Make_CollectElec.cs 6.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163
  1. using System;
  2. using System.Data;
  3. using System.Drawing;
  4. using System.Windows.Forms;
  5. using UAS_MES_NEW.DataOperate;
  6. using UAS_MES_NEW.Entity;
  7. using UAS_MES_NEW.PublicMethod;
  8. namespace UAS_MES_NEW.Make
  9. {
  10. public partial class Make_CollectElec : Form
  11. {
  12. DataHelper dh;
  13. AutoSizeFormClass asc = new AutoSizeFormClass();
  14. LogStringBuilder sql = new LogStringBuilder();
  15. DataTable dt;
  16. //当前序列号记录
  17. string sn_code;
  18. //制造单号
  19. string macode;
  20. //采集网标号
  21. float net_code;
  22. //网标查询条件ms_id
  23. string oMsID;
  24. //判断是否输入网标
  25. Boolean isnetcode = false;
  26. //打印计数
  27. int printcount = 0;
  28. int ma_unlimitin;
  29. public Make_CollectElec()
  30. {
  31. InitializeComponent();
  32. }
  33. private void Make_CollectNetCode_Load(object sender, EventArgs e)
  34. {
  35. asc.controllInitializeSize(this);
  36. sncode.Focus();
  37. dh = SystemInf.dh;
  38. StepCount.StepCode = User.CurrentStepCode;
  39. StepCount.Source = User.UserSourceCode;
  40. StepCount.LineCode = User.UserLineCode;
  41. StepCount.Dh = dh;
  42. StepCount.Start();
  43. }
  44. private void sncode_KeyDown(object sender, KeyEventArgs e)
  45. {
  46. if (e.KeyCode == Keys.Enter)
  47. {
  48. string ErrorMessage2;
  49. string oMakeCode;
  50. //采集序列号
  51. if (!isnetcode)
  52. {
  53. if (sncode.Text == "")
  54. {
  55. OperateResult.AppendText(">>序列号不能为空\n", Color.Red);
  56. return;
  57. }
  58. if (LogicHandler.CheckStepAttribute(Tag.ToString(), User.UserSourceCode, out ErrorMessage2))
  59. {
  60. //判断界面工单是否为空时的序列号是否自动归属工单
  61. string oStatus = "";
  62. if (!LogicHandler.GetMakeInfo(sncode.Text, out oMakeCode, out oStatus, out ErrorMessage2))
  63. {
  64. if (ms_makecode.Text == "")
  65. {
  66. OperateResult.AppendText(">>" + ErrorMessage2 + "\n", Color.Red, sncode);
  67. return;
  68. }
  69. }
  70. OperateResult.AppendText("<<" + sncode.Text + "\n", Color.Black);
  71. // 获取工单归属工单下一工序是否正确
  72. if (LogicHandler.CheckStepSNAndMacode(ms_makecode.Text == "" ? oMakeCode : ms_makecode.Text, User.UserSourceCode, sncode.Text, User.UserCode, out oMakeCode, out oMsID, out ErrorMessage2))
  73. {
  74. sql.Clear();
  75. sql.Append("select ms_makecode,ms_prodcode,pr_detail,nvl(pr_electricmax,0)pr_electricmax,nvl(pr_electricmin,0)pr_electricmin,ms_colorcode from makeserial left join product on ");
  76. sql.Append(" ms_prodcode = pr_code where ms_id = '" + oMsID + "'");
  77. dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
  78. BaseUtil.SetFormValue(this.Controls, dt);
  79. OperateResult.AppendText(">>请输入COLOR\n", Color.Black);
  80. sn_code = sncode.Text;
  81. sncode.Text = "";
  82. isnetcode = true;
  83. return;
  84. }
  85. else OperateResult.AppendText(">>" + ErrorMessage2 + "\n", Color.Red, sncode);
  86. }
  87. else OperateResult.AppendText(">>" + ErrorMessage2 + "\n", Color.Red, sncode);
  88. }
  89. //采集netcode
  90. else
  91. {
  92. if (sncode.Text == "")
  93. {
  94. OperateResult.AppendText(">>COLOR信息不能为空\n", Color.Red);
  95. return;
  96. }
  97. if (ms_colorcode.Text != "" && ms_colorcode.Text != sncode.Text)
  98. {
  99. OperateResult.AppendText(">>COLOR" + sncode.Text + "与工单设定COLOR" + ms_colorcode.Text + "不一致\n", Color.Red);
  100. return;
  101. }
  102. OperateResult.AppendText("<<" + sncode.Text + "\n", Color.Black);
  103. string ErrorMessage = "";
  104. if (LogicHandler.SetStepResult(ms_makecode.Text, User.UserSourceCode, sn_code, "COLOR采集", "COLOR采集完成", User.UserCode, out ErrorMessage))
  105. {
  106. //提示正确返回时传递的信息
  107. if (ErrorMessage.Contains("AFTERSUCCESS"))
  108. OperateResult.AppendText(">>" + ErrorMessage + "\n");
  109. dh.BatchInsert("update makeserial set MS_COLORCODE = :netcode where ms_id = :oMsId", new String[] { "netcode", "oMsId" }, new string[] { sncode.Text }, new string[] { oMsID.ToString() });
  110. OperateResult.AppendText(">>COLOR信息采集完成\n", Color.Green);
  111. LogicHandler.DoCommandLog(Tag.ToString(), User.UserCode, ms_makecode.Text, User.UserLineCode, User.UserSourceCode, "COLOR采集", "采集成功", sn_code, "");
  112. isnetcode = false;
  113. sncode.Text = "";
  114. sncode.Focus();
  115. }
  116. else
  117. {
  118. OperateResult.AppendText(">>更新错误" + ErrorMessage + "\n", Color.Red);
  119. }
  120. OperateResult.AppendText(">>请输入SN\n", Color.Black);
  121. }
  122. }
  123. }
  124. private void Make_CollectNetCode_SizeChanged(object sender, EventArgs e)
  125. {
  126. asc.controlAutoSize(this);
  127. }
  128. private void Make_CollectNetCode_Activated(object sender, EventArgs e)
  129. {
  130. sncode.Focus();
  131. }
  132. private void deleteButton1_Click(object sender, EventArgs e)
  133. {
  134. if (isnetcode)
  135. {
  136. BaseUtil.CleanForm(this);
  137. OperateResult.AppendText(">>清除完成,清重新输入SN号\n", Color.Green);
  138. isnetcode = false;
  139. sncode.Focus();
  140. }
  141. }
  142. private void enterTextBox1_Leave(object sender, EventArgs e)
  143. {
  144. enterTextBox1.ReadOnly = true;
  145. }
  146. private void enterTextBox1_MouseDoubleClick(object sender, MouseEventArgs e)
  147. {
  148. enterTextBox1.ReadOnly = false;
  149. }
  150. }
  151. }