using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Runtime.InteropServices;
using System.Data.SqlClient;
using System.Collections;
using System.IO;
using com.force.json;
using System.Net;
using System.Net.NetworkInformation;
using Oracle.ManagedDataAccess.Client;

namespace WCS
{
    public class Common
    {
        /// <summary>
        /// 系统路径
        /// </summary>
        public static string filepath = System.Reflection.Assembly.GetExecutingAssembly().Location;
        //public static string exepath = Application.ExecutablePath;
        //public static string path = filepath.Substring(0, filepath.LastIndexOf('\\'));

        /// <summary>
        /// 系统配置文件
        /// </summary>
        public static string sysinipath = filepath.Substring(0, filepath.LastIndexOf('\\')) + "\\System.ini";
        //public static string cmdinipath = filepath.Substring(0, filepath.LastIndexOf('\\')) + "\\Command.ini";
        //public static string inipath = filepath.Substring(0, filepath.LastIndexOf('\\')) + "\\labels\\";
        //public static string pbdpath = filepath.Substring(0, filepath.LastIndexOf('\\')) + "\\report.pbd";

        /// <summary>
        /// 公司名称
        /// </summary>
        public static string gs_companyName = "";

        /// <summary>
        /// 系统图片路径
        /// </summary>
        public static string picpath = filepath.Substring(0, filepath.LastIndexOf('\\')) + "\\image\\";

        /// <summary>
        /// 系统信号，弹出提示框后根据选择传值回主窗口,后期考虑窗口间传参
        /// </summary>
        public static bool sysinfo = false;
        //public static bool logout = false;
        //public static bool sameinfo = false;

        /// <summary>
        /// ASRS数据库连接字符串
        /// </summary>
        public static string sqlcon = "Initial Catalog=klsasrs2;Persist Security Info=True;User ID=sa;Password=sa@123;";
        //public static string sqlcon = "Initial Catalog=jsasrs;Persist Security Info=True;User ID=;Password=klsasrs@zy;";

        /// <summary>
        /// ERP数据库连接字符串
        /// </summary>
        public static string erpcon = "Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=dm01db01-vip.dssyebs.com)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME = PROD)));User Id=HSTORE;Password=HSTORE;";

        /// <summary>
        /// 数据库服务器IP
        /// </summary>
        public static string serverIp = "127.0.0.1";

        /// <summary>
        /// WMS接口
        /// </summary>
        public static string HttpUrl = "";

        //public static string servername = ".";
        //public static string login = "asrs";
        //public static string psw = "asrs";
        //public static int crnwriteadd = 80;
        /// <summary>
        /// 定义FORM窗体f1
        /// </summary>
        public static Form f1 = null;

        /// <summary>
        /// 堆垛机数量
        /// </summary>
        public static int ci_crn_count = 3;
        /// <summary>
        /// 站点数量
        /// </summary>
        public static int ci_sta_count = 36;
        /// <summary>
        /// PLC数量
        /// </summary>
        public static int ci_plc_count = 1;
        /// <summary>
        /// 磅秤数量
        /// </summary>
        public static int ci_scale_count = 1;
        /// <summary>
        /// 条码扫描器数量
        /// </summary>
        public static int ci_barcode_count = 1;
        /// <summary>
        /// LED显示屏
        /// </summary>
        public static int ci_led_count = 5;

        /// <summary>
        /// 台车数量
        /// </summary>
        public static int ci_rgv_count = 0;

        /// <summary>
        /// WCS服务器Socket IP
        /// </summary>
        public static string gs_wcs_ip = "";
        /// <summary>
        /// WCS服务器Socket端口
        /// </summary>
        public static int gs_wcs_port = 10001;

        //public static int ci_plc_error_count = 7;// 91;

        /// <summary>
        /// 站点错误数
        /// </summary>
        public static int ci_plcerrcount = 100;
        public static string[] plcerr;// = new string[ci_plcerrcount];
        public static string[] gs_PlcErrDesc;// = new string[ci_plcerrcount];
        //public static int ci_plcerrrecord = 30;
        //public static int[] gi_plc_err = new int[ci_plcerrrecord];
        /// <summary>
        /// S7写数据到西门子PLC互锁标志，同一时间只允许一个写入
        /// </summary>
        public static bool writeFlag = true;

        /// <summary>
        /// 磅秤重量上限
        /// </summary>
        public static double ci_scale_maxwt = 1000;
        /// <summary>
        /// 磅秤重量下限
        /// </summary>
        public static double ci_scale_minwt = 30;

        /// <summary>
        /// 堆垛机入库站站点编号数组
        /// </summary>
        public static int[] crn_inStns = new int[8] { 104,106,117,120,124,131,133,136 };

        /// <summary>
        /// 堆垛机出库站站点编号数组
        /// </summary>
        public static int[] crn_outStns = new int[4] { 101,110, 113,127 };

        //public static bool[] plctag = new bool[2];
        //public static bool[] stasts = new bool[16];
        //public static bool[] stasts1 = new bool[4];
        //public static int[] gi_wrkno_pick = new int[5];
        //public static string[] gi_sts=new string[4];

        #region 常量定义区
        //堆垛机内部状态参数状态字
        public static long ch_crn_sdms = 1;         //手动模式
        public static long ch_crn_zdms = 2;         //自动模式
        public static long ch_crn_dnms = 4;         //电脑模式
        public static long ch_crn_sdz = 8;          //手动中
        public static long ch_crn_zdz = 16;         //自动中
        public static long ch_crn_dnmsz = 32;       //电脑模式中
        public static long ch_crn_jt = 64;          //急停
        public static long ch_crn_yc = 128;         //异常
        public static long ch_crn_dndmz = 256;      //电脑待命中
        public static long ch_crn_dnmljs = 512;     //电脑命令正确接收
        public static long ch_crn_rkz = 1024;       //入库中
        public static long ch_crn_ckz = 2048;       //出库中
        public static long ch_crn_kdkz = 4096;      //库对库中
        public static long ch_crn_zdzz = 8192;      //站对站中
        public static long ch_crn_yxz = 16384;      //移行中
        public static long ch_crn_dcqhjd = 32768;   //堆垛机取货阶段

        // {CRN STATUS2}
        public static long ch_crn_dcfhjd = 1;       //堆垛机放货阶段
        public static long ch_crn_dckx = 2;         //堆垛机空闲
        public static long ch_crn_zxyddw = 4;       //走行原点定位
        public static long ch_crn_sjyddw = 8;       //升降原点定位
        public static long ch_crn_zxzdw = 16;       //走行在定位
        public static long ch_crn_cyzzj = 32;       //叉牙在中间
        public static long ch_crn_cyzzd = 64;       //叉牙在左端
        public static long ch_crn_cyzyd = 128;      //叉牙在右端
        public static long ch_crn_sjsdw = 256;      //升降上定位
        public static long ch_crn_sjxdw = 512;      //升降下定位
        public static long ch_crn_plcdlbz = 1024;   //plc电力不足
        public static long ch_crn_sjtycyw = 2048;   //升降台有物        

        //public static bool[] gl_crn_status = new bool[ci_crn_count];

        //plc状态字
        public static int ch_d1 = 1;
        public static int ch_d2 = 2;
        public static int ch_d3 = 4;
        public static int ch_d4 = 8;
        public static int ch_d5 = 16;
        public static int ch_d6 = 32;
        public static int ch_d7 = 64;
        public static int ch_d8 = 128;
        public static int ch_d9 = 256;
        public static int ch_d10 = 512;
        public static long ch_d11 = 1024;
        public static long ch_d12 = 2048;
        public static long ch_d13 = 4096;
        public static long ch_d14 = 8192;
        public static long ch_d15 = 16384;
        public static long ch_d16 = 32768;

        //堆垛机工作模式
        /// <summary>
        /// 手动模式
        /// </summary>
        public static int ci_CRN_MANUAL = 1;
        /// <summary>
        /// 自动模式
        /// </summary>
        public static int ci_CRN_AUTO = 2;
        /// <summary>
        /// 连线模式
        /// </summary>
        public static int ci_CRN_ONLINE = 3;

        //堆垛机io状态
        public static int ci_CRN_LINK = 1;
        public static int ci_CRN_RESET = 2;
        public static int ci_CRN_CLEAR = 3;
        public static int ci_CRN_HOME = 4;
        public static int ci_CRN_STN = 5;
        public static int ci_CRN_SHELF = 6;
        public static int ci_CRN_INQUIRY = 7;
        public static int ci_CRN_STORE = 7;
        public static int ci_CRN_RETRIEVE = 8;
        public static int ci_CRN_MOVE = 10;
        public static int ci_CRN_STNTOSTN = 11;
        public static int ci_CRN_LOCTOLOC = 12;

        //堆垛机状态
        /// <summary>
        /// 初始化
        /// </summary>
        public static int ci_CRN_STS_INIT = -1;
        /// <summary>
        /// 空闲，无任务
        /// </summary>
        public static int ci_CRN_STS_IDLE = 0;
        /// <summary>
        /// 取货定位中
        /// </summary>
        public static int ci_CRN_STS_FETCH_MOVING = 1;
        /// <summary>
        /// 取货中
        /// </summary>
        public static int ci_CRN_STS_FETCH = 2;
        /// <summary>
        /// 取货完成，放货定位中
        /// </summary>
        public static int ci_CRN_STS_RELEASE_MOVING = 3;
        /// <summary>
        /// 放货中
        /// </summary>
        public static int ci_CRN_STS_RELEASE = 4;
        /// <summary>
        /// 回原点中
        /// </summary>
        public static int ci_CRN_STS_HP = 5;
        /// <summary>
        /// 去反原点中
        /// </summary>
        public static int ci_CRN_STS_OHP = 6;
        /// <summary>
        /// 库位移转中
        /// </summary>
        public static int ci_CRN_STS_LOC_MOVE = 7;
        /// <summary>
        /// 任务完成，等待WCS确认
        /// </summary>
        public static int ci_CRN_STS_TASK_FINISH = 90;

        //public static int ci_CRN_SETTING = 0;
        //public static int ci_CRN_STS_IDLE = 1;
        public static int ci_CRN_STS_STORE_MOVE = 2; //{ STORE COMMAND }
        public static int ci_CRN_STS_RETRIEVE_MOVE = 3; //{ RETRIEVE COMMAND }
        public static int ci_CRN_STS_MOVING = 4; //{ MOVE COMMAND }
        public static int ci_CRN_STS_STORE_OK = 5;
        public static int ci_CRN_STS_RETRIEVE_OK = 6;
        public static int ci_CRN_STS_MOVING_OK = 7;
        public static int ci_CRN_STS_ERROR = 8;
        public static int ci_CRN_STS_ERROR_IDLE = 9;
        //public static int ci_CRN_STS_OHP = 10;
        public static int ci_CRN_STS_STOP = 11;
        public static int ci_CRN_STS_STNCHG_MOVE = 12;
        public static int ci_CRN_STS_STNCHG_OK = 13;
        public static int ci_CRN_STS_LOCATION_MOVE = 14;
        public static int ci_CRN_STS_LOCATION_MOVE_OK = 16;
        public static int ci_CRN_STS_HP_POSITION = 15; ///20061007

        //工作状态
        public static int ci_WRK_STORE_SETDATA = 1;
        public static int ci_WRK_STORE_SETPLC = 2;
        public static int ci_WRK_STORE_SETCRN = 3;
        public static int ci_WRK_STORE_OK = 4;
        public static int ci_WRK_STORE_UPDDB = 5;
        public static int ci_WRK_STORE_exit = 6;
        public static int ci_WRK_STNMOVE_OK = 7;

