Make_OutBoxSnCheckDN.cs 4.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132
  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.PublicForm;
  8. using UAS_MES_NEW.PublicMethod;
  9. namespace UAS_MES_NEW.Make
  10. {
  11. public partial class Make_OutBoxSnCheckDN : Form
  12. {
  13. AutoSizeFormClass asc = new AutoSizeFormClass();
  14. DataHelper dh;
  15. LogStringBuilder sql;
  16. DataTable dt;
  17. public Make_OutBoxSnCheckDN()
  18. {
  19. InitializeComponent();
  20. }
  21. private void Make_LabelCheck_Load(object sender, EventArgs e)
  22. {
  23. asc.controllInitializeSize(this);
  24. //聚焦SN号
  25. pa_outboxcode.Focus();
  26. //打开界面提示用户:请输入SN
  27. OperateResult.AppendText(">>请采集箱号\n", Color.Black);
  28. sql = new LogStringBuilder();
  29. dh = SystemInf.dh;
  30. }
  31. private void Make_LabelCheck_SizeChanged(object sender, EventArgs e)
  32. {
  33. asc.controlAutoSize(this);
  34. }
  35. bool FindFugeSN = false;
  36. int RowIndex = 0;
  37. private void sncode_KeyDown(object sender, KeyEventArgs e)
  38. {
  39. //判断是enter事件
  40. if (e.KeyCode == Keys.Enter)
  41. {
  42. if (sncode.Text == "")
  43. {
  44. OperateResult.AppendText("<<输入不能为空\n", Color.Red);
  45. return;
  46. }
  47. bool AllCheck = true;
  48. for (int i = 0; i < CheckSnDGV.Rows.Count; i++)
  49. {
  50. if (CheckSnDGV.Rows[i].Cells["WOD_PALLENTORBOX"].Value.ToString() == sncode.Text)
  51. {
  52. CheckSnDGV.Rows[i].Cells["pd_checksn1"].Value = sncode.Text;
  53. FindFugeSN = true;
  54. }
  55. }
  56. if (FindFugeSN)
  57. {
  58. FindFugeSN = false;
  59. OperateResult.AppendText("<<" + sncode.Text + "箱号校验成功\n", Color.Green, sncode);
  60. }
  61. else
  62. {
  63. OperateResult.AppendText("<<" + sncode.Text + "箱号不存在\n", Color.Red, sncode);
  64. return;
  65. }
  66. if (AllCheck)
  67. {
  68. SetCheck set = new SetCheck("OK", Color.Green);
  69. BaseUtil.SetFormCenter(set);
  70. set.ShowDialog();
  71. }
  72. RefreshQTY();
  73. }
  74. }
  75. private void pa_outboxcode_KeyDown(object sender, KeyEventArgs e)
  76. {
  77. if (e.KeyCode == Keys.Enter)
  78. {
  79. dt = (DataTable)dh.ExecuteSql("select * from wmsoutdetail where WOD_DN='" + pa_outboxcode.Text + "'", "select");
  80. if (dt.Rows.Count > 0)
  81. {
  82. BaseUtil.FillDgvWithDataTable(CheckSnDGV, dt);
  83. RefreshQTY();
  84. sncode.Focus();
  85. }
  86. else
  87. {
  88. OperateResult.AppendText("<<DN号" + pa_outboxcode.Text + "不存在\n", Color.Red);
  89. }
  90. }
  91. }
  92. private void RefreshQTY()
  93. {
  94. int boxnum = 0;
  95. int palletnum = 0;
  96. int checkboxnum = 0;
  97. int checkpallernum = 0;
  98. for (int i = 0; i < CheckSnDGV.Rows.Count; i++)
  99. {
  100. if (CheckSnDGV.Rows[i].Cells["WOD_TYPE"].Value.ToString() == "卡通箱")
  101. {
  102. boxnum = boxnum + 1;
  103. if (CheckSnDGV.Rows[i].Cells["pd_checksn1"].Value != null)
  104. {
  105. checkboxnum = checkboxnum + 1;
  106. }
  107. }
  108. if (CheckSnDGV.Rows[i].Cells["WOD_TYPE"].Value.ToString() == "栈板")
  109. {
  110. palletnum = palletnum + 1;
  111. if (CheckSnDGV.Rows[i].Cells["pd_checksn1"].Value != null)
  112. {
  113. checkpallernum = checkpallernum + 1;
  114. }
  115. }
  116. }
  117. QTY.Text = "卡通箱:" + checkboxnum + "/" + boxnum + " 栈板号:" + checkpallernum + "/" + palletnum;
  118. }
  119. }
  120. }