Make_TestCollectionqrcode2.cs 27 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609
  1. using System;
  2. using System.Data;
  3. using System.Text;
  4. using System.Threading;
  5. using System.Drawing;
  6. using System.Windows.Forms;
  7. using UAS_MES_NEW.DataOperate;
  8. using UAS_MES_NEW.Entity;
  9. using UAS_MES_NEW.PublicMethod;
  10. using System.Collections.Generic;
  11. using UAS_MES_NEW.CustomControl.PowerControlForm;
  12. using System.Xml;
  13. using System.IO;
  14. using ExcelHelper;
  15. using NPOI.SS.UserModel;
  16. using NPOI.HSSF.UserModel;
  17. using NPOI.SS.Formula.Eval;
  18. using NPOI.HSSF.Util;
  19. using NPOI.SS.Util;
  20. using LabelManager2;
  21. using System.Diagnostics;
  22. using UAS_MES_NEW.PublicForm;
  23. using System.Security.Cryptography;
  24. namespace UAS_MES_NEW.Make
  25. {
  26. public partial class Make_TestCollectionqrcode2 : Form
  27. {
  28. DataHelper dh = null;
  29. DataTable dt = null;
  30. //当前工序的名称
  31. string ErrorMessage = "";
  32. //用于保存是否之前输入的ms_sncode
  33. string LastSncode;
  34. string oMakeCode = "";
  35. string oMSID = "";
  36. string ifrework = "";
  37. string reworkstatus = "";
  38. LogStringBuilder sql = new LogStringBuilder();
  39. AutoSizeFormClass asc = new AutoSizeFormClass();
  40. /// <summary>
  41. /// 已选的不良
  42. /// </summary>
  43. List<string> ChoosedList = new List<string>();
  44. /// <summary>
  45. /// 待选的不良
  46. /// </summary>
  47. List<string> WaitList = new List<string>();
  48. bool AutoCut = false;
  49. bool LockSn = false;
  50. DataTable Dbfind;
  51. Thread InitPrint;
  52. ApplicationClass lbl;
  53. public BarTender.Application engine;
  54. public Make_TestCollectionqrcode2()
  55. {
  56. InitializeComponent();
  57. }
  58. private void TestCollection_Load(object sender, EventArgs e)
  59. {
  60. GoodProduct.Checked = true;
  61. asc.controllInitializeSize(this);
  62. ms_sncode.Focus();
  63. Process[] processes = System.Diagnostics.Process.GetProcessesByName("lppa");
  64. Process[] processes1 = System.Diagnostics.Process.GetProcessesByName("bartend");
  65. for (int i = 0; i < processes1.Length; i++)
  66. {
  67. processes1[i].Kill();
  68. }
  69. for (int i = 0; i < processes.Length; i++)
  70. {
  71. processes[i].Kill();
  72. }
  73. InitPrint = new Thread(InPrint);
  74. SetLoadingWindow stw = new SetLoadingWindow(InitPrint, "初始化打印程序");
  75. BaseUtil.SetFormCenter(stw);
  76. stw.ShowDialog();
  77. //设置锁定工单
  78. LockMakeCode.GetMakeCodeCtl(ma_code);
  79. ma_code.SetLockCheckBox(LockMakeCode);
  80. ControlLockTimer.Tick += ControlLockTimer_Tick;
  81. ControlLockTimer.Interval = 100;
  82. //lockCheckBox1.GetMakeCodeCtl(US_ID);
  83. //US_ID.SetLockCheckBox(lockCheckBox1);
  84. //US_ID.TableName = "upcsku";
  85. //US_ID.SelectField = "US_ID # ID,US_PRODUCTCOLOR # PRODUCT_COLOR,US_COLORCODE # 颜色号,US_SKU # SKU,US_UPC # UPC,US_LOCATION # 出货地";
  86. //US_ID.FormName = Name;
  87. //US_ID.SetValueField = new string[] { "US_ID","US_SKU", "US_PRODUCTCOLOR", "US_COLORCODE", "US_UPC","US_LOCATION" };
  88. //US_ID.Condition = "1=1";
  89. //US_ID.DbChange += US_SKU_DbChange;
  90. //工单号放大镜配置
  91. ma_code.TableName = "make left join product on ma_prodcode=pr_code";
  92. ma_code.SelectField = "ma_code # 工单号,ma_prodcode # 产品编号,ma_qty # 工单数量,pr_spec # 产品规格,ma_softversion # 软件版本,ma_appversion # APP版本,ma_rom # ROM ,ma_ram # RAM,ma_salecode # 销售单号,pr_sendchecktype # 产品送检方式";
  93. ma_code.FormName = Name;
  94. ma_code.SetValueField = new string[] { "ma_code", "ma_prodcode", "ma_qty", "pr_spec", "ma_softversion", "ma_appversion", "ma_rom", "ma_ram", "ma_salecode", "nvl(pr_sendchecktype,'LineCode')pr_sendchecktype" };
  95. ma_code.Condition = "ma_statuscode='STARTED'";
  96. ma_code.DbChange += Ma_code_DbChange;
  97. dh = SystemInf.dh;
  98. StepCount.StepCode = User.CurrentStepCode;
  99. StepCount.Source = User.UserSourceCode;
  100. StepCount.LineCode = User.UserLineCode;
  101. StepCount.Dh = dh;
  102. StepCount.Start();
  103. }
  104. private void US_SKU_DbChange(object sender, EventArgs e)
  105. {
  106. //Dbfind = US_ID.ReturnData;
  107. //BaseUtil.SetFormValue(this.Controls, Dbfind);
  108. }
  109. private void InPrint()
  110. {
  111. try
  112. {
  113. engine = new BarTender.Application();
  114. lbl = new ApplicationClass();
  115. BaseUtil.WriteLbl();
  116. }
  117. catch (Exception ex)
  118. {
  119. OperateResult.AppendText("未正确安装CodeSoft软件\n", Color.Red);
  120. }
  121. }
  122. private void ControlLockTimer_Tick(object sender, EventArgs e)
  123. {
  124. this.Activate();
  125. ms_sncode.Focus();
  126. }
  127. private void Ma_code_DbChange(object sender, EventArgs e)
  128. {
  129. Dbfind = ma_code.ReturnData;
  130. BaseUtil.SetFormValue(this.Controls, Dbfind);
  131. LoadCollectedNum();
  132. }
  133. private void CleanInfo_Click(object sender, EventArgs e)
  134. {
  135. OperateResult.Clear();
  136. }
  137. private void ms_code_KeyDown(object sender, KeyEventArgs e)
  138. {
  139. if (e.KeyCode == Keys.Enter)
  140. {
  141. string softversion = "";
  142. string othid = "";
  143. string appver = "";
  144. string rom = "";
  145. string ram = "";
  146. string mac = "";
  147. string bt = "";
  148. string listmac = "";
  149. string listbt = "";
  150. try
  151. {
  152. String[] message = ms_sncode.Text.Split(';');
  153. if (getframeid.Checked)
  154. {
  155. if (message.Length != 8)
  156. {
  157. OperateResult.AppendText(">>需要采集相框ID,采集二维码解析出"+ message.Length + "个数据,不符合要求\n", Color.Red, ms_sncode);
  158. return;
  159. }
  160. ms_sncode.Text = message[0];
  161. bt = message[2];
  162. mac = message[1];
  163. softversion = message[3];
  164. othid = message[4];
  165. appver = message[5];
  166. rom = message[6];
  167. ram = message[7];
  168. }
  169. else
  170. {
  171. if (message.Length != 7)
  172. {
  173. OperateResult.AppendText(">>不需要采集相框ID,采集二维码解析出" + message.Length + "个数据,不符合要求\n", Color.Red, ms_sncode);
  174. return;
  175. }
  176. ms_sncode.Text = message[0];
  177. bt = message[2];
  178. mac = message[1];
  179. softversion = message[3];
  180. //othid = message[4];
  181. appver = message[4];
  182. rom = message[5];
  183. ram = message[6];
  184. }
  185. DataGridViewRow row = new DataGridViewRow();
  186. row.CreateCells(LabelDataGridView);
  187. row.Cells[0].Value = ms_sncode.Text;
  188. row.Cells[3].Value = softversion;
  189. row.Cells[4].Value = othid;
  190. row.Cells[5].Value = appver;
  191. row.Cells[6].Value = rom;
  192. row.Cells[2].Value = mac;
  193. row.Cells[1].Value = bt;
  194. row.Cells[7].Value = ram;
  195. LabelDataGridView.Rows.Insert(0, row);
  196. //int index = LabelDataGridView.Rows.Add();
  197. //LabelDataGridView.Rows[index].Cells["SN"].Value = ms_sncode.Text;
  198. //LabelDataGridView.Rows[index].Cells["softversion"].Value = softversion;
  199. //LabelDataGridView.Rows[index].Cells["xkid"].Value = othid;
  200. //LabelDataGridView.Rows[index].Cells["mmi1"].Value = mmi1;
  201. //LabelDataGridView.Rows[index].Cells["mmi2"].Value = mmi2;
  202. //LabelDataGridView.Rows[index].Cells["wifis"].Value = mac;
  203. //LabelDataGridView.Rows[index].Cells["bts"].Value = bt;
  204. //LabelDataGridView.Rows[index].Cells["opentime"].Value = opentime;
  205. }
  206. catch (Exception ex)
  207. {
  208. OperateResult.AppendText(">>" + ex.Message + "\n", Color.Red, ms_sncode);
  209. return;
  210. }
  211. WaitList.Clear();
  212. ChoosedList.Clear();
  213. if (LogicHandler.CheckStepAttribute(Tag.ToString(), User.UserSourceCode, out ErrorMessage))
  214. {
  215. bool NoteAlready = LogicHandler.CheckDiffMakeCodeBeforeStepCheck(ms_sncode.Text, ma_code.Text, NoteForChange.Checked, out oMakeCode, out ErrorMessage);
  216. if (!NoteAlready)
  217. {
  218. OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red, ms_sncode);
  219. return;
  220. }
  221. if (LogicHandler.CheckStepSNAndMacode(oMakeCode, User.UserSourceCode, ms_sncode.Text, User.UserCode, out oMakeCode, out oMSID, out ErrorMessage))
  222. {
  223. //是否提示过工单切换框,检测前后执行
  224. if (!LogicHandler.CheckDiffMakeCodeAfterStepCheck(ms_sncode.Text, oMakeCode, NoteForChange.Checked, NoteAlready, ma_code, out ErrorMessage))
  225. {
  226. OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red, ms_sncode);
  227. return;
  228. }
  229. if (ma_code.Text != oMakeCode && oMakeCode != null)
  230. {
  231. dt = (DataTable)dh.ExecuteSql("select ma_code,ma_prodcode,ma_softversion,ma_salecode,pr_spec,nvl(pr_sendchecktype,'LineCode')pr_sendchecktype,ma_qty,ma_appversion,ma_rom,ma_ram from make left join product on ma_prodcode=pr_code where ma_code='" + oMakeCode + "'", "select");
  232. if (dt.Rows.Count > 0)
  233. {
  234. BaseUtil.SetFormValue(this.Controls, dt);
  235. LockMakeCode.Checked = true;
  236. }
  237. }
  238. dt = (DataTable)dh.ExecuteSql("select ms_nextstepcode,ms_sncode,ms_reworkstatus,nvl(ms_ifrework,0)ms_ifrework,ms_stepcode,ms_status,nvl(ms_netcode,' ') ms_netcode,nvl(st_ifrepair,0) st_ifrepair from makeserial left join step on ms_stepcode=st_code where ms_id='" + oMSID + "'", "select");
  239. string status = dt.Rows[0]["ms_status"].ToString();
  240. reworkstatus = dt.Rows[0]["ms_reworkstatus"].ToString();
  241. string stepcode = dt.Rows[0]["ms_stepcode"].ToString();
  242. string ifrepair = dt.Rows[0]["st_ifrepair"].ToString();
  243. string sncode = dt.Rows[0]["ms_sncode"].ToString();
  244. string ms_netcode = dt.Rows[0]["ms_netcode"].ToString();
  245. string ms_nextstepcode = dt.Rows[0]["ms_nextstepcode"].ToString();
  246. //if (ms_netcode != " " && dh.CheckExist("makeserial", "ms_netcode = '" + ms_netcode + "' and ms_sncode <>'" + ms_sncode.Text + "'"))
  247. //{
  248. // string othersn = dh.getFieldDataByCondition("makeserial", "ms_sncode", "ms_netcode = '" + ms_netcode + "' and ms_sncode <>'" + ms_sncode.Text + "'").ToString();
  249. // OperateResult.AppendText(">>" + ms_sncode.Text + "对应wifibox:"+ms_netcode+"已被SN:"+othersn+"使用\n", Color.Red, ms_sncode);
  250. // return;
  251. //}
  252. if (sncode != ms_sncode.Text)
  253. {
  254. OperateResult.AppendText(">>" + ms_sncode.Text + " 序列号已执行过转号,不允许使用TSN采集\n", Color.Red, ms_sncode);
  255. return;
  256. }
  257. ifrework = dt.Rows[0]["ms_ifrework"].ToString();
  258. //string softversioncheck = dh.GetConfig("softversion", "sys").ToString();
  259. if (softversion != ma_softversion.Text )
  260. {
  261. OperateResult.AppendText("<<序列号:" + ms_sncode.Text + "对应软件版本:" + softversion + "与工单维护软件版本:" + ma_softversion.Text + "不一致\n", Color.Red);
  262. return;
  263. }
  264. if (appver != ma_appversion.Text)
  265. {
  266. OperateResult.AppendText("<<序列号:" + ms_sncode.Text + "对应APP版本:" + appver + "与工单维护APP版本:" + ma_appversion.Text + "不一致\n", Color.Red);
  267. return;
  268. }
  269. if (rom != ma_rom.Text)
  270. {
  271. OperateResult.AppendText("<<序列号:" + ms_sncode.Text + "对应ROM:" + rom + "与工单维护ROM:" + ma_rom.Text + "不一致\n", Color.Red);
  272. return;
  273. }
  274. if (ram != ma_ram.Text)
  275. {
  276. OperateResult.AppendText("<<序列号:" + ms_sncode.Text + "对应RAM:" + ram + "与工单维护RAM:" + ma_ram.Text + "不一致\n", Color.Red);
  277. return;
  278. }
  279. //if (!mmi1.Contains("PASS") || !mmi2.Contains("PASS"))
  280. //{
  281. // OperateResult.AppendText("<<序列号:" + ms_sncode.Text + "未通过MMI测试\n", Color.Red);
  282. // return;
  283. //}
  284. //if (dh.CheckExist("product", "pr_code = '" + ma_prodcode.Text + "' and pr_length = -1 ") && mmi1.Contains("UNKNOWN"))
  285. //{
  286. // OperateResult.AppendText("<<序列号:" + ms_sncode.Text + " MMI1信息异常\n", Color.Red);
  287. // return;
  288. //}
  289. //if (dh.CheckExist("product", "pr_code = '" + ma_prodcode.Text + "' and pr_width = -1 ") && mmi2.Contains("UNKNOWN"))
  290. //{
  291. // OperateResult.AppendText("<<序列号:" + ms_sncode.Text + " MMI2信息异常\n", Color.Red);
  292. // return;
  293. //}
  294. if (dh.CheckExist("product", "pr_code = '" + ma_prodcode.Text + "' and pr_volume = -1 ") && bt.Contains("UNKNOWN"))
  295. {
  296. OperateResult.AppendText("<<序列号:" + ms_sncode.Text + " BT信息异常\n", Color.Red);
  297. return;
  298. }
  299. if (dh.CheckExist("product", "pr_code = '" + ma_prodcode.Text + "' and pr_height = -1 ") && mac.Contains("UNKNOWN"))
  300. {
  301. OperateResult.AppendText("<<序列号:" + ms_sncode.Text + " WIFI信息异常\n", Color.Red);
  302. return;
  303. }
  304. if (dh.CheckExist("product", "pr_code = '" + ma_prodcode.Text + "' and pr_palletheight = -1 ") && othid.Contains("UNKNOWN"))
  305. {
  306. OperateResult.AppendText("<<序列号:" + ms_sncode.Text + " 相框ID信息异常\n", Color.Red);
  307. return;
  308. }
  309. listmac = dh.getFieldDataByCondition("makesnlist", "msl_mac", "msl_sncode ='" + ms_sncode.Text + "' and msl_makecode = '"+ma_code.Text+"'").ToString();
  310. if (listmac != "" && listmac != mac.ToUpper())
  311. {
  312. OperateResult.AppendText("<<序列号:" + ms_sncode.Text + " 导入WIFI为:"+listmac+",与二维码mac:"+mac+"不一致\n", Color.Red);
  313. return;
  314. }
  315. listbt = dh.getFieldDataByCondition("makesnlist", "msl_bt", "msl_sncode ='" + ms_sncode.Text + "' and msl_makecode = '" + ma_code.Text + "'").ToString();
  316. if (listbt != "" && listbt != bt.ToUpper())
  317. {
  318. OperateResult.AppendText("<<序列号:" + ms_sncode.Text + " 导入BT为:" + listbt + ",与二维码BT:" + bt + "不一致\n", Color.Red);
  319. return;
  320. }
  321. dh.ExecuteSql("update makeserial set MS_SOFTVERSION = '" + softversion + "',ms_othid1 = '" + othid + "'," +
  322. "ms_mac = '" + mac + "',ms_bt = '" + bt + "',ms_appver = '"+appver+"' where ms_sncode = '" + ms_sncode.Text + "' and ms_makecode = '" + ma_code.Text + "'", "update");
  323. //if (US_SKU.Text != "")
  324. //{
  325. // dh.ExecuteSql("update makeserial set ms_sku = '" + US_SKU.Text + "' where ms_sncode = '" + ms_sncode.Text + "' and ms_makecode = '" + ma_code.Text + "'", "update");
  326. //}
  327. //if (US_UPC.Text != "")
  328. //{
  329. // dh.ExecuteSql("update makeserial set ms_upc = '" + US_UPC.Text + "' where ms_sncode = '" + ms_sncode.Text + "' and ms_makecode = '" + ma_code.Text + "'", "update");
  330. //}
  331. //if (US_LOCATION.Text != "")
  332. //{
  333. // dh.ExecuteSql("update makeserial set MS_location = '" + US_LOCATION.Text + "' where ms_sncode = '" + ms_sncode.Text + "' and ms_makecode = '" + ma_code.Text + "'", "update");
  334. //}
  335. if (autoprint.Checked)
  336. {
  337. if (PrintLabel.Text.ToUpper().Contains(".BTW"))
  338. {
  339. if (Print.SinglePrint(Tag.ToString(), engine, PrintLabel.Text, PrintLabel.SelectedValue.ToString(), Printer.Text, ms_sncode.Text, int.Parse(PrintNum.Text), oMakeCode, ma_prodcode.Text, "机身标", "0", out ErrorMessage))
  340. {
  341. //提示用户打印成功
  342. OperateResult.AppendText(">>序列号:" + ms_sncode.Text + "打印成功\n", Color.Green);
  343. }
  344. else
  345. {
  346. OperateResult.AppendText(ErrorMessage + "\n", Color.Red);
  347. }
  348. }
  349. else
  350. {
  351. if (Print.CodeSoft(Tag.ToString(), ref lbl, PrintLabel.Text, PrintLabel.SelectedValue.ToString(), Printer.Text, ms_sncode.Text, int.Parse(PrintNum.Text), oMakeCode, ma_prodcode.Text, "机身标", "0", out ErrorMessage))
  352. {
  353. //提示用户打印成功
  354. OperateResult.AppendText(">>序列号:" + ms_sncode.Text + "打印成功\n", Color.Green);
  355. }
  356. else
  357. {
  358. OperateResult.AppendText(ErrorMessage + "\n", Color.Red);
  359. }
  360. }
  361. }
  362. SetCollectResult();
  363. }
  364. else OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red, ms_sncode);
  365. }
  366. else OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red, ms_sncode);
  367. }
  368. }
  369. /// <summary>
  370. /// 设置良品或者不良品的采集结果
  371. /// </summary>
  372. private void SetCollectResult()
  373. {
  374. string ErrorMessage = "";
  375. //如果勾选的是不良品
  376. if (Reject.Checked)
  377. {
  378. OperateResult.AppendText(">>请采集不良代码\n", Color.Green);
  379. //勾选了自动产生代码
  380. if (AutoBadCode.Checked)
  381. Save_Click(new object(), new EventArgs());
  382. }
  383. else if (GoodProduct.Checked)
  384. {
  385. //如果不是返修的
  386. if (ifrework == "0")
  387. {
  388. dt = (DataTable)dh.ExecuteSql("select mb_id,bc_name,mbr_mbid from makebad left join makebadreason on mbr_mbid=mb_id left join badcode on mb_badcode=bc_code where mb_sncode='" + ms_sncode.Text + "' and mb_makecode='" + ma_code.Text + "' and mb_status=0", "select");
  389. for (int i = 0; i < dt.Rows.Count; i++)
  390. {
  391. if (dt.Rows[i]["mb_id"].ToString() != dt.Rows[i]["mbr_mbid"].ToString())
  392. ErrorMessage += "【" + dt.Rows[i]["bc_name"].ToString() + "】";
  393. }
  394. //存在不良记录
  395. if (ErrorMessage != "")
  396. {
  397. OperateResult.AppendText(">>序列号:" + ms_sncode.Text + " 已经判为不良品,不允许修改!\n", Color.Red);
  398. return;
  399. }
  400. else
  401. {
  402. //良品信息采集
  403. if (LogicHandler.SetStepResult(ma_code.Text, User.UserSourceCode, ms_sncode.Text, "良品采集", "检测合格", User.UserCode, out ErrorMessage))
  404. {
  405. //提示正确返回时传递的信息
  406. if (ErrorMessage.Contains("AFTERSUCCESS"))
  407. OperateResult.AppendText(">>" + ErrorMessage + "\n");
  408. LastSncode = ms_sncode.Text;
  409. OperateResult.AppendText(">>" + ms_sncode.Text + "良品采集成功\n", Color.Green, ms_sncode);
  410. //记录操作日志
  411. LogicHandler.DoCommandLog(Tag.ToString(), User.UserCode, ma_code.Text, User.UserLineCode, User.UserSourceCode, "采集良品", "采集良品成功", LastSncode, ob_checkno.Text);
  412. }
  413. else OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red, ms_sncode);
  414. }
  415. }
  416. else
  417. {
  418. if (reworkstatus != "3")
  419. {
  420. if (LogicHandler.SetStepResult(ma_code.Text, User.UserSourceCode, ms_sncode.Text, "良品采集", "检测合格", User.UserCode, out ErrorMessage))
  421. {
  422. //提示正确返回时传递的信息
  423. if (ErrorMessage.Contains("AFTERSUCCESS"))
  424. OperateResult.AppendText(">>" + ErrorMessage + "\n");
  425. LastSncode = ms_sncode.Text;
  426. OperateResult.AppendText(">>" + ms_sncode.Text + "成功采集为良品\n", Color.Green, ms_sncode);
  427. //记录操作日志
  428. LogicHandler.DoCommandLog(Tag.ToString(), User.UserCode, ma_code.Text, User.UserLineCode, User.UserSourceCode, "采集良品", "采集良品成功", LastSncode, ob_checkno.Text);
  429. }
  430. else OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red, ms_sncode);
  431. }
  432. else
  433. {
  434. OperateResult.AppendText(">>返修的不良序列号必须先进行维修\n", Color.Red);
  435. }
  436. }
  437. }
  438. //加载页面信息
  439. LoadCollectedNum();
  440. }
  441. private void 测试采集_SizeChanged(object sender, EventArgs e)
  442. {
  443. asc.controlAutoSize(this);
  444. }
  445. private void LoadCollectedNum()
  446. {
  447. dt = (DataTable)dh.ExecuteSql("select mcd_inqty,ma_qty-mcd_inqty mcd_remainqty from make left join makecraftdetail on mcd_macode=ma_code where ma_code='" + ma_code.Text + "' and mcd_stepcode='" + User.CurrentStepCode + "'", "select");
  448. BaseUtil.SetFormValue(Controls, dt);
  449. }
  450. private void Save_Click(object sender, EventArgs e)
  451. {
  452. if (ms_sncode.Text == "")
  453. {
  454. OperateResult.AppendText(">>序列号不允许为空\n", Color.Red);
  455. return;
  456. }
  457. if (GoodProduct.Checked)
  458. ms_code_KeyDown(sender, new KeyEventArgs(Keys.Enter));
  459. }
  460. private void GoodProduct_CheckedChanged(object sender, EventArgs e)
  461. {
  462. if (GoodProduct.Checked)
  463. {
  464. Save.Visible = false;
  465. }
  466. else
  467. {
  468. Save.Visible = true;
  469. }
  470. if (ms_sncode.Text == "")
  471. {
  472. ms_sncode.Focus();
  473. }
  474. }
  475. /// <summary>
  476. /// 工单变化修改数量
  477. /// </summary>
  478. /// <param name="sender"></param>
  479. /// <param name="e"></param>
  480. private void ma_code_UserControlTextChanged(object sender, EventArgs e)
  481. {
  482. if (ma_code.Text.Length > 4)
  483. {
  484. BaseUtil.CleanControlsText(mcd_inqty, mcd_remainqty, ob_nowcheckqty);
  485. LoadCollectedNum();
  486. //LoadCheckQTY();
  487. }
  488. }
  489. private void Make_TestCollection_FormClosing(object sender, FormClosingEventArgs e)
  490. {
  491. BaseUtil.ClosePrint(lbl);
  492. if (engine != null)
  493. engine.Quit(BarTender.BtSaveOptions.btDoNotSaveChanges);
  494. dh.Dispose();
  495. }
  496. private void ma_prodcode_TextChanged(object sender, EventArgs e)
  497. {
  498. 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");
  499. if (dt.Rows.Count == 0)
  500. {
  501. return;
  502. }
  503. PrintLabel.DataSource = dt;
  504. PrintLabel.DisplayMember = "la_url";
  505. PrintLabel.ValueMember = "la_id";
  506. }
  507. private void Make_TestCollection_KeyDown(object sender, KeyEventArgs e)
  508. {
  509. if (e.Modifiers == Keys.Control && e.KeyCode == Keys.Q)
  510. {
  511. if (!LockSn)
  512. {
  513. ControlLockTimer.Start();
  514. LockSn = true;
  515. Lock_label.Visible = true;
  516. }
  517. else
  518. {
  519. ControlLockTimer.Stop();
  520. LockSn = false;
  521. Lock_label.Visible = false;
  522. }
  523. }
  524. }
  525. private void button1_Click(object sender, EventArgs e)
  526. {
  527. }
  528. }
  529. }