        public static int ci_WRK_RETRIEVE_SETDATA = 11;
        public static int ci_WRK_RETRIEVE_SETCRN = 12;
        public static int ci_WRK_RETRIEVE_OK = 14;
        public static int ci_WRK_RETRIEVE_UPDDB = 15;

        public static int ci_plc_MAX = 10;          //PLC最大队列数

        //plc工作命令类型
        public static int ci_PLC_SETID = 1;
        public static int ci_PLC_SETDEST = 2;
        public static int ci_PLC_SETIDDEST = 3;

        //COMUCATION I/O BUFFER SIZE
        public static int ci_crn_MAXBUFSIZE = 4096;
        public static int ci_barcode_MAXBUFSIZE = 4096;
        //public static int ci_MAXINCOUNT = 35;
        //public static int ci_MAXOUTCOUNT = 50;

        /// <summary>
        /// CRANE SLEEP TIME
        /// </summary>
        public static int ci_CRNtimeInterval = 300;
        /// <summary>
        /// PLC SLEEP TIME
        /// </summary>
        public static int ci_PLCtimeInterval = 300;
        /// <summary>
        /// Barcode Scanner SLEEP TIME
        /// </summary>
        public static int ci_BarcodetimeInterval = 200;
        /// <summary>
        /// LED SLEEP TIME
        /// </summary>
        public static int ci_LedtimeInterval = 200;

        /// <summary>
        /// 系统运行中
        /// </summary>
        public static int ch_CMD_START = 1;
        /// <summary>
        /// 系统暂停中
        /// </summary>
        public static int ch_CMD_PAUSE = 10;
        /// <summary>
        /// 系统关闭中
        /// </summary>
        public static int ch_CMD_CLOSE = 100;
        #endregion

        //-------------------------------------------------------------变量定义---------------------------------------------------------------------------
        /// <summary>
        /// 下发堆垛机命令后，等待一个周期，再判断堆垛机是否空闲
        /// </summary>
        public static int gi_cycle_flag = 0;

        /// <summary>
        /// 堆垛机IP
        /// </summary>
        public static string[] gs_crn_ip = new string[ci_crn_count];
        /// <summary>
        /// PLC输送设备IP
        /// </summary>
        public static string[] gs_plc_ip = new string[ci_plc_count];
        /// <summary>
        /// 磅秤端口号，串口
        /// </summary>
        public static int[] gi_scale_port = new int[ci_scale_count];
        /// <summary>
        /// 磅秤设备IP
        /// </summary>
        public static string[] gs_scale_ip = new string[ci_scale_count];
        /// <summary>
        /// 条码设备串口端口
        /// </summary>
        public static int[] gs_barcode_port = new int[ci_barcode_count];
        /// <summary>
        /// 条码设备IP
        /// </summary>
        public static string[] gs_barcode_ip = new string[ci_barcode_count];
        /// <summary>
        /// 条码设备IP
        /// </summary>
        public static string[] gs_led_ip = new string[ci_led_count];
        /// <summary>
        /// 磅秤称重数据
        /// </summary>
        public static double[] gd_gross_wt = new double[ci_scale_count];
        /// <summary>
        /// 条码扫描数据
        /// </summary>
        public static string[] gs_barcode_data = new string[ci_barcode_count];
        /// <summary>
        /// LED待发送数据
        /// </summary>
        public static string[] gs_led_data = new string[ci_led_count];
        public static string[] gs_led_data_pre = new string[ci_led_count];

        ///// <summary>
        ///// LED页数
        ///// </summary>
        //public static int[] gi_led_Pages = new int[ci_led_count];

        /// <summary>
        /// LED页码
        /// </summary>
        public static int[] gi_led_PageNumber = new int[ci_led_count];

        /// <summary>
        /// LED显示当前页码
        /// </summary>
        public static int[] gi_led_CurPageNumber = new int[ci_led_count];

        /// <summary>
        /// LED显示循环次数
        /// </summary>
        public static int[] gi_led_Counts = new int[ci_led_count];

        ///// <summary>
        ///// LED显示效果
        ///// </summary>
        //public static int[] gi_led_ShowStyle = new int[ci_led_count];

        /// <summary>
        /// 台车位置
        /// </summary>
        public static int[] gi_RGVPos = new int[ci_rgv_count];

        /// <summary>
        /// 扫描超时时间判断
        /// </summary>
        public static double gd_scanTimeout = 4;

        ///// <summary>
        ///// PLC工作模式，0--入库，1--出库
        ///// </summary>
        //public static int gi_PLCModel = 0;
        ///// <summary>
        ///// PLC手工完成出库信号，工作档将12->14
        ///// </summary>
        //public static int gi_PLCClear = 0;

        /// <summary>
        /// 1号站条码扫描判断有没有扫到，计时判断
        /// </summary>
        public static DateTime barcodeTime = DateTime.Now;
        public static int barcodeFlag = 0;
        //public static string gs_barcode = "";

        #region LED参数
        /// <summary>
        /// 显示屏宽度
        /// </summary>
        public static int SCREEN_WIDTH = 96;
        /// <summary>
        /// 显示屏高度
        /// </summary>
        public static int SCREEN_HEIGHT = 48;
        public static int CONTROLLER_TYPE = 850;                        //控制器类型
        public static int SCREEN_TYPE = 1;                              //显示屏类型
        public static int SCREEN_PIXELMODE = 1;                         //点阵类型
        public static int SCREEN_DATADA = 0;                            //数据极性
        public static int SCREEN_DATAOE = 0;                            //OE极性
        public static int SCREEN_ROWORDER = 0;                          //行序模式
        public static int SCREEN_FREQPAR = 0;                           //扫描点频        

        public static string SCREEN_COMM = "COM1";                      //串口
        public static int SCREEN_BAUD = 57600;                          //串口波特率
        public static string SCREEN_STATUSFILE = "C:\\ScreenStatus.ini";  //显示屏状态保存文件

        public static int SCREEN_SENDMODE = 2;                          //通讯模式,0:串口 2:网络 4:wifi
        public const int SENDALLPROGRAM = 41456;                        //发送所有节目信息。
        /// <summary>
        /// 发送数据给控制卡时互斥作用，每次只能发送一条过去
        /// </summary>
        public static bool m_bSendBusy = false;
        #endregion

        //public static string barrec = "";        
        public static int[] areamode = new int[4];
        //public static bool insesheettag = false;
        //public static string[] gs_barcode_tmp = new string[5];
        public static string[] crncmd = new string[ci_crn_count];
        public static int[] crnwrkno = new int[ci_crn_count];
        //public static int[] pickquereseq = new int[12];
        //public static int bk = 1;

        public static Form form1 = null;
        public static Form form2 = null;
        //public static bool stnmove = true;
        //public static bool crnmove = true;
        //public static bool crnallow = true;

        public static int gi_Online_Flag = 10;
        public static bool[] gb_crn_status = new bool[ci_crn_count];
        //public static int gi_wrkfileh = 0;
        public static string[] gs_crnlastio = new string[ci_crn_count];
        public static int[] gi_crnstn = new int[ci_crn_count];
        public static string[] gs_crn_data_pre = new string[ci_crn_count];
        public static int[] gi_crn_wrkno = new int[ci_crn_count];
        public static string[] gs_crn_err_pre = new string[ci_crn_count];
        //public static int[] clrled = new int[10];
        public static int gi_buffer_count = 16;
        public static int gi_trolleypos_count = 2;
        //public static int[] stnbuffer = new int[gi_buffer_count];//
        public static int[] trolleypos = new int[gi_trolleypos_count];//2个，14，29
        //public static int[] ci_stnbuffer = new int[gi_buffer_count];
        public static int[] gi_stabuffer = new int[gi_buffer_count];
        //public static int[] gi_crn_actsts = new int[ci_crn_count];
        public static int[] gi_stn_iotype = new int[ci_sta_count];

        public static int[] g_ari_staion = new int[ci_sta_count];
        public static string[] g_ars_staion_name = new string[ci_sta_count];
        public static int[] g_ari_staion_plc_no = new int[ci_sta_count];
        public static Control[] g_ari_staion_Component_seq = new Control[ci_sta_count];
        public static int[] g_ari_station_idaddr = new int[ci_sta_count];
        public static int[] g_ari_station_stsaddr = new int[ci_sta_count];
        public static int[] g_ari_station_destaddr = new int[ci_sta_count];
        public static string[] gs_plc_data_pre = new string[ci_sta_count];
        public static int[] gi_crn_iotype = new int[ci_crn_count];
        public static int[] gi_loctype = new int[ci_sta_count];

        //堆垛机变量
        //public static string[,] crnstsvalue = new string[ci_crn_count, 33];
        public static string[] crnerrlist = new string[ci_crn_count];
        //public static string[] crnip = new string[ci_crn_count];

        public static int[] crn_i_crnno = new int[ci_crn_count];
        public static int[] crn_i_crn_sts = new int[ci_crn_count];

        /// <summary>
        /// 堆垛机命令
        /// </summary>
        public static string[] gs_crncmd = new string[ci_crn_count];
        public static string[] crn_s_commandstr = new string[ci_crn_count];
        public static int[] crn_i_kind = new int[ci_crn_count];
        public static int[] crn_i_Wrkno = new int[ci_crn_count];
        public static int[] crn_i_fstn = new int[ci_crn_count];
        public static int[] crn_i_tstn = new int[ci_crn_count];
        public static string[] crn_s_Flocno = new string[ci_crn_count];
        public static string[] crn_s_Tlocno = new string[ci_crn_count];
        public static int[] crn_i_Errcod = new int[ci_crn_count];
        public static bool[] gi_Yanshi_Flag = new bool[ci_crn_count];
        /// <summary>
        /// 是否在原点，1=原点
        /// </summary>
        public static int[] crn_i_onHP = new int[ci_crn_count];

        ////////////////////---------------------------堆垛机变量表--------------------------
        #region 堆垛机(CRN)状态信息
        /// <summary>
        /// 堆垛机工作模式，0 = 离线模式，1=手动模式中，2=自动模式中,3=电脑连线模式中
        /// </summary>
        public static int[] Mode = new int[ci_crn_count];

        /// <summary>
        /// 堆垛机当前任务号
        /// </summary>
        public static int[] TaskNo = new int[ci_crn_count];

        /// <summary>
        /// SRM工位1当前任务执行状态，0=空闲，1=取货定位中，2=取货中，3=取货完成，放货定位中，
        /// 4=放货中，5=回原点中，6=去反原点中，7=库位移转，90=任务完成,WCS未确认，99=报警
        /// </summary>
        public static int[] CrnState = new int[ci_crn_count];

        ///// <summary>
        ///// 堆垛机当前列号
        ///// </summary>
        //public static int[] CurBay = new int[ci_crn_count];

        ///// <summary>
        ///// 堆垛机当前层号
        ///// </summary>
        //public static int[] CurLev = new int[ci_crn_count];

        /// <summary>
        /// 堆垛机当前货叉位置，0=货叉原位，1=货叉在左侧，2=货叉在右侧
        /// </summary>
        public static int[] ForkPos = new int[ci_crn_count];

        /// <summary>
        /// 堆垛机当前载货台定位位置，1=下定位，2=上定位，0=不在定位
        /// </summary>
        public static int[] LiftPos = new int[ci_crn_count];

        /// <summary>
        /// 堆垛机走行定位位置，1=在定位，0=不在定位
        /// </summary>
        public static int[] WalkPos = new int[ci_crn_count];

        /// <summary>
        /// =1 堆垛机任务完成信号
        /// </summary>
        public static int[] TaskFinish = new int[ci_crn_count];

