Make_SNLabelCheckMidBoxNoWeight.cs 31 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574
  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_SNLabelCheckMidBoxNoWeight : 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_SNLabelCheckMidBoxNoWeight()
  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. //如果称重到了50个,则重量信息重新自动设置到产品信息
  243. int weight_count = dh.getRowCount("makeserial", " ms_makecode='" + ma_code.Text + "' and ms_midboxweight is not null");
  244. if (weight_count == 50)
  245. {
  246. double pr_miderror = double.Parse(dh.getFieldDataByCondition("product", "nvl(pr_miderror,0)", "pr_code='" + ma_prodcode.Text + "'").ToString());
  247. double avgweight = double.Parse(dh.getFieldDataByCondition("makeserial", "sum(ms_midboxweight)/50", " ms_makecode='" + ma_code.Text + "' and ms_outboxcode is not null").ToString());
  248. dh.ExecuteSql("update product set PR_MIDBOXMINWEIGHT=(" + avgweight + "-" + pr_miderror + "), PR_MIDBOXMAXWEIGHT=(" + avgweight + "+" + pr_miderror + ") where pr_code=v_ms_prodcode", "update");
  249. }
  250. sql.Clear();
  251. sql.Append("insert into labelchecklog(LCL_ID, LCL_SN, LCL_LABELTYPE, lcl_prefix,lcl_length, LCL_LABELVALUE, LCL_STEPCODE, LCL_SOURCECODE," +
  252. " LCL_INMAN, LCL_DATE)" +
  253. "select labelchecklog_seq.nextval,'" + sn_code.Text + "',:LCL_LABELTYPE,:lcl_prefix,:lcl_length,:LCL_LABELVALUE,'" + User.CurrentStepCode + "'" +
  254. ",'" + User.UserSourceCode + "','" + User.UserCode + "',sysdate from dual");
  255. dh.BatchInsert(sql.GetString(), new string[] { "LCL_LABELTYPE", "lcl_prefix", "lcl_length", "LCL_LABELVALUE" },
  256. labeltype_list.ToArray(), prefix_list.ToArray(), length_list.ToArray(), value.ToArray());
  257. LogicHandler.DoCommandLog(Tag.ToString(), User.UserCode, oMakeCode, User.UserLineCode, User.UserSourceCode, "上料采集", "上料成功", sn_code.Text, "");
  258. 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))
  259. {
  260. OperateResult.AppendText(ErrorMessage + "\n", Color.Red);
  261. }
  262. if (PrintSecond.Checked)
  263. {
  264. if (Print.BarTender(Tag.ToString(), ref engine, PrintLabel1.Text, PrintLabel1.SelectedValue.ToString(), PrintList1.Text, sn_code.Text, int.Parse(PrintNum1.Text), oMakeCode, ma_prodcode.Text, "中箱标", "0", out ErrorMessage))
  265. {
  266. OperateResult.AppendText(">>序列号:" + sn_code.Text + "打印结束\n", Color.Green);
  267. }
  268. else
  269. {
  270. OperateResult.AppendText(ErrorMessage + "\n", Color.Red);
  271. }
  272. }
  273. if (!LogicHandler.SetStepResult(ma_code.Text, User.UserSourceCode, sn_code.Text, "标签核对", "标签核对完成", User.UserCode, out ErrorMessage))
  274. {
  275. OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red, code);
  276. return;
  277. }
  278. OperateResult.AppendText(">>校验完成\n", Color.Green, code);
  279. sn_code.Text = "";
  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 PR_MIDBOXMINWEIGHT, PR_MIDBOXMAXWEIGHT,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. string _maxweight = dt.Rows[0]["PR_MIDBOXMAXWEIGHT"].ToString();
  361. string _minweight = dt.Rows[0]["PR_MIDBOXMINWEIGHT"].ToString();
  362. ms_id = dt.Rows[0]["ms_id"].ToString();
  363. make_code = dt.Rows[0]["ma_code"].ToString();
  364. mabomversion = dt.Rows[0]["ma_bomversion"].ToString();
  365. make_prodcode = dt.Rows[0]["ms_prodcode"].ToString();
  366. nextstepcode = dt.Rows[0]["ms_nextstepcode"].ToString();
  367. ms_status = dt.Rows[0]["ms_status"].ToString();
  368. ms_firstsn = dt.Rows[0]["ms_firstsn"].ToString();
  369. MaxWeight = double.Parse(_maxweight == "" ? "0" : _maxweight);
  370. MinWeight = double.Parse(_minweight == "" ? "0" : _minweight);
  371. BaseUtil.SetFormValue(this.Controls, dt);
  372. LockMakeCode.Checked = true;
  373. //勾选了前一工单
  374. 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");
  375. nextstepcode = dt.Rows[0]["ms_nextstepcode"].ToString();
  376. ms_status = dt.Rows[0]["ms_status"].ToString();
  377. sn_code.Text = code.Text;
  378. code.Str = "";
  379. sql.Clear();
  380. sql.Append("select ma_code,ma_softversion,ma_ecncode,ma_prodcode,pr_spec,ma_qty from makeserial left join product ");
  381. sql.Append(" on ms_prodcode=pr_code left join make on ms_makecode=ma_code left join ");
  382. sql.Append("makecraftdetail on mcd_macode=ms_makecode where ms_id='" + oMsid + "' and mcd_stepcode='" + User.CurrentStepCode + "'");
  383. dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
  384. BaseUtil.SetFormValue(this.Controls, dt);
  385. OperateResult.AppendText(">>获取序列号" + code.Text + "成功\n", Color.Green);
  386. GetItem();
  387. }
  388. else
  389. {
  390. OperateResult.AppendText(">>序列号" + code.Text + "不存在\n", Color.Red, code);
  391. code.Text = "";
  392. sn_code.Text = "";
  393. code.Str = ma_prodcode.Text;
  394. }
  395. }
  396. else OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red, code);
  397. }
  398. private void GetItem()
  399. {
  400. 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 " +
  401. "on lcd_lcid=lc_id where lc_prodcode='" + ma_prodcode.Text + "' and lcd_stepcode='" + User.CurrentStepCode + "' order by lcd_detno", "select");
  402. if (dt1.Rows.Count == 0)
  403. {
  404. OperateResult.AppendText(">>序列号" + code.Text + "未设置核对类型,或者已核对完成\n", Color.Red, code);
  405. sn_code.Clear();
  406. code.Str = ma_prodcode.Text;
  407. }
  408. BaseUtil.FillDgvWithDataTable(LabelDataGridView, dt1);
  409. }
  410. private void ClearSn_code_Click(object sender, EventArgs e)
  411. {
  412. sn_code.Clear();
  413. CheckBarcode.Clear();
  414. code.Str = ma_prodcode.Text;
  415. if (dt1 != null)
  416. BaseUtil.CleanDataTableData(dt1);
  417. RemainIndex = 0;
  418. BaseUtil.CleanDGVData(LabelDataGridView);
  419. OperateResult.AppendText(">>请采集序列号\n", Color.Black);
  420. }
  421. private void ma_code_UserControlTextChanged(object sender, EventArgs e)
  422. {
  423. if (ma_code.Text.Length > 5)
  424. {
  425. string ErrMessage = "";
  426. if (LogicHandler.CheckMakeStatus(ma_code.Text, out ErrMessage))
  427. {
  428. mcd_inqty.Text = "";
  429. mcd_remainqty.Text = "";
  430. sql.Clear();
  431. sql.Append("select mcd_inqty,ma_qty-mcd_inqty mcd_remainqty ");
  432. sql.Append("from make left join makecraftdetail_view on mcd_macode=ma_code where ");
  433. sql.Append("ma_code='" + ma_code.Text + "' and mcd_stepcode='" + User.CurrentStepCode + "'");
  434. DataTable dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
  435. if (dt.Rows.Count > 0)
  436. BaseUtil.SetFormValue(Controls, dt);
  437. }
  438. }
  439. }
  440. private void ma_prodcode_TextChanged(object sender, EventArgs e)
  441. {
  442. 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");
  443. PrintLabel.DataSource = _dt;
  444. PrintLabel.DisplayMember = "la_url";
  445. PrintLabel.ValueMember = "la_id";
  446. PrintLabel1.DataSource = _dt.Copy();
  447. PrintLabel1.DisplayMember = "la_url";
  448. PrintLabel1.ValueMember = "la_id";
  449. code.Str = ma_prodcode.Text;
  450. }
  451. private void PrintLabel_SelectedIndexChanged(object sender, EventArgs e)
  452. {
  453. if (PrintLabel.SelectedValue != null && PrintLabel.SelectedValue.ToString() != "System.Data.DataRowView")
  454. {
  455. string PrintNums = dh.getFieldDataByCondition("label", "la_printnos", "la_id='" + PrintLabel.SelectedValue.ToString() + "'").ToString();
  456. PrintNum.Text = (PrintNums == "" ? "1" : PrintNums);
  457. }
  458. }
  459. Thread thread;
  460. SerialPort serialPort1 = new SerialPort();
  461. //称量的标准重量
  462. Double Weight;
  463. //最大重量
  464. Double MaxWeight;
  465. //最小重量
  466. Double MinWeight;
  467. //是否通过串口获取数据
  468. bool GetData = true;
  469. Regex re = new Regex("\\d+.\\d+");
  470. private void StartWeight_Click(object sender, EventArgs e)
  471. {
  472. thread = new Thread(getSerialData);
  473. try
  474. {
  475. serialPort1.PortName = ComList.Text;
  476. serialPort1.BaudRate = int.Parse(BaudRate.Text);
  477. serialPort1.Open();
  478. GetData = true;
  479. thread.Start();
  480. }
  481. catch (Exception mes)
  482. {
  483. if (BaudRate.Text == "" || ComList.Text == "")
  484. OperateResult.AppendText(">>请先在电子秤调试界面维护波特率和串口\n", Color.Red);
  485. else
  486. OperateResult.AppendText(">>" + mes.Message + "\n", Color.Red);
  487. }
  488. }
  489. private void StopWeight_Click(object sender, EventArgs e)
  490. {
  491. if (serialPort1.IsOpen)
  492. {
  493. GetData = false;
  494. serialPort1.Close();
  495. SystemInf.OpenPort.Remove(serialPort1.PortName);
  496. thread.Abort();
  497. }
  498. }
  499. private void getSerialData()
  500. {
  501. if (serialPort1.IsOpen)
  502. {
  503. if (!SystemInf.OpenPort.Contains(serialPort1.PortName))
  504. {
  505. SystemInf.OpenPort.Add(serialPort1.PortName);
  506. try
  507. {
  508. while (GetData)
  509. {
  510. try
  511. {
  512. int len = serialPort1.BytesToRead;
  513. Byte[] readBuffer = new Byte[len];
  514. serialPort1.Read(readBuffer, 0, len); //将数据读入缓存
  515. string weigh = Encoding.Default.GetString(readBuffer);
  516. if (weigh != "")
  517. {
  518. }
  519. }
  520. catch (Exception)
  521. {
  522. GetData = false;
  523. }
  524. }
  525. }
  526. catch (IOException ex) { MessageBox.Show(ex.Message); }
  527. }
  528. else OperateResult.AppendText(">>端口已被占用,请关闭其他窗口\n", Color.Red);
  529. }
  530. }
  531. private void StepCount_Load(object sender, EventArgs e)
  532. {
  533. }
  534. }
  535. }