using System; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; using UAS_MES.DataOperate; using UAS_MES.PublicMethod; using UAS_MES.Entity; using LabelManager2; using System.Threading; using UAS_MES.PublicForm; using System.Collections.Generic; namespace UAS_MES.Make { public partial class Make_ColorBoxLoadPrint : Form { DataHelper dh; DataTable dt; LogStringBuilder sql = new LogStringBuilder(); AutoSizeFormClass asc = new AutoSizeFormClass(); //保存StepProduct查询出来的数据 DataTable ListA = new DataTable(); //制造单号 string ma_code; //当前工单的序列号 //string sn_code; //当前提示的索引 int RemainIndex = 0; string ErrorMessage = ""; System.DateTime[] indate; ApplicationClass lbl; Thread InitPrint; List CollectData = new List(); List CollectDataSonCode = new List(); public Make_ColorBoxLoadPrint() { InitializeComponent(); load.Checked = true; } private void 标签打印_Load(object sender, EventArgs e) { dh = new DataHelper(); code.Focus(); asc.controllInitializeSize(this); InitPrint = new Thread(InPrint); SetLoadingWindow stw = new SetLoadingWindow(InitPrint, "初始化打印程序"); BaseUtil.SetFormCenter(stw); stw.ShowDialog(); } private void InPrint() { try { lbl = new ApplicationClass(); BaseUtil.WriteLbl(lbl); } catch (Exception ex) { OperateResult.AppendText("未正确安装CodeSoft软件\n", Color.Red); } } private void sn_code_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.Enter) { if (code.Text == "") { OperateResult.AppendText(">>输入内容不能为空\n", Color.Red); return; } if (LogicHandler.CheckStepAttribute(Tag.ToString(), User.UserSourceCode, out ErrorMessage)) { string Msid; if (ms_makecode.Text == "") { if (!LogicHandler.GetMakeInfo(code.Text, out ma_code, out ErrorMessage)) { OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red); return; } } if (ms_makecode.Text != ma_code || ListA.Rows.Count == 0) { if (LogicHandler.CheckStepSNAndMacode(ms_makecode.Text, User.UserSourceCode, code.Text, User.UserCode, out ma_code, out Msid, out ErrorMessage) || ListA.Rows.Count > 0) { sql.Clear(); sql.Append("select ms_makecode,ma_craftcode,ms_sncode,ma_qty,pr_detail,pr_code,ma_bomversion from makeserial left join make on "); sql.Append("ms_makecode=ma_code left join product on ms_prodcode=pr_code where ms_sncode=:sncode"); dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select", code.Text); if (dt.Rows.Count > 0) { BaseUtil.SetFormValue(this.Controls, dt); LoadCollectNum(); if (PrintLabel.SelectedValue == null) { OperateResult.AppendText(">>产品编号:" + pr_code.Text + "未维护彩盒标签\n", Color.Red); return; } ms_sncode.Text = code.Text; } //判断当前的执行状态 ,Loading表示执行上料操作，UnLoading表示执行下料操作 if (load.Checked == true) { OperateResult.AppendText(">>开始执行上料工序\n"); sql.Clear(); sql.Append("select sp_id,sp_tracekind,sp_barcoderule,sp_prefix,sp_ifuseregex,sp_ifforsn,sp_length,sp_description,sp_soncode,pr_detail,pr_spec,"); sql.Append("sp_repcode,pr_id,sp_type,case when (sp_type='物料' and sp_soncode=pr_code) then '已采集' else '未采集' end sp_ifpick ,sp_prefix,"); sql.Append("sp_length,sp_regex,sp_ifforsn from stepproduct left join product on pr_code=sp_soncode where sp_bomversion='" + ma_bomversion.Text + "' and "); sql.Append("sp_craftcode='" + ma_craftcode.Text + "' and sp_stepcode='" + User.CurrentStepCode + "' And sp_mothercode ='" + pr_code.Text + "' "); sql.Append("and((sp_type = '物料' and(sp_tracekind <> 2 or sp_tracekind is null))or sp_type <> '物料') order by SP_DETNO asc"); ListA = (DataTable)dh.ExecuteSql(sql.GetString(), "select"); //获取对应 产品的机身标的打印模板 if (ListA.Rows.Count > 0) { OperateResult.AppendText(">>请采集" + ListA.Rows[RemainIndex]["sp_soncode"].ToString() + "的条码\n"); code.Clear(); } } else if (unload.Checked == true) { if (LogicHandler.CheckStepSNAndMacode(ma_code, User.UserSourceCode, code.Text, User.UserCode, out ma_code, out Msid, out ErrorMessage)) { dt = (DataTable)dh.ExecuteSql("select cm_id,cm_stepcode,ms_makecode,cm_mccode from craftmaterial left join makeserial on cm_makecode=ms_makecode and cm_sncode=ms_sncode where ms_sncode='" + code.Text + "' and cm_makecode='" + ma_code + "'", "select"); if (dt.Rows.Count > 0) { string ms_macode = dt.Rows[0]["ms_makecode"].ToString(); string cm_stepcode = dt.Rows[0]["cm_stepcode"].ToString(); string cm_mccode = dt.Rows[0]["cm_mccode"].ToString(); dh.ExecuteSql("delete from craftmaterial where cm_sncode='" + code.Text + "' and cm_makecode='" + ma_code + "'", "delete"); LogicHandler.InsertMakeProcess(ms_macode, code.Text, User.UserSourceCode, "上料采集操作", "下料成功", User.UserCode); int count = dh.getRowCount("craftMaterial", "cm_mccode='" + cm_mccode + "' and cm_stepcode='" + cm_stepcode + "' and cm_sncode='" + code.Text + "'"); if (count == 0) dh.UpdateByCondition("makecraftdetail ", "mcd_inqty=mcd_inqty-1,mcd_outqty=mcd_outqty-1,mcd_okqty = mcd_okqty - 1", "mcd_mccode='" + cm_mccode + "' and mcd_stepcode='" + cm_stepcode + "'"); OperateResult.AppendText(">>序列号" + code.Text + "下料成功\n", Color.Green, code); } else OperateResult.AppendText(">>该序列号未上料，无需下料\n", Color.Red, code); } else OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red, code); } } else OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red); } else { //获取上料需要传递的参数，sp_soncode,sp_id string sp_soncode = ListA.Rows[RemainIndex]["sp_soncode"].ToString(); string sp_prefix = ListA.Rows[RemainIndex]["sp_prefix"].ToString(); string sp_regex = ListA.Rows[RemainIndex]["sp_regex"].ToString(); string length = ListA.Rows[RemainIndex]["sp_length"].ToString(); string sp_id = ListA.Rows[RemainIndex]["sp_id"].ToString(); string sp_ifforsn = ListA.Rows[RemainIndex]["sp_ifforsn"].ToString(); string sp_tracekind = ListA.Rows[RemainIndex]["sp_tracekind"].ToString(); string sp_barcoderule = ListA.Rows[RemainIndex]["sp_barcoderule"].ToString(); if (LogicHandler.CheckSNBeforeLoad(ma_code,code.Text, sp_soncode, sp_barcoderule, sp_prefix, length, out ErrorMessage)) { CollectData.Add(code.Text); CollectDataSonCode.Add(ListA.Rows[RemainIndex]["sp_soncode"].ToString()); OperateResult.AppendText(">>采集成功\n", Color.Green, code); RemainIndex = RemainIndex + 1; } else { OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red, code); return; } code.Clear(); if (RemainIndex <= ListA.Rows.Count - 1) OperateResult.AppendText(">>请采集物料编号为" + ListA.Rows[RemainIndex]["sp_soncode"].ToString() + "的条码\n"); if (RemainIndex == ListA.Rows.Count) { sql.Clear(); sql.Append("insert into Craftmaterial (cm_id ,cm_makecode,cm_maid,cm_maprodcode, cm_soncode, cm_mscode, cm_sncode, cm_stepcode, cm_stepname,"); sql.Append("cm_craftcode,cm_craftname,cm_barcode,cm_inqty,cm_indate,cm_inman,cm_linecode,cm_wccode,cm_sourcecode,cm_spid,cm_status,cm_materialtype,cm_firstsn)"); sql.Append("select Craftmaterial_seq.nextval, ma_code, ma_id, ma_prodcode,:soncode,ms_code,ms_sncode,mcd_stepcode,"); sql.Append("mcd_stepname,ma_craftcode,ma_craftname,:barcode,1,sysdate,'" + User.UserCode + "',ma_linecode,ma_wccode,"); sql.Append("'" + User.UserSourceCode + "','" + sp_id + "',0,1,ms_firstsn from make left join makecraftdetail on mcd_macode=ma_code left join stepproduct on sp_stepcode=mcd_stepcode "); sql.Append("and sp_craftcode=ma_craftcode and sp_mothercode = ma_prodcode left join makeserial on ms_makecode=ma_code "); sql.Append("where ma_code='" + ma_code + "'and sp_id=" + sp_id + " and mcd_stepcode = '" + User.CurrentStepCode + "' and ms_sncode='" + ms_sncode.Text + "'"); dh.BatchInsert(sql.GetString(), new string[] { "soncode", "barcode" }, CollectDataSonCode.ToArray(), CollectData.ToArray()); OperateResult.AppendText(">>序列号" + ms_sncode.Text + "对应的工单已经采集完成\n", Color.Green); Print.CodeSoft(lbl, PrintLabel.Text, PrintLabel.SelectedValue.ToString(), Printer.Text, ms_sncode.Text, int.Parse(PrintNum.Text), indate[PrintLabel.SelectedIndex]); RemainIndex = 0; CollectData.Clear(); CollectDataSonCode.Clear(); if (LogicHandler.SetTestResult(ms_makecode.Text, User.UserSourceCode, ms_sncode.Text, "彩盒上料打印", "彩盒上料成功", User.UserCode, out ErrorMessage)) { mcd_okqty.Text = int.Parse(mcd_okqty.Text) + 1 + ""; code.Clear(); LoadCollectNum(); BaseUtil.CleanDataTableData(ListA); } else OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red, code); return; } } } else OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red); } } private void 标签打印_SizeChanged(object sender, EventArgs e) { asc.controlAutoSize(this); } private void pr_code_TextChanged(object sender, EventArgs e) { dt = (DataTable)dh.ExecuteSql("select pl_labelname,pl_labelcode,pl_indate,pl_labelurl from productlabel where pl_prodcode='" + pr_code.Text + "' and pl_labeltype='彩盒标' order by pl_isdefault desc", "select"); PrintLabel.DataSource = dt; PrintLabel.DisplayMember = "pl_labelname"; PrintLabel.ValueMember = "pl_labelcode"; ftpOperater ftp = new ftpOperater(); indate = new System.DateTime[dt.Rows.Count]; for (int i = 0; i < dt.Rows.Count; i++) { BaseUtil.GetPrintLabel(dt.Rows[i]["pl_labelname"].ToString(), dt.Rows[i]["pl_labelurl"].ToString(), dt.Rows[i]["pl_indate"].ToString()); indate[i] = Convert.ToDateTime(dt.Rows[i]["pl_indate"].ToString()); } } private void LoadCollectNum() { dt = (DataTable)dh.ExecuteSql("select ma_qty-mcd_inqty mcd_remainqty from make left join makecraftdetail on mcd_macode=ma_code where ma_code='" + ms_makecode.Text + "' and mcd_stepcode='" + User.CurrentStepCode + "'", "select"); BaseUtil.SetFormValue(Controls, dt); } private void 标签打印_FormClosing(object sender, FormClosingEventArgs e) { BaseUtil.ClosePrint(lbl); } } }