        /// <summary>
        /// SRM工位1任务完成处理标记,防止重复处理。默认为0，timer1根据F1TaskFinish处理工作档状态后赋值1
        /// 堆垛机线程中下发确认信息后，重置为0
        /// </summary>
        public static int[] TaskFlag = new int[ci_crn_count];

        /// <summary>
        /// =1 堆垛机载货台有货
        /// </summary>
        public static int[] Loaded = new int[ci_crn_count];

        /// <summary>
        /// 堆垛机异常码
        /// </summary>
        public static int[] AlarmCode = new int[ci_crn_count];

        /// <summary>
        /// 堆垛机走行速度(m/min)
        /// </summary>
        public static float[] WalkSpeed = new float[ci_crn_count];

        /// <summary>
        /// 堆垛机升降速度(m/min)
        /// </summary>
        public static float[] LiftSpeed = new float[ci_crn_count];

        /// <summary>
        /// 堆垛机叉牙速度(m/min)
        /// </summary>
        public static float[] ForkSpeed = new float[ci_crn_count];

        /// <summary>
        /// 堆垛机累计走行距离(km)
        /// </summary>
        public static float[] XDistance = new float[ci_crn_count];

        /// <summary>
        /// 堆垛机累计升降距离(km)
        /// </summary>
        public static float[] YDistance = new float[ci_crn_count];

        /// <summary>
        /// 堆垛机累计走行时长(H)
        /// </summary>
        public static float[] XDuration = new float[ci_crn_count];

        /// <summary>
        /// 堆垛机累计升降时长(H)
        /// </summary>
        public static float[] YDuration = new float[ci_crn_count];

        ///// <summary>
        ///// 1=SRM处于报警状态
        ///// </summary>
        //public static int[] AlarmStatus = new int[ci_crn_count];


        ///// <summary>
        ///// SRM工位1当前货叉位置，[1：左近，2：中位，3：右近,4：左远，5：右远]
        ///// </summary>
        //public static int[] F1PosZ = new int[ci_crn_count];

        ///// <summary>
        ///// SRM当前列坐标，单位mm
        ///// </summary>
        //public static double[] PosXmm = new double[ci_crn_count];

        ///// <summary>
        ///// SRM当前层坐标，单位mm
        ///// </summary>
        //public static double[] PosYmm = new double[ci_crn_count];

        ///// <summary>
        ///// SRM工位1当前货叉坐标，单位mm
        ///// </summary>
        //public static double[] F1PosZmm = new double[ci_crn_count];

        ///// <summary>
        ///// SRM工位2当前任务执行状态，0=位置，1=空闲，2=检查任务数据，3=定位到取货位，7=取货完成，
        ///// 8=等待调度柜允许，9=移动到放货位置，10=放货中，13=搬运完成，14=空载避让，15=检查任务数据
        ///// 20=检查源位置，21=检查目标位置，50=移动任务，98=任务完成,WCS未确认，99=报警
        ///// </summary>
        //public static int[] F2State = new int[ci_crn_count];

        #endregion

        #region 堆垛机状态字定义
        /// <summary>
        /// 手动模式
        /// </summary>
        public static bool[] crn_sdms = new bool[ci_crn_count];
        /// <summary>
        /// 自动模式
        /// </summary>
        public static bool[] crn_zdms = new bool[ci_crn_count];
        /// <summary>
        /// 电脑模式
        /// </summary>
        public static bool[] crn_dnms = new bool[ci_crn_count];
        /// <summary>
        /// 手动中
        /// </summary>
        public static bool[] crn_sdz = new bool[ci_crn_count];
        /// <summary>
        /// 自动中
        /// </summary>
        public static bool[] crn_zdz = new bool[ci_crn_count];
        /// <summary>
        /// 电脑模式中
        /// </summary>
        public static bool[] crn_dnmsz = new bool[ci_crn_count];
        /// <summary>
        /// 急停
        /// </summary>
        public static bool[] crn_jt = new bool[ci_crn_count];
        /// <summary>
        /// 异常
        /// </summary>
        public static bool[] crn_yc = new bool[ci_crn_count];
        /// <summary>
        /// 保留
        /// </summary>
        public static bool[] crn_dndmz = new bool[ci_crn_count];
        /// <summary>
        /// 任务完成
        /// </summary>
        public static bool[] crn_dnmljs = new bool[ci_crn_count];
        /// <summary>
        /// 入库中
        /// </summary>
        public static bool[] crn_rkz = new bool[ci_crn_count];
        /// <summary>
        /// 出库中
        /// </summary>
        public static bool[] crn_ckz = new bool[ci_crn_count];
        /// <summary>
        /// 库到库
        /// </summary>
        public static bool[] crn_kdkz = new bool[ci_crn_count];
        /// <summary>
        /// 站到站
        /// </summary>
        public static bool[] crn_zdzz = new bool[ci_crn_count];
        /// <summary>
        /// 去原点
        /// </summary>
        public static bool[] crn_yxz = new bool[ci_crn_count];
        /// <summary>
        /// 去反原点
        /// </summary>
        public static bool[] crn_dcqhjd = new bool[ci_crn_count];
        /// <summary>
        /// 放货阶段
        /// </summary>
        public static bool[] crn_dcfhjd = new bool[ci_crn_count];
        /// <summary>
        /// 吊车空闲
        /// </summary>
        public static bool[] crn_dckx = new bool[ci_crn_count];
        /// <summary>
        /// 走行原点定位
        /// </summary>
        public static bool[] crn_zxyddw = new bool[ci_crn_count];
        /// <summary>
        /// 升降原点定位
        /// </summary>
        public static bool[] crn_sjyddw = new bool[ci_crn_count];
        /// <summary>
        /// 走行在定位
        /// </summary>
        public static bool[] crn_zxzdw = new bool[ci_crn_count];
        /// <summary>
        /// 叉牙在中间
        /// </summary>
        public static bool[] crn_cyzzj = new bool[ci_crn_count];
        /// <summary>
        /// 叉牙在左端
        /// </summary>
        public static bool[] crn_cyzzd = new bool[ci_crn_count];
        /// <summary>
        /// 叉牙在右端
        /// </summary>
        public static bool[] crn_cyzyd = new bool[ci_crn_count];
        /// <summary>
        /// 升降上定位
        /// </summary>
        public static bool[] crn_sjsdw = new bool[ci_crn_count];
        /// <summary>
        /// 升降下定位
        /// </summary>
        public static bool[] crn_sjxdw = new bool[ci_crn_count];
        /// <summary>
        /// 保留
        /// </summary>
        public static bool[] crn_plcdlbz = new bool[ci_crn_count];
        /// <summary>
        /// 升降台有物
        /// </summary>
        public static bool[] crn_sjtycyw = new bool[ci_crn_count];
        /// <summary>
        /// 当前排数
        /// </summary>
        public static int[] crn_dqps = new int[ci_crn_count];
        /// <summary>
        /// 当前层数
        /// </summary>
        public static int[] crn_dqcs = new int[ci_crn_count];
        /// <summary>
        /// 走行镭射距离
        /// </summary>
        public static double[] crn_zxlsz = new double[ci_crn_count];
        /// <summary>
        /// 升降镭射距离
        /// </summary>
        public static double[] crn_sjlsz = new double[ci_crn_count];
        public static int[] crn_dnmlyc = new int[ci_crn_count];
        /// <summary>
        /// 设备异常码
        /// </summary>
        public static int[] crn_ycmm = new int[ci_crn_count];
        public static int[] crn_yczm = new int[ci_crn_count];

        //public static int[] crn_zxlsz1 = new int[ci_crn_count];
        //public static int[] crn_zxlsz2 = new int[ci_crn_count];
        //public static int[] crn_sjlsz1 = new int[ci_crn_count];
        //public static int[] crn_sjlsz2 = new int[ci_crn_count];
        #endregion

        public static string[] crncmdtext = new string[ci_crn_count];
        //定义plc变量
        //public struct sta
        //{
        public static int PlcMaxQuereCount = 10;//plc最大队列存储数量
        public static string[,] s_cmd = new string[4, PlcMaxQuereCount];
        //public static Queue<string> PlcAQueue = new Queue<string>();
        //public static Queue<string> PlcBQueue = new Queue<string>();

        public static string[,] plc_s_dev_no = new string[ci_plc_count, ci_sta_count];
        public static string[,] plc_s_type_mk = new string[ci_plc_count, ci_sta_count];
        public static string[,] plc_s_term_mk = new string[ci_plc_count, ci_sta_count];
        public static int[,] plc_i_status = new int[ci_plc_count, ci_sta_count];
        public static int[,] plc_i_plc_no = new int[ci_plc_count, ci_sta_count];
        public static int[,] plc_i_Wrk_no = new int[ci_plc_count, ci_sta_count];
        public static int[,] plc_i_ctn_type = new int[ci_plc_count, ci_sta_count];
        public static int[,] plc_i_pakmk = new int[ci_plc_count, ci_sta_count];
        public static int[,] plc_i_buff_count = new int[ci_plc_count, ci_sta_count];
        public static string[,] plc_s_stn_status = new string[ci_plc_count, ci_sta_count];
        public static string[,] plc_s_from_stn = new string[ci_plc_count, ci_sta_count];
        public static string[,] plc_s_next_stn = new string[ci_plc_count, ci_sta_count];
        public static string[,] plc_s_t_station = new string[ci_plc_count, ci_sta_count];
        public static string[,] plc_s_autoing = new string[ci_plc_count, ci_sta_count];
        public static string[,] plc_s_loading = new string[ci_plc_count, ci_sta_count];
        /// <summary>
        /// 可入
        /// </summary>
        public static string[,] plc_s_canining = new string[ci_plc_count, ci_sta_count];
        /// <summary>
        /// 可出
        /// </summary>
        public static string[,] plc_s_canouting = new string[ci_plc_count, ci_sta_count];
        /// <summary>
        /// 空板信号
        /// </summary>
        public static string[,] plc_s_inreq1 = new string[ci_plc_count, ci_sta_count];
        /// <summary>
        /// 满托信号
        /// </summary>
        public static string[,] plc_s_inreq2 = new string[ci_plc_count, ci_sta_count];
        /// <summary>
        /// 货物类型
        /// </summary>
        public static string[,] plc_s_loctype = new string[ci_plc_count, ci_sta_count];
        /// <summary>
        /// 报警
        /// </summary>
        public static string[,] plc_s_error = new string[ci_plc_count, ci_sta_count];
        public static string[,] plc_s_modeallow = new string[ci_plc_count, ci_sta_count];

        //public static string[] s_plc_err_count1 = new string[ci_plcerrcount];
        //public static string[] s_plc_err_count2 = new string[ci_plcerrcount];

        //public struct fieldds//字段描述
        //{
        //    public int index;
        //    public string dataname;
        //    public string datadesc;
        //}


        //public Common()
        //{
        //}

        //public static string Proc_GetNum(string str)
        //{
        //    string result = "";
        //    try
        //    {
        //        for (int i = 0; i < str.Length; i++)
        //        {
        //            if (str[i] == '0' || str[i] == '1' || str[i] == '2' || str[i] == '3' || str[i] == '4' || str[i] == '6' || str[i] == '7' || str[i] == '8' || str[i] == '9')
        //            {
        //                result = result.Trim() + str[i];
        //            }
        //        }
        //    }
        //    catch (Exception t)
        //    {

        //    }
        //    return result;
        //}

