Make_PackageCollectionWeigh.cs 50 KB

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