using System; using System.Data; using System.Drawing; using System.Windows.Forms; using UAS_MES_NEW.DataOperate; using UAS_MES_NEW.Entity; using UAS_MES_NEW.PublicMethod; namespace UAS_MES_NEW.Make { public partial class Make_MakeDown : Form { AutoSizeFormClass asc = new AutoSizeFormClass(); DataTable dt; DataTable dt1; DataTable dtbar; LogStringBuilder sql = new LogStringBuilder(); DataHelper dh; //页面Caller string caller; //事件号变量 string _macode; //数量记录 int count; //记录当前序列号ms_id string ms_id; DataTable Dbfind; public Make_MakeDown() { InitializeComponent(); caller = "MakeDown"; count = 0; _macode = ""; } private void Make_MakeDown_Load(object sender, EventArgs e) { asc.controllInitializeSize(this); dh = SystemInf.dh; sn_code.Focus(); make_count.Text = count.ToString(); string[] param = new string[] { caller, make_count.Text, _macode }; dh.CallProcedure("SP_GETMAXNUMBER", ref param); mdcode.Text = param[2]; cr_code.FormName = Name; cr_code.TableName = "craft"; cr_code.SelectField = "cr_name # 工艺名称,cr_code # 工艺编号,cr_prodcode # 物料编号"; cr_code.SetValueField = new string[] { "cr_code" }; cr_code.DBTitle = "工艺"; cr_code.DbChange += Cr_code_DbChange; cd_stepcode.FormName = Name; cd_stepcode.TableName = "craftdetail left join step on st_code=cd_stepcode left join craft on cd_crid=cr_id"; cd_stepcode.SetValueField = new string[] { "cd_stepcode" }; cd_stepcode.SelectField = "cd_stepname # 工序名称 ,cd_stepcode # 工序编号,cd_stepno # 执行顺序"; cd_stepcode.DBTitle = "拦截工序"; cd_stepcode.DbChange += Cd_stepcode_DbChange; } private void Cr_code_DbChange(object sender, EventArgs e) { Dbfind = cr_code.ReturnData; BaseUtil.SetFormValue(this.Controls, Dbfind); } private void Cd_stepcode_DbChange(object sender, EventArgs e) { Dbfind = cd_stepcode.ReturnData; BaseUtil.SetFormValue(this.Controls, Dbfind); } private void Make_MakeDown_SizeChanged(object sender, EventArgs e) { asc.controlAutoSize(this); } private void sn_code_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.Enter) { if (inputreson.Text.Trim() != "") { sql.Clear(); sql.Append("select max(ms_id) from makeserial where ms_sncode='" + sn_code.Text + "' or ms_imei1='" + sn_code.Text + "' or ms_imei2='" + sn_code.Text + "' or ms_imei3='" + md_sncode.HeaderText + "'"); dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select"); ms_id = dt.Rows[0][0].ToString(); if (ms_id != "") { //界面赋值 dtbar = (DataTable)dh.ExecuteSql("select ms_makecode,ms_sncode,pr_code,pr_detail from makeserial left join product on MS_PRODCODE=pr_code where ms_id='" + ms_id + "'", "select"); sn_code.Text = dtbar.Rows[0]["ms_sncode"].ToString(); BaseUtil.SetFormValue(this.Controls, dtbar); sql.Clear(); sql.Append("select ms_outboxcode,ms_craftcode, ms_downstatus,ms_outno,nvl(ms_iostatus,0) ms_iostatus,ms_prodcode from makeserial where ms_id ='" + ms_id + "' "); dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select"); string ms_downstatus = dt.Rows[0]["ms_downstatus"].ToString(); string ms_outboxcode = dt.Rows[0]["ms_outboxcode"].ToString(); string ms_prodcode = dt.Rows[0]["ms_prodcode"].ToString(); string ms_iostatus = dt.Rows[0]["ms_iostatus"].ToString(); string ms_outno = dt.Rows[0]["ms_outno"].ToString(); cr_code.Text = dt.Rows[0]["ms_craftcode"].ToString(); ; cd_stepcode.Condition = "ST_STATUSCODE='AUDITED' and cr_code='" + cr_code.Text + "' and cr_prodcode='" + ms_prodcode + "' order by cd_stepno"; if (ms_downstatus == "0") { if (ms_outno == "" && ms_iostatus == "0") { if (ms_outboxcode == null || ms_outboxcode == "") { //进行下地操作，插入下地记录 sql.Clear(); sql.Append("INSERT INTO MAKEDOWN (MD_ID,MD_LINECODE,MD_SCCODE,MD_STEPCODE,"); sql.Append("MD_SNCODE,MD_PRODCODE,MD_MACODE, MD_DOWNREASON, MD_CODE,"); sql.Append("MD_DOWNDATE,MD_DOWNMAN,MD_STATUS) values (MAKEDOWN_seq.nextval,'" + User.UserLineCode + "','" + User.UserSourceCode + "',"); sql.Append("'" + User.CurrentStepCode + "','" + sn_code.Text + "','" + pr_code.Text + "','" + ms_makecode.Text + "','" + inputreson.Text + "','" + mdcode.Text + "',sysdate,'" + User.UserCode + "','-1')"); //执行 dh.ExecuteSql(sql.GetString(), "insert"); //更新序列号状态为下地 dh.UpdateByCondition("makeserial", "ms_downstatus='-1'", "ms_id='" + ms_id + "'"); OperateResult.AppendText(">>>序列号" + sn_code.Text + "下地成功\n", Color.Green); cd_stepcode.Enabled = true; //更新数量 LogicHandler.DoCommandLog(Tag.ToString(), User.UserCode, ms_makecode.Text, User.UserLineCode, User.UserSourceCode, "下地操作", "序列号" + sn_code.Text + "下地成功", sn_code.Text, ""); count++; make_count.Text = count + ""; sn_code.Text = ""; loadGrid(); } else { OperateResult.AppendText(">>>序列号" + sn_code.Text + "已装箱:" + ms_outboxcode + ",不允许下地，如需下地请先解除装箱\n", Color.Red, sn_code); sn_code.Focus(); return; } } else { OperateResult.AppendText(">>>序列号" + sn_code.Text + "已进行出入库操作，不允许下地\n", Color.Red, sn_code); sn_code.Focus(); return; } } else { OperateResult.AppendText(">>>序列号" + sn_code.Text + "目前已经是下地状态，无需重复下地\n", Color.Red, sn_code); sn_code.Focus(); return; } } else { ms_id = null; OperateResult.AppendText(">>>序列号" + sn_code.Text + "不存在\n", Color.Red, sn_code); sn_code.Focus(); } } else { OperateResult.AppendText(">>>序列号" + sn_code.Text + "未输入下地原因\n", Color.Red, sn_code); sn_code.Focus(); return; } } } private void loadGrid() { sql.Clear(); sql.Append("select md_macode,md_sncode,md_prodcode,pr_detail from makedown left join product on pr_code = md_prodcode where md_code = '" + mdcode.Text + "'"); dt1 = (DataTable)dh.ExecuteSql(sql.GetString(), "select"); BaseUtil.FillDgvWithDataTable(LabelDataGridView, dt1); } private void cr_code_UserControlTextChanged(object sender, EventArgs e) { } private void cd_stepcode_UserControlTextChanged(object sender, EventArgs e) { dh.ExecuteSql("update makedown set md_stopstepcode='" + cd_stepcode.Text + "' where MD_CODE='" + mdcode.Text + "'", "update"); OperateResult.AppendText(">>>设置拦截工序成功\n", Color.Green); } } }