        /// <summary>
        /// 增加plc命令队列
        /// </summary>
        /// <param name="plcno">plc号</param>
        /// <param name="cmd">指令</param>
        public static void AddPlcQuereCmd(int plcno, string cmd)
        {
            if (cmd == "") { return; };
            for (int j = PlcMaxQuereCount - 1; j >= 0; j--)
            {
                if (s_cmd[plcno, j] == "" || s_cmd[plcno, j] == null)
                {
                    s_cmd[plcno, j] = cmd;
                    break;
                }
            }
            AdjPlcQuere(plcno);
        }

        /// <summary>
        /// 得到plc指令队列的数量
        /// </summary>
        /// <param name="plcno">plc号</param>
        /// <returns>队列的数量</returns>
        public static int GetPlcQuereCount(int plcno)
        {
            int count = 0;
            for (int i = 0; i < ci_plc_MAX; i++)
            {
                if (s_cmd[plcno, i] != "" && s_cmd[plcno, i] != null)
                {
                    count++;
                }
            }
            return count;
        }

        /// <summary>
        /// 从plc队列中取最先进的一笔指令
        /// </summary>
        /// <param name="plcno">plc号</param>
        /// <returns>对应最先进的指令</returns>
        public static string GetPlcQuereCmd(int plcno)
        {
            string cmd = "";
            for (int i = 0; i < PlcMaxQuereCount; i++)
            {
                if (s_cmd[plcno, i] != "" && s_cmd[plcno, i] != null)
                {
                    cmd = s_cmd[plcno, i];
                    s_cmd[plcno, i] = "";
                    break;
                }
            }
            AdjPlcQuere(plcno);
            return cmd;
        }

        /// <summary>
        /// 调整队列存储
        /// </summary>
        /// <param name="plcno">plc号</param>
        public static void AdjPlcQuere(int plcno)
        {
            string s_tmep1 = "", s_tmep2 = "";
            for (int j = PlcMaxQuereCount - 1; j >= 0; j--)
            {
                s_tmep1 = s_cmd[plcno, j];
                if (j > 0)
                {
                    s_tmep2 = s_cmd[plcno, j - 1];
                    if (s_tmep1 != "" && s_tmep2 == "")
                    {
                        s_cmd[plcno, j - 1] = s_tmep1;
                        s_cmd[plcno, j] = "";
                    }
                }
            }
        }

        /// <summary>
        /// 根据堆垛机状态值得到状态名称
        /// </summary>
        /// <param name="i_sts">堆垛机状态值</param>
        /// <returns>堆垛机状态</returns>
        public static string GetCrnStsName(int i_sts)
        {
            string crnstsname = "";
            switch (i_sts)
            {
                case -1:
                    crnstsname = "初始化";
                    break;
                case 0:
                    crnstsname = "空闲";
                    break;
                case 1:
                    crnstsname = "取货定位中";
                    break;
                case 2:
                    crnstsname = "取货中";
                    break;
                case 3:
                    crnstsname = "取货完成，放货定位中";
                    break;
                case 4:
                    crnstsname = "放货中";
                    break;
                case 5:
                    crnstsname = "回原点中";
                    break;
                case 6:
                    crnstsname = "去反原点中";
                    break;
                case 7:
                    crnstsname = "库位移转";
                    break;
                case 90:
                    crnstsname = "任务完成，WCS未确认";
                    break;
                case 99:
                    crnstsname = "报警";
                    break;
                default:
                    crnstsname = "未知";
                    break;
            }
            return crnstsname;
        }

        /// <summary>
        /// 站点初始化，PLC读写地址定义
        /// </summary>
        public static void InitSta()
        {
            int i;
            for (i = 1; i <= ci_sta_count; i++)
            {
                    //站点号
                    g_ari_staion[i - 1] = i + 100;
                    g_ars_staion_name[i - 1] = (i + 100).ToString();
                    g_ari_staion_plc_no[i - 1] = 1;
                    //工作号  目标库位  状态
                    g_ari_station_idaddr[i - 1] = (i - 1) * 4;    //工作号地址
                    g_ari_station_destaddr[i - 1] = (i - 1) * 4 + 2;      //目标站地址
                    g_ari_station_stsaddr[i - 1] = i + 149;    //状态位地址

                //else if (i > 5 && i <= 10)
                //{
                //    g_ari_staion[i - 1] = i + 194;
                //    g_ars_staion_name[i - 1] = (i + 194).ToString();
                //    g_ari_staion_plc_no[i - 1] = 1;

                //    g_ari_station_idaddr[i - 1] = (i - 1) * 4;
                //    g_ari_station_destaddr[i - 1] = (i - 1) * 4 + 2;
                //    g_ari_station_stsaddr[i - 1] = i + 59;
                //}
              
                //初始化站点中各个值的数据。
                plc_s_dev_no[g_ari_staion_plc_no[i - 1] - 1, i - 1] = g_ari_staion[i - 1].ToString();
                plc_s_autoing[g_ari_staion_plc_no[i - 1] - 1, i - 1] = "N";
                plc_s_loading[g_ari_staion_plc_no[i - 1] - 1, i - 1] = "N";
                plc_s_canining[g_ari_staion_plc_no[i - 1] - 1, i - 1] = "N";
                plc_s_canouting[g_ari_staion_plc_no[i - 1] - 1, i - 1] = "N";
                plc_s_inreq1[g_ari_staion_plc_no[i - 1] - 1, i - 1] = "N";
                plc_s_inreq2[g_ari_staion_plc_no[i - 1] - 1, i - 1] = "N";
                plc_s_loctype[g_ari_staion_plc_no[i - 1] - 1, i - 1] = "N";
                plc_s_error[g_ari_staion_plc_no[i - 1] - 1, i - 1] = "N";
                plc_i_buff_count[g_ari_staion_plc_no[i - 1] - 1, i - 1] = 0;
                plc_i_Wrk_no[g_ari_staion_plc_no[i - 1] - 1, i - 1] = 0;
                plc_s_stn_status[g_ari_staion_plc_no[i - 1] - 1, i - 1] = "N";
                plc_s_next_stn[g_ari_staion_plc_no[i - 1] - 1, i - 1] = "0";
                plc_i_pakmk[g_ari_staion_plc_no[i - 1] - 1, i - 1] = 0;

                gi_stn_iotype[i - 1] = 0;   //初始化站点出入形态
            }
        }

        /// <summary>
        /// 堆垛机初始化
        /// </summary>
        public static void InitCrn()
        {
            int i;
            for (i = 1; i <= ci_crn_count; i++)
            {
                crn_i_crnno[i - 1] = i;
                //crn_i_crn_sts[i - 1] = ci_CRN_SETTING;
                gs_crncmd[i - 1] = "";
                crn_i_kind[i - 1] = 0;
                crn_i_Wrkno[i - 1] = 0;
                crn_i_fstn[i - 1] = 0;
                crn_i_tstn[i - 1] = 0;
                crn_s_Flocno[i - 1] = "";
                crn_s_Tlocno[i - 1] = "";
                //crn_i_Errcod[i - 1] = 0;
                crn_i_onHP[i - 1] = 0;

                gs_crnlastio[i - 1] = "I";
                gs_crncmd[i - 1] = "";
                crn_s_commandstr[i - 1] = "";
                gi_crn_iotype[i - 1] = 0;

                gb_crn_status[i - 1] = true;

                AlarmCode[i - 1] = 0;
                TaskFlag[i - 1] = 0;
                CrnState[i - 1] = -1;
            }
        }

        /// <summary>
        /// 条码、LED、磅秤数据初始化
        /// </summary>
        public static void InitDev()
        {
            int i;
            for (i = 0; i < ci_barcode_count; i++)
            {
                gs_barcode_data[i] = "";
            }
            for (i = 0; i < ci_led_count; i++)
            {
                gs_led_data[i] = "";
                gs_led_data_pre[i] = "";
                gi_led_PageNumber[i] = 1;
                //gi_led_Pages[i] = 1;
                gi_led_Counts[i] = 0;
                gi_led_CurPageNumber[i] = 1;
            }
            for (i = 0; i < ci_scale_count; i++)
            {
                gd_gross_wt[i] = 0;
            }
        }

        /// <summary>
        /// 得到站序号
        /// </summary>
        /// <param name="stn"></param>
        /// <returns></returns>
        public static int GetStnSeq(int stn)
        {
            int retval = 0;
            for (int i = 0; i <= ci_sta_count - 1; i++)
            {
                if (g_ari_staion[i] == stn)
                {
                    retval = i;
                    return retval;
                    //break;
                }
            }
            return 0;
        }

        ////得到区域模式地址
        //public static int GetBufAddrByStn(int stn)
        //{
        //    int addr = 0;
        //    switch (stn)
        //    {
        //        case 1:
        //            addr = 4107;
        //            break;
        //        case 2:
        //            addr = 4110;
        //            break;
        //        default:
        //            break;
        //    }
        //    return addr;
        //}

        //public static string InttoStringYN(int i, int j)
        //{
        //    if (i == 1)
        //    {
        //        if (j == 1)
        //        {
        //            return "出";
        //        }
        //        else
        //        {
        //            return "入";
        //        }
        //    }
        //    else
        //    {
        //        if (j == 1)
        //        {
        //            return "入";
        //        }
        //        else
        //        {
        //            return "出";
        //        }
        //    }
        //}        

        ///// <summary>
        ///// 十六进制转十进制
        ///// </summary>
        ///// <param name="s_data"></param>
        ///// <param name="i_len"></param>
        ///// <returns></returns>
        //public static int funi_htoi(string s_data, int i_len)
        //{
        //    int i_sum = 0, i_tmp = 0, x = 0;
        //    s_data = s_data.ToUpper();
        //    if (s_data == "" || s_data == null)
        //    {
        //        return 0;
        //    }
        //    for (x = 0; x < i_len; x++)
        //    {

        //        i_tmp = Convert.ToInt32(s_data[x]);
        //        if (i_tmp > 58) i_tmp = i_tmp - 7;
        //        i_sum = i_sum * 16 + i_tmp - 48;
        //    }
        //    return i_sum;
        //}

        ///// <summary>
        ///// 判断是否4位十六进制是否正确
        ///// </summary>
        ///// <param name="data"></param>
        ///// <returns></returns>
        //public static bool fun_chkhex(string data)
        //{
        //    string s_str = data.PadLeft(4, '0');
        //    int i_asc = 0, i_count = 0;
        //    for (int i = 0; i < s_str.Length; i++)
        //    {
        //        i_asc = Convert.ToInt32(s_str[i]);
        //        if ((i_asc > 47 && i_asc < 58) || (i_asc > 64 && i_asc < 71))
        //        {

        //        }
        //        else
        //        {
        //            i_count++;
        //        }
        //    }
        //    if (i_count > 0)
        //    {
        //        return false;
        //    }
        //    else
        //    {
        //        return true;
        //    }
        //}

        /// <summary>
        /// 十六进制转十进制
        /// </summary>
        /// <param name="data"></param>
        /// <returns></returns>
        public static double fun_hextodec(string data)
        {
            string cptr = "";
            string s_str = data.Trim();
            int len = s_str.Length;
            double nsum = 0;
            int k = 1;
            for (int i = 0; i < len; i++)
            {
                cptr = s_str.Substring(len - i - 1, 1);
                if (cptr == "A")
                {
                    cptr = "10";
                }
                else if (cptr == "B")
                {
                    cptr = "11";
                }
                else if (cptr == "C")
                {
                    cptr = "12";
                }
                else if (cptr == "D")
                {
                    cptr = "13";
                }
                else if (cptr == "E")
                {
                    cptr = "14";
                }
                else if (cptr == "F")
                {
                    cptr = "15";
                }
                if (i == 0)
                {
                    k = 1;
                }
                else if (i == 1)
                {
                    k = 16;
                }
                else if (i == 2)
                {
                    k = 256;
                }
                else if (i == 3)
                {
                    k = 16 * 256;
                }
                else if (i == 4)
                {
                    k = 256 * 256;
                }
                else if (i == 5)
                {
                    k = 16 * 256 * 256;
                }
                else if (i == 6)
                {
                    k = 256 * 256 * 256;
                }
                else if (i == 7)
                {
                    k = 16 * 256 * 256 * 256;
                }
                nsum = nsum + Convert.ToInt32(cptr) * k;
            }
            return nsum;
        }

