Make_SNLabelCheckMidBox.cs 30 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558
  1. using System;
  2. using System.Data;
  3. using System.Windows.Forms;
  4. using UAS_MES_NEW.DataOperate;
  5. using UAS_MES_NEW.Entity;
  6. using UAS_MES_NEW.PublicMethod;
  7. using System.Drawing;
  8. using System.Collections.Generic;
  9. using UAS_MES_NEW.PublicForm;
  10. using Seagull.BarTender.Print;
  11. using System.Threading;
  12. using System.Text.RegularExpressions;
  13. using static HslCommunication.Profinet.Knx.KnxCode;
  14. using System.IO.Ports;
  15. using System.Runtime.InteropServices;
  16. using System.IO;
  17. using System.Text;
  18. using static System.Runtime.CompilerServices.RuntimeHelpers;
  19. namespace UAS_MES_NEW.Make
  20. {
  21. public partial class Make_SNLabelCheckMidBox : Form
  22. {
  23. //MakeSerial表主键
  24. string ms_id;
  25. //制造单号
  26. string make_code;
  27. //产品编号
  28. string make_prodcode;
  29. //工序编号
  30. string nextstepcode;
  31. //完工状态
  32. string ms_status;
  33. //工艺路线编号
  34. //Bom版本
  35. string mabomversion;
  36. string ErrorMessage = "";
  37. List<string> TSN = new List<string>();
  38. Dictionary<string, string> CheckBarcode = new Dictionary<string, string>();
  39. //用于提醒的序列B
  40. string[] RemainList = new string[0];
  41. //提醒序列的索引
  42. int RemainIndex = 0;
  43. string oMakeCode = "";
  44. string oMsid = "";
  45. string ms_firstsn = "";
  46. Thread InitPrint;
  47. Engine engine;
  48. DataHelper dh;
  49. LogStringBuilder sql = new LogStringBuilder();
  50. DataTable DBFind;
  51. DataTable dt;
  52. //保存ListB中的数据
  53. DataTable dt1;
  54. AutoSizeFormClass asc = new AutoSizeFormClass();
  55. public Make_SNLabelCheckMidBox()
  56. {
  57. InitializeComponent();
  58. }
  59. private void InPrint()
  60. {
  61. try
  62. {
  63. engine = new Engine(true);
  64. }
  65. catch (Exception)
  66. {
  67. OperateResult.AppendText("未正确安装BarTender软件\n", Color.Red);
  68. }
  69. }
  70. private void Make_FeedingCollection_Load(object sender, EventArgs e)
  71. {
  72. asc.controllInitializeSize(this);
  73. InitPrint = new Thread(InPrint);
  74. SetLoadingWindow stw = new SetLoadingWindow(InitPrint, "初始化打印程序");
  75. BaseUtil.SetFormCenter(stw);
  76. stw.ShowDialog();
  77. ComList.Text = BaseUtil.GetCacheData("PortName").ToString();
  78. BaudRate.Text = BaseUtil.GetCacheData("BaudRate").ToString();
  79. LockMakeCode.GetMakeCodeCtl(ma_code);
  80. ma_code.SetLockCheckBox(LockMakeCode);
  81. //工单号放大镜配置
  82. ma_code.TableName = "make left join product on ma_prodcode=pr_code";
  83. ma_code.SelectField = "ma_code # 工单号,ma_prodcode # 产品编号,ma_qty # 工单数量,ma_craftcode # 途程编号,pr_spec # 产品名称,ma_bomversion # Bom版本,ma_softversion # 软件版本,ma_ecncode # ECN号";
  84. ma_code.FormName = Name;
  85. ma_code.DBTitle = "工单查询";
  86. ma_code.SetValueField = new string[] { "ma_code", "ma_prodcode", "ma_qty", "pr_spec", "ma_craftcode", "ma_bomversion", "ma_softversion", "ma_ecncode" };
  87. ma_code.Condition = "ma_statuscode='STARTED'";
  88. ma_code.DbChange += Ma_code_DBChange;
  89. code.Focus();
  90. StartWeight.PerformClick();
  91. dh = SystemInf.dh;
  92. StepCount.StepCode = User.CurrentStepCode;
  93. StepCount.Source = User.UserSourceCode;
  94. StepCount.LineCode = User.UserLineCode;
  95. StepCount.Dh = dh;
  96. StepCount.Start();
  97. }
  98. private void Ma_code_DBChange(object sender, EventArgs e)
  99. {
  100. DBFind = ma_code.ReturnData;
  101. BaseUtil.SetFormValue(this.Controls, DBFind);
  102. }
  103. private void Make_FeedingCollection_SizeChanged(object sender, EventArgs e)
  104. {
  105. asc.controlAutoSize(this);
  106. }
  107. private void Clean_Click(object sender, EventArgs e)
  108. {
  109. OperateResult.Clear();
  110. }
  111. private void Confirm_Click(object sender, EventArgs e)
  112. {
  113. KeyEventArgs e2 = new KeyEventArgs(Keys.Enter);
  114. code_KeyDown(sender, e2);
  115. }
  116. private void code_KeyDown(object sender, KeyEventArgs e)
  117. {
  118. if (e.KeyCode == Keys.Enter)
  119. {
  120. if (LogicHandler.CheckStepAttribute(Tag.ToString(), User.UserSourceCode, out ErrorMessage))
  121. {
  122. if (Loading.Checked)
  123. {
  124. if (code.Text.Replace(" ", "") == "")
  125. {
  126. OperateResult.AppendText(">>采集数据不可为空\n", Color.Red);
  127. return;
  128. }
  129. //如果录入框和工单号均有输入
  130. if (code.Text != "" && ma_code.Text != "" && sn_code.Text == "")
  131. {
  132. GetCollectItem();
  133. BaseUtil.FillDgvWithDataTable(LabelDataGridView, dt1);
  134. }
  135. //输入框有值但未选择工单号
  136. else if (code.Text != "" && ma_code.Text == "" && sn_code.Text == "")
  137. {
  138. GetCollectItem();
  139. BaseUtil.FillDgvWithDataTable(LabelDataGridView, dt1);
  140. }
  141. else if (sn_code.Text != "")
  142. {
  143. bool AllCheck = true;
  144. //索引超出长度表示内容均已提醒
  145. for (int i = 0; i < LabelDataGridView.Rows.Count; i++)
  146. {
  147. if (LabelDataGridView.Rows[i].Cells["lcd_content"].Value == null)
  148. {
  149. string labeltype = LabelDataGridView.Rows[i].Cells["lcd_labeltype"].Value.ToString();
  150. string length = LabelDataGridView.Rows[i].Cells["lcd_length"].Value.ToString();
  151. string alllength = LabelDataGridView.Rows[i].Cells["lcd_alllength"].Value.ToString();
  152. string prefix = LabelDataGridView.Rows[i].Cells["lcd_prefix"].Value.ToString();
  153. string suffix = LabelDataGridView.Rows[i].Cells["lcd_suffix"].Value.ToString();
  154. string sql = LabelDataGridView.Rows[i].Cells["lcd_sql"].Value.ToString();
  155. if (sql != "")
  156. {
  157. Regex ConnoteA = new Regex("{\\w+}");
  158. foreach (Match mch in ConnoteA.Matches(sql))
  159. {
  160. string x = mch.Value.Trim();
  161. sql = sql.Replace(x, "'" + sn_code.Text + "'");
  162. }
  163. DataTable Param = (DataTable)dh.ExecuteSql(sql.ToString(), "select");
  164. if (Param.Rows.Count == 0)
  165. {
  166. OperateResult.AppendText(">>" + sn_code.Text + "SQL语句未获取到内容\n", Color.Red, code);
  167. return;
  168. }
  169. else
  170. {
  171. if (code.Text == Param.Rows[0][0].ToString())
  172. {
  173. LabelDataGridView.Rows[i].Cells["lcd_content"].Value = code.Text;
  174. }
  175. else
  176. {
  177. OperateResult.AppendText(">>" + sn_code.Text + "SQL获取内容" + Param.Rows[0][0].ToString() + "" +
  178. "和扫码内容" + code.Text + "不匹配\n", Color.Red, code);
  179. return;
  180. }
  181. }
  182. }
  183. else
  184. {
  185. if (!code.Text.StartsWith(prefix))
  186. {
  187. OperateResult.AppendText(">>" + labeltype + "前缀不匹配" + code.Text + "\n", Color.Red, code);
  188. return;
  189. }
  190. if (!code.Text.EndsWith(suffix))
  191. {
  192. OperateResult.AppendText(">>" + labeltype + "后缀不匹配" + code.Text + "\n", Color.Red, code);
  193. return;
  194. }
  195. if (int.Parse(alllength) > 0)
  196. {
  197. if (int.Parse(alllength) != code.Text.Length)
  198. {
  199. OperateResult.AppendText(">>" + labeltype + "总长度[" + alllength + "]" + code.Text + "不匹配\n", Color.Red, code);
  200. return;
  201. }
  202. }
  203. string tempstr = code.Text.Replace(prefix, "");
  204. if (!(tempstr.Length >= int.Parse(length) && code.Text.Replace(prefix, "").Substring(0, int.Parse(length)) == sn_code.Text))
  205. {
  206. OperateResult.AppendText(">>" + labeltype + "截取SN" + code.Text + "不匹配\n", Color.Red, code);
  207. return;
  208. }
  209. LabelDataGridView.Rows[i].Cells["lcd_content"].Value = code.Text;
  210. }
  211. break;
  212. }
  213. }
  214. //循环所有行,判断是否所有的内容都有值
  215. List<string> labeltype_list = new List<string>();
  216. List<string> prefix_list = new List<string>();
  217. List<string> length_list = new List<string>();
  218. List<string> value = new List<string>();
  219. int checkcount = 0;
  220. for (int i = 0; i < LabelDataGridView.Rows.Count; i++)
  221. {
  222. if (LabelDataGridView.Rows[i].Cells["lcd_content"].Value != null)
  223. {
  224. checkcount = checkcount + 1;
  225. labeltype_list.Add(LabelDataGridView.Rows[i].Cells["lcd_labeltype"].Value.ToString());
  226. prefix_list.Add(LabelDataGridView.Rows[i].Cells["lcd_labeltype"].Value.ToString());
  227. length_list.Add(LabelDataGridView.Rows[i].Cells["lcd_length"].Value.ToString());
  228. value.Add(LabelDataGridView.Rows[i].Cells["lcd_content"].Value.ToString());
  229. }
  230. else
  231. {
  232. AllCheck = false;
  233. }
  234. }
  235. ////如果达到了行数,则判定校验通过
  236. //if (checkcount == LabelDataGridView.Rows.Count)
  237. //{
  238. // AllCheck = true;
  239. //}
  240. if (AllCheck)
  241. {
  242. double ActualWeight = double.Parse(weight.Text == "" ? "0" : weight.Text.Replace("kg", "").Replace("g", "").Trim());
  243. if (MinWeight == 0 || MaxWeight == 0)
  244. {
  245. OperateResult.AppendText(">>产品" + ma_prodcode.Text + "未维护彩盒重量范围\n", Color.Red);
  246. return;
  247. }
  248. if ((ActualWeight >= MinWeight) && (ActualWeight <= MaxWeight))
  249. {
  250. OperateResult.AppendText(">>彩盒" + sn_code.Text + "重量检测检测合格\n", Color.Green);
  251. LogicHandler.DoCommandLog(Tag.ToString(), User.UserCode, ma_code.Text, User.UserLineCode, User.UserSourceCode, "彩盒称重:" + weight.Text, "称量合格", sn_code.Text, "");
  252. LogicHandler.RecordProdWeight(sn_code.Text, "SN", float.Parse(ActualWeight.ToString()), "kg", User.UserLineCode, ma_prodcode.Text, User.UserSourceCode, User.UserName);
  253. dh.ExecuteSql("update makeserial set ms_grossw='" + ActualWeight + "' where ms_id='" + oMsid + "'", "update");
  254. }
  255. else
  256. {
  257. OperateResult.AppendText(">>彩盒" + sn_code.Text + "重量检测未通过\n", Color.Red);
  258. LogicHandler.DoCommandLog(Tag.ToString(), User.UserCode, ma_code.Text, User.UserLineCode, User.UserSourceCode, "彩盒称重:" + weight.Text, "称量不合格", sn_code.Text, "");
  259. LogicHandler.RecordProdWeight(sn_code.Text, "SN", float.Parse(ActualWeight.ToString()), "kg", User.UserLineCode, ma_prodcode.Text, User.UserSourceCode, User.UserName);
  260. return;
  261. }
  262. sql.Clear();
  263. sql.Append("insert into labelchecklog(LCL_ID, LCL_SN, LCL_LABELTYPE, lcl_prefix,lcl_length, LCL_LABELVALUE, LCL_STEPCODE, LCL_SOURCECODE," +
  264. " LCL_INMAN, LCL_DATE)" +
  265. "select labelchecklog_seq.nextval,'" + sn_code.Text + "',:LCL_LABELTYPE,:lcl_prefix,:lcl_length,:LCL_LABELVALUE,'" + User.CurrentStepCode + "'" +
  266. ",'" + User.UserSourceCode + "','" + User.UserCode + "',sysdate from dual");
  267. dh.BatchInsert(sql.GetString(), new string[] { "LCL_LABELTYPE", "lcl_prefix", "lcl_length", "LCL_LABELVALUE" },
  268. labeltype_list.ToArray(), prefix_list.ToArray(), length_list.ToArray(), value.ToArray());
  269. LogicHandler.DoCommandLog(Tag.ToString(), User.UserCode, oMakeCode, User.UserLineCode, User.UserSourceCode, "上料采集", "上料成功", sn_code.Text, "");
  270. if (!Print.BarTender(Tag.ToString(), ref engine, PrintLabel.Text, PrintLabel.SelectedValue.ToString(), Printer.Text, sn_code.Text, int.Parse(PrintNum.Text == "" ? "1" : PrintNum.Text), ma_code.Text, ma_prodcode.Text, "中箱标", "0", out ErrorMessage))
  271. {
  272. OperateResult.AppendText(ErrorMessage + "\n", Color.Red);
  273. }
  274. if (!LogicHandler.SetStepResult(ma_code.Text, User.UserSourceCode, sn_code.Text, "标签核对", "标签核对完成", User.UserCode, out ErrorMessage))
  275. {
  276. OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red, code);
  277. return;
  278. }
  279. OperateResult.AppendText(">>校验完成\n", Color.Green, code);
  280. }
  281. }
  282. }
  283. //勾选了下料的时候
  284. else if (UnLoading.Checked)
  285. {
  286. if (LogicHandler.CheckStepSNAndMacode(ma_code.Text, User.UserSourceCode, code.Text, User.UserCode, out oMakeCode, out oMsid, out ErrorMessage))
  287. {
  288. sql.Clear();
  289. sql.Append("select ms_firstsn,cm_makecode,cm_craftcode,nvl(cm_status,0)cm_status,cm_id,cm_stepcode,");
  290. sql.Append("ms_makecode,cm_mccode,cm_materialtype from craftmaterial left join makeserial on cm_makecode");
  291. sql.Append("=ms_makecode and cm_sncode=ms_sncode where cm_sncode='" + code.Text + "' and cm_makecode='" + oMakeCode + "'");
  292. sql.Append("and cm_materialtype=1 and cm_stepcode='" + User.CurrentStepCode + "' ");
  293. dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
  294. if (dt.Rows.Count > 0)
  295. {
  296. string ms_macode = dt.Rows[0]["ms_makecode"].ToString();
  297. string ms_firstsn = dt.Rows[0]["ms_firstsn"].ToString();
  298. string cm_stepcode = dt.Rows[0]["cm_stepcode"].ToString();
  299. string cm_mccode = dt.Rows[0]["cm_mccode"].ToString();
  300. string cm_materialtype = dt.Rows[0]["cm_materialtype"].ToString();
  301. string cm_status = dt.Rows[0]["cm_status"].ToString();
  302. string cm_makecode = dt.Rows[0]["cm_makecode"].ToString();
  303. string cm_craftcode = dt.Rows[0]["cm_craftcode"].ToString();
  304. //清除已被使用的序列号
  305. sql.Clear();
  306. sql.Append("update makeserial set ms_nextmacode='' where ms_sncode in(select cm_barcode from craftmaterial where ");
  307. sql.Append("cm_makecode='" + cm_makecode + "' and cm_sncode='" + code.Text + "' and cm_stepcode='" + cm_stepcode + "' and cm_craftcode='" + cm_craftcode + "' ");
  308. sql.Append("and cm_materialtype=1 and nvl(cm_status,0) =0) and ms_nextmacode='" + oMakeCode + "'");
  309. dh.ExecuteSql(sql.GetString(), "update");
  310. sql.Clear();
  311. sql.Append("update makeserial set ms_nextstepcode=ms_stepcode where ms_id='" + ms_id + "'");
  312. dh.ExecuteSql(sql.GetString(), "update");
  313. //进行下料
  314. sql.Clear();
  315. sql.Append("delete from craftmaterial where (cm_sncode in (select sn from makesnrelation where firstsn");
  316. sql.Append("='" + ms_firstsn + "') or cm_sncode = '" + ms_firstsn + "') and cm_makecode = '" + oMakeCode + "' ");
  317. sql.Append("and cm_status = 0 and cm_stepcode='" + User.CurrentStepCode + "' and cm_materialtype=1");
  318. dh.ExecuteSql(sql.GetString(), "delete");
  319. LogicHandler.InsertMakeProcess(ms_macode, code.Text, User.UserSourceCode, "上料采集操作", "下料成功", User.UserCode);
  320. //刷新界面值
  321. sql.Clear();
  322. sql.Append("select mcd_inqty,ma_qty-mcd_inqty mcd_remainqty ");
  323. sql.Append("from make left join makecraftdetail on mcd_macode=ma_code where ");
  324. sql.Append("ma_code='" + oMakeCode + "' and mcd_stepcode='" + User.CurrentStepCode + "'");
  325. dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
  326. BaseUtil.SetFormValue(Controls, dt);
  327. LogicHandler.DoCommandLog(Tag.ToString(), User.UserCode, oMakeCode, User.UserLineCode, User.UserSourceCode, "上料采集", "下料成功", code.Text, "");
  328. OperateResult.AppendText(">>序列号" + code.Text + "下料成功\n", Color.Green, code);
  329. }
  330. else OperateResult.AppendText(">>序列号" + code.Text + "未上料,无需下料\n", Color.Red, code);
  331. }
  332. else OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red, code);
  333. }
  334. }
  335. else OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red, code);
  336. }
  337. }
  338. //获取采集的项目
  339. private void GetCollectItem()
  340. {
  341. if (LogicHandler.CheckStepSNAndMacode(ma_code.Text, User.UserSourceCode, code.Text, User.UserCode, out oMakeCode, out oMsid, out ErrorMessage))
  342. {
  343. nextstepcode = dh.getFieldDataByCondition("makeserial", "ms_nextstepcode", "ms_id='" + oMsid + "'").ToString();
  344. if (nextstepcode != User.CurrentStepCode)
  345. {
  346. string stname = dh.getFieldDataByCondition("step", "st_name", "st_code='" + nextstepcode + "'").ToString();
  347. OperateResult.AppendText("<<序列号:" + code.Text + "下一工序是" + stname + ",不是当前岗位的工序\n", Color.Red, code);
  348. return;
  349. }
  350. //将录入框的值给序列号
  351. sn_code.Text = code.Text;
  352. code.Str = "";
  353. sql.Clear();
  354. sql.Append("select ma_prodcode,ma_ecncode,ma_softversion,ms_firstsn,ma_bomversion,ma_qty,ma_code,pr_spec,ms_status,ms_id,ms_craftcode,ms_nextstepcode");
  355. sql.Append(",ms_prodcode,ms_makecode,ms_code,ms_stepname from makeserial left join make on ma_code=ms_makecode ");
  356. sql.Append("left join product on ms_prodcode=pr_code where ms_sncode='" + code.Text + "' order by ms_id desc");
  357. dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
  358. if (dt.Rows.Count > 0)
  359. {
  360. ms_id = dt.Rows[0]["ms_id"].ToString();
  361. make_code = dt.Rows[0]["ma_code"].ToString();
  362. mabomversion = dt.Rows[0]["ma_bomversion"].ToString();
  363. make_prodcode = dt.Rows[0]["ms_prodcode"].ToString();
  364. nextstepcode = dt.Rows[0]["ms_nextstepcode"].ToString();
  365. ms_status = dt.Rows[0]["ms_status"].ToString();
  366. ms_firstsn = dt.Rows[0]["ms_firstsn"].ToString();
  367. BaseUtil.SetFormValue(this.Controls, dt);
  368. LockMakeCode.Checked = true;
  369. //勾选了前一工单
  370. dt = (DataTable)dh.ExecuteSql("select ms_status,ms_stepcode,ms_nextstepcode from makeserial where ms_sncode='" + code.Text + "' and ms_makecode='" + ma_code.Text + "' order by ms_id desc", "select");
  371. nextstepcode = dt.Rows[0]["ms_nextstepcode"].ToString();
  372. ms_status = dt.Rows[0]["ms_status"].ToString();
  373. sn_code.Text = code.Text;
  374. code.Str = "";
  375. sql.Clear();
  376. sql.Append("select ma_code,ma_softversion,ma_ecncode,ma_prodcode,pr_spec,ma_qty from makeserial left join product ");
  377. sql.Append(" on ms_prodcode=pr_code left join make on ms_makecode=ma_code left join ");
  378. sql.Append("makecraftdetail on mcd_macode=ms_makecode where ms_id='" + oMsid + "' and mcd_stepcode='" + User.CurrentStepCode + "'");
  379. dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
  380. BaseUtil.SetFormValue(this.Controls, dt);
  381. OperateResult.AppendText(">>获取序列号" + code.Text + "成功\n", Color.Green);
  382. GetItem();
  383. }
  384. else
  385. {
  386. OperateResult.AppendText(">>序列号" + code.Text + "不存在\n", Color.Red, code);
  387. code.Text = "";
  388. sn_code.Text = "";
  389. code.Str = ma_prodcode.Text;
  390. }
  391. }
  392. else OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red, code);
  393. }
  394. private void GetItem()
  395. {
  396. dt1 = (DataTable)dh.ExecuteSql("select lcd_sql,lcd_detno,LCD_LABELTYPE, nvl(lcd_alllength,0)lcd_alllength,nvl(LCD_LENGTH,0)LCD_LENGTH,lcd_suffix, LCD_PREFIX from LABELCHECKdetail left join labelcheck " +
  397. "on lcd_lcid=lc_id where lc_prodcode='" + ma_prodcode.Text + "' and lcd_stepcode='" + User.CurrentStepCode + "' and LCD_LABELTYPE not in (select LCL_LABELTYPE from labelchecklog where " +
  398. "LCL_SN='" + sn_code.Text + "') order by lcd_detno", "select");
  399. if (dt1.Rows.Count == 0)
  400. {
  401. OperateResult.AppendText(">>序列号" + code.Text + "未设置核对类型,或者已核对完成\n", Color.Red, code);
  402. sn_code.Clear();
  403. code.Str = ma_prodcode.Text;
  404. }
  405. BaseUtil.FillDgvWithDataTable(LabelDataGridView, dt1);
  406. }
  407. private void ClearSn_code_Click(object sender, EventArgs e)
  408. {
  409. sn_code.Clear();
  410. CheckBarcode.Clear();
  411. code.Str = ma_prodcode.Text;
  412. if (dt1 != null)
  413. BaseUtil.CleanDataTableData(dt1);
  414. RemainIndex = 0;
  415. BaseUtil.CleanDGVData(LabelDataGridView);
  416. OperateResult.AppendText(">>请采集序列号\n", Color.Black);
  417. }
  418. private void ma_code_UserControlTextChanged(object sender, EventArgs e)
  419. {
  420. if (ma_code.Text.Length > 5)
  421. {
  422. string ErrMessage = "";
  423. if (LogicHandler.CheckMakeStatus(ma_code.Text, out ErrMessage))
  424. {
  425. mcd_inqty.Text = "";
  426. mcd_remainqty.Text = "";
  427. sql.Clear();
  428. sql.Append("select mcd_inqty,ma_qty-mcd_inqty mcd_remainqty ");
  429. sql.Append("from make left join makecraftdetail_view on mcd_macode=ma_code where ");
  430. sql.Append("ma_code='" + ma_code.Text + "' and mcd_stepcode='" + User.CurrentStepCode + "'");
  431. DataTable dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
  432. if (dt.Rows.Count > 0)
  433. BaseUtil.SetFormValue(Controls, dt);
  434. }
  435. }
  436. }
  437. private void ma_prodcode_TextChanged(object sender, EventArgs e)
  438. {
  439. DataTable _dt = (DataTable)dh.ExecuteSql("select la_id,la_url,la_isdefault from label where la_prodcode='" + ma_prodcode.Text + "' and la_templatetype='中箱标' and la_statuscode='AUDITED' order by la_isdefault", "select");
  440. PrintLabel.DataSource = _dt;
  441. PrintLabel.DisplayMember = "la_url";
  442. PrintLabel.ValueMember = "la_id";
  443. code.Str = ma_prodcode.Text;
  444. }
  445. private void PrintLabel_SelectedIndexChanged(object sender, EventArgs e)
  446. {
  447. if (PrintLabel.SelectedValue != null && PrintLabel.SelectedValue.ToString() != "System.Data.DataRowView")
  448. {
  449. string PrintNums = dh.getFieldDataByCondition("label", "la_printnos", "la_id='" + PrintLabel.SelectedValue.ToString() + "'").ToString();
  450. PrintNum.Text = (PrintNums == "" ? "1" : PrintNums);
  451. }
  452. }
  453. Thread thread;
  454. SerialPort serialPort1 = new SerialPort();
  455. //称量的标准重量
  456. Double Weight;
  457. //最大重量
  458. Double MaxWeight;
  459. //最小重量
  460. Double MinWeight;
  461. //是否通过串口获取数据
  462. bool GetData = true;
  463. Regex re = new Regex("\\d+.\\W+");
  464. private void StartWeight_Click(object sender, EventArgs e)
  465. {
  466. thread = new Thread(getSerialData);
  467. try
  468. {
  469. serialPort1.PortName = ComList.Text;
  470. serialPort1.BaudRate = int.Parse(BaudRate.Text);
  471. serialPort1.Open();
  472. GetData = true;
  473. thread.Start();
  474. }
  475. catch (Exception mes)
  476. {
  477. if (BaudRate.Text == "" || ComList.Text == "")
  478. OperateResult.AppendText(">>请先在电子秤调试界面维护波特率和串口\n", Color.Red);
  479. else
  480. OperateResult.AppendText(">>" + mes.Message + "\n", Color.Red);
  481. }
  482. }
  483. private void StopWeight_Click(object sender, EventArgs e)
  484. {
  485. if (serialPort1.IsOpen)
  486. {
  487. GetData = false;
  488. serialPort1.Close();
  489. SystemInf.OpenPort.Remove(serialPort1.PortName);
  490. thread.Abort();
  491. }
  492. }
  493. private void getSerialData()
  494. {
  495. if (serialPort1.IsOpen)
  496. {
  497. if (!SystemInf.OpenPort.Contains(serialPort1.PortName))
  498. {
  499. SystemInf.OpenPort.Add(serialPort1.PortName);
  500. try
  501. {
  502. while (GetData)
  503. {
  504. try
  505. {
  506. int len = serialPort1.BytesToRead;
  507. Byte[] readBuffer = new Byte[len];
  508. serialPort1.Read(readBuffer, 0, len); //将数据读入缓存
  509. string weigh = Encoding.Default.GetString(readBuffer);
  510. if (weigh != "")
  511. {
  512. weight.Text = re.Match(weigh).Value;
  513. }
  514. }
  515. catch (Exception)
  516. {
  517. GetData = false;
  518. }
  519. }
  520. }
  521. catch (IOException ex) { MessageBox.Show(ex.Message); }
  522. }
  523. else OperateResult.AppendText(">>端口已被占用,请关闭其他窗口\n", Color.Red);
  524. }
  525. }
  526. }
  527. }