Make_TestCollectionqrcode2.cs 27 KB

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