private void dgCl_KeyUp(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.Enter) { if (curRow >= 0) { if (dtCl.Rows[curRow]["WCFlag"].ToString() == "0") { if (dtCl.Rows[curRow]["KW"].ToString() != "") { dtCl.Rows[curRow]["WCFlag"] = 1; dtCl.Rows[curRow]["SCANTIME"] = System.DateTime.Now.ToString("yyyyMMddHHmmss"); SqlCe.ExecuteNonQuery("update ExportStorageAcceptOrder set WCFlag=1,SCANTIME='" + System.DateTime.Now.ToString("yyyyMMddHHmmss") + "' where CLH='" + dtCl.Rows[curRow]["CLH"].ToString() + "' and ZFH='" + dtCl.Rows[curRow]["ZFH"].ToString() + "' and JHH='" + dtCl.Rows[curRow]["JHH"].ToString() + "'"); PsionTeklogix.Sound.Beeper.Beeper.PlayTone(5000, 500, 100); } } else if (dtCl.Rows[curRow]["WCFlag"].ToString() == "1") { frmMessage frmMessage = new frmMessage(); frmMessage.ShowDialog("是否取消消帐材料" + dtCl.Rows[curRow]["CLH"].ToString(), "提示"); if (frmMessage.ret) { dtCl.Rows[curRow]["WCFlag"] = 0; dtCl.Rows[curRow]["SCANTIME"] = ""; SqlCe.ExecuteNonQuery("update ExportStorageAcceptOrder set WCFlag=0,SCANTIME='' where CLH='" + dtCl.Rows[curRow]["CLH"].ToString() + "' and ZFH='" + dtCl.Rows[curRow]["ZFH"].ToString() + "' and JHH='" + dtCl.Rows[curRow]["JHH"].ToString() + "'"); } } } } }
private void addCL(string clh) { for (int i = 0; i < dtCl.Rows.Count; i++) { if (isSameCLH(dtCl.Rows[i]["CLH2"].ToString(), clh)) { if (dtCl.Rows[i]["WCFlag"].ToString() == "0") { dtCl.Rows[i]["WCFlag"] = 1; dtCl.Rows[i]["SCANTIME"] = System.DateTime.Now.ToString("yyyyMMddHHmmss"); SqlCe.ExecuteNonQuery("update ExportStorageAcceptOrder set WCFlag=1,SCANTIME='" + System.DateTime.Now.ToString("yyyyMMddHHmmss") + "' where CLH='" + dtCl.Rows[i]["CLH"].ToString() + "' and ZFH='" + dtCl.Rows[i]["ZFH"].ToString() + "' and JHH='" + dtCl.Rows[i]["JHH"].ToString() + "'"); PsionTeklogix.Sound.Beeper.Beeper.PlayTone(5000, 500, 100); } else if (dtCl.Rows[i]["WCFlag"].ToString() == "1") { frmMessage frm = new frmMessage(); frm.ShowDialog("是否取消消帐材料" + clh, "提示"); if (frm.ret) { dtCl.Rows[i]["WCFlag"] = 0; dtCl.Rows[i]["SCANTIME"] = ""; SqlCe.ExecuteNonQuery("update ExportStorageAcceptOrder set WCFlag=0,SCANTIME='' where CLH='" + dtCl.Rows[i]["CLH"].ToString() + "' and ZFH='" + dtCl.Rows[i]["ZFH"].ToString() + "' and JHH='" + dtCl.Rows[i]["JHH"].ToString() + "'"); } frm.Dispose(); } break; } } }
private void sendFailTimer_Tick(object sender, EventArgs e) { sendFailTimer.Enabled = false; SqlCe.ExecuteNonQuery("update SendMsg set Lock=0 where Lock=1 and GramID<>'' and GramTime<>''"); sendFailTimer.Enabled = true; }
private void sendTimer_Tick(object sender, EventArgs e) { sendTimer.Enabled = false; if (Global.socketClient.Connected) { DataTable dt = SqlCe.ExecuteQuery("select * from SendMsg where Lock=0 and Done=0 order by SendTime "); if (dt.Rows.Count > 0) { string datagram = dt.Rows[0]["Msg"].ToString(); string id = dt.Rows[0]["ID"].ToString(); //if (datagram.IndexOf("ZDUA11") > 0)//清盘库信息更新 //{ // if (Business.msg.UnPackage(datagram)) // { // SqlCe.ExecuteNonQuery("update SendMsg set Lock=1,GramTime='" + Business.msg.ItemValue("fssj") + "',GramID='" + Business.msg.MessageID + "' where ID='" + id + "'"); // Global.socketClient.SendToSession(datagram); // } // else // { // SqlCe.ExecuteNonQuery("delete from SendMsg where ID='" + id + "'"); // } //} //else //{ Global.socketClient.SendToSession(datagram); SqlCe.ExecuteNonQuery("delete from SendMsg where ID='" + id + "'"); //} } dt.Dispose(); } sendTimer.Enabled = true; }
private void btnWagon_Click(object sender, EventArgs e) { string sql = "delete from wagon"; SqlCe.ExecuteNonQuery(sql); showWagon(); Business.SendText(Business.msg.Package("ZDWX59", Global.sKb)); btnWagon.Enabled = false; }
//changeByYang20170205 板坯材料号保存 public static void SaveCurrentSlabMaterials(string jhh, string clh) { string sql2 = "select * from ExpSlabPlan where CLH= '" + clh + "' and JHH= '" + jhh + "' "; DataTable dt = SqlCe.ExecuteQuery(sql2); if (dt.Rows.Count == 0) { string sql = "insert into ExpSlabPlan (JHH,CLH) values ('" + jhh + "','" + clh + "')"; SqlCe.ExecuteNonQuery(sql); } //string sql2 = "select CLH from ExpSlabPlan where CLH= '" + clh + "'"; //DataTable dt = SqlCe.ExecuteQuery(sql2); dt.Dispose(); }
public void OutStore() { string sql; for (int i = 0; i < dtCl.Rows.Count; i++) { if (dtCl.Rows[i]["WCFlag"].ToString() == "1") { sql = "update ExportStorageAcceptOrder set WCFlag=2 where CLH='" + dtCl.Rows[i]["CLH"].ToString() + "' and ZFH='" + dtCl.Rows[i]["ZFH"].ToString() + "' and JHH='" + dtCl.Rows[i]["JHH"].ToString() + "'"; SqlCe.ExecuteNonQuery(sql); } } LoadData(); Storage.UpdateExpWcjs(); //sql = "select A.JHH,A.ZFH,count(*) WCJS,sum(B.MZ) WCMZ,sum(B.JZ) WCJZ from ExportStorageOrder A,ExportStorageAcceptOrder B "; //sql += "where A.ZFH=B.ZFH and A.JHH=B.JHH and B.WCFlag=2 group by A.JHH,A.ZFH"; //DataTable dt = SqlCe.ExecuteQuery(sql); //for (int i = 0; i < dt.Rows.Count; i++) //{ // SqlCe.ExecuteNonQuery("update ExportStorageOrder set WCJS=" + dt.Rows[i]["WCJS"].ToString() + ",WCMZ=" + dt.Rows[i]["WCMZ"].ToString() + ",WCJZ=" + dt.Rows[i]["WCJZ"].ToString() + " where ZFH='" + dt.Rows[i]["ZFH"].ToString() + "' and JHH='" + dt.Rows[i]["JHH"].ToString() + "'"); //} //sql = "select A.JHH,sum(B.WCJS) WCJS,sum(B.WCMZ) WCMZ,sum(B.WCJZ) WCJZ from ExportStoragePlan A,ExportStorageOrder B "; //sql += "where A.JHH=B.JHH group by A.JHH"; //dt = SqlCe.ExecuteQuery(sql); //for (int i = 0; i < dt.Rows.Count; i++) //{ // SqlCe.ExecuteNonQuery("update ExportStoragePlan set WCJS=" + dt.Rows[i]["WCJS"].ToString() + ",WCMZ=" + dt.Rows[i]["WCMZ"].ToString() + ",WCJZ=" + dt.Rows[i]["WCJZ"].ToString() + " where JHH='" + dt.Rows[i]["JHH"].ToString() + "'"); //} //dt.Dispose(); //sql = "delete from ExportStorageAcceptOrder where exists(select * from ExportStoragePlan where JS=WCJS and JHH=ExportStorageAcceptOrder.JHH)"; //SqlCe.ExecuteNonQuery(sql); //sql = "delete from ExportStorageOrder where exists(select * from ExportStoragePlan where JS=WCJS and JHH=ExportStorageOrder.JHH)"; //SqlCe.ExecuteNonQuery(sql); //sql = "delete from ExportStoragePlan where JS=WCJS"; //SqlCe.ExecuteNonQuery(sql); }
public void GetUserInfResult(IAsyncResult ar) { WebService.Service ws = (WebService.Service)ar.AsyncState; try { string sql; string userid; string pwd; DataTable dt = new DataTable(); try { dt = ws.EndgetUserInf(ar); sql = "delete from userinf"; SqlCe.ExecuteNonQuery(sql); for (int i = 0; i < dt.Rows.Count; i++) { userid = dt.Rows[i]["USERID"].ToString(); pwd = dt.Rows[i]["PWD"].ToString(); sql = "insert into userinf (USERID,PWD) values('" + userid + "','" + pwd + "')"; SqlCe.ExecuteNonQuery(sql); } frmMessage frmMessage = new frmMessage(); frmMessage.ShowDialog("用户资料库已更新!", "提示", "确定"); frmMessage.Dispose(); } catch (Exception e) { System.Diagnostics.Debug.WriteLine(e.Message); } finally { dt.Dispose(); } } catch { } finally { ws.Dispose(); } }
public void InStore() { string sql; for (int i = 0; i < dtCl.Rows.Count; i++) { if (dtCl.Rows[i]["WCFlag"].ToString() == "1") { sql = "update ImportStorageAcceptOrder set WCFlag=2 where CLH='" + dtCl.Rows[i]["CLH"].ToString() + "' and ZFH='" + dtCl.Rows[i]["ZFH"].ToString() + "' and JHH='" + dtCl.Rows[i]["JHH"].ToString() + "' and Make='" + dtCl.Rows[i]["Make"].ToString() + "'"; SqlCe.ExecuteNonQuery(sql); sql = "update ExportStorageAcceptOrder set KW='" + Global.sKb + dtCl.Rows[i]["KW"].ToString() + "' where CLH='" + dtCl.Rows[i]["CLH"].ToString() + "' and ZFH='" + dtCl.Rows[i]["ZFH"].ToString() + "' and Make='" + dtCl.Rows[i]["Make"].ToString() + "'"; SqlCe.ExecuteNonQuery(sql); } } LoadData(); Storage.UpdateImpWcjs(); }
private void ScanExpCoilResult(CoilPoint p, string text, string scantime, DataTable dt) { //curcoil = new Coil(p, text); int scanflag = 0; string zzdy = ""; //制造单元 if (dt.Rows.Count > 0) { scanflag = 1; zzdy = dt.Rows[0]["Make"].ToString(); } if (Global.coils.ContainsKey(p)) { Global.coils[p].scanflag = scanflag; Global.coils[p].scantime = scantime; //Global.coils[p].clh = text; Global.coils[p].zzdy = zzdy; } //else //{ // curcoil.scanflag = scanflag; // curcoil.scantime = scantime; // curcoil.zzdy = zzdy; // Global.coils.Add(p, curcoil); //} //if (text.Length > 8) //{ // dtFrame.Rows[p.row][p.col] = text.Substring(text.Length - 8, 8); //} //else //{ // dtFrame.Rows[p.row][p.col] = text; //} //dataGrid1.DataSource = dtFrame; dataGrid2.Invalidate(); if (scanflag == 1) { PsionTeklogix.Sound.Beeper.Beeper.PlayTone(5000, 500, 100); string sql = "update exportstorageacceptorder set scantime='" + scantime + "', wcflag=1 where clh2='" + text + "'"; SqlCe.ExecuteNonQuery(sql); } }
//private void txtKb_KeyUp(object sender, KeyEventArgs e) //{ // if (e.KeyCode >= Keys.A && e.KeyCode <= Keys.Z) // { // txtHch.Text = txtHch.Text.ToUpper(); // txtHch.SelectionStart = txtHch.Text.Length; // } //} private void recvTimer_Tick(object sender, EventArgs e) { recvTimer.Enabled = false; string sql = "select * from RecvMsg where Lock=0 and Done=0 order by RecvTime"; DataTable dt = SqlCe.ExecuteQuery(sql); string DataGram = ""; //##0109UAZD02S0301;B232;20;43900;1500;N;2;;;;43900;7800;2400;1700;780;C9;;;;43900;10000;2400;1700;780;C99999@@ string id = ""; for (int i = 0; i < dt.Rows.Count; i++) { DataGram = dt.Rows[i]["Msg"].ToString(); id = dt.Rows[i]["ID"].ToString(); Global.RecvData(DataGram); SqlCe.ExecuteNonQuery("delete RecvMsg where ID='" + id + "'"); } dt.Dispose(); recvTimer.Enabled = true; }
private void btnQd_Click(object sender, EventArgs e) { if (Global.sUserId != "") { frmMain frmMain = new frmMain(); Global.frmCurrent = frmMain; frmMain.Owner = this; frmMain.Show(); this.Hide(); return; } if (txtGh.Text == "") { new frmMessage().ShowDialog("请输入工号!", "提示"); return; } if (txtGh.Text != "BS") { if (txtMm.Text == "") { new frmMessage().ShowDialog("请输入密码!", "提示"); return; } } if (cboBb.SelectedIndex == -1) { new frmMessage().ShowDialog("请选择班别!", "提示"); return; } if (cboZyq.SelectedIndex == -1) { new frmMessage().ShowDialog("请选择作业区!", "提示"); return; } string sGh = txtGh.Text; string sMm = txtMm.Text; string sBb = ""; if (cboBb.Text == "白") { sBb = "22"; } else if (cboBb.Text == "夜") { sBb = "21"; } string sZyq = cboZyq.Text; if (cboZyq.Text == "甲") { sZyq = "1"; } else if (cboZyq.Text == "乙") { sZyq = "2"; } else if (cboZyq.Text == "丙") { sZyq = "3"; } else if (cboZyq.Text == "丁") { sZyq = "4"; } if (sGh != "BS") { string sql = "select PWD from UserInf where UserID='" + sGh + "'"; DataTable dt = SqlCe.ExecuteQuery(sql); if (dt.Rows.Count > 0) { if (dt.Rows[0]["PWD"].ToString() == sMm) { Global.sUserId = sGh; Global.sPassword = sMm; Global.sBb = sBb; Global.sZyq = sZyq; } } dt.Dispose(); if (Global.sUserId != "")//登陆成功 { sql = "insert into UserLogin (UserID,Class,StartTime) values ("; sql += "'" + sGh + "',"; sql += "'" + sBb + "',"; //sql += "'" + sHch + "',"; sql += "'" + System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "'"; sql += ")"; SqlCe.ExecuteNonQuery(sql); //Business.SaveConfig(Global.appPath + @"\config.xml", sHch); //Global.sHch = sHch; } else { new frmMessage().ShowDialog("工号或者密码错误!", "提示"); } if (Global.sUserId != "") { if (Global.sDebug == "False") { Business.SendText(Business.msg.Package("ZDUA09", System.DateTime.Today.ToString("yyyyMMdd") + ";" + sBb + ";" + sGh + ";" + sZyq + ";" + System.DateTime.Now.ToString("yyyyMMddHHmmss"))); } frmMain frmMain = new frmMain(); Global.frmCurrent = frmMain; frmMain.Owner = this; frmMain.Show(); this.Hide(); } } else { Global.sUserId = sGh; Global.sPassword = sMm; Global.sBb = sBb; Global.sZyq = sZyq; frmMain frmMain = new frmMain(); Global.frmCurrent = frmMain; frmMain.Owner = this; frmMain.Show(); this.Hide(); } }