private void dome()//完 成 { if (svstatus.Text == "Status:successful") { timer1.Enabled = false; panel2.Visible = false; pageset(); PB.Maximum = 100; PB.Value = 100; Perlabel.Text = "100%"; sendmessage($"Completed#{StationLab.Text}#{tempgvid}#{Perlabel.Text}"); label2.Text = "Model"; button4.Visible = false; string StrSql = $"exec sp_UpdateStationStatus '{StationLab.Text}'"; if (AdoInterface.InsertData(StrSql) == 0) { MessageBox.Show("数据库连接失败,无法更新状态!"); } label5.Text = "00:00"; label7.Text = "00:00"; } else { MessageBox.Show("服务端连接失败,请重试!"); Tryconnect(); } }
private void Form1_Load(object sender, EventArgs e) { UpdateClass.UpdateFrom("FCT-LED-Client"); this.Text = this.Text + "-" + Application.ProductVersion; label8.Text = "REV." + Application.ProductVersion; Station(); InitSocket(); modellist(); string Strsql = $"exec sp_Busy '{StationLab.Text}'"; string statusID = AdoInterface.Readstr(Strsql); if (statusID == "0") { pageset(); } else if (statusID == "1") { loadtempmodel(); button2_Click(sender, e); loadtime(); } cl = true; MouseMove += Form_MouseMove; MouseDown += Form_MouseDown; }
private void GridView_CellContentClick(object sender, DataGridViewCellEventArgs e)//gridview点击事件 { if (GridView.RowCount > 0) { if (e.ColumnIndex == 3) { if (svstatus.Text == "Status:successful") { if (bl) { string StrSql = null; if (GridView.CurrentRow.Cells["EntBut"].Value.ToString() != "完 成") { for (int i = 0; i < GridView.RowCount; i++) { if (GridView.Rows[i].Cells["EntBut"].Value.ToString() == "进行中...") { GridView.Rows[i].Cells["EntBut"].Value = "完 成"; GridView.Rows[i].Cells["bs"].Value = imageList1.Images[1]; StrSql =$"{StrSql} exec sp_UpdateTempStepStatus '{int.Parse(GridView.Rows[i].Cells["ID"].Value.ToString())}','完 成','{StationLab.Text.Trim()}';"; } } GridView.CurrentRow.Cells["EntBut"].Value = "进行中..."; GridView.CurrentRow.Cells["bs"].Value = imageList1.Images[0]; tempgvid = GridView.CurrentRow.Cells["ID"].Value.ToString(); timecalibration(); string str = $"Operational#{StationLab.Text}#{GridView.CurrentRow.Cells["ID"].Value.ToString()}#{Perlabel.Text}"; sendmessage(str); gmeg = str; StrSql = $"{StrSql} exec sp_UpdateTempStepStatus '{int.Parse(tempgvid)}','进行中...','{StationLab.Text.Trim()}';"; if (AdoInterface.InsertData(StrSql) == 0) { MessageBox.Show("数据库连接失败,无法更新状态!"); } sicconfig(int.Parse(GridView.CurrentRow.Cells["ID"].Value.ToString())); } else { MessageBox.Show("已经完成不可以再点"); } } else { MessageBox.Show("有异常信息在进行中"); } } else { Tryconnect(); } } } }
}//窗体移动 private void loadtempmodel()//加载临时Model { string StrSql = $"exec sp_TempModel '{StationLab .Text}'"; string str = AdoInterface.Readstr(StrSql); if (str != null) { label2.Text =str; } }
private void Station()//查询当前电脑绑定的Station { string Strsql = $"exec sp_Station_Find '{Dns.GetHostName()}'"; string str = AdoInterface.Readstr(Strsql); if (str != null) { StationLab.Text = str; } }
private void StationSetting_Load(object sender, EventArgs e) { string strsql = "exec sp_StationList"; DataSet ds = new DataSet(); ds = AdoInterface.GetDataSet(strsql); StationSetCombo.DataSource = ds.Tables[0]; StationSetCombo.DisplayMember = "Station"; }
private void FaFrm_Load(object sender, EventArgs e) { string Strsql = "exec sp_FailList"; DataSet ds = new DataSet(); ds = AdoInterface.GetDataSet(Strsql); comboBox1.DataSource = ds.Tables[0]; comboBox1.DisplayMember = "FailMessage"; AdoInterface.FrmfailMes = ""; }
private void modellist()//加载Model comlist数据 { string Strsql = $"exec sp_ModelList '{StationLab.Text}'"; DataSet ds = new DataSet(); ds = AdoInterface.GetDataSet(Strsql); if (ds != null) { Modelcombo.DataSource = ds.Tables[0]; Modelcombo.DisplayMember = "Model"; } }
private void ModelSave_Click(object sender, EventArgs e) { string StrSql = $"sp_UpdateStation '{StationSetCombo.Text }','{Dns.GetHostName()}'"; if (AdoInterface.InsertData(StrSql) == 1) { MessageBox.Show("Station绑定成功,请重新启动程序!"); Close(); Dispose(); Application.Exit(); } // Properties.Settings.Default.Station = StationSetCombo.Text; // Properties.Settings.Default.Save(); // Close(); }
private void rockontime()//进度条计时 { string StrSql = $"exec sp_QueryH '{label2.Text}'"; string str = AdoInterface.Readstr(StrSql); if (str != null) { int t = int.Parse(str); TimeSpan ts = new TimeSpan(0, t, 0); label7.Text = ts.Hours.ToString("00") + ":" + ts.Minutes.ToString("00"); PB.Maximum = t; PB.Value = t; num = 8; time1click(); timer1.Interval = 60000; timer1.Start(); } }
private void sicconfig(int id)//SIC调用接口 { string strsql = $"exec sp_sicconfigquery '{id}'"; DataSet ds = new DataSet(); ds = AdoInterface.GetDataSet(strsql); if (ds.Tables[0].Rows.Count >0) { INIHelper.Path = $"{Application.StartupPath.ToString()}\\ESIC_Client\\SICSetting.ini"; INIHelper.Write("setting", "Project", ds.Tables[0].Rows[0]["Project"].ToString()); INIHelper.Write("setting", "Category", ds.Tables[0].Rows[0]["Category"].ToString()); INIHelper.Write("setting", "Model", ds.Tables[0].Rows[0]["Model"].ToString()); INIHelper.Write("setting", "Side", ds.Tables[0].Rows[0]["Side"].ToString()); INIHelper.Write("setting", "Station", ds.Tables[0].Rows[0]["Station"].ToString()); FileStream fs = new FileStream($"{Application.StartupPath.ToString()}\\ESIC_Client\\SICStart.txt", FileMode.OpenOrCreate, FileAccess.ReadWrite); fs.Dispose(); fs.Close(); } }
private void loadtime()//加载剩余时间 { string StrSql = $"exec sp_LoadTime '{StationLab.Text}'"; string str = AdoInterface.Readstr(StrSql); if (str != null) { int t = int.Parse(str); if (t<PB.Value) { PB.Value = PB.Value - t; } else { Thread th = new Thread(loaddome); th.Start(); } } }
private void timer3_Tick(object sender, EventArgs e)//异常计时 { if (label3.Text != "") { yctime++; button3.Text = $"异 常 {yctime}"; } else { timer3.Enabled = false; button3.Text = "异 常"; string StrSql = $"exec sp_UpdateWaitingTime '{yctime}','{StationLab.Text}'"; if (AdoInterface.InsertData(StrSql) == 0) { MessageBox.Show("数据库连接失败,无法更新状态!"); } yctime = 0; } }
private void button2_Click(object sender, EventArgs e) { panel2.Width = 600; panel2.Height = 430; panel2.Top = 100; panel2.Left = 15; panel1.Visible = false; panel2.Visible = true; button4.Visible = true; if (label2.Text == "Model") { label2.Text = Modelcombo.Text; } string StrSql = $"exec sp_AssyStep '{label2.Text}','{StationLab.Text}'"; DataSet ds = new DataSet(); ds = AdoInterface.GetDataSet(StrSql); GridView.DataSource = ds.Tables[0]; for (int i = 0; i < GridView.Rows.Count ; i++) { if (GridView.Rows[i].Cells["EntBut"].Value.ToString() == "进行中...") { tempgvid = GridView.Rows[i].Cells["ID"].Value.ToString(); } switch (GridView.Rows[i].Cells["EntBut"].Value.ToString()) { case "进行中...": GridView.Rows[i].Cells["bs"].Value = imageList1.Images[0]; break; case "完 成": GridView.Rows[i].Cells["bs"].Value = imageList1.Images[1]; break; } } rockontime(); timecalibration(); }