Packing_ProdWeightSet.cs 7.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223
  1. using System;
  2. using System.Collections.Generic;
  3. using System.ComponentModel;
  4. using System.Data;
  5. using System.Drawing;
  6. using System.IO;
  7. using System.IO.Ports;
  8. using System.Linq;
  9. using System.Text;
  10. using System.Text.RegularExpressions;
  11. using System.Threading;
  12. using System.Windows.Forms;
  13. using UAS_MES.DataOperate;
  14. using UAS_MES.Entity;
  15. using UAS_MES.PublicMethod;
  16. namespace UAS_MES.Packing
  17. {
  18. public partial class Packing_ProdWeightSet : Form
  19. {
  20. AutoSizeFormClass asc = new AutoSizeFormClass();
  21. DataTable Dbfind;//存储工单号查询出来的信息
  22. //创建串口实例
  23. SerialPort serialPort1 = new SerialPort();
  24. DataHelper dh;
  25. Thread thread;
  26. //true的时候表示从串口读取数据
  27. bool GetData = true;
  28. int samplesCount = 0;
  29. string maxValue = "";//存储最大值
  30. string minValue = "";//存储最小值
  31. public Packing_ProdWeightSet()
  32. {
  33. InitializeComponent();
  34. }
  35. private void Packing_ProdWeightSet_Load(object sender, EventArgs e)
  36. {
  37. asc.controllInitializeSize(this);
  38. ComList.Text = BaseUtil.GetCacheData("PortName").ToString();
  39. BaudRate.Text = BaseUtil.GetCacheData("BaudRate").ToString();
  40. //工单号放大镜配置
  41. ma_code.TableName = "make left join product on ma_prodcode=pr_code";
  42. ma_code.SelectField = "ma_code # 工单号,pr_code # 产品编号,pr_detail # 产品名称,pr_spec # 规格,ma_qty # 工单数量";
  43. ma_code.FormName = Name;
  44. ma_code.SetValueField = new string[] { "ma_code","pr_code","pr_detail","pr_spec" };
  45. ma_code.DbChange += Ma_code_DbChange;
  46. dh = new DataHelper();
  47. //开始称重
  48. startWeigh.PerformClick();
  49. }
  50. private void Ma_code_DbChange(object sender, EventArgs e)
  51. {
  52. Dbfind = ma_code.ReturnData;
  53. BaseUtil.SetFormValue(this.Controls, Dbfind);
  54. }
  55. private void recordResult(int index,string palletcode, string weigh, string time)
  56. {
  57. //创建一个item
  58. ListViewItem lvi = new ListViewItem();
  59. //分条赋值
  60. lvi.SubItems.Add(index+"");
  61. lvi.SubItems.Add(palletcode);
  62. lvi.SubItems.Add(weigh+pr_cartonunit.Text);
  63. lvi.SubItems.Add(time);
  64. //添加结果的信息进去
  65. showResult.Items.Add(lvi);
  66. //更新已称重量最大值最小值
  67. if (index > 1)
  68. {
  69. maxValue = double.Parse(weigh) > double.Parse(maxValue) ? weigh : maxValue;
  70. minValue = double.Parse(weigh) < double.Parse(minValue) ? weigh : minValue;
  71. }
  72. else
  73. {
  74. maxValue = weigh;
  75. minValue = weigh;
  76. }
  77. }
  78. private void startWeigh_Click(object sender, EventArgs e)
  79. {
  80. thread = new Thread(getSerialData);
  81. try
  82. {
  83. GetData = true;
  84. serialPort1.PortName = this.ComList.Text;
  85. serialPort1.BaudRate = int.Parse(BaudRate.Text);
  86. serialPort1.Open();
  87. thread.Start();
  88. }
  89. catch (Exception mes)
  90. {
  91. if (BaudRate.Text == "" || ComList.Text == "")
  92. OperateResult.AppendText(">>请先在电子秤调试界面维护波特率和串口\n", Color.Red);
  93. else
  94. OperateResult.AppendText(">>" + mes.Message + "\n", Color.Red);
  95. }
  96. }
  97. private void getSerialData()
  98. {
  99. if (serialPort1.IsOpen)
  100. {
  101. if (!SystemInf.OpenPort.Contains(serialPort1.PortName))
  102. {
  103. SystemInf.OpenPort.Add(serialPort1.PortName);
  104. try
  105. {
  106. while (GetData)
  107. {
  108. try
  109. {
  110. weight.Text = Regex.Replace(serialPort1.ReadLine(), "\\D+", "");
  111. }
  112. catch (Exception)
  113. {
  114. GetData = false;
  115. }
  116. }
  117. }
  118. catch (IOException ex) { MessageBox.Show(ex.Message); }
  119. }
  120. else
  121. MessageBox.Show("端口已被占用,请关闭其他窗口");
  122. }
  123. }
  124. //停止称重
  125. private void stopWeigh_Click(object sender, EventArgs e)
  126. {
  127. GetData = false;
  128. SystemInf.OpenPort.Remove(serialPort1.PortName);
  129. serialPort1.Close();
  130. }
  131. private void confirm_Click(object sender, EventArgs e)
  132. {
  133. //按确认更新产品重量
  134. if (ma_code.Text=="")
  135. {
  136. OperateResult.AppendText("<<请先选择工单\n", Color.Red);
  137. return;
  138. }
  139. //判断是否达到已称数量
  140. if (showResult.Items.Count<samplesCount)
  141. {
  142. OperateResult.AppendText("<<采样个数不足\n", Color.Red);
  143. return;
  144. }
  145. //更新彩盒重量最大值最小值
  146. dh.ExecuteSql("update product set PR_COLORBOXMAXW ='"+maxValue+"', PR_COLORBOXMINW = '"+minValue+ "',PR_COLORBOXUNIT='"+pr_cartonunit.Text+"' where pr_code='" + pr_code.Text+"'", "update");
  147. OperateResult.AppendText("<<重量设置成功,最大值"+maxValue+pr_cartonunit.Text+",最小值"+minValue+pr_cartonunit.Text+"\n", Color.Green);
  148. }
  149. private void sncode_KeyDown(object sender, KeyEventArgs e)
  150. {
  151. //按下了enter键
  152. if (e.KeyCode == Keys.Enter)
  153. {
  154. if (sncode.Text == "")
  155. {
  156. OperateResult.AppendText("<<输入不能为空\n", Color.Red);
  157. return;
  158. }
  159. if (weight.Text == "")
  160. {
  161. OperateResult.AppendText("<<未读取到重量信息\n", Color.Red);
  162. return;
  163. }
  164. if (double.Parse(weight.Text) == 0)
  165. {
  166. OperateResult.AppendText("<<重量不能等于0\n", Color.Red, sncode);
  167. return;
  168. }
  169. //验证彩盒是否与工单对应
  170. if (!dh.CheckExist("makeserial","ms_makecode='"+ma_code.Text+"' and ms_sncode = '"+sncode.Text+"'"))
  171. {
  172. OperateResult.AppendText("<<序列号"+sncode.Text+"不在工单"+ma_code.Text+"中\n", Color.Red, sncode);
  173. return;
  174. }
  175. //记录重量
  176. recordResult(showResult.Items.Count+1,sncode.Text, weight.Text, System.DateTime.Now.ToString());
  177. }
  178. }
  179. private void Packing_ProdWeightSet_AutoSizeChanged(object sender, EventArgs e)
  180. {
  181. }
  182. private void Packing_ProdWeightSet_SizeChanged(object sender, EventArgs e)
  183. {
  184. asc.controlAutoSize(this);
  185. }
  186. private void ma_code_UserControlTextChanged(object sender, EventArgs e)
  187. {
  188. //查询重量设置采样个数
  189. try
  190. {
  191. samplesCount = int.Parse(dh.GetConfig("重量设置采样个数", "MESSetting").ToString());
  192. }
  193. catch (Exception ess)
  194. {
  195. //如果没维护的话默认是10
  196. samplesCount = 10;
  197. }
  198. OperateResult.AppendText("<<重量设置需采样个数为" + samplesCount + "\n", Color.Black);
  199. //清空称量记录
  200. showResult.Items.Clear();
  201. }
  202. }
  203. }