public void DoUpdateRegs() { //Thread.Sleep(1000); //inputCommPortSingleton.GetInstance().initComm(); //if (false == inputCommPortSingleton.GetInstance().openComm()) //{ // btnStop_Click(null, null); //} //Random random = new Random(); while (m_updateDataFlg) { try { int ret = inputCommPortSingleton.GetInstance().readRegister(ref modbusRegs); if (ret != inputCommPortSingleton.RET_OK) { if (ret == inputCommPortSingleton.RET_TIMEOUT) { continue; } else { // set label communication error } break; } UpdateMainUIInvoke umi = new UpdateMainUIInvoke(UpdateUIData); while (!this.IsHandleCreated) { Thread.Sleep(100); } BeginInvoke(umi, modbusRegs); if (modbusRegs.stReg[CHECKFINISH].getHighReg() != 0 && !l_report_flg) { byte[] imageLeft = WindowManager.GetInstance().wrd1.getImageData(); //byte[] imageRight = WindowManager.GetInstance().wrd2.getImageData(); //Left room string sql1 = "insert into ModbusResultTable(room, TestDate, TestTime, TestResult, TestNo, Operator, [TestImage]) values('left','" + DateTime.Now + "', '" + textBoxTime0.Text + "', '" + coldfilterpoint0.ToString() + "', '" + textBoxNo0.Text + "', '" + textBoxOp0.Text + "', @imageLeft)"; OleDbParameter[] pars = new OleDbParameter[1]; OleDbParameter p = new OleDbParameter("@imageLeft", OleDbType.VarBinary, imageLeft.Length); p.Value = imageLeft; pars[0] = p; int i = AccessHelper.ExecuteNonQuery(AccessHelper.ConnString, sql1, pars); //Right room //string sql2 = "insert into ModbusResultTable(room, TestDate, TestTime, TestResult, TestNo, Operator, [TestImage]) values('right','" + DateTime.Now + "', '" + textBoxTime2.Text + "','" + coldfilterpoint1.ToString() + "', '" + textBoxNo2.Text + "', '" + textBoxOp2.Text + "', @imageRight)"; //OleDbParameter[] pars2 = new OleDbParameter[1]; // OleDbParameter p2 = new OleDbParameter("@imageRight", OleDbType.VarBinary, imageRight.Length); //p2.Value = imageRight; //pars2[0] = p2; //i = AccessHelper.ExecuteNonQuery(AccessHelper.ConnString, sql2, pars2); //stopUpdateRegs(); saveXMLFile(ROOMNUM_LEFT); saveExcelFile(ROOMNUM_LEFT); byte[] serverData = getAsciiData(coldfilterpoint0.ToString(), textBoxTime0.Text, textBoxNo0.Text, textBoxName0.Text, textBoxDevNo0.Text, textBoxOp0.Text); transResultToServer(serverData); //getAsciiData("", "", "", "", "", ""); l_report_flg = true; } if (modbusRegs.stReg[CHECKFINISH].getLowReg() != 0 && !r_report_flg) { //byte[] imageLeft = WindowManager.GetInstance().wrd1.getImageData(); byte[] imageRight = WindowManager.GetInstance().wrd2.getImageData(); //Left room //string sql1 = "insert into ModbusResultTable(room, TestDate, TestTime, TestResult, TestNo, Operator, [TestImage]) values('left','" + DateTime.Now + "', '" + textBoxTime1.Text + "', '" + coldfilterpoint0.ToString() + "', '" + textBoxNo1.Text + "', '" + textBoxOp1.Text + "', @imageLeft)"; //OleDbParameter[] pars = new OleDbParameter[1]; //OleDbParameter p = new OleDbParameter("@imageLeft", OleDbType.VarBinary, imageLeft.Length); //p.Value = imageLeft; //pars[0] = p; //int i = AccessHelper.ExecuteNonQuery(AccessHelper.ConnString, sql1, pars); //Right room string sql2 = "insert into ModbusResultTable(room, TestDate, TestTime, TestResult, TestNo, Operator, [TestImage]) values('right','" + DateTime.Now + "', '" + textBoxTime1.Text + "','" + coldfilterpoint1.ToString() + "', '" + textBoxNo1.Text + "', '" + textBoxOp1.Text + "', @imageRight)"; OleDbParameter[] pars2 = new OleDbParameter[1]; OleDbParameter p2 = new OleDbParameter("@imageRight", OleDbType.VarBinary, imageRight.Length); p2.Value = imageRight; pars2[0] = p2; int i = AccessHelper.ExecuteNonQuery(AccessHelper.ConnString, sql2, pars2); //stopUpdateRegs(); saveXMLFile(ROOMNUM_RIGHT); saveExcelFile(ROOMNUM_RIGHT); byte[] serverData = getAsciiData(coldfilterpoint1.ToString(), textBoxTime1.Text, textBoxNo1.Text, textBoxName1.Text, textBoxDevNo1.Text, textBoxOp1.Text); transResultToServer(serverData); r_report_flg = true; } Thread.Sleep(1000); } catch (Exception ex) { LogClass.GetInstance().WriteExceptionLog(ex); //MessageBox.Show(ex.ToString(), "Error - No Ports available", MessageBoxButtons.OK, MessageBoxIcon.Error); break; } } while (m_updateDataFlg) { try { Thread.Sleep(1000); } catch (Exception ex) { LogClass.GetInstance().WriteExceptionLog(ex); } } inputCommPortSingleton.GetInstance().closeComm(); }
public void RefreshData() { DataSet ds = new DataSet(); //dt = accdb.SelectToDataTable("select * from MyTable"); if (bSelectDateFlg) { string sql = "select ID, TestTime, TestResult, TestNo, Operator from ModbusResultTable where [room] = 'left' and [TestDate] between @start_datetime and @end_datetime"; OleDbParameter[] pars = new OleDbParameter[2]; OleDbParameter ps = new OleDbParameter("@start_datetime", OleDbType.Date); ps.Value = start_datetime; pars[0] = ps; OleDbParameter pe = new OleDbParameter("@end_datetime", OleDbType.Date); pe.Value = end_datetime; pars[1] = pe; ds = AccessHelper.ExecuteDataSet(AccessHelper.ConnString, sql, pars); } else { ds = AccessHelper.ExecuteDataSet(AccessHelper.ConnString, "select ID, TestTime, TestResult, TestNo, Operator from ModbusResultTable where [room] = 'left'", null); } dataGridView1.DataSource = ds.Tables[0].DefaultView; dataGridView1.AllowUserToAddRows = false;//datagridview dataGridView1.Columns[0].Visible = false; dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; DataSet ds2 = new DataSet(); //dt = accdb.SelectToDataTable("select * from MyTable"); if (bSelectDateFlg) { string sql = "select ID, TestTime, TestResult, TestNo, Operator from ModbusResultTable where [room] = 'right' and [TestDate] between @start_datetime and @end_datetime"; OleDbParameter[] pars = new OleDbParameter[2]; OleDbParameter ps = new OleDbParameter("@start_datetime", OleDbType.Date); ps.Value = start_datetime; pars[0] = ps; OleDbParameter pe = new OleDbParameter("@end_datetime", OleDbType.Date); pe.Value = end_datetime; pars[1] = pe; ds2 = AccessHelper.ExecuteDataSet(AccessHelper.ConnString, sql, pars); } else { ds2 = AccessHelper.ExecuteDataSet(AccessHelper.ConnString, "select ID, TestTime, TestResult, TestNo, Operator from ModbusResultTable where [room] = 'right'", null); } dataGridView2.DataSource = ds2.Tables[0].DefaultView; dataGridView2.AllowUserToAddRows = false;//datagridview dataGridView2.Columns[0].Visible = false; dataGridView2.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; dellist_left.Clear(); dellist_right.Clear(); //bDataLoaded = true; }