private void frmFrameIn_Load(object sender, EventArgs e)
{
if (ScanCodeRemapping.NormalTable.Contains(0x003A))
{
ScanCodeRemapping.NormalTable.Remove(0x003A);
}
Global.storage.kjh = "";
string sql = "select CLH,WZ,substring(KW,4,len(KW)-3) KW,Height+'×'+Width+'×'+Long GG,MZ,WCFlag,SCANTIME,ZFH,TDH,Make,CH,QA,'0' ExFlag from FrameDetail where 1=2";
dtCl = SqlCe.ExecuteQuery(sql);
dgCl.DataSource = dtCl;
dgCl.TableStyles.Clear();
DataGridTableStyle clStyle = new DataGridTableStyle();
clStyle.MappingName = dtCl.TableName;
CheckCellEventHandler cellEvent = new CheckCellEventHandler(CheckCellColor);
clStyle.GridColumnStyles.Add(new ColumnStyle(0, "CLH", "材料号", 110, "", cellEvent));
clStyle.GridColumnStyles.Add(new ColumnStyle(1, "KW", "库位", 50, "", cellEvent));
clStyle.GridColumnStyles.Add(new ColumnStyle(2, "ZFH", "准发号", 100, "", cellEvent));
clStyle.GridColumnStyles.Add(new ColumnStyle(3, "WZ", "库别", 40, "", cellEvent));
clStyle.GridColumnStyles.Add(new ColumnStyle(4, "GG", "规格", 40, "", cellEvent));
clStyle.GridColumnStyles.Add(new ColumnStyle(5, "MZ", "毛重", 50, "", cellEvent));
clStyle.GridColumnStyles.Add(new ColumnStyle(6, "CH", "层号", 50, "", cellEvent));
curRow = -1;
dgCl.TableStyles.Add(clStyle);
}
private void btnResearch_Click(object sender, EventArgs e)
{
if (txtClh.Text == "")
{
return;
}
string sql = "select A.JHH,B.ZFH,B.PM,B.JZ,B.MZ,B.Height + '×' + B.Width + '×' + B.Long GG,";
sql += "B.KW,A.JHDD,A.SHDW,A.YSFS,A.CM from ExportStoragePlan A,ExportStorageAcceptOrder B ";
sql += "where A.JHH=B.JHH and A.MAKE=B.MAKE ";
sql += "and B.CLH='" + txtClh.Text + "'";
DataTable dt = SqlCe.ExecuteQuery(sql);
if (dt.Rows.Count > 0)
{
lblInfo.Text = "计划号：" + dt.Rows[0]["JHH"].ToString() + "\r\n";
lblInfo.Text += "准发号：" + dt.Rows[0]["ZFH"].ToString() + "\r\n";
lblInfo.Text += "品名：" + dt.Rows[0]["PM"].ToString() + "\r\n";
lblInfo.Text += "净重：" + dt.Rows[0]["JZ"].ToString() + "\r\n";
lblInfo.Text += "毛重：" + dt.Rows[0]["MZ"].ToString() + "\r\n";
lblInfo.Text += "规格：" + dt.Rows[0]["GG"].ToString() + "\r\n";
lblInfo.Text += "库位：" + dt.Rows[0]["KW"].ToString() + "\r\n";
lblInfo.Text += "交货地点：" + dt.Rows[0]["JHDD"].ToString() + "\r\n";
lblInfo.Text += "收货单位：" + dt.Rows[0]["SHDW"].ToString() + "\r\n";
lblInfo.Text += "运输方式：" + dt.Rows[0]["YSFS"].ToString() + "\r\n";
lblInfo.Text += "船名：" + dt.Rows[0]["CM"].ToString() + "\r\n";
}
else
{
lblInfo.Text = "";
}
}
private void txtClh_KeyUp(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Escape)
{
lblClh.Visible = false;
txtClh.Visible = false;
return;
}
if (e.KeyCode >= Keys.A && e.KeyCode <= Keys.Z)
{
txtClh.Text = txtClh.Text.ToUpper();
txtClh.SelectionStart = txtClh.Text.Length;
}
if (e.KeyCode == Keys.Enter)
{
if (txtClh.Text.Length >= 9)
{
addResult(txtClh.Text, "");
//changeByYang20170526
}
txtClh.Text = "";
lblClh.Visible = false;
txtClh.Visible = false;
}
if (txtClh.Text.Length >= 5)
{
string sql = "";
if (Global.curFrame.KZ == "重")//入库作业
{
//匹配后5位
sql = "SELECT CLH FROM ExpSlabPlan WHERE (CLH LIKE '%" + txtClh.Text + "') ";
}
else
{
sql = "SELECT CLH FROM ExpSlabPlan WHERE (CLH LIKE '%" + txtClh.Text + "') ";
}
DataTable dt = SqlCe.ExecuteQuery(sql);
if (dt.Rows.Count == 1)
{
txtClh.Text = dt.Rows[0]["CLH"].ToString();
txtClh.SelectionStart = txtClh.Text.Length;
}
else if (dt.Rows.Count > 1)
{
lstClh.Items.Clear();
for (int i = 0; i < dt.Rows.Count; i++)
{
lstClh.Items.Add(dt.Rows[i]["CLH"].ToString());
}
lstClh.Visible = true;
//yt20170526
}
dt.Dispose();
}
}
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 loadFrameLayout10(string sFrameID)
{
string sql = "select Location,CLH,RKB,SteelDiameter from FrameLayout where FrameID='" + sFrameID + "' and Mold='10'";
DataTable dt = SqlCe.ExecuteQuery(sql);
for (int i = 0; i < dt.Rows.Count; i++)
{
if (dt.Rows[i]["Location"].ToString().Length == 7)
{
string clh = dt.Rows[i]["CLH"].ToString();
if (!clh.Equals(""))
{
CoilPoint p = new CoilPoint(sFrameID, dt.Rows[i]["Location"].ToString());
if (clh.Length > 8)
{
dtFrame.Rows[p.row][p.col] = clh.Substring(clh.Length - 8, 8);
}
else
{
dtFrame.Rows[p.row][p.col] = clh;
}
Coil coil = new Coil(p, clh);
coil.kb = dt.Rows[i]["RKB"].ToString();
coil.diameter = dt.Rows[i]["SteelDiameter"].ToString();
Global.coils.Add(p, coil);
}
}
}
dt.Dispose();
}
public void LoadData()
{
lblInfo.Text = "计划号：" + m_jhh + "\r\n";
lblInfo.Text += "入库别：" + m_rkb + "\r\n";
string sql = "select B.JHH,B.ZFH,B.CLH,B.CLH2,B.MZ,B.JZ,substring(B.KW,4,8) KW,";
sql += "B.Height+'×'+B.Width+'×'+B.Long GG,";
sql += "B.WCFlag,B.SCANTIME from ";
sql += "ExportStorageOrder A,ExportStorageAcceptOrder B where A.ZFH=B.ZFH and (B.WCFlag is null or B.WCFlag<>2) ";
switch (m_cltype)
{
case 0:
lblInfo.Text += "准发号：" + m_zfh;
sql += "and A.ZFH='" + m_zfh + "'";
break;
case 1:
lblInfo.Text += "炉号：" + m_lh;
sql += "and B.LH='" + m_lh + "'";
break;
case 2:
lblInfo.Text += "合同号：" + m_hth;
sql += "and A.HTH='" + m_hth + "'";
break;
case 3:
lblInfo.Text += "扎批号：" + m_zph;
sql += "and substring(B.CLH,1,6)='" + m_zph + "'";
break;
default:
break;
}
dtCl = SqlCe.ExecuteQuery(sql);
curRow = -1;
dgCl.DataSource = dtCl;
dgCl.TableStyles.Clear();
DataGridTableStyle clStyle = new DataGridTableStyle();
clStyle.MappingName = dtCl.TableName;
CheckCellEventHandler cellEvent = new CheckCellEventHandler(CheckCellColor);
clStyle.GridColumnStyles.Add(new ColumnStyle(0, "CLH", "材料号", 100, "", cellEvent));
clStyle.GridColumnStyles.Add(new ColumnStyle(1, "KW", "库位", 70, "", cellEvent));
clStyle.GridColumnStyles.Add(new ColumnStyle(2, "MZ", "毛重", 60, "", cellEvent));
clStyle.GridColumnStyles.Add(new ColumnStyle(3, "JZ", "净重", 60, "", cellEvent));
clStyle.GridColumnStyles.Add(new ColumnStyle(4, "GG", "规格", 170, "", cellEvent));
dgCl.TableStyles.Add(clStyle);
}
public void LoadData()
{
lblJhh.Text = "提单号：" + m_jhh;
string sql = "select B.JHH,B.ZFH,B.CLH,B.CLH2,B.MZ,B.JZ,substring(B.KW,4,len(B.KW)-3) KW,";
sql += "B.Height+'×'+B.Width+'×'+B.Long GG,";
sql += "B.WCFlag,B.SCANTIME from ";
sql += "ExportStorageOrder A,ExportStorageAcceptOrder B where A.ZFH=B.ZFH and A.JHH=B.JHH and (B.WCFlag is null or B.WCFlag<>2) and B.KW<>'' ";
sql += "and B.CKB='" + Global.sKb + "' and A.JHH like '1%' ";
sql += "and A.JHH='" + m_jhh + "' ";
switch (m_cltype)
{
case 0:
sql += "and A.ZFH='" + m_zfh + "'";
lblZfh.Text += "准发号：" + m_zfh;
break;
case 1:
sql += "and B.LH='" + m_lh + "'";
lblZfh.Text += "炉号：" + m_lh;
break;
case 2:
sql += "and A.HTH='" + m_hth + "'";
lblZfh.Text += "合同号：" + m_hth;
break;
case 3:
lblZfh.Text += "扎批号：" + m_zph;
sql += "and substring(B.CLH,1,6)='" + m_zph + "'";
break;
default:
break;
}
dtOut = SqlCe.ExecuteQuery(sql);
curRow = -1;
dgOut.DataSource = dtOut;
dgOut.TableStyles.Clear();
DataGridTableStyle outStyle = new DataGridTableStyle();
outStyle.MappingName = dtOut.TableName;
CheckCellEventHandler cellEvent = new CheckCellEventHandler(CheckCellColor);
outStyle.GridColumnStyles.Add(new ColumnStyle(0, "CLH", "材料号", 100, "", cellEvent));
outStyle.GridColumnStyles.Add(new ColumnStyle(1, "KW", "库位", 60, "", cellEvent));
outStyle.GridColumnStyles.Add(new ColumnStyle(2, "MZ", "毛重", 60, "", cellEvent));
outStyle.GridColumnStyles.Add(new ColumnStyle(3, "JZ", "净重", 60, "", cellEvent));
outStyle.GridColumnStyles.Add(new ColumnStyle(4, "GG", "规格", 150, "", cellEvent));
dgOut.TableStyles.Add(outStyle);
RefreshJS();
}
private void LoadData()
{
string sql = "select CLH,'" + Global.sKb + "' WZ,substring(KW,4,len(KW)-3) KW,Height+'×'+Width+'×'+Long GG, MZ,ZFH,JHH,Make,WCFlag,SCANTIME,QA,'0' ExFlag from ImportStorageAcceptOrder where WCFlag=1 ";
if (Global.storage.jhh != "")
{
sql += " and JHH='" + Global.storage.jhh + "' and Make='" + Global.storage.make + "'";
}
dtCl = SqlCe.ExecuteQuery(sql);
dgCl.DataSource = dtCl;
curRow = -1;
}
private void txtClh_KeyUp(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Escape)
{
lblClh.Visible = false;
txtClh.Visible = false;
return;
}
if (e.KeyCode >= Keys.A && e.KeyCode <= Keys.Z)
{
txtClh.Text = txtClh.Text.ToUpper();
txtClh.SelectionStart = txtClh.Text.Length;
}
if (e.KeyCode == Keys.Enter)
{
//old if (txtClh.Text.Length >= 9)
if (txtClh.Text.Length >= 6)
{
addCl(txtClh.Text);
}
txtClh.Text = "";
lblClh.Visible = false;
txtClh.Visible = false;
}
if (txtClh.Text.Length >= 5)
{
string sql = "SELECT CLH2 FROM ExportStorageAcceptOrder WHERE (CLH2 LIKE '%" + txtClh.Text + "') ";
sql += " UNION ";
sql += "SELECT CLH2 FROM ImportStorageAcceptOrder WHERE (CLH2 LIKE '%" + txtClh.Text + "')";
DataTable dt = SqlCe.ExecuteQuery(sql);
if (dt.Rows.Count == 1)
{
txtClh.Text = dt.Rows[0]["CLH2"].ToString();
txtClh.SelectionStart = txtClh.Text.Length;
}
else if (dt.Rows.Count > 1)
{
lstClh.Items.Clear();
for (int i = 0; i < dt.Rows.Count; i++)
{
lstClh.Items.Add(dt.Rows[i]["CLH2"].ToString());
}
lstClh.Visible = true;
}
dt.Dispose();
}
}
//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();
}
private void txtClh_KeyUp(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Escape)
{
return;
}
if (e.KeyCode >= Keys.A && e.KeyCode <= Keys.Z)
{
txtClh.Text = txtClh.Text.ToUpper();
txtClh.SelectionStart = txtClh.Text.Length;
}
if (e.KeyCode == Keys.Enter)
{
if (txtClh.Text.Length > 0)
{
addCL(txtClh.Text);
txtClh.Text = "";
}
}
if (txtClh.Text.Length == 5)
{
string sql = "select CLH2 from ImportStorageAcceptOrder where (WCFlag is null or WCFlag<>2) and CLH2 like '%" + txtClh.Text + "' and RKB='" + Global.sKb + "'";
if (Global.storage.jhh != "")
{
sql += " and JHH='" + Global.storage.jhh + "' and Make='" + Global.storage.make + "'";
}
DataTable dt = SqlCe.ExecuteQuery(sql);
if (dt.Rows.Count == 1)
{
txtClh.Text = dt.Rows[0]["CLH2"].ToString();
txtClh.SelectionStart = txtClh.Text.Length;
}
else if (dt.Rows.Count > 1)
{
lstCLH.Items.Clear();
for (int i = 0; i < dt.Rows.Count; i++)
{
lstCLH.Items.Add(dt.Rows[i]["CLH2"].ToString());
}
lstCLH.Visible = true;
}
dt.Dispose();
}
}
private void txtClh_KeyUp(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Escape)
{
return;
}
if (e.KeyCode >= Keys.A && e.KeyCode <= Keys.Z)
{
txtClh.Text = txtClh.Text.ToUpper();
txtClh.SelectionStart = txtClh.Text.Length;
}
if (e.KeyCode == Keys.Enter)
{
if (txtClh.Text.Length > 0)
{
addCL(txtClh.Text);
}
}
if (txtClh.Text.Length == 5)
{
string sql = "select A.CLH from FrameDetail A left join ImportStorageAcceptOrder B on A.CLH=B.CLH and A.Make=B.Make and (B.WCFlag is null or B.WCFlag<>2) and B.RKB='" + Global.sKb + "' ";
sql += "where A.KJH='" + Global.storage.kjh + "' and A.CLH like '%" + txtClh.Text + "' ";
DataTable dt = SqlCe.ExecuteQuery(sql);
if (dt.Rows.Count == 1)
{
txtClh.Text = dt.Rows[0]["CLH"].ToString();
txtClh.SelectionStart = txtClh.Text.Length;
}
else if (dt.Rows.Count > 1)
{
lstCLH.Items.Clear();
for (int i = 0; i < dt.Rows.Count; i++)
{
lstCLH.Items.Add(dt.Rows[i]["CLH"].ToString());
}
lstCLH.Visible = true;
}
dt.Dispose();
}
}
private DataTable SearchExpCoil(string text)
{
DataTable dt = new DataTable();
string sql = "select CLH,Make,QA from ExportStorageAcceptOrder where (WCFlag is null or WCFlag<>2) and CKB='" + Global.sKb + "' ";
if (text.Length == 9 || text.Length == 10)
{
sql += "and (CLH2='" + text + "' or ( len(CLH2)=11 and charindex('" + text + "',CLH2)>0 ) ) ";
}
else
{
sql += "and CLH2='" + text + "'";
}
dt = SqlCe.ExecuteQuery(sql);
return(dt);
}
private void dgTl_CurrentCellChanged(object sender, EventArgs e)
{
curRow = dgTl.CurrentCell.RowNumber;
txtWcjs.Text = dtTl.Rows[curRow]["WCJS"].ToString();
txtWcmz.Text = dtTl.Rows[curRow]["WCMZ"].ToString();
string sql = "select count(*) JS,sum(MZ) MZ from ExportStorageAcceptOrder ";
sql += "where JHH='" + dtTl.Rows[curRow]["JHH"].ToString() + "' and KW<>'' and (WCFlag is Null or WCFlag<>2)";
DataTable dt = SqlCe.ExecuteQuery(sql);
if (dt.Rows.Count > 0)
{
txtDdjs.Text = dt.Rows[0]["JS"].ToString();
txtDdmz.Text = dt.Rows[0]["MZ"].ToString();
}
dt.Dispose();
dgTl.Select(dgTl.CurrentCell.RowNumber);
}
private void txtKjh_KeyUp(object sender, KeyEventArgs e)
{
if (e.KeyCode >= Keys.D0 && e.KeyCode <= Keys.Z)
{
txtKjh.Text = txtKjh.Text.ToUpper();
txtKjh.SelectionStart = txtKjh.Text.Length;
if (Global.storage.expflag == "tl")
{
lstWagon.Items.Clear();
string sql = "select * from wagon where wagon like '" + txtKjh.Text + "%' and finish='K' and isused='Y' and kb='" + Global.sKb + "'";
DataTable dt = SqlCe.ExecuteQuery(sql);
for (int i = 0; i < dt.Rows.Count; i++)
{
lstWagon.Items.Add(dt.Rows[i]["wagon"].ToString());
}
if (dt.Rows.Count > 0) lstWagon.Visible = true;
dt.Dispose();
}
}
}
//bool key = false;
//int pageSize = 0; //每页显示行数
//int nMax = 0; //总记录数
//int pageCount = 0; //页数=总记录数/每页显示行数
//int pageCurrent = 0; //当前页号
//int nCurrent = 0; //当前记录行
private void LoadPlan()
{
string sql = "select SX,HCH,KJH,CLH,MDD from TaskOrder ";
if (Global.curFrame != null)
{
if (Global.curFrame.HCH != "")
{
sql += "where HCH='" + Global.curFrame.HCH + "'";
}
else
{
sql += "where 1=2 ";
}
}
dtJhzy = SqlCe.ExecuteQuery(sql);
dgSxChange.DataSource = dtJhzy;
dgSxChange.TableStyles.Clear();
DataGridTableStyle SxchangeStyle = new DataGridTableStyle();
SxchangeStyle.MappingName = dtJhzy.TableName;
CheckCellEventHandler cellEvent = new CheckCellEventHandler(CheckCellColor);
SxchangeStyle.GridColumnStyles.Add(new ColumnStyle(0, "SX", "顺序", 50, "", cellEvent));
SxchangeStyle.GridColumnStyles.Add(new ColumnStyle(1, "KJH", "框架号", 60, "", cellEvent));
SxchangeStyle.GridColumnStyles.Add(new ColumnStyle(2, "CLH", "材料号", 120, "", cellEvent));
SxchangeStyle.GridColumnStyles.Add(new ColumnStyle(3, "MDD", "目的地", 120, "", cellEvent));
dgSxChange.TableStyles.Add(SxchangeStyle);
if (Global.curFrame.HCH != "")
{
lblTitle.Text = Global.curFrame.HCH + "#行车作业指令";
}
curRow = -1;
}
//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 getKJInfo(string kjh)
{
string sql = "select * from Frame where FrameID='" + kjh + "'";
DataTable dt = SqlCe.ExecuteQuery(sql);
if (dt.Rows.Count == 0)
{
sZZ = "";
iMaxRow = 0;
iSpace = 0;
frmMessage frmMessage = new frmMessage();
frmMessage.ShowDialog("未找到框架号为：" + kjh + "的框架信息！", "提示", "确定");
frmMessage.Dispose();
}
else
{
sZZ = dt.Rows[0]["Weight"].ToString();
if (dt.Rows[0]["FrameCount"] != DBNull.Value)
{
iMaxRow = Convert.ToInt32(dt.Rows[0]["FrameCount"]);
}
else
{
iMaxRow = 0;
}
if (dt.Rows[0]["Space"] != DBNull.Value)
{
iSpace = Convert.ToInt32(dt.Rows[0]["Space"]);
}
else
{
iSpace = 0;
}
}
}
public void showWagon()
{
Global.UIThread(lstWagon, delegate {
lstWagon.Items.Clear();
string sql = "select * from wagon where kb='" + Global.sKb + "'";
DataTable dt = SqlCe.ExecuteQuery(sql);
for (int i = 0; i < dt.Rows.Count; i++)
{
if (dt.Rows[i]["isused"].ToString() == "N")
{
lstWagon.Items.Add(dt.Rows[i]["wagon"].ToString() + " 色牌");
}
else if (dt.Rows[i]["finish"].ToString() == "Z")
{
lstWagon.Items.Add(dt.Rows[i]["wagon"].ToString() + " 重车");
}
else
{
lstWagon.Items.Add(dt.Rows[i]["wagon"].ToString() + " 空车");
}
}
dt.Dispose();
});
}
private void btnSend_Click(object sender, EventArgs e)
{
frmMessage frmMessage = new frmMessage();
frmMessage.ShowDialog("是否需要发送出库消帐电文？", "提示", "是", "否");
bool ret = frmMessage.ret;
frmMessage.Dispose();
if (ret)
{
lblInfo.Text = "发送中...";
btnSend.Enabled = false;
Global.sKjh = txtKjh.Text;
Global.sDq = cboDq.SelectedIndex;
string data = System.DateTime.Now.ToString("yyyyMMddHHmmss") + ";";
data += Global.sBb + ";";
data += Global.sKb + ";";
data += Global.sUserId + ";";
data += txtJxh.Text + ";";
data += cboDq.Text + txtKjh.Text + ";";
data += ";";
data += ";";
if (cboPcbj.SelectedIndex == 0)
{
data += "N;";
}
else
{
data += "Y;";
}
data += Global.sZyq + ";";
data += ";";//直装标志 0,1
string sql = "select * from ExportStorageAcceptOrder where CLH in (" + clhs + ") order by ZFH ";
DataTable dt = SqlCe.ExecuteQuery(sql);
string gram = "";
string zfh = "";
if (dt.Rows.Count > 0)
{
zfh = dt.Rows[0]["ZFH"].ToString();
}
for (int i = 0; i < dt.Rows.Count; i++)
{
if (zfh != dt.Rows[i]["ZFH"].ToString())
{
gram = gram.Substring(0, gram.Length - 1);
Business.SendText(Business.msg.Package("ZDWX56", data + gram));
gram = "";
zfh = dt.Rows[i]["ZFH"].ToString();
}
gram += dt.Rows[i]["CLH"].ToString() + ";" + dt.Rows[i]["SCANTIME"].ToString() + ";";
}
if (dt.Rows.Count > 0)
{
gram = gram.Substring(0, gram.Length - 1);
Business.SendText(Business.msg.Package("ZDWX56", data + gram));
}
dt.Dispose();
Business.InvokeMethod(this.Owner, "OutStore", new object[] { });
lblInfo.Text = "发送成功！";
Global.frmCurrent = this.Owner;
this.Owner.Show();
this.Owner = null;
this.Close();
}
}
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();
}
}
private void addCL(string barcode)
{
string sql = "select CLH,substring(KW,4,len(KW)-3) KW,MZ,ZFH,Height,Width,Long,JHH,Make,QA from ImportStorageAcceptOrder where (WCFlag is null or WCFlag<>2) and RKB='" + Global.sKb + "' ";
if (barcode.Length == 9 || barcode.Length == 10)
{
sql += "and (CLH2='" + barcode + "' or ( len(CLH2)=11 and charindex('" + barcode + "',CLH2)>0 ) ) ";
}
else
{
sql += "and CLH2='" + barcode + "'";
}
if (Global.storage.jhh != "")
{
sql += " and JHH='" + Global.storage.jhh + "' and Make='" + Global.storage.make + "'";
}
DataTable dt = SqlCe.ExecuteQuery(sql);
if (dt.Rows.Count > 0)
{
barcode = dt.Rows[0]["CLH"].ToString();
string kw = dt.Rows[0]["KW"].ToString();
int mz = 0;
if (dt.Rows[0]["MZ"] != DBNull.Value)
{
mz = Convert.ToInt32(dt.Rows[0]["MZ"]);
}
string zfh = dt.Rows[0]["ZFH"].ToString();
string gg = dt.Rows[0]["Height"].ToString() + "×" + dt.Rows[0]["Width"].ToString() + "×" + dt.Rows[0]["Long"].ToString();
string jhh = dt.Rows[0]["JHH"].ToString();
string make = dt.Rows[0]["Make"].ToString();
string qa = dt.Rows[0]["QA"].ToString();
bool bAlreadyIn = false;
for (int i = 0; i < dtCl.Rows.Count; i++)
{
if (dtCl.Rows[i]["CLH"].ToString() == barcode)
{
bAlreadyIn = true;
frmMessage frm = new frmMessage();
frm.ShowDialog("是否取消消帐材料" + barcode, "提示");
if (frm.ret)
{
dtCl.Rows[i]["WCFlag"] = 0;
dtCl.Rows[i]["SCANTIME"] = "";
dtCl.Rows[i]["KW"] = "";
Storage.ClearImpScanStatus(jhh, make, zfh, barcode);
dtCl.Rows.RemoveAt(i);
curRow = -1;
}
frm.Dispose();
break;
}
}
if (bAlreadyIn == false)
{
string exflag = Storage.GetExportFlag(barcode);
zf2kw(barcode, zfh, jhh, make, kw, gg, mz, qa, exflag);
}
}
dt.Dispose();
}
private void txtClh_KeyUp(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Escape)
{
return;
}
if (e.KeyCode >= Keys.A && e.KeyCode <= Keys.Z)
{
txtClh.Text = txtClh.Text.ToUpper();
txtClh.SelectionStart = txtClh.Text.Length;
}
if (e.KeyCode == Keys.Enter)
{
if (txtClh.Text.Length > 4)
{
addCL(txtClh.Text);
}
}
if (txtClh.Text.Length == 5)
{
string sql = "select B.CLH2 from ExportStorageOrder A,ExportStorageAcceptOrder B where A.ZFH=B.ZFH and (B.WCFlag is null or B.WCFlag<>2) and B.KW<>'' ";
sql += " and B.CLH2 like '%" + txtClh.Text + "' and B.CKB='" + Global.sKb + "' and (A.JHH like '7%' or A.JHH like '8%' or A.JHH like '9%') ";
sql += "and A.JHH='" + m_jhh + "' ";
switch (m_cltype)
{
case 0:
sql += "and A.ZFH='" + m_zfh + "'";
break;
case 1:
sql += "and B.LH='" + m_lh + "'";
break;
case 2:
sql += "and A.HTH='" + m_hth + "'";
break;
case 3:
sql += "and substring(B.CLH,1,6)='" + m_zph + "'";
break;
default:
break;
}
DataTable dt = SqlCe.ExecuteQuery(sql);
if (dt.Rows.Count == 1)
{
txtClh.Text = dt.Rows[0]["CLH2"].ToString();
txtClh.SelectionStart = txtClh.Text.Length;
}
else if (dt.Rows.Count > 1)
{
lstCLH.Items.Clear();
for (int i = 0; i < dt.Rows.Count; i++)
{
lstCLH.Items.Add(dt.Rows[i]["CLH2"].ToString());
}
lstCLH.Visible = true;
}
dt.Dispose();
}
}
private void loadFrameLayout20(string sFrameID, string kz)
{
string sql = "";
if (kz == "重")
{
sql = "select Location,CLH,Relative_X,Relative_Y,CLH,RKB,SteelWide,SteelDiameter from FrameLayout where FrameID='" + sFrameID + "' and Mold='20' order by Relative_X";
}
else
{
sql = "select Location,CLH,Relative_X,Relative_Y,CLH,CKB,SteelWide,SteelDiameter from FrameLayoutExp where FrameID='" + sFrameID + "' order by Relative_X";
}
DataTable dt = SqlCe.ExecuteQuery(sql);
if (kz == "重")
{
int[] colIndex = new int[Global.curFrame.MaxRow];
for (int i = 0; i < Global.curFrame.MaxRow; i++)
{
colIndex[i] = 0;
}
for (int i = 0; i < dt.Rows.Count; i++)
{
int X = Convert.ToInt32(dt.Rows[i]["Relative_X"]);
int Y = Convert.ToInt32(dt.Rows[i]["Relative_Y"]);
int row = Y / Global.curFrame.Space;
int col = colIndex[row] + 1;
if (col <= 2)
{
CoilPoint p = new CoilPoint(sFrameID, row, col);
if (Global.coils.ContainsKey(p))
{
Global.coils[p].X = X;
Global.coils[p].Y = Y;
Global.coils[p].diameter = dt.Rows[i]["SteelDiameter"].ToString();
Global.coils[p].wide = dt.Rows[i]["SteelWide"].ToString();
}
else
{
Coil coil = new Coil(p, "");
coil.X = X;
coil.Y = Y;
coil.diameter = dt.Rows[i]["SteelDiameter"].ToString();
coil.wide = dt.Rows[i]["SteelWide"].ToString();
Global.coils.Add(p, coil);
}
colIndex[row] = col;
}
}
}
else if (kz == "空" || kz == "拼")
{
for (int i = 0; i < dt.Rows.Count; i++)
{
int X = Convert.ToInt32(dt.Rows[i]["Relative_X"]);
int Y = Convert.ToInt32(dt.Rows[i]["Relative_Y"]);
string Location = dt.Rows[i]["Location"].ToString();
string clh = dt.Rows[i]["CLH"].ToString();
string kb = dt.Rows[i]["CKB"].ToString();
CoilPoint p = new CoilPoint(sFrameID, Location);
if (clh.Length > 8)
{
dtFrame.Rows[p.row][p.col] = clh.Substring(clh.Length - 8, 8);
}
else
{
dtFrame.Rows[p.row][p.col] = clh;
}
//if (Global.coils.ContainsKey(p))
//{
// Global.coils[p].X = X;
// Global.coils[p].Y = Y;
// Global.coils[p].clh = clh;
// Global.coils[p].kb = kb;
// Global.coils[p].diameter = dt.Rows[i]["SteelDiameter"].ToString();
// Global.coils[p].wide = dt.Rows[i]["SteelWide"].ToString();
//}
//else
if (Global.coils.ContainsKey(p) == false)
{
Coil coil = new Coil(p, "");
coil.X = X;
coil.Y = Y;
coil.clh = clh;
coil.kb = kb;
coil.diameter = dt.Rows[i]["SteelDiameter"].ToString();
coil.wide = dt.Rows[i]["SteelWide"].ToString();
Global.coils.Add(p, coil);
}
}
}
dt.Dispose();
}