Make_SeqProgramTransform.cs 31 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643
  1. using System;
  2. using System.Collections;
  3. using System.Collections.Generic;
  4. using System.ComponentModel;
  5. using System.Data;
  6. using System.Drawing;
  7. using System.Linq;
  8. using System.Text;
  9. using System.Windows.Forms;
  10. using UAS_MES.DataOperate;
  11. using UAS_MES.Entity;
  12. using UAS_MES.PublicMethod;
  13. namespace UAS_MES.Make
  14. {
  15. public partial class Make_SeqProgramTransform : Form
  16. {
  17. AutoSizeFormClass asc = new AutoSizeFormClass();
  18. LogStringBuilder sql = new LogStringBuilder();
  19. DataHelper dh;
  20. //原序列号
  21. string TSN = "";
  22. //转换后序列号
  23. string SN = "";
  24. //错误信息
  25. string errorMessage;
  26. //存放productsnrelation表中的数据
  27. DataTable ListA;
  28. //存放工单信息
  29. DataTable dt;
  30. //存放序列号防呆规则
  31. DataTable rules;
  32. //step 记录检验规则的进度
  33. int step = 0;
  34. //存放关联信息类型
  35. string type;
  36. //存放包含IMEI的规则的值,方便拼接
  37. StringBuilder imei = new StringBuilder();
  38. LogStringBuilder logsql = new LogStringBuilder();
  39. //存放工单中数量
  40. int ma_qty;
  41. //存放所有关联信息的类型和录入的值
  42. Hashtable hs;
  43. string oMakecode = "";
  44. string oMsid = "";
  45. string siid="";//存储TSN对应的sninfo记录id
  46. DataTable macRange;//记录macBT范围
  47. string macOrBt = "";//存储去掉":"或者"-"的mac和bt
  48. string imeif = "";
  49. bool hasSnList = false;//记录是否有转换后SN清单
  50. bool hasMakeRule = false;//记录是否有工单防呆规则
  51. public Make_SeqProgramTransform()
  52. {
  53. InitializeComponent();
  54. }
  55. private void Make_SeqProgramTransform_Load(object sender, EventArgs e)
  56. {
  57. asc.controllInitializeSize(this);
  58. code.Focus();
  59. //提示用户“>>请输入TSN号”
  60. OperateResult.AppendText(">>请输入TSN号\n", Color.Black);
  61. dh = new DataHelper();
  62. }
  63. private void code_KeyDown(object sender, KeyEventArgs e)
  64. {
  65. if (e.KeyCode == Keys.Enter)
  66. {
  67. if (code.Text != "")
  68. {
  69. if (LogicHandler.CheckStepAttribute(Tag.ToString(), User.UserSourceCode, out errorMessage))
  70. {
  71. //为0,输入TSN
  72. if (step == 0)
  73. {
  74. OperateResult.AppendText(">>TSN号" + code.Text + "\n", Color.Black);
  75. if (!ChangeResult.Checked)//不勾选
  76. {
  77. //核对工序
  78. if (!LogicHandler.CheckStepSNAndMacode("", User.UserSourceCode, code.Text, User.UserCode, out oMakecode, out oMsid, out errorMessage))
  79. {
  80. OperateResult.AppendText(">>" + errorMessage + "\n", Color.Red, code);
  81. return;
  82. }
  83. }
  84. else//勾选
  85. {
  86. oMsid = dh.getFieldDataByCondition("makeserial", "max(ms_id)", "ms_sncode in (select '" + code.Text + "' from dual union select sn from makesnrelation where beforesn='" + code.Text + "' and sn<>' ' union select beforesn from makesnrelation where sn='" + code.Text + "' and beforesn<>' ')").ToString();
  87. if (oMsid=="")
  88. {
  89. OperateResult.AppendText("<<TSN号错误\n", Color.Red, code);
  90. return;
  91. }
  92. //根据ms_id查询
  93. sql.Clear();
  94. sql.Append("select ms_stepcode from makeserial where ms_id='" + oMsid+"' and ms_beforesn='"+code.Text+"' and ms_nextmacode is null and ms_outboxcode is null");
  95. dt = (DataTable)dh.ExecuteSql(sql.GetString(),"select");
  96. //如果行数大于0则允许转号
  97. if (dt.Rows.Count > 0)
  98. {
  99. if (dt.Rows[0]["ms_stepcode"].ToString()==User.CurrentStepCode)
  100. {
  101. step = 1;
  102. TSN = code.Text;
  103. //显示序列号
  104. show_sncode.Text = TSN;
  105. ChangeResult.Enabled = false;
  106. }
  107. else
  108. {
  109. OperateResult.AppendText("<<当前工序不允许重新转号\n", Color.Red, code);
  110. return;
  111. }
  112. }
  113. else
  114. {
  115. OperateResult.AppendText("<<TSN号" + code.Text + "当前状态不允许重新转号\n", Color.Red, code);
  116. return;
  117. }
  118. }
  119. //如果用户没有选择工单号
  120. if (ms_macode.Text == "" || ms_macode.Text != oMakecode||ChangeResult.Checked)
  121. {
  122. //按照out出的工单号查出工单相关信息,并赋值到相关控件
  123. sql.Clear();
  124. sql.Append("select ma_code as ms_macode,ma_softversion,mcd_okqty,ma_qty,ma_qty-mcd_inqty as remain_qty,pr_detail,pr_code as ma_prodcode ");
  125. sql.Append("from makeserial left join make on ms_makecode=ma_code left join product on ");
  126. sql.Append("ms_prodcode=pr_code left join makecraftdetail on ms_makecode=mcd_macode where ms_id=:msid and mcd_stepcode='" + User.CurrentStepCode + "'");
  127. dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select", oMsid);
  128. if (dt.Rows.Count > 0)
  129. {
  130. //记录数量
  131. ma_qty = int.Parse(dt.Rows[0]["ma_qty"].ToString());
  132. BaseUtil.SetFormValue(this.Controls, dt);
  133. }
  134. else
  135. {
  136. OperateResult.AppendText("<<TSN号" + code.Text + "不存在\n", Color.Red, code);
  137. return;
  138. }
  139. }
  140. //查询TSN对应的sninfo记录id
  141. siid= dh.getFieldDataByCondition("sninfo", "max(si_id) si_id", "si_sn in (select '" + code.Text + "' from dual union select sn from makesnrelation where beforesn = '" + code.Text + "' )").ToString();
  142. //获取需要关联采集的信息,以及校验规则
  143. ListA = (DataTable)dh.ExecuteSql("select * from productsnrelation where psr_prodcode='" + ma_prodcode.Text + "' order by psr_detno", "select");
  144. //没有获取到就提示错误请维护产品对应的关联采集信息
  145. if (ListA.Rows.Count == 0)
  146. {
  147. OperateResult.AppendText("<<请维护产品对应的关联采集信息\n", Color.Red, code);
  148. OperateResult.AppendText(">>请输入TSN\n", Color.Black);
  149. if (ChangeResult.Checked)
  150. {
  151. clearInfo();
  152. }
  153. return;
  154. }
  155. if (ChangeResult.Checked)
  156. {
  157. OperateResult.AppendText(">>请输入SN\n", Color.Green, code);
  158. }
  159. //判断重新转换未勾选
  160. if (!ChangeResult.Checked)
  161. {
  162. //没有勾选,只能修改一次
  163. //核对TSN是否正确
  164. //string beforesn = dh.getFieldDataByCondition("makeserial", "ms_beforesn", "ms_sncode='" + code.Text + "'").ToString().Trim();
  165. if (dh.CheckExist("makeserial", "ms_id='" + oMsid + "' and ms_sncode='" + code.Text + "' and ms_beforesn is null"))
  166. {
  167. step = 1;
  168. //记录转换前的序列号
  169. TSN = code.Text;
  170. //显示之前的序列号
  171. show_sncode.Text = TSN;
  172. OperateResult.AppendText(">>请输入SN\n", Color.Green, code);
  173. ChangeResult.Enabled = false;
  174. }
  175. else
  176. //不为空,进行过转换。不勾选修改结果,就不能再修改
  177. {
  178. //修改转换结果时,输入两次SN直接过站
  179. if (dh.CheckExist("MakeSerial", "ms_id='" + oMsid + "' and ms_sncode='" + code.Text + "' and ms_beforesn is not null"))
  180. {
  181. step = 1;
  182. TSN = code.Text;
  183. //显示序列号
  184. show_sncode.Text = TSN;
  185. OperateResult.AppendText(">>请输入SN\n", Color.Green, code);
  186. ChangeResult.Enabled = false;
  187. }
  188. else
  189. {
  190. OperateResult.AppendText("<<序列号:" + code.Text + "已转换过\n", Color.Red, code);
  191. OperateResult.AppendText(">>请重新输入TSN\n", Color.Black);
  192. }
  193. }
  194. }
  195. }
  196. else if (step == 1)
  197. {
  198. OperateResult.AppendText(">>" + code.Text + "\n", Color.Black);
  199. //判断工单是否导入了序列号清单
  200. if (hasSnList)
  201. {
  202. if (!dh.CheckExist("makesnlist", "msl_sncode='" + code.Text + "' and msl_makecode='" + ms_macode.Text + "' and msl_type='after'"))
  203. {
  204. //有序列号清单,输入的序列号却不在范围内
  205. OperateResult.AppendText("<<SN号" + code.Text + "错误,不在工单设定的转换后序列号清单中\n", Color.Red, code);
  206. return;
  207. }
  208. }
  209. else if (hasMakeRule)//判断工单防呆
  210. {
  211. if (!dh.CheckExist("makesnruledetail", "msd_sncode='" + code.Text + "' and msd_makecode='" + ms_macode.Text + "' and msd_type='after'"))
  212. {
  213. OperateResult.AppendText("<<SN号" + code.Text + "校验错误,不在工单防呆规则指定范围内!\n", Color.Red, code);
  214. return;
  215. }
  216. }
  217. else//判断产品防呆
  218. {
  219. //判断用户是否锁定输入SN长度,
  220. if (!checkLengthOrPre(SNLength_checkBox, SNLength, "长度", "SN"))
  221. {
  222. return;
  223. }
  224. //判断用户是否锁定输入SN前缀,
  225. if (!checkLengthOrPre(SNPre_checkBox, SNPre, "前缀", "SN"))
  226. {
  227. return;
  228. }
  229. }
  230. //开始录入SN
  231. if ((ChangeResult.Checked && dh.CheckExist("makeserial", " ms_id='" + oMsid + "' and ms_sncode='" + code.Text + "'")) || !dh.CheckExist("makeserial", "ms_sncode='" + code.Text + "'") || (!ChangeResult.Checked && (TSN == code.Text)))
  232. {
  233. //SN校验成功,合法,记录下SN
  234. SN = code.Text;
  235. code.Text = "";
  236. //开始进行校验规则
  237. if (ListA.Rows.Count > 0)
  238. {
  239. OperateResult.AppendText(">>请输入" + ListA.Rows[0]["psr_type"] + "\n", Color.Green);
  240. //实例化hashTable的值
  241. hs = new Hashtable();
  242. }
  243. //step+1
  244. step = 2;
  245. }
  246. else
  247. {
  248. OperateResult.AppendText("<<序列号" + code.Text + "已存在或无该转换后序列号\n", Color.Red);
  249. OperateResult.AppendText(">>请输入SN\n", Color.Black, code);
  250. }
  251. }
  252. else if (step < ListA.Rows.Count + 2)
  253. {
  254. OperateResult.AppendText(">>" + code.Text + "\n", Color.Black);
  255. //开始进行校验规则
  256. if (checkRules(step))
  257. {
  258. step += 1;
  259. }
  260. }
  261. }
  262. else
  263. {
  264. OperateResult.AppendText(">>" + errorMessage + "\n", Color.Red, code);
  265. }
  266. }
  267. else
  268. {
  269. OperateResult.AppendText("<<输入不能为空\n", Color.Red);
  270. }
  271. code.Text = "";
  272. }
  273. }
  274. /// <summary>
  275. /// 检验长度或者前缀是否合法
  276. /// </summary>
  277. /// <param name="checkbox"></param>
  278. /// <param name="c"></param>
  279. /// <param name="info"></param>
  280. private bool checkLengthOrPre(CheckBox checkbox, TextBox textbox, string type, string TSNorSN)
  281. {
  282. if (checkbox.Checked == true)
  283. {
  284. //如果勾选没有填值
  285. if (textbox.Text == "")
  286. {
  287. OperateResult.AppendText("<<勾选长度或者前缀需要填写内容\n", Color.Red);
  288. return false;
  289. }
  290. if (type == "长度")
  291. {
  292. //则判断输入转换前的序列号长度是否合法,不合法则提示
  293. if (code.Text.Trim().Length != int.Parse(textbox.Text))
  294. {
  295. //序列号校验错误,长度错误
  296. OperateResult.AppendText("<<" + TSNorSN + ":" + code.Text + "校验错误,长度错误\n", Color.Red, code);
  297. OperateResult.AppendText(">>请重新输入" + TSNorSN + "\n", Color.Black);
  298. return false;
  299. }
  300. }
  301. else if (type == "前缀")
  302. {
  303. string[] pres = textbox.Text.Split('|');
  304. bool f = false;
  305. for (int i = 0; i < pres.Length; i++)
  306. {
  307. if (pres[i] == "" ? true : code.Text.StartsWith(pres[i]))
  308. {
  309. //满足其中一条即可
  310. f = true;
  311. break;
  312. }
  313. }
  314. //则判断输入转换前的序列号前缀是否合法,不合法则提示
  315. if (!f)
  316. {
  317. //序列号校验错误,前缀错误
  318. OperateResult.AppendText("<<" + TSNorSN + ":" + code.Text + "校验错误,前缀错误\n", Color.Red, code);
  319. OperateResult.AppendText(">>请重新输入" + TSNorSN + "\n", Color.Black);
  320. return false;
  321. }
  322. }
  323. return true;
  324. }
  325. return true;
  326. }
  327. /// <summary>
  328. /// 关联采集的校验
  329. /// </summary>
  330. /// <param name="step"></param>
  331. private bool checkRules(int step)
  332. {
  333. type = ListA.Rows[step - 2]["psr_type"].ToString();
  334. //将type中的mac和bt中的"-"和":"号去掉
  335. if (type == "MAC" || type == "BT")
  336. {
  337. if (code.Text.Length > 40)
  338. {
  339. macOrBt = code.Text.Substring(0, 40).Replace(":", "").Replace("-", "");
  340. }
  341. else
  342. {
  343. macOrBt = code.Text.Replace(":", "").Replace("-", "");
  344. }
  345. }
  346. else
  347. {
  348. if (code.Text.Length > 40)
  349. {
  350. imeif = code.Text.Substring(0, 40);
  351. }
  352. else
  353. {
  354. imeif = code.Text;
  355. }
  356. }
  357. //如果前缀和长度都满足的话
  358. if ((ListA.Rows[step - 2]["psr_length"].ToString() == "0" ? false : code.Text.Length != int.Parse(ListA.Rows[step - 2]["psr_length"].ToString())))
  359. {
  360. OperateResult.AppendText("<<" + ListA.Rows[step - 2]["psr_type"] + "长度需为"+ ListA.Rows[step - 2]["psr_length"].ToString() + "校验不通过,请重新输入\n", Color.Red);
  361. OperateResult.AppendText(">>请重新输入" + ListA.Rows[step - 2]["psr_type"] + "\n", Color.Black, code);
  362. return false;
  363. }
  364. //以|符号分割前缀
  365. string[] preFixs = ListA.Rows[step - 2]["psr_prefix"].ToString().Split('|');
  366. //只要满足其中一个前缀条件即可
  367. bool isfit = false;
  368. for (int i = 0; i < preFixs.Length; i++)
  369. {
  370. if (preFixs[i] == "" ? true : code.Text.StartsWith(preFixs[i]))
  371. {
  372. //满足其中一条即可
  373. isfit = true;
  374. break;
  375. }
  376. }
  377. if (!isfit)
  378. {
  379. OperateResult.AppendText("<<" + ListA.Rows[step - 2]["psr_type"] + "前缀校验不通过,请重新输入\n", Color.Red);
  380. OperateResult.AppendText(">>请重新输入" + ListA.Rows[step - 2]["psr_type"] + "\n", Color.Black, code);
  381. return false;
  382. }
  383. switch (type)
  384. {
  385. case "IMEI1":
  386. case "IMEI2":
  387. case "IMEI3":
  388. if (checkExist("(ms_imei1='" + imeif + "' or ms_imei2 = '" + imeif + "' or ms_imei3 = '" + imeif + "') and ms_status in (0,1,2,3) and ms_id <> '" + oMsid + "'"))
  389. {
  390. OperateResult.AppendText("<<" + type + ":" + imeif + "错误,不允许重复\n", Color.Red);
  391. OperateResult.AppendText(">>请输入" + type + "\n", Color.Black, code);
  392. return false;
  393. }
  394. else
  395. { //校验sninfo中是否已经存在这个
  396. if (dh.CheckExist("sninfo", "(si_imei1='" + imeif + "' or si_imei2 = '" + imeif + "' or si_imei3 = '" + imeif + "') and si_id <>'" + siid + "'"))
  397. {
  398. OperateResult.AppendText("<<" + type + ":" + imeif + "错误,不允许重复\n", Color.Red);
  399. OperateResult.AppendText(">>请输入" + type + "\n", Color.Black, code);
  400. return false;
  401. }
  402. //判断IMEI1,IMEI2,IMEI3中是否已经有这个号了
  403. if (imei.ToString().Contains(imeif))
  404. {
  405. OperateResult.AppendText("<<" + type + ":" + imeif + "已录,请重新输入\n", Color.Red);
  406. OperateResult.AppendText(">>请输入" + type + "\n", Color.Black, code);
  407. return false;
  408. }
  409. }
  410. //通过校验,将包含IMEI的值拼接
  411. imei.Append("'" + imeif + "',");
  412. break;
  413. case "BT":
  414. case "MAC":
  415. //验证是否符合合同防呆
  416. if (!LogicHandler.checkMacOrBtRange(oMsid,macOrBt,type))
  417. {
  418. OperateResult.AppendText("<<" + ListA.Rows[step - 2]["psr_type"].ToString() + ":" + code.Text + "错误,不在合同防呆范围内\n", Color.Red);
  419. OperateResult.AppendText(">>请输入" + ListA.Rows[step - 2]["psr_type"].ToString() + "\n", Color.Black, code);
  420. return false;
  421. }
  422. //验证是否已被使用
  423. if (checkExist("MS_" + type + "='" + macOrBt + "' and ms_status in (0,1,2,3) and ms_id <> '" + oMsid + "'"))
  424. {
  425. OperateResult.AppendText("<<" + ListA.Rows[step - 2]["psr_type"].ToString() + ":" + code.Text + "错误,不允许重复\n", Color.Red);
  426. OperateResult.AppendText(">>请输入" + ListA.Rows[step - 2]["psr_type"].ToString() + "\n", Color.Black, code);
  427. return false;
  428. }
  429. else
  430. {
  431. //校验在sninfo表中是否存在
  432. if (dh.CheckExist("sninfo", "si_" + type + "='" + macOrBt + "' and si_id <>'" + siid + "'"))
  433. {
  434. OperateResult.AppendText("<<" + ListA.Rows[step - 2]["psr_type"].ToString() + ":" + code.Text + "错误,不允许重复\n", Color.Red);
  435. OperateResult.AppendText(">>请输入" + ListA.Rows[step - 2]["psr_type"].ToString() + "\n", Color.Black, code);
  436. return false;
  437. }
  438. }
  439. break;
  440. case "NETCODE":
  441. if (checkExist("MS_" + type + "='" + imeif + "' and ms_status in (0,1,2,3) and ms_id <> '" + oMsid + "'"))
  442. {
  443. OperateResult.AppendText("<<" + ListA.Rows[step - 2]["psr_type"].ToString() + ":" + imeif + "错误,不允许重复\n", Color.Red);
  444. OperateResult.AppendText(">>请输入" + ListA.Rows[step - 2]["psr_type"].ToString() + "\n", Color.Black, code);
  445. return false;
  446. }
  447. else
  448. {
  449. //校验在sninfo表中是否存在
  450. if (dh.CheckExist("sninfo", "si_" + type + "='" + imeif + "' and si_id <>'" + siid + "'"))
  451. {
  452. OperateResult.AppendText("<<" + ListA.Rows[step - 2]["psr_type"].ToString() + ":" + imeif + "错误,不允许重复\n", Color.Red);
  453. OperateResult.AppendText(">>请输入" + ListA.Rows[step - 2]["psr_type"].ToString() + "\n", Color.Black, code);
  454. return false;
  455. }
  456. }
  457. break;
  458. }
  459. //满足规则,则采集
  460. if (type == "MAC" || type == "BT")
  461. {
  462. hs.Add(ListA.Rows[step - 2]["psr_type"].ToString(), macOrBt);
  463. }
  464. else
  465. {
  466. hs.Add(ListA.Rows[step - 2]["psr_type"].ToString(), imeif);
  467. }
  468. //说明已经是最后一个校验规则
  469. if (step == ListA.Rows.Count + 1)
  470. {
  471. //通过存储过程二次校验
  472. if (LogicHandler.snChangeAndBurn(TSN,SN,User.UserSourceCode,User.UserCode,ms_macode.Text,ChangeResult.Checked?1:0,(hs.ContainsKey("IMEI1")?hs["IMEI1"].ToString():""), (hs.ContainsKey("IMEI2") ? hs["IMEI2"].ToString() : ""), (hs.ContainsKey("IMEI3") ? hs["IMEI3"].ToString() : ""),"", (hs.ContainsKey("NETCODE") ? hs["NETCODE"].ToString() : ""),"","","","", (hs.ContainsKey("MAC") ? hs["MAC"].ToString() : ""), (hs.ContainsKey("BT") ? hs["BT"].ToString() : ""),"","","",out errorMessage))
  473. {
  474. OperateResult.AppendText("<<序列号转换成功\n<<关联采集成功\n", Color.Green);
  475. //写入日志
  476. LogManager.DoLog("修改序列号:" + TSN + "为" + SN + "成功!" + "操作人:" + User.UserCode);
  477. //记录日志
  478. LogicHandler.DoCommandLog(Tag.ToString(), User.UserCode, ms_macode.Text, User.UserLineCode, User.UserSourceCode, "序列烧录转换", "转换成功", TSN, "");
  479. //获取剩余数,刷新页面
  480. sql.Clear();
  481. sql.Append("select mcd_inqty from makecraftdetail where mcd_macode='" + ms_macode.Text + "' and mcd_stepcode='" + User.CurrentStepCode + "'");
  482. dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
  483. if (dt.Rows.Count > 0)
  484. {
  485. remain_qty.Text = ma_qty - int.Parse(dt.Rows[0]["mcd_inqty"].ToString()) + "";
  486. }
  487. //更新页面计数+1
  488. count.Text = int.Parse(count.Text) + 1 + "";
  489. //完成之后,清除信息
  490. clearInfo();
  491. OperateResult.AppendText(">>请输入TSN号\n", Color.Black);
  492. }
  493. else
  494. {
  495. OperateResult.AppendText(">>" + errorMessage + "\n", Color.Red, code);
  496. OperateResult.AppendText(">>请重新输入TSN\n", Color.Black, code);
  497. // //清空信息
  498. clearInfo();
  499. }
  500. code.Text = "";
  501. return false;
  502. }
  503. else
  504. {
  505. OperateResult.AppendText(">>请输入" + ListA.Rows[step - 1]["psr_type"] + "\n", Color.Green, code);
  506. return true;
  507. }
  508. }
  509. /// <summary>
  510. /// 工单号变化时,带出校验规则
  511. /// </summary>
  512. /// <param name="sender"></param>
  513. /// <param name="e"></param>
  514. private void ms_macode_TextChanged(object sender, EventArgs e)
  515. {
  516. hasSnList = false;
  517. hasMakeRule = false;
  518. //清空
  519. TSNPre.Text = "";
  520. TSNLength.Text = "";
  521. SNPre.Text = "";
  522. SNLength.Text = "";
  523. //取消勾选
  524. TSNPre_checkBox.Checked = false;
  525. TSNLength_checkBox.Checked = false;
  526. SNPre_checkBox.Checked = false;
  527. SNLength_checkBox.Checked = false;
  528. //设置可编辑
  529. TSNLength.Enabled = true;
  530. TSNPre.Enabled = true;
  531. SNLength.Enabled = true;
  532. SNPre.Enabled = true;
  533. TSNPre_checkBox.Enabled = true;
  534. TSNLength_checkBox.Enabled = true;
  535. SNPre_checkBox.Enabled = true;
  536. SNLength_checkBox.Enabled = true;
  537. //判断工单是否导入了序列号清单
  538. if (dh.CheckExist("makesnlist", "msl_makecode='" + ms_macode.Text + "' and msl_type='after'"))
  539. {
  540. hasSnList = true;
  541. return;
  542. }
  543. //查询表工单序列号防呆规则表
  544. rules = (DataTable)dh.ExecuteSql("select msr_startno from makesnrule where msr_makecode='" + ms_macode.Text + "' and msr_type='after'", "select");
  545. if (rules.Rows.Count > 0)
  546. {
  547. hasMakeRule = true;
  548. }
  549. else
  550. {
  551. /* 如果转换前没有值,则取 select productsnrule where psr_prodcode=? 产品编号,
  552. * 有值则赋值到 转换前,并且自动勾选不可编辑。*/
  553. rules = (DataTable)dh.ExecuteSql("select psr_prefix,psr_length from productsnrule where psr_prodcode ='" + dt.Rows[0]["ma_prodcode"].ToString() + "' and psr_type='after'", "select");
  554. if (rules.Rows.Count > 0)
  555. {
  556. //将产品序列号防呆规则查出的数据填充
  557. if (rules.Rows[0]["psr_prefix"].ToString() != "")
  558. {
  559. SNPre.Text = rules.Rows[0]["psr_prefix"].ToString();
  560. SNPre.Enabled = false;
  561. SNPre_checkBox.Checked = true;
  562. SNPre_checkBox.Enabled = false;
  563. }
  564. if (rules.Rows[0]["psr_length"].ToString() != "")
  565. {
  566. SNLength.Text = rules.Rows[0]["psr_length"].ToString();
  567. SNLength.Enabled = false;
  568. SNLength_checkBox.Checked = true;
  569. SNLength_checkBox.Enabled = false;
  570. }
  571. }
  572. }
  573. }
  574. private bool checkExist(string fields)
  575. {
  576. //不存在
  577. if (!dh.CheckExist("makeserial", fields))
  578. {
  579. //则记录
  580. return false;
  581. }
  582. else
  583. {
  584. return true;
  585. }
  586. }
  587. private void clearInfo()
  588. {
  589. //步骤重置为0
  590. step = 0;
  591. //关联采集信息清空
  592. if (hs != null)
  593. {
  594. hs.Clear();
  595. }
  596. imei.Clear();
  597. logsql.Clear();
  598. show_sncode.Text = "";
  599. ChangeResult.Enabled = true;
  600. }
  601. private void cancel_Click(object sender, EventArgs e)
  602. {
  603. //清除已经采集的所有信息
  604. clearInfo();
  605. //提示用户输入TSN
  606. OperateResult.AppendText(">>请输入TSN\n", Color.Green);
  607. }
  608. private void ChangeResult_CheckedChanged(object sender, EventArgs e)
  609. {
  610. if (ChangeResult.Checked)
  611. {
  612. //勾选的时候提示输入TSN
  613. OperateResult.AppendText(">>请输入TSN号\n", Color.Black);
  614. }
  615. }
  616. private void Make_SeqProgramTransform_SizeChanged(object sender, EventArgs e)
  617. {
  618. asc.controlAutoSize(this);
  619. }
  620. }
  621. }