using LabelManager2; using Seagull.BarTender.Print; using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Threading; using System.Windows.Forms; using UAS_MES_NEW.DataOperate; using UAS_MES_NEW.Entity; using UAS_MES_NEW.PublicForm; using UAS_MES_NEW.PublicMethod; namespace UAS_MES_NEW.Make { public partial class Make_GetReMakeSN : Form { //打印进程 ApplicationClass lbl; //初始化打印进程 Thread InitPrint; LogStringBuilder sql = new LogStringBuilder(); AutoSizeFormClass asc = new AutoSizeFormClass(); DataHelper dh; DataTable dt; Document doc; private System.DateTime[] indate; string ErrMessage; public Make_GetReMakeSN() { InitializeComponent(); } Engine engine; private void InPrint() { try { engine = new Engine(true); BaseUtil.WriteLbl(); } catch (Exception ex) { OperateResult.AppendText("未正确安装BarTender软件\n", Color.Red); } } private void Make_GetReMakeSN_Load(object sender, EventArgs e) { ma_code.TableName = "make left join product on ma_prodcode=pr_code"; ma_code.SelectField = "ma_code # 工单号,pr_code # 产品编号,ma_qty # 工单数量,pr_detail # 产品名称,pr_spec # 产品规格,ma_craftcode # 途程编号"; ma_code.FormName = Name; ma_code.SetValueField = new string[] { "ma_code", "pr_code", "ma_qty", "pr_detail", "pr_spec", "ma_craftcode" }; ma_code.Condition = "ma_kind='返工' and ma_statuscode='STARTED'"; ma_code.DbChange += Ma_code_DbChange; ma_code.SetLockCheckBox(LockCheckBox); LockCheckBox.GetMakeCodeCtl(ma_code); OperateResult.AppendText(">>请输入返工工单号\n", Color.Black); asc.controllInitializeSize(this); InitPrint = new Thread(InPrint); SetLoadingWindow stw = new SetLoadingWindow(InitPrint, "初始化打印程序"); BaseUtil.SetFormCenter(stw); stw.ShowDialog(); sn_code.Focus(); dh = SystemInf.dh; } private void Ma_code_DbChange(object sender, EventArgs e) { DataTable dt = ma_code.ReturnData; BaseUtil.SetFormValue(this.Controls, dt); } private void Make_GetReMakeSN_SizeChanged(object sender, EventArgs e) { asc.controlAutoSize(this); } private void pr_code_TextChanged(object sender, EventArgs e) { DataTable _dt = (DataTable)dh.ExecuteSql("select la_id,la_url,la_isdefault from label where la_prodcode='" + pr_code.Text + "' and la_templatetype='SN标签' and la_statuscode='AUDITED' order by la_isdefault", "select"); PrintLabel.DataSource = _dt; PrintLabel.DisplayMember = "la_url"; PrintLabel.ValueMember = "la_id"; } private void sn_code_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.Enter) { if (ma_code.Text != "") { //判断是否是途程第一道工序 sql.Clear(); sql.Append("select cd_id from craft left join craftdetail on cd_crid=cr_id where cr_code='" + ma_craftcode.Text + "' "); sql.Append("and cr_prodcode='" + pr_code.Text + "' and nvl(cd_firststep,0)<>0 and cd_stepcode='" + User.CurrentStepCode + "'"); dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select"); if (dt.Rows.Count > 0) { if (sn_code.Text != "") { //判断序列号是否有效 string Msid = dh.getFieldDataByCondition("makeserial ", "max(ms_id)", "(ms_sncode='" + sn_code.Text + "' or ms_imei1='" + sn_code.Text + "' or ms_imei2='" + sn_code.Text + "' or ms_imei3='" + sn_code.Text + "' ) and ms_makecode<>'" + ma_code.Text + "' ").ToString(); if (Msid != "") { //序列号信息 sql.Clear(); sql.Append("select ms_beforesn,ms_sncode,ms_status,ms_makecode,ms_firstsn,ms_outboxcode,ms_nextmacode,ms_prodcode,ms_salecode,"); sql.Append("MS_IMEI1,MS_MAC,MS_NETCODE,MS_MEID,ms_imei2,ms_imei3,ms_othid1,ms_othid2,ms_othid3"); sql.Append(",MS_OTHCODE3,MS_OTHCODE2,MS_OTHCODE1,ms_bt from makeserial where ms_id='" + Msid + "'"); DataTable SnInf = (DataTable)dh.ExecuteSql(sql.GetString(), "select"); string ms_prodcode = SnInf.Rows[0]["ms_prodcode"].ToString(); string ms_salecode = SnInf.Rows[0]["ms_salecode"].ToString(); string ms_beforesn = SnInf.Rows[0]["ms_beforesn"].ToString(); string ms_makecode = SnInf.Rows[0]["ms_makecode"].ToString(); string Sn = SnInf.Rows[0]["ms_sncode"].ToString(); string ms_status = SnInf.Rows[0]["ms_status"].ToString(); string ms_outboxcode = SnInf.Rows[0]["ms_outboxcode"].ToString(); //判断序列号是否已经被使用 if (SnInf.Rows[0]["ms_nextmacode"].ToString() != "") { OperateResult.AppendText(">>序列号已经被工单号:" + SnInf.Rows[0]["ms_nextmacode"].ToString() + "使用\n", Color.Red, sn_code); return; } //工单信息 sql.Clear(); sql.Append("select ma_salecode,nvl(ma_checksacode,0)ma_checksacode,ma_prodcode,ma_craftname,ma_inqty,ma_craftcode,ma_qty,nvl(ma_inqty,0) ma_inqty,"); sql.Append("nvl(ma_scrapqty,0)ma_scrapqty,ma_id,nvl(ma_unlimitin,0) ma_unlimitin,ma_wccode,NVL(re_autodecom,0)"); sql.Append("re_autodecom,nvl(re_ifsnok,0)re_ifsnok,re_code from make left join rework on ma_screcode=re_code where "); sql.Append("ma_code='" + ma_code.Text + "'and ma_kind='返工' and ma_statuscode='STARTED'"); DataTable MaInf = (DataTable)dh.ExecuteSql(sql.GetString(), "select"); string ma_prodcode = MaInf.Rows[0]["ma_prodcode"].ToString(); string ma_salecode = MaInf.Rows[0]["ma_salecode"].ToString(); string re_autodecom = MaInf.Rows[0]["re_autodecom"].ToString(); string re_ifsnok = MaInf.Rows[0]["re_ifsnok"].ToString(); string ma_checksacode = MaInf.Rows[0]["ma_checksacode"].ToString(); string re_code = MaInf.Rows[0]["re_code"].ToString(); int ma_unlimitin = int.Parse(MaInf.Rows[0]["ma_unlimitin"].ToString()); int ma_inqty = int.Parse(MaInf.Rows[0]["ma_inqty"].ToString()); int ma_scrapqty = int.Parse(MaInf.Rows[0]["ma_scrapqty"].ToString()); int ma_qty = int.Parse(MaInf.Rows[0]["ma_qty"].ToString()); if (ma_prodcode != ms_prodcode) { OperateResult.AppendText(">>序列号所属产品" + ms_prodcode + "与返工工单产品不一致\n", Color.Red, sn_code); return; } if (ma_checksacode != "0") { if (ms_salecode != "" && ma_salecode != "" && ms_salecode != ma_salecode) { OperateResult.AppendText(">>序列号所属合同" + ms_salecode + "与返工工单合同不一致\n", Color.Red, sn_code); return; } } if (ma_unlimitin == 0 && ma_inqty - ma_scrapqty + 1 > ma_qty) { OperateResult.AppendText(">>工单不允许超数投产\n", Color.Red, sn_code); return; } if (re_ifsnok != "0") { if (ms_status == "3" && dh.CheckExist("makebad", "mb_sncode = '" + sn_code.Text + "'and mb_makecode = '" + ms_makecode + "' and mb_status = '0'")) { OperateResult.AppendText(">>序列号:" + sn_code.Text + "处于不良状态,完成维修后才能归属至返工工单\n", Color.Red, sn_code); return; } } //if (ReWorkAsRelateTSN.Checked) //{ // if (ms_beforesn != "") // { // Sn = ms_beforesn; // } // else // { // OperateResult.AppendText(">>序列号" + sn_code.Text + "不存在TSN\n", Color.Red, sn_code); // return; // } //} string netcode = ""; string imeid = ""; string imei1 = ""; string imei2 = ""; string imei3 = ""; string othid1 = ""; string othid2 = ""; string othid3 = ""; string mac = ""; string bt = ""; string othcode1 = ""; string othcode2 = ""; string othcode3 = ""; if (ma_saveimei.Checked) { netcode = SnInf.Rows[0]["MS_NETCODE"].ToString(); imeid = SnInf.Rows[0]["MS_MEID"].ToString(); imei1 = SnInf.Rows[0]["MS_IMEI1"].ToString(); imei2 = SnInf.Rows[0]["ms_imei2"].ToString(); imei3 = SnInf.Rows[0]["ms_imei3"].ToString(); othid1 = SnInf.Rows[0]["ms_othid1"].ToString(); othid2 = SnInf.Rows[0]["ms_othid2"].ToString(); othid3 = SnInf.Rows[0]["ms_othid3"].ToString(); } if (ma_savemacbt.Checked) { mac = SnInf.Rows[0]["ms_mac"].ToString(); bt = SnInf.Rows[0]["ms_bt"].ToString(); othcode1 = SnInf.Rows[0]["MS_OTHCODE1"].ToString(); othcode2 = SnInf.Rows[0]["MS_OTHCODE2"].ToString(); othcode3 = SnInf.Rows[0]["MS_OTHCODE3"].ToString(); } string craftcode = MaInf.Rows[0]["ma_craftcode"].ToString(); string craftname = MaInf.Rows[0]["ma_craftname"].ToString(); string firstsn = SnInf.Rows[0]["ms_firstsn"].ToString(); //工作中心为空的时候取工单的工作中心 string workcenter = User.WorkCenter; if (workcenter == "") workcenter = MaInf.Rows[0]["ma_wccode"].ToString(); //工单合同为空的时候取序列号合同，更新合同回工单 string salecode = MaInf.Rows[0]["ma_salecode"].ToString(); List SQLS = new List(); if (salecode == "") { salecode = SnInf.Rows[0]["ms_salecode"].ToString(); SQLS.Add("update make set ma_salecode='" + salecode + "' where ma_id='" + ma_id.Text + "'"); } //插入返工工单 sql.Clear(); sql.Append("insert into MakeSerial(ms_id,ms_code,ms_sncode,ms_prodcode,ms_indate,ms_wccode"); sql.Append(",ms_craftcode,ms_craftname,ms_nextstepcode,ms_status,ms_makecode,ms_linecode"); sql.Append(",ms_sourcecode,ms_maid,ms_firstsn,ms_salecode,ms_mac,ms_bt,ms_othcode1,ms_othcode2,"); sql.Append("ms_othcode3,ms_netcode,ms_imei1,ms_imei2,ms_imei3,ms_meid,ms_othid1,ms_othid2,ms_othid3)"); sql.Append("values(MakeSerial_seq.nextval,'" + Sn + "','" + Sn + "','" + pr_code.Text + "',"); sql.Append("sysdate,'" + workcenter + "','" + craftcode + "','" + craftname + "','" + User.CurrentStepCode + "',"); sql.Append("'0','" + ma_code.Text + "','" + User.UserLineCode + "','" + User.UserSourceCode + "','" + ma_id.Text + "',"); sql.Append("'" + firstsn + "','" + salecode + "','" + mac + "','" + bt + "','" + othcode1 + "','" + othcode2 + "','" + othcode3 + "',"); sql.Append("'" + netcode + "','" + imei1 + "','" + imei2 + "','" + imei3 + "','" + imeid + "','" + othid1 + "','" + othid2 + "','" + othid3 + "')"); SQLS.Add(sql.GetString()); //更新工单数量+1 SQLS.Add("update make set ma_inqty=nvl(ma_inqty,0)+1 where ma_id='" + ma_id.Text + "'"); //更新该序列号的所属工单为返工工单 SQLS.Add("update makeserial set ms_nextmacode='" + ma_code.Text + "' where ms_id='" + Msid + "'"); if (ms_outboxcode != "") { string pamothercode = dh.getFieldDataByCondition("package", "pa_mothercode", "pa_outboxcode='" + ms_outboxcode + "'").ToString(); //如果已装栈板从栈板解除 if (pamothercode != "") { sql.Clear(); sql.Append("insert into packagebackupdetail(pbd_id,pbd_paid,pbd_outboxcode,pbd_innerboxcode,pbd_barcode,pbd_innerqty,pbd_prodcode,pbd_makecode,pbd_buildate,pbd_ymd)"); sql.Append("select pd_id,pd_paid,pd_outboxcode,pd_innerboxcode,pd_barcode,pd_innerqty,pd_prodcode,pd_makecode,pd_builddate,pd_ymd from packagedetail where "); sql.Append("pd_outboxcode='" + pamothercode + "' and pd_innerboxcode='" + ms_outboxcode + "'"); SQLS.Add(sql.GetString()); SQLS.Add("delete from packagedetail where pd_outboxcode='" + pamothercode + "' and pd_innerboxcode='" + ms_outboxcode + "'"); DataTable dt = dh.getFieldsDatasByCondition("packagedetail left join package on pa_id=pd_paid", new string[] { "nvl(sum(pd_innerqty),0)", "count(1)" }, "pa_outboxcode='" + pamothercode + "'"); string totalqty = dt.Rows[0][0].ToString(); string currentqty = dt.Rows[0][1].ToString(); SQLS.Add("update package set PA_TOTALQTY='" + totalqty + "',pa_packageqty='" + currentqty + "',pa_currentqty='" + currentqty + "' where pa_outboxcode='" + pamothercode + "'"); } //备份和删除卡通箱明细 sql.Clear(); sql.Append("insert into packagebackup(pab_id,pab_prodcode,pab_outboxcode,pab_packdate,pab_level,pab_packageqty,pab_totalqty,pab_makecode,pab_status,pab_indate,pab_salecode,pab_printcount,pab_custcode,pab_type,"); sql.Append("pab_weight,pab_currentqty,pab_standardqty,pab_packtype,pab_checkno,pab_downstatus,pab_sccode,pab_ymd,pab_mothercode,pab_currentstep,pab_nextstep,pab_outno,pab_iostatus,pab_remark) "); sql.Append("select pa_id,pa_prodcode,pa_outboxcode,pa_packdate,pa_level,pa_packageqty,pa_totalqty,pa_makecode,pa_status,pa_indate,pa_salecode,pa_printcount,pa_custcode,pa_type,pa_weight,pa_currentqty,"); sql.Append("pa_standardqty,pa_packtype,pa_checkno,pa_downstatus,pa_sccode,pa_ymd,pa_mothercode,pa_currentstep,pa_nextstep,pa_outno,pa_iostatus,pa_remark from package where pa_outboxcode='" + ms_outboxcode + "'"); SQLS.Add(sql.GetString()); SQLS.Add("delete from package where pa_outboxcode='" + ms_outboxcode + "'"); sql.Clear(); sql.Append("insert into packagebackupdetail(pbd_id,pbd_paid,pbd_outboxcode,pbd_innerboxcode,pbd_barcode,pbd_innerqty,pbd_prodcode,pbd_makecode,pbd_buildate,pbd_ymd)"); sql.Append("select pd_id,pd_paid,pd_outboxcode,pd_innerboxcode,pd_barcode,pd_innerqty,pd_prodcode,pd_makecode,pd_builddate,pd_ymd from packagedetail where "); sql.Append("pd_outboxcode='" + ms_outboxcode + "'"); SQLS.Add(sql.GetString()); SQLS.Add("delete from packagedetail where pd_outboxcode='" + ms_outboxcode + "' "); } sql.Clear(); sql.Append("update makebad set mb_makecode='" + ms_makecode + "' where mb_sncode ='" + sn_code.Text + "' and mb_status=0"); SQLS.Add(sql.GetString()); if (re_autodecom != "0") { //sql.Clear(); //sql.Append("select cm_makecode,cm_soncode,cm_barcode from craftmaterial left join makeserial on ms_makecode="); //sql.Append("cm_makecode and ms_sncode=cm_sncode and ms_prodcode=cm_maprodcode where ms_id='" + Msid + "'"); //DataTable dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select"); //string cm_makecode = ""; //string cm_soncode = ""; //string cm_barcode = ""; //if (dt.Rows.Count > 0) //{ // cm_makecode = dt.Rows[0]["cm_makecode"].ToString(); // cm_soncode = dt.Rows[0]["cm_soncode"].ToString(); // cm_barcode = dt.Rows[0]["cm_barcode"].ToString(); //} sql.Clear(); sql.Append("update craftmaterial set cm_status=-1,cm_dropcode='" + re_code + "',cm_dropman='" + User.UserCode + "',cm_dropdate=sysdate where "); sql.Append("cm_firstsn='" + firstsn + "' and nvl(cm_status,0)=0 and exists (select 1 from makesndecompose "); sql.Append("where msd_recode='" + re_code + "' and msd_fsoncode=cm_fsoncode and msd_stepcode=cm_stepcode)"); SQLS.Add(sql.GetString()); //TSN失效 //sql.Clear(); //sql.Append("update makeserial set ms_nextmacode='' where ms_nextmacode='" + cm_makecode + "'"); //sql.Append(" and ms_sncode='" + cm_barcode + "' and ms_prodcode='" + cm_soncode + "' "); sql.Clear(); sql.Append("update makeserial set ms_nextmacode='' where ms_id in (select a.ms_id from makeserial B INNER JOIN CRAFTMATERIAL ON cm_firstsn=B.ms_firstsn"); sql.Append("inner join makeserial a on cm_barcode=A.ms_sncode and cm_soncode=A.ms_prodcode inner join makesndecompose on msd_fsoncode=cm_fsoncode and msd_stepcode=cm_stepcode "); sql.Append("AND A.MS_NEXTMACODE=cm_makecode where b.ms_id='" + Msid + "' and msd_recode='" + re_code + "')"); SQLS.Add(sql.GetString()); } dh.ExecuteSQLTran(SQLS.ToArray()); //if (ReWorkAsRelateTSN.Checked) //{ // dh.ExecuteSql("update makeserial set ms_nextmacode='" + ma_code.Text + "' where ms_sncode='" + ms_beforesn + "' and ms_nextmacode='" + ms_makecode + "'", "update"); //} OperateResult.AppendText(">>序列号" + sn_code.Text + "归属工单" + ma_code.Text + "成功。\n", Color.Green); LogicHandler.DoCommandLog(Tag.ToString(), User.UserCode, ma_code.Text, User.UserLineCode, User.UserSourceCode, "返工信息采集", "序列号归属成功", sn_code.Text, ""); getsnqty.Text = dh.getFieldDataByCondition("makeserial ", "count(1)", "ms_makecode='" + ma_code.Text + "'").ToString(); if (AutoPrint.Checked) { if (PrintLabel.Items.Count != 0) { OperateResult.AppendText(">>打印序列号" + sn_code.Text + "\n", Color.Black); //doc = lbl.Documents.Open(PrintLabel.Text); if (!Print.BarTenderS(Tag.ToString(), ref engine, PrintLabel.Text, PrintLabel.SelectedValue.ToString(), PrinterList.Text, sn_code.Text, int.Parse(PrintNum.Text), ma_code.Text, pr_code.Text, "SN标签", "0", out ErrMessage)) { OperateResult.AppendText(ErrMessage + "\n", Color.Red); return; } dh.UpdateByCondition("makeserial", "ms_printcount=nvl(ms_printcount,0)+1", "ms_sncode='" + sn_code.Text + "'"); } else OperateResult.AppendText(">>" + pr_code.Text + "未维护标签\n", Color.Black); } sn_code.Clear(); } else OperateResult.AppendText(">>序列号" + sn_code.Text + "不存在或者已绑定工单\n", Color.Red, sn_code); } else OperateResult.AppendText(">>序列号不允许为空\n", Color.Red, sn_code); } else OperateResult.AppendText(">>该岗位资源对应的工序不是当前返工工单途程中的第一道工序，请切换资源编号\n", Color.Red, sn_code); } else OperateResult.AppendText(">>工单号不允许为空\n", Color.Red, sn_code); } } private void ma_code_UserControlTextChanged(object sender, EventArgs e) { if (ma_code.Text.Length >= 5) { if (dh.CheckExist("make", "ma_kind='返工' and ma_statuscode='STARTED' and ma_code='" + ma_code.Text + "'")) { sql.Clear(); sql.Append("select ma_id,ma_craftcode,ma_code,pr_code,pr_detail,pr_spec,ma_qty,nvl(ma_savemacbt,0) ma_savemacbt,nvl(ma_saveimei, 0)"); sql.Append("ma_saveimei from make left join product on ma_prodcode=pr_code where ma_code='" + ma_code.Text + "'"); dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select"); BaseUtil.SetFormValue(this.Controls, dt); if (dt.Rows[0]["ma_saveimei"].ToString() != "0") { ma_saveimei.Checked = true; } if (dt.Rows[0]["ma_savemacbt"].ToString() != "0") { ma_savemacbt.Checked = true; } } } } private void PrintLabel_SelectedValueChanged(object sender, EventArgs e) { if (PrintLabel.SelectedValue != null && PrintLabel.SelectedValue.ToString() != "System.Data.DataRowView") { string PrintNums = dh.getFieldDataByCondition("label", "la_printnos", "la_id='" + PrintLabel.SelectedValue.ToString() + "'").ToString(); PrintNum.Text = (PrintNums == "" ? "1" : PrintNums); } } } }