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.DataOperate; using UAS_MES_NEW.Entity; using UAS_MES_NEW.PublicMethod; namespace UAS_MES_NEW.Make { public partial class Make_CollectSoft : Form { DataHelper dh; AutoSizeFormClass asc = new AutoSizeFormClass(); LogStringBuilder sql = new LogStringBuilder(); DataTable dt; //当前序列号记录 string sn_code; //制造单号 string macode; //软件版本查询条件ms_id string oMsID; //判断是否输入软件版本 Boolean isnetcode = false; //打印计数 int printcount = 0; int ma_unlimitin; public Make_CollectSoft() { InitializeComponent(); } private void Make_CollectNetCode_Load(object sender, EventArgs e) { asc.controllInitializeSize(this); sncode.Focus(); dh = SystemInf.dh; StepCount.StepCode = User.CurrentStepCode; StepCount.Source = User.UserSourceCode; StepCount.LineCode = User.UserLineCode; StepCount.Dh = dh; StepCount.Start(); } private void sncode_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.Enter) { string ErrorMessage2; string oMakeCode; //采集序列号 if (!isnetcode) { if (sncode.Text == "") { OperateResult.AppendText(">>序列号不能为空\n", Color.Red); return; } if (LogicHandler.CheckStepAttribute(Tag.ToString(), User.UserSourceCode, out ErrorMessage2)) { //判断界面工单是否为空时的序列号是否自动归属工单 string oStatus = ""; if (!LogicHandler.GetMakeInfo(sncode.Text, out oMakeCode, out oStatus, out ErrorMessage2)) { if (ms_makecode.Text == "") { OperateResult.AppendText(">>" + ErrorMessage2 + "\n", Color.Red, sncode); return; } } OperateResult.AppendText("<<" + sncode.Text + "\n", Color.Black); // 获取工单归属工单下一工序是否正确 if (LogicHandler.CheckStepSNAndMacode(ms_makecode.Text == "" ? oMakeCode : ms_makecode.Text, User.UserSourceCode, sncode.Text, User.UserCode, out oMakeCode, out oMsID, out ErrorMessage2)) { sql.Clear(); sql.Append("select ma_code as ms_makecode,ma_prodcode,pr_detail,"); sql.Append("pr_spec,ma_softversion from make "); sql.Append(" left join product on pr_code=ma_prodcode where ma_code='" + oMakeCode + "' "); dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select"); if (dt.Rows.Count > 0) { BaseUtil.SetFormValue(this.Controls, dt); //dh.UpdateByCondition("makeserial", "ms_currentstepcode = '" + User.CurrentStepCode + "'", "ms_id = '" + oMsID + "'"); OperateResult.AppendText(">>请输入软件版本\n", Color.Black); sn_code = sncode.Text; sncode.Text = ""; isnetcode = true; return; } } else OperateResult.AppendText(">>" + ErrorMessage2 + "\n", Color.Red, sncode); } else OperateResult.AppendText(">>" + ErrorMessage2 + "\n", Color.Red, sncode); } //采集netcode else { if (sncode.Text == "") { OperateResult.AppendText(">>软件版本号不能为空\n", Color.Red); return; } OperateResult.AppendText("<<" + sncode.Text + "\n", Color.Black); string ErrorMessage = ""; string result = ""; ////软件版本号校验 if (ma_softversion.Text != sncode.Text) { OperateResult.AppendText(">>录入错误,此软件版本:" + sncode.Text + "与工单维护软件版本"+ ma_softversion.Text + "不一致\n", Color.Red, sncode); OperateResult.AppendText(">>请输入软件版本\n", Color.Black); return; } else { if (LogicHandler.SetStepResult(ms_makecode.Text, User.UserSourceCode, sn_code, "软件版本采集", "软件版本采集完成", User.UserCode, out ErrorMessage)) { //提示正确返回时传递的信息 if (ErrorMessage.Contains("AFTERSUCCESS")) OperateResult.AppendText(">>" + ErrorMessage + "\n"); dh.BatchInsert("update makeserial set ms_softversion = :netcode where ms_id = :oMsId", new String[] { "netcode", "oMsId" }, new string[] { sncode.Text }, new string[] { oMsID.ToString() }); OperateResult.AppendText(">>软件版本采集完成,执行更新\n", Color.Green); LogicHandler.DoCommandLog(Tag.ToString(), User.UserCode, ms_makecode.Text, User.UserLineCode, User.UserSourceCode, "软件版本采集"+ sncode.Text, "采集成功", sn_code, ""); isnetcode = false; sncode.Text = ""; sncode.Focus(); } else { OperateResult.AppendText(">>更新错误" + ErrorMessage + "\n", Color.Red); } OperateResult.AppendText(">>请输入SN\n", Color.Black); } } } } private void Make_CollectNetCode_SizeChanged(object sender, EventArgs e) { asc.controlAutoSize(this); } private void Make_CollectNetCode_Activated(object sender, EventArgs e) { sncode.Focus(); } private void deleteButton1_Click(object sender, EventArgs e) { if (isnetcode) { BaseUtil.CleanForm(this); OperateResult.AppendText(">>清除完成,清重新输入SN号\n", Color.Green); isnetcode = false; sncode.Focus(); } } } }