Packing_PackageCollection.cs 56 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011
  1. using LabelManager2;
  2. using System;
  3. using System.Data;
  4. using System.Windows.Forms;
  5. using UAS_MES_NEW.DataOperate;
  6. using UAS_MES_NEW.Entity;
  7. using UAS_MES_NEW.PublicMethod;
  8. using System.Drawing;
  9. using System.Threading;
  10. using UAS_MES_NEW.PublicForm;
  11. using System.Collections.Generic;
  12. namespace UAS_MES_NEW.Packing
  13. {
  14. public partial class Packing_PackageCollection : Form
  15. {
  16. DataHelper dh;
  17. DataTable dt;
  18. LogStringBuilder sql = new LogStringBuilder();
  19. AutoSizeFormClass asc = new AutoSizeFormClass();
  20. ApplicationClass lbl;
  21. Thread thread;
  22. DataTable Dbfind;
  23. string ErrorMessage = "";
  24. string oMakeCode = "";
  25. string oMsID = "";
  26. string oMsStatus = "";
  27. string oOutBoxCode = "";
  28. decimal StandardQTY = 0;
  29. string LastSncode;
  30. Document doc;
  31. string PR_CHECKCARTONW = "0";
  32. ModeBusTCPServer md;
  33. public Packing_PackageCollection()
  34. {
  35. InitializeComponent();
  36. }
  37. //创建打印进程
  38. private void NewPrint()
  39. {
  40. try
  41. {
  42. lbl = new ApplicationClass();
  43. BaseUtil.WriteLbl();
  44. }
  45. catch (Exception)
  46. {
  47. OperateResult.AppendText("未正确安装CodeSoft软件\n", Color.Red);
  48. }
  49. }
  50. private void PackCollection_Load(object sender, EventArgs e)
  51. {
  52. IP.Text = BaseUtil.GetCacheData("IP").ToString();
  53. Port.Text = BaseUtil.GetCacheData("IPPort").ToString();
  54. //设置DbFind的必须的数据
  55. PrintNum.Text = "1";
  56. asc.controllInitializeSize(this);
  57. thread = new Thread(NewPrint);
  58. SetLoadingWindow stw = new SetLoadingWindow(thread, "初始化打印程序");
  59. BaseUtil.SetFormCenter(stw);
  60. md = new ModeBusTCPServer();
  61. stw.ShowDialog();
  62. try
  63. {
  64. OutBoxLength.Text = BaseUtil.GetCacheData("OutBoxLength").ToString();
  65. PreFix.Text = BaseUtil.GetCacheData("PreFix").ToString();
  66. Remark_PreFix.Text = BaseUtil.GetCacheData("Remark_PreFix").ToString();
  67. }
  68. catch (Exception) { }
  69. sn_code.Focus();
  70. dh = SystemInf.dh;
  71. StepCount.StepCode = User.CurrentStepCode;
  72. StepCount.Source = User.UserSourceCode;
  73. StepCount.LineCode = User.UserLineCode;
  74. StepCount.Dh = dh;
  75. StepCount.Start();
  76. }
  77. private void PackCollection_SizeChanged(object sender, EventArgs e)
  78. {
  79. asc.controlAutoSize(this);
  80. }
  81. private void PackCollection_Activated(object sender, EventArgs e)
  82. {
  83. pa_outboxcode.Focus();
  84. }
  85. //刷新表单的数据的数据
  86. private void LoadData()
  87. {
  88. //加载表单数据
  89. sql.Clear();
  90. sql.Append("select pr_code,nvl(pr_sendchecktype,'LineCode')pr_sendchecktype,pa_remark,pa_outboxcode,pa_prodcode,pa_salecode,pa_makecode,pa_sccode,nvl(pa_downstatus,0) pa_downstatus,pa_checkno,pa_status,pr_packrule,nvl(PR_CHECKCARTONW,'0') PR_CHECKCARTONW,pr_detail,pa_packageqty,nvl(pa_standardqty,0) pa_standardqty,nvl(pr_outboxinnerqty,0)pr_outboxinnerqty,pa_currentqty from package left join product on pa_prodcode=");
  91. sql.Append("pr_code where pa_outboxcode='" + pa_outboxcode.Text + "'");
  92. dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
  93. if (dt.Rows.Count > 0)
  94. {
  95. //记录该数据保证在修改不被允许的前提下能偶回复之前的值
  96. StandardQTY = decimal.Parse(dt.Rows[0]["pr_outboxinnerqty"].ToString());
  97. if (dt.Rows[0]["pa_salecode"].ToString() != "")
  98. {
  99. ms_salecode.Text = dt.Rows[0]["pa_salecode"].ToString();
  100. }
  101. BaseUtil.SetFormValue(this.Controls, dt);
  102. if (pa_standardqty.Text != "0")
  103. {
  104. pr_outboxinnerqty.Text = pa_standardqty.Text;
  105. }
  106. }
  107. else
  108. {
  109. pa_makecode.Text = "";
  110. }
  111. LoadCollectedNum();
  112. LoadCheckQTY();
  113. }
  114. private void LoadGridData()
  115. {
  116. //加载Grid数据
  117. dt = (DataTable)dh.ExecuteSql("select pa_outboxcode,pa_prodcode,pd_barcode,pd_innerqty,pd_makecode,pa_indate from packageDetail left join package on pa_id=pd_paid where pa_outboxcode='" + pa_outboxcode.Text + "'", "select");
  118. BaseUtil.FillDgvWithDataTable(PackageDetail, dt);
  119. if (dt.Rows.Count > 0)
  120. {
  121. string choose_pd_barcode = dt.Rows[0]["pd_barcode"].ToString();
  122. string choose_pd_makecode = dt.Rows[0]["pd_makecode"].ToString();
  123. PR_CHECKCARTONW = dh.getFieldDataByCondition("craftdetail left join craft on cr_id=cd_crid left join makeserial on ms_craftcode =cr_code and cr_prodcode = ms_prodcode", "nvl(cd_ifweigh,'0') cd_ifweigh", "ms_sncode='" + choose_pd_barcode + "' and ms_makecode='" + choose_pd_makecode + "' and cd_stepcode = '" + User.CurrentStepCode + "'").ToString();
  124. }
  125. //更新界面的采集数量
  126. pa_currentqty.Text = dh.getFieldDataByCondition("package", "pa_currentqty", "pa_outboxcode='" + pa_outboxcode.Text + "'").ToString();
  127. }
  128. private void Print_Click(object sender, EventArgs e)
  129. {
  130. if (PrintLabel.Items.Count != 0)
  131. {
  132. if (dh.getFieldDataByCondition("package", "pa_status", "pa_outboxcode='" + pa_outboxcode.Text + "'").ToString() == "1")
  133. {
  134. dh.ExecuteSql("update package set pa_printcount=pa_printcount+1 where pa_outboxcode='" + pa_outboxcode.Text + "'", "update");
  135. //doc = lbl.Documents.Open(PrintLabel.Text);
  136. if (Print.CodeSoft(Tag.ToString(), ref lbl, PrintLabel.Text, PrintLabel.SelectedValue.ToString(), PrintList.Text, pa_outboxcode.Text, int.Parse(PrintNum.Text), oMakeCode == "" ? pa_makecode.Text : oMakeCode, pr_code.Text, "卡通箱标", "0", out ErrorMessage))
  137. {
  138. OperateResult.AppendText(">>开始打印箱号" + pa_outboxcode.Text + "\n", Color.Black);
  139. }
  140. else
  141. {
  142. OperateResult.AppendText(ErrorMessage + "\n", Color.Red);
  143. }
  144. if (!AutoGenBoxCode.Checked)
  145. {
  146. pa_outboxcode.SelectAll();
  147. pa_outboxcode.Focus();
  148. }
  149. else
  150. {
  151. sn_code.Focus();
  152. sn_code.SelectAll();
  153. }
  154. }
  155. else OperateResult.AppendText(">>箱号" + pa_outboxcode.Text + "尚未封箱,请封箱后执行打印\n", Color.Red);
  156. }
  157. else OperateResult.AppendText(">>产品" + pr_code.Text + "未维护打印标签\n", Color.Red);
  158. }
  159. //加载工单信息和装箱明细信息
  160. private void pa_code_KeyDown(object sender, KeyEventArgs e)
  161. {
  162. if (e.KeyCode == Keys.Enter)
  163. {
  164. LoadData();
  165. LoadGridData();
  166. if (CheckOutBoxLength())
  167. {
  168. sn_code.Focus();
  169. }
  170. }
  171. }
  172. //输入序列号的回车事件
  173. private void barcode_KeyDown(object sender, KeyEventArgs e)
  174. {
  175. //当用户输入回车键的时候
  176. if (e.KeyCode == Keys.Enter)
  177. {
  178. if (LogicHandler.CheckStepAttribute(Tag.ToString(), User.UserSourceCode, out ErrorMessage))
  179. {
  180. dt = (DataTable)dh.ExecuteSql("select ms_status,ms_id,ms_makecode,ms_nextstepcode,ms_prodcode,ms_craftcode from makeserial where ms_sncode ='" + sn_code.Text + "' order by ms_id desc", "select");
  181. if (LogicHandler.CheckStepSNAndMacode("", User.UserSourceCode, sn_code.Text, User.UserCode, out oMakeCode, out oMsID, out ErrorMessage) || (dt.Rows.Count > 0 && dt.Rows[0]["ms_status"].ToString() == "2"))
  182. {
  183. if (oMsID == "" || oMsID == "null" || oMsID == "0")
  184. {
  185. oMsID = dt.Rows[0]["ms_id"].ToString();
  186. oMsStatus = dt.Rows[0]["ms_status"].ToString();
  187. oMakeCode = dt.Rows[0]["ms_makecode"].ToString();
  188. }
  189. if (oMsStatus == "2")
  190. {
  191. string prodcode = dt.Rows[0]["ms_prodcode"].ToString();
  192. string craftcode = dt.Rows[0]["ms_craftcode"].ToString();
  193. string craftstepcode = dh.getFieldDataByCondition("craft left join craftdetail on cr_id =cd_crid", "(cd_stepcode)", "cr_prodcode='" + prodcode + "' and cr_code='" + craftcode + "' and cd_stepcode='" + User.CurrentStepCode + "'").ToString();
  194. if (craftstepcode == "")
  195. {
  196. OperateResult.AppendText("工序" + User.CurrentStepCode + "不在途程" + craftcode + "内,不允许采集\n", Color.Red);
  197. return;
  198. }
  199. }
  200. string nextstepcode = dh.getFieldDataByCondition("makeserial", "ms_nextstepcode", "ms_id='" + oMsID + "'").ToString();
  201. if (nextstepcode != "" && nextstepcode != User.CurrentStepCode)
  202. {
  203. OperateResult.AppendText("当前序列号下一道工序" + nextstepcode + ",当前资源不允许采集\n", Color.Red);
  204. if (md.IsOpen)
  205. {
  206. md.SendOrder("M502_ON");
  207. }
  208. return;
  209. }
  210. PR_CHECKCARTONW = dh.getFieldDataByCondition("craftdetail left join craft on cr_id=cd_crid left join makeserial on ms_craftcode =cr_code and cr_prodcode = ms_prodcode", "nvl(cd_ifweigh,'0') cd_ifweigh", "ms_sncode='" + sn_code.Text + "' and ms_makecode='" + oMakeCode + "' and cd_stepcode = '" + User.CurrentStepCode + "'").ToString();
  211. //获取序列号信息
  212. sql.Clear();
  213. sql.Append("select nvl(ms_iostatus,0) ms_iostatus,pa_salecode,ms_salecode,ms_outno,ms_makecode,ms_prodcode,nvl(pa_downstatus,0) pa_downstatus,pa_sccode,pa_checkno,pr_packrule,");
  214. sql.Append("nvl(pr_outboxinnerqty,0)pr_outboxinnerqty,nvl(pr_sendchecktype,'LineCode')pr_sendchecktype from makeserial left join product on ms_prodcode=pr_code left join packagedetail ");
  215. sql.Append("on pd_barcode=ms_sncode left join package on pa_id =pd_paid where ms_id='" + oMsID + "'");
  216. dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
  217. string ms_makecode = "";
  218. string ms_prodcode = "";
  219. string ms_iostatus = "";
  220. string ms_outno = "";
  221. string ms_salecode_text = "";
  222. if (dt.Rows.Count > 0)
  223. {
  224. StandardQTY = decimal.Parse(dt.Rows[0]["pr_outboxinnerqty"].ToString());
  225. ms_makecode = dt.Rows[0]["ms_makecode"].ToString();
  226. ms_prodcode = dt.Rows[0]["ms_prodcode"].ToString();
  227. ms_iostatus = dt.Rows[0]["ms_iostatus"].ToString();
  228. ms_outno = dt.Rows[0]["ms_outno"].ToString();
  229. ms_salecode_text = dt.Rows[0]["ms_salecode"].ToString();
  230. if (locksalecode.Checked && ms_salecode.Text != "" && ms_salecode.Text != ms_salecode_text)
  231. {
  232. OperateResult.AppendText(">>序列号" + sn_code.Text + "所属订单号" + ms_salecode_text + "与界面订单号" + ms_salecode.Text + "不同,无法采集\n", Color.Red, sn_code);
  233. if (md.IsOpen)
  234. {
  235. md.SendOrder("M502_ON");
  236. }
  237. return;
  238. }
  239. BaseUtil.SetFormValue(this.Controls, dt);
  240. }
  241. if (dt.Rows[0]["ms_outno"].ToString() != "")
  242. {
  243. OperateResult.AppendText(">>序列号" + sn_code.Text + "已被出货单" + dt.Rows[0]["ms_outno"].ToString() + "采集,不允许操作\n", Color.Red, sn_code);
  244. if (md.IsOpen)
  245. {
  246. md.SendOrder("M502_ON");
  247. }
  248. return;
  249. }
  250. if (dt.Rows[0]["ms_iostatus"].ToString() != "0")
  251. {
  252. OperateResult.AppendText(">>序列号" + sn_code.Text + "已入库不允许采集\n", Color.Red, sn_code);
  253. if (md.IsOpen)
  254. {
  255. md.SendOrder("M502_ON");
  256. }
  257. return;
  258. }
  259. //保证箱内容量不会被重置
  260. if (pa_standardqty.Text != "0" && pa_standardqty.Text != "")
  261. {
  262. pr_outboxinnerqty.Text = pa_standardqty.Text;
  263. }
  264. if (pa_outboxcode.Text == "")
  265. {
  266. string boxcode = dh.getFieldDataByCondition("makeserial", "ms_outboxcode", "ms_id='" + oMsID + "'").ToString();
  267. //序列号存在箱号的情况下获取所有的装箱数据
  268. if (boxcode != "")
  269. {
  270. pa_outboxcode.Text = boxcode;
  271. pa_makecode.Text = "";
  272. LoadGridData();
  273. }
  274. else
  275. {
  276. //如果勾选了自动生成箱号,在封箱或者首次
  277. if (AutoGenBoxCode.Checked && (pa_status.Text == "1" || pa_status.Text == "" || pa_status.Text == "0"))
  278. pa_outboxcode.Text = LogicHandler.GetOutBoxCode("PACKAGE", ms_makecode, pr_code.Text, User.UserCode);
  279. }
  280. }
  281. if (pa_outboxcode.Text == "")
  282. {
  283. OperateResult.AppendText(">>箱号不能为空\n", Color.Red, sn_code);
  284. return;
  285. }
  286. //判断箱内总数必须大于0
  287. if (pr_outboxinnerqty.Text == "" || pr_outboxinnerqty.Text == "0")
  288. {
  289. OperateResult.AppendText(">>箱内容量必须大于0\n", Color.Red);
  290. return;
  291. }
  292. sql.Clear();
  293. sql.Append("select nvl(pa_iostatus,0)pa_iostatus,pa_outno,pa_mothercode,pa_type from package where pa_outboxcode='" + pa_outboxcode.Text + "'");
  294. dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
  295. string MotherBoxCode = "";
  296. if (dt.Rows.Count > 0)
  297. {
  298. if (dt.Rows[0]["pa_mothercode"].ToString() != "")
  299. {
  300. MotherBoxCode = dt.Rows[0]["pa_mothercode"].ToString();
  301. }
  302. if (dt.Rows[0]["pa_outno"].ToString() != "")
  303. {
  304. OperateResult.AppendText(">>卡通箱" + pa_outboxcode.Text + "已被出货单" + dt.Rows[0]["pa_outno"].ToString() + "采集,不允许操作\n", Color.Red, sn_code);
  305. if (md.IsOpen)
  306. {
  307. md.SendOrder("M502_ON");
  308. }
  309. return;
  310. }
  311. if (dt.Rows[0]["pa_iostatus"].ToString() != "0")
  312. {
  313. OperateResult.AppendText(">>卡通箱" + pa_outboxcode.Text + "处于入库状态,不允许操作\n", Color.Red, sn_code);
  314. if (md.IsOpen)
  315. {
  316. md.SendOrder("M502_ON");
  317. }
  318. return;
  319. }
  320. }
  321. //如果未勾选了取消录入
  322. if (!Cancel.Checked)
  323. {
  324. //判断序列号是否已经装箱
  325. string ms_outboxcode = dh.getFieldDataByCondition("makeserial", "ms_outboxcode", "ms_id='" + oMsID + "'").ToString();
  326. if (ms_outboxcode != "")
  327. {
  328. if (ms_outboxcode == pa_outboxcode.Text)
  329. {
  330. if (md.IsOpen)
  331. {
  332. md.SendOrder("M501_ON");
  333. }
  334. OperateResult.AppendText(">>序列号" + sn_code.Text + "已在本箱内\n", Color.Red, sn_code);
  335. }
  336. else
  337. {
  338. if (md.IsOpen)
  339. {
  340. md.SendOrder("M502_ON");
  341. }
  342. OperateResult.AppendText(">>序列号" + sn_code.Text + "已采集至箱" + ms_outboxcode + "\n", Color.Red, sn_code);
  343. }
  344. LoadData();
  345. }
  346. else
  347. {
  348. //满箱之后采集下一个之前自动清除内容,生成新的箱号
  349. if ((AutoGenBoxCode.Checked && pa_currentqty.Text != "" && pr_outboxinnerqty.Text == pa_currentqty.Text) || (AutoGenBoxCode.Checked && pa_status.Text == "1"))
  350. {
  351. pa_currentqty.Text = "";
  352. pa_outboxcode.Text = "";
  353. pa_status.Text = "0";
  354. BaseUtil.CleanDGVData(PackageDetail);
  355. pa_outboxcode.Text = LogicHandler.GetOutBoxCode("PACKAGE", ms_makecode, pr_code.Text, User.UserCode);
  356. }
  357. if (!CheckOutBoxLength())
  358. {
  359. return;
  360. }
  361. ////箱号不存在的情况
  362. if (LogicHandler.Packing(sn_code.Text, pa_outboxcode.Text, AutoGenBoxCode.Checked, "标准", User.UserSourceCode, User.UserCode, pr_outboxinnerqty.Text, Cancel.Checked, out oOutBoxCode, out ErrorMessage))
  363. {
  364. if (md.IsOpen)
  365. {
  366. md.SendOrder("M501_ON");
  367. }
  368. //提示正确返回时传递的信息
  369. if (ErrorMessage.Contains("AFTERSUCCESS"))
  370. OperateResult.AppendText(">>" + ErrorMessage + "\n");
  371. LastSncode = sn_code.Text;
  372. OperateResult.AppendText(">>序列号" + sn_code.Text + "采集成功!\n", Color.Green);
  373. LogicHandler.DoCommandLog(Tag.ToString(), User.UserCode, oMakeCode, User.UserLineCode, User.UserSourceCode, "卡通箱采集", "卡通箱" + pa_outboxcode.Text + "采集成功", sn_code.Text, "");
  374. //满箱更新状态为1
  375. LoadData();
  376. LoadGridData();
  377. LoadCheckQTY();
  378. dh.ExecuteSql("update packagedetail set pd_innerqty=(select pa_packageqty from package where pa_outboxcode='" + pa_outboxcode.Text + "') where pd_innerboxcode='" + pa_outboxcode.Text + "'", "update");
  379. if (MotherBoxCode != "")
  380. {
  381. dt = (DataTable)dh.ExecuteSql("select pa_mothercode,pa_type from package where pa_outboxcode='" + MotherBoxCode + "'", "select");
  382. //如果母箱号不为空,需要更新总数
  383. if (dt.Rows.Count > 0)
  384. {
  385. if (dt.Rows[0]["pa_type"].ToString() == "2")
  386. {
  387. string MotherCode2 = dt.Rows[0]["pa_mothercode"].ToString();
  388. //更新大箱数量
  389. dh.ExecuteSql("update package set PA_TOTALQTY=(select sum(pd_innerqty) from packagedetail left join package on pa_id=pd_paid where pa_outboxcode='" + MotherBoxCode + "') where pa_outboxcode='" + MotherBoxCode + "'", "update");
  390. //外层有栈板则更新栈板数量
  391. if (MotherCode2 != "")
  392. {
  393. dh.ExecuteSql("update packagedetail set pd_innerqty=(select sum(pd_innerqty) from packagedetail where pd_outboxcode='" + MotherBoxCode + "') where pd_innerboxcode='" + MotherBoxCode + "'", "update");
  394. dh.ExecuteSql("update package set PA_TOTALQTY=(select sum(pd_innerqty) from packagedetail left join package on pa_id=pd_paid where pa_outboxcode='" + MotherCode2 + "') where pa_outboxcode='" + MotherCode2 + "'", "update");
  395. }
  396. }
  397. if (dt.Rows[0]["pa_type"].ToString() == "3")
  398. {
  399. dh.ExecuteSql("update package set PA_TOTALQTY=(select sum(pd_innerqty) from packagedetail left join package on pa_id=pd_paid where pa_outboxcode='" + MotherBoxCode + "') where pa_outboxcode='" + MotherBoxCode + "'", "update");
  400. }
  401. }
  402. }
  403. //采集完后如果是第一个装的序列号,把序列号的NextStepCode赋值给箱号
  404. if (pa_currentqty.Text == "1")
  405. {
  406. dh.UpdateByCondition("package", "pa_nextstep='" + User.CurrentStepCode + "', PA_CURRENTSTEP = '" + User.CurrentStepCode + "'", "pa_outboxcode='" + pa_outboxcode.Text + "'");
  407. }
  408. if (int.Parse(pa_currentqty.Text == "" ? "0" : pa_currentqty.Text) == int.Parse(pr_outboxinnerqty.Text))
  409. {
  410. dh.UpdateByCondition("package", "pa_status=1,pa_packageqty=pa_currentqty,pa_totalqty=pa_currentqty", "pa_outboxcode='" + pa_outboxcode.Text + "'");
  411. OperateResult.AppendText(">>箱号" + pa_outboxcode.Text + "满箱采集完成,封箱成功\n", Color.Green);
  412. pa_status.Text = "1";
  413. pa_standardqty.Text = "";
  414. if (AutoPrint.Checked)
  415. Print_Click(new object(), new EventArgs());
  416. if (!CollecRemark.Checked)
  417. {
  418. if (!AutoGenBoxCode.Checked)
  419. {
  420. pa_outboxcode.SelectAll();
  421. pa_outboxcode.Focus();
  422. }
  423. else
  424. {
  425. sn_code.Focus();
  426. sn_code.SelectAll();
  427. }
  428. }
  429. else
  430. {
  431. pa_remark.SelectAll();
  432. pa_remark.Focus();
  433. }
  434. if (PR_CHECKCARTONW != "0")
  435. {
  436. OperateResult.AppendText(">>卡通箱" + pa_outboxcode.Text + "满箱处于称重工序,请在卡通箱称重界面进行称重打印\n", Color.Black, sn_code);
  437. return;
  438. }
  439. if (LogicHandler.OutBoxStepPass(pa_outboxcode.Text, ms_makecode, User.UserSourceCode, User.UserCode, "卡通箱:" + pa_outboxcode.Text + "整箱过站", "卡通箱整箱过站", out ErrorMessage))
  440. {
  441. dh.UpdateByCondition("package", "pa_nextstep='" + dh.getFieldDataByCondition("packagedetail left join makeserial on ms_sncode=pd_barcode and ms_makecode=pd_makecode", "max(ms_nextstepcode)", "pd_outboxcode='" + pa_outboxcode.Text + "'").ToString() + "', PA_CURRENTSTEP = '' ", "pa_outboxcode='" + pa_outboxcode.Text + "'");
  442. }
  443. else
  444. {
  445. OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red);
  446. }
  447. LoadCollectedNum();
  448. LoadCheckQTY();
  449. }
  450. sn_code.Clear();
  451. }
  452. else OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red, sn_code);
  453. }
  454. }
  455. //勾选了取消箱号先验证箱号存不存在,存在的话移除掉,重新加载一次数据
  456. else
  457. {
  458. if (LogicHandler.Packing(sn_code.Text, pa_outboxcode.Text, AutoGenBoxCode.Checked, "标准", User.UserSourceCode, User.UserCode, pr_outboxinnerqty.Text, Cancel.Checked, out oOutBoxCode, out ErrorMessage))
  459. {
  460. dh.UpdateByCondition("makeserial", "ms_outboxcode=''", "ms_id='" + oMsID + "'");
  461. dh.ExecuteSql("update packagedetail set pd_innerqty=(select pa_packageqty from package where pa_outboxcode='" + pa_outboxcode.Text + "') where pd_innerboxcode='" + pa_outboxcode.Text + "'", "update");
  462. //如果母箱号不为空,需要更新总数
  463. if (MotherBoxCode != "")
  464. {
  465. DataTable dt = (DataTable)dh.ExecuteSql("select pa_mothercode,pa_type from package where pa_outboxcode='" + MotherBoxCode + "'", "select");
  466. if (dt.Rows.Count > 0)
  467. {
  468. if (dt.Rows[0]["pa_type"].ToString() == "2")
  469. {
  470. string MotherCode2 = dt.Rows[0]["pa_mothercode"].ToString();
  471. //更新大箱数量
  472. dh.ExecuteSql("update package set PA_TOTALQTY=(select sum(pd_innerqty) from packagedetail left join package on pa_id=pd_paid where pa_outboxcode='" + MotherBoxCode + "') where pa_outboxcode='" + MotherBoxCode + "'", "update");
  473. //外层有栈板则更新栈板数量
  474. if (MotherCode2 != "")
  475. {
  476. dh.ExecuteSql("update packagedetail set pd_innerqty=(select sum(pd_innerqty) from packagedetail where pd_outboxcode='" + MotherBoxCode + "') where pd_innerboxcode='" + MotherBoxCode + "'", "update");
  477. dh.ExecuteSql("update package set PA_TOTALQTY=(select sum(pd_innerqty) from packagedetail left join package on pa_id=pd_paid where pa_outboxcode='" + MotherCode2 + "') where pa_outboxcode='" + MotherCode2 + "'", "update");
  478. }
  479. }
  480. if (dt.Rows[0]["pa_type"].ToString() == "3")
  481. {
  482. dh.ExecuteSql("update package set PA_TOTALQTY=(select sum(pd_innerqty) from packagedetail left join package on pa_id=pd_paid where pa_outboxcode='" + MotherBoxCode + "') where pa_outboxcode='" + MotherBoxCode + "'", "update");
  483. }
  484. }
  485. }
  486. LogicHandler.DoCommandLog(Tag.ToString(), User.UserCode, oMakeCode, User.UserLineCode, User.UserSourceCode, "卡通箱采集", "卡通箱" + pa_outboxcode.Text + "取消采集成功", sn_code.Text, "");
  487. LoadGridData();
  488. pa_status.Text = "0";
  489. OperateResult.AppendText(">>已从该箱中移除序列号" + sn_code.Text + "\n", Color.Green, sn_code);
  490. }
  491. else
  492. {
  493. OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red, sn_code);
  494. if (md.IsOpen)
  495. {
  496. md.SendOrder("M502_ON");
  497. }
  498. }
  499. }
  500. }
  501. else
  502. {
  503. OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red, sn_code);
  504. if (md.IsOpen)
  505. {
  506. md.SendOrder("M502_ON");
  507. }
  508. }
  509. }
  510. else OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red, sn_code);
  511. }
  512. }
  513. private void Clean_Click(object sender, EventArgs e)
  514. {
  515. OperateResult.Clear();
  516. }
  517. private void pr_code_TextChanged(object sender, EventArgs e)
  518. {
  519. LoadCheckQTY();
  520. dt = (DataTable)dh.ExecuteSql("select la_id,la_url,la_isdefault from label where la_prodcode='" + pr_code.Text + "' and la_templatetype='卡通箱标' and la_statuscode='AUDITED' order by la_isdefault", "select");
  521. PrintLabel.DataSource = dt;
  522. PrintLabel.DisplayMember = "la_url";
  523. PrintLabel.ValueMember = "la_id";
  524. }
  525. private void PackCollection_FormClosing(object sender, FormClosingEventArgs e)
  526. {
  527. BaseUtil.ClosePrint(lbl);
  528. dh.Dispose();
  529. }
  530. private void Packing_Click(object sender, EventArgs e)
  531. {
  532. if (dh.CheckExist("package", "pa_outboxcode='" + pa_outboxcode.Text + "' and nvl(pa_status,0)=0"))
  533. {
  534. string Seal = MessageBox.Show(this.ParentForm, "是否确认封箱?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question).ToString();
  535. if (Seal == "Yes")
  536. {
  537. OperateResult.AppendText(">>箱号" + pa_outboxcode.Text + "采集完成,手动封箱成功\n", Color.Green);
  538. dh.UpdateByCondition("package", "pa_status=1,pa_totalqty=pa_currentqty,pa_packageqty=pa_currentqty", "pa_outboxcode='" + pa_outboxcode.Text + "'");
  539. pa_status.Text = "1";
  540. pa_standardqty.Text = "";
  541. LogicHandler.DoCommandLog(Tag.ToString(), User.UserCode, pa_makecode.Text, User.UserLineCode, User.UserSourceCode, "装箱采集", "卡通箱" + pa_outboxcode.Text + "封箱成功", pa_outboxcode.Text, "");
  542. if (!CollecRemark.Checked)
  543. {
  544. if (!AutoGenBoxCode.Checked)
  545. {
  546. pa_outboxcode.SelectAll();
  547. pa_outboxcode.Focus();
  548. }
  549. else
  550. {
  551. sn_code.Focus();
  552. sn_code.SelectAll();
  553. }
  554. }
  555. else
  556. {
  557. pa_remark.SelectAll();
  558. pa_remark.Focus();
  559. }
  560. if (PR_CHECKCARTONW != "0")
  561. {
  562. OperateResult.AppendText(">>卡通箱" + pa_outboxcode.Text + "处于称重工序,请在卡通箱称重界面进行操作\n", Color.Black, sn_code);
  563. return;
  564. }
  565. if (LogicHandler.OutBoxStepPass(pa_outboxcode.Text, ms_makecode.Text, User.UserSourceCode, User.UserCode, "卡通箱:" + pa_outboxcode.Text + "整箱过站", "卡通箱整箱过站", out ErrorMessage))
  566. {
  567. dh.UpdateByCondition("package", "pa_nextstep='" + dh.getFieldDataByCondition("packagedetail left join makeserial on ms_sncode=pd_barcode and ms_makecode=pd_makecode", "max(ms_nextstepcode)", "pd_outboxcode='" + pa_outboxcode.Text + "'").ToString() + "', PA_CURRENTSTEP = '' ", "pa_outboxcode='" + pa_outboxcode.Text + "'");
  568. }
  569. else
  570. {
  571. OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red);
  572. }
  573. LoadCheckQTY();
  574. }
  575. }
  576. else OperateResult.AppendText(">>箱号" + pa_outboxcode.Text + "错误或者已封箱\n", Color.Red);
  577. }
  578. private void SendCheck_Click(object sender, EventArgs e)
  579. {
  580. if (dh.getFieldDataByCondition("package", "pa_status", "pa_outboxcode='" + pa_outboxcode.Text + "'").ToString() == "1")
  581. {
  582. DataTable dt = (DataTable)dh.ExecuteSql("select wm_concat(pa_outboxcode) pa_outboxcode from package where pa_checkno='" + ob_checkno.Text + "' and pa_status=0 ", "select");
  583. if (dt.Rows[0][0].ToString() != "")
  584. {
  585. OperateResult.AppendText(">>批次" + ob_checkno.Text + "存在箱号" + dt.Rows[0][0].ToString() + "未封箱,请先进行封箱\n", Color.Red);
  586. return;
  587. }
  588. sql.Clear();
  589. sql.Append("update oqcbatch set ob_status='UNCHECK' where ob_checkno ='" + ob_checkno.Text + "'");
  590. dh.ExecuteSql(sql.GetString(), "select");
  591. ob_nowcheckqty.Text = "";
  592. ob_batchqty.Text = "";
  593. ob_nowcheckqty.ForeColor = Color.Black;
  594. SendCheck.Enabled = false;
  595. OperateResult.AppendText(">>批次" + ob_checkno.Text + "送检成功\n", Color.Green);
  596. LogicHandler.InsertMakeProcess(LastSncode, oMakeCode, User.UserSourceCode, "手动送检", "手动送检成功", User.UserCode);
  597. //记录操作日志
  598. LogicHandler.DoCommandLog(Tag.ToString(), User.UserCode, pa_makecode.Text, User.UserLineCode, User.UserSourceCode, "手动送检", "手动送检成功", "", ob_checkno.Text);
  599. ob_checkno.Text = "";
  600. }
  601. else OperateResult.AppendText(">>必须封箱才能送检\n", Color.Red);
  602. }
  603. bool AutoCut;
  604. private void LoadCheckQTY()
  605. {
  606. sql.Clear();
  607. string condition = "";
  608. int nowcheckqty = int.Parse(ob_nowcheckqty.Text == "" ? "0" : ob_nowcheckqty.Text);
  609. int batchqty = int.Parse(ob_batchqty.Text == "" ? "0" : ob_batchqty.Text);
  610. if (nowcheckqty + 1 == batchqty && AutoCut)
  611. {
  612. condition = "and ob_status='UNCHECK' and ob_checkno='" + ob_checkno.Text + "'";
  613. }
  614. else
  615. {
  616. condition = "and ob_status='ENTERING' ";
  617. }
  618. if (pr_sendchecktype.Text == "SaleCode")
  619. {
  620. condition += " and ob_salecode='" + ms_salecode.Text + "'";
  621. }
  622. sql.Append("select ob_batchqty,ob_nowcheckqty,ob_checkno from oqcbatch where ");
  623. sql.Append("ob_linecode='" + User.UserLineCode + "' and ob_prodcode='" + pr_code.Text + "' and ");
  624. sql.Append("ob_stepcode='" + User.CurrentStepCode + "' " + condition);
  625. DataTable dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
  626. if (dt.Rows.Count > 0)
  627. {
  628. ob_batchqty.Text = dt.Rows[0]["ob_batchqty"].ToString();
  629. ob_nowcheckqty.Text = dt.Rows[0]["ob_nowcheckqty"].ToString();
  630. ob_checkno.Text = dt.Rows[0]["ob_checkno"].ToString();
  631. nowcheckqty = int.Parse(ob_nowcheckqty.Text == "" ? "0" : ob_nowcheckqty.Text);
  632. batchqty = int.Parse(ob_batchqty.Text == "" ? "0" : ob_batchqty.Text);
  633. if (nowcheckqty >= batchqty)
  634. {
  635. ob_nowcheckqty.ForeColor = Color.Red;
  636. OperateResult.AppendText(">>当前采集数量已达到送检数量\n", Color.Red);
  637. if (AutoCut)
  638. {
  639. OperateResult.AppendText(">>批次" + ob_checkno.Text + "自动断批\n", Color.Green);
  640. }
  641. }
  642. }
  643. else
  644. {
  645. ob_batchqty.Text = "";
  646. ob_nowcheckqty.Text = "";
  647. ob_checkno.Text = "";
  648. SendCheck.Enabled = false;
  649. }
  650. if (ob_batchqty.Text != "" && PR_CHECKCARTONW == "0")
  651. {
  652. SendCheck.Enabled = true;
  653. }
  654. else
  655. {
  656. SendCheck.Enabled = false;
  657. }
  658. }
  659. private void ob_checkno_TextChanged(object sender, EventArgs e)
  660. {
  661. if (ob_checkno.Text != "")
  662. {
  663. string Cut = dh.getFieldDataByCondition("product left join oqcbatch on ob_prodcode=pr_code", "pr_ifautocutcheckno", "ob_checkno='" + ob_checkno.Text + "'").ToString();
  664. if (Cut == "" || Cut == "0")
  665. AutoCut = false;
  666. else
  667. AutoCut = true;
  668. SendCheck.Enabled = true;
  669. }
  670. }
  671. //private void pr_outboxinnerqty_KeyDown(object sender, KeyEventArgs e)
  672. //{
  673. // if (e.KeyCode == Keys.Enter)
  674. // ResetPackQTY();
  675. //}
  676. //private void pr_outboxinnerqty_Leave(object sender, EventArgs e)
  677. //{
  678. // ResetPackQTY();
  679. //}
  680. //private void ResetPackQTY()
  681. //{
  682. // //数据不符合限制的时候保持原有值
  683. // int curretnqty = int.Parse(pa_currentqty.Text == "" ? "0" : pa_currentqty.Text);
  684. // if (!(int.Parse(pr_outboxinnerqty.Text) >= curretnqty))
  685. // {
  686. // pr_outboxinnerqty.Text = StandardQTY.ToString();
  687. // }
  688. // else
  689. // {
  690. // if (dh.CheckExist("package", "pa_outboxcode='" + pa_outboxcode.Text + "'"))
  691. // {
  692. // string checknostatus = dh.getFieldDataByCondition("oqcbatch", "ob_status", "ob_checkno='" + pa_checkno.Text + "'").ToString();
  693. // if (checknostatus == "" || checknostatus == "ENTERING")
  694. // {
  695. // if (pa_downstatus.Text == "0")
  696. // {
  697. // if (dh.CheckExist("source", "sc_code='" + pa_sccode.Text + "' and sc_stepcode='" + User.CurrentStepCode + "'"))
  698. // {
  699. // dh.UpdateByCondition("package", "pa_standardqty='" + pr_outboxinnerqty.Text + "'", "pa_outboxcode='" + pa_outboxcode.Text + "'");
  700. // LogicHandler.DoCommandLog(Tag.ToString(), User.UserCode, "", User.UserLineCode, User.UserSourceCode, "修改箱内容量", "原容量" + StandardQTY + ",修改为" + pr_outboxinnerqty.Text + "'", pa_outboxcode.Text, pa_checkno.Text);
  701. // return;
  702. // }
  703. // else
  704. // OperateResult.AppendText(">>箱号" + pa_outboxcode.Text + "当前所在工序不是登录岗位资源所在工序,不允许修改数量\n", Color.Red);
  705. // }
  706. // else
  707. // OperateResult.AppendText(">>箱号" + pa_outboxcode.Text + "处于下地状态,不允许修改标准容量\n", Color.Red);
  708. // }
  709. // else
  710. // OperateResult.AppendText(">>箱号" + pa_outboxcode.Text + "处于送检中,不允许修改标准容量\n", Color.Red);
  711. // }
  712. // else
  713. // OperateResult.AppendText(">>箱号" + pa_outboxcode.Text + "不存在,修改容量无效\n", Color.Red);
  714. // pr_outboxinnerqty.Text = StandardQTY.ToString();
  715. // }
  716. //}
  717. private void PrintLabel_SelectedValueChanged(object sender, EventArgs e)
  718. {
  719. if (PrintLabel.SelectedValue != null && PrintLabel.SelectedValue.ToString() != "System.Data.DataRowView")
  720. {
  721. string PrintNums = dh.getFieldDataByCondition("label", "la_printnos", "la_id='" + PrintLabel.SelectedValue.ToString() + "'").ToString();
  722. PrintNum.Text = (PrintNums == "" ? "1" : PrintNums);
  723. }
  724. }
  725. private void DeleteAll_Click(object sender, EventArgs e)
  726. {
  727. if (pa_outboxcode.Text == "")
  728. {
  729. OperateResult.AppendText(">>箱号不能为空\n", Color.Red);
  730. return;
  731. }
  732. string Delete = MessageBox.Show(this.ParentForm, "是否确认拆箱?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question).ToString();
  733. if (Delete == "Yes")
  734. {
  735. DataTable dt = (DataTable)dh.ExecuteSql("select nvl(pa_iostatus,0)pa_iostatus,pa_outno,pa_checkno,ob_status,pa_mothercode,nvl(pa_downstatus,0)pa_downstatus from package left join oqcbatch on pa_checkno=ob_checkno where pa_outboxcode='" + pa_outboxcode.Text + "'", "select");
  736. if (dt.Rows.Count > 0)
  737. {
  738. if (dt.Rows[0]["pa_outno"].ToString() != "")
  739. {
  740. OperateResult.AppendText(">>卡通箱" + pa_outboxcode.Text + "已被出货单" + dt.Rows[0]["pa_outno"].ToString() + "采集,不允许操作\n", Color.Red);
  741. return;
  742. }
  743. if (dt.Rows[0]["pa_iostatus"].ToString() != "0")
  744. {
  745. OperateResult.AppendText(">>卡通箱" + pa_outboxcode.Text + "处于入库状态,不允许操作\n", Color.Red);
  746. return;
  747. }
  748. if (dt.Rows[0]["pa_mothercode"].ToString() == "")
  749. {
  750. if (dt.Rows[0]["pa_downstatus"].ToString() == "0")
  751. {
  752. string ob_status = dt.Rows[0]["ob_status"].ToString();
  753. string pa_checkno = dt.Rows[0]["pa_checkno"].ToString();
  754. //不存在抽检批次或者还未检验可以拆解
  755. if (ob_status == "" || ob_status == "ENTERING" || ob_status == "UNCHECK")
  756. {
  757. sql.Clear();
  758. sql.Append("select pd_makecode,count(1) num from packagedetail left join makeserial ");
  759. sql.Append("on ms_sncode=pd_barcode and ms_makecode=pd_makecode where pd_outboxcode='" + pa_outboxcode.Text + "' group by pd_makecode");
  760. dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
  761. List<string> SQLS1 = new List<string>();
  762. for (int i = 0; i < dt.Rows.Count; i++)
  763. {
  764. string ma_code = dt.Rows[i]["pd_makecode"].ToString();
  765. string num = dt.Rows[i]["num"].ToString();
  766. SQLS1.Add("delete from makeprocess where mp_sncode in (select ms_sncode from makeserial where ms_outboxcode='" + pa_outboxcode.Text + "' and ms_makecode='" + ma_code + "') and mp_makecode='" + ma_code + "' and mp_stepcode='" + User.CurrentStepCode + "'");
  767. SQLS1.Add("delete from steppassed where sp_sncode in (select ms_sncode from makeserial where ms_outboxcode='" + pa_outboxcode.Text + "' and ms_makecode='" + ma_code + "') and sp_makecode='" + ma_code + "' and sp_stepcode='" + User.CurrentStepCode + "'");
  768. SQLS1.Add("update makecraftdetail set mcd_inqty=mcd_inqty-" + num + ",mcd_outqty=mcd_outqty-" + num + ",mcd_okqty=mcd_okqty-" + num + " where mcd_macode='" + ma_code + "' and mcd_stepcode='" + User.CurrentStepCode + "'");
  769. //扣减已完工数
  770. SQLS1.Add("update make set ma_madeqty=ma_madeqty-(select count(1) from makeserial where ms_outboxcode='" + pa_outboxcode.Text + "' and ms_makecode='" + ma_code + "' and ms_status=2) where ma_code='" + ma_code + "'");
  771. }
  772. if (pa_checkno != "")
  773. {
  774. SQLS1.Add("update makeserial set ms_checkno='' where ms_outboxcode='" + pa_outboxcode.Text + "'");
  775. SQLS1.Add("update oqcbatch set ob_nowcheckqty=ob_nowcheckqty-(select count(1) from oqcbatchdetail where obd_outboxcode='" + pa_outboxcode.Text + "') where ob_checkno='" + pa_checkno + "'");
  776. SQLS1.Add("delete from oqcbatchdetail where obd_outboxcode='" + pa_outboxcode.Text + "'");
  777. }
  778. //更新序列号状态
  779. SQLS1.Add("update makeserial set ms_status=1,ms_outboxcode='',ms_nextstepcode= (case when ms_nextstepcode='" + User.CurrentStepCode + "' then ms_nextstepcode else ms_stepcode end ),ms_paststep=replace(ms_paststep,'," + User.CurrentStepCode + "','') where ms_outboxcode='" + pa_outboxcode.Text + "'");
  780. //抽检批次不为空的时候进行移除
  781. dh.ExecuteSQLTran(SQLS1.ToArray());
  782. List<string> SQLS2 = new List<string>();
  783. //置空原箱
  784. SQLS2.Add("update package set pa_checkno='',pa_prodcode='',pa_packtype='',pa_salecode='',pa_packageqty=0,pa_totalqty=0,pa_currentqty=0,pa_status=0 where pa_outboxcode='" + pa_outboxcode.Text + "'");
  785. pa_status.Text = "0";
  786. //删除箱的明细
  787. SQLS2.Add("delete from packagedetail where pd_outboxcode='" + pa_outboxcode.Text + "'");
  788. dh.ExecuteSQLTran(SQLS2.ToArray());
  789. LogicHandler.DoCommandLog(Tag.ToString(), User.UserCode, pa_makecode.Text, User.UserLineCode, User.UserSourceCode, "卡通箱拆解", "成功", pa_outboxcode.Text, ob_checkno.Text);
  790. OperateResult.AppendText(">>箱号" + pa_outboxcode.Text + "成功拆解!\n", Color.Green);
  791. LoadGridData();
  792. LoadCheckQTY();
  793. }
  794. else OperateResult.AppendText(">>箱号" + pa_outboxcode.Text + "已送检,不允许解除\n", Color.Red);
  795. }
  796. else OperateResult.AppendText(">>箱号" + pa_outboxcode.Text + "已下地,不允许解除\n", Color.Red);
  797. }
  798. else OperateResult.AppendText(">>箱号" + pa_outboxcode.Text + "已装箱" + dt.Rows[0]["pa_mothercode"].ToString() + ",不允许解除\n", Color.Red);
  799. }
  800. else OperateResult.AppendText(">>箱号" + pa_outboxcode.Text + "不存在\n", Color.Red);
  801. }
  802. }
  803. private void OutBoxLength_KeyDown(object sender, KeyEventArgs e)
  804. {
  805. if (e.KeyCode == Keys.Enter)
  806. {
  807. try
  808. {
  809. if (OutBoxLength.Text != "")
  810. {
  811. int.Parse(OutBoxLength.Text);
  812. }
  813. BaseUtil.SetCacheData("OutBoxLength", OutBoxLength.Text);
  814. if (!AutoGenBoxCode.Checked)
  815. {
  816. pa_outboxcode.SelectAll();
  817. pa_outboxcode.Focus();
  818. }
  819. else
  820. {
  821. sn_code.Focus();
  822. }
  823. }
  824. catch (Exception)
  825. {
  826. OutBoxLength.Clear();
  827. MessageBox.Show("请输入正确的长度");
  828. }
  829. }
  830. }
  831. private bool CheckOutBoxLength()
  832. {
  833. //勾选了检验长度进行校验
  834. if (OutBoxLength.Text != "")
  835. {
  836. try
  837. {
  838. int.Parse(OutBoxLength.Text);
  839. }
  840. catch (Exception)
  841. {
  842. MessageBox.Show("请填写正确的箱号长度");
  843. return false;
  844. }
  845. if (pa_outboxcode.Text.Length != int.Parse(OutBoxLength.Text))
  846. {
  847. OperateResult.AppendText(">>箱号长度错误,请重新输入箱号\n", Color.Red);
  848. return false;
  849. }
  850. }
  851. if (PreFix.Text != "")
  852. {
  853. try
  854. {
  855. if (pa_outboxcode.Text.Substring(0, PreFix.Text.Length) != PreFix.Text)
  856. {
  857. OperateResult.AppendText(">>箱号前缀不匹配,请重新输入箱号\n", Color.Red);
  858. return false;
  859. }
  860. }
  861. catch (Exception)
  862. {
  863. OperateResult.AppendText(">>箱号前缀不匹配,请重新输入箱号\n", Color.Red);
  864. return false;
  865. }
  866. }
  867. return true;
  868. }
  869. private void LoadCollectedNum()
  870. {
  871. 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='" + ms_makecode.Text + "' and mcd_stepcode='" + User.CurrentStepCode + "'", "select");
  872. BaseUtil.SetFormValue(Controls, dt);
  873. }
  874. private void pa_remark_KeyDown(object sender, KeyEventArgs e)
  875. {
  876. if (Keys.Enter == e.KeyCode)
  877. {
  878. if (dh.CheckExist("package", "pa_outboxcode='" + pa_outboxcode.Text + "'"))
  879. {
  880. if (Remark_PreFix.Text != "")
  881. {
  882. try
  883. {
  884. if (pa_remark.Text.Substring(0, Remark_PreFix.Text.Length) != Remark_PreFix.Text)
  885. {
  886. OperateResult.AppendText(">>备注前缀不匹配,请重新输入备注信息\n", Color.Red);
  887. return;
  888. }
  889. }
  890. catch (Exception)
  891. {
  892. OperateResult.AppendText(">>备注前缀不匹配,请重新输入备注信息\n", Color.Red);
  893. return;
  894. }
  895. }
  896. if (!AllowRepeat.Checked)
  897. {
  898. DataTable dt = (DataTable)dh.ExecuteSql("select pa_outboxcode from package where pa_remark='" + pa_remark.Text.ToUpper() + "'", "select");
  899. if (dt.Rows.Count > 0)
  900. {
  901. OperateResult.AppendText(">>箱号" + dt.Rows[0][0].ToString() + "已采集关联信息" + pa_remark.Text + "\n", Color.Red);
  902. return;
  903. }
  904. }
  905. dh.UpdateByCondition("package", "pa_remark='" + pa_remark.Text.ToUpper() + "'", "pa_outboxcode='" + pa_outboxcode.Text + "'");
  906. OperateResult.AppendText(">>箱号" + pa_outboxcode.Text + "关联信息" + pa_remark.Text + "采集成功\n", Color.Green);
  907. pa_remark.Text = "";
  908. if (!AutoGenBoxCode.Checked)
  909. {
  910. pa_outboxcode.SelectAll();
  911. pa_outboxcode.Focus();
  912. }
  913. else
  914. {
  915. sn_code.Focus();
  916. }
  917. }
  918. else OperateResult.AppendText(">>请先采集箱内数据\n", Color.Red);
  919. }
  920. }
  921. private void PreFix_KeyDown(object sender, KeyEventArgs e)
  922. {
  923. if (e.KeyCode == Keys.Enter)
  924. {
  925. BaseUtil.SetCacheData("PreFix", PreFix.Text);
  926. if (!AutoGenBoxCode.Checked)
  927. {
  928. pa_outboxcode.SelectAll();
  929. pa_outboxcode.Focus();
  930. }
  931. else
  932. {
  933. sn_code.Focus();
  934. sn_code.SelectAll();
  935. }
  936. }
  937. }
  938. private void BuildServer_Click(object sender, EventArgs e)
  939. {
  940. if (!md.IsOpen)
  941. {
  942. md.IP = IP.Text;
  943. md.Port = Port.Text;
  944. if (md.Open())
  945. {
  946. BaseUtil.SetCacheData("IP", IP.Text);
  947. BaseUtil.SetCacheData("IPPort", Port.Text);
  948. OperateResult.AppendText(">>服务开启成功\n");
  949. }
  950. }
  951. else
  952. OperateResult.AppendText(">>服务已经开启\n");
  953. }
  954. private void CloseServer_Click(object sender, EventArgs e)
  955. {
  956. if (md.IsOpen)
  957. {
  958. md.Close();
  959. OperateResult.AppendText(">>服务关闭成功\n");
  960. }
  961. else
  962. OperateResult.AppendText(">>服务尚未开启\n");
  963. }
  964. private void Remark_PreFix_KeyDown(object sender, KeyEventArgs e)
  965. {
  966. if (e.KeyCode == Keys.Enter)
  967. {
  968. BaseUtil.SetCacheData("Remark_PreFix", Remark_PreFix.Text);
  969. if (CollecRemark.Checked)
  970. {
  971. pa_remark.SelectAll();
  972. pa_remark.Focus();
  973. }
  974. }
  975. }
  976. }
  977. }