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();
}
}