Make_GetReMakeSN.cs 21 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348
  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 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. sql.Clear();
  120. 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,");
  121. sql.Append("nvl(ma_scrapqty,0)ma_scrapqty,ma_id,nvl(ma_unlimitin,0) ma_unlimitin,ma_wccode,NVL(re_autodecom,0)");
  122. sql.Append("re_autodecom,re_code from make left join rework on ma_screcode=re_code where ");
  123. sql.Append("ma_code='" + ma_code.Text + "'and ma_kind='返工' and ma_statuscode='STARTED'");
  124. DataTable MaInf = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
  125. string ma_prodcode = MaInf.Rows[0]["ma_prodcode"].ToString();
  126. string ma_salecode = MaInf.Rows[0]["ma_salecode"].ToString();
  127. string re_autodecom = MaInf.Rows[0]["re_autodecom"].ToString();
  128. string ma_checksacode = MaInf.Rows[0]["ma_checksacode"].ToString();
  129. string re_code = MaInf.Rows[0]["re_code"].ToString();
  130. int ma_unlimitin = int.Parse(MaInf.Rows[0]["ma_unlimitin"].ToString());
  131. int ma_inqty = int.Parse(MaInf.Rows[0]["ma_inqty"].ToString());
  132. int ma_scrapqty = int.Parse(MaInf.Rows[0]["ma_scrapqty"].ToString());
  133. int ma_qty = int.Parse(MaInf.Rows[0]["ma_qty"].ToString());
  134. if (ma_prodcode != ms_prodcode)
  135. {
  136. OperateResult.AppendText(">>序列号所属产品" + ms_prodcode + "与返工工单产品不一致\n", Color.Red, sn_code);
  137. return;
  138. }
  139. if (ma_checksacode != "0")
  140. {
  141. if (ms_salecode != "" && ma_salecode != "" && ms_salecode != ma_salecode)
  142. {
  143. OperateResult.AppendText(">>序列号所属合同" + ms_salecode + "与返工工单合同不一致\n", Color.Red, sn_code);
  144. return;
  145. }
  146. }
  147. if (ma_unlimitin == 0 && ma_inqty - ma_scrapqty + 1 > ma_qty)
  148. {
  149. OperateResult.AppendText(">>工单不允许超数投产\n", Color.Red, sn_code);
  150. return;
  151. }
  152. string Sn = sn_code.Text;
  153. //if (ReWorkAsRelateTSN.Checked)
  154. //{
  155. // if (ms_beforesn != "")
  156. // {
  157. // Sn = ms_beforesn;
  158. // }
  159. // else
  160. // {
  161. // OperateResult.AppendText(">>序列号" + sn_code.Text + "不存在TSN\n", Color.Red, sn_code);
  162. // return;
  163. // }
  164. //}
  165. string netcode = "";
  166. string imeid = "";
  167. string imei1 = "";
  168. string imei2 = "";
  169. string imei3 = "";
  170. string othid1 = "";
  171. string othid2 = "";
  172. string othid3 = "";
  173. string mac = "";
  174. string bt = "";
  175. string othcode1 = "";
  176. string othcode2 = "";
  177. string othcode3 = "";
  178. if (ma_saveimei.Checked)
  179. {
  180. netcode = SnInf.Rows[0]["MS_NETCODE"].ToString();
  181. imeid = SnInf.Rows[0]["MS_MEID"].ToString();
  182. imei1 = SnInf.Rows[0]["MS_IMEI1"].ToString();
  183. imei2 = SnInf.Rows[0]["ms_imei2"].ToString();
  184. imei3 = SnInf.Rows[0]["ms_imei3"].ToString();
  185. othid1 = SnInf.Rows[0]["ms_othid1"].ToString();
  186. othid2 = SnInf.Rows[0]["ms_othid2"].ToString();
  187. othid3 = SnInf.Rows[0]["ms_othid3"].ToString();
  188. }
  189. if (ma_savemacbt.Checked)
  190. {
  191. mac = SnInf.Rows[0]["ms_mac"].ToString();
  192. bt = SnInf.Rows[0]["ms_bt"].ToString();
  193. othcode1 = SnInf.Rows[0]["MS_OTHCODE1"].ToString();
  194. othcode2 = SnInf.Rows[0]["MS_OTHCODE2"].ToString();
  195. othcode3 = SnInf.Rows[0]["MS_OTHCODE3"].ToString();
  196. }
  197. string craftcode = MaInf.Rows[0]["ma_craftcode"].ToString();
  198. string craftname = MaInf.Rows[0]["ma_craftname"].ToString();
  199. string firstsn = SnInf.Rows[0]["ms_firstsn"].ToString();
  200. //工作中心为空的时候取工单的工作中心
  201. string workcenter = User.WorkCenter;
  202. if (workcenter == "")
  203. workcenter = MaInf.Rows[0]["ma_wccode"].ToString();
  204. //工单合同为空的时候取序列号合同,更新合同回工单
  205. string salecode = MaInf.Rows[0]["ma_salecode"].ToString();
  206. List<string> SQLS = new List<string>();
  207. if (salecode == "")
  208. {
  209. salecode = SnInf.Rows[0]["ms_salecode"].ToString();
  210. SQLS.Add("update make set ma_salecode='" + salecode + "' where ma_id='" + ma_id.Text + "'");
  211. }
  212. //插入返工工单
  213. sql.Clear();
  214. sql.Append("insert into MakeSerial(ms_id,ms_code,ms_sncode,ms_prodcode,ms_indate,ms_wccode");
  215. sql.Append(",ms_craftcode,ms_craftname,ms_nextstepcode,ms_status,ms_makecode,ms_linecode");
  216. sql.Append(",ms_sourcecode,ms_maid,ms_firstsn,ms_salecode,ms_mac,ms_bt,ms_othcode1,ms_othcode2,");
  217. sql.Append("ms_othcode3,ms_netcode,ms_imei1,ms_imei2,ms_imei3,ms_meid,ms_othid1,ms_othid2,ms_othid3)");
  218. sql.Append("values(MakeSerial_seq.nextval,'" + Sn + "','" + Sn + "','" + pr_code.Text + "',");
  219. sql.Append("sysdate,'" + workcenter + "','" + craftcode + "','" + craftname + "','" + User.CurrentStepCode + "',");
  220. sql.Append("'0','" + ma_code.Text + "','" + User.UserLineCode + "','" + User.UserSourceCode + "','" + ma_id.Text + "',");
  221. sql.Append("'" + firstsn + "','" + salecode + "','" + mac + "','" + bt + "','" + othcode1 + "','" + othcode2 + "','" + othcode3 + "',");
  222. sql.Append("'" + netcode + "','" + imei1 + "','" + imei2 + "','" + imei3 + "','" + imeid + "','" + othid1 + "','" + othid2 + "','" + othid3 + "')");
  223. SQLS.Add(sql.GetString());
  224. //更新工单数量+1
  225. SQLS.Add("update make set ma_inqty=nvl(ma_inqty,0)+1 where ma_id='" + ma_id.Text + "'");
  226. //更新该序列号的所属工单为返工工单
  227. SQLS.Add("update makeserial set ms_nextmacode='" + ma_code.Text + "' where ms_id='" + Msid + "'");
  228. if (ms_outboxcode != "")
  229. {
  230. //更新箱号失效
  231. sql.Clear();
  232. sql.Append("update package set pa_status=-1 where pa_outboxcode='" + ms_outboxcode + "' and pa_status<>-1");
  233. SQLS.Add(sql.GetString());
  234. }
  235. sql.Clear();
  236. sql.Append("update makebad set mb_makecode='" + ms_makecode + "' where mb_sncode ='" + sn_code.Text + "' and mb_status=0");
  237. SQLS.Add(sql.GetString());
  238. if (re_autodecom != "0")
  239. {
  240. sql.Clear();
  241. sql.Append("select cm_makecode,cm_soncode,cm_barcode from craftmaterial left join makeserial on ms_makecode=");
  242. sql.Append("cm_makecode and ms_sncode=cm_sncode and ms_prodcode=cm_maprodcode where ms_id='" + Msid + "'");
  243. DataTable dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
  244. string cm_makecode = "";
  245. string cm_soncode = "";
  246. string cm_barcode = "";
  247. if (dt.Rows.Count > 0)
  248. {
  249. cm_makecode = dt.Rows[0]["cm_makecode"].ToString();
  250. cm_soncode = dt.Rows[0]["cm_soncode"].ToString();
  251. cm_barcode = dt.Rows[0]["cm_barcode"].ToString();
  252. }
  253. sql.Clear();
  254. sql.Append("update craftmaterial set cm_status=-1,cm_dropcode='" + re_code + "',cm_dropman='" + User.UserCode + "',cm_dropdate=sysdate where ");
  255. sql.Append("cm_firstsn='" + firstsn + "' and nvl(cm_status,0)=0 and exists (select 1 from makesndecompose ");
  256. sql.Append("where msd_recode='" + re_code + "' and msd_fsoncode=cm_fsoncode and msd_stepcode=cm_stepcode)");
  257. SQLS.Add(sql.GetString());
  258. //TSN失效
  259. sql.Clear();
  260. sql.Append("update makeserial set ms_nextmacode='' where ms_nextmacode='" + cm_makecode + "'");
  261. sql.Append(" and ms_sncode='" + cm_barcode + "' and ms_prodcode='" + cm_soncode + "' ");
  262. SQLS.Add(sql.GetString());
  263. }
  264. dh.ExecuteSQLTran(SQLS.ToArray());
  265. //if (ReWorkAsRelateTSN.Checked)
  266. //{
  267. // dh.ExecuteSql("update makeserial set ms_nextmacode='" + ma_code.Text + "' where ms_sncode='" + ms_beforesn + "' and ms_nextmacode='" + ms_makecode + "'", "update");
  268. //}
  269. OperateResult.AppendText(">>序列号" + sn_code.Text + "归属工单" + ma_code.Text + "成功。\n", Color.Green);
  270. LogicHandler.DoCommandLog(Tag.ToString(), User.UserCode, ma_code.Text, User.UserLineCode, User.UserSourceCode, "返工信息采集", "序列号归属成功", sn_code.Text, "");
  271. getsnqty.Text = dh.getFieldDataByCondition("makeserial ", "count(1)", "ms_makecode='" + ma_code.Text + "'").ToString();
  272. if (AutoPrint.Checked)
  273. {
  274. if (PrintLabel.Items.Count != 0)
  275. {
  276. OperateResult.AppendText(">>打印序列号" + sn_code.Text + "\n", Color.Black);
  277. //doc = lbl.Documents.Open(PrintLabel.Text);
  278. 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))
  279. {
  280. OperateResult.AppendText(ErrMessage + "\n", Color.Red);
  281. return;
  282. }
  283. dh.UpdateByCondition("makeserial", "ms_printcount=nvl(ms_printcount,0)+1", "ms_sncode='" + sn_code.Text + "'");
  284. }
  285. else OperateResult.AppendText(">>" + pr_code.Text + "未维护标签\n", Color.Black);
  286. }
  287. sn_code.Clear();
  288. }
  289. else OperateResult.AppendText(">>序列号" + sn_code.Text + "不存在或者已绑定工单\n", Color.Red, sn_code);
  290. }
  291. else OperateResult.AppendText(">>序列号不允许为空\n", Color.Red, sn_code);
  292. }
  293. else OperateResult.AppendText(">>该岗位资源对应的工序不是当前返工工单途程中的第一道工序,请切换资源编号\n", Color.Red, sn_code);
  294. }
  295. else OperateResult.AppendText(">>工单号不允许为空\n", Color.Red, sn_code);
  296. }
  297. }
  298. private void ma_code_UserControlTextChanged(object sender, EventArgs e)
  299. {
  300. if (ma_code.Text.Length >= 5)
  301. {
  302. if (dh.CheckExist("make", "ma_kind='返工' and ma_statuscode='STARTED' and ma_code='" + ma_code.Text + "'"))
  303. {
  304. sql.Clear();
  305. 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)");
  306. sql.Append("ma_saveimei from make left join product on ma_prodcode=pr_code where ma_code='" + ma_code.Text + "'");
  307. dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
  308. BaseUtil.SetFormValue(this.Controls, dt);
  309. if (dt.Rows[0]["ma_saveimei"].ToString() != "0")
  310. {
  311. ma_saveimei.Checked = true;
  312. }
  313. if (dt.Rows[0]["ma_savemacbt"].ToString() != "0")
  314. {
  315. ma_savemacbt.Checked = true;
  316. }
  317. }
  318. }
  319. }
  320. private void PrintLabel_SelectedValueChanged(object sender, EventArgs e)
  321. {
  322. if (PrintLabel.SelectedValue != null && PrintLabel.SelectedValue.ToString() != "System.Data.DataRowView")
  323. {
  324. string PrintNums = dh.getFieldDataByCondition("label", "la_printnos", "la_id='" + PrintLabel.SelectedValue.ToString() + "'").ToString();
  325. PrintNum.Text = (PrintNums == "" ? "1" : PrintNums);
  326. }
  327. }
  328. }
  329. }