        ////得到十六进制
        //public static string fun_gethex(string s_data)
        //{
        //    string tohex = "";
        //    tohex = Convert.ToString(Convert.ToInt32(funi_htoi(s_data, 4)), 2);
        //    return tohex;
        //}

        ////得到位与运算结果，并判断是否相同
        //public static bool fun_ChkAndByte(string s_data, long t_data)
        //{
        //    long tohex1 = 0, tohex2 = 0, tohex3 = 0;
        //    tohex1 = Convert.ToInt64(Convert.ToString(Convert.ToInt64(funi_htoi(s_data, s_data.Length)), 2));
        //    tohex2 = t_data;// Convert.ToInt32(Convert.ToString(t_data, 2));
        //    tohex3 = tohex1 & tohex2;
        //    if (tohex3 == tohex2)
        //    {
        //        return true;
        //    }
        //    else
        //    {
        //        return false;
        //    }
        //}

        /// <summary>
        /// 得到位与运算结果，并判断是否相同
        /// </summary>
        /// <param name="i_data"></param>
        /// <param name="t_data"></param>
        /// <returns></returns>
        public static bool fun_ChkAndByte(long i_data, long t_data)
        {
            long tohex1 = 0, tohex2 = 0, tohex3 = 0;
            tohex1 = i_data;
            tohex2 = t_data;// Convert.ToInt32(Convert.ToString(t_data, 2));
            tohex3 = tohex1 & tohex2;
            if (tohex3 == tohex2)
            {
                return true;
            }
            else
            {
                return false;
            }
        }

        /// <summary>
        /// 生成工作号
        /// </summary>
        /// <param name="wrkmk"></param>
        /// <returns></returns>
        public static int GetWrkno(int wrkmk)
        {
            int wrkno = 0, li_s_no = 0, li_e_no = 0;
            SqlConnection sqlcn = new SqlConnection(sqlcon);
            sqlcn.Open();
            SqlDataAdapter sqlda = new SqlDataAdapter("select wrk_no,s_no,e_no from asr_wrk_lastno where wrk_mk=" + wrkmk + "", sqlcn);
            DataSet ds = new DataSet();
            sqlda.Fill(ds);
            DataView dv = new DataView(ds.Tables[0]);
            sqlcn.Close();
            foreach (System.Data.DataRowView drow in dv)
            {
                wrkno = Convert.ToInt32(drow[0].ToString().Trim());
                li_s_no = Convert.ToInt32(drow[1].ToString().Trim());
                li_e_no = Convert.ToInt32(drow[2].ToString().Trim());
            }
            if (wrkno >= li_e_no)
            {
                wrkno = li_s_no;
            }
            else
            {
                wrkno++;
            }

            SqlConnection sqlcon1 = new SqlConnection(sqlcon);
            sqlcon1.Open();
            SqlTransaction sqlts = sqlcon1.BeginTransaction();
            string sql = "update asr_wrk_lastno set wrk_no=" + wrkno + " where wrk_mk=" + wrkmk + "";
            SqlCommand sqlcom1 = new SqlCommand(sql, sqlcon1);
            sqlcom1.Transaction = sqlts;
            try
            {
                sqlcom1.ExecuteNonQuery();
                sqlts.Commit();
            }
            catch (SqlException r)
            {
                //MessageBox.Show("更新[asr_wrk_lastno]错误！", "错误");
                sqlts.Rollback();
                wrkno = 0;
            }
            finally
            {
                sqlcom1.Dispose();
                sqlcon1.Dispose();
                sqlcon1.Close();
            }
            return wrkno;
        }

        /// <summary>
        /// 生成库位号
        /// </summary>
        /// <param name="type">入库类型</param>
        /// <param name="loc_type">高低库位</param>
        /// <param name="crn_no">堆垛机号</param>
        /// <param name="stano">入库站号</param>
        /// <param name="stnType">入库方向,1为东侧1列起数，2为西侧最大列起数</param>
        /// <returns></returns>
        public static string GetLocNo(int type, int loc_type, int crn_no, int stano, int stnType)
        {
            int e_staNo = 0;
            string locno = "";
            int li_crnrow = 0, li_crn = 0, li_cnt = 0, li_max_cnt = 0, i = 0, n = 0, li_min = 0, li_max = 0, li_max_1 = 0, li_crn_qty = 0, crnsts = 0;
            string orderBy = "lev1,bay1 asc";
            if (stnType == 1)    //东侧
            {
                orderBy = "lev1,bay1 asc";
            }
            else if (stnType == 2)  //西侧
            {
                orderBy = "lev1 asc,bay1 desc";
            }
            //DataView dv = ExecAsrsSelect("select current_row,s_row,e_row,crn_qty from asr_row_lastno where whs_type=" + whs_type);
            DataView dv = ExecAsrsSelect("select current_row,s_row,e_row,crn_qty from asr_row_lastno ");
            foreach (DataRowView drv in dv)
            {
                li_crnrow = Convert.ToInt32(drv[0].ToString());
                li_min = Convert.ToInt32(drv[1].ToString());
                li_max = Convert.ToInt32(drv[2].ToString());
                li_crn_qty = Convert.ToInt32(drv[3].ToString());
            }
            li_max_1 = li_max - 1;
            i = 1;
            do
            {
                if (li_crnrow == li_max)
                {
                    li_crnrow = li_min;
                }
                else if (li_crnrow == li_max_1)
                {
                    li_crnrow = li_min + 1;
                }
                else
                {
                    li_crnrow = li_crnrow + 2;
                }
                li_crn = (li_crnrow + 1) / 2;

                if (ChkCrnEnable(li_crn, "I") == "Y")
                {
                    e_staNo = getIoStaNo(type, li_crn, stano);
                    if (e_staNo == 0)
                    {
                        continue;
                    }
                    //if (type == 10)
                    //{
                    //    locno = getEmptyLocation(li_crnrow, loc_type, orderBy);
                    //}

                    if (locno == "")
                    {
                        string sql = "";
                        //if (type == 10)
                        //{
                        sql = "select top 1 loc_no from asr_loc_mast where row1=" + li_crnrow + " and loc_sts='O' order by " + orderBy;
                        //}
                        //else
                        //{
                        //    sql = "select top 1 loc_no from asr_loc_mast where row1=" + li_crnrow + " and loc_sts='O' order by " + orderBy;
                        //}
                        SqlConnection sqlconn = new SqlConnection(sqlcon);
                        sqlconn.Open();
                        SqlDataAdapter sqlap = new SqlDataAdapter(sql, sqlconn);
                        DataSet ds = new DataSet();
                        sqlap.Fill(ds);
                        DataView dv1 = new DataView(ds.Tables[0]);
                        sqlap.Dispose();
                        sqlconn.Dispose();
                        //sqlconn.Close();
                        foreach (DataRowView drv in dv1)
                        {
                            locno = drv[0].ToString();
                            break;
                        }
                    }
                }

                //if (locno != "" && int.Parse(locno.Substring(0, 2)) < 3 && (stano == 1304 || stano == 1205))
                //{//1204站无法入库1号堆垛机
                //    locno = "";
                //}
                //if (crn_no > 0 && crn_no != li_crn)
                //{//先入品分配新库位，必须同一台堆垛机
                //    locno = "";
                //}
                if (Common.AlarmCode[li_crn - 1] > 0 || Common.Mode[li_crn - 1] != 3)
                { //堆垛机异常或者非自动，寻找下一个库位
                    locno = "";
                }

                //int seqno = Common.GetStnSeq(e_staNo);
                //int plcno = stnType - 1;
                //string s_loading = Common.plc_s_loading[plcno, seqno];
                //if (s_loading == "Y")
                //{//堆垛机入库站点有物，寻找下一个
                //    locno = "";
                //}

                i++;
                if (i > li_crn_qty * 2)
                {
                    break;
                }
            } while (locno == "");

            if (locno != "")
            {
                SqlConnection sqlconn = new SqlConnection(sqlcon);
                sqlconn.Open();
                SqlTransaction sqltrans = sqlconn.BeginTransaction();
                string sql = "update dbo.asr_row_lastno set current_row='" + li_crnrow + "',modi_time='" + DateTime.Now.ToString() + "' ";
                SqlCommand sqlcmd = new SqlCommand(sql, sqlconn);
                sqlcmd.Transaction = sqltrans;
                try
                {
                    sqlcmd.ExecuteNonQuery();
                    sqltrans.Commit();
                }
                catch (SqlException r)
                {
                    //MessageBox.Show("更新[asr_row_lastno]错误！", "错误");
                    sqltrans.Rollback();
                    sqlcmd.Dispose();
                    sqlconn.Dispose();
                    locno = "";
                }
            }
            return locno;
        }

        /// <summary>
        /// 根据作业类型得到站点编号
        /// </summary>
        /// <param name="type">入库类型</param>
        /// <param name="crnno">堆垛机号</param>
        /// <param name="stnno">站点号</param>
        /// <returns></returns>
        public static int getIoStaNo(int type, int crnno, int stnno)
        {
            int e_staNo = 0;
            try
            {
                string sql = "select crn_stn from asr_sta_desc ";
                sql += " where type_no=" + type + " and stn_no=" + stnno + " and crn_no=" + crnno;
                DataView dv_crn_stn = Common.ExecAsrsSelect(sql);
                if (dv_crn_stn != null || dv_crn_stn.Count > 0)
                {
                    foreach (DataRowView drow in dv_crn_stn)
                    {
                        e_staNo = int.Parse(drow[0].ToString());
                    }
                }
            }
            catch (Exception)
            {
            }
            return e_staNo;
        }

        /// <summary>
        /// 判断堆垛机是否可用
        /// </summary>
        /// <param name="crn"></param>
        /// <param name="type"></param>
        /// <returns></returns>
        public static string ChkCrnEnable(int crnno, string type)
        {
            DataView dv = null;
            string ls_in = "N", ls_ou = "N";
            dv = ExecAsrsSelect("select in_enable,out_enable from asr_bas_crnp where crn_no=" + crnno);
            foreach (DataRowView drv in dv)
            {
                ls_in = drv[0].ToString();
                ls_ou = drv[1].ToString();
            }
            if (type == "I")
            {
                return ls_in;
            }
            else if (type == "O")
            {
                return ls_ou;
            }
            else
            {
                return "N";
            }
        }

        //public static string GetRow(string row)
        //{
        //    if (row == "01")
        //    {
        //        return "01";
        //    }
        //    else if (row == "02")
        //    {
        //        return "02";
        //    }
        //    //else if (row == "03")
        //    //{
        //    //    return "01";
        //    //}
        //    //else if (row == "04")
        //    //{
        //    //    return "02";
        //    //}
        //    //else if (row == "05")
        //    //{
        //    //    return "01";
        //    //}
        //    //else if (row == "06")
        //    //{
        //    //    return "02";
        //    //}
        //    else
        //    {
        //        return "";
        //    }
        //}

