Make_Decompose.cs 36 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505
  1. using System;
  2. using System.Collections.Generic;
  3. using System.ComponentModel;
  4. using System.Data;
  5. using System.Drawing;
  6. using System.Linq;
  7. using System.Text;
  8. using System.Windows.Forms;
  9. using UAS_MES_NEW.DataOperate;
  10. using UAS_MES_NEW.Entity;
  11. using UAS_MES_NEW.PublicMethod;
  12. namespace UAS_MES_NEW.Make
  13. {
  14. public partial class Make_Decompose : Form
  15. {
  16. AutoSizeFormClass asc = new AutoSizeFormClass();
  17. DataTable dt;
  18. DataTable dt1;
  19. DataTable dtbar;
  20. DataTable dtst;
  21. LogStringBuilder sql = new LogStringBuilder();
  22. DataHelper dh;
  23. //记录当前序列号的ms_id
  24. string ms_id;
  25. //采集计数
  26. int count;
  27. //Bom版本
  28. string ma_bomversion;
  29. int rowindex;
  30. Make_NewBadCode_DE badcode;
  31. //记录当前输入框的值
  32. string sncode_1;
  33. string sncode_2;
  34. string[] bccode;
  35. string[] bgcode;
  36. string[] id;
  37. public Make_Decompose()
  38. {
  39. InitializeComponent();
  40. }
  41. private void Make_Decompose_Load(object sender, EventArgs e)
  42. {
  43. asc.controllInitializeSize(this);
  44. sn_code.Focus();
  45. OperateResult.AppendText(">>请输入序列号\n");
  46. count = 0;
  47. deccount.Text = count + "";
  48. dh = SystemInf.dh;
  49. }
  50. private void sn_code_KeyDown(object sender, KeyEventArgs e)
  51. {
  52. if (e.KeyCode == Keys.Enter)
  53. {
  54. dt = (DataTable)dh.ExecuteSql("select ms_sncode from makeserial where ms_imei1='" + sn_code.Text + "' order by ms_id desc", "select");
  55. if (dt.Rows.Count > 0)
  56. {
  57. sn_code.Text = dt.Rows[0]["ms_sncode"].ToString();
  58. }
  59. else
  60. {
  61. dt = (DataTable)dh.ExecuteSql("select ms_sncode from makeserial where ms_imei2='" + sn_code.Text + "' order by ms_id desc", "select");
  62. if (dt.Rows.Count > 0)
  63. {
  64. sn_code.Text = dt.Rows[0]["ms_sncode"].ToString();
  65. }
  66. else
  67. {
  68. dt = (DataTable)dh.ExecuteSql("select mil_sncode from makeimeilist where mil_imei1='" + sn_code.Text + "' order by mil_id desc", "select");
  69. if (dt.Rows.Count > 0)
  70. {
  71. sn_code.Text = dt.Rows[0]["mil_sncode"].ToString();
  72. }
  73. else
  74. {
  75. dt = (DataTable)dh.ExecuteSql("select mil_sncode from makeimeilist where mil_imei2='" + sn_code.Text + "' order by mil_id desc", "select");
  76. if (dt.Rows.Count > 0)
  77. {
  78. sn_code.Text = dt.Rows[0]["mil_sncode"].ToString();
  79. }
  80. }
  81. }
  82. }
  83. sql.Clear();
  84. sql.Append("select max(ms_id) from makeserial where ms_sncode ='" + sn_code.Text + "' or ms_sncode = (select max(SN)");
  85. sql.Append(" from makesnrelation left join makeserial on ms_makecode=makecode where beforesn='" + sn_code.Text + "')");
  86. dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
  87. ms_id = dt.Rows[0][0].ToString();
  88. sncode_1 = sn_code.Text;
  89. BaseUtil.CleanForm(this);
  90. deccount.Text = count + "";
  91. if (ms_id != "")
  92. {
  93. sql.Clear();
  94. sql.Append("select ms_id,ms_status,ms_makecode,ms_prodcode,pr_detail pr_name,ms_sncode,ms_firstsn,ms_craftcode,ms_craftname,ms_wccode from makeserial left join product on pr_code=ms_prodcode where ms_id='" + ms_id + "'");
  95. dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
  96. if (dt.Rows[0]["ms_status"].ToString() == "0" || dt.Rows[0]["ms_status"].ToString() == "3")
  97. {
  98. BaseUtil.SetFormValue(this.Controls, dt);
  99. LoadData(ms_sncode.Text, sender, e);
  100. }
  101. else
  102. {
  103. OperateResult.AppendText(">>序列号" + sncode_1 + "必须处于维修或未采集状态才能做拆解\n", Color.Red, sn_code);
  104. BaseUtil.CleanForm(this);
  105. sn_code.Focus();
  106. return;
  107. }
  108. }
  109. else
  110. {
  111. ms_id = null;
  112. OperateResult.AppendText(">>序列号" + sncode_1 + "不存在\n", Color.Red, sn_code);
  113. BaseUtil.CleanForm(this);
  114. sn_code.Focus();
  115. return;
  116. }
  117. }
  118. }
  119. //加载此序列号上料记录
  120. private void LoadData(string sncode, object sender, KeyEventArgs e)
  121. {
  122. //cm_wccode
  123. sncode_1 = sncode;
  124. sql.Clear();
  125. sql.Append("select cm_craftcode,cm_spid,cm_craftname,cm_firstsn,cm_makecode,cm_stepcode,cm_stepname,cm_maprodcode,cm_fsoncode,cm_wccode,cm_maid,cm_soncode,cm_materialtype,");
  126. sql.Append("max(cm_status) cm_status,max(cm_id) cm_id from craftmaterial where(cm_sncode in (select '" + sncode_1 + "' from dual union select firstsn from makesnrelation where sn ");
  127. sql.Append(" ='" + sncode_1 + "'union select sn from makesnrelation where firstsn = '" + sncode_1 + "')");
  128. sql.Append(") group by cm_craftcode,cm_firstsn,cm_stepcode,cm_stepname,cm_spid,cm_makecode,cm_maprodcode,cm_maid,cm_soncode,cm_wccode,cm_materialtype,cm_craftname,cm_fsoncode ORDER BY cm_status DESC");
  129. dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
  130. if (dt.Rows.Count > 0)
  131. {
  132. BaseUtil.FillDgvWithDataTable(LabelDataGridView, dt);
  133. for (int i = 0; i < LabelDataGridView.Rows.Count; i++)
  134. {
  135. DataTable datatable = (DataTable)dh.ExecuteSql("select cm_barcode,cm_sncode from CRAFTMATERIAL where cm_id = '" + LabelDataGridView.Rows[i].Cells["cm_id"].Value + "'", "select");
  136. LabelDataGridView.Rows[i].Cells["cm_barcode"].Value = datatable.Rows[0]["cm_barcode"].ToString();
  137. LabelDataGridView.Rows[i].Cells["cm_sncode"].Value = datatable.Rows[0]["cm_sncode"].ToString();
  138. string[] cm_sncodedetail = LabelDataGridView.Rows[i].Cells["cm_soncode"].Value.ToString().Split(',');
  139. string pr_name = "";
  140. foreach (string item in cm_sncodedetail)
  141. {
  142. pr_name += "'" + item + "',";
  143. }
  144. pr_name = pr_name.TrimEnd(',');
  145. LabelDataGridView.Rows[i].Cells["pr_detail_"].Value = dh.getFieldDataByCondition("product", "wm_concat(substr(pr_spec,0,20))", "pr_code in (" + pr_name + ")");
  146. LabelDataGridView.Rows[i].Cells["cm_status_1"].Value = (LabelDataGridView.Rows[i].Cells["cm_status"].Value.ToString() == "-1") ? "已拆解" : "上线";
  147. }
  148. }
  149. else
  150. {
  151. OperateResult.AppendText(">>序列号" + ms_sncode.Text + "无上料数据\n", Color.Red);
  152. }
  153. }
  154. private void Make_Decompose_SizeChanged(object sender, EventArgs e)
  155. {
  156. asc.controlAutoSize(this);
  157. }
  158. private void LabelDataGridView_CellContentClick(object sender, DataGridViewCellEventArgs e)
  159. {
  160. if (e.ColumnIndex >= 0 && e.RowIndex >= 0)
  161. {
  162. if (LabelDataGridView.Columns[e.ColumnIndex].Name == "AddBad")
  163. {
  164. if (ms_sncode.Text == "" || ms_makecode.Text == "")
  165. {
  166. OperateResult.AppendText(">>序列号和工单号不允许为空\n", Color.Red);
  167. }
  168. else
  169. {
  170. rowindex = e.RowIndex;
  171. badcode = new Make_NewBadCode_DE(ms_sncode.Text, ms_makecode.Text);
  172. badcode.Controls["Save"].Click += LoadBadcode;
  173. BaseUtil.SetFormCenter(badcode);
  174. badcode.ShowDialog();
  175. }
  176. }
  177. }
  178. }
  179. //加载之前在新增不良代码界面选择的不良代码
  180. private void LoadBadcode(object sender, EventArgs e)
  181. {
  182. sql.Clear();
  183. for (int i = 0; i < badcode.bccode.Length; i++)
  184. {
  185. sql.Append(badcode.bgcode[i] + " : " + badcode.bccode[i] + " |");
  186. }
  187. LabelDataGridView.Rows[rowindex].Cells["mb_badcode"].Value = sql.GetString();
  188. badcode.Close();
  189. }
  190. private void Decompose_Click(object sender, EventArgs e)
  191. {
  192. sql.Clear();
  193. sql.Append("select max(ms_id) from makeserial where ms_sncode ='" + ms_sncode.Text + "' or ms_sncode = (select max(SN)");
  194. sql.Append(" from makesnrelation left join makeserial on ms_makecode=makecode where beforesn='" + ms_sncode.Text + "')");
  195. dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
  196. ms_id = dt.Rows[0][0].ToString();
  197. if (ms_id != "")
  198. {
  199. sql.Clear();
  200. sql.Append("select ms_id,ms_status,ms_makecode,ms_prodcode,pr_detail pr_name,ms_sncode,ms_firstsn,ms_craftcode,ms_craftname,ms_wccode from makeserial left join product on pr_code=ms_prodcode where ms_id='" + ms_id + "'");
  201. dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
  202. if (!(dt.Rows[0]["ms_status"].ToString() == "0" || dt.Rows[0]["ms_status"].ToString() == "3"))
  203. {
  204. OperateResult.AppendText(">>序列号" + ms_sncode.Text + "必须处于维修或未采集状态才能做拆解\n", Color.Red, sn_code);
  205. BaseUtil.CleanForm(this);
  206. sn_code.Focus();
  207. return;
  208. }
  209. }
  210. else
  211. {
  212. ms_id = null;
  213. OperateResult.AppendText(">>序列号" + ms_sncode.Text + "不存在\n", Color.Red, sn_code);
  214. BaseUtil.CleanForm(this);
  215. sn_code.Focus();
  216. return;
  217. }
  218. Boolean decompose = false;
  219. for (int i = 0; i < LabelDataGridView.Rows.Count; i++)
  220. {
  221. if (LabelDataGridView.Rows[i].Cells["Choose"].Value != null)
  222. {
  223. //if ((Boolean)LabelDataGridView.Rows[i].Cells["Choose"].Value == true && change.Checked && (LabelDataGridView.Rows[i].Cells["mb_badcode"].Value == null || LabelDataGridView.Rows[i].Cells["New_BarCode"].Value == null) && LabelDataGridView.Rows[i].Cells["cm_status"].Value.ToString() != "-1")
  224. //{
  225. // OperateResult.AppendText("第" + (i + 1) + "行没有采集不良代码或新批号\n", Color.Red);
  226. // return;
  227. //}
  228. if ((Boolean)LabelDataGridView.Rows[i].Cells["Choose"].Value == true && change.Checked && LabelDataGridView.Rows[i].Cells["New_BarCode"].Value == null && LabelDataGridView.Rows[i].Cells["cm_status"].Value.ToString() == "-1")
  229. {
  230. OperateResult.AppendText("第" + (i + 1) + "行没有采集新批号\n", Color.Red);
  231. return;
  232. }
  233. //if ((Boolean)LabelDataGridView.Rows[i].Cells["Choose"].Value == true && nochange.Checked && (LabelDataGridView.Rows[i].Cells["mb_badcode"].Value == null) && LabelDataGridView.Rows[i].Cells["cm_status"].Value.ToString() != "-1")
  234. //{
  235. // OperateResult.AppendText("第" + (i + 1) + "行没有采集不良代码\n", Color.Red);
  236. // return;
  237. //}
  238. }
  239. }
  240. for (int i = 0; i < LabelDataGridView.Rows.Count; i++)
  241. {
  242. if (LabelDataGridView.Rows[i].Cells["Choose"].Value != null)
  243. {
  244. if ((Boolean)LabelDataGridView.Rows[i].Cells["Choose"].Value == true)
  245. {
  246. //if (LabelDataGridView.Rows[i].Cells["mb_badcode"].Value != null)
  247. //{
  248. // String[] badcodetol = LabelDataGridView.Rows[i].Cells["mb_badcode"].Value.ToString().Split('|');
  249. // bgcode = new string[badcodetol.Length - 1];
  250. // bccode = new string[badcodetol.Length - 1];
  251. // for (int h = 0; h < badcodetol.Length - 1; h++)
  252. // {
  253. // bgcode[h] = badcodetol[h].Split(':')[0].Trim();
  254. // bccode[h] = badcodetol[h].Split(':')[1].Trim();
  255. // }
  256. //}
  257. if (change.Checked)
  258. {
  259. dt1 = new DataTable();
  260. sql.Clear();
  261. sql.Append("select ma_bomversion from makeserial left join make on ma_code=ms_makecode ");
  262. sql.Append("left join product on ms_prodcode=pr_code where ms_makecode='" + LabelDataGridView.Rows[i].Cells["cm_makecode"].Value + "' order by ms_id desc");
  263. dt1 = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
  264. if (dt1.Rows.Count > 0)
  265. {
  266. ma_bomversion = dt1.Rows[0][0].ToString();
  267. }
  268. dtbar = new DataTable();
  269. sql.Clear();
  270. sql.Append("select max(sp_id)sp_id,max(sp_detno)sp_detno,min(sp_ifrepeat)sp_ifrepeat,sp_fsoncode,max(sp_barcoderule)");
  271. sql.Append("sp_barcoderule, min(sp_checksalecode)sp_checksalecode,sp_tracekind,wm_concat(sp_soncode) sp_soncode,max(sp_ifuseregex)sp_ifuseregex,max(sp_ifforsn)");
  272. sql.Append("sp_ifforsn,max(sp_length)sp_length,max(sp_type)sp_type,replace(wm_concat(sp_prefix),',','|')sp_prefix,max(sp_regex)");
  273. sql.Append("sp_regex,max(substr(pr_spec,0,20))pr_detail from stepproduct left join product on pr_code=sp_fsoncode where ");
  274. sql.Append("sp_bomversion='" + ma_bomversion + "' and sp_craftcode='" + LabelDataGridView.Rows[i].Cells["cm_craftcode"].Value + "'and sp_mothercode ='" + LabelDataGridView.Rows[i].Cells["cm_maprodcode"].Value + "'");
  275. sql.Append(" group by sp_fsoncode,sp_tracekind order by SP_DETNO asc");
  276. dtbar = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
  277. DataRow[] dtrows = dtbar.Select("sp_soncode like '" + LabelDataGridView.Rows[i].Cells["cm_soncode"].Value + "'");
  278. dtbar = BaseUtil.ToDataTable(dtrows);
  279. if (dtbar.Rows.Count > 0)
  280. {
  281. string ErrorMessage;
  282. string sp_tracekind = dtbar.Rows[0]["sp_tracekind"].ToString();
  283. string sp_soncode = dtbar.Rows[0]["sp_soncode"].ToString();
  284. string sp_prefix = dtbar.Rows[0]["sp_prefix"].ToString();
  285. string sp_fsoncode = dtbar.Rows[0]["sp_fsoncode"].ToString();
  286. string length = dtbar.Rows[0]["sp_length"].ToString();
  287. string sp_ifrepeat = dtbar.Rows[0]["sp_ifrepeat"].ToString();
  288. string sp_barcoderule = dtbar.Rows[0]["sp_barcoderule"].ToString();
  289. string sp_checksalecode = dtbar.Rows[0]["sp_checksalecode"].ToString();
  290. if (sp_tracekind == "1")
  291. {
  292. //上料校验规则判断
  293. if (!LogicHandler.CheckSNBeforeLoad(LabelDataGridView.Rows[i].Cells["cm_makecode"].Value.ToString(), LabelDataGridView.Rows[i].Cells["New_BarCode"].Value.ToString(), sp_fsoncode, sp_soncode, sp_barcoderule, sp_prefix, length, sp_ifrepeat, sp_checksalecode, out ErrorMessage))
  294. {
  295. OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red);
  296. LoadData(sncode_1, sender, new KeyEventArgs(Keys.Enter));
  297. continue;
  298. }
  299. dh.UpdateByCondition("makeserial", "ms_nextmacode='" + LabelDataGridView.Rows[i].Cells["cm_makecode"].Value.ToString() + "'", "ms_id=(select max(ms_id) from makeserial where ms_sncode='" + LabelDataGridView.Rows[i].Cells["New_BarCode"].Value.ToString() + "')");
  300. }
  301. else if (sp_tracekind == "2")
  302. {
  303. if (!dh.CheckExist("makesourcestock", " (MSS_FPRODCODE = '" + LabelDataGridView.Rows[i].Cells["cm_soncode"].Value.ToString() + "' or MSS_PRODCODE = '" + LabelDataGridView.Rows[i].Cells["cm_soncode"].Value.ToString() + "') and mss_barcode = '" + LabelDataGridView.Rows[i].Cells["New_BarCode"].Value.ToString() + "'"))
  304. {
  305. OperateResult.AppendText(">>物料" + LabelDataGridView.Rows[i].Cells["cm_soncode"].Value.ToString() + "岗位备料无条码" + LabelDataGridView.Rows[i].Cells["New_BarCode"].Value.ToString() + "\n", Color.Red);
  306. continue;
  307. }
  308. else
  309. {
  310. sql.Clear();
  311. sql.Append("select mss_id,MSS_REMAIN,MSS_BASEQTY from makesourcestock where (MSS_FPRODCODE = '" + LabelDataGridView.Rows[i].Cells["cm_soncode"].Value.ToString() + "' or MSS_PRODCODE = '" + LabelDataGridView.Rows[i].Cells["cm_soncode"].Value.ToString() + "') and mss_barcode = '" + LabelDataGridView.Rows[i].Cells["New_BarCode"].Value.ToString() + "'");
  312. dtst = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
  313. int MSS_REMAIN = int.Parse(dtst.Rows[0]["MSS_REMAIN"].ToString());
  314. int MSS_BASEQTY = int.Parse(dtst.Rows[0]["MSS_BASEQTY"].ToString());
  315. if (MSS_REMAIN < MSS_BASEQTY)
  316. {
  317. OperateResult.AppendText(">>物料" + LabelDataGridView.Rows[i].Cells["cm_soncode"].Value.ToString() + "条码" + LabelDataGridView.Rows[i].Cells["New_BarCode"].Value.ToString() + "备料不足\n", Color.Red);
  318. continue;
  319. }
  320. else
  321. {
  322. dh.UpdateByCondition("makesourcestock", "MSS_REMAIN = NVL(MSS_REMAIN, 0) - MSS_BASEQTY,MSS_USEQTY = NVL(MSS_USEQTY, 0) + MSS_BASEQTY,mss_madeqty=NVL(mss_madeqty,0)+ceil(MSS_USEQTY/MSS_BASEQTY)", " mss_id = '" + dtst.Rows[0]["mss_id"].ToString() + "' and (MSS_FPRODCODE = '" + LabelDataGridView.Rows[i].Cells["cm_soncode"].Value.ToString() + "' or MSS_PRODCODE = '" + LabelDataGridView.Rows[i].Cells["cm_soncode"].Value.ToString() + "') and mss_barcode = '" + LabelDataGridView.Rows[i].Cells["New_BarCode"].Value.ToString() + "'");
  323. }
  324. }
  325. }
  326. }
  327. else
  328. {
  329. //当前备料信息不再工序BOM中,为BOM之外的批管控物料备料
  330. if (!dh.CheckExist("makesourcestock", " (MSS_FPRODCODE = '" + LabelDataGridView.Rows[i].Cells["cm_soncode"].Value.ToString() + "' or MSS_PRODCODE = '" + LabelDataGridView.Rows[i].Cells["cm_soncode"].Value.ToString() + "') and mss_barcode = '" + LabelDataGridView.Rows[i].Cells["New_BarCode"].Value.ToString() + "'"))
  331. {
  332. OperateResult.AppendText(">>物料" + LabelDataGridView.Rows[i].Cells["cm_soncode"].Value.ToString() + "不在当前工序BOM" + ma_bomversion + "中\n", Color.Black);
  333. OperateResult.AppendText(">>物料" + LabelDataGridView.Rows[i].Cells["cm_soncode"].Value.ToString() + "岗位备料无条码" + LabelDataGridView.Rows[i].Cells["New_BarCode"].Value.ToString() + "\n", Color.Red);
  334. continue;
  335. }
  336. else
  337. {
  338. sql.Clear();
  339. sql.Append("select mss_id,MSS_REMAIN,MSS_BASEQTY from makesourcestock where (MSS_FPRODCODE = '" + LabelDataGridView.Rows[i].Cells["cm_soncode"].Value.ToString() + "' or MSS_PRODCODE = '" + LabelDataGridView.Rows[i].Cells["cm_soncode"].Value.ToString() + "') and mss_barcode = '" + LabelDataGridView.Rows[i].Cells["New_BarCode"].Value.ToString() + "'");
  340. dtst = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
  341. int MSS_REMAIN = int.Parse(dtst.Rows[0]["MSS_REMAIN"].ToString());
  342. int MSS_BASEQTY = int.Parse(dtst.Rows[0]["MSS_BASEQTY"].ToString());
  343. if (MSS_REMAIN < MSS_BASEQTY)
  344. {
  345. OperateResult.AppendText(">>物料" + LabelDataGridView.Rows[i].Cells["cm_soncode"].Value.ToString() + "条码" + LabelDataGridView.Rows[i].Cells["New_BarCode"].Value.ToString() + "备料不足\n", Color.Red);
  346. continue;
  347. }
  348. else
  349. {
  350. dh.UpdateByCondition("makesourcestock", "MSS_REMAIN = NVL(MSS_REMAIN, 0) - MSS_BASEQTY,MSS_USEQTY = NVL(MSS_USEQTY, 0) + MSS_BASEQTY,mss_madeqty=NVL(mss_madeqty,0)+ceil(MSS_USEQTY/MSS_BASEQTY)", " mss_id = '" + dtst.Rows[0]["mss_id"].ToString() + "' and (MSS_FPRODCODE = '" + LabelDataGridView.Rows[i].Cells["cm_soncode"].Value.ToString() + "' or MSS_PRODCODE = '" + LabelDataGridView.Rows[i].Cells["cm_soncode"].Value.ToString() + "') and mss_barcode = '" + LabelDataGridView.Rows[i].Cells["New_BarCode"].Value.ToString() + "'");
  351. }
  352. }
  353. }
  354. if (LabelDataGridView.Rows[i].Cells["cm_status"].Value.ToString() != "-1")
  355. {
  356. //判断生产信息
  357. sql.Clear();
  358. sql.Append("select ms_id,ms_sncode,cm_barcode from craftmaterial left join makeserial on cm_barcode = ms_sncode and cm_soncode = ms_prodcode where cm_id = '" + LabelDataGridView.Rows[i].Cells["cm_id"].Value + "' and cm_materialtype ='1' and ms_id>'0' and ms_nextmacode = '" + LabelDataGridView.Rows[i].Cells["cm_makecode"].Value.ToString() + "'");
  359. dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
  360. //制造件
  361. if (dt.Rows.Count > 0)
  362. {
  363. string makecode = (String)dh.getFieldDataByCondition("makeserial", "ms_makecode", "ms_sncode = '" + LabelDataGridView.Rows[i].Cells["cm_barcode"].Value + "' and ms_prodcode = '" + LabelDataGridView.Rows[i].Cells["cm_soncode"].Value + "'");
  364. string mss_id = dt.Rows[0]["ms_id"].ToString();
  365. //////MakeBad表插入物料批号不良信息
  366. //sql.Clear();
  367. //sql.Append(" insert into makebad (mb_id, mb_inman,mb_indate,mb_stepcode,mb_sourcecode, mb_bgcode,mb_mscode,mb_sncode, mb_badcode, mb_makecode)");
  368. //sql.Append("values (MakeBad_seq.nextval,'" + User.UserName + "',sysdate,'" + User.CurrentStepCode + "','" + User.UserSourceCode + "',:bg_code ,'" + LabelDataGridView.Rows[i].Cells["cm_barcode"].Value + "','" + LabelDataGridView.Rows[i].Cells["cm_barcode"].Value + "',");
  369. //sql.Append(":bc_code,'" + makecode + "')");
  370. //dh.BatchInsert(sql.GetString(), new string[] { "bg_code", "bc_code" }, bgcode, bccode);
  371. //更新子件序列号为待维修
  372. sql.Clear();
  373. sql.Append("update makeserial set ms_status=3 ,ms_badtimes = ms_badtimes+1,ms_nextmacode = '' where ms_id='" + mss_id + "' ");
  374. dh.ExecuteSql(sql.GetString(), "update");
  375. }
  376. //没有生产信息,判定为采购件,则将不良信息插入不良零件表中MAKEBADRSPART
  377. else
  378. {
  379. //sql.Clear();
  380. //sql.Append("insert into MAKEBADRSPART(mbp_id,mbp_indate,mbp_inman,mbp_sncode, mbp_badcode, mbp_part, mbp_makecode, mbp_sccode,mbp_barcode)values");
  381. //sql.Append("(MAKEBADRSPART_seq.nextval, sysdate, '" + User.UserCode + "','" + ms_sncode.Text + "',:bc_code,'" + LabelDataGridView.Rows[i].Cells["cm_soncode"].Value + "','" + ms_makecode.Text + "','" + User.UserSourceCode + "','" + LabelDataGridView.Rows[i].Cells["cm_barcode"].Value + "')");
  382. //dh.BatchInsert(sql.GetString(), new string[] { "bc_code" }, bccode);
  383. }
  384. }
  385. //此物料上线状态更新为-1,代表被拆解
  386. sql.Clear();
  387. sql.Append("update craftmaterial set cm_status=-1,cm_lastdeco=-1,cm_dropman='" + User.UserCode + "',");
  388. sql.Append("cm_dropdate =sysdate,cm_dropstep='" + User.CurrentStepCode + "',");
  389. sql.Append("cm_dropsccode='" + User.UserSourceCode + "' where cm_id='" + LabelDataGridView.Rows[i].Cells["cm_id"].Value + "'");
  390. dh.ExecuteSql(sql.GetString(), "update");
  391. ////将新批号绑定到序列号中
  392. //dt = (DataTable)dh.ExecuteSql("select sp_id from stepproduct where sp_mothercode='" + LabelDataGridView.Rows[i].Cells["cm_maprodcode"].Value + "'", "select");
  393. //string sp_id = dt.Rows[0]["sp_id"].ToString();
  394. sql.Clear();
  395. sql.Append("insert into craftmaterial (cm_id, cm_makecode,cm_maid,cm_maprodcode,cm_soncode,cm_mscode,cm_sncode,cm_stepcode,cm_stepname,");
  396. sql.Append("cm_craftcode,cm_craftname,cm_barcode,cm_inqty,cm_indate,cm_inman,cm_linecode,cm_wccode,cm_sourcecode,cm_spid, cm_materialtype,cm_status,cm_fsoncode,cm_firstsn)");
  397. sql.Append("values(Craftmaterial_seq.nextval,'" + LabelDataGridView.Rows[i].Cells["cm_makecode"].Value + "','" + LabelDataGridView.Rows[i].Cells["cm_maid"].Value + "','" + LabelDataGridView.Rows[i].Cells["cm_maprodcode"].Value + "','" + LabelDataGridView.Rows[i].Cells["cm_soncode"].Value + "'");
  398. sql.Append(",'" + LabelDataGridView.Rows[i].Cells["cm_sncode"].Value + "','" + LabelDataGridView.Rows[i].Cells["cm_sncode"].Value + "','" + LabelDataGridView.Rows[i].Cells["cm_stepcode"].Value + "','" + LabelDataGridView.Rows[i].Cells["cm_stepname"].Value + "',");
  399. sql.Append("'" + LabelDataGridView.Rows[i].Cells["cm_craftcode"].Value + "','" + LabelDataGridView.Rows[i].Cells["cm_craftname"].Value + "','" + LabelDataGridView.Rows[i].Cells["New_BarCode"].Value + "',1,sysdate,'" + User.UserCode + "','" + User.UserLineCode + "','" + LabelDataGridView.Rows[i].Cells["cm_wccode"].Value + "',");
  400. sql.Append("'" + User.UserSourceCode + "','" + LabelDataGridView.Rows[i].Cells["cm_spid"].Value + "','" + LabelDataGridView.Rows[i].Cells["cm_materialtype"].Value + "','0','" + LabelDataGridView.Rows[i].Cells["cm_fsoncode"].Value + "','" + LabelDataGridView.Rows[i].Cells["cm_firstsn"].Value + "')");
  401. dh.ExecuteSql(sql.GetString(), "insert");
  402. dh.ExecuteSql("update makeserial set ms_nextmacode='" + LabelDataGridView.Rows[i].Cells["cm_makecode"].Value + "' where ms_id=(select max(ms_id) from makeserial where ms_sncode='" + LabelDataGridView.Rows[i].Cells["New_BarCode"].Value + "' and ms_makecode<>'" + ms_makecode.Text + "')", "update");
  403. OperateResult.AppendText("物料" + LabelDataGridView.Rows[i].Cells["cm_barcode"].Value + "拆解换料成功\n", Color.Green);
  404. decompose = true;
  405. LogicHandler.DoCommandLog(Tag.ToString(), User.UserCode, ms_makecode.Text, User.UserLineCode, User.UserSourceCode, "物料" + LabelDataGridView.Rows[i].Cells["cm_barcode"].Value + "拆解换料", "拆解换料成功", ms_sncode.Text, "");
  406. LogicHandler.DoCommandLog(Tag.ToString(), User.UserCode, ms_makecode.Text, User.UserLineCode, User.UserSourceCode, "物料" + LabelDataGridView.Rows[i].Cells["New_BarCode"].Value + "拆解换料上料", "拆解换料上料成功", ms_sncode.Text, "");
  407. }
  408. else if (nochange.Checked)
  409. {
  410. if (LabelDataGridView.Rows[i].Cells["cm_status"].Value.ToString() != "-1")
  411. {
  412. //判断生产信息
  413. sql.Clear();
  414. sql.Append("select ms_id,ms_sncode,cm_barcode from craftmaterial left join makeserial on cm_barcode = ms_sncode and cm_soncode = ms_prodcode where cm_id = '" + LabelDataGridView.Rows[i].Cells["cm_id"].Value + "' and cm_materialtype ='1' and ms_id>'0' and ms_nextmacode = '" + LabelDataGridView.Rows[i].Cells["cm_makecode"].Value.ToString() + "'");
  415. dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
  416. //制造件
  417. if (dt.Rows.Count > 0)
  418. {
  419. string makecode = (String)dh.getFieldDataByCondition("makeserial", "ms_makecode", "ms_sncode = '" + LabelDataGridView.Rows[i].Cells["cm_barcode"].Value + "' and ms_prodcode = '" + LabelDataGridView.Rows[i].Cells["cm_soncode"].Value + "'");
  420. string mss_id = dt.Rows[0]["ms_id"].ToString();
  421. ////MakeBad表插入物料批号不良信息
  422. //sql.Clear();
  423. //sql.Append(" insert into makebad (mb_id, mb_inman,mb_indate,mb_stepcode,mb_sourcecode, mb_bgcode,mb_mscode,mb_sncode, mb_badcode, mb_makecode)");
  424. //sql.Append("values (MakeBad_seq.nextval,'" + User.UserName + "',sysdate,'" + User.CurrentStepCode + "','" + User.UserSourceCode + "',:bg_code ,'" + LabelDataGridView.Rows[i].Cells["cm_barcode"].Value + "','" + LabelDataGridView.Rows[i].Cells["cm_barcode"].Value + "',");
  425. //sql.Append(":bc_code,'" + makecode + "')");
  426. //dh.BatchInsert(sql.GetString(), new string[] { "bg_code", "bc_code" }, bgcode, bccode);
  427. //更新子件序列号为待维修
  428. sql.Clear();
  429. sql.Append("update makeserial set ms_status=3 ,ms_badtimes = ms_badtimes+1,ms_nextmacode = '' where ms_id='" + mss_id + "' ");
  430. dh.ExecuteSql(sql.GetString(), "update");
  431. }
  432. //没有生产信息,判定为采购件,则将不良信息插入不良零件表中MAKEBADRSPART
  433. else
  434. {
  435. //sql.Clear();
  436. //sql.Append("insert into MAKEBADRSPART(mbp_id,mbp_indate,mbp_inman,mbp_sncode, mbp_badcode, mbp_part, mbp_makecode, mbp_sccode,mbp_barcode)values");
  437. //sql.Append("(MAKEBADRSPART_seq.nextval, sysdate, '" + User.UserCode + "','" + ms_sncode.Text + "',:bc_code,'" + LabelDataGridView.Rows[i].Cells["cm_soncode"].Value + "','" + ms_makecode.Text + "','" + User.UserSourceCode + "','" + LabelDataGridView.Rows[i].Cells["cm_barcode"].Value + "')");
  438. //dh.BatchInsert(sql.GetString(), new string[] { "bc_code" }, bccode);
  439. }
  440. //craftmaterial解除相应物料绑定
  441. sql.Clear();
  442. sql.Append("update craftmaterial set cm_status=-1,cm_dropman='" + User.UserCode + "',");
  443. sql.Append("cm_dropdate =sysdate,cm_dropstep='" + User.CurrentStepCode + "',");
  444. sql.Append("cm_dropsccode='" + User.UserSourceCode + "' where cm_id='" + LabelDataGridView.Rows[i].Cells["cm_id"].Value + "'");
  445. dh.ExecuteSql(sql.GetString(), "update");
  446. }
  447. //更新序列号信息
  448. sql.Clear();
  449. sql.Append("update makeserial set ms_nextmacode = '' where ms_sncode = (select cm_barcode from craftmaterial where cm_id = '" + LabelDataGridView.Rows[i].Cells["cm_id"].Value + "' and CM_MATERIALTYPE = '1') and ms_nextmacode='" + ms_makecode.Text + "'");
  450. dh.ExecuteSql(sql.GetString(), "update");
  451. OperateResult.AppendText("物料" + LabelDataGridView.Rows[i].Cells["cm_barcode"].Value + "拆解成功\n", Color.Green);
  452. decompose = true;
  453. LogicHandler.DoCommandLog(Tag.ToString(), User.UserCode, ms_makecode.Text, User.UserLineCode, User.UserSourceCode, "物料" + LabelDataGridView.Rows[i].Cells["cm_barcode"].Value + "拆解", "拆解成功", ms_sncode.Text, "");
  454. }
  455. else
  456. {
  457. OperateResult.AppendText(">>>没有选择拆解方式\n", Color.Red);
  458. return;
  459. }
  460. }
  461. }
  462. }
  463. if (decompose)
  464. {
  465. sn_code.Focus();
  466. count++;
  467. deccount.Text = count + "";
  468. LoadData(sncode_1, sender, new KeyEventArgs(Keys.Enter));
  469. }
  470. else
  471. {
  472. OperateResult.AppendText("没有成功拆解项\n", Color.Red);
  473. }
  474. }
  475. private void LabelDataGridView_Sorted(object sender, EventArgs e)
  476. {
  477. }
  478. }
  479. }