Make_SNLabelCheckMidBox.cs 32 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579
  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 (PrintSecond.Checked)
  275. {
  276. 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))
  277. {
  278. OperateResult.AppendText(">>序列号:" + sn_code.Text + "打印结束\n", Color.Green);
  279. }
  280. else
  281. {
  282. OperateResult.AppendText(ErrorMessage + "\n", Color.Red);
  283. }
  284. }
  285. if (!LogicHandler.SetStepResult(ma_code.Text, User.UserSourceCode, sn_code.Text, "标签核对", "标签核对完成", User.UserCode, out ErrorMessage))
  286. {
  287. OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red, code);
  288. return;
  289. }
  290. OperateResult.AppendText(">>校验完成\n", Color.Green, code);
  291. }
  292. }
  293. }
  294. //勾选了下料的时候
  295. else if (UnLoading.Checked)
  296. {
  297. if (LogicHandler.CheckStepSNAndMacode(ma_code.Text, User.UserSourceCode, code.Text, User.UserCode, out oMakeCode, out oMsid, out ErrorMessage))
  298. {
  299. sql.Clear();
  300. sql.Append("select ms_firstsn,cm_makecode,cm_craftcode,nvl(cm_status,0)cm_status,cm_id,cm_stepcode,");
  301. sql.Append("ms_makecode,cm_mccode,cm_materialtype from craftmaterial left join makeserial on cm_makecode");
  302. sql.Append("=ms_makecode and cm_sncode=ms_sncode where cm_sncode='" + code.Text + "' and cm_makecode='" + oMakeCode + "'");
  303. sql.Append("and cm_materialtype=1 and cm_stepcode='" + User.CurrentStepCode + "' ");
  304. dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
  305. if (dt.Rows.Count > 0)
  306. {
  307. string ms_macode = dt.Rows[0]["ms_makecode"].ToString();
  308. string ms_firstsn = dt.Rows[0]["ms_firstsn"].ToString();
  309. string cm_stepcode = dt.Rows[0]["cm_stepcode"].ToString();
  310. string cm_mccode = dt.Rows[0]["cm_mccode"].ToString();
  311. string cm_materialtype = dt.Rows[0]["cm_materialtype"].ToString();
  312. string cm_status = dt.Rows[0]["cm_status"].ToString();
  313. string cm_makecode = dt.Rows[0]["cm_makecode"].ToString();
  314. string cm_craftcode = dt.Rows[0]["cm_craftcode"].ToString();
  315. //清除已被使用的序列号
  316. sql.Clear();
  317. sql.Append("update makeserial set ms_nextmacode='' where ms_sncode in(select cm_barcode from craftmaterial where ");
  318. sql.Append("cm_makecode='" + cm_makecode + "' and cm_sncode='" + code.Text + "' and cm_stepcode='" + cm_stepcode + "' and cm_craftcode='" + cm_craftcode + "' ");
  319. sql.Append("and cm_materialtype=1 and nvl(cm_status,0) =0) and ms_nextmacode='" + oMakeCode + "'");
  320. dh.ExecuteSql(sql.GetString(), "update");
  321. sql.Clear();
  322. sql.Append("update makeserial set ms_nextstepcode=ms_stepcode where ms_id='" + ms_id + "'");
  323. dh.ExecuteSql(sql.GetString(), "update");
  324. //进行下料
  325. sql.Clear();
  326. sql.Append("delete from craftmaterial where (cm_sncode in (select sn from makesnrelation where firstsn");
  327. sql.Append("='" + ms_firstsn + "') or cm_sncode = '" + ms_firstsn + "') and cm_makecode = '" + oMakeCode + "' ");
  328. sql.Append("and cm_status = 0 and cm_stepcode='" + User.CurrentStepCode + "' and cm_materialtype=1");
  329. dh.ExecuteSql(sql.GetString(), "delete");
  330. LogicHandler.InsertMakeProcess(ms_macode, code.Text, User.UserSourceCode, "上料采集操作", "下料成功", User.UserCode);
  331. //刷新界面值
  332. sql.Clear();
  333. sql.Append("select mcd_inqty,ma_qty-mcd_inqty mcd_remainqty ");
  334. sql.Append("from make left join makecraftdetail on mcd_macode=ma_code where ");
  335. sql.Append("ma_code='" + oMakeCode + "' and mcd_stepcode='" + User.CurrentStepCode + "'");
  336. dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
  337. BaseUtil.SetFormValue(Controls, dt);
  338. LogicHandler.DoCommandLog(Tag.ToString(), User.UserCode, oMakeCode, User.UserLineCode, User.UserSourceCode, "上料采集", "下料成功", code.Text, "");
  339. OperateResult.AppendText(">>序列号" + code.Text + "下料成功\n", Color.Green, code);
  340. }
  341. else OperateResult.AppendText(">>序列号" + code.Text + "未上料,无需下料\n", Color.Red, code);
  342. }
  343. else OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red, code);
  344. }
  345. }
  346. else OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red, code);
  347. }
  348. }
  349. //获取采集的项目
  350. private void GetCollectItem()
  351. {
  352. if (LogicHandler.CheckStepSNAndMacode(ma_code.Text, User.UserSourceCode, code.Text, User.UserCode, out oMakeCode, out oMsid, out ErrorMessage))
  353. {
  354. nextstepcode = dh.getFieldDataByCondition("makeserial", "ms_nextstepcode", "ms_id='" + oMsid + "'").ToString();
  355. if (nextstepcode != User.CurrentStepCode)
  356. {
  357. string stname = dh.getFieldDataByCondition("step", "st_name", "st_code='" + nextstepcode + "'").ToString();
  358. OperateResult.AppendText("<<序列号:" + code.Text + "下一工序是" + stname + ",不是当前岗位的工序\n", Color.Red, code);
  359. return;
  360. }
  361. //将录入框的值给序列号
  362. sn_code.Text = code.Text;
  363. code.Str = "";
  364. sql.Clear();
  365. 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");
  366. sql.Append(",ms_prodcode,ms_makecode,ms_code,ms_stepname from makeserial left join make on ma_code=ms_makecode ");
  367. sql.Append("left join product on ms_prodcode=pr_code where ms_sncode='" + code.Text + "' order by ms_id desc");
  368. dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
  369. if (dt.Rows.Count > 0)
  370. {
  371. ms_id = dt.Rows[0]["ms_id"].ToString();
  372. make_code = dt.Rows[0]["ma_code"].ToString();
  373. mabomversion = dt.Rows[0]["ma_bomversion"].ToString();
  374. make_prodcode = dt.Rows[0]["ms_prodcode"].ToString();
  375. nextstepcode = dt.Rows[0]["ms_nextstepcode"].ToString();
  376. ms_status = dt.Rows[0]["ms_status"].ToString();
  377. ms_firstsn = dt.Rows[0]["ms_firstsn"].ToString();
  378. BaseUtil.SetFormValue(this.Controls, dt);
  379. LockMakeCode.Checked = true;
  380. //勾选了前一工单
  381. 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");
  382. nextstepcode = dt.Rows[0]["ms_nextstepcode"].ToString();
  383. ms_status = dt.Rows[0]["ms_status"].ToString();
  384. sn_code.Text = code.Text;
  385. code.Str = "";
  386. sql.Clear();
  387. sql.Append("select ma_code,ma_softversion,ma_ecncode,ma_prodcode,pr_spec,ma_qty from makeserial left join product ");
  388. sql.Append(" on ms_prodcode=pr_code left join make on ms_makecode=ma_code left join ");
  389. sql.Append("makecraftdetail on mcd_macode=ms_makecode where ms_id='" + oMsid + "' and mcd_stepcode='" + User.CurrentStepCode + "'");
  390. dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
  391. BaseUtil.SetFormValue(this.Controls, dt);
  392. OperateResult.AppendText(">>获取序列号" + code.Text + "成功\n", Color.Green);
  393. GetItem();
  394. }
  395. else
  396. {
  397. OperateResult.AppendText(">>序列号" + code.Text + "不存在\n", Color.Red, code);
  398. code.Text = "";
  399. sn_code.Text = "";
  400. code.Str = ma_prodcode.Text;
  401. }
  402. }
  403. else OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red, code);
  404. }
  405. private void GetItem()
  406. {
  407. 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 " +
  408. "on lcd_lcid=lc_id where lc_prodcode='" + ma_prodcode.Text + "' and lcd_stepcode='" + User.CurrentStepCode + "' and (LCD_LABELTYPE,lcd_stepcode) not in (select LCL_LABELTYPE,LCL_STEPCODE from labelchecklog where " +
  409. "LCL_SN='" + sn_code.Text + "') order by lcd_detno", "select");
  410. if (dt1.Rows.Count == 0)
  411. {
  412. OperateResult.AppendText(">>序列号" + code.Text + "未设置核对类型,或者已核对完成\n", Color.Red, code);
  413. sn_code.Clear();
  414. code.Str = ma_prodcode.Text;
  415. }
  416. BaseUtil.FillDgvWithDataTable(LabelDataGridView, dt1);
  417. }
  418. private void ClearSn_code_Click(object sender, EventArgs e)
  419. {
  420. sn_code.Clear();
  421. CheckBarcode.Clear();
  422. code.Str = ma_prodcode.Text;
  423. if (dt1 != null)
  424. BaseUtil.CleanDataTableData(dt1);
  425. RemainIndex = 0;
  426. BaseUtil.CleanDGVData(LabelDataGridView);
  427. OperateResult.AppendText(">>请采集序列号\n", Color.Black);
  428. }
  429. private void ma_code_UserControlTextChanged(object sender, EventArgs e)
  430. {
  431. if (ma_code.Text.Length > 5)
  432. {
  433. string ErrMessage = "";
  434. if (LogicHandler.CheckMakeStatus(ma_code.Text, out ErrMessage))
  435. {
  436. mcd_inqty.Text = "";
  437. mcd_remainqty.Text = "";
  438. sql.Clear();
  439. sql.Append("select mcd_inqty,ma_qty-mcd_inqty mcd_remainqty ");
  440. sql.Append("from make left join makecraftdetail_view on mcd_macode=ma_code where ");
  441. sql.Append("ma_code='" + ma_code.Text + "' and mcd_stepcode='" + User.CurrentStepCode + "'");
  442. DataTable dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
  443. if (dt.Rows.Count > 0)
  444. BaseUtil.SetFormValue(Controls, dt);
  445. }
  446. }
  447. }
  448. private void ma_prodcode_TextChanged(object sender, EventArgs e)
  449. {
  450. 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");
  451. PrintLabel.DataSource = _dt;
  452. PrintLabel.DisplayMember = "la_url";
  453. PrintLabel.ValueMember = "la_id";
  454. PrintLabel1.DataSource = _dt.Copy();
  455. PrintLabel1.DisplayMember = "la_url";
  456. PrintLabel1.ValueMember = "la_id";
  457. code.Str = ma_prodcode.Text;
  458. }
  459. private void PrintLabel_SelectedIndexChanged(object sender, EventArgs e)
  460. {
  461. if (PrintLabel.SelectedValue != null && PrintLabel.SelectedValue.ToString() != "System.Data.DataRowView")
  462. {
  463. string PrintNums = dh.getFieldDataByCondition("label", "la_printnos", "la_id='" + PrintLabel.SelectedValue.ToString() + "'").ToString();
  464. PrintNum.Text = (PrintNums == "" ? "1" : PrintNums);
  465. }
  466. }
  467. Thread thread;
  468. SerialPort serialPort1 = new SerialPort();
  469. //称量的标准重量
  470. Double Weight;
  471. //最大重量
  472. Double MaxWeight;
  473. //最小重量
  474. Double MinWeight;
  475. //是否通过串口获取数据
  476. bool GetData = true;
  477. Regex re = new Regex("\\d+.\\W+");
  478. private void StartWeight_Click(object sender, EventArgs e)
  479. {
  480. thread = new Thread(getSerialData);
  481. try
  482. {
  483. serialPort1.PortName = ComList.Text;
  484. serialPort1.BaudRate = int.Parse(BaudRate.Text);
  485. serialPort1.Open();
  486. GetData = true;
  487. thread.Start();
  488. }
  489. catch (Exception mes)
  490. {
  491. if (BaudRate.Text == "" || ComList.Text == "")
  492. OperateResult.AppendText(">>请先在电子秤调试界面维护波特率和串口\n", Color.Red);
  493. else
  494. OperateResult.AppendText(">>" + mes.Message + "\n", Color.Red);
  495. }
  496. }
  497. private void StopWeight_Click(object sender, EventArgs e)
  498. {
  499. if (serialPort1.IsOpen)
  500. {
  501. GetData = false;
  502. serialPort1.Close();
  503. SystemInf.OpenPort.Remove(serialPort1.PortName);
  504. thread.Abort();
  505. }
  506. }
  507. private void getSerialData()
  508. {
  509. if (serialPort1.IsOpen)
  510. {
  511. if (!SystemInf.OpenPort.Contains(serialPort1.PortName))
  512. {
  513. SystemInf.OpenPort.Add(serialPort1.PortName);
  514. try
  515. {
  516. while (GetData)
  517. {
  518. try
  519. {
  520. int len = serialPort1.BytesToRead;
  521. Byte[] readBuffer = new Byte[len];
  522. serialPort1.Read(readBuffer, 0, len); //将数据读入缓存
  523. string weigh = Encoding.Default.GetString(readBuffer);
  524. if (weigh != "")
  525. {
  526. weight.Text = re.Match(weigh).Value;
  527. }
  528. }
  529. catch (Exception)
  530. {
  531. GetData = false;
  532. }
  533. }
  534. }
  535. catch (IOException ex) { MessageBox.Show(ex.Message); }
  536. }
  537. else OperateResult.AppendText(">>端口已被占用,请关闭其他窗口\n", Color.Red);
  538. }
  539. }
  540. private void StepCount_Load(object sender, EventArgs e)
  541. {
  542. }
  543. }
  544. }