Make_Decompose.cs 26 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394
  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.DataOperate;
  10. using UAS_MES.Entity;
  11. using UAS_MES.PublicMethod;
  12. namespace UAS_MES.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. //记录当前输入框的值
  31. string sncode_1;
  32. string sncode_2;
  33. string[] bccode;
  34. string[] bgcode;
  35. string[] id;
  36. public Make_Decompose()
  37. {
  38. InitializeComponent();
  39. }
  40. private void Make_Decompose_Load(object sender, EventArgs e)
  41. {
  42. asc.controllInitializeSize(this);
  43. dh = new DataHelper();
  44. sn_code.Focus();
  45. OperateResult.AppendText(">>请输入序列号\n");
  46. count = 0;
  47. deccount.Text = count + "";
  48. }
  49. private void sn_code_KeyDown(object sender, KeyEventArgs e)
  50. {
  51. if (e.KeyCode == Keys.Enter)
  52. {
  53. sql.Clear();
  54. sql.Append("select max(ms_id) from makeserial where ms_sncode ='" + sn_code.Text + "' or ms_sncode = (select max(SN)");
  55. sql.Append(" from makesnrelation left join makeserial on ms_makecode=makecode where beforesn='" + sn_code.Text + "')");
  56. dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
  57. ms_id = dt.Rows[0][0].ToString();
  58. sncode_1 = sn_code.Text;
  59. BaseUtil.CleanForm(this);
  60. deccount.Text = count + "";
  61. if (ms_id != "")
  62. {
  63. sql.Clear();
  64. sql.Append("select ms_id,ms_status,ms_makecode,ms_prodcode,pr_detail ||' | '|| pr_spec 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 + "'");
  65. dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
  66. if (dt.Rows[0]["ms_status"].ToString() != "0" && dt.Rows[0]["ms_status"].ToString() != "1")
  67. {
  68. BaseUtil.SetFormValue(this.Controls, dt);
  69. LoadData(ms_sncode.Text, sender, e);
  70. }
  71. else
  72. {
  73. OperateResult.AppendText(">>序列号" + ms_sncode.Text + "必须是非在线状态才能做拆解\n", Color.Red, sn_code);
  74. BaseUtil.CleanForm(this);
  75. sn_code.Focus();
  76. return;
  77. }
  78. }
  79. else
  80. {
  81. ms_id = null;
  82. OperateResult.AppendText(">>序列号" + sncode_1 + "不存在\n", Color.Red, sn_code);
  83. BaseUtil.CleanForm(this);
  84. sn_code.Focus();
  85. return;
  86. }
  87. }
  88. }
  89. //加载此序列号上料记录
  90. private void LoadData(string sncode, object sender, KeyEventArgs e)
  91. {
  92. sncode_1 = sncode;
  93. sql.Clear();
  94. sql.Append("select cm_craftcode,cm_craftname,cm_makecode,cm_sncode,cm_stepcode,cm_stepname,cm_maprodcode,cm_maid,cm_soncode,pr_detail,cm_materialtype,");
  95. sql.Append("max(cm_status) cm_status,max(cm_id) cm_id from craftmaterial left join product on pr_code=cm_soncode where(cm_sncode in (select sn from makesnrelation ");
  96. sql.Append("where firstsn='"+ sncode_1 + "') or cm_sncode in ( select firstsn from makesnrelation where sn = '" + sncode_1 + "')");
  97. sql.Append("or cm_sncode = '" + sncode_1 + "') group by cm_craftcode,cm_makecode,cm_sncode,cm_maprodcode,cm_maid,cm_soncode,pr_detail,cm_materialtype,cm_craftname ORDER BY cm_status DESC");
  98. dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
  99. if (dt.Rows.Count > 0)
  100. {
  101. BaseUtil.FillDgvWithDataTable(LabelDataGridView, dt);
  102. for (int i = 0; i < LabelDataGridView.Rows.Count; i++)
  103. {
  104. LabelDataGridView.Rows[i].Cells["cm_barcode"].Value = dh.getFieldDataByCondition("CRAFTMATERIAL", "CM_BARCODE", "cm_id = '"+ LabelDataGridView.Rows[i].Cells["cm_id"].Value + "'");
  105. }
  106. }
  107. else
  108. {
  109. OperateResult.AppendText(">>序列号" + ms_sncode.Text + "无上料数据\n", Color.Red);
  110. }
  111. LoadBadcode(sender, e);
  112. }
  113. private void Make_Decompose_SizeChanged(object sender, EventArgs e)
  114. {
  115. asc.controlAutoSize(this);
  116. }
  117. private void LabelDataGridView_CellContentClick(object sender, DataGridViewCellEventArgs e)
  118. {
  119. if (e.ColumnIndex >= 0 && e.RowIndex >= 0)
  120. {
  121. if (LabelDataGridView.Columns[e.ColumnIndex].Name == "AddBad")
  122. {
  123. if (ms_sncode.Text == "" || ms_makecode.Text == "")
  124. {
  125. OperateResult.AppendText(">>序列号和工单号不允许为空\n", Color.Red);
  126. }
  127. else
  128. {
  129. Make_NewBadCode badcode = new Make_NewBadCode(ms_sncode.Text, ms_makecode.Text);
  130. BaseUtil.SetFormCenter(badcode);
  131. badcode.FormClosed += LoadBadcode;
  132. badcode.ShowDialog();
  133. }
  134. }
  135. }
  136. }
  137. private void LoadBadcode(object sender, EventArgs e)
  138. {
  139. sql.Clear();
  140. sql.Append("select mb_id,mb_sncode,mb_badcode,mb_bgcode,nvl(bc_name,mb_badcode) bc_name,nvl(bg_name,mb_bgcode) bg_name,");
  141. sql.Append("mb_badremark from makebad left join badcode on bc_code=mb_badcode left join badgroup ");
  142. sql.Append("on bg_code=mb_bgcode where mb_sncode='" + ms_sncode.Text + "' and mb_makecode='" + ms_makecode.Text + "' and mb_status=0");
  143. dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
  144. if (dt.Rows.Count > 0)
  145. {
  146. sql.Clear();
  147. bccode = new string[dt.Rows.Count];
  148. bgcode = new string[dt.Rows.Count];
  149. for (int i = 0; i < dt.Rows.Count; i++)
  150. {
  151. sql.Append(dt.Rows[i]["mb_bgcode"].ToString() + " : " + dt.Rows[i]["mb_badcode"].ToString() + " ");
  152. bgcode[i] = dt.Rows[i]["mb_bgcode"].ToString();
  153. bccode[i] = dt.Rows[i]["mb_badcode"].ToString();
  154. }
  155. for (int i = 0; i < LabelDataGridView.Rows.Count; i++)
  156. {
  157. LabelDataGridView.Rows[i].Cells["mb_badcode"].Value = sql.GetString();
  158. }
  159. }
  160. }
  161. private void Decompose_Click(object sender, EventArgs e)
  162. {
  163. Boolean decompose = false;
  164. for (int i = 0; i < LabelDataGridView.Rows.Count; i++)
  165. {
  166. if (LabelDataGridView.Rows[i].Cells["Choose"].Value != null)
  167. {
  168. 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))
  169. {
  170. OperateResult.AppendText("第" + (i + 1) + "行没有采集不良代码或新批号\n", Color.Red);
  171. return;
  172. }
  173. }
  174. }
  175. for (int i = 0; i < LabelDataGridView.Rows.Count; i++)
  176. {
  177. if (LabelDataGridView.Rows[i].Cells["Choose"].Value != null)
  178. {
  179. if ((Boolean)LabelDataGridView.Rows[i].Cells["Choose"].Value == true)
  180. {
  181. if (change.Checked)
  182. {
  183. dt1 = new DataTable();
  184. sql.Clear();
  185. sql.Append("select ma_bomversion from makeserial left join make on ma_code=ms_makecode ");
  186. 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");
  187. dt1 = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
  188. if (dt1.Rows.Count > 0)
  189. {
  190. ma_bomversion = dt1.Rows[0][0].ToString();
  191. }
  192. dtbar = new DataTable();
  193. sql.Clear();
  194. sql.Append("select sp_id,sp_tracekind,sp_barcoderule,sp_prefix,sp_ifuseregex,sp_ifforsn,sp_length,sp_description,sp_soncode,pr_detail,pr_spec,");
  195. sql.Append("sp_repcode,pr_id,sp_type,case when (sp_type='物料' and sp_soncode=pr_code) then '已采集' else '未采集' end sp_ifpick ,sp_prefix,");
  196. sql.Append("sp_length,sp_regex,sp_ifforsn from stepproduct left join product on pr_code=sp_soncode where sp_bomversion='" + ma_bomversion + "' and ");
  197. sql.Append("sp_craftcode='" + LabelDataGridView.Rows[i].Cells["cm_craftcode"].Value + "'and sp_mothercode ='" + LabelDataGridView.Rows[i].Cells["cm_maprodcode"].Value + "' and sp_soncode = '" + LabelDataGridView.Rows[i].Cells["cm_soncode"].Value + "' ");
  198. sql.Append("and((sp_type = '物料')or sp_type <> '物料') order by SP_DETNO asc");
  199. dtbar = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
  200. if (dtbar.Rows.Count > 0)
  201. {
  202. String ErrorMessage;
  203. string sp_tracekind = dtbar.Rows[0]["sp_tracekind"].ToString();
  204. string sp_soncode = dtbar.Rows[0]["sp_soncode"].ToString();
  205. string sp_prefix = dtbar.Rows[0]["sp_prefix"].ToString();
  206. string length = dtbar.Rows[0]["sp_length"].ToString();
  207. string sp_barcoderule = dtbar.Rows[0]["sp_barcoderule"].ToString();
  208. if (sp_tracekind != "2")
  209. {
  210. //上料校验规则判断
  211. if (!LogicHandler.CheckSNBeforeLoad(ms_makecode.Text, LabelDataGridView.Rows[i].Cells["New_BarCode"].Value.ToString(), sp_soncode, sp_barcoderule, sp_prefix, length, out ErrorMessage))
  212. {
  213. OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red);
  214. LoadData(sncode_1, sender, new KeyEventArgs(Keys.Enter));
  215. continue;
  216. }
  217. }
  218. else
  219. {
  220. if (!dh.CheckExist("makesourcestock", "mss_makecode = '" + ms_makecode.Text + "' 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() + "'"))
  221. {
  222. OperateResult.AppendText(">>物料" + LabelDataGridView.Rows[i].Cells["cm_soncode"].Value.ToString() + "岗位备料无条码" + LabelDataGridView.Rows[i].Cells["New_BarCode"].Value.ToString() + "\n", Color.Red);
  223. continue;
  224. }
  225. else
  226. {
  227. sql.Clear();
  228. sql.Append("select MSS_REMAIN,MSS_BASEQTY from makesourcestock where mss_makecode = '" + ms_makecode.Text + "' 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() + "'");
  229. dtst = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
  230. int MSS_REMAIN = int.Parse(dtst.Rows[0]["MSS_REMAIN"].ToString());
  231. int MSS_BASEQTY = int.Parse(dtst.Rows[0]["MSS_BASEQTY"].ToString());
  232. if (MSS_REMAIN < MSS_BASEQTY)
  233. {
  234. OperateResult.AppendText(">>物料" + LabelDataGridView.Rows[i].Cells["cm_soncode"].Value.ToString() + "条码" + LabelDataGridView.Rows[i].Cells["New_BarCode"].Value.ToString() + "备料不足\n", Color.Red);
  235. continue;
  236. }
  237. else
  238. {
  239. 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_makecode = '" + ms_makecode.Text + "' 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() + "'");
  240. }
  241. }
  242. }
  243. }
  244. else
  245. {
  246. OperateResult.AppendText(">>序列号" + ms_sncode.Text + "途程未维护工序BOM\n", Color.Red);
  247. return;
  248. }
  249. //判断生产信息
  250. sql.Clear();
  251. 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 = '" + ms_makecode.Text + "'");
  252. dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
  253. //制造件
  254. if (dt.Rows.Count > 0)
  255. {
  256. 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 + "'");
  257. string mss_id = dt.Rows[0]["ms_id"].ToString();
  258. ////MakeBad表插入物料批号不良信息
  259. sql.Clear();
  260. 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)");
  261. 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 + "',");
  262. sql.Append(":bc_code,'" + makecode + "')");
  263. dh.BatchInsert(sql.GetString(), new string[] { "bg_code", "bc_code" }, bgcode, bccode);
  264. //更新子件序列号为待维修
  265. sql.Clear();
  266. sql.Append("update makeserial set ms_status=3 ,ms_badtimes = ms_badtimes+1,ms_nextmacode = '' where ms_id='" + mss_id + "' ");
  267. dh.ExecuteSql(sql.GetString(), "update");
  268. }
  269. //没有生产信息,判定为采购件,则将不良信息插入不良零件表中MAKEBADRSPART
  270. else
  271. {
  272. sql.Clear();
  273. sql.Append("insert into MAKEBADRSPART(mbp_id,mbp_indate,mbp_inman,mbp_sncode, mbp_badcode, mbp_part, mbp_makecode, mbp_sccode,mbp_barcode)values");
  274. 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 + "')");
  275. dh.BatchInsert(sql.GetString(), new string[] { "bc_code" }, bccode);
  276. }
  277. //此物料上线状态更新为-1,代表被拆解
  278. sql.Clear();
  279. sql.Append("update craftmaterial set cm_status=-1,cm_dropman='" + User.UserName + "',");
  280. sql.Append("cm_dropdate =sysdate,cm_dropstep='" + User.CurrentStepName + "',");
  281. sql.Append("cm_dropsccode='" + User.CurrentStepCode + "' where cm_id='" + LabelDataGridView.Rows[i].Cells["cm_id"].Value + "'");
  282. dh.ExecuteSql(sql.GetString(), "update");
  283. //将新批号绑定到序列号中
  284. dt = (DataTable)dh.ExecuteSql("select sp_id from stepproduct where sp_mothercode='" + ms_prodcode.Text + "'", "select");
  285. string sp_id = dt.Rows[0]["sp_id"].ToString();
  286. sql.Clear();
  287. sql.Append("insert into craftmaterial (cm_id, cm_makecode,cm_maid,cm_maprodcode,cm_soncode,cm_mscode,cm_sncode,cm_stepcode,cm_stepname,");
  288. 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)");
  289. sql.Append("values(Craftmaterial_seq.nextval,'" + LabelDataGridView.Rows[i].Cells["cm_makecode"].Value + "','" + LabelDataGridView.Rows[i].Cells["cm_maid"].Value + "','" + ms_prodcode.Text + "','" + LabelDataGridView.Rows[i].Cells["cm_soncode"].Value + "'");
  290. 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 + "',");
  291. 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.UserName + "','" + User.UserLineCode + "','" + ms_wccode.Text + "',");
  292. sql.Append("'" + User.UserSourceCode + "','" + sp_id + "','" + LabelDataGridView.Rows[i].Cells["cm_materialtype"].Value + "','0')");
  293. dh.ExecuteSql(sql.GetString(), "insert");
  294. dh.ExecuteSql("update makeserial set ms_nextmacode='" + ms_makecode.Text + "' 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");
  295. OperateResult.AppendText("物料" + LabelDataGridView.Rows[i].Cells["cm_barcode"].Value + "拆解换料成功\n", Color.Green);
  296. decompose = true;
  297. LogicHandler.DoCommandLog(Tag.ToString(), User.UserCode, ms_makecode.Text, User.UserLineCode, User.UserSourceCode, "物料" + LabelDataGridView.Rows[i].Cells["cm_barcode"].Value + "拆解换料", "拆解换料成功", ms_sncode.Text, "");
  298. LogicHandler.DoCommandLog(Tag.ToString(), User.UserCode, ms_makecode.Text, User.UserLineCode, User.UserSourceCode, "物料" + LabelDataGridView.Rows[i].Cells["New_BarCode"].Value + "拆解换料上料", "拆解换料上料成功", ms_sncode.Text, "");
  299. }
  300. else if (nochange.Checked)
  301. {
  302. //判断生产信息
  303. sql.Clear();
  304. 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 = '" + ms_makecode.Text + "'");
  305. dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
  306. //制造件
  307. if (dt.Rows.Count > 0)
  308. {
  309. 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 + "'");
  310. string mss_id = dt.Rows[0]["ms_id"].ToString();
  311. ////MakeBad表插入物料批号不良信息
  312. sql.Clear();
  313. 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)");
  314. 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 + "',");
  315. sql.Append(":bc_code,'" + makecode + "')");
  316. dh.BatchInsert(sql.GetString(), new string[] { "bg_code", "bc_code" }, bgcode, bccode);
  317. //更新子件序列号为待维修
  318. sql.Clear();
  319. sql.Append("update makeserial set ms_status=3 ,ms_badtimes = ms_badtimes+1,ms_nextmacode = '' where ms_id='" + mss_id + "' ");
  320. dh.ExecuteSql(sql.GetString(), "update");
  321. }
  322. //没有生产信息,判定为采购件,则将不良信息插入不良零件表中MAKEBADRSPART
  323. else
  324. {
  325. sql.Clear();
  326. sql.Append("insert into MAKEBADRSPART(mbp_id,mbp_indate,mbp_inman,mbp_sncode, mbp_badcode, mbp_part, mbp_makecode, mbp_sccode,mbp_barcode)values");
  327. 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 + "')");
  328. dh.BatchInsert(sql.GetString(), new string[] { "bc_code" }, bccode);
  329. }
  330. //craftmaterial解除相应物料绑定
  331. sql.Clear();
  332. sql.Append("update craftmaterial set cm_status=-1,cm_dropman='" + User.UserName + "',");
  333. sql.Append("cm_dropdate =sysdate,cm_dropstep='" + User.CurrentStepName + "',");
  334. sql.Append("cm_dropsccode='" + User.CurrentStepCode + "' where cm_id='" + LabelDataGridView.Rows[i].Cells["cm_id"].Value + "'");
  335. dh.ExecuteSql(sql.GetString(), "update");
  336. //更新序列号信息
  337. sql.Clear();
  338. 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 + "'");
  339. dh.ExecuteSql(sql.GetString(), "update");
  340. OperateResult.AppendText("物料" + LabelDataGridView.Rows[i].Cells["cm_barcode"].Value + "拆解成功\n", Color.Green);
  341. decompose = true;
  342. LogicHandler.DoCommandLog(Tag.ToString(), User.UserCode, ms_makecode.Text, User.UserLineCode, User.UserSourceCode, "物料" + LabelDataGridView.Rows[i].Cells["cm_barcode"].Value + "拆解", "拆解成功", ms_sncode.Text, "");
  343. }
  344. else
  345. {
  346. OperateResult.AppendText(">>>没有选择拆解方式\n", Color.Red);
  347. return;
  348. }
  349. }
  350. }
  351. }
  352. if (decompose)
  353. {
  354. count++;
  355. deccount.Text = count + "";
  356. LoadData(sncode_1,sender, new KeyEventArgs(Keys.Enter));
  357. }
  358. else
  359. {
  360. OperateResult.AppendText("没有成功拆解项\n", Color.Red);
  361. }
  362. }
  363. private void LabelDataGridView_Sorted(object sender, EventArgs e)
  364. {
  365. LoadBadcode(sender, e);
  366. }
  367. }
  368. }