using LabelManager2; using System; using System.Data; using System.Text; using System.Windows.Forms; using UAS_MES.DataOperate; using UAS_MES.Entity; using UAS_MES.PublicMethod; using System.Drawing; using System.Threading; using UAS_MES.PublicForm; using System.IO.Ports; using System.IO; using System.Text.RegularExpressions; namespace UAS_MES.Make { public partial class Make_PackageCollectionWeigh : Form { DataHelper dh; DataTable dt; LogStringBuilder sql = new LogStringBuilder(); AutoSizeFormClass asc = new AutoSizeFormClass(); Document doc; ApplicationClass lbl; Thread thread; DataTable Dbfind; string ErrorMessage = ""; string oMakeCode = ""; string oMsID = ""; //称量的标准重量 double Weight; //最大重量 double MaxWeight; //最小重量 double MinWeight; decimal StandardQTY = 0; string oOutBoxCode = ""; string LastSncode; //创建串口实例 SerialPort serialPort1 = new SerialPort(); //true的时候表示从串口读取数据 bool GetData = true; System.DateTime[] indate; public Make_PackageCollectionWeigh() { InitializeComponent(); } //创建打印进程 private void NewPrint() { try { lbl = new ApplicationClass(); BaseUtil.WriteLbl(lbl); } catch (Exception ex) { OperateResult.AppendText("未正确安装CodeSoft软件\n", Color.Red); } } private void 包装采集_Load(object sender, EventArgs e) { pa_outboxcode.ShowClickIcon = false; ComList.Text = BaseUtil.GetCacheData("PortName").ToString(); Baurate.Text = BaseUtil.GetCacheData("BaudRate").ToString(); //设置DbFind的必须的数据 PrintNum.Value = 1; asc.controllInitializeSize(this); thread = new Thread(NewPrint); SetLoadingWindow stw = new SetLoadingWindow(thread, "初始化打印程序"); BaseUtil.SetFormCenter(stw); stw.ShowDialog(); dh = new DataHelper(); thread = new Thread(getSerialData); try { GetData = true; serialPort1.PortName = ComList.Text; serialPort1.BaudRate = int.Parse(Baurate.Text); serialPort1.Open(); thread.Start(); } catch (Exception mes) { if (Baurate.Text == "" || ComList.Text == "") OperateResult.AppendText(">>请先在电子秤调试界面维护波特率和串口\n", Color.Red); else OperateResult.AppendText(">>" + mes.Message + "\n", Color.Red); } } private void getSerialData() { if (serialPort1.IsOpen) { if (!SystemInf.OpenPort.Contains(serialPort1.PortName)) { SystemInf.OpenPort.Add(serialPort1.PortName); try { while (GetData) { try { weight.Text = Regex.Replace(serialPort1.ReadLine(), "\\D+", ""); if (pr_cartonunit.Text == "kg") weight.Text = (double.Parse(weight.Text) / 1000).ToString(); } catch (Exception) { GetData = false; } } } catch (IOException ex) { MessageBox.Show(ex.Message); } } else MessageBox.Show("端口已被占用,请关闭其他窗口"); } } private void 包装采集_SizeChanged(object sender, EventArgs e) { asc.controlAutoSize(this); } private void 包装采集_Activated(object sender, EventArgs e) { pa_outboxcode.Focus(); } //刷新表单的数据的数据 private void LoadData() { //加载表单数据 string Err = ""; sql.Clear(); sql.Append("select pa_prodcode,pr_cartonmaxw,pa_makecode,pr_cartonunit,pr_cartonminw,pr_cartongw,pa_outboxcode,pa_sccode,nvl(pa_downstatus,0) pa_downstatus,pa_checkno,"); sql.Append("pa_status,pr_packrule,pr_detail,pa_packageqty,nvl(pa_standardqty,0)pa_standardqty,pr_outboxinnerqty,pa_currentqty from package left join "); sql.Append("product on pa_prodcode=pr_code where pa_outboxcode='" + pa_outboxcode.Text + "'"); Err = "箱号"; DataTable dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select"); if (dt.Rows.Count > 0) { //重量的临时变量 string _weight = dt.Rows[0]["pr_cartongw"].ToString(); string _maxweight = dt.Rows[0]["pr_cartonmaxw"].ToString(); string _minweight = dt.Rows[0]["pr_cartonminw"].ToString(); //赋值重量单位 Weight = double.Parse(_weight == "" ? "0" : _weight); MaxWeight = double.Parse(_maxweight == "" ? "0" : _maxweight); MinWeight = double.Parse(_minweight == "" ? "0" : _minweight); //记录该数据保证在修改不被允许的前提下能偶回复之前的值 StandardQTY = decimal.Parse(dt.Rows[0]["pr_outboxinnerqty"].ToString()); BaseUtil.SetFormValue(this.Controls, dt); if (pa_standardqty.Text != "0") pr_outboxinnerqty.Text = pa_standardqty.Text; if (Weight - MinWeight == MaxWeight - Weight) pr_cartonboxgw.Text = Weight + "±" + (MaxWeight - Weight); else pr_cartonboxgw.Text = MinWeight + "-" + MaxWeight; } else OperateResult.AppendText(">>" + Err + "不存在\n", Color.Red); } private void LoadGridData() { //加载Grid数据 dt = (DataTable)dh.ExecuteSql("select pa_outboxcode,pa_prodcode,pd_barcode,pd_innerqty,pa_indate from packageDetail left join package on pa_id=pd_paid where pa_outboxcode='" + pa_outboxcode.Text + "'", "select"); BaseUtil.FillDgvWithDataTable(PackageDetail, dt); //更新界面的采集数量 pa_currentqty.Text = dh.getFieldDataByCondition("package", "pa_currentqty", "pa_outboxcode='" + pa_outboxcode.Text + "'").ToString(); } private void Print_Click(object sender, EventArgs e) { if (PrintLabel.Items.Count != 0) { if (dh.getFieldDataByCondition("package", "pa_status", "pa_outboxcode='" + pa_outboxcode.Text + "'").ToString() == "1") { dh.ExecuteSql("update package set pa_printcount=pa_printcount+1 where pa_outboxcode='" + pa_outboxcode.Text + "'", "update"); OperateResult.AppendText(">>开始打印箱号" + pa_outboxcode.Text + "\n", Color.Black); doc = lbl.Documents.Open(ftpOperater.DownLoadTo+ PrintLabel.Text.Split(':')[1]); Print.CodeSoft(Tag.ToString(), doc, PrintLabel.Text.Split(':')[1], PrintLabel.SelectedValue.ToString(), PrintList.Text, pa_outboxcode.Text, int.Parse(PrintNum.Text), indate[PrintLabel.SelectedIndex]); } else OperateResult.AppendText(">>箱号" + pa_outboxcode.Text + "尚未封箱,请封箱后执行打印\n", Color.Red); } else OperateResult.AppendText(">>产品" + pr_code.Text + "未维护打印标签\n", Color.Red); } //加载工单信息和装箱明细信息 private void pa_code_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.Enter) { LoadData(); LoadGridData(); } } //输入序列号的回车事件 private void barcode_KeyDown(object sender, KeyEventArgs e) { //当用户输入回车键的时候 if (e.KeyCode == Keys.Enter) { if (LogicHandler.CheckStepAttribute(Tag.ToString(), User.UserSourceCode, out ErrorMessage)) { if (LogicHandler.CheckStepSNAndMacode("", User.UserSourceCode, sn_code.Text, User.UserCode, out oMakeCode, out oMsID, out ErrorMessage)) { sql.Clear(); sql.Append("select ms_makecode,pr_code,nvl(pa_downstatus,0) pa_downstatus,pa_sccode,pa_checkno,pr_packrule,pr_code,pr_detail,"); sql.Append("pr_outboxinnerqty from makeserial left join product on ms_prodcode=pr_code left join packagedetail "); sql.Append("on pd_barcode=ms_sncode left join package on pa_id =pd_paid where ms_id='" + oMsID + "'"); dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select"); if (dt.Rows.Count > 0) { StandardQTY = decimal.Parse(dt.Rows[0]["pr_outboxinnerqty"].ToString()); BaseUtil.SetFormValue(this.Controls, dt); } if (pa_standardqty.Text != "0" && pa_standardqty.Text != "") { pr_outboxinnerqty.Value = int.Parse(pa_standardqty.Text); } if (pa_outboxcode.Text == "") { string boxcode = dh.getFieldDataByCondition("makeserial", "ms_outboxcode", "ms_id='" + oMsID + "'").ToString(); if (boxcode != "") { pa_outboxcode.Text = boxcode; LoadGridData(); } else { if (AutoGenBoxCode.Checked && (pa_status.Text == "1" || pa_status.Text == "")) pa_outboxcode.GeneratePaCode_Click(new object(), new EventArgs()); } } if (pa_outboxcode.Text == "") { OperateResult.AppendText(">>箱号不能为空\n", Color.Red, sn_code); return; } if (pa_status.Text != "1") { //按工单核对装箱 switch (pr_packrule.Text.ToUpper()) { case "MAKE": if (dh.getFieldDataByCondition("makeserial", "ms_makecode", "ms_id='" + oMsID + "'").ToString() != pa_makecode.Text) { OperateResult.AppendText(">>序列号" + sn_code.Text + "所属工单和当前箱号工单不相等\n", Color.Red, sn_code); return; } break; case "SALE": if (dh.CheckExist("package", "pa_outboxcode='" + pa_outboxcode.Text + "'")) { sql.Clear(); sql.Append("select 1 from package left join make on pa_salecode=ma_salecode and pa_prodcode=ma_prodcode left join makeserial "); sql.Append("on ma_code=ms_makecode where pa_outboxcode='" + pa_outboxcode.Text + "' and ms_id='" + oMsID + "'"); DataTable dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select"); if (dt.Rows.Count == 0) { OperateResult.AppendText(">>序列号" + sn_code.Text + "所属订单号和当前箱号订单不相等\n", Color.Red, sn_code); return; } } break; case "PROD": if (dh.getFieldDataByCondition("makeserial", "ms_prodcode", "ms_id='" + oMsID + "'").ToString() != pr_code.Text) { OperateResult.AppendText(">>序列号" + sn_code.Text + "对应物料和该箱所装物料不同\n", Color.Red, sn_code); return; } break; case "MIX": break; default: break; } } //判断箱内总数必须大于0 if (pr_outboxinnerqty.Text == "" || pr_outboxinnerqty.Text == "0") { OperateResult.AppendText(">>箱内容量必须大于0\n", Color.Red); return; } //如果未勾选了取消录入 if (!Cancel.Checked) { //判断序列号是否已经装箱 if (dh.getFieldDataByCondition("makeserial", "ms_outboxcode", "ms_id='" + oMsID + "'").ToString() != "") { OperateResult.AppendText(">>序列号" + sn_code.Text + "已经装箱!\n", Color.Red, sn_code); } else { //满箱之后采集下一个之前自动清除内容,生成新的箱号 if ((AutoGenBoxCode.Checked && pa_currentqty.Text != "" && pr_outboxinnerqty.Text == pa_currentqty.Text) || (AutoGenBoxCode.Checked && pa_status.Text == "1")) { pa_currentqty.Text = ""; pa_outboxcode.Text = ""; pa_status.Text = "0"; BaseUtil.CleanDGVData(PackageDetail); pa_outboxcode.GeneratePaCode_Click(new object(), new EventArgs()); } ////箱号不存在的情况 if (LogicHandler.Packing(sn_code.Text, pa_outboxcode.Text, AutoGenBoxCode.Checked, "标准", User.UserSourceCode, User.UserCode, pr_outboxinnerqty.Text, Cancel.Checked, out oOutBoxCode, out ErrorMessage)) { if (LogicHandler.SetStepResult(ms_makecode.Text, User.UserSourceCode, sn_code.Text, "包装采集", "装箱成功", User.UserCode, out ErrorMessage)) { LoadCheckQTY(); OperateResult.AppendText(">>序列号" + sn_code.Text + "采集成功!\n", Color.Green); //满箱更新状态为1 LoadData(); if (int.Parse(pa_currentqty.Text == "" ? "0" : pa_currentqty.Text) == int.Parse(pr_outboxinnerqty.Text)) { //检查重量合格 if (float.Parse(weight.Text) > MinWeight && float.Parse(weight.Text) < MaxWeight) { dh.UpdateByCondition("package", "pa_status=1,pa_packageqty=pa_currentqty,pa_weight='" + weight.Text + "'", "pa_outboxcode='" + pa_outboxcode.Text + "'"); pa_standardqty.Text = ""; pa_status.Text = "1"; OperateResult.AppendText(">>箱号" + pa_outboxcode.Text + "称量合格\n", Color.Green); LastSncode = sn_code.Text; if (AutoPrint.Checked) Print_Click(new object(), new EventArgs()); } else OperateResult.AppendText(">>箱号" + pa_outboxcode.Text + "重量不符合标准重量\n", Color.Red); } LoadGridData(); sn_code.Clear(); } } else OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red); } } //勾选了取消箱号先验证箱号存不存在,存在的话移除掉,重新加载一次数据 else { if (LogicHandler.Packing(sn_code.Text, pa_outboxcode.Text, AutoGenBoxCode.Checked, "标准", User.UserSourceCode, User.UserCode, pr_outboxinnerqty.Text, Cancel.Checked, out oOutBoxCode, out ErrorMessage)) { LogicHandler.DoCommandLog(Tag.ToString(), User.UserCode, oMakeCode, User.UserLineCode, User.UserSourceCode, "装箱采集", "取消采集成功", sn_code.Text, ""); LoadGridData(); pa_status.Text = "0"; OperateResult.AppendText(">>已从该箱中移除序列号" + sn_code.Text + "\n", Color.Green, sn_code); } else OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red, sn_code); } } else OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red, sn_code); } else OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red, sn_code); } } private void Clean_Click(object sender, EventArgs e) { OperateResult.Clear(); } private void pr_code_TextChanged(object sender, EventArgs e) { LoadCheckQTY(); pa_outboxcode.MakeCode = pa_makecode.Text; pa_outboxcode.ProdCode = pr_code.Text; pa_outboxcode.Caller = "PACKAGE"; dt = (DataTable)dh.ExecuteSql("select pl_labelcode||':'||pl_labelname pl_laname,pl_labelname,pl_labelcode,pl_labelurl,pl_indate from productlabel where pl_prodcode='" + pr_code.Text + "' and pl_labeltype='卡通箱标' order by pl_isdefault desc ", "select"); PrintLabel.DataSource = dt; PrintLabel.DisplayMember = "pl_laname"; 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 包装采集_FormClosing(object sender, FormClosingEventArgs e) { BaseUtil.ClosePrint(lbl); if (serialPort1.IsOpen) { GetData = false; serialPort1.Close(); SystemInf.OpenPort.Remove(serialPort1.PortName); thread.Interrupt(); } dh.Dispose(); } private void Packing_Click(object sender, EventArgs e) { if (dh.CheckExist("package", "pa_outboxcode='" + pa_outboxcode.Text + "' and pa_status<>1")) { dh.UpdateByCondition("package", "pa_status=1,pa_totalqty=pa_currentqty,pa_packageqty=pa_currentqty", "pa_outboxcode='" + pa_outboxcode.Text + "'"); pa_status.Text = "1"; LogicHandler.DoCommandLog(Tag.ToString(), User.UserCode, oMakeCode, User.UserLineCode, User.UserSourceCode, "装箱采集", "封箱成功", pa_outboxcode.Text, ""); OperateResult.AppendText(">>箱号" + pa_outboxcode.Text + "封箱成功\n", Color.Green); } else OperateResult.AppendText(">>箱号" + pa_outboxcode.Text + "错误或者已封箱\n", Color.Red); } private void SendCheck_Click(object sender, EventArgs e) { if (dh.getFieldDataByCondition("package", "pa_status", "pa_outboxcode='" + pa_outboxcode.Text + "'").ToString() != "0") { DataTable dt = (DataTable)dh.ExecuteSql("select wm_concat(pa_outboxcode) pa_outboxcode from package where pa_checkno='" + ob_checkno.Text + "' and pa_status=0 ", "select"); if (dt.Rows[0][0].ToString() != "") { OperateResult.AppendText(">>批次" + ob_checkno.Text + "存在箱号" + dt.Rows[0][0].ToString() + "未封箱,请先进行封箱\n", Color.Red); return; } sql.Clear(); sql.Append("update oqcbatch set ob_status='UNCHECK' where ob_checkno ='" + ob_checkno.Text + "'"); dh.ExecuteSql(sql.GetString(), "select"); ob_nowcheckqty.Text = ""; ob_batchqty.Text = ""; ob_nowcheckqty.ForeColor = Color.Black; SendCheck.Enabled = false; OperateResult.AppendText(">>批次" + ob_checkno.Text + "送检成功\n", Color.Green); LogicHandler.InsertMakeProcess(LastSncode, oMakeCode, User.UserSourceCode, "手动送检", "手动送检成功", User.UserCode); //记录操作日志 LogicHandler.DoCommandLog(Tag.ToString(), User.UserCode, oMakeCode, User.UserLineCode, User.UserSourceCode, "手动送检", "手动送检成功", "", ob_checkno.Text); ob_checkno.Text = ""; } else OperateResult.AppendText(">>必须封箱才能送检\n", Color.Red); } bool AutoCut; private void LoadCheckQTY() { sql.Clear(); string condition = ""; int nowcheckqty = int.Parse(ob_nowcheckqty.Text == "" ? "0" : ob_nowcheckqty.Text); int batchqty = int.Parse(ob_batchqty.Text == "" ? "0" : ob_batchqty.Text); if (nowcheckqty + 1 == batchqty && AutoCut) { condition = "and ob_status='UNCHECK' and ob_checkno='" + ob_checkno.Text + "'"; } else { condition = "and ob_status='ENTERING' "; } sql.Append("select ob_batchqty,ob_nowcheckqty,ob_checkno from oqcbatch where "); sql.Append("ob_linecode='" + User.UserLineCode + "' and ob_prodcode='" + pr_code.Text + "' and "); sql.Append("ob_stepcode='" + User.CurrentStepCode + "' " + condition); DataTable dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select"); if (dt.Rows.Count > 0) { ob_batchqty.Text = dt.Rows[0]["ob_batchqty"].ToString(); ob_nowcheckqty.Text = dt.Rows[0]["ob_nowcheckqty"].ToString(); ob_checkno.Text = dt.Rows[0]["ob_checkno"].ToString(); nowcheckqty = int.Parse(ob_nowcheckqty.Text == "" ? "0" : ob_nowcheckqty.Text); batchqty = int.Parse(ob_batchqty.Text == "" ? "0" : ob_batchqty.Text); if (nowcheckqty == batchqty) { ob_nowcheckqty.ForeColor = Color.Red; OperateResult.AppendText(">>当前采集数量已达到送检数量\n", Color.Red); } } else { ob_batchqty.Text = ""; ob_nowcheckqty.Text = ""; ob_checkno.Text = ""; SendCheck.Enabled = false; } if (ob_batchqty.Text != "") { SendCheck.Enabled = true; } else { SendCheck.Enabled = false; } } private void ob_checkno_TextChanged(object sender, EventArgs e) { if (ob_checkno.Text != "") { string Cut = dh.getFieldDataByCondition("product left join oqcbatch on ob_prodcode=pr_code", "pr_ifautocutcheckno", "ob_checkno='" + ob_checkno.Text + "'").ToString(); if (Cut == "" || Cut == "0") AutoCut = false; else AutoCut = true; SendCheck.Enabled = true; } } private void pr_outboxinnerqty_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.Enter) ResetPackQTY(); } private void pr_outboxinnerqty_Leave(object sender, EventArgs e) { ResetPackQTY(); } private void ResetPackQTY() { //数据不符合限制的时候保持原有值 int curretnqty = int.Parse(pa_currentqty.Text == "" ? "0" : pa_currentqty.Text); if (!(pr_outboxinnerqty.Value >= curretnqty)) { pr_outboxinnerqty.Value = StandardQTY; } else { if (dh.CheckExist("package", "pa_outboxcode='" + pa_outboxcode.Text + "'")) { string checknostatus = dh.getFieldDataByCondition("oqcbatch", "ob_status", "ob_checkno='" + pa_checkno.Text + "'").ToString(); if (checknostatus == "" || checknostatus == "ENTERING") { if (pa_downstatus.Text == "0") { if (dh.CheckExist("source", "sc_code='" + pa_sccode.Text + "' and sc_stepcode='" + User.CurrentStepCode + "'")) { dh.UpdateByCondition("package", "pa_standardqty='" + pr_outboxinnerqty.Value + "'", "pa_outboxcode='" + pa_outboxcode.Text + "'"); LogicHandler.DoCommandLog(Tag.ToString(), User.UserCode, "", User.UserLineCode, User.UserSourceCode, "修改箱内容量", "原容量" + StandardQTY + ",修改为" + pr_outboxinnerqty.Value + "'", pa_outboxcode.Text, pa_checkno.Text); return; } else OperateResult.AppendText(">>箱号" + pa_outboxcode.Text + "当前所在工序不是登录岗位资源所在工序,不允许修改数量\n", Color.Red); } else OperateResult.AppendText(">>箱号" + pa_outboxcode.Text + "处于下地状态,不允许修改标准容量\n", Color.Red); } else OperateResult.AppendText(">>箱号" + pa_outboxcode.Text + "处于送检中,不允许修改标准容量\n", Color.Red); } else OperateResult.AppendText(">>箱号" + pa_outboxcode.Text + "不存在,修改容量无效\n", Color.Red); pr_outboxinnerqty.Value = StandardQTY; } } } }