Make_GetReMakeSN.cs 27 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402
  1. using LabelManager2;
  2. using System;
  3. using System.Collections.Generic;
  4. using System.ComponentModel;
  5. using System.Data;
  6. using System.Drawing;
  7. using System.Linq;
  8. using System.Text;
  9. using System.Threading;
  10. using System.Windows.Forms;
  11. using UAS_MES.DataOperate;
  12. using UAS_MES.Entity;
  13. using UAS_MES.PublicForm;
  14. using UAS_MES.PublicMethod;
  15. namespace UAS_MES.Make
  16. {
  17. public partial class Make_GetReMakeSN : Form
  18. {
  19. //打印进程
  20. ApplicationClass lbl;
  21. //初始化打印进程
  22. Thread InitPrint;
  23. LogStringBuilder sql = new LogStringBuilder();
  24. AutoSizeFormClass asc = new AutoSizeFormClass();
  25. DataHelper dh;
  26. DataTable dt;
  27. Document doc;
  28. private System.DateTime[] indate;
  29. string ErrMessage;
  30. public Make_GetReMakeSN()
  31. {
  32. InitializeComponent();
  33. }
  34. private void InPrint()
  35. {
  36. try
  37. {
  38. lbl = new ApplicationClass();
  39. BaseUtil.WriteLbl();
  40. }
  41. catch (Exception ex)
  42. {
  43. OperateResult.AppendText("未正确安装CodeSoft软件\n", Color.Red);
  44. }
  45. }
  46. private void Make_GetReMakeSN_Load(object sender, EventArgs e)
  47. {
  48. ma_code.TableName = "make left join product on ma_prodcode=pr_code";
  49. ma_code.SelectField = "ma_code # 工单号,pr_code # 产品编号,ma_qty # 工单数量,pr_detail # 产品名称,pr_spec # 产品规格,ma_craftcode # 途程编号";
  50. ma_code.FormName = Name;
  51. ma_code.SetValueField = new string[] { "ma_code", "pr_code", "ma_qty", "pr_detail", "pr_spec", "ma_craftcode" };
  52. ma_code.Condition = "ma_kind='返工' and ma_statuscode='STARTED'";
  53. ma_code.DbChange += Ma_code_DbChange;
  54. ma_code.SetLockCheckBox(LockCheckBox);
  55. LockCheckBox.GetMakeCodeCtl(ma_code);
  56. OperateResult.AppendText(">>请输入返工工单号\n", Color.Black);
  57. asc.controllInitializeSize(this);
  58. InitPrint = new Thread(InPrint);
  59. SetLoadingWindow stw = new SetLoadingWindow(InitPrint, "初始化打印程序");
  60. BaseUtil.SetFormCenter(stw);
  61. stw.ShowDialog();
  62. sn_code.Focus();
  63. dh = SystemInf.dh;
  64. }
  65. private void Ma_code_DbChange(object sender, EventArgs e)
  66. {
  67. DataTable dt = ma_code.ReturnData;
  68. BaseUtil.SetFormValue(this.Controls, dt);
  69. }
  70. private void Make_GetReMakeSN_SizeChanged(object sender, EventArgs e)
  71. {
  72. asc.controlAutoSize(this);
  73. }
  74. private void pr_code_TextChanged(object sender, EventArgs e)
  75. {
  76. DataTable _dt = (DataTable)dh.ExecuteSql("select la_id,la_url,la_isdefault from label where la_prodcode='" + pr_code.Text + "' and la_templatetype='SN标签' and la_statuscode='AUDITED' order by la_isdefault", "select");
  77. PrintLabel.DataSource = _dt;
  78. PrintLabel.DisplayMember = "la_url";
  79. PrintLabel.ValueMember = "la_id";
  80. }
  81. private void sn_code_KeyDown(object sender, KeyEventArgs e)
  82. {
  83. if (e.KeyCode == Keys.Enter)
  84. {
  85. if (ma_code.Text != "")
  86. {
  87. //判断是否是途程第一道工序
  88. sql.Clear();
  89. sql.Append("select cd_id from craft left join craftdetail on cd_crid=cr_id where cr_code='" + ma_craftcode.Text + "' ");
  90. sql.Append("and cr_prodcode='" + pr_code.Text + "' and nvl(cd_firststep,0)<>0 and cd_stepcode='" + User.CurrentStepCode + "'");
  91. dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
  92. if (dt.Rows.Count > 0)
  93. {
  94. if (sn_code.Text != "")
  95. {
  96. //判断序列号是否有效
  97. string Msid = dh.getFieldDataByCondition("makeserial ", "max(ms_id)", "ms_sncode='" + sn_code.Text + "' and ms_makecode<>'" + ma_code.Text + "'").ToString();
  98. if (Msid != "")
  99. {
  100. //序列号信息
  101. sql.Clear();
  102. sql.Append("select ms_beforesn,ms_status,ms_makecode,ms_firstsn,ms_outboxcode,ms_nextmacode,ms_prodcode,ms_salecode,");
  103. sql.Append("MS_IMEI1,MS_MAC,MS_NETCODE,MS_MEID,ms_imei2,ms_imei3,ms_othid1,ms_othid2,ms_othid3");
  104. sql.Append(",MS_OTHCODE3,MS_OTHCODE2,MS_OTHCODE1,ms_bt,nvl(MS_DOWNSTATUS,0) MS_DOWNSTATUS from makeserial where ms_id='" + Msid + "'");
  105. DataTable SnInf = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
  106. string ms_prodcode = SnInf.Rows[0]["ms_prodcode"].ToString();
  107. string ms_salecode = SnInf.Rows[0]["ms_salecode"].ToString();
  108. string ms_beforesn = SnInf.Rows[0]["ms_beforesn"].ToString();
  109. string ms_makecode = SnInf.Rows[0]["ms_makecode"].ToString();
  110. string ms_status = SnInf.Rows[0]["ms_status"].ToString();
  111. string ms_outboxcode = SnInf.Rows[0]["ms_outboxcode"].ToString();
  112. //判断序列号是否已经被使用
  113. if (SnInf.Rows[0]["ms_nextmacode"].ToString() != "")
  114. {
  115. OperateResult.AppendText(">>序列号已经被工单号:" + SnInf.Rows[0]["ms_nextmacode"].ToString() + "使用\n", Color.Red, sn_code);
  116. return;
  117. }
  118. //判断序列号是否已经被下地
  119. if (SnInf.Rows[0]["MS_DOWNSTATUS"].ToString() != "0")
  120. {
  121. OperateResult.AppendText(">>序列号"+ sn_code.Text + "已被下地,不允许操作\n", Color.Red, sn_code);
  122. return;
  123. }
  124. //工单信息
  125. sql.Clear();
  126. sql.Append("select ma_salecode,nvl(ma_checksacode,0)ma_checksacode,ma_prodcode,ma_craftname,ma_inqty,ma_craftcode,ma_qty,nvl(ma_inqty,0) ma_inqty,");
  127. sql.Append("nvl(ma_scrapqty,0)ma_scrapqty,ma_id,nvl(ma_unlimitin,0) ma_unlimitin,ma_wccode,NVL(re_autodecom,0)");
  128. sql.Append("re_autodecom,nvl(re_ifsnok,0)re_ifsnok,re_code from make left join rework on ma_screcode=re_code where ");
  129. sql.Append("ma_code='" + ma_code.Text + "'and ma_kind='返工' and ma_statuscode='STARTED'");
  130. DataTable MaInf = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
  131. string ma_prodcode = MaInf.Rows[0]["ma_prodcode"].ToString();
  132. string ma_salecode = MaInf.Rows[0]["ma_salecode"].ToString();
  133. string re_autodecom = MaInf.Rows[0]["re_autodecom"].ToString();
  134. string re_ifsnok = MaInf.Rows[0]["re_ifsnok"].ToString();
  135. string ma_checksacode = MaInf.Rows[0]["ma_checksacode"].ToString();
  136. string re_code = MaInf.Rows[0]["re_code"].ToString();
  137. int ma_unlimitin = int.Parse(MaInf.Rows[0]["ma_unlimitin"].ToString());
  138. int ma_inqty = int.Parse(MaInf.Rows[0]["ma_inqty"].ToString());
  139. int ma_scrapqty = int.Parse(MaInf.Rows[0]["ma_scrapqty"].ToString());
  140. int ma_qty = int.Parse(MaInf.Rows[0]["ma_qty"].ToString());
  141. if (ma_prodcode != ms_prodcode)
  142. {
  143. OperateResult.AppendText(">>序列号所属产品" + ms_prodcode + "与返工工单产品不一致\n", Color.Red, sn_code);
  144. return;
  145. }
  146. if (ma_checksacode != "0")
  147. {
  148. if (ms_salecode != "" && ma_salecode != "" && ms_salecode != ma_salecode)
  149. {
  150. OperateResult.AppendText(">>序列号所属合同" + ms_salecode + "与返工工单合同不一致\n", Color.Red, sn_code);
  151. return;
  152. }
  153. }
  154. if (ms_outboxcode != "")
  155. {
  156. //string logout_confirm = MessageBox.Show(this, "序列号"+ sn_code.Text + "已装入卡通箱"+ ms_outboxcode + "是否确认返工","提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question).ToString();
  157. //if (logout_confirm != "Yes")
  158. //{
  159. // return;
  160. //}
  161. OperateResult.AppendText("序列号" + sn_code.Text + "已装入卡通箱" + ms_outboxcode + "不允许采集", Color.Red, sn_code);
  162. return;
  163. }
  164. if (ma_unlimitin == 0 && ma_inqty - ma_scrapqty + 1 > ma_qty)
  165. {
  166. OperateResult.AppendText(">>工单不允许超数投产\n", Color.Red, sn_code);
  167. return;
  168. }
  169. string Sn = sn_code.Text;
  170. if (re_ifsnok != "0")
  171. {
  172. if (ms_status == "3"&&dh.CheckExist("makebad","mb_sncode = '"+ sn_code.Text + "'and mb_makecode = '"+ ms_makecode + "' and mb_status = '0'"))
  173. {
  174. OperateResult.AppendText(">>序列号:"+ sn_code.Text + "处于不良状态,完成维修后才能归属至返工工单\n", Color.Red, sn_code);
  175. return;
  176. }
  177. }
  178. //if (ReWorkAsRelateTSN.Checked)
  179. //{
  180. // if (ms_beforesn != "")
  181. // {
  182. // Sn = ms_beforesn;
  183. // }
  184. // else
  185. // {
  186. // OperateResult.AppendText(">>序列号" + sn_code.Text + "不存在TSN\n", Color.Red, sn_code);
  187. // return;
  188. // }
  189. //}
  190. string netcode = "";
  191. string imeid = "";
  192. string imei1 = "";
  193. string imei2 = "";
  194. string imei3 = "";
  195. string othid1 = "";
  196. string othid2 = "";
  197. string othid3 = "";
  198. string mac = "";
  199. string bt = "";
  200. string othcode1 = "";
  201. string othcode2 = "";
  202. string othcode3 = "";
  203. if (ma_saveimei.Checked)
  204. {
  205. netcode = SnInf.Rows[0]["MS_NETCODE"].ToString();
  206. imeid = SnInf.Rows[0]["MS_MEID"].ToString();
  207. imei1 = SnInf.Rows[0]["MS_IMEI1"].ToString();
  208. imei2 = SnInf.Rows[0]["ms_imei2"].ToString();
  209. imei3 = SnInf.Rows[0]["ms_imei3"].ToString();
  210. othid1 = SnInf.Rows[0]["ms_othid1"].ToString();
  211. othid2 = SnInf.Rows[0]["ms_othid2"].ToString();
  212. othid3 = SnInf.Rows[0]["ms_othid3"].ToString();
  213. }
  214. if (ma_savemacbt.Checked)
  215. {
  216. mac = SnInf.Rows[0]["ms_mac"].ToString();
  217. bt = SnInf.Rows[0]["ms_bt"].ToString();
  218. othcode1 = SnInf.Rows[0]["MS_OTHCODE1"].ToString();
  219. othcode2 = SnInf.Rows[0]["MS_OTHCODE2"].ToString();
  220. othcode3 = SnInf.Rows[0]["MS_OTHCODE3"].ToString();
  221. }
  222. string craftcode = MaInf.Rows[0]["ma_craftcode"].ToString();
  223. string craftname = MaInf.Rows[0]["ma_craftname"].ToString();
  224. string firstsn = SnInf.Rows[0]["ms_firstsn"].ToString();
  225. //工作中心为空的时候取工单的工作中心
  226. string workcenter = User.WorkCenter;
  227. if (workcenter == "")
  228. workcenter = MaInf.Rows[0]["ma_wccode"].ToString();
  229. //工单合同为空的时候取序列号合同,更新合同回工单
  230. string salecode = MaInf.Rows[0]["ma_salecode"].ToString();
  231. List<string> SQLS = new List<string>();
  232. if (salecode == "")
  233. {
  234. salecode = SnInf.Rows[0]["ms_salecode"].ToString();
  235. SQLS.Add("update make set ma_salecode='" + salecode + "' where ma_id='" + ma_id.Text + "'");
  236. }
  237. //插入返工工单
  238. sql.Clear();
  239. sql.Append("insert into MakeSerial(ms_id,ms_code,ms_sncode,ms_prodcode,ms_indate,ms_wccode");
  240. sql.Append(",ms_craftcode,ms_craftname,ms_nextstepcode,ms_status,ms_makecode,ms_linecode");
  241. sql.Append(",ms_sourcecode,ms_maid,ms_firstsn,ms_salecode,ms_mac,ms_bt,ms_othcode1,ms_othcode2,");
  242. sql.Append("ms_othcode3,ms_netcode,ms_imei1,ms_imei2,ms_imei3,ms_meid,ms_othid1,ms_othid2,ms_othid3)");
  243. sql.Append("values(MakeSerial_seq.nextval,'" + Sn + "','" + Sn + "','" + pr_code.Text + "',");
  244. sql.Append("sysdate,'" + workcenter + "','" + craftcode + "','" + craftname + "','" + User.CurrentStepCode + "',");
  245. sql.Append("'0','" + ma_code.Text + "','" + User.UserLineCode + "','" + User.UserSourceCode + "','" + ma_id.Text + "',");
  246. sql.Append("'" + firstsn + "','" + salecode + "','" + mac + "','" + bt + "','" + othcode1 + "','" + othcode2 + "','" + othcode3 + "',");
  247. sql.Append("'" + netcode + "','" + imei1 + "','" + imei2 + "','" + imei3 + "','" + imeid + "','" + othid1 + "','" + othid2 + "','" + othid3 + "')");
  248. SQLS.Add(sql.GetString());
  249. //更新工单数量+1
  250. SQLS.Add("update make set ma_inqty=nvl(ma_inqty,0)+1 where ma_id='" + ma_id.Text + "'");
  251. //更新该序列号的所属工单为返工工单
  252. SQLS.Add("update makeserial set ms_nextmacode='" + ma_code.Text + "' where ms_id='" + Msid + "'");
  253. if (ms_outboxcode != "")
  254. {
  255. string pamothercode = dh.getFieldDataByCondition("package", "pa_mothercode", "pa_outboxcode='" + ms_outboxcode + "'").ToString();
  256. //如果已装栈板从栈板解除
  257. if (pamothercode != "")
  258. {
  259. sql.Clear();
  260. sql.Append("insert into packagebackupdetail(pbd_id,pbd_paid,pbd_outboxcode,pbd_innerboxcode,pbd_barcode,pbd_innerqty,pbd_prodcode,pbd_makecode,pbd_buildate,pbd_ymd)");
  261. sql.Append("select pd_id,pd_paid,pd_outboxcode,pd_innerboxcode,pd_barcode,pd_innerqty,pd_prodcode,pd_makecode,pd_builddate,pd_ymd from packagedetail where ");
  262. sql.Append("pd_outboxcode='" + pamothercode + "' and pd_innerboxcode='" + ms_outboxcode + "'");
  263. SQLS.Add(sql.GetString());
  264. SQLS.Add("delete from packagedetail where pd_outboxcode='" + pamothercode + "' and pd_innerboxcode='" + ms_outboxcode + "'");
  265. DataTable dt = dh.getFieldsDatasByCondition("packagedetail left join package on pa_id=pd_paid", new string[] { "nvl(sum(pd_innerqty),0)", "count(1)" }, "pa_outboxcode='" + pamothercode + "'");
  266. string totalqty = dt.Rows[0][0].ToString();
  267. string currentqty = dt.Rows[0][1].ToString();
  268. SQLS.Add("update package set PA_TOTALQTY='" + totalqty + "',pa_packageqty='" + currentqty + "',pa_currentqty='" + currentqty + "' where pa_outboxcode='" + pamothercode + "'");
  269. }
  270. //备份和删除卡通箱明细
  271. sql.Clear();
  272. sql.Append("insert into packagebackup(pab_id,pab_prodcode,pab_outboxcode,pab_packdate,pab_level,pab_packageqty,pab_totalqty,pab_makecode,pab_status,pab_indate,pab_salecode,pab_printcount,pab_custcode,pab_type,");
  273. sql.Append("pab_weight,pab_currentqty,pab_standardqty,pab_packtype,pab_checkno,pab_downstatus,pab_sccode,pab_ymd,pab_mothercode,pab_currentstep,pab_nextstep,pab_outno,pab_iostatus,pab_remark) ");
  274. sql.Append("select pa_id,pa_prodcode,pa_outboxcode,pa_packdate,pa_level,pa_packageqty,pa_totalqty,pa_makecode,pa_status,pa_indate,pa_salecode,pa_printcount,pa_custcode,pa_type,pa_weight,pa_currentqty,");
  275. sql.Append("pa_standardqty,pa_packtype,pa_checkno,pa_downstatus,pa_sccode,pa_ymd,pa_mothercode,pa_currentstep,pa_nextstep,pa_outno,pa_iostatus,pa_remark from package where pa_outboxcode='" + ms_outboxcode + "'");
  276. SQLS.Add(sql.GetString());
  277. SQLS.Add("delete from package where pa_outboxcode='" + ms_outboxcode + "'");
  278. sql.Clear();
  279. sql.Append("insert into packagebackupdetail(pbd_id,pbd_paid,pbd_outboxcode,pbd_innerboxcode,pbd_barcode,pbd_innerqty,pbd_prodcode,pbd_makecode,pbd_buildate,pbd_ymd)");
  280. sql.Append("select pd_id,pd_paid,pd_outboxcode,pd_innerboxcode,pd_barcode,pd_innerqty,pd_prodcode,pd_makecode,pd_builddate,pd_ymd from packagedetail where ");
  281. sql.Append("pd_outboxcode='" + ms_outboxcode + "'");
  282. SQLS.Add(sql.GetString());
  283. SQLS.Add("delete from packagedetail where pd_outboxcode='" + ms_outboxcode + "' ");
  284. }
  285. sql.Clear();
  286. sql.Append("update makebad set mb_makecode='" + ms_makecode + "' where mb_sncode ='" + sn_code.Text + "' and mb_status=0");
  287. SQLS.Add(sql.GetString());
  288. if (re_autodecom != "0")
  289. {
  290. //sql.Clear();
  291. //sql.Append("select cm_makecode,cm_soncode,cm_barcode from craftmaterial left join makeserial on ms_makecode=");
  292. //sql.Append("cm_makecode and ms_sncode=cm_sncode and ms_prodcode=cm_maprodcode where ms_id='" + Msid + "'");
  293. //DataTable dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
  294. //string cm_makecode = "";
  295. //string cm_soncode = "";
  296. //string cm_barcode = "";
  297. //if (dt.Rows.Count > 0)
  298. //{
  299. // cm_makecode = dt.Rows[0]["cm_makecode"].ToString();
  300. // cm_soncode = dt.Rows[0]["cm_soncode"].ToString();
  301. // cm_barcode = dt.Rows[0]["cm_barcode"].ToString();
  302. //}
  303. sql.Clear();
  304. sql.Append("update craftmaterial set cm_status=-1,cm_dropcode='" + re_code + "',cm_dropman='" + User.UserCode + "',cm_dropdate=sysdate where ");
  305. sql.Append("cm_firstsn='" + firstsn + "' and nvl(cm_status,0)=0 and exists (select 1 from makesndecompose ");
  306. sql.Append("where msd_recode='" + re_code + "' and msd_fsoncode=cm_fsoncode and msd_stepcode=cm_stepcode)");
  307. SQLS.Add(sql.GetString());
  308. //TSN失效
  309. //sql.Clear();
  310. //sql.Append("update makeserial set ms_nextmacode='' where ms_nextmacode='" + cm_makecode + "'");
  311. //sql.Append(" and ms_sncode='" + cm_barcode + "' and ms_prodcode='" + cm_soncode + "' ");
  312. sql.Clear();
  313. sql.Append("update makeserial set ms_nextmacode='' where ms_id in (select a.ms_id from makeserial B INNER JOIN CRAFTMATERIAL ON cm_firstsn=B.ms_firstsn ");
  314. sql.Append("inner join makeserial a on cm_barcode=A.ms_sncode and cm_soncode=A.ms_prodcode inner join makesndecompose on msd_fsoncode=cm_fsoncode and msd_stepcode=cm_stepcode ");
  315. sql.Append("AND A.MS_NEXTMACODE=cm_makecode where b.ms_id='"+ Msid + "' and msd_recode='"+ re_code + "')");
  316. SQLS.Add(sql.GetString());
  317. }
  318. dh.ExecuteSQLTran(SQLS.ToArray());
  319. //if (ReWorkAsRelateTSN.Checked)
  320. //{
  321. // dh.ExecuteSql("update makeserial set ms_nextmacode='" + ma_code.Text + "' where ms_sncode='" + ms_beforesn + "' and ms_nextmacode='" + ms_makecode + "'", "update");
  322. //}
  323. OperateResult.AppendText(">>序列号" + sn_code.Text + "归属工单" + ma_code.Text + "成功。\n", Color.Green);
  324. LogicHandler.DoCommandLog(Tag.ToString(), User.UserCode, ma_code.Text, User.UserLineCode, User.UserSourceCode, "返工信息采集", "序列号归属成功", sn_code.Text, "");
  325. getsnqty.Text = dh.getFieldDataByCondition("makeserial ", "count(1)", "ms_makecode='" + ma_code.Text + "'").ToString();
  326. if (AutoPrint.Checked)
  327. {
  328. if (PrintLabel.Items.Count != 0)
  329. {
  330. OperateResult.AppendText(">>打印序列号" + sn_code.Text + "\n", Color.Black);
  331. //doc = lbl.Documents.Open(PrintLabel.Text);
  332. if (!Print.CodeSoft(Tag.ToString(), ref lbl, PrintLabel.Text, PrintLabel.SelectedValue.ToString(), PrinterList.Text, sn_code.Text, int.Parse(PrintNum.Text), ma_code.Text, pr_code.Text, "SN标签", "0", out ErrMessage))
  333. {
  334. OperateResult.AppendText(ErrMessage + "\n", Color.Red);
  335. return;
  336. }
  337. dh.UpdateByCondition("makeserial", "ms_printcount=nvl(ms_printcount,0)+1", "ms_sncode='" + sn_code.Text + "'");
  338. }
  339. else OperateResult.AppendText(">>" + pr_code.Text + "未维护标签\n", Color.Black);
  340. }
  341. sn_code.Clear();
  342. }
  343. else OperateResult.AppendText(">>序列号" + sn_code.Text + "不存在或者已绑定工单\n", Color.Red, sn_code);
  344. }
  345. else OperateResult.AppendText(">>序列号不允许为空\n", Color.Red, sn_code);
  346. }
  347. else OperateResult.AppendText(">>该岗位资源对应的工序不是当前返工工单途程中的第一道工序,请切换资源编号\n", Color.Red, sn_code);
  348. }
  349. else OperateResult.AppendText(">>工单号不允许为空\n", Color.Red, sn_code);
  350. }
  351. }
  352. private void ma_code_UserControlTextChanged(object sender, EventArgs e)
  353. {
  354. if (ma_code.Text.Length >= 5)
  355. {
  356. if (dh.CheckExist("make", "ma_kind='返工' and ma_statuscode='STARTED' and ma_code='" + ma_code.Text + "'"))
  357. {
  358. sql.Clear();
  359. sql.Append("select ma_id,ma_craftcode,ma_code,pr_code,pr_detail,pr_spec,ma_qty,nvl(ma_savemacbt,0) ma_savemacbt,nvl(ma_saveimei, 0)");
  360. sql.Append("ma_saveimei from make left join product on ma_prodcode=pr_code where ma_code='" + ma_code.Text + "'");
  361. dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
  362. BaseUtil.SetFormValue(this.Controls, dt);
  363. if (dt.Rows[0]["ma_saveimei"].ToString() != "0")
  364. {
  365. ma_saveimei.Checked = true;
  366. }
  367. if (dt.Rows[0]["ma_savemacbt"].ToString() != "0")
  368. {
  369. ma_savemacbt.Checked = true;
  370. }
  371. }
  372. }
  373. }
  374. private void PrintLabel_SelectedValueChanged(object sender, EventArgs e)
  375. {
  376. if (PrintLabel.SelectedValue != null && PrintLabel.SelectedValue.ToString() != "System.Data.DataRowView")
  377. {
  378. string PrintNums = dh.getFieldDataByCondition("label", "la_printnos", "la_id='" + PrintLabel.SelectedValue.ToString() + "'").ToString();
  379. PrintNum.Text = (PrintNums == "" ? "1" : PrintNums);
  380. }
  381. }
  382. }
  383. }