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; 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(); //保存make left join makecraftdetail left join product的数据 DataTable mapB; //保存ProductLabel数据 DataTable ListC; //工序编号 string stepcode; //下一工序编号 string nextstepcode; //工艺路线编号 string craftcode; //制造单号 string ma_code; //当前工单的序列号 //string sn_code; //当前提示的索引 int RemainIndex = 0; //string Step = "Loading"; ApplicationClass lbl; public Make_ColorBoxLoadPrint() { InitializeComponent(); //默认选中上料 load.Checked = true; } private void 标签打印_Load(object sender, EventArgs e) { dh = new DataHelper(); code.Focus(); asc.controllInitializeSize(this); lbl = new ApplicationClass(); } private void sn_code_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.Enter) { if (code.Text == "") { OperateResult.AppendText(">>输入内容不能为空\n", Color.Red); return; } //string Omakecode; //string Omsid; //string Oerrormessage; //LogicHandler.CheckStepSNAndMacode(ms_makecode.Text, User.UserSourceCode, code.Text, User.UserCode, out Omakecode, out Omsid, out Oerrormessage) //通过输入指定字符来设置当前执行的步骤 if (load.Checked=true) { OperateResult.AppendText(">>开始执行上料工序\n", Color.Green); } else if (unload.Checked=true) { OperateResult.AppendText(">>开始执行下料工序\n", Color.Green); } //判断如果该序列号的归属工单和之前查询的是一致的话，就不进行重复数据的查询 ma_code = dh.getFieldDataByCondition("makeserial", "ms_makecode", "ms_sncode='" + code.Text + "'").ToString(); if (ms_makecode.Text != ma_code || ma_code == "") { //ma_code不为空的时候表示不是第一次加载，提示用户切换工单 if (ma_code != "" && ms_makecode.Text != "") { OperateResult.AppendText(">>切换工单至工单号" + ma_code + "\n", Color.Red); } sql.Clear(); sql.Append("select ma_code as ms_makecode,mcd_okqty,ma_qty,ma_qty-mcd_inqty as mcd_remainqty,pr_detail,pr_code "); sql.Append("from makeserial left join make on ms_makecode=ma_code left join product on "); sql.Append("ms_prodcode=pr_code left join makecraftdetail on ms_makecode=mcd_macode where ms_sncode=:sncode"); dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select", code.Text); if (dt.Rows.Count > 0) { BaseUtil.SetFormValue(this.Controls, dt); sncode.Text = code.Text; } else { OperateResult.AppendText(">>序列号" + code.Text + "不存在\n", Color.Red); return; } //判断当前的执行状态 ,Loading表示执行上料操作，UnLoading表示执行下料操作 if (load.Checked=true) { sql.Clear(); sql.Append("select ma_code,ma_craftcode,ms_nextstepcode, ms_status,ms_stepcode from makeserial "); sql.Append("left join make on ma_code=ms_makecode where ms_sncode=:sncode or ms_psn=:sncode"); dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select", code.Text, code.Text); //记录一些变量 stepcode = dt.Rows[0]["ms_stepcode"].ToString(); nextstepcode = dt.Rows[0]["ms_nextstepcode"].ToString(); craftcode = dt.Rows[0]["ma_craftcode"].ToString(); string ErrorMessage; string Omakecode; string Omsid; //string Oerrormessage; //检测当前序列号和岗位资源是否对应 if (LogicHandler.CheckStepSNAndMacode(ms_makecode.Text, User.UserSourceCode, code.Text, User.UserCode, out Omakecode, out Omsid, out ErrorMessage)) { //判断当前工序是否是上料工序cd_ifinput或者是否是测试工序cd_iftest sql.Clear(); sql.Append("select cr_code,cd_stepcode,cd_ifinput,cd_iftest from makeserial left join craft on ms_craftcode=cr_code left join craftdetail on cd_crid=cr_id and "); sql.Append("cd_stepcode=ms_nextstepcode where ms_sncode='" + code.Text + "' and ms_makecode='" + ms_makecode.Text + "'"); dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select"); if (dt.Rows.Count > 0) { //如果是上料工序 if (dt.Rows[0]["cd_ifinput"].ToString() != "0") { // 查询没有结果，提示该上料工序没有需要上料的数据，请先维护对应的数据 sql.Clear(); sql.Append("select sp_id,sp_description,sp_soncode,pr_detail,pr_spec,sp_repcode,pr_id,sp_type,"); sql.Append("'未采集' sp_ifpick ,sp_prefix,sp_length,sp_regex,sp_regex,sp_ifforsn from stepproduct "); sql.Append("left join product on pr_code=sp_soncode where sp_craftcode='" + dt.Rows[0]["cd_ifinput"].ToString() + "' and sp_stepcode='" + dt.Rows[0]["cd_stepcode"].ToString() + "' "); sql.Append("And sp_mothercode='" + pr_code.Text + "' and ((sp_type='物料' and pr_tracekind<>2)or sp_type<>'物料') "); sql.Append("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", Color.Green); } //未查询到数据时标识是测试工序 else { DoTestProcedure(); } } //同上，如果,iftest不等于0也进入测试工序 else if (dt.Rows[0]["cd_iftest"].ToString() != "0") { DoTestProcedure(); } } } else { Print.CodeSoft(lbl, PrintLabel.Text, PrintLabel.SelectedValue.ToString(), Printer.Text, code.Text); OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red); } } //如果执行的是下料操作 else if (unload.Checked=true) { string ErrorMessage1 = ""; if (LogicHandler.SetMaterialDown(sncode.Text, code.Text,User.UserSourceCode, User.CurrentStepCode, User.UserName, out ErrorMessage1)) { OperateResult.AppendText(">>条码" + code.Text + "下料成功\n", Color.Green); } else { OperateResult.AppendText(">>" + ErrorMessage1 + "\n", Color.Red); } } } else { //如果ListA中没有数据执行的是测试工序 if (ListA.Rows.Count == 0) { DoTestProcedure(); } //存在数据执行的是上料采集 else { //如果当前的索引和长度相等则表示采集完成 if (RemainIndex == ListA.Rows.Count - 1) { OperateResult.AppendText(">>序列号对应的工单已经采集完成\n", Color.Green); sncode.Text = ""; return; } string ErrorMessage; //获取上料需要传递的参数，sp_soncode,sp_id string soncode = ListA.Rows[RemainIndex]["sp_soncode"].ToString(); string sonID = ListA.Rows[RemainIndex]["sp_id"].ToString(); //执行上料 if (LogicHandler.SetMaterialUp(sncode.Text, ms_makecode.Text, code.Text, soncode, User.UserSourceCode, User.UserName, sonID, out ErrorMessage)) { RemainIndex = RemainIndex + 1; OperateResult.AppendText(">>请采集物料编号为" + ListA.Rows[RemainIndex]["sp_soncode"].ToString() + "的条码\n", Color.Green); } else { OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red); } } } } } private void 标签打印_SizeChanged(object sender, EventArgs e) { asc.controlAutoSize(this); } //执行测试工序 private void DoTestProcedure() { //局部变量ErrorMessage1 string ErrorMessage1; //由于打印驱动暂时不可用，暂时注释打印方法 if (LogicHandler.SetCollectionFinish(code.Text, ms_makecode.Text, User.UserName, User.UserSourceCode, out ErrorMessage1)) { sncode.Text = ""; //如果值为空默认设置为0 if (int.Parse(mcd_remainqty.Text) > 0) { dh.UpdateByCondition("makecraftdetail", "mcd_okqty=mcd_okqty+1,mcd_inqty=mcd_inqty+1", "mcd_macode='" + ms_makecode.Text + "'"); sql.Clear(); sql.Append("select mcd_okqty,ma_qty-mcd_inqty mcd_remainqty from makecraftdetail left join make on "); sql.Append("ma_code=mcd_macode where mcd_macode='" + ms_makecode.Text + "'"); dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select"); BaseUtil.SetFormValue(this.Controls, dt); if (mcd_remainqty.Text == "0") { OperateResult.AppendText(">>工单" + ms_makecode.Text + "采集完成\n", Color.Green); BaseUtil.CleanForm(this); } } else { BaseUtil.CleanForm(this); OperateResult.AppendText(">>该序列号所属工单" + ms_makecode.Text + "已全部采集完成\n", Color.Green); } } else MessageBox.Show(ErrorMessage1); } private void 标签打印_Activated(object sender, EventArgs e) { sncode.Focus(); } private void pr_code_TextChanged(object sender, EventArgs e) { dt = (DataTable)dh.ExecuteSql("select pl_labelname,pl_labelcode from productlabel where pl_prodcode='" + pr_code.Text + "' order by pl_isdefault desc", "select"); PrintLabel.DataSource = dt; PrintLabel.DisplayMember = "pl_labelname"; PrintLabel.ValueMember = "pl_labelcode"; ftpOperater ftp = new ftpOperater(); for (int i = 0; i < dt.Rows.Count; i++) { ftp.Download(dt.Rows[i]["pl_labelname"].ToString()); } } private void 标签打印_FormClosing(object sender, FormClosingEventArgs e) { lbl.Quit(); } } }