using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using UAS_MES.DataOperate; using UAS_MES.Entity; using UAS_MES.PublicMethod; namespace UAS_MES.Make { public partial class Make_CollectBTMAC : Form { DataHelper dh; AutoSizeFormClass asc = new AutoSizeFormClass(); LogStringBuilder sql = new LogStringBuilder(); DataTable dt; //当前序列号记录 string sn_code; //制造单号 string macode; //采集BT号 string ms_bt; //采集销售单号 string sale_code; //采集MAC string ms_mac; //网标查询条件ms_id string oMsID; //判断是否输入BT Boolean isBT = false; //判断是否输入BT Boolean isMAC = false; //打印计数 int printcount; int ma_unlimitin; public Make_CollectBTMAC() { InitializeComponent(); } private void Make_CollectBTMAC_Load(object sender, EventArgs e) { asc.controllInitializeSize(this); printcount = 0; sncode.Focus(); dh = new DataHelper(); } private void Make_CollectBTMAC_Activated(object sender, EventArgs e) { sncode.Focus(); } private void Make_CollectBTMAC_SizeChanged(object sender, EventArgs e) { asc.controlAutoSize(this); } private void deleteButton1_Click(object sender, EventArgs e) { isBT = false; isMAC = false; BaseUtil.CleanForm(this); mcd_okqty.Text = printcount + ""; mcd_remainqty.Text = 0 + ""; OperateResult.AppendText(">>清除完成,请输入SN号\n", Color.Green); sncode.Focus(); } private void sncode_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.Enter) { if (!isMAC) { if (!isBT) { string ErrorMessage2; string oMakeCode; //由序列号获取数据 if (sncode.Text == "") { OperateResult.AppendText(">>序列号不能为空\n", Color.Red); return; } if (LogicHandler.CheckStepAttribute(Tag.ToString(), User.UserSourceCode, out ErrorMessage2)) { OperateResult.AppendText("<<" + sncode.Text + "\n", Color.Black); // 获取工单归属工单下一工序是否正确 if (LogicHandler.CheckStepSNAndMacode("", User.UserSourceCode, sncode.Text, User.UserCode, out oMakeCode, out oMsID, out ErrorMessage2)) { sql.Clear(); sql.Append("select ma_code as ms_makecode,nvl(mcd_okqty,0),ma_prodcode,pr_detail,"); sql.Append("pr_spec,ma_qty - nvl(mcd_inqty, 0) mcd_remainqty,nvl(ma_unlimitin,0) ma_unlimitin from make left join makecraftdetail on "); sql.Append("mcd_maid=ma_id left join product on pr_code=ma_prodcode where ma_code='" + oMakeCode + "' and mcd_stepcode='" + User.CurrentStepCode + "'"); dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select"); if (dt.Rows.Count > 0) { ma_unlimitin = int.Parse(dt.Rows[0]["ma_unlimitin"].ToString()); BaseUtil.SetFormValue(this.Controls, dt); dh.UpdateByCondition("makeserial", "ms_currentstepcode = '" + User.CurrentStepCode + "'", "ms_id = '" + oMsID + "'"); OperateResult.AppendText(">>请输入BT\n", Color.Black); sn_code = sncode.Text; sncode.Text = ""; isBT = true; return; } else { OperateResult.AppendText(">>序列号" + sncode.Text + "没有对应工序\n", Color.Red, sncode); } } else { OperateResult.AppendText(ErrorMessage2 + "\n", Color.Red, sncode); } } else { OperateResult.AppendText(ErrorMessage2 + "\n", Color.Red, sncode); } } else //采集BT { if (sncode.Text == "") { OperateResult.AppendText(">>BT号不能为空\n", Color.Red); return; } OperateResult.AppendText("<<" + sncode.Text + "\n", Color.Black); string ErrorMessage = ""; string result = ""; sql.Clear(); string checkbt = sncode.Text.Replace(":", "").Replace("-", ""); if (dh.CheckExist("MakeAddressList", "mal_makecode = '" + ms_makecode.Text + "'")) { sql.Append("select mal_bt from MakeAddressList where mal_bt = '" + checkbt + "' and mal_makecode = '" + ms_makecode.Text + "'"); dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select"); if (!(dt.Rows.Count > 0)) { OperateResult.AppendText(">>BT号" + checkbt + "不符合工单导入要求\n", Color.Red,sncode); return; } } else { ////根据工单号获取销售单号 //sale_code = dh.getFieldDataByCondition("make", "ma_salecode", "ma_code = '" + ms_makecode.Text + "'").ToString(); //sql.Clear(); //sql.Append("select sr_startcode,sr_endcode from SaleMacBTRange where sr_sacode = '" + sale_code + "' and sr_type = 'BT'"); //dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select"); //if (dt.Rows.Count > 0) //{ // if (!(dt.Rows[0]["sr_startcode"].ToString().Replace(":", "").Replace("-", "").CompareTo(checkbt) <= 0 && dt.Rows[0]["sr_endcode"].ToString().Replace(":", "").Replace("-", "").CompareTo(checkbt) >= 0)) // { // OperateResult.AppendText(">>BT号" + checkbt + "不符合销售单合同范围\n", Color.Red, sncode); // return; // } //} if (!LogicHandler.checkMacOrBtRange(oMsID, checkbt, "BT")) { OperateResult.AppendText(">>BT号" + checkbt + "不符合销售单合同范围\n", Color.Red, sncode); return; } } //根据序列号获取此时BT号 //ms_bt = dh.getFieldDataByCondition("makeserial", "ms_bt", "ms_id = '" + oMsID + "'").ToString(); if (int.Parse(mcd_remainqty.Text) <= 0 && ma_unlimitin == 0) { ErrorMessage = "工单" + ms_makecode.Text + "剩余采集数不足\n>>>请输入SN"; OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red); return; } if (dh.CheckExist("sninfo", "si_bt = '" + checkbt + "'")) { OperateResult.AppendText(">>录入错误，此BT:" + checkbt + "已被"+dh.getFieldDataByCondition("sninfo", "si_sn", "si_bt = '"+ checkbt + "'").ToString() +"使用\n", Color.Red, sncode); OperateResult.AppendText(">>请输入BT\n", Color.Black); return; } if (dh.CheckExist("makeserial", "ms_bt = '" + checkbt + "'")) { OperateResult.AppendText(">>录入错误，此BT:" + checkbt + "已被" + dh.getFieldDataByCondition("makeserial", "ms_sncode", "ms_bt = '" + checkbt + "'").ToString() + "使用\n", Color.Red, sncode); OperateResult.AppendText(">>请输入BT\n", Color.Black); return; } else { ms_bt = checkbt; OperateResult.AppendText(">>BT采集完成\n>>请输入MAC\n", Color.Green, sncode); isBT = false; isMAC = true; sncode.Focus(); return; } } } else { //采集MAC if (sncode.Text == "") { OperateResult.AppendText(">>MAC号不能为空\n", Color.Red); return; } OperateResult.AppendText("<<" + sncode.Text + "\n", Color.Black); string ErrorMessage = ""; string result = ""; sql.Clear(); string checkmac = sncode.Text.Replace(":", "").Replace("-", ""); if (dh.CheckExist("MakeAddressList", "mal_makecode = '" + ms_makecode.Text + "'")) { sql.Append("select mal_mac from MakeAddressList where mal_mac = '" + checkmac + "' and mal_makecode = '" + ms_makecode.Text + "'"); dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select"); if (!(dt.Rows.Count > 0)) { OperateResult.AppendText(">>MAC号" + checkmac + "不符合工单导入要求\n", Color.Red, sncode); return; } } else { ////根据工单号获取销售单号 //sale_code = dh.getFieldDataByCondition("make", "ma_salecode", "ma_code = '" + ms_makecode.Text + "'").ToString(); //sql.Clear(); //sql.Append("select sr_startcode,sr_endcode from SaleMacBTRange where sr_sacode = '" + sale_code + "' and sr_type = 'MAC'"); //dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select"); //if (dt.Rows.Count > 0) //{ // if (!(dt.Rows[0]["sr_startcode"].ToString().Replace(":", "").Replace("-", "").CompareTo(checkmac) <= 0 && dt.Rows[0]["sr_endcode"].ToString().Replace(":", "").Replace("-", "").CompareTo(checkmac) >= 0)) // { // OperateResult.AppendText(">>MAC号" + checkmac + "不符合销售单合同范围\n", Color.Red, sncode); // return; // } //} if (!LogicHandler.checkMacOrBtRange(oMsID, checkmac, "MAC")) { OperateResult.AppendText(">>MAC号" + checkmac + "不符合销售单合同范围\n", Color.Red, sncode); return; } } ////根据序列号获取此时网标号 //ms_mac = dh.getFieldDataByCondition("makeserial", "ms_mac", "ms_id = '" + oMsID + "'").ToString(); if (int.Parse(mcd_remainqty.Text) <= 0 && ma_unlimitin == 0) { ErrorMessage = "工单" + ms_makecode.Text + "剩余采集数不足\n>>>请输入SN"; OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red); return; } if (dh.CheckExist("sninfo", "si_bt = '" + checkmac + "'")) { OperateResult.AppendText(">>录入错误，此MAC:" + checkmac + "已被" + dh.getFieldDataByCondition("sninfo", "si_sn", "si_mac = '" + checkmac + "'").ToString() + "使用\n", Color.Red, sncode); OperateResult.AppendText(">>请输入MAC\n", Color.Black); return; } if (dh.CheckExist("makeserial", "ms_mac = '" + checkmac + "'")) { OperateResult.AppendText(">>录入错误，此MAC:" + checkmac + "已被" + dh.getFieldDataByCondition("makeserial", "ms_sncode", "ms_mac = '" + checkmac + "'").ToString() + "使用\n", Color.Red, sncode); OperateResult.AppendText(">>请输入MAC\n", Color.Black); return; } else { if (LogicHandler.SetStepResult(ms_makecode.Text, User.UserSourceCode, sn_code, "BT/MAC采集", "BT/MAC采集完成", User.UserCode, out ErrorMessage)) { //提示正确返回时传递的信息 if (ErrorMessage.Contains("AFTERSUCCESS")) OperateResult.AppendText(">>" + ErrorMessage + "\n"); string si_id = dh.getFieldDataByCondition("sninfo", "max(si_id) si_id", " si_sn='"+ sn_code + "' or si_sn in(select sn from makesnrelation where sn='"+ sn_code + "' or beforesn = '" + sn_code + "')").ToString(); if (si_id != "") { dh.BatchInsert("update sninfo set si_mac = :mac,si_bt =:bt,si_indate = sysdate where si_id = :osiId", new String[] { "mac", "bt", "osiId" }, new string[] { checkmac }, new string[] { ms_bt }, new string[] { si_id }); } else { dh.BatchInsert("insert into sninfo (si_id,si_sn,si_mac,si_bt,si_indate) values (SnInfo_seq.nextval,:si_sn,:si_mac,:si_bt,sysdate)", new String[] { "si_sn", "si_mac", "si_bt" }, new string[] { sn_code }, new string[] { checkmac }, new string[] { ms_bt }); } dh.BatchInsert("update makeserial set ms_mac = :mac,ms_bt =:bt where ms_id = :oMsId", new String[] { "mac", "bt", "oMsId" }, new string[] { checkmac }, new string[] { ms_bt }, new string[] { oMsID.ToString() }); OperateResult.AppendText(">>BT/MAC采集完成,执行更新\n", Color.Green); LogicHandler.DoCommandLog(Tag.ToString(), User.UserCode, ms_makecode.Text, User.UserLineCode, User.UserSourceCode, "BT/MAC采集", "采集成功", sn_code, ""); sql.Clear(); sql.Append("select ma_qty - nvl(mcd_inqty, 0) mcd_remainqty from make left join makecraftdetail on "); sql.Append("mcd_maid=ma_id left join product on pr_code=ma_prodcode where ma_code='" + ms_makecode.Text + "' and mcd_stepcode='" + User.CurrentStepCode + "'"); dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select"); BaseUtil.SetFormValue(Controls, dt); printcount++; mcd_okqty.Text = printcount + ""; isMAC = false; sncode.Text = ""; sncode.Focus(); } else { OperateResult.AppendText(">>采集错误" + ErrorMessage + "\n", Color.Red); return; } OperateResult.AppendText(">>请输入SN\n", Color.Black); } } } } } }