/// <summary> /// 初始化参数 /// </summary> private void Initialize() { sConFilePath = ConfigurationSettings.AppSettings["Config.FilePath"]; sLogFilePath = ConfigurationSettings.AppSettings["Log.FilePath"]; sServerName = ConfigurationSettings.AppSettings["ServerName"]; sSqlStr = ConfigurationSettings.AppSettings["SqlStr"]; iDataRefrTimes = int.Parse(ConfigurationSettings.AppSettings["DataRefrTimes"]); iSqlRefrTimes = int.Parse(ConfigurationSettings.AppSettings["SqlRefrTimes"]); bReConnect = bool.Parse(ConfigurationSettings.AppSettings["bReConnect"]); iReConnectTimes = int.Parse(ConfigurationSettings.AppSettings["ReConnectTimes"]); opcKepClient = new OPCClient(sLogFilePath); string[] sConFilePaths = sConFilePath.Split(new char[] { ';' }); foreach (string sConFilePath in sConFilePaths) { string[] sFlieNames = sConFilePath.Split(new char[] { '/' }, StringSplitOptions.RemoveEmptyEntries); string sFlieName = sFlieNames[sFlieNames.Length - 1]; sFlieName = sFlieName.Replace(".xlsx", ""); OPCItemsStruct OPCItemsStrt = new OPCItemsStruct(); OPCItemsStrt.sGroupName = sFlieName; DataSet dsOPCGroup = ExcelFunction.ExcelRead(sConFilePath); DataTable dtOPCGroup = dsOPCGroup.Tables[0]; int iRowCounts = dtOPCGroup.Rows.Count; OPCItemsStrt.sItems = new string[iRowCounts]; for (int i = 0; i < iRowCounts; i++) { if (dtOPCGroup.Rows[i][0] is System.DBNull == false) { OPCItemsStrt.sItems[i] = sFlieName + "." + dtOPCGroup.Rows[i][0].ToString(); } } lOPCItemsStrt.Add(OPCItemsStrt); } }