Make_PalletWeigh.cs 10 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273
  1. using System;
  2. using System.Data;
  3. using System.IO;
  4. using System.IO.Ports;
  5. using System.Text.RegularExpressions;
  6. using System.Threading;
  7. using System.Windows.Forms;
  8. using UAS_MES_NEW.DataOperate;
  9. using UAS_MES_NEW.Entity;
  10. using UAS_MES_NEW.PublicMethod;
  11. using System.Drawing;
  12. using LabelManager2;
  13. using UAS_MES_NEW.PublicForm;
  14. using System.Net.Sockets;
  15. using System.Collections.Generic;
  16. using System.Net;
  17. using System.Text;
  18. using Seagull.BarTender.Print;
  19. namespace UAS_MES_NEW.Make
  20. {
  21. public partial class Make_PalletWeigh : Form
  22. {
  23. AutoSizeFormClass asc = new AutoSizeFormClass();
  24. ApplicationClass lbl;
  25. DataHelper dh;
  26. DataTable dt;
  27. LogStringBuilder sql = new LogStringBuilder();
  28. //启用线程进行称重数据读取
  29. Thread thread;
  30. SerialPort serialPort1 = new SerialPort();
  31. //称量的标准重量
  32. Double Weight;
  33. //最大重量
  34. Double MaxWeight;
  35. //最小重量
  36. Double MinWeight;
  37. //是否通过串口获取数据
  38. bool GetData = true;
  39. string LastSncode;
  40. DataTable Dbfind;
  41. Regex re = new Regex("\\d+.\\d+");
  42. string ErrorMessage;
  43. Thread InitPrint;
  44. private bool AutoCut;
  45. public Make_PalletWeigh()
  46. {
  47. InitializeComponent();
  48. CheckForIllegalCrossThreadCalls = false;
  49. }
  50. Engine engine;
  51. private void InPrint()
  52. {
  53. try
  54. {
  55. engine = new Engine(true);
  56. }
  57. catch (Exception ex)
  58. {
  59. OperateResult.AppendText(ex.Message + ex.StackTrace, Color.Red);
  60. }
  61. }
  62. private void Make_ColorBoxWeigh_Load(object sender, EventArgs e)
  63. {
  64. asc.controllInitializeSize(this);
  65. ComList.Text = BaseUtil.GetCacheData("PortName").ToString();
  66. BaudRate.Text = BaseUtil.GetCacheData("BaudRate").ToString();
  67. InitPrint = new Thread(InPrint);
  68. SetLoadingWindow stw = new SetLoadingWindow(InitPrint, "初始化打印程序");
  69. BaseUtil.SetFormCenter(stw);
  70. stw.ShowDialog();
  71. //设置锁定工单
  72. LockMakeCode.GetMakeCodeCtl(ma_code);
  73. ma_code.SetLockCheckBox(LockMakeCode);
  74. //工单号放大镜配置
  75. ma_code.TableName = "make left join product on ma_prodcode=pr_code";
  76. ma_code.SelectField = "ma_code # 工单号,pr_code # 产品编号,pr_spec # 产品规格";
  77. ma_code.FormName = Name;
  78. ma_code.SetValueField = new string[] { "ma_code", "pr_code", "pr_spec" };
  79. ma_code.Condition = "ma_statuscode='STARTED'";
  80. ma_code.DbChange += Ma_code_DbChange;
  81. StartWeight.PerformClick();
  82. dh = SystemInf.dh;
  83. StepCount.StepCode = User.CurrentStepCode;
  84. StepCount.Source = User.UserSourceCode;
  85. StepCount.LineCode = User.UserLineCode;
  86. StepCount.Dh = dh;
  87. StepCount.Start();
  88. AutoPrint.Checked = false;
  89. }
  90. private void Ma_code_DbChange(object sender, EventArgs e)
  91. {
  92. Dbfind = ma_code.ReturnData;
  93. BaseUtil.SetFormValue(this.Controls, Dbfind);
  94. //获取工单的其他信息
  95. sql.Clear();
  96. sql.Append("select ma_code,ma_prodcode as pr_code , pr_detail as pr_spec,");
  97. sql.Append("pr_spec,ma_qty - nvl(mcd_inqty, 0) mcd_remainqty from make left join makecraftdetail_view on ");
  98. sql.Append("mcd_maid=ma_id left join product on pr_code=ma_prodcode where ma_code='" + ma_code.Text + "' and mcd_stepcode='" + User.CurrentStepCode + "'");
  99. dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
  100. if (dt.Rows.Count > 0)
  101. {
  102. BaseUtil.SetFormValue(this.Controls, dt);
  103. }
  104. }
  105. private void sncode_KeyDown(object sender, KeyEventArgs e)
  106. {
  107. if (e.KeyCode == Keys.Enter)
  108. {
  109. double ActualWeight = double.Parse(weight.Text == "" ? "0" : weight.Text.Replace("kg", "").Replace("g", "").Trim());
  110. ListViewItem lsi = new ListViewItem();
  111. lsi.SubItems.Add(sncode.Text);
  112. lsi.SubItems.Add(ActualWeight.ToString());
  113. lsi.SubItems.Add(System.DateTime.Now.ToString());
  114. WeighRecord.Items.Add(lsi);
  115. WeighRecord.Items[this.WeighRecord.Items.Count - 1].EnsureVisible();
  116. OperateResult.AppendText(">>彩盒" + sncode.Text + "称重完成\n", Color.Green);
  117. }
  118. }
  119. private void getSerialData()
  120. {
  121. if (serialPort1.IsOpen)
  122. {
  123. if (!SystemInf.OpenPort.Contains(serialPort1.PortName))
  124. {
  125. SystemInf.OpenPort.Add(serialPort1.PortName);
  126. try
  127. {
  128. while (GetData)
  129. {
  130. try
  131. {
  132. weight.Text = re.Match(serialPort1.ReadLine()).Groups[0].Value;
  133. }
  134. catch (Exception)
  135. {
  136. GetData = false;
  137. }
  138. }
  139. }
  140. catch (IOException ex) { MessageBox.Show(ex.Message); }
  141. }
  142. else OperateResult.AppendText(">>端口已被占用,请关闭其他窗口\n", Color.Red);
  143. }
  144. }
  145. private void 彩盒称重_SizeChanged(object sender, EventArgs e)
  146. {
  147. weight.Location = new Point(weight_label.Location.X + weight_label.Size.Width - 10, weight_label.Location.Y - 20);
  148. asc.controlAutoSize(this);
  149. }
  150. protected override void OnVisibleChanged(EventArgs e)
  151. {
  152. base.OnVisibleChanged(e);
  153. if (!IsHandleCreated)
  154. {
  155. this.Close();
  156. }
  157. }
  158. private void Clean_Click(object sender, EventArgs e)
  159. {
  160. OperateResult.Clear();
  161. }
  162. //关闭窗口的时候停止进程读取串口数据
  163. private void 彩盒称重_FormClosing(object sender, FormClosingEventArgs e)
  164. {
  165. BaseUtil.ClosePrint(lbl);
  166. StopWeight.PerformClick();
  167. InitPrint.Abort();
  168. if (serialPort1.IsOpen)
  169. {
  170. GetData = false;
  171. serialPort1.Close();
  172. SystemInf.OpenPort.Remove(serialPort1.PortName);
  173. thread.Interrupt();
  174. }
  175. }
  176. private void Confirm_Click(object sender, EventArgs e)
  177. {
  178. if (ma_code.Text == "")
  179. {
  180. OperateResult.AppendText(">>请先选择工单号\n", Color.Red);
  181. return;
  182. }
  183. if (weight.Text == "")
  184. {
  185. OperateResult.AppendText(">>未读取到重量,请先链接电子秤\n", Color.Red);
  186. return;
  187. }
  188. sncode.Text = LogicHandler.GetOutBoxCode1("PALLETCODE", ma_code.Text, pr_code.Text, User.UserCode);
  189. if (PrintLabel.Items.Count != 0)
  190. {
  191. string oErrorMessage;
  192. if (!Print.BarTender(Tag.ToString(), ref engine, PrintLabel.Text, PrintLabel.SelectedValue.ToString(), PrinterList.Text, sncode.Text, int.Parse(PrintNum.Text), ma_code.Text, pr_code.Text, "卡板标", "0", out oErrorMessage))
  193. {
  194. OperateResult.AppendText(oErrorMessage + "\n", Color.Red);
  195. }
  196. }
  197. else
  198. {
  199. OperateResult.AppendText(">>产品" + pr_code.Text + "未维护卡板标签\n", Color.Red);
  200. return;
  201. }
  202. dh.ExecuteSql("insert into pallet(PL_ID, PL_CODE, PL_MAKECODE, PL_INMAN, PL_INDATE, PL_WEIGHT)" +
  203. "values(pallet_seq.nextval,'" + sncode.Text + "','" + ma_code.Text + "','" + User.UserCode + "',sysdate,'" + weight.Text + "')", "insert");
  204. OperateResult.AppendText(">>卡板" + sncode.Text + "标签打印成功\n", Color.Green);
  205. }
  206. Thread threadWatch = null; //负责监听客户端的线程
  207. Socket socketWatch = null; //负责监听客户端的套接字
  208. Socket socConnection;
  209. private void StartWeight_Click(object sender, EventArgs e)
  210. {
  211. thread = new Thread(getSerialData);
  212. try
  213. {
  214. serialPort1.PortName = ComList.Text;
  215. serialPort1.BaudRate = int.Parse(BaudRate.Text);
  216. serialPort1.Open();
  217. GetData = true;
  218. thread.Start();
  219. }
  220. catch (Exception mes)
  221. {
  222. if (BaudRate.Text == "" || ComList.Text == "")
  223. OperateResult.AppendText(">>请先在电子秤调试界面维护波特率和串口\n", Color.Red);
  224. else
  225. OperateResult.AppendText(">>" + mes.Message + "\n", Color.Red);
  226. }
  227. }
  228. private void StopWeight_Click(object sender, EventArgs e)
  229. {
  230. if (serialPort1.IsOpen)
  231. {
  232. GetData = false;
  233. serialPort1.Close();
  234. SystemInf.OpenPort.Remove(serialPort1.PortName);
  235. thread.Abort();
  236. }
  237. }
  238. private void pr_code_TextChanged(object sender, EventArgs e)
  239. {
  240. DataTable _dt = (DataTable)dh.ExecuteSql("select la_id,la_url,la_isdefault from label where la_templatetype='卡板标' and la_statuscode='AUDITED' order by la_isdefault", "select");
  241. PrintLabel.DataSource = _dt;
  242. PrintLabel.DisplayMember = "la_url";
  243. PrintLabel.ValueMember = "la_id";
  244. }
  245. private void PrintLabel_SelectedValueChanged(object sender, EventArgs e)
  246. {
  247. if (PrintLabel.SelectedValue != null && PrintLabel.SelectedValue.ToString() != "System.Data.DataRowView")
  248. {
  249. string PrintNums = dh.getFieldDataByCondition("label", "la_printnos", "la_id='" + PrintLabel.SelectedValue.ToString() + "'").ToString();
  250. PrintNum.Text = (PrintNums == "" ? "1" : PrintNums);
  251. }
  252. }
  253. }
  254. }