        /// <summary>
        /// 根据堆垛机异常码得到异常描述
        /// </summary>
        /// <param name="error_code"></param>
        /// <returns></returns>
        public static string GetErr(int error_code)
        {
            string result = "";
            switch (error_code)
            {
                case 1:
                    result = "左超限";
                    break;
                case 2:
                    result = "右超限";
                    break;
                case 3:
                    result = "前超限";
                    break;
                case 4:
                    result = "后超限";
                    break;
                case 5:
                    result = "高超限";
                    break;
                case 6:
                    result = "取货载货台有货";
                    break;
                case 7:
                    result = "放货载货台无货";
                    break;
                case 8:
                    result = "取货左货格无货";
                    break;
                case 9:
                    result = "取货右货格无货";
                    break;
                case 10:
                    result = "放货左一有货";
                    break;
                case 11:
                    result = "放货右一有货";
                    break;
                case 12:
                    result = "取左二货格无货";
                    break;
                case 13:
                    result = "取右二货格无货";
                    break;
                case 14:
                    result = "放货左二货格有货";
                    break;
                case 15:
                    result = "放货右二货格有货";
                    break;
                case 16:
                    result = "左二取货左一有货";
                    break;
                case 17:
                    result = "右二取货右一有货";
                    break;
                case 18:
                    result = "左取货失败";
                    break;
                case 19:
                    result = "右取货失败";
                    break;
                case 20:
                    result = "左放货失败";
                    break;
                case 21:
                    result = "右放货失败";
                    break;
                case 22:
                    result = "货叉运行超时";
                    break;
                case 23:
                    result = "货叉断路器跳闸";
                    break;
                case 24:
                    result = "货叉变频器报警";
                    break;
                case 25:
                    result = "货叉编码器故障";
                    break;
                case 26:
                    result = "货叉伸叉故障";
                    break;
                case 27:
                    result = "层运行货叉不在中位";
                    break;
                case 28:
                    result = "列运行货叉不在中位";
                    break;
                case 29:
                    result = "货叉中位开关故障";
                    break;
                case 30:
                    result = "货叉变频器通讯故障";
                    break;
                case 31:
                    result = "货叉编码器通讯故障";
                    break;
                case 32:
                    result = "伸叉超出左极限";
                    break;
                case 33:
                    result = "伸叉超出右极限";
                    break;
                case 34:
                    result = "入左二货格货时左一货格有货";
                    break;
                case 35:
                    result = "入右二货格货时右一货格有货";
                    break;
                case 36:
                    result = "货叉右侧回中停止位置错误";
                    break;
                case 37:
                    result = "货叉左侧回中停止位置错误";
                    break;
                case 38:
                    result = "货叉左侧极限停止位置错误";
                    break;
                case 39:
                    result = "货叉右侧极限停止位置错误";
                    break;
                case 40:
                    result = "面板急停";
                    break;
                case 41:
                    result = "远程急停";
                    break;
                case 42:
                    result = "主接触器控制回路故障";
                    break;
                case 43:
                    result = "超重保护";
                    break;
                case 44:
                    result = "松绳保护";
                    break;
                case 45:
                    result = "限速保护";
                    break;
                case 46:
                    result = "层停止位置错误";
                    break;
                case 47:
                    result = "列停止位置错误";
                    break;
                case 48:
                    result = "列停止位置错误";
                    break;
                case 49:
                    result = "接收列超限";
                    break;
                case 50:
                    result = "接收层超限";
                    break;
                case 51:
                    result = "接收层超限";
                    break;
                case 52:
                    result = "行走后退极限";
                    break;
                case 53:
                    result = "提升上极限";
                    break;
                case 54:
                    result = "提升下极限";
                    break;
                case 55:
                    result = "行走运行超时";
                    break;
                case 56:
                    result = "提升运行超时";
                     break;
                      case 57:
                     result = "行走断路器跳闸";
                     break;
                      case 58:
                     result = "提升断路器跳闸";
                     break;
                      case 59:
                     result = "行走变频器故障";
                     break;
                      case 60:
                     result = "提升变频器故障";
                     break;
                      case 61:
                     result = "行走测距/条码故障";
                     break;
                      case 62:
                     result = "提升测距/条码故障";
                     break;
                      case 63:
                     result = "行走测距/条码被挡";
                     break;
                      case 64:
                     result = "提升测距/条码被挡";
                     break;
                      case 65:
                     result = "上升减速光电故障";
                     break;
                      case 66:
                     result = "下降减速光电故障";
                     break;
                      case 67:
                     result = "提升原点光电故障";
                     break;
                      case 68:
                     result = "行走前减速光电故障";
                     break;
                      case 69:
                     result = "行走后减速光电故障";
                     break;
                      case 70:
                     result = "行走原点光电故障";
                     break;
                      case 71:
                     result = "与输送机通讯故障";
                     break;
                      case 72:
                     result = "升降超出最小层";
                     break;
                      case 73:
                     result = "升降超出最大层";
                     break;
                      case 74:
                     result = "行走超出最小列";
                     break;
                      case 75:
                     result = "行走超出最大列";
                     break;
                      case 76:
                     result = "接收排错误";
                     break;
                      case 77:
                     result = "起始站货格被禁用";
                     break;
                      case 78:
                     result = "目的站货格被禁用";
                     break;
                      case 79:
                     result = "行走抱闸故障";
                     break;
                      case 80:
                     result = "提升抱闸故障";
                     break;
                      case 81:
                     result = "安全门打开故障";
                     break;
                default:
                    result = "";
                    break;
            }
            return result;
        }

        ////判断数字是否合法
        //public static bool ChkFloat(string str)
        //{
        //    try
        //    {
        //        float f = (float)Convert.ToDouble(str);
        //        return true;
        //    }
        //    catch (Exception e)
        //    {
        //        return false;
        //    }
        //}
        ////判断整数是否合法
        //public static bool ChkInt(string str)
        //{
        //    try
        //    {
        //        int f = Convert.ToInt32(str);
        //        return true;
        //    }
        //    catch (Exception e)
        //    {
        //        return false;
        //    }
        //}
        ////得到地址
        //public static string GetAddr(int li)
        //{
        //    string addr = "";
        //    try
        //    {
        //        switch (li)
        //        {
        //            case 0:
        //                return addr = "1030";
        //            case 1:
        //                return addr = "1032";
        //            case 2:
        //                return addr = "1034";
        //            case 3:
        //                return addr = "1036";
        //            case 4:
        //                return addr = "1038";
        //            case 5:
        //                return addr = "1040";
        //            case 6:
        //                return addr = "1042";
        //            default:
        //                return addr = "";

        //        }
        //    }
        //    catch (Exception e)
        //    {
        //        return addr = "";
        //    }
        //}

        /// <summary>
        /// 查询erp数据
        /// </summary>
        /// <param name="sql"></param>
        /// <returns></returns>
        public static DataView ExecErpSelect(string sql)
        {
            try
            {
                OracleConnection sqlerp = new OracleConnection(erpcon);
                sqlerp.Open();
                OracleDataAdapter odasrs = new OracleDataAdapter(sql, sqlerp);
                DataSet dserp = new DataSet();
                odasrs.Fill(dserp);
                DataView dverp = new DataView(dserp.Tables[0]);
                odasrs.Dispose();
                sqlerp.Dispose();
                sqlerp.Close();
                return dverp;
            }
            catch (SqlException em)
            {
                return null;
            }
        }

        /// <summary>
        /// 执行ERP数据更新sql语句
        /// </summary>
        /// <param name="sql"></param>
        /// <returns></returns>
        public static bool ExecERPModify(string sql)
        {
            bool result = false;
            try
            {
                OracleConnection sqlconn = new OracleConnection(erpcon);
                sqlconn.Open();
                OracleTransaction sqltrans = sqlconn.BeginTransaction();
                OracleCommand sqlcmd = new OracleCommand();
                //SqlCommand sqlcmd = new SqlCommand(sql, sqlconn);
                //sqlcmd.Transaction = sqltrans;
                string[] arraySql = sql.Split(';');
                try
                {
                    for (int i = 0; i < arraySql.Length; i++)
                    {
                        if (arraySql[i] != "")
                        {
                            sqlcmd.CommandText = arraySql[i];
                            sqlcmd.Connection = sqlconn;
                            sqlcmd.Transaction = sqltrans;
                            sqlcmd.ExecuteNonQuery();
                        }
                    }
                    sqltrans.Commit();
                    result = true;
                }
                catch (SqlException t)
                {
                    sqltrans.Rollback();
                    result = false;

                }
                finally
                {
                    sqlcmd.Dispose();
                    sqltrans.Dispose();
                    sqlconn.Dispose();
                    //sqlconn.Close();
                }
            }
            catch (Exception r)
            {
                return false;
            }
            return result;
        }

        /////-------------------------------从asrs数据库中执行查询功能返回数据集----------------
        public static DataView ExecAsrsSelect(string sql)
        {
            try
            {
                SqlConnection sqlasrs = new SqlConnection(sqlcon);
                sqlasrs.Open();
                SqlDataAdapter odasrs = new SqlDataAdapter(sql, sqlasrs);
                DataSet dsasrs = new DataSet();
                odasrs.Fill(dsasrs);
                DataView dvasrs = new DataView(dsasrs.Tables[0]);
                odasrs.Dispose();
                sqlasrs.Dispose();
                sqlasrs.Close();
                return dvasrs;
            }
            catch (SqlException em)
            {
                return null;
            }
        }

        public static DataView ExecAsrsSelect(string sql, out string err)
        {
            err = null;
            try
            {
                SqlConnection sqlasrs = new SqlConnection(sqlcon);
                sqlasrs.Open();
                SqlDataAdapter odasrs = new SqlDataAdapter(sql, sqlasrs);
                DataSet dsasrs = new DataSet();
                odasrs.Fill(dsasrs);
                DataView dvasrs = new DataView(dsasrs.Tables[0]);
                odasrs.Dispose();
                sqlasrs.Dispose();
                sqlasrs.Close();
                return dvasrs;
            }
            catch (SqlException em)
            {
                err = "查询sql语句失败：" + em.Message;
                //MessageBox.Show("查询sql语句失败：" + em.Message + "\r\n" + sql);
                return null;
            }
        }
        /////-------------------------------从asrs数据库中执行查询功能返回数据量----------------
        public static int ExecAsrsSelect1(string sql)
        {
            int li_count1 = 0;
            SqlConnection sqlasrs0 = new SqlConnection(sqlcon);
            sqlasrs0.Open();
            SqlCommand ocasrs = new SqlCommand(sql, sqlasrs0);
            li_count1 = Convert.ToInt32(ocasrs.ExecuteScalar());
            sqlasrs0.Dispose();
            ocasrs.Dispose();
            sqlasrs0.Close();

            return li_count1;
        }
        /////-------------------------------从asrs数据库中执行异动功能（提交）----------------
        /// <summary>
        /// 执行sql更新语句(insert、delete、update)
        /// </summary>
        /// <param name="sql"></param>
        /// <returns></returns>
        public static bool ExecAsrsModify(string sql)
        {
            bool result = false;
            try
            {
                SqlConnection sqlconn = new SqlConnection(sqlcon);
                sqlconn.Open();
                SqlTransaction sqltrans = sqlconn.BeginTransaction();
                SqlCommand sqlcmd = new SqlCommand();
                //SqlCommand sqlcmd = new SqlCommand(sql, sqlconn);
                //sqlcmd.Transaction = sqltrans;
                string[] arraySql = sql.Split(';');
                try
                {
                    for (int i = 0; i < arraySql.Length; i++)
                    {
                        if (arraySql[i] != "")
                        {
                            sqlcmd.CommandText = arraySql[i];
                            sqlcmd.Connection = sqlconn;
                            sqlcmd.Transaction = sqltrans;
                            sqlcmd.ExecuteNonQuery();
                        }
                    }
                    sqltrans.Commit();
                    result = true;
                }
                catch (SqlException em)
                {
                    WriteLogFile("WcsError", "Common/ExecAsrsModify--执行SQL语句发生异常:" + em.Message + "\r\n" + sql);
                    sqltrans.Rollback();
                    result = false;

                }
                finally
                {
                    sqlcmd.Dispose();
                    sqltrans.Dispose();
                    sqlconn.Dispose();
                    //sqlconn.Close();
                }
            }
            catch (Exception r)
            {
                return false;
            }
            return result;
        }
        ///////-------------------------------从asrs数据库中执行异动功能(未提交)----------------
        //public static bool ExecAsrsModify1(string sql)
        //{
        //    bool result = false;
        //    SqlConnection sqlasrs1 = new SqlConnection(sqlcon);
        //    sqlasrs1.Open();
        //    SqlTransaction otasrs = sqlasrs1.BeginTransaction();
        //    SqlCommand ocom = new SqlCommand(sql, sqlasrs1);
        //    ocom.Transaction = otasrs;
        //    try
        //    {
        //        ocom.ExecuteNonQuery();
        //        //otasrs.Commit();
        //        result = true;
        //    }
        //    catch (SqlException t)
        //    {
        //        otasrs.Rollback();
        //        result = false;

