Make_ImeiCheck.cs 7.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178
  1. using System;
  2. using System.Collections.Generic;
  3. using System.ComponentModel;
  4. using System.Data;
  5. using System.Drawing;
  6. using System.Linq;
  7. using System.Text;
  8. using System.Windows.Forms;
  9. using UAS_MES_NEW.DataOperate;
  10. using UAS_MES_NEW.Entity;
  11. using UAS_MES_NEW.PublicForm;
  12. using UAS_MES_NEW.PublicMethod;
  13. namespace UAS_MES_NEW.Make
  14. {
  15. public partial class Make_ImeiCheck : Form
  16. {
  17. AutoSizeFormClass asc = new AutoSizeFormClass();
  18. DataHelper dh;
  19. LogStringBuilder sql;
  20. DataTable dt;
  21. DataTable info;
  22. string imei1 = "";
  23. bool isImei1 = false;
  24. string oErrorMessage = "";
  25. string SN = "";
  26. string omakeCode = "";
  27. string oMsid = "";
  28. public Make_ImeiCheck()
  29. {
  30. InitializeComponent();
  31. }
  32. private void Make_LabelCheck_Load(object sender, EventArgs e)
  33. {
  34. asc.controllInitializeSize(this);
  35. //聚焦SN号
  36. sncode.Focus();
  37. //打开界面提示用户:请输入SN
  38. OperateResult.AppendText(">>请输入SN\n", Color.Black);
  39. sql = new LogStringBuilder();
  40. dh = SystemInf.dh;
  41. StepCount.StepCode = User.CurrentStepCode;
  42. StepCount.Source = User.UserSourceCode;
  43. StepCount.LineCode = User.UserLineCode;
  44. StepCount.Dh = dh;
  45. StepCount.Start();
  46. }
  47. private void Make_LabelCheck_SizeChanged(object sender, EventArgs e)
  48. {
  49. asc.controlAutoSize(this);
  50. }
  51. private void sncode_KeyDown(object sender, KeyEventArgs e)
  52. {
  53. //判断是enter事件
  54. if (e.KeyCode == Keys.Enter)
  55. {
  56. if (sncode.Text == "")
  57. {
  58. OperateResult.AppendText("<<输入不能为空\n", Color.Red);
  59. return;
  60. }
  61. //说明输入的imei1对比一致
  62. //判断工序属性attribute
  63. if (LogicHandler.CheckStepAttribute(Tag.ToString(), User.UserSourceCode, out oErrorMessage))
  64. {
  65. //判断序列号下一工序(CHECKSTEPSNANDMACODE)
  66. if (LogicHandler.CheckStepSNAndMacode("", User.UserSourceCode, SN, User.UserCode, out omakeCode, out oMsid, out oErrorMessage))
  67. {
  68. if (!LogicHandler.CheckSeeWoSN(SN, out oErrorMessage))
  69. {
  70. OperateResult.AppendText(">>条码" + sncode.Text + "已激活\n");
  71. return;
  72. }
  73. //调用 SETSTEPRESULT ,获取返回的工单号,
  74. if (LogicHandler.SetStepResult(omakeCode, User.UserSourceCode, SN, "标签核对", "OK", User.UserCode, out oErrorMessage))
  75. {
  76. //提示正确返回时传递的信息
  77. if (oErrorMessage.Contains("AFTERSUCCESS"))
  78. OperateResult.AppendText(">>" + oErrorMessage + "\n");
  79. //根据工单号查询makecraftdetail 表中的 mcd_okqty 计数,剩余数为ma_qty - nvl(mcd_inqty,0),刷新页面中工单信息的显示
  80. sql.Clear();
  81. sql.Append("select ma_code,nvl(mcd_okqty,0) mcd_okqty,ma_prodcode,pr_detail,");
  82. sql.Append("ma_qty - nvl(mcd_okqty, 0) remain_qty from make left join makecraftdetail on ");
  83. sql.Append("mcd_maid=ma_id left join product on pr_code=ma_prodcode where ma_code='" + omakeCode + "' and mcd_stepcode='" + User.CurrentStepCode + "'");
  84. dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
  85. BaseUtil.SetFormValue(Controls, dt);
  86. //将SN,时间,结果记录在页面
  87. recordResult(SN, DateTime.Now.ToString(), "成功");
  88. //记录日志
  89. LogicHandler.DoCommandLog(Tag.ToString(), User.UserCode, ma_code.Text, User.UserLineCode, User.UserSourceCode, "标签核对", "标签核对成功", SN, "");
  90. //SN核对成功
  91. //>> 请输入SN
  92. OperateResult.AppendText("<<SN核对成功\n", Color.Green, sncode);
  93. OperateResult.AppendText(">>请输入SN\n", Color.Black);
  94. SetCheck set = new SetCheck("OK", Color.Green);
  95. BaseUtil.SetFormCenter(set);
  96. set.ShowDialog();
  97. }
  98. else
  99. {
  100. //setstepresult不通过
  101. OperateResult.AppendText(">>" + oErrorMessage + "\n", Color.Red, sncode);
  102. recordResult(SN, DateTime.Now.ToString(), "失败");
  103. SetCheck set = new SetCheck("NG", Color.Red);
  104. BaseUtil.SetFormCenter(set);
  105. set.ShowDialog();
  106. }
  107. }
  108. else
  109. {
  110. //判定序列号下一工序不通过
  111. OperateResult.AppendText(">>" + oErrorMessage + "\n", Color.Red, sncode);
  112. recordResult(SN, DateTime.Now.ToString(), "失败");
  113. SetCheck set = new SetCheck("NG", Color.Red);
  114. BaseUtil.SetFormCenter(set);
  115. set.ShowDialog();
  116. }
  117. }
  118. else
  119. {
  120. //判定工序属性不通过
  121. OperateResult.AppendText(">>" + oErrorMessage + "\n", Color.Red, sncode);
  122. recordResult(SN, DateTime.Now.ToString(), "失败");
  123. }
  124. }
  125. //说明比对不一致
  126. else
  127. {
  128. //清空imei1变量的值
  129. imei1 = "";
  130. //SN核对失败
  131. //>> 请输入SN
  132. OperateResult.AppendText(">>SN核对失败,不一致\n", Color.Red, sncode);
  133. OperateResult.AppendText(">>请输入SN\n", Color.Black);
  134. }
  135. //imei1校对结束,下次输入的是SN
  136. isImei1 = false;
  137. }
  138. private void recordResult(string SN, string time, string result)
  139. {
  140. //if (showResult.Items.Count >= 10)
  141. //{
  142. // //如果有10行的话,则删除最前一行
  143. // showResult.Items.RemoveAt(0);
  144. //}
  145. //创建一个item
  146. ListViewItem lvi = new ListViewItem();
  147. //分条赋值
  148. lvi.SubItems.Add(SN);
  149. lvi.SubItems.Add(time);
  150. lvi.SubItems.Add(result);
  151. //添加结果的信息进去
  152. showResult.Items.Add(lvi);
  153. }
  154. private void clear()
  155. {
  156. //清空变量的值
  157. omakeCode = "";
  158. oMsid = "";
  159. SN = "";
  160. imei1 = "";
  161. }
  162. }
  163. }