123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223 |
- 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_ImeiCheck : Form
- {
- AutoSizeFormClass asc = new AutoSizeFormClass();
- DataHelper dh;
- LogStringBuilder sql;
- DataTable dt;
- DataTable info;
- string imei1 = "";
- bool isImei1 = false;
- string oErrorMessage = "";
- string SN = "";
- string omakeCode = "";
- string oMsid = "";
- public Make_ImeiCheck()
- {
- InitializeComponent();
- }
- private void Make_LabelCheck_Load(object sender, EventArgs e)
- {
- asc.controllInitializeSize(this);
-
- sncode.Focus();
-
- OperateResult.AppendText(">>请输入SN\n", Color.Black);
- sql = new LogStringBuilder();
- dh = SystemInf.dh;
- StepCount.StepCode = User.CurrentStepCode;
- StepCount.Source = User.UserSourceCode;
- StepCount.LineCode = User.UserLineCode;
- StepCount.Dh = dh;
- StepCount.Start();
- }
- private void Make_LabelCheck_SizeChanged(object sender, EventArgs e)
- {
- asc.controlAutoSize(this);
- }
- private void sncode_KeyDown(object sender, KeyEventArgs e)
- {
-
- if (e.KeyCode == Keys.Enter)
- {
- if (sncode.Text == "")
- {
- OperateResult.AppendText("<<输入不能为空\n", Color.Red);
- return;
- }
-
- if (!isImei1)
- {
- OperateResult.AppendText("<<" + sncode.Text + "\n", Color.Black);
-
- sql.Clear();
- sql.Append("select max(ms_id) ms_id from makeserial where ms_sncode ='"+sncode.Text+"'");
- dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
- if (dt.Rows.Count == 0 || dt.Rows[0]["ms_id"].ToString() == "")
- {
-
-
- OperateResult.AppendText("<<SN错误,序列号" + sncode.Text + "不存在\n", Color.Red, sncode);
- OperateResult.AppendText(">>请输入SN\n", Color.Black);
- }
-
- else
- {
-
- sql.Clear();
- sql.Append("select ms_imei1 from makeserial where ms_id='" + dt.Rows[0]["ms_id"].ToString() + "'");
- info = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
- if (info.Rows.Count > 0)
- {
-
- if (info.Rows[0]["ms_imei1"].ToString() == null || info.Rows[0]["ms_imei1"].ToString() == "")
- {
-
-
- OperateResult.AppendText("<<序列号" + sncode.Text + "对应的IMEI不存在\n", Color.Red, sncode);
- OperateResult.AppendText(">>请输入SN\n", Color.Black);
- }
- else
-
- {
-
- imei1 = info.Rows[0]["ms_imei1"].ToString();
- SN = sncode.Text;
-
-
- OperateResult.AppendText("<<序列号" + sncode.Text + "对应的IMEI号为:" + imei1 + "\n", Color.Green);
- OperateResult.AppendText(">>请输入彩盒上的IMEI\n", Color.Black, sncode);
-
- isImei1 = true;
- }
- }
- else
- {
- OperateResult.AppendText("<<SN:" + sncode.Text + "对应的IMEI不存在\n", Color.Red, sncode);
- OperateResult.AppendText(">>请输入SN\n", Color.Black);
- }
- }
- }
-
- else
- {
- OperateResult.AppendText("<<" + sncode.Text + "\n", Color.Black);
- if (imei1 == sncode.Text)
- {
-
-
- if (LogicHandler.CheckStepAttribute(Tag.ToString(), User.UserSourceCode, out oErrorMessage))
- {
-
- if (LogicHandler.CheckStepSNAndMacode("", User.UserSourceCode, SN, User.UserCode, out omakeCode, out oMsid, out oErrorMessage))
- {
-
- if (LogicHandler.SetStepResult(omakeCode, User.UserSourceCode, SN, "标签核对", "OK", User.UserCode, out oErrorMessage))
- {
-
- if (oErrorMessage.Contains("AFTERSUCCESS"))
- OperateResult.AppendText(">>" + oErrorMessage + "\n");
-
- sql.Clear();
- sql.Append("select ma_code,nvl(mcd_okqty,0) mcd_okqty,ma_prodcode,pr_detail,");
- sql.Append("ma_qty - nvl(mcd_okqty, 0) remain_qty from make left join makecraftdetail on ");
- sql.Append("mcd_maid=ma_id left join product on pr_code=ma_prodcode where ma_code='" + omakeCode + "' and mcd_stepcode='" + User.CurrentStepCode + "'");
- dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
- BaseUtil.SetFormValue(Controls, dt);
-
- recordResult(SN, DateTime.Now.ToString(), "成功");
-
- LogicHandler.DoCommandLog(Tag.ToString(), User.UserCode, ma_code.Text, User.UserLineCode, User.UserSourceCode, "标签核对", "标签核对成功", SN, "");
-
-
- OperateResult.AppendText("<<IMEI核对成功\n", Color.Green, sncode);
- OperateResult.AppendText(">>请输入SN\n", Color.Black);
- }
- else
- {
-
- OperateResult.AppendText(">>" + oErrorMessage + "\n", Color.Red, sncode);
- recordResult(SN, DateTime.Now.ToString(), "失败");
- }
- }
- else
- {
-
- OperateResult.AppendText(">>" + oErrorMessage + "\n", Color.Red, sncode);
- recordResult(SN, DateTime.Now.ToString(), "失败");
- }
- }
- else
- {
-
- OperateResult.AppendText(">>" + oErrorMessage + "\n", Color.Red, sncode);
- recordResult(SN, DateTime.Now.ToString(), "失败");
- }
- }
-
- else
- {
-
- imei1 = "";
-
-
- OperateResult.AppendText(">>IMEI核对失败,不一致\n", Color.Red, sncode);
- OperateResult.AppendText(">>请输入SN\n", Color.Black);
- }
-
- isImei1 = false;
- }
- }
- }
- private void recordResult(string SN, string time, string result)
- {
-
-
-
-
-
-
- ListViewItem lvi = new ListViewItem();
-
- lvi.SubItems.Add(SN);
- lvi.SubItems.Add(time);
- lvi.SubItems.Add(result);
-
- showResult.Items.Add(lvi);
- }
- private void clear()
- {
-
- omakeCode = "";
- oMsid = "";
- SN = "";
- imei1 = "";
- }
- }
- }
|