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_NEW; using UAS_MES_NEW.DataOperate; using UAS_MES_NEW.Entity; using UAS_MES_NEW.PublicMethod; namespace UAS_MES_NEW.Make { public partial class Make_SMTStencil_1 : Form { DataTable Dbfind; bool ifUsed = false; AutoSizeFormClass asc = new AutoSizeFormClass(); DataHelper dh = SystemInf.dh; StringBuilder sql = new StringBuilder(); public Make_SMTStencil_1() { InitializeComponent(); SU_DEVCODE.Enabled = false; st_combinenumber.Enabled = false; SU_DEVCODE1.Enabled = false; st_table.Enabled = false; su_singlepringqty1.Enabled = false; Receive.Enabled = false; Return.Enabled = false; SU_DEVCODE.Enabled = false; SU_DEVCODE1.Enabled = false; //ST_ENSIONA.Enabled = false; //ST_ENSIONB.Enabled = false; //ST_ENSIONC.Enabled = false; //ST_ENSIOND.Enabled = false; //ST_ENSIONE.Enabled = false; Scrap.Enabled = false; } private void Make_SMTStencil_Load(object sender, EventArgs e) { asc.controllInitializeSize(this); li_code.Text = User.UserLineCode; //工单号放大镜配置 ma_code.TableName = "make left join product on ma_prodcode=pr_code"; ma_code.SelectField = "ma_code # 工单号,ma_prodcode # 产品编号,ma_qty # 工单数量,pr_detail # 产品名称,ma_softversion # 软件版本,ma_salecode # 销售单号,pr_sendchecktype # 产品送检方式"; ma_code.FormName = Name; ma_code.SetValueField = new string[] { "ma_code", "ma_prodcode", "ma_qty", "pr_detail", "ma_softversion", "ma_salecode", "nvl(pr_sendchecktype,'LineCode')pr_sendchecktype" }; ma_code.DbChange += Ma_code_DbChange; li_code.TableName = "Line"; li_code.SelectField = "li_code # 线别编号,li_name # 线别名称"; li_code.Condition = "li_wccode='SMT'"; li_code.FormName = Name; li_code.SetValueField = new string[] { "li_code", "li_name" }; li_code.DbChange += Li_code_DbChange; ma_code.Controls["TextBox"].Focus(); } private void Li_code_DbChange(object sender, EventArgs e) { Dbfind = li_code.ReturnData; BaseUtil.SetFormValue(this.Controls, Dbfind); } private void Ma_code_DbChange(object sender, EventArgs e) { Dbfind = ma_code.ReturnData; BaseUtil.SetFormValue(this.Controls, Dbfind); Confirm.PerformClick(); } private void Make_SMTStencil_SizeChanged(object sender, EventArgs e) { asc.controlAutoSize(this); } private void LoadGridData() { sql.Clear(); sql.Append("select St_PCBCODE,su_stcode,su_table,su_status,su_linecode,su_usemacode,su_singlepringqty,su_stverison "); sql.Append("from StencilUse left join stencil on st_code=su_stcode where su_usemacode='" + ma_code.Text + "' and su_status='在线'"); DataTable dt = (DataTable)dh.ExecuteSql(sql.ToString(), "select"); BaseUtil.FillDgvWithDataTable(ToolsBom, dt); } private void Confirm_Click(object sender, EventArgs e) { LoadGridData(); } private void Receive_Click(object sender, EventArgs e) { if (ma_code.Text == "") { MessageBox.Show("工单号不能为空"); } DataTable dt; int WaringCount = int.Parse(dh.GetConfig("WaringCount", "Stencil").ToString()); dt = (DataTable)dh.ExecuteSql("select st_kind,ST_USESTATUS,st_version,nvl(st_maxusecount,0)st_maxusecount,nvl(st_usecount,0)st_usecount from Stencil where upper(st_code)='" + (SU_DEVCODE.Text.ToUpper()) + "' and st_statuscode='AUDITED'", "select"); string st_kind = ""; string status = ""; string version = ""; int st_maxusecount = 0; int st_usecount = 0; if (dt.Rows.Count > 0) { st_kind = dt.Rows[0]["st_kind"].ToString(); status = dt.Rows[0]["ST_USESTATUS"].ToString(); version = dt.Rows[0]["st_version"].ToString(); st_maxusecount = int.Parse(dt.Rows[0]["st_maxusecount"].ToString()); st_usecount = int.Parse(dt.Rows[0]["st_usecount"].ToString()); if (status == "在线" || status == "报废"/* || status == "在仓"*/) { MessageBox.Show("当前" + st_kind + SU_DEVCODE.Text + "处于" + status + "状态,无法领用"); return; } } else { MessageBox.Show("编号" + SU_DEVCODE.Text + "不存在或者未审核"); return; } //使用次数预警 if (st_maxusecount - st_usecount < WaringCount) { string close = MessageBox.Show(this.ParentForm, "已使用" + st_usecount + "，距离使用上限还有" + (st_maxusecount - st_usecount) + "次", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question).ToString(); if (close != "Yes") { return; } } if (st_kind == "钢网") { //限制钢网使用的产品 dt = (DataTable)dh.ExecuteSql("select 1 from STENILCANUSEPRO where upper(sp_stcode)='" + SU_DEVCODE.Text.ToUpper() + "' and sp_prodcode='" + ma_prodcode.Text + "'", "select"); if (dt.Rows.Count == 0) { dt = (DataTable)dh.ExecuteSql("select 1 from makematerial where mm_code='" + ma_code.Text + "' and mm_prodcode in (select SP_PRODCODE from " + "STENILCANUSEPRO where upper(SP_STCODE)='" + SU_DEVCODE.Text.ToUpper() + "')", "select"); if (dt.Rows.Count == 0) { MessageBox.Show("钢网编号" + SU_DEVCODE.Text + "不能在产品" + ma_prodcode.Text + "中使用"); return; } } } dt = (DataTable)dh.ExecuteSql("select em_name from employee where em_code='" + em_code.Text + "'", "select"); if (dt.Rows.Count > 0) { if (int.Parse(su_singlepringqty1.Text) > 0) { string em_name = dt.Rows[0]["em_name"].ToString(); sql.Clear(); sql.Append("insert into StencilUse(su_id,SU_USEPRODCODE,SU_CLEANNUMS,su_stid,su_linecode,su_stcode,su_usedate,su_useman,SU_USEMANCODE,SU_TABLE,su_usemacode,su_singlepringqty,su_stverison,SU_STATUS)"); sql.Append("select StencilUse_seq.nextval,'" + ma_prodcode.Text + "',ST_CLEANNUMS,st_id,'" + li_code.Text + "','" + SU_DEVCODE.Text + "',sysdate,'" + em_name + "','" + em_code.Text + "','" + st_table.Text + "','" + ma_code.Text + "'"); sql.Append(",'" + su_singlepringqty1.Text + "',st_version,'在线' from "); sql.Append("Stencil where upper(st_code)='" + SU_DEVCODE.Text.ToUpper() + "'"); dh.ExecuteSql(sql.ToString(), "insert"); dt = (DataTable)dh.ExecuteSql("select ST_USESTATUS,St_USECOUNT from Stencil where upper(st_code)='" + SU_DEVCODE.Text.ToUpper() + "' and st_statuscode='AUDITED'", "select"); string St_USECOUNT = dt.Rows[0]["St_USECOUNT"].ToString(); dt = (DataTable)dh.ExecuteSql("select em_name from employee where em_code='" + em_code.Text + "'", "select"); if (dt.Rows.Count > 0) { sql.Clear(); sql.Append("update StencilUse set SU_ENSIONA='" + ST_ENSIONA.Text + "',SU_ENSIONB='" + ST_ENSIONB.Text + "',SU_ENSIONC='" + ST_ENSIONC.Text + "',SU_ENSIOND='" + ST_ENSIOND.Text + "',SU_ENSIONE='" + ST_ENSIONE.Text + "' "); sql.Append("where su_id=(select max(su_id) from stenciluse where su_stcode='" + SU_DEVCODE.Text + "' and su_status='在线')"); dh.ExecuteSql(sql.ToString(), "update"); } dh.ExecuteSql("update Stencil set ST_USESTATUS='在线' where st_code='" + SU_DEVCODE.Text + "'", "update"); MessageBox.Show("领用成功"); st_table.SelectedItem = null; SU_DEVCODE.Text = ""; em_code.Text = ""; Receive.Enabled = false; LoadGridData(); } else { MessageBox.Show("单片印刷次数必须大于0"); } } else { MessageBox.Show("人员编号" + em_code.Text + "不存在"); } } private void Return_Click(object sender, EventArgs e) { if (SU_RETURNIFCLEAN.Checked) { DataTable dt = (DataTable)dh.ExecuteSql("select st_kind,ST_USESTATUS,St_USECOUNT from Stencil where st_code='" + SU_DEVCODE1.Text + "' and st_statuscode='AUDITED'", "select"); if (dt.Rows.Count > 0) { string status = dt.Rows[0]["ST_USESTATUS"].ToString(); string st_kind = dt.Rows[0]["st_kind"].ToString(); if (status == "在仓" || status == "在仓") { MessageBox.Show("当前" + st_kind + SU_DEVCODE.Text + "未在线,无需归还"); return; } if (status == "报废") { MessageBox.Show("当前" + st_kind + SU_DEVCODE.Text + "处于" + status + "状态,无法退回"); return; } } else { MessageBox.Show("编号" + SU_DEVCODE1.Text + "不存在或者未审核"); } string St_USECOUNT = dt.Rows[0]["St_USECOUNT"].ToString(); dt = (DataTable)dh.ExecuteSql("select em_name from employee where em_code='" + em_code1.Text + "'", "select"); if (dt.Rows.Count > 0) { if (int.Parse(st_combinenumber.Text) >= 0) { sql.Clear(); sql.Append("update StencilUse set SU_ENSIONA='" + ST_ENSIONA.Text + "',SU_ENSIONB='" + ST_ENSIONB.Text + "',SU_ENSIONC='" + ST_ENSIONC.Text + "',SU_ENSIOND='" + ST_ENSIOND.Text + "',SU_ENSIONE='" + ST_ENSIONE.Text + "',su_cleannums=nvl(su_cleannums,0)+1, SU_BACKDATE=sysdate,su_returnman='" + dt.Rows[0]["em_name"].ToString() + "',su_returnmancode='" + em_code1.Text + "',"); sql.Append("SU_THISUSETIMES='" + (st_combinenumber.Text == "" ? "0" : st_combinenumber.Text) + "',SU_STATUS='在仓',su_usecount=" + (St_USECOUNT == "" ? "0" : St_USECOUNT) + "+" + st_combinenumber.Text); sql.Append(",SU_RETURNIFCLEAN='" + (SU_RETURNIFCLEAN.Checked ? "-1" : "0") + "' where su_id=(select max(su_id) from stenciluse where su_stcode='" + SU_DEVCODE1.Text + "' and su_status='在线')"); dh.ExecuteSql(sql.ToString(), "update"); sql.Clear(); sql.Append("update Stencil set st_cleannums=nvl(st_cleannums,0)+1,ST_USESTATUS='在仓',st_usecount=nvl(st_usecount,0)+" + (st_combinenumber.Text == "" ? "0" : st_combinenumber.Text) + " where st_code='" + SU_DEVCODE1.Text + "'"); dh.ExecuteSql(sql.ToString(), "update"); MessageBox.Show(SU_DEVCODE1.Text + "退回成功！"); SU_DEVCODE1.Text = ""; st_combinenumber.Text = ""; em_code1.Text = ""; SU_RETURNIFCLEAN.Checked = false; Return.Enabled = false; Confirm.PerformClick(); } else { MessageBox.Show("加工小板数必须大于等于0"); } } else { MessageBox.Show("人员编号" + em_code1.Text + "不存在"); } } else { MessageBox.Show("请确认是否清洗"); } } private void Radio_CheckedChanged(object sender, EventArgs e) { switch ((sender as Control).Name) { case "RadioReceive": if ((sender as RadioButton).Checked) { SU_DEVCODE.Enabled = true; Receive.Enabled = true; st_table.Enabled = true; su_singlepringqty1.Enabled = true; Receive.Enabled = true; st_combinenumber.Enabled = false; SU_DEVCODE1.Enabled = false; Return.Enabled = false; } break; case "RadioReturn": if ((sender as RadioButton).Checked) { SU_DEVCODE1.Enabled = true; st_combinenumber.Enabled = true; Return.Enabled = true; SU_DEVCODE.Enabled = false; st_table.Enabled = false; su_singlepringqty1.Enabled = false; Receive.Enabled = false; } break; default: break; } } private void SU_DEVCODE_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.Enter) { SU_DEVCODE.Text = SU_DEVCODE.Text.Replace(" ", ""); DataTable dt = (DataTable)dh.ExecuteSql("select st_kind,st_usestatus,st_table from stencil where st_code='" + SU_DEVCODE.Text + "' and st_statuscode='AUDITED'", "select"); if (dt.Rows.Count == 0) { MessageBox.Show("编号" + SU_DEVCODE.Text + "不存在或者未审核"); } if (dt.Rows.Count > 0) { string st_kind = dt.Rows[0]["st_kind"].ToString(); for (int i = 0; i < st_table.Items.Count; i++) { if (st_table.Items[i].ToString() == dt.Rows[0]["st_table"].ToString()) { st_table.SelectedItem = st_table.Items[i]; } } Receive.Enabled = true; if (dt.Rows[0]["st_usestatus"].ToString() == "报废") { MessageBox.Show(st_kind + "编号" + SU_DEVCODE.Text + "已报废"); } } } } private void SU_DEVCODE1_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.Enter) { SU_DEVCODE1.Text = SU_DEVCODE1.Text.Replace(" ", ""); DataTable dt = (DataTable)dh.ExecuteSql("select case when nvl(ST_COMBINENUMBER,1)=0 then 1 else nvl(ST_COMBINENUMBER,1) end from STENCIL where st_code='" + SU_DEVCODE1.Text + "' and st_statuscode='AUDITED'", "select"); if (dt.Rows.Count > 0) { try { st_combinenumber.Text = (Math.Ceiling(decimal.Parse(ma_qty.Text) / decimal.Parse(dt.Rows[0][0].ToString()))).ToString(); } catch (Exception) { } } else { MessageBox.Show("钢网编号" + SU_DEVCODE1.Text + "不存在或者未审核"); } dt = (DataTable)dh.ExecuteSql("select nvl(st_usecount,0)st_usecount,case when nvl(ST_COMBINENUMBER,1)=0 then 1 else nvl(ST_COMBINENUMBER,1) end from STENCIL where st_code='" + SU_DEVCODE1.Text + "' and st_statuscode='AUDITED'", "select"); if (dt.Rows.Count == 0) { MessageBox.Show("钢网编号" + SU_DEVCODE1.Text + "不存在或者未审核"); } else { st_usecount.Text = dt.Rows[0]["st_usecount"].ToString(); if (int.Parse(st_usecount.Text) > 0) { ifUsed = true; } else { ifUsed = false; } } } } //默认范围39-55，如不在范围内则可以报废 private void ST_ENSION_TextChanged(object sender, EventArgs e) { double Range = 0; List Num = new List(); Num.Add(ST_ENSIONA.Text); Num.Add(ST_ENSIONB.Text); Num.Add(ST_ENSIONC.Text); Num.Add(ST_ENSIOND.Text); Num.Add(ST_ENSIONE.Text); int CheckCount = 0; int FillCount = 0; foreach (string item in Num) { if (item != "") { FillCount = FillCount + 1; if (double.TryParse(item, out Range)) { //如果使用过张力范围39-55，使用过30-55 if (ifUsed) { if (Range > 30 && Range <= 55) { CheckCount = CheckCount + 1; } } else { if (Range > 30 && Range <= 55) { CheckCount = CheckCount + 1; } } } } } if (FillCount == 5) { if (CheckCount == 5) { Return.Enabled = true; Scrap.Enabled = false; } else { Return.Enabled = false; Scrap.Enabled = true; } } } Make_StencilScrapReason form; private void Scrap_Click(object sender, EventArgs e) { DataTable dt = (DataTable)dh.ExecuteSql("select st_usestatus,st_status from stencil where st_code='" + SU_DEVCODE1.Text + "' and st_statuscode='AUDITED'", "select"); if (dt.Rows.Count > 0) { if (dt.Rows[0]["st_usestatus"].ToString() == "报废") { MessageBox.Show( SU_DEVCODE1.Text + "已处于报废状态"); return; } if (dt.Rows[0]["st_usestatus"].ToString() != "在仓") { MessageBox.Show("报废必须" + SU_DEVCODE1.Text + "处于在仓状态"); return; } string closetab_confirm = MessageBox.Show(this.ParentForm, "报废后不可撤销，是否确认报废", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question).ToString(); if (closetab_confirm != "Yes") { return; } form = new Make_StencilScrapReason(); BaseUtil.SetFormCenter(form); form.Controls["ConfirmScrap"].Click += Make_SMTStencil_Click; form.ShowDialog(); } else { MessageBox.Show("编号" + SU_DEVCODE1.Text + "不存在或者未审核"); } } private void Make_SMTStencil_Click(object sender, EventArgs e) { string Code = ""; string scrapreason = form.Controls["Reason"].Text; if (scrapreason == "") { MessageBox.Show("报废原因不能为空"); return; } sql.Clear(); sql.Append("update StencilUse set SU_IFSCRAPOLD=-1,SU_STATUS='报废',SU_ENSIONA='" + ST_ENSIONA.Text + "',SU_ENSIONB='" + ST_ENSIONB.Text + "',SU_ENSIONC='" + ST_ENSIONC.Text + "',SU_ENSIOND='" + ST_ENSIOND.Text + "',SU_ENSIONE='" + ST_ENSIONE.Text + "'"); sql.Append(",SU_RETURNIFCLEAN='" + (SU_RETURNIFCLEAN.Checked ? "-1" : "0") + "' where su_id=(select max(su_id) from stenciluse where su_stcode='" + SU_DEVCODE1.Text + "')"); dh.ExecuteSql(sql.ToString(), "update"); sql.Clear(); sql.Append("update Stencil set ST_SCRAPREASON='" + scrapreason + "',ST_SCRAPMANCODE='" + User.UserCode + "',st_scrapman='" + User.UserName + "',st_scrapdate=sysdate,ST_USESTATUS='报废',ST_ENSIONA='" + ST_ENSIONA.Text + "',ST_ENSIONB='" + ST_ENSIONB.Text + "',"); sql.Append("ST_ENSIONC='" + ST_ENSIONC.Text + "',ST_ENSIOND='" + ST_ENSIOND.Text + "',ST_ENSIONE='" + ST_ENSIONE.Text + "' "); sql.Append("where st_code='" + SU_DEVCODE1.Text + "'"); dh.ExecuteSql(sql.ToString(), "insert"); ////推送人员信息 //string[] emid = dh.GetConfig("sendEmp", "Stencil").ToString().Replace("\n", "#").Split('#'); //for (int i = 0; i < emid.Length; i++) //{ // string em_name = dh.getFieldDataByCondition("employee", "em_name", "em_id='" + emid[i] + "'").ToString(); // // LogicHandler.SendMessage(emid[i], em_name, "钢网" + SU_DEVCODE1.Text + "已报废" + ",原因" + scrapreason + ",人员" + User.UserName); //} form.Close(); SU_DEVCODE1.Text = ""; ST_ENSIONA.Text = ""; ST_ENSIONB.Text = ""; ST_ENSIONC.Text = ""; ST_ENSIOND.Text = ""; ST_ENSIONE.Text = ""; SU_RETURNIFCLEAN.Checked = false; Scrap.Enabled = false; MessageBox.Show("报废成功！"); } private void ma_code_TextKeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.Enter) { Confirm.PerformClick(); } } } }