void DataTransferFinished(object sender, DataTransferFinishedArgs e) { if (nCount > 300) { richTextBox1.Text = ""; nCount = 0; } richTextBox1.Text = e.TransferMsg + "\n" + richTextBox1.Text; txtTestTime.Text = string.Format("{0:yyyy-MM-dd HH:mm:ss}", e.MaxTestDateTime.ToString()); txtFilePath.Text = e.TransferDbFile; timer1.Enabled = true; }
/// <summary> /// 将数据从Access数据库转移到MES数据库。 /// </summary> /// <param name="element">设备配置。</param> /// <returns>true:转置成功。false:转置失败。</returns> public void Execute(IVTestDeviceElement element, System.DateTime MaxTestDateTimeFromServer) { bool blTransferDataResult = true; string strTransferDataMsg = ""; dNewMaxTestTime = MaxTestDateTimeFromServer; dMaxUploadTestTime = MaxTestDateTimeFromServer; List <string> lstSqlForInsert = new List <string>(); List <string> lstSqlForUpdateIVDataDefault = new List <string>(); try { String _day = SqlHelper.ExecuteDataTable("select max(InspectTime) from ZWIP_COROL_TEST", connHost).Rows[0][0].ToString(); string _str = "select top 1 [LotSN] ,[InspectTime] ,[InspectResult] ,[InspectValue],[BlueValue],[Operator],[Shift],[RcpName],[LocalIp],[DeviceID] from t_ColorInspectResult where InspectTime > '" + _day + "'order by [InspectTime] "; DataTable d1t = SqlHelper.ExecuteDataTable(_str, connClient); if (d1t.Rows.Count > 0) { } else { strTransferDataMsg = string.Format("没有找到对应的COLOR数据文件{0} ", strAccessFullPath); blTransferDataResult = false; } DataTable dt = null; if (blTransferDataResult) { String _keysql = "select count(*) from ZWIP_COROL_TEST where LOT_NUMBER ='" + d1t.Rows[0]["LotSN"].ToString() + "'and InspectTime='" + d1t.Rows[0]["InspectTime"].ToString() + "'"; int _key = Convert.ToInt32(SqlHelper.ExecuteDataTable(_keysql, connHost).Rows[0][0]); if (_key == 0) { #region Builder Insert Sql StringBuilder sbsql = new StringBuilder(); sbsql.Append("INSERT INTO [ZWIP_COROL_TEST] ([LOT_NUMBER] ,[InspectTime] ,[InspctResult],[InspectValue] ,[BlueValue] ,[Opetator] ,[Shift] ,[RcpName] ,[LocalIp],[DeviceID] ,[DataTime])"); sbsql.Append("VALUES ( "); sbsql.Append("'" + d1t.Rows[0]["LotSN"].ToString() + "',"); sbsql.Append("'" + d1t.Rows[0]["InspectTime"].ToString() + "',"); sbsql.Append("'" + d1t.Rows[0]["InspectResult"].ToString() + "',"); sbsql.Append("'" + d1t.Rows[0]["InspectValue"].ToString() + "',"); sbsql.Append("'" + d1t.Rows[0]["BlueValue"].ToString() + "',"); sbsql.Append("'" + d1t.Rows[0]["Operator"].ToString() + "',"); sbsql.Append("'" + d1t.Rows[0]["Shift"].ToString() + "',"); sbsql.Append("'" + d1t.Rows[0]["RcpName"].ToString() + "',"); sbsql.Append("'" + d1t.Rows[0]["LocalIp"].ToString() + "',"); sbsql.Append("'" + d1t.Rows[0]["DeviceID"].ToString() + "',"); sbsql.Append("'" + DateTime.Now + "'"); sbsql.Append(" )"); string _str1 = sbsql.ToString(); SqlHelper.ExecuteNonQuery(_str1, connHost); sbsql.Clear(); //isDefault = false; #endregion } else { strTransferDataMsg = string.Format("{1:yyyy-MM-dd HH:mm:ss}数据已存在>{0} ", strTransferDataMsg, System.DateTime.Now.ToString()); } } } catch (Exception ex) { blTransferDataResult = false; strTransferDataMsg = ex.Message; } finally { lstSqlForInsert.Clear(); lstSqlForUpdateIVDataDefault.Clear(); } DataTransferFinishedArgs arg = new DataTransferFinishedArgs(); arg.TransferDataResult = blTransferDataResult; arg.TransferDbFile = strAccessFullPath; if (blTransferDataResult) { strTransferDataMsg = string.Format("{1:yyyy-MM-dd HH:mm:ss}上传Coler数据成功>{0} ", strTransferDataMsg, System.DateTime.Now.ToString()); arg.MaxTestDateTime = dNewMaxTestTime; } else { strTransferDataMsg = string.Format("{1:yyyy-MM-dd HH:mm:ss}上传Coler数据失败>{0} ", strTransferDataMsg, System.DateTime.Now.ToString()); arg.MaxTestDateTime = dMaxUploadTestTime; } arg.TransferMsg = strTransferDataMsg; if (OnDataTransferFinished != null) { OnDataTransferFinished(this, arg); } }