        //    }
        //    finally
        //    {
        //        ocom.Dispose();
        //        otasrs.Dispose();
        //        sqlasrs1.Dispose();
        //        sqlasrs1.Close();
        //    }
        //    return result;
        //}
        ///////-------------------------------从asrs数据库中执行异动功能(两个表)，同步执行----------------
        //public static bool ExecAsrsModifyByMD(string sql, string sql1)
        //{
        //    bool result = false;
        //    SqlConnection sqlasrs1 = new SqlConnection(sqlcon);
        //    sqlasrs1.Open();
        //    SqlTransaction otasrs = sqlasrs1.BeginTransaction();
        //    SqlCommand ocom = new SqlCommand(sql, sqlasrs1);
        //    SqlCommand ocom1 = new SqlCommand(sql1, sqlasrs1);
        //    ocom.Transaction = otasrs;
        //    ocom1.Transaction = otasrs;
        //    try
        //    {
        //        ocom.ExecuteNonQuery();
        //        ocom1.ExecuteNonQuery();
        //        otasrs.Commit();
        //        result = true;
        //    }
        //    catch (SqlException t)
        //    {
        //        otasrs.Rollback();
        //        result = false;

        //    }
        //    finally
        //    {
        //        ocom.Dispose();
        //        otasrs.Dispose();
        //        sqlasrs1.Dispose();
        //        sqlasrs1.Close();
        //    }
        //    return result;
        //}
        ///////-------------------------------从asrs数据库中执行异动功能(4个表),同步执行----------------
        //public static bool ExecAsrsModifyByMD(string sql, string sql1, string sql2, string sql3)
        //{
        //    bool result = false;
        //    SqlConnection sqlasrs1 = new SqlConnection(sqlcon);
        //    sqlasrs1.Open();
        //    SqlTransaction otasrs = sqlasrs1.BeginTransaction();
        //    SqlCommand ocom = new SqlCommand(sql, sqlasrs1);
        //    SqlCommand ocom1 = new SqlCommand(sql1, sqlasrs1);
        //    SqlCommand ocom2 = new SqlCommand(sql2, sqlasrs1);
        //    SqlCommand ocom3 = new SqlCommand(sql3, sqlasrs1);
        //    ocom.Transaction = otasrs;
        //    ocom1.Transaction = otasrs;
        //    ocom2.Transaction = otasrs;
        //    ocom3.Transaction = otasrs;
        //    try
        //    {
        //        ocom.ExecuteNonQuery();
        //        ocom1.ExecuteNonQuery();
        //        ocom2.ExecuteNonQuery();
        //        ocom3.ExecuteNonQuery();
        //        otasrs.Commit();
        //        result = true;
        //    }
        //    catch (SqlException t)
        //    {
        //        otasrs.Rollback();
        //        result = false;

        //    }
        //    finally
        //    {
        //        ocom.Dispose();
        //        otasrs.Dispose();
        //        sqlasrs1.Dispose();
        //        sqlasrs1.Close();
        //    }
        //    return result;
        //}
        /////-------------------------------从asrs数据库中执行异动功能(5个表),同步执行----------------
        public static bool ExecAsrsModifyByMD(string sql, string sql1, string sql2, string sql3, string sql4)
        {
            bool result = false;
            SqlConnection sqlasrs1 = new SqlConnection(sqlcon);
            sqlasrs1.Open();
            SqlTransaction otasrs = sqlasrs1.BeginTransaction();
            SqlCommand ocom = new SqlCommand(sql, sqlasrs1);
            SqlCommand ocom1 = new SqlCommand(sql1, sqlasrs1);
            SqlCommand ocom2 = new SqlCommand(sql2, sqlasrs1);
            SqlCommand ocom3 = new SqlCommand(sql3, sqlasrs1);
            SqlCommand ocom4 = new SqlCommand(sql4, sqlasrs1);
            ocom.Transaction = otasrs;
            ocom1.Transaction = otasrs;
            ocom2.Transaction = otasrs;
            ocom3.Transaction = otasrs;
            ocom4.Transaction = otasrs;
            try
            {
                ocom.ExecuteNonQuery();
                ocom1.ExecuteNonQuery();
                ocom2.ExecuteNonQuery();
                ocom3.ExecuteNonQuery();
                ocom4.ExecuteNonQuery();
                otasrs.Commit();
                result = true;
            }
            catch (SqlException t)
            {
                otasrs.Rollback();
                result = false;

            }
            finally
            {
                ocom.Dispose();
                otasrs.Dispose();
                sqlasrs1.Dispose();
                sqlasrs1.Close();
            }
            return result;
        }
        ///////-------------------------------从ASRS数据库中执行查询功能返回数据量----------------
        //public static int ExecASRSSelect1(string sql)
        //{
        //    int li_count1 = 0;
        //    SqlConnection sqlasrs = new SqlConnection(sqlcon);
        //    sqlasrs.Open();
        //    SqlCommand ocerp = new SqlCommand(sql, sqlasrs);
        //    li_count1 = Convert.ToInt32(ocerp.ExecuteScalar());
        //    ocerp.Dispose();
        //    sqlasrs.Dispose();
        //    sqlasrs.Close();
        //    return li_count1;
        //}

        /// <summary>
        /// 根据库位状态代号返回库位状态名称
        /// </summary>
        /// <param name="locsts"></param>
        /// <returns></returns>
        public static string getlocsts(string locsts)
        {
            string locstsname = "";
            switch (locsts)
            {
                case "O":
                    locstsname = "O-空库位";
                    break;
                case "F":
                    locstsname = "F-在库";
                    break;
                case "S":
                    locstsname = "S-入库预约中";
                    break;
                case "R":
                    locstsname = "R-出库预约中";
                    break;
                case "P":
                    locstsname = "P-拣料/并板/盘点出库预约中";
                    break;
                case "L":
                    locstsname = "L-拣料库位空载中";
                    break;
                case "M":
                    locstsname = "M-拣料库位满载中";
                    break;
                case "Q":
                    locstsname = "Q-拣料/并板/盘点再入库预约中";
                    break;
                case "X":
                    locstsname = "X-禁用";
                    break;
                case "D":
                    locstsname = "D-空栈板";
                    break;
                default:
                    locstsname = "O-空库位";
                    break;
            }
            return locstsname;
        }

        /// <summary>
        /// 根据工作状态代号得到工作状态名称
        /// </summary>
        /// <param name="sts"></param>
        /// <returns></returns>
        public static string Getwrksts(string sts)
        {
            string wrkstsname = "";
            switch (sts)
            {
                case "1":
                    wrkstsname = "1.生成入库ID";
                    break;
                case "2":
                    wrkstsname = "2.设备上移动";
                    break;
                case "3":
                    wrkstsname = "3.堆垛机入库中";
                    break;
                case "4":
                    wrkstsname = "4.堆垛机入库完成";
                    break;
                case "5":
                    wrkstsname = "5.入库回报完成";
                    break;
                //case "6":
                //    wrkstsname = "6.2号堆垛机站到站中";
                //    break;
                //case "7":
                //    return "7.5站到6站移动中";
                //    break;
                //case "8":
                //    return "8.7站到8站移动中";
                //    break;
                //case "9":
                //    return "9.2号堆垛机站到站完成";
                //    break;
                case "11":
                    wrkstsname = "11.生成出库ID";
                    break;
                case "12":
                    wrkstsname = "12.堆垛机出库中";
                    break;
                case "13":
                    wrkstsname = "13.空出库";
                    break;
                case "14":
                    wrkstsname = "14.堆垛机出库完成";
                    break;
                case "15":
                    wrkstsname = "15.出库回报完成";
                    break;
                case "16":
                    wrkstsname = "16.LED指令完成";
                    break;
            }
            return wrkstsname;
        }

        /// <summary>
        /// 根据IO类型代号得到IO名称
        /// </summary>
        /// <param name="sts"></param>
        /// <returns></returns>
        public static string Getiotype(string sts)
        {
            string iotypename = "";
            switch (sts)
            {
                case "1":
                    iotypename = "1.入库";
                    break;
                case "6":
                    iotypename = "6.退库";
                    break;
                case "10":
                    iotypename = "10.空桶入库";
                    break;
                case "110":
                    iotypename = "110.空桶出库";
                    break;
                case "101":
                    iotypename = "101.全板出库";
                    break;
                case "103":
                    iotypename = "103.拣料出库";
                    break;
                case "104":
                    iotypename = "104.并板出库";
                    break;
                case "107":
                    iotypename = "107.盘点出库";
                    break;
                case "53":
                    iotypename = "53.拣料再入库";
                    break;
                case "57":
                    iotypename = "57.盘点再入库";
                    break;
                case "54":
                    iotypename = "54.并板再入库";
                    break;
            }
            return iotypename;
        }

        /// <summary>
        /// 根据拣料站得到再入库堆垛机站点
        /// </summary>
        /// <param name="crn"></param>
        /// <param name="stn"></param>
        /// <returns></returns>
        public static int GetRestoreStnByPick(int crn, int stn)
        {
            int stnno = 0;
            switch (crn)
            {
                case 1:
                    stnno = 106;
                    break;
                case 2:
                    stnno = 120;
                    break;

                case 3:
                    stnno = 133;
                    break;
            




            }
            return stnno;
        }

        /// <summary>
        /// 根据站号得到对应吊车站序号
        /// </summary>
        /// <param name="stn"></param>
        /// <returns></returns>
        public static int GetCrnStnSeq(int stn)
        {
            int crnstn = 0;
            switch (stn)
            {
                case 100:
                    crnstn = 1;
                    break;
                case 200:
                    crnstn = 2;
                    break;
                case 104:
                    crnstn = 1;
                    break;
                case 204:
                    crnstn = 2;
                    break;
                default:
                    crnstn = 0;
                    break;
            }
            return crnstn;
        }

        /// <summary>
        /// 根据堆垛机入库站号得到站点编号
        /// </summary>
        /// <param name="crn">堆垛机号</param>
        /// <param name="seq">堆垛机站点编号</param>
        /// <returns>输送机站点编号</returns>
        public static int GetStnSeqNo(int crn, int seq)
        {
            int stnno = 0;
            switch (crn)
            {
                case 1:
                    switch (seq)
                    {
                        case 1:
                            stnno = 104;
                            break;
                        //case 2:
                        //    stnno = 104;
                        //    break;
                    }
                    break;
                case 2:
                    switch (seq)
                    {
                        case 1:
                            stnno = 204;
                            break;
                    }
                    break;
                default:
                    stnno = seq;
                    break;
            }
            return stnno;
        }

        /// <summary>
        /// 判断字符串是否数字
        /// </summary>
        /// <param name="ls_string"></param>
        /// <returns></returns>
        public static bool ChkStrtoInt(string ls_string)
        {
            bool result = false;
            int i = 0, i_len = 0;
            i_len = ls_string.Length;
            for (i = 0; i < i_len; i++)
            {
                if (ls_string[i] >= '0' && ls_string[i] <= '9')
                // if (Convert.ToInt32(ls_string[i].ToString()) >= 0 && Convert.ToInt32(ls_string[i].ToString()) <= 9)
                {
                    result = true;
                }
                else
                {
                    result = false;
                    break;
                }
            }
            return result;

        }

        /// <summary>
        /// 写日志文件
        /// </summary>
        /// <param name="Memo">写入内容</param>
        public static void WriteLogFile(string fileName, string Memo)
        {
            DateTime dt = DateTime.Now;
            string FileName = Application.StartupPath + "\\log\\" + fileName + string.Format("{0:yyyyMMdd}", dt) + ".log";
            try
            {
                if (!Directory.Exists(Application.StartupPath + "\\log"))
                {
                    Directory.CreateDirectory(Application.StartupPath + "\\log");
                }

                StreamWriter fs1 = new StreamWriter(FileName, true);//创建写入文件    
                //StreamWriter sw = new StreamWriter(fs1);
                fs1.WriteLine("【" + DateTime.Now.ToString() + "】" + Memo);//开始写入值                   

                //sw.Close();
                fs1.Close();
            }
            catch (Exception)
            {
            }
        }

        /// <summary>
        /// DateTime时间格式转换为Unix时间戳格式
        /// </summary>
        /// <param name=”time”></param>
        /// <returns></returns>
        public static int ConvertDateTimeInt(System.DateTime time)
        {
            System.DateTime startTime = TimeZone.CurrentTimeZone.ToLocalTime(new System.DateTime(1970, 1, 1));
            return (int)(time - startTime).TotalSeconds;

        }

        ///// <summary>
        ///// 判断工作档中入库资料数量
        ///// </summary>
        ///// <returns></returns>
        //public static int GetWrkInCount()
        //{
        //    int result = 1000;
        //    try
        //    {
        //        string sql = "select * from asr_wrk_mast where wrk_sts>0 and wrk_sts<5";
        //        result = Common.ExecAsrsSelect1(sql);                
        //    }
        //    catch (Exception)
        //    {
        //    }
        //    return result;
        //}

        ///// <summary>
        ///// 判断工作档中出库资料数量
        ///// </summary>
        ///// <returns></returns>
        //public static int GetWrkOutCount()
        //{
        //    int result = 1000;
        //    try
        //    {
        //        string sql = "select * from asr_wrk_mast where wrk_sts>11 and wrk_sts<15";
        //        result = Common.ExecAsrsSelect1(sql);
        //    }
        //    catch (Exception)
        //    {
        //    }
        //    return result;
        //}

        ///// <summary>
        ///// 判断工作档中资料数量
        ///// </summary>
        ///// <returns></returns>
        //public static int GetWrkCount()
        //{
        //    int result = 1000;
        //    try
        //    {
        //        string sql = "select * from asr_wrk_mast where wrk_sts<15";
        //        result = Common.ExecAsrsSelect1(sql);
        //    }
        //    catch (Exception)
        //    {
        //    }
        //    return result;
        //}

        ///// <summary>
        ///// 判断库存档中库存资料是否存在
        ///// </summary>
        ///// <returns></returns>
        //public static int GetStkCount(string boxId)
        //{
        //    int result = 1000;
        //    try
        //    {
        //        string sql = "select * from asr_loc_mast where boxId='" + boxId + "'";
        //        result = Common.ExecAsrsSelect1(sql);
        //    }
        //    catch (Exception)
        //    {
        //    }
        //    return result;
        //}

        /// <summary>
        /// 检查数据库连接是否正常
        /// </summary>
        /// <returns></returns>
        public static bool CheckDbConnect()
        {
            bool result = false;
            SqlConnection conn = new SqlConnection(Common.sqlcon);
            try
            {
                if (conn.State == ConnectionState.Closed)
                    conn.Open();
                else if (conn.State == ConnectionState.Broken)
                {
                    conn.Close();
                    conn.Open();
                }
                result = true;
            }
            catch (Exception em)
            {
                //MessageBox.Show("数据库连接失败。" + em.Message, "错误");
            }
            finally
            {
                conn.Close();
            }
            return result;
        }

        /// <summary>
        /// 检测端口是否占用
        /// </summary>
        /// <param name="port"></param>
        /// <returns></returns>
        public static bool PortInUse(int port)
        {
            bool inUse = false;

            IPGlobalProperties ipProperties = IPGlobalProperties.GetIPGlobalProperties();
            IPEndPoint[] ipEndPoints = ipProperties.GetActiveTcpListeners();

            foreach (IPEndPoint endPoint in ipEndPoints)
            {
                if (endPoint.Port == port)
                {
                    inUse = true;
                    break;
                }
            }
            return inUse;
        }

        /// <summary>
        /// 根据输送机站点获取对应库位号
        /// </summary>
        /// <param name="i_stn">堆垛机状态值</param>
        /// <returns>库位号</returns>
        public static string GetLocByStn(int i_stn)
        {
            string loc_no = "0000000";
            switch (i_stn)
            {
                case 100:
                    loc_no = "0200101";
                    break;
                case 104:
                    loc_no = "0300101";
                    break;
                case 200:
                    loc_no = "0400101";
                    break;
                case 204:
                    loc_no = "0500101";
                    break;
                default:
                    loc_no = "0000000";
                    break;
            }
            return loc_no;
        }

        /// <summary>
        /// 根据库位号获取对应输送机站点编号
        /// </summary>
        /// <param name="i_stn">堆垛机状态值</param>
        /// <returns>库位号</returns>
        public static int GetStnByLoc(string loc_no)
        {
            int i_stn = 0;
            switch (loc_no)
            {
                case "0200101":
                    i_stn = 100;
                    break;
                case "0300101":
                    i_stn = 104;
                    break;
                case "0400101":
                    i_stn = 200;
                    break;
                case "0500101":
                    i_stn = 204;
                    break;
                default:
                    i_stn = 0;
                    break;
            }
            return i_stn;
        }

        #region 堆垛机异常列表
        /// <summary>
        /// 根据堆垛机异常码得到异常名称
        /// </summary>
        /// <param name="AlarmCode">堆垛机异常码</param>
        /// <returns>堆垛机异常名称</returns>
        public static string GetCrnErrorName(int AlarmCode)
        {
            string errorName = "";
            switch (AlarmCode)
            {
                case 0:
                    errorName = "";
                    break;
                case 1:
                    errorName = "主电源断路器断开";
                    break;
                case 2:
                    errorName = "相位变化或缺相";
                    break;
                case 3:
                    errorName = "内部 24V 供电异常";
                    break;
                case 4:
                    errorName = "外部 24V 供电异常";
                    break;
                case 5:
                    errorName = "24V总断路器异常";
                    break;
                case 6:
                    errorName = "总交流接触器异常";
                    break;
                case 7:
                    errorName = "行走抱闸接触器异常";
                    break;
                case 8:
                    errorName = "起升抱闸接触器异常";
                    break;
                case 9:
                    errorName = "货叉抱闸接触器异常";
                    break;
                case 11:
                    errorName = "行走变频器报警";
                    break;
                case 12:
                    errorName = "起升变频器报警";
                    break;
                case 13:
                    errorName = "货叉变频器报警";
                    break;
                case 14:
                    errorName = "行走马达保护器异常";
                    break;
                case 15:
                    errorName = "起升马达保护器异常";
                    break;
                case 16:
                    errorName = "货叉马达保护器异常";
                    break;
                case 18:
                    errorName = "货叉位置错误";
                    break;
                case 19:
                    errorName = "货叉触发左极限";
                    break;
                case 20:
                    errorName = "货叉触发右极限";
                    break;
                case 21:
                    errorName = "载货台货物左后超限";
                    break;
                case 22:
                    errorName = "载货台货物左前超限";
                    break;
                case 23:
                    errorName = "载货台货物右后超限";
                    break;
                case 24:
                    errorName = "载货台货物右前超限";
                    break;
                case 25:
                    errorName = "载货台货物左坍塌";
                    break;
                case 26:
                    errorName = "载货台货物左超高";
                    break;
                case 27:
                    errorName = "行走电机位置值未变动";
                    break;
                case 28:
                    errorName = "起升电机位置值未变动";
                    break;
                case 29:
                    errorName = "载货台货物右超高";
                    break;
                case 30:
                    errorName = "货叉电机位置值未变动";
                    break;
                case 32:
                    errorName = "载货台货物右坍塌";
                    break;
                case 33:
                    errorName = "行走激光丢失";
                    break;
                case 34:
                    errorName = "行走停准失败";
                    break;
                case 35:
                    errorName = "起升激光丢失";
                    break;
                case 36:
                    errorName = "起升停准失败";
                    break;
                case 37:
                    errorName = "货叉测距异常";
                    break;
                case 38:
                    errorName = "货叉停准失败";
                    break;
                case 39:
                    errorName = "变频器总线IO通讯断开";
                    break;
                case 42:
                    errorName = "行走电机运行超时";
                    break;
                case 43:
                    errorName = "起升电机运行超时";
                    break;
                case 44:
                    errorName = "货叉电机运行超时";
                    break;
                case 45:
                    errorName = "载货台安全回路断开";
                    break;
                case 47:
                    errorName = "柜门急停";
                    break;
                case 49:
                    errorName = "松绳保护开关触发";
                    break;
                case 51:
                    errorName = "外部急停或安全门打开";
                    break;
                case 53:
                    errorName = "相序保护器异常";
                    break;
                case 54:
                    errorName = "安全继电器异常";
                    break;
                case 55:
                    errorName = "水平极限开关被触发";
                    break;
                case 56:
                    errorName = "起升下极限开关触发";
                    break;
                case 57:
                    errorName = "起升超速保护开关触发";
                    break;
                case 58:
                    errorName = "起升上极限开关触发";
                    break;
                case 61:
                    errorName = "放货时货架有货";
                    break;
                case 62:
                    errorName = "自动模式无任务载货台有货";
                    break;
                case 63:
                    errorName = "放货后载货台有货";
                    break;
                case 64:
                    errorName = "取货后载货台无货";
                    break;
                case 66:
                    errorName = "目标位置未找到";
                    break;
                case 67:
                    errorName = "输送机不允许取货/放货";
                    break;
                case 69:
                    errorName = "任务地址错误";
                    break;
                case 71:
                    errorName = "上一任务未完成警告";
                    break;
                case 75:
                    errorName = "上位机下发急停";
                    break;
                case 76:
                    errorName = "电控柜门打开";
                    break;
                case 85:
                    errorName = "载货台远程IO断开";
                    break;
                case 87:
                    errorName = "触摸屏急停";
                    break;
                case 101:
                    errorName = "货叉在中位没有中位开关信号";
                    break;
                case 102:
                    errorName = "货叉在非中位有中位信号";
                    break;
                default:
                    errorName = "未知";
                    break;
            }
            return errorName;
        }
        #endregion

    }
}