Make_PalletWeigh.cs 14 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319
  1. using LabelManager2;
  2. using System;
  3. using System.Collections.Generic;
  4. using System.ComponentModel;
  5. using System.Data;
  6. using System.Drawing;
  7. using System.IO;
  8. using System.IO.Ports;
  9. using System.Linq;
  10. using System.Text;
  11. using System.Text.RegularExpressions;
  12. using System.Threading;
  13. using System.Windows.Forms;
  14. using UAS_MES.DataOperate;
  15. using UAS_MES.Entity;
  16. using UAS_MES.PublicForm;
  17. using UAS_MES.PublicMethod;
  18. namespace UAS_MES.Make
  19. {
  20. public partial class Make_PalletWeigh : Form
  21. {
  22. AutoSizeFormClass asc = new AutoSizeFormClass();
  23. LogStringBuilder sql = new LogStringBuilder();
  24. ApplicationClass lbl;
  25. Document doc;
  26. Thread InitPrint;
  27. Thread thread;
  28. DataHelper dh;
  29. DataTable dt;
  30. DataTable listc;
  31. DataTable info;
  32. //创建串口实例
  33. SerialPort serialPort1 = new SerialPort();
  34. //true的时候表示从串口读取数据
  35. bool GetData = true;
  36. public Make_PalletWeigh()
  37. {
  38. InitializeComponent();
  39. }
  40. private void Make_PalletWeigh_Load(object sender, EventArgs e)
  41. {
  42. CheckForIllegalCrossThreadCalls = false;
  43. asc.controllInitializeSize(this);
  44. OperateResult.AppendText(">>请输入栈板号\n", Color.Black);
  45. //栈板号输入框聚焦
  46. ComList.Text = BaseUtil.GetCacheData("PortName").ToString();
  47. BaudRate.Text = BaseUtil.GetCacheData("BaudRate").ToString();
  48. InitPrint = new Thread(InPrint);
  49. SetLoadingWindow stw = new SetLoadingWindow(InitPrint, "初始化打印程序");
  50. BaseUtil.SetFormCenter(stw);
  51. stw.ShowDialog();
  52. startWeigh.PerformClick();
  53. dh = SystemInf.dh;
  54. palletcode.Focus();
  55. }
  56. protected override void OnVisibleChanged(EventArgs e)
  57. {
  58. base.OnVisibleChanged(e);
  59. if (!IsHandleCreated)
  60. {
  61. this.Close();
  62. }
  63. }
  64. private void InPrint()
  65. {
  66. try
  67. {
  68. lbl = new ApplicationClass();
  69. BaseUtil.WriteLbl();
  70. }
  71. catch (Exception ex)
  72. {
  73. OperateResult.AppendText("未正确安装CodeSoft软件\n", Color.Red);
  74. }
  75. }
  76. private void Make_PalletWeigh_SizeChanged(object sender, EventArgs e)
  77. {
  78. asc.controlAutoSize(this);
  79. }
  80. private void palletcode_KeyDown(object sender, KeyEventArgs e)
  81. {
  82. //按下了enter键
  83. if (e.KeyCode == Keys.Enter)
  84. {
  85. if (palletcode.Text == "")
  86. {
  87. OperateResult.AppendText("<<输入不能为空\n", Color.Red);
  88. return;
  89. }
  90. if (weight.Text == "")
  91. {
  92. OperateResult.AppendText("<<未读取到重量信息\n", Color.Red);
  93. return;
  94. }
  95. //校验栈板号
  96. sql.Clear();
  97. sql.Append("select pa_id,pa_prodcode,pr_detail,pa_makecode,pa_salecode,pa_totalqty,");
  98. sql.Append("pa_packageqty from package left join product on pr_code=pa_prodcode where ");
  99. sql.Append("pa_outboxcode=:code and pa_type='3'");
  100. dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select", palletcode.Text);
  101. if (dt.Rows.Count == 0)
  102. {
  103. OperateResult.AppendText("<<无该栈板号\n", Color.Red, palletcode);
  104. }
  105. else
  106. {
  107. //给页面赋值
  108. BaseUtil.SetFormValue(this.Controls, dt);
  109. //刷新grid的历史称重信息;
  110. if (double.Parse(weight.Text.Replace("kg", "").Trim()) == 0)
  111. {
  112. OperateResult.AppendText("<<重量不能等于0\n", Color.Red, palletcode);
  113. return;
  114. }
  115. // 更新大箱重量
  116. sql.Clear();
  117. sql.Append("update package set pa_weight=:weight where pa_id=:pa_id ");
  118. dh.ExecuteSql(sql.GetString(), "update", weight.Text.Replace("kg", "").Trim(), dt.Rows[0]["pa_id"].ToString());
  119. //记录makeprocess
  120. //查询maid
  121. info = (DataTable)dh.ExecuteSql("select ma_id,ma_wccode from make where ma_code='" + pa_makecode.Text + "'", "select");
  122. if (info.Rows.Count > 0)
  123. {
  124. //有值
  125. //查询
  126. sql.Clear();
  127. sql.Append("insert into MakeProcess(mp_id,mp_makecode,mp_maid,mp_stepcode,mp_stepname ,");
  128. sql.Append("mp_kind,mp_result,mp_indate,mp_inman,mp_wccode,mp_linecode,mp_sourcecode,");
  129. sql.Append("mp_snoutboxcode) values ( makeprocess_seq.nextval,:makecode,:ma_id,:craftcode,:craftname,'栈板称重'");
  130. sql.Append(",:result,sysdate,:inman,:workcenter,:linecode,:source,:palletcode) ");
  131. dh.ExecuteSql(sql.GetString(), "insert", pa_makecode.Text, info.Rows[0]["ma_id"].ToString(), User.CurrentStepCode, User.CurrentStepName, "称重成功,栈板号:" + palletcode.Text + ",重量:" + weight.Text.Trim(), User.UserName, info.Rows[0]["ma_wccode"].ToString(), User.UserLineCode, User.UserSourceCode, palletcode.Text);
  132. //提示信息栏显示:<< 栈板号:XXXX,重量:xxxx 克,
  133. OperateResult.AppendText("<<栈板号:" + palletcode.Text + ",重量:" + weight.Text.Trim() + "\n", Color.Green);
  134. //记录日志
  135. LogicHandler.DoCommandLog(Tag.ToString(), User.UserCode, pa_makecode.Text, User.UserLineCode, User.UserSourceCode, "栈板称重", "重量:" + weight.Text.Trim() + "\n", palletcode.Text, "");
  136. //刷新称重计数+1
  137. weightedNum.Text = double.Parse(weightedNum.Text) + 1 + "";
  138. recordResult(palletcode.Text, weight.Text.Trim(), System.DateTime.Now.ToString());
  139. //插入称重日志表
  140. //sql.Clear();
  141. //sql.Append("insert into weightlog(wl_id,wl_type,wl_scancode,wl_weight,wl_unit,wl_linecode,");
  142. //sql.Append("wl_prodcode,wl_sccode,wl_indate,wl_inman) values (weightlog_seq.nextval,'PALLET',:palletcode,");
  143. //sql.Append(":weight,'kg',:linecode,:prodcode,:sccode,sysdate,:inman)");
  144. //dh.ExecuteSql(sql.GetString(), "insert", palletcode.Text, weight.Text.Replace("kg", "").Trim(), User.UserLineCode, pa_prodcode.Text, User.UserSourceCode, User.UserName);
  145. LogicHandler.RecordProdWeight(palletcode.Text, "PALLET", float.Parse(weight.Text.Replace("kg", "").Trim()), "kg", User.UserLineCode, pa_prodcode.Text, User.UserSourceCode, User.UserName);
  146. //如果用户勾选了自动打印,调用打印, 打印成功,消息提示栏显示“打印成功”,“请输入栈板号”
  147. if (autoPrint.Checked == true)
  148. {
  149. try
  150. {
  151. if (PrintLabel.SelectedValue == null)
  152. {
  153. OperateResult.AppendText(">>产品:" + pa_prodcode.Text + "未维护栈板标签模板\n", Color.Red, palletcode);
  154. return;
  155. }
  156. //doc = lbl.Documents.Open(PrintLabel.Text);
  157. string ErrorMessage = "";
  158. if (Print.CodeSoft(Tag.ToString(), ref lbl, PrintLabel.Text, PrintLabel.SelectedValue.ToString(), Printer.Text, palletcode.Text, int.Parse(PrintNum.Text), pa_makecode.Text, pa_prodcode.Text, "栈板标", "0", out ErrorMessage))
  159. {
  160. //打印成功,请输入栈板号
  161. OperateResult.AppendText("<<打印成功\n", Color.Green);
  162. }
  163. else
  164. {
  165. OperateResult.AppendText(ErrorMessage + "\n", Color.Red);
  166. }
  167. }
  168. catch (Exception ex)
  169. {
  170. OperateResult.AppendText("<<打印失败\n", Color.Red);
  171. OperateResult.AppendText(">>请输入栈板号\n", Color.Black, palletcode);
  172. return;
  173. }
  174. OperateResult.AppendText(">>请输入栈板号\n", Color.Black);
  175. //更新栈板打印次数
  176. sql.Clear();
  177. sql.Append("update package set pa_printcount= pa_printcount+1 where pa_id=:pa_id");
  178. dh.ExecuteSql(sql.GetString(), "update", dt.Rows[0]["pa_id"].ToString());
  179. //清空输入框中的值,扫描框置空定焦
  180. palletcode.Text = "";
  181. }
  182. else
  183. {
  184. OperateResult.AppendText("<<需打印请勾选自动打印\n", Color.Red);
  185. }
  186. }
  187. }
  188. }
  189. }
  190. private void pa_prodcode_TextChanged(object sender, EventArgs e)
  191. {
  192. listc = (DataTable)dh.ExecuteSql("select la_id,substr(la_url,instr(la_url,'\\',-1)+1)la_name,la_url,la_isdefault from label where la_prodcode='" + pa_prodcode.Text + "' and la_templatetype='栈板标' and la_statuscode='AUDITED' order by la_isdefault", "select");
  193. if (listc.Rows.Count == 0)
  194. {
  195. OperateResult.AppendText(">>产品:" + pa_prodcode.Text + "未维护栈板标签模板\n", Color.Red);
  196. }
  197. PrintLabel.DataSource = listc;
  198. PrintLabel.DisplayMember = "la_url";
  199. PrintLabel.ValueMember = "la_id";
  200. }
  201. private void startWeigh_Click(object sender, EventArgs e)
  202. {
  203. thread = new Thread(getSerialData);
  204. try
  205. {
  206. GetData = true;
  207. serialPort1.PortName = this.ComList.Text;
  208. serialPort1.BaudRate = int.Parse(BaudRate.Text);
  209. serialPort1.Open();
  210. thread.Start();
  211. }
  212. catch (Exception mes)
  213. {
  214. if (BaudRate.Text == "" || ComList.Text == "")
  215. OperateResult.AppendText(">>请先在电子秤调试界面维护波特率和串口\n", Color.Red);
  216. else
  217. OperateResult.AppendText(">>" + mes.Message + "\n", Color.Red);
  218. }
  219. }
  220. //停止称重
  221. private void stopWeigh_Click(object sender, EventArgs e)
  222. {
  223. if (serialPort1.IsOpen)
  224. {
  225. GetData = false;
  226. serialPort1.Close();
  227. SystemInf.OpenPort.Remove(serialPort1.PortName);
  228. thread.Abort();
  229. }
  230. }
  231. private void getSerialData()
  232. {
  233. if (serialPort1.IsOpen)
  234. {
  235. if (!SystemInf.OpenPort.Contains(serialPort1.PortName))
  236. {
  237. SystemInf.OpenPort.Add(serialPort1.PortName);
  238. try
  239. {
  240. while (GetData)
  241. {
  242. try
  243. {
  244. //weight.Text = Regex.Replace(serialPort1.ReadLine(), "\\D+", "");
  245. weight.Text = serialPort1.ReadLine();
  246. }
  247. catch (Exception)
  248. {
  249. GetData = false;
  250. }
  251. }
  252. }
  253. catch (IOException ex) { MessageBox.Show(ex.Message); }
  254. }
  255. else
  256. MessageBox.Show("端口已被占用,请关闭其他窗口");
  257. }
  258. }
  259. private void Make_PalletWeigh_FormClosing(object sender, FormClosingEventArgs e)
  260. {
  261. BaseUtil.ClosePrint(lbl);
  262. stopWeigh.PerformClick();
  263. InitPrint.Abort();
  264. if (serialPort1.IsOpen)
  265. {
  266. GetData = false;
  267. serialPort1.Close();
  268. SystemInf.OpenPort.Remove(serialPort1.PortName);
  269. thread.Interrupt();
  270. }
  271. //thread.Abort();
  272. }
  273. private void recordResult(string palletcode, string weigh, string time)
  274. {
  275. //if (showResult.Items.Count >= 50)
  276. //{
  277. // //如果有10行的话,则删除最前一行
  278. // showResult.Items.RemoveAt(0);
  279. //}
  280. //创建一个item
  281. ListViewItem lvi = new ListViewItem();
  282. //分条赋值
  283. lvi.SubItems.Add(palletcode);
  284. lvi.SubItems.Add(weigh);
  285. lvi.SubItems.Add(time);
  286. //添加结果的信息进去
  287. showResult.Items.Add(lvi);
  288. }
  289. private void PrintLabel_SelectedValueChanged(object sender, EventArgs e)
  290. {
  291. if (PrintLabel.SelectedValue != null && PrintLabel.SelectedValue.ToString() != "System.Data.DataRowView")
  292. {
  293. string PrintNums = dh.getFieldDataByCondition("label", "la_printnos", "la_id='" + PrintLabel.SelectedValue.ToString() + "'").ToString();
  294. PrintNum.Text = (PrintNums == "" ? "1" : PrintNums);
  295. }
  296. }
  297. }
  298. }