Make_GetTestFileData.cs 8.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177
  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_GetTestFileData : Form
  16. {
  17. AutoSizeFormClass asc = new AutoSizeFormClass();
  18. DataHelper dh;
  19. LogStringBuilder sql;
  20. string oErrorMessage = "";
  21. string omakeCode = "";
  22. string oMsid = "";
  23. public Make_GetTestFileData()
  24. {
  25. InitializeComponent();
  26. }
  27. private void Make_LabelCheck_Load(object sender, EventArgs e)
  28. {
  29. asc.controllInitializeSize(this);
  30. //聚焦SN号
  31. sncode.Focus();
  32. //打开界面提示用户:请输入SN
  33. OperateResult.AppendText(">>请输入SN\n", Color.Black);
  34. sql = new LogStringBuilder();
  35. dh = SystemInf.dh;
  36. StepCount.StepCode = User.CurrentStepCode;
  37. StepCount.Source = User.UserSourceCode;
  38. StepCount.LineCode = User.UserLineCode;
  39. StepCount.Dh = dh;
  40. StepCount.Start();
  41. }
  42. private void Make_LabelCheck_SizeChanged(object sender, EventArgs e)
  43. {
  44. asc.controlAutoSize(this);
  45. }
  46. private void sncode_KeyDown(object sender, KeyEventArgs e)
  47. {
  48. //判断是enter事件
  49. if (e.KeyCode == Keys.Enter)
  50. {
  51. if (sncode.Text == "")
  52. {
  53. OperateResult.AppendText("<<输入不能为空\n", Color.Red);
  54. return;
  55. }
  56. if (LogicHandler.CheckStepAttribute(Tag.ToString(), User.UserSourceCode, out oErrorMessage))
  57. {
  58. if (LogicHandler.CheckStepSNAndMacode("", User.UserSourceCode, sncode.Text, User.UserCode, out omakeCode, out oMsid, out oErrorMessage))
  59. {
  60. DataTable dt = new DataTable();
  61. BaseUtil.OpenCSVFile(ref dt, @"C:\Users\callm\Desktop\品网\2019_04_04_19_59_18_788.csv");
  62. //移除标题行
  63. dt.Rows.RemoveAt(0);
  64. //设置列名绑定数据
  65. dt.Columns[0].ColumnName = "std_class";
  66. dt.Columns[1].ColumnName = "std_testtimes";
  67. dt.Columns[2].ColumnName = "std_testresult";
  68. dt.Columns[3].ColumnName = "std_badcode";
  69. CheckItemDGV.DataSource = dt;
  70. bool Result = true;
  71. for (int i = 0; i < dt.Rows.Count; i++)
  72. {
  73. if (dt.Rows[i]["std_testresult"].ToString() != "OK")
  74. {
  75. Result = false;
  76. }
  77. dh.ExecuteSql("insert into STEPTESTDETAIL(std_id,std_sn,std_indate,std_class,std_testtimes,std_testresult,std_badcode) values(STEPTESTDETAIL_seq.nextval,'" + sncode.Text + "',sysdate,'" + dt.Rows[i]["std_class"].ToString() + "','" + dt.Rows[i]["std_testtimes"].ToString() + "','" + dt.Rows[i]["std_testresult"].ToString() + "','" + dt.Rows[i]["std_badcode"].ToString() + "')", "insert");
  78. }
  79. if (Result)
  80. {
  81. if (LogicHandler.SetStepResult(omakeCode, User.UserSourceCode, sncode.Text, "", "OK", User.UserCode, out oErrorMessage))
  82. {
  83. //提示正确返回时传递的信息
  84. if (oErrorMessage.Contains("AFTERSUCCESS"))
  85. OperateResult.AppendText(">>" + oErrorMessage + "\n");
  86. //根据工单号查询makecraftdetail 表中的 mcd_okqty 计数,剩余数为ma_qty - nvl(mcd_inqty,0),刷新页面中工单信息的显示
  87. sql.Clear();
  88. sql.Append("select ma_code,nvl(mcd_okqty,0) mcd_okqty,ma_prodcode,pr_detail,");
  89. sql.Append("ma_qty - nvl(mcd_okqty, 0) remain_qty from make left join makecraftdetail on ");
  90. sql.Append("mcd_maid=ma_id left join product on pr_code=ma_prodcode where ma_code='" + omakeCode + "' and mcd_stepcode='" + User.CurrentStepCode + "'");
  91. dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
  92. BaseUtil.SetFormValue(Controls, dt);
  93. //将SN,时间,结果记录在页面
  94. //记录日志
  95. LogicHandler.DoCommandLog(Tag.ToString(), User.UserCode, ma_code.Text, User.UserLineCode, User.UserSourceCode, "标签核对", "参数核对成功", sncode.Text, "");
  96. //SN核对成功
  97. //>> 请输入SN
  98. OperateResult.AppendText("<<" + sncode.Text + "信息核对成功\n", Color.Green, sncode);
  99. OperateResult.AppendText(">>请输入SN\n", Color.Black);
  100. SetCheck set = new SetCheck("OK", Color.Green);
  101. BaseUtil.SetFormCenter(set);
  102. set.ShowDialog();
  103. if (ReSet.Checked)
  104. {
  105. BaseUtil.GetDataFromDevice("RESET");
  106. }
  107. }
  108. else
  109. {
  110. OperateResult.AppendText(">>" + oErrorMessage + "\n", Color.Red, sncode);
  111. }
  112. }
  113. else
  114. {
  115. OperateResult.AppendText(">>序列号" + sncode.Text + "测试不通过\n", Color.Red, sncode);
  116. }
  117. }
  118. else
  119. {
  120. OperateResult.AppendText(">>" + oErrorMessage + "\n", Color.Red, sncode);
  121. }
  122. }
  123. else
  124. {
  125. OperateResult.AppendText(">>" + oErrorMessage + "\n", Color.Red, sncode);
  126. }
  127. }
  128. }
  129. private void StepCount_Load(object sender, EventArgs e)
  130. {
  131. }
  132. private void CheckItemDGV_CellPainting(object sender, DataGridViewCellPaintingEventArgs e)
  133. {
  134. //系统值和
  135. if (e.ColumnIndex >= 0)
  136. {
  137. if (CheckItemDGV.Columns[e.ColumnIndex].Name == "std_testresult")
  138. {
  139. if (e.RowIndex >= 0)
  140. {
  141. if (CheckItemDGV.Rows[e.RowIndex].Cells["std_testresult"].Value != null && (CheckItemDGV.Rows[e.RowIndex].Cells["std_testresult"].Value.ToString() == "OK"))
  142. {
  143. e.Graphics.FillRectangle(Brushes.ForestGreen, e.CellBounds);
  144. Rectangle border = e.CellBounds;
  145. border.Width -= 1;
  146. e.Graphics.DrawRectangle(Pens.Black, border);
  147. e.PaintContent(e.CellBounds);
  148. e.Handled = true;
  149. }
  150. else
  151. {
  152. e.Graphics.FillRectangle(Brushes.OrangeRed, e.CellBounds);
  153. Rectangle border = e.CellBounds;
  154. border.Width -= 1;
  155. e.Graphics.DrawRectangle(Pens.Black, border);
  156. e.PaintContent(e.CellBounds);
  157. e.Handled = true;
  158. }
  159. }
  160. }
  161. }
  162. }
  163. }
  164. }