Make_SeqTransformPrint.cs 35 KB

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