Make_SeqTransform.cs 36 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692
  1. using System;
  2. using System.Data;
  3. using System.Drawing;
  4. using System.Windows.Forms;
  5. using UAS_MES.CustomControl.TextBoxWithIcon;
  6. using UAS_MES.DataOperate;
  7. using UAS_MES.Entity;
  8. using UAS_MES.PublicMethod;
  9. namespace UAS_MES.Make
  10. {
  11. public partial class Make_SeqTransform : Form
  12. {
  13. AutoSizeFormClass asc = new AutoSizeFormClass();
  14. DataHelper dh;
  15. DataTable dt;
  16. DataTable rules;
  17. LogStringBuilder sql = new LogStringBuilder();
  18. string bsncode = "";//转换前序列号
  19. string errorMessage = "";
  20. DataTable ListA;
  21. //存放工单中数量
  22. int ma_qty;
  23. string oMakeCode = "";
  24. string oMsId = "";
  25. bool onlyPass = false;
  26. bool hasSnList = false;//记录是否有转换后SN清单
  27. bool hasMakeRule = false;//记录是否有工单防呆规则
  28. bool hasSaleRule = false;//记录是否有合同防呆规则
  29. public Make_SeqTransform()
  30. {
  31. InitializeComponent();
  32. }
  33. private void sncode_KeyDown(object sender, KeyEventArgs e)
  34. {
  35. if (e.KeyCode == Keys.Enter)
  36. {
  37. if (sncode.Text != "")
  38. {
  39. if (sncode.Text.Contains(":"))
  40. {
  41. if (sncode.Text.Contains("SN:"))
  42. {
  43. sncode.Text = sncode.Text.Split(':')[1];
  44. }
  45. else
  46. {
  47. sncode.Clear();
  48. return;
  49. }
  50. }
  51. if (LogicHandler.CheckStepAttribute(Tag.ToString(), User.UserSourceCode, out errorMessage))
  52. {
  53. OperateResult.AppendText(">>" + sncode.Text + "\n", Color.Black);
  54. //如果用户没有输入工单号自行去后台查询
  55. //通过工单序列号关系验证
  56. //bsncode为空,就说明是输入转换之前的序列号
  57. if (bsncode == "")
  58. {
  59. if (!ChangeResult.Checked)
  60. {
  61. //用户填写了工单号,那么序列号必须要是该工单的,否则提示错误
  62. if (!LogicHandler.CheckStepSNAndMacode("", User.UserSourceCode, sncode.Text, User.UserCode, out oMakeCode, out oMsId, out errorMessage))
  63. {
  64. OperateResult.AppendText("<<" + errorMessage + "\n", Color.Red, sncode);
  65. return;
  66. }
  67. }
  68. else//勾选
  69. {
  70. oMsId = dh.getFieldDataByCondition("makeserial", "max(ms_id)", "ms_sncode in (select '" + sncode.Text + "' from dual union select sn from makesnrelation where beforesn='" + sncode.Text + "' and sn<>' ' union select beforesn from makesnrelation where sn='" + sncode.Text + "' and beforesn<>' ')").ToString();
  71. if (oMsId == "")
  72. {
  73. OperateResult.AppendText("<<TSN号错误\n", Color.Red, sncode);
  74. return;
  75. }
  76. //根据ms_id查询
  77. sql.Clear();
  78. sql.Append("select ms_stepcode,nvl(ms_downstatus,'0') ms_downstatus from makeserial where ms_id='" + oMsId + "' and ms_beforesn='" + sncode.Text + "' and ms_nextmacode is null and ms_outboxcode is null");
  79. dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
  80. //如果行数大于0则允许转号
  81. if (dt.Rows.Count > 0)
  82. {
  83. if (dt.Rows[0]["ms_downstatus"].ToString() != "0")
  84. {
  85. OperateResult.AppendText("<<当前TSN号处于下地状态不允许操作\n", Color.Red, sncode);
  86. return;
  87. }
  88. //if (dt.Rows[0]["ms_stepcode"].ToString() == User.CurrentStepCode)
  89. //{
  90. bsncode = sncode.Text;
  91. //显示序列号
  92. show_sncode.Text = bsncode;
  93. ChangeResult.Enabled = false;
  94. //}
  95. //else
  96. //{
  97. // OperateResult.AppendText("<<当前工序不允许重新转号\n", Color.Red, sncode);
  98. // return;
  99. //}
  100. }
  101. else
  102. {
  103. OperateResult.AppendText("<<TSN号" + sncode.Text + "未转号不允许重新转号\n", Color.Red, sncode);
  104. return;
  105. }
  106. }
  107. //如果用户没有选择工单号
  108. if (ma_code.Text == "" || ma_code.Text != oMakeCode || ChangeResult.Checked)
  109. {
  110. //按照out出的工单号查出工单相关信息,并赋值到相关控件
  111. sql.Clear();
  112. sql.Append("select ma_code,ma_softversion,ma_prodcode,pr_detail,ma_salecode,ma_qty,ma_qty-mcd_inqty as remain_qty ");
  113. sql.Append("from makeserial left join make on ms_makecode=ma_code left join product on ");
  114. sql.Append("ms_prodcode=pr_code left join makecraftdetail on ms_makecode=mcd_macode where ms_id='" + oMsId + "' and mcd_stepcode='" + User.CurrentStepCode + "'");
  115. dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
  116. if (dt.Rows.Count > 0)
  117. {
  118. //记录数量
  119. ma_qty = int.Parse(dt.Rows[0]["ma_qty"].ToString());
  120. BaseUtil.SetFormValue(this.Controls, dt);
  121. }
  122. }
  123. //获取需要关联采集的信息,以及校验规则
  124. ListA = (DataTable)dh.ExecuteSql("select * from productsnrelation where psr_prodcode='" + ma_prodcode.Text + "' order by psr_detno", "select");
  125. //没有获取到就提示错误请维护产品对应的关联采集信息
  126. if (ListA.Rows.Count > 0)
  127. {
  128. OperateResult.AppendText("<<产品已维护关联采集信息,不允许只做转号\n", Color.Red, sncode);
  129. OperateResult.AppendText(">>请输入TSN\n", Color.Black);
  130. if (ChangeResult.Checked)
  131. {
  132. bsncode = "";
  133. ChangeResult.Enabled = true;
  134. show_sncode.Text = "";
  135. }
  136. return;
  137. }
  138. //获取需要关联采集的信息,以及校验规则
  139. ListA = (DataTable)dh.ExecuteSql("select * from makeaddresslist where mal_makecode='" + ma_code.Text + "' order by mal_detno", "select");
  140. //没有获取到就提示错误请维护产品对应的关联采集信息
  141. if (ListA.Rows.Count > 0)
  142. {
  143. OperateResult.AppendText("<<当前工序为序列号烧录转换工序,SN对应的工单导入了MAC清单,SN必须烧录MAC信息\n", Color.Red, sncode);
  144. OperateResult.AppendText(">>请输入TSN\n", Color.Black);
  145. if (ChangeResult.Checked)
  146. {
  147. bsncode = "";
  148. ChangeResult.Enabled = true;
  149. show_sncode.Text = "";
  150. }
  151. return;
  152. }
  153. //获取需要关联采集的信息,以及校验规则
  154. ListA = (DataTable)dh.ExecuteSql("select * from makeimeilist where mil_makecode='" + ma_code.Text + "' order by mil_detno", "select");
  155. //没有获取到就提示错误请维护产品对应的关联采集信息
  156. if (ListA.Rows.Count > 0)
  157. {
  158. OperateResult.AppendText("<<当前工序为序列号烧录转换工序,SN对应的工单导入了IMEI清单,SN必须烧录IMEI信息\n", Color.Red, sncode);
  159. OperateResult.AppendText(">>请输入TSN\n", Color.Black);
  160. if (ChangeResult.Checked)
  161. {
  162. bsncode = "";
  163. ChangeResult.Enabled = true;
  164. show_sncode.Text = "";
  165. }
  166. return;
  167. }
  168. if (ChangeResult.Checked)
  169. {
  170. OperateResult.AppendText(">>请输入SN号\n", Color.Green, sncode);
  171. }
  172. switch (ChangeResult.CheckState)
  173. {
  174. //勾选是修改已转换的序列,矫正修改错了的序列号
  175. case CheckState.Checked:
  176. break;
  177. case CheckState.Unchecked:
  178. //string beforesn = dh.getFieldDataByCondition("makeserial", "ms_beforesn", "ms_sncode='" + sncode.Text + "'").ToString().Trim();
  179. //为空,就说明,没有进行过序列号的转换
  180. if (dh.CheckExist("makeserial", "ms_id='" + oMsId + "' and ms_sncode='" + sncode.Text + "' and ms_beforesn is null"))
  181. {
  182. //记录转换前的序列号
  183. bsncode = sncode.Text;
  184. //显示序列号
  185. show_sncode.Text = bsncode;
  186. OperateResult.AppendText(">>请输入SN号\n", Color.Green, sncode);
  187. ChangeResult.Enabled = false;
  188. }
  189. else
  190. //不为空,进行过转换。不勾选修改结果,就不能再修改
  191. {
  192. //修改转换结果时,输入两次SN直接过站
  193. if (dh.CheckExist("MakeSerial", "ms_id='" + oMsId + "' and ms_sncode='" + sncode.Text + "' and ms_beforesn is not null"))
  194. {
  195. string nextstepcode = dh.getFieldDataByCondition("makeserial", "ms_nextstepcode", "ms_id='" + oMsId + "'").ToString();
  196. if (nextstepcode == User.CurrentStepCode)
  197. {
  198. bsncode = sncode.Text;
  199. //显示序列号
  200. show_sncode.Text = bsncode;
  201. OperateResult.AppendText(">>请输入SN号\n", Color.Green, sncode);
  202. ChangeResult.Enabled = false;
  203. onlyPass = true;
  204. }
  205. else
  206. {
  207. OperateResult.AppendText("<<序列号:" + sncode.Text + "下一工序是" + nextstepcode + ",不是当前岗位的工序\n", Color.Red, sncode);
  208. OperateResult.AppendText(">>请重新输入TSN号\n", Color.Black);
  209. }
  210. }
  211. else
  212. {
  213. OperateResult.AppendText("<<序列号:" + sncode.Text + "已转换过\n", Color.Red, sncode);
  214. OperateResult.AppendText(">>请重新输入TSN号\n", Color.Black);
  215. }
  216. }
  217. break;
  218. default:
  219. break;
  220. }
  221. }
  222. //bsncode不为空,说明输入的是转换后的序列号
  223. else
  224. {
  225. //判断工单是否导入了序列号清单
  226. if (hasSnList)
  227. {
  228. if (!dh.CheckExist("makesnlist", "msl_sncode='" + sncode.Text + "' and msl_makecode='" + ma_code.Text + "' and msl_type='after'"))
  229. {
  230. //有序列号清单,输入的序列号却不在范围内
  231. OperateResult.AppendText("<<SN号" + sncode.Text + "错误,不在工单设定的转换后序列号清单中\n", Color.Red, sncode);
  232. return;
  233. }
  234. }
  235. else if (hasMakeRule)//判断工单防呆
  236. {
  237. if (!dh.CheckExist("makesnruledetail", "msd_sncode='" + sncode.Text + "' and msd_makecode='" + ma_code.Text + "' and msd_type='after'"))
  238. {
  239. OperateResult.AppendText("<<SN号" + sncode.Text + "校验错误,不在工单防呆规则指定范围内!\n", Color.Red, sncode);
  240. return;
  241. }
  242. }
  243. else if (hasSaleRule)//判断合同防呆
  244. {
  245. if (!dh.CheckExist("makesnruledetail", "msd_sncode='" + sncode.Text + "' and msd_salecode='" + ma_salecode.Text + "' and msd_type='after'"))
  246. {
  247. OperateResult.AppendText("<<SN号" + sncode.Text + "校验错误,不在合同防呆规则指定范围内!\n", Color.Red, sncode);
  248. return;
  249. }
  250. }
  251. else//判断产品防呆
  252. {
  253. //判断用户是否锁定输入转换后序列号长度,
  254. if (!checkLengthOrPre(afterTransSNLength_checkBox, afterTransSNLength, "长度"))
  255. return;
  256. //判断用户是否锁定输入转换后序列号前缀,
  257. if (!checkLengthOrPre(afterTransSNPre_checkBox, afterTransSNPre, "前缀"))
  258. return;
  259. }
  260. //防呆验证完成
  261. if ((!ChangeResult.Checked && (!dh.CheckExist("makeserial", "ms_sncode='" + sncode.Text + "' and ms_id <>'" + oMsId + "' and nvl(ms_nextmacode,' ') =' '") && !onlyPass || onlyPass && bsncode == sncode.Text)) || (ChangeResult.Checked && !dh.CheckExist("makeserial", "ms_sncode='" + sncode.Text + "' and ms_id <>'" + oMsId + "' and nvl(ms_nextmacode,' ') =' '")))
  262. {
  263. if (CollectRemark.Checked || SameReamrk.Checked)
  264. {
  265. if (Remark.Text == "")
  266. {
  267. OperateResult.AppendText(">>备注栏信息为空,录入备注信息\n", Color.Black);
  268. Remark.SelectAll();
  269. Remark.Focus();
  270. return;
  271. }
  272. if (IFONLY.Checked)
  273. {
  274. if (!CheckPre())
  275. {
  276. return;
  277. }
  278. string UsedSncode = dh.getFieldDataByCondition("SNRELATIONINFORECORD", "SIR_SNCODE", "sir_remark = '" + Remark.Text + "'").ToString();
  279. if (UsedSncode != "")
  280. {
  281. OperateResult.AppendText(">>备注信息" + Remark.Text + "已被" + UsedSncode + "采集,不可重复采集\n", Color.Red);
  282. Remark.SelectAll();
  283. Remark.Focus();
  284. return;
  285. }
  286. LogicHandler.CollectRemarkInf(oMsId, "", "", Remark.Text);
  287. OperateResult.AppendText(">>备注:" + Remark.Text + "\n", Color.Black);
  288. if (CollectRemark.Checked)
  289. {
  290. Remark.Text = "";
  291. }
  292. }
  293. else
  294. {
  295. if (!CheckPre())
  296. {
  297. return;
  298. }
  299. LogicHandler.CollectRemarkInf(oMsId, "", "", Remark.Text);
  300. OperateResult.AppendText(">>备注:" + Remark.Text + "\n", Color.Black);
  301. if (CollectRemark.Checked)
  302. {
  303. Remark.Text = "";
  304. }
  305. }
  306. }
  307. if (!ChangeResult.Checked && !onlyPass || ChangeResult.Checked)
  308. {
  309. string firstsn = "";
  310. string updateSql = "";
  311. //勾选了修改转换结果
  312. if (ChangeResult.Checked)
  313. {
  314. //查询ms_firstsn
  315. firstsn = dh.getFieldDataByCondition("makeserial", "ms_firstsn", "ms_id='" + oMsId + "' and ms_beforesn='" + bsncode + "'").ToString();
  316. //记录本次修改,存入makesnrelation表中
  317. updateSql = "update makeserial set ms_sncode='" + sncode.Text + "' where ms_id='" + oMsId + "' and ms_beforesn='" + bsncode + "'";
  318. //删除最近一条转换记录
  319. dh.ExecuteSql("delete from makesnrelation where BEFORESN='" + bsncode + "' and makecode='" + ma_code.Text + "'", "delete");
  320. }
  321. //未勾选修改转换结果
  322. else
  323. {
  324. //查询ms_firstsn
  325. firstsn = dh.getFieldDataByCondition("makeserial", "ms_firstsn", "ms_id='" + oMsId + "' and ms_sncode='" + bsncode + "'").ToString();
  326. //记录本次修改,存入makesnrelation表中
  327. updateSql = "update makeserial set ms_sncode='" + sncode.Text + "', ms_beforesn='" + bsncode + "' where ms_id='" + oMsId + "' and ms_sncode='" + bsncode + "'";
  328. }
  329. string insertSql = "insert into makesnrelation (BEFORESN,SN,FIRSTSN,MAKECODE,msr_indate, msr_inman)values('" + bsncode + "','" + sncode.Text + "','" + firstsn + "','" + ma_code.Text + "', sysdate ,'" + User.UserCode + "')";
  330. dh.ExecuteSQLTran(updateSql, insertSql);
  331. }
  332. onlyPass = false;
  333. OperateResult.AppendText("<<序列号" + bsncode + "成功转换为" + sncode.Text + "\n", Color.Green);
  334. //记录日志
  335. LogicHandler.DoCommandLog(Tag.ToString(), User.UserCode, ma_code.Text, User.UserLineCode, User.UserSourceCode, "序列转换", bsncode + "转换为" + sncode.Text, sncode.Text, "");
  336. //if (CollectRemark.Checked && Remark.Text != "")
  337. //{
  338. // LogicHandler.CollectRemarkInf(sncode.Text, "", "", oMakeCode, ma_prodcode.Text, Remark.Text);
  339. //}
  340. LogManager.DoLog("修改序列号:" + bsncode + "为" + sncode.Text + "成功!" + "操作人:" + User.UserCode);
  341. //写入日志
  342. if (!LogicHandler.SetStepResult(ma_code.Text, User.UserSourceCode, sncode.Text, "序列转换", "序列转换成功", User.UserCode, out errorMessage))
  343. {
  344. OperateResult.AppendText(">>" + errorMessage + "\n", Color.Red, sncode);
  345. }
  346. OperateResult.AppendText(">>请输入TSN号\n", Color.Black);
  347. //置空
  348. bsncode = "";
  349. show_sncode.Text = "";
  350. //获取剩余数,刷新页面
  351. sql.Clear();
  352. sql.Append("select mcd_inqty from makecraftdetail where mcd_macode='" + ma_code.Text + "' and mcd_stepcode='" + User.CurrentStepCode + "'");
  353. dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
  354. if (dt.Rows.Count > 0)
  355. {
  356. remain_qty.Text = ma_qty - int.Parse(dt.Rows[0]["mcd_inqty"].ToString()) + "";
  357. }
  358. //更新数量
  359. changenum.Text = int.Parse(changenum.Text) + 1 + "";
  360. ChangeResult.Enabled = true;
  361. }
  362. else
  363. {
  364. if (onlyPass)
  365. {
  366. OperateResult.AppendText("<<SN号" + sncode.Text + "错误,已完成转号只允许SN转SN\n", Color.Red);
  367. }
  368. else
  369. {
  370. OperateResult.AppendText("<<SN号" + sncode.Text + "已存在,请输入其他序列号\n", Color.Red);
  371. }
  372. }
  373. sncode.Text = "";
  374. }
  375. }
  376. else
  377. {
  378. OperateResult.AppendText("<<" + errorMessage + "\n", Color.Red, sncode);
  379. }
  380. }
  381. else
  382. {
  383. OperateResult.AppendText("<<序列号不能为空\n", Color.Red);
  384. }
  385. sncode.Text = "";
  386. }
  387. }
  388. private void Confirm_Click(object sender, EventArgs e)
  389. {
  390. KeyEventArgs ky = new KeyEventArgs(Keys.Enter);
  391. sncode_KeyDown(sender, ky);
  392. }
  393. private void ReCall_Click(object sender, EventArgs e)
  394. {
  395. bsncode = "";
  396. OperateResult.AppendText(">>请输入TSN号\n", Color.Green, show_sncode);
  397. ChangeResult.Enabled = true;
  398. onlyPass = false;
  399. }
  400. /// <summary>
  401. /// 工单号keydown
  402. /// </summary>
  403. /// <param name="sender"></param>
  404. /// <param name="e"></param>
  405. private void ms_makecode_KeyDown(object sender, KeyEventArgs e)
  406. {
  407. }
  408. /// <summary>
  409. /// 如果清空了工单号,或者更换了工单号则将 : 转换前序列号长度,转换前序列号前缀
  410. ///转换后序列号长度,转换后序列号前缀 四个字段值清空。
  411. /// </summary>
  412. /// <param name="sender"></param>
  413. /// <param name="e"></param>
  414. private void ms_makecode_UserControlTextChanged(object sender, EventArgs e)
  415. {
  416. hasSnList = false;
  417. hasMakeRule = false;
  418. hasSaleRule = false;
  419. //清空
  420. beforeTransSNPre.Text = "";
  421. beforeTransSNLength.Text = "";
  422. afterTransSNPre.Text = "";
  423. afterTransSNLength.Text = "";
  424. //取消勾选
  425. beforeTransSNPre_checkBox.Checked = false;
  426. beforeTransSNLength_checkBox.Checked = false;
  427. afterTransSNPre_checkBox.Checked = false;
  428. afterTransSNLength_checkBox.Checked = false;
  429. //设置可编辑
  430. beforeTransSNLength.Enabled = true;
  431. beforeTransSNPre.Enabled = true;
  432. afterTransSNLength.Enabled = true;
  433. afterTransSNPre.Enabled = true;
  434. beforeTransSNPre_checkBox.Enabled = true;
  435. beforeTransSNLength_checkBox.Enabled = true;
  436. afterTransSNPre_checkBox.Enabled = true;
  437. afterTransSNLength_checkBox.Enabled = true;
  438. //判断工单是否导入了序列号清单
  439. if (dh.CheckExist("makesnlist", "msl_makecode='" + ma_code.Text + "' and msl_type='after'"))
  440. {
  441. hasSnList = true;
  442. return;
  443. }
  444. //查询表工单序列号防呆规则表
  445. rules = (DataTable)dh.ExecuteSql("select msr_startno from makesnrule where msr_makecode='" + ma_code.Text + "' and msr_type='after'", "select");
  446. if (rules.Rows.Count > 0)
  447. {
  448. hasMakeRule = true;
  449. }
  450. else
  451. {
  452. ma_salecode.Text = dh.getFieldDataByCondition("make", "ma_salecode", "ma_code='" + ma_code.Text + "'").ToString();
  453. //查询表合同序列号防呆规则表
  454. rules = (DataTable)dh.ExecuteSql("select msr_startno from makesnrule where msr_salecode='" + ma_salecode.Text + "' and msr_type='after'", "select");
  455. if (rules.Rows.Count > 0)
  456. {
  457. hasSaleRule = true;
  458. }
  459. else
  460. {
  461. /* 如果转换前没有值,则取 select productsnrule where psr_prodcode=? 产品编号,
  462. * 有值则赋值到 转换前,并且自动勾选不可编辑。*/
  463. 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");
  464. if (rules.Rows.Count > 0)
  465. {
  466. //将产品序列号防呆规则查出的数据填充
  467. if (rules.Rows[0]["psr_prefix"].ToString() != "")
  468. {
  469. afterTransSNPre.Text = rules.Rows[0]["psr_prefix"].ToString();
  470. afterTransSNPre.Enabled = false;
  471. afterTransSNPre_checkBox.Checked = true;
  472. afterTransSNPre_checkBox.Enabled = false;
  473. }
  474. if (rules.Rows[0]["psr_length"].ToString() != "")
  475. {
  476. afterTransSNLength.Text = rules.Rows[0]["psr_length"].ToString();
  477. afterTransSNLength.Enabled = false;
  478. afterTransSNLength_checkBox.Checked = true;
  479. afterTransSNLength_checkBox.Enabled = false;
  480. }
  481. }
  482. }
  483. }
  484. }
  485. /// <summary>
  486. /// 检验长度或者前缀是否合法
  487. /// </summary>
  488. /// <param name="checkbox"></param>
  489. /// <param name="c"></param>
  490. /// <param name="info"></param>
  491. private bool checkLengthOrPre(CheckBox checkbox, TextBox textbox, string type)
  492. {
  493. if (checkbox.Checked == true)
  494. {
  495. //如果勾选没有填值
  496. if (textbox.Text == "")
  497. {
  498. OperateResult.AppendText("<<勾选长度或者前缀需要填写内容\n", Color.Red);
  499. return false;
  500. }
  501. if (type == "长度")
  502. {
  503. //则判断输入转换前的序列号长度是否合法,不合法则提示
  504. if (sncode.Text.Trim().Length != int.Parse(textbox.Text))
  505. {
  506. //序列号校验错误,长度错误
  507. OperateResult.AppendText("<<序列号" + sncode.Text + "校验错误,长度错误\n", Color.Red, sncode);
  508. OperateResult.AppendText(">>请重新输入SN号\n", Color.Black);
  509. return false;
  510. }
  511. }
  512. else if (type == "前缀")
  513. {
  514. string[] pres = textbox.Text.Split('|');
  515. bool f = false;
  516. for (int i = 0; i < pres.Length; i++)
  517. {
  518. if (pres[i] == "" ? true : sncode.Text.StartsWith(pres[i]))
  519. {
  520. //满足其中一条即可
  521. f = true;
  522. break;
  523. }
  524. }
  525. //则判断输入转换前的序列号前缀是否合法,不合法则提示
  526. if (!f)
  527. {
  528. //序列号校验错误,前缀错误
  529. OperateResult.AppendText("<<序列号" + sncode.Text + "校验错误,前缀错误\n", Color.Red, sncode);
  530. OperateResult.AppendText(">>请重新输入SN号\n", Color.Black);
  531. return false;
  532. }
  533. }
  534. return true;
  535. }
  536. return true;
  537. }
  538. private void ChangeResult_CheckedChanged(object sender, EventArgs e)
  539. {
  540. if (ChangeResult.Checked)
  541. {
  542. //勾选的时候提示输入TSN
  543. OperateResult.AppendText(">>请输入TSN号\n", Color.Black);
  544. }
  545. }
  546. private void Make_SeqTransform_Load(object sender, EventArgs e)
  547. {
  548. asc.controllInitializeSize(this);
  549. dh = SystemInf.dh;
  550. sncode.Focus();
  551. OperateResult.AppendText(">>请输入TSN号\n", Color.Black);
  552. StepCount.StepCode = User.CurrentStepCode;
  553. StepCount.Source = User.UserSourceCode;
  554. StepCount.LineCode = User.UserLineCode;
  555. StepCount.Dh = dh;
  556. StepCount.Start();
  557. Seq_Remark_PreFix.Text = BaseUtil.GetCacheData("Seq_Remark_PreFix").ToString();
  558. }
  559. private void Make_SeqTransform_SizeChanged(object sender, EventArgs e)
  560. {
  561. asc.controlAutoSize(this);
  562. }
  563. private void Remark_KeyDown(object sender, KeyEventArgs e)
  564. {
  565. if (e.KeyCode == Keys.Enter)
  566. {
  567. try
  568. {
  569. if ((CollectRemark.Checked || SameReamrk.Checked) && Remark.Text != "")
  570. {
  571. sncode.Enabled = true;
  572. sncode.Focus();
  573. sncode_KeyDown(this, new KeyEventArgs(Keys.Enter));
  574. }
  575. else
  576. {
  577. sncode.Enabled = true;
  578. sncode.Focus();
  579. }
  580. }
  581. catch
  582. {
  583. sncode.Enabled = true;
  584. sncode.Focus();
  585. }
  586. }
  587. }
  588. private void IFONLY_CheckedChanged(object sender, EventArgs e)
  589. {
  590. if (IFONLY.Checked)
  591. {
  592. SameReamrk.Checked = false;
  593. CollectRemark.Checked = true;
  594. }
  595. }
  596. private void SameReamrk_CheckedChanged(object sender, EventArgs e)
  597. {
  598. if (SameReamrk.Checked)
  599. {
  600. IFONLY.Checked = false;
  601. CollectRemark.Checked = false;
  602. }
  603. }
  604. private void Seq_Remark_PreFix_KeyDown(object sender, KeyEventArgs e)
  605. {
  606. if (e.KeyCode == Keys.Enter)
  607. {
  608. BaseUtil.SetCacheData("Seq_Remark_PreFix", Seq_Remark_PreFix.Text);
  609. if (CollectRemark.Checked || SameReamrk.Checked)
  610. {
  611. Remark.SelectAll();
  612. Remark.Focus();
  613. }
  614. }
  615. }
  616. //校验备注前缀
  617. private Boolean CheckPre()
  618. {
  619. try
  620. {
  621. if (Remark.Text.Substring(0, Seq_Remark_PreFix.Text.Length) != Seq_Remark_PreFix.Text)
  622. {
  623. OperateResult.AppendText(">>备注前缀不匹配,请重新输入备注信息\n", Color.Red);
  624. Remark.SelectAll();
  625. Remark.Focus();
  626. return false;
  627. }
  628. }
  629. catch (Exception)
  630. {
  631. OperateResult.AppendText(">>备注前缀不匹配,请重新输入备注信息\n", Color.Red);
  632. Remark.SelectAll();
  633. Remark.Focus();
  634. return false;
  635. }
  636. return true;
  637. }
  638. private void CollectRemark_CheckedChanged(object sender, EventArgs e)
  639. {
  640. if (CollectRemark.Checked)
  641. {
  642. SameReamrk.Checked = false;
  643. }
  644. }
  645. private void Remark_Leave(object sender, EventArgs e)
  646. {
  647. sncode.Enabled = true;
  648. }
  649. private void Remark_Enter(object sender, EventArgs e)
  650. {
  651. sncode.Enabled = false;
  652. }
  653. }
  654. }