Make_Repair.cs 24 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472
  1. using System;
  2. using System.Collections;
  3. using System.Collections.Generic;
  4. using System.Data;
  5. using System.Drawing;
  6. using System.Text;
  7. using System.Windows.Forms;
  8. using UAS_MES.CustomControl.DataGrid_View;
  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_Repair : Form
  15. {
  16. string caller = "Make!Repair";
  17. //记录维修结果的代码值
  18. string Repair_Result;
  19. //记录不良状态码
  20. string badcode;
  21. //记录不良组别
  22. string groupcode;
  23. //判断是否获取了下拉框的值
  24. string mb_id1;
  25. //记录插入操作日志表的sql
  26. string cm_makecode;
  27. //执行插入日志的SQL
  28. string insert_makeprocess = "insert into makeprocess(mp_id,mp_makecode,mp_maid, mp_mscode,mp_sncode,mp_stepcode,mp_stepname,mp_craftcode,mp_craftname,mp_kind,mp_result,mp_indate,mp_inman,mp_wccode,mp_linecode,mp_sourcecode) select MakeProcess_seq.nextval, ma_code,ma_id,ms_code,ms_sncode,mcd_stepcode,mcd_stepname,ma_craftcode,'','维修作业','#',sysdate,'" + User.UserName + "',ma_wccode,ma_linecode,'' from make left join makecraftdetail on mcd_macode=ma_code left join makeserial on ms_makecode=ma_code where ms_sncode=:ms_sncode and ma_code=:ma_code";
  29. //是否获取过下拉框数据
  30. bool GetSelectData = false;
  31. string mb_id = "";
  32. string mbr_id = "";
  33. /// <summary>
  34. /// 存放父节点信息
  35. /// </summary>
  36. Dictionary<string, Dictionary<string, string>> BadInf_1 = new Dictionary<string, Dictionary<string, string>>();
  37. /// <summary>
  38. /// 存放子节点信息
  39. /// </summary>
  40. Dictionary<string, Dictionary<string, string>> BadInf_2 = new Dictionary<string, Dictionary<string, string>>();
  41. DataHelper dh = null;
  42. LogStringBuilder sql = new LogStringBuilder();
  43. List<string> sqls = new List<string>();
  44. DataTable dt = null;
  45. AutoSizeFormClass asc = new AutoSizeFormClass();
  46. string macode;
  47. string msid = "";
  48. string dbtable1 = "(select distinct nvl(dsl_prodcode,msl_prodcode)prodcode from ReduceStepRecord left join devsmtlocation on dsl_linecode=rsd_linecode and dsl_makecode=rsd_macode left join makesmtlocation on msl_linecode=rsd_linecode and msl_makecode=rsd_macode where rsd_macode=':macode' and rsd_sncode=':sncode') left join product on pr_code=prodcode";
  49. string dbtable2 = "(select distinct nvl(dsl_prodcode,msl_prodcode)prodcode from ReduceStepRecord left join devsmtlocation on dsl_linecode=rsd_linecode and dsl_makecode=rsd_macode left join makesmtlocation on msl_linecode=rsd_linecode and msl_makecode=rsd_macode where rsd_macode=':macode' and rsd_sncode=':sncode' and ((dsl_location=':msl_location' and dsl_validtime<sysdate and sysdate<dsl_invalidtime) ) or (msl_location=':msl_location' and msl_validtime<sysdate and sysdate<msl_invalidtime)) left join product on pr_code=prodcode";
  50. public Make_Repair()
  51. {
  52. InitializeComponent();
  53. }
  54. private void 维修作业_Load(object sender, EventArgs e)
  55. {
  56. dh = new DataHelper();
  57. //为DBFind配置Call和Form的名称
  58. cr_code.FormName = Name;
  59. cr_code.TableName = "craft";
  60. cr_code.SelectField = "cr_name # 工艺名称,cr_code # 工艺编号,cr_prodcode # 物料编号";
  61. cr_code.SetValueField = new string[] { "cr_code" };
  62. cr_code.DBTitle = "回流工艺";
  63. cd_stepcode.FormName = Name;
  64. cd_stepcode.TableName = "craftdetail left join step on st_code=cd_stepcode left join craft on cd_crid=cr_id";
  65. cd_stepcode.SetValueField = new string[] { "cd_stepcode" };
  66. cd_stepcode.SelectField = "cd_stepname # 工序名称 ,cd_stepcode # 工序编号,cd_stepno # 执行顺序";
  67. cd_stepcode.DBTitle = "回流工序";
  68. prodcode.FormName = Name;
  69. prodcode.TableName = dbtable1.Replace(":macode", macode).Replace(":sncode", GetSNCode.Text);
  70. prodcode.SetValueField = new string[] { "prodcode" };
  71. prodcode.SelectField = "prodcode # 不良零件编号,pr_detail # 零件名称";
  72. prodcode.DBTitle = "不良零件";
  73. asc.controllInitializeSize(this);
  74. GetSNCode.Focus();
  75. }
  76. private void GetSNCode_KeyDown(object sender, KeyEventArgs e)
  77. {
  78. if (e.KeyCode == Keys.Enter)
  79. {
  80. if (GetSNCode.Text == "")
  81. {
  82. OperatResult.AppendText(">>序列号不允许为空\n", Color.Red);
  83. return;
  84. }
  85. string ms_status = dh.getFieldDataByCondition("Makeserial", "ms_status", "ms_sncode='" + GetSNCode.Text + "'").ToString();
  86. if (ms_status == "4")
  87. {
  88. OperatResult.AppendText(">>序列号:" + GetSNCode.Text + "已处于报废状态\n", Color.Red);
  89. return;
  90. }
  91. if (ms_status != "3")
  92. {
  93. OperatResult.AppendText(">>序列号:" + GetSNCode.Text + "不处于维修状态\n", Color.Red);
  94. return;
  95. }
  96. string ErrorMessage = "";
  97. //验证工序是否正确
  98. if (LogicHandler.CheckStepAttribute(Tag.ToString(), User.UserSourceCode, out ErrorMessage))
  99. {
  100. BadInf_1.Clear();
  101. if (LogicHandler.GetMakeInfo(GetSNCode.Text, out macode, out ErrorMessage))
  102. {
  103. //验证makeserial或者ms_firstsn表序列号是否存在
  104. sql.Clear();
  105. sql.Append("select max(ms_id) ms_id,ms_makecode,ms_prodcode,ms_sncode,pr_detail,ms_stepcode,ms_craftcode ");
  106. sql.Append("from makeserial left join product on pr_code=ms_prodcode where ms_makecode ='" + macode + "' and(ms_sncode");
  107. sql.Append("='" + GetSNCode.Text + "' or ms_firstsn in (select firstsn from makesnrelation where ");
  108. sql.Append("sn='" + GetSNCode.Text + "')) group by ms_makecode,ms_prodcode,ms_sncode,pr_detail,ms_stepcode,ms_craftcode");
  109. dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
  110. if (dt.Rows.Count > 0)
  111. {
  112. msid = dt.Rows[0]["ms_id"].ToString();
  113. BaseUtil.SetFormValue(this.Controls, dt);
  114. LoadBadInfTree(sender, e);
  115. }
  116. else OperatResult.AppendText(">>" + ErrorMessage + "\n", Color.Red);
  117. }
  118. else OperatResult.AppendText(">>" + ErrorMessage + "\n", Color.Red);
  119. }
  120. else OperatResult.AppendText(">>" + ErrorMessage + "\n", Color.Red);
  121. }
  122. }
  123. private void Make_Repair_SizeChanged(object sender, EventArgs e)
  124. {
  125. asc.controlAutoSize(this);
  126. }
  127. private void BadCodeTree_NodeMouseClick(object sender, TreeNodeMouseClickEventArgs e)
  128. {
  129. if (e.Node.Level == 0)
  130. {
  131. mb_id = e.Node.Tag.ToString();
  132. BaseUtil.CleanControlsText(bc_name, bc_code, bg_name, bg_code, mb_badremark, nrg_name, nr_name, nr_code, mbr_solutioncode, mbr_dutycode, mbc_component);
  133. bc_name.Text = BadInf_1[mb_id]["bc_name"];
  134. bc_code.Text = BadInf_1[mb_id]["mb_badcode"];
  135. bg_name.Text = BadInf_1[mb_id]["bg_name"];
  136. bg_code.Text = BadInf_1[mb_id]["mb_bgcode"];
  137. mb_badremark.Text = BadInf_1[mb_id]["mb_badremark"];
  138. }
  139. if (e.Node.Level == 1)
  140. {
  141. mbr_id = e.Node.Tag.ToString();
  142. nrg_name.Text = BadInf_2[mbr_id]["nrg_name"];
  143. nr_name.Text = BadInf_2[mbr_id]["nr_name"];
  144. nr_code.Text = BadInf_2[mbr_id]["nr_code"];
  145. mbr_solutioncode.Text = BadInf_2[mbr_id]["so_name"];
  146. mbr_dutycode.Text = BadInf_2[mbr_id]["mbr_dutycode"];
  147. mbc_component.Text = dh.getFieldDataByCondition("makebadrscom", "mbc_component", "mbc_mbrid=" + mbr_id).ToString();
  148. //加载两个Grid的数据源
  149. mbp_partdgv.DataSource = (DataTable)dh.ExecuteSql("select mbp_id,mbp_part from makebadrspart where mbp_mbrid=" + mbr_id, "select");
  150. mbl_locdgv.DataSource = (DataTable)dh.ExecuteSql("select mbl_id,mbl_loc from makebadrsloc where mbl_mbrid=" + mbr_id, "select");
  151. }
  152. }
  153. private void LoadBadInfTree(object sender, EventArgs e)
  154. {
  155. BadCodeTree.Nodes.Clear();
  156. sql.Clear();
  157. 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,");
  158. sql.Append("mb_badremark from makebad left join badcode on bc_code=mb_badcode left join badgroup ");
  159. sql.Append("on bg_code=mb_bgcode where mb_sncode='" + (GetSNCode.Text == "" ? ms_sncode.Text : GetSNCode.Text) + "' and mb_makecode='" + macode + "'");
  160. dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
  161. for (int i = 0; i < dt.Rows.Count; i++)
  162. {
  163. //添加根节点
  164. TreeNode tnode_0 = new TreeNode();
  165. string bg_name = dt.Rows[i]["bg_name"].ToString();
  166. string bc_name = dt.Rows[i]["bc_name"].ToString();
  167. string mb_badcode = dt.Rows[i]["mb_badcode"].ToString();
  168. string mb_bgcode = dt.Rows[i]["mb_bgcode"].ToString();
  169. tnode_0.Text = (bg_name == "" ? mb_bgcode : bg_name) + ":" + (bc_name == "" ? mb_bgcode : bc_name);
  170. tnode_0.Name = dt.Rows[i]["mb_bgcode"].ToString();
  171. //作为Dictionary的主标识
  172. string mb_id = dt.Rows[i]["mb_id"].ToString();
  173. tnode_0.Tag = mb_id;
  174. Dictionary<string, string> dic = new Dictionary<string, string>();
  175. dic.Add("mb_id", mb_id);
  176. dic.Add("mb_sncode", dt.Rows[i]["mb_sncode"].ToString());
  177. dic.Add("mb_badcode", dt.Rows[i]["mb_badcode"].ToString());
  178. dic.Add("mb_bgcode", dt.Rows[i]["mb_bgcode"].ToString());
  179. dic.Add("bc_name", dt.Rows[i]["bc_name"].ToString());
  180. dic.Add("bg_name", dt.Rows[i]["bg_name"].ToString());
  181. dic.Add("mb_badremark", dt.Rows[i]["mb_badremark"].ToString());
  182. if (!BadInf_1.ContainsKey(tnode_0.Tag.ToString()))
  183. BadInf_1.Add(tnode_0.Tag.ToString(), dic);
  184. BadCodeTree.Nodes.Add(tnode_0);
  185. //添加子节点
  186. sql.Clear();
  187. sql.Append("select mbr_id,mbr_brcode,mbr_brgcode,mbr_solutioncode,so_name,mbr_dutycode,nd_name,nrg_name");
  188. sql.Append(",nr_name,nr_code from makebadreason left join QUA_NGReason left join QUA_NGREASONGROUP on ");
  189. sql.Append("nrg_code=nr_group on nr_code=mbr_brcode left join solution on so_code=mbr_solutioncode ");
  190. sql.Append("left join ngduty on nd_code=mbr_dutycode where mbr_mbid=" + mb_id);
  191. DataTable dt1 = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
  192. for (int j = 0; j < dt1.Rows.Count; j++)
  193. {
  194. TreeNode tnode_1 = new TreeNode();
  195. //存放子节点的信息
  196. Dictionary<string, string> dic1 = new Dictionary<string, string>();
  197. string mbr_id = dt1.Rows[j]["mbr_id"].ToString();
  198. tnode_1.Tag = mbr_id;
  199. dic1.Add("mbr_id", mbr_id);
  200. dic1.Add("mbr_brcode", dt1.Rows[j]["mbr_id"].ToString());
  201. dic1.Add("mbr_brgcode", dt1.Rows[j]["mbr_brcode"].ToString());
  202. dic1.Add("mbr_solutioncode", dt1.Rows[j]["mbr_solutioncode"].ToString());
  203. dic1.Add("mbr_dutycode", dt1.Rows[j]["mbr_dutycode"].ToString());
  204. dic1.Add("nd_name", dt1.Rows[j]["nd_name"].ToString());
  205. dic1.Add("so_name", dt1.Rows[j]["so_name"].ToString());
  206. dic1.Add("nrg_name", dt1.Rows[j]["nrg_name"].ToString());
  207. dic1.Add("nr_name", dt1.Rows[j]["nr_name"].ToString());
  208. dic1.Add("nr_code", dt1.Rows[j]["nr_code"].ToString());
  209. tnode_1.Text = dt1.Rows[j]["mbr_brgcode"].ToString();
  210. if (!BadInf_2.ContainsKey(mbr_id))
  211. BadInf_2.Add(mbr_id, dic1);
  212. tnode_0.Nodes.Add(tnode_1);
  213. }
  214. }
  215. try
  216. {
  217. if (bg_code.Text != "")
  218. BadCodeTree.Nodes[bg_code.Text].Expand();
  219. }
  220. catch (Exception) { }
  221. }
  222. private void RefreshTreeView_Click(object sender, EventArgs e)
  223. {
  224. LoadBadInfTree(sender, e);
  225. }
  226. private void RepairComplete_Click(object sender, EventArgs e)
  227. {
  228. if (ms_sncode.Text == "")
  229. {
  230. OperatResult.AppendText(">>序列号不允许为空\n", Color.Red);
  231. return;
  232. }
  233. //判断是否所有的不良信息都有维护不良原因
  234. DataTable dt = (DataTable)dh.ExecuteSql("select mb_id,bc_name,mbr_mbid from makebad left join makebadreason on mbr_mbid=mb_id left join badcode on mb_badcode=bc_code where mb_sncode='" + ms_sncode.Text + "'", "select");
  235. string ErrorMessage = "";
  236. for (int i = 0; i < dt.Rows.Count; i++)
  237. {
  238. if (dt.Rows[i]["mb_id"].ToString() != dt.Rows[i]["mbr_mbid"].ToString())
  239. ErrorMessage += "【" + dt.Rows[i]["bc_name"].ToString() + "】";
  240. }
  241. if (ErrorMessage != "")
  242. {
  243. OperatResult.AppendText(">>" + ErrorMessage + "未维护不良原因\n", Color.Red);
  244. return;
  245. }
  246. dt = (DataTable)dh.ExecuteSql("select cr_id from craft where cr_statuscode='AUDITED' and cr_code='" + cr_code.Text + "'", "select");
  247. if (dt.Rows.Count == 0)
  248. OperatResult.AppendText(">>回流工序不存在\n", Color.Red);
  249. else
  250. {
  251. string cr_id = dt.Rows[0]["cr_id"].ToString();
  252. dt = (DataTable)dh.ExecuteSql("select cd_ifinput from craftdetail left join step on st_code=cd_stepcode where cd_crid='" + cr_id + "' and cd_stepcode='" + cd_stepcode.Text + "' and st_statuscode='AUDITED'", "select");
  253. if (dt.Rows.Count == 0)
  254. OperatResult.AppendText(">>回流工序不在回流工艺中\n", Color.Red);
  255. else
  256. {
  257. dh.UpdateByCondition("makeserial", "ms_nextstepcode='" + cd_stepcode.Text + "',ms_craftcode='" + cr_code.Text + "',ms_stepcode='" + User.CurrentStepCode + "',ms_status=1", "ms_sncode='" + ms_sncode.Text + "'");
  258. dh.ExecuteSql(insert_makeprocess.Replace("#", "完成维修"), "insert", ms_sncode.Text, User.CurrentStepCode);
  259. OperatResult.AppendText(">>" + ms_sncode.Text + " 序列号回流成功\n", Color.Green);
  260. GetSNCode.Clear();
  261. }
  262. }
  263. }
  264. private void Scrap_Click(object sender, EventArgs e)
  265. {
  266. if (ms_sncode.Text != "") {
  267. //判断是否有无法维修的记录
  268. int ScrapNum = int.Parse(dh.getFieldDataByCondition("makebad", "count(0) cn", "mb_sncode='" + ms_sncode.Text + "'").ToString());
  269. if (ScrapNum == 0)
  270. OperatResult.AppendText(">>" + ms_sncode.Text + "存在无法维修的记录才允许报废\n", Color.Red);
  271. else
  272. {
  273. string confirm = MessageBox.Show(this.ParentForm, "此操作不可撤销,是否确认报废", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Asterisk).ToString();
  274. if (confirm == "Yes")
  275. {
  276. dh.UpdateByCondition("makeserial", "ms_status=4,ms_nextstepcode='',ms_stepcode='" + User.CurrentStepCode + "'", "ms_sncode='" + ms_sncode.Text + "' and ms_makecode='" + macode + "'");
  277. dh.UpdateByCondition("make", "MA_NGMADEQTY=nvl(MA_NGMADEQTY,0)+1", "ma_code='" + macode + "'");
  278. OperatResult.AppendText(">>报废成功\n", Color.Green);
  279. GetSNCode.Clear();
  280. BaseUtil.CleanForm(this);
  281. BadCodeTree.Nodes.Clear();
  282. }
  283. }
  284. }
  285. else OperatResult.AppendText(">>序列号不允许为空\n", Color.Red);
  286. }
  287. private void NewBadCode_Click(object sender, EventArgs e)
  288. {
  289. Make_NewBadCode badcode = new Make_NewBadCode(GetSNCode.Text, macode);
  290. badcode.FormClosed += LoadBadInfTree;
  291. BaseUtil.SetFormCenter(badcode);
  292. badcode.ShowDialog();
  293. }
  294. private void NewRepairInf_Click(object sender, EventArgs e)
  295. {
  296. Make_NewMatainInf mataininf = new Make_NewMatainInf(bg_name.Text, bg_code.Text, bc_name.Text, bc_code.Text, GetSNCode.Text, msid, mb_id);
  297. mataininf.FormClosed += LoadBadInfTree;
  298. BaseUtil.SetFormCenter(mataininf);
  299. mataininf.ShowDialog();
  300. }
  301. private void SaveRepairInf_Click(object sender, EventArgs e)
  302. {
  303. //保存不良零件
  304. DataTable dt = (DataTable)mbp_partdgv.DataSource;
  305. if (dt != null && dt.Rows.Count > 0)
  306. {
  307. List<string> prodcode = new List<string>();
  308. for (int i = 0; i < dt.Rows.Count; i++)
  309. {
  310. if (dt.Rows[i]["mbp_id"].ToString() == "")
  311. prodcode.Add(dt.Rows[i]["mbp_part"].ToString());
  312. }
  313. if (prodcode.Count > 0)
  314. {
  315. sql.Clear();
  316. sql.Append("insert into makebadrspart(mbp_id,mbp_mbrid,mbp_part,mbp_badcode,");
  317. sql.Append("mbp_brcode,mbp_sncode,mbp_makecode,mbp_indate,mbp_inman)");
  318. sql.Append("select makebadrspart_seq.nextval," + mbr_id + ",:prodcode,");
  319. sql.Append("'" + bc_code.Text + "','" + nr_code.Text + "','" + GetSNCode.Text + "','" + macode + "',");
  320. sql.Append("sysdate,'" + User.UserCode + "' from dual");
  321. dh.BatchInsert(sql.GetString(), new string[] { "prodcode" }, prodcode.ToArray());
  322. }
  323. OperatResult.AppendText(">>不良零件保存成功\n", Color.Green);
  324. }
  325. //保存不良位置
  326. dt = (DataTable)mbl_locdgv.DataSource;
  327. if (dt != null && dt.Rows.Count > 0)
  328. {
  329. List<string> location = new List<string>();
  330. for (int i = 0; i < dt.Rows.Count; i++)
  331. {
  332. if (dt.Rows[i]["mbl_id"].ToString() == "")
  333. location.Add(dt.Rows[i]["mbl_loc"].ToString());
  334. }
  335. if (location.Count > 0)
  336. {
  337. sql.Clear();
  338. sql.Append("insert into makebadrsloc(mbl_id,mbl_mbrid,mbl_loc,mbl_badcode,mbl_brcode,");
  339. sql.Append("mbl_sncode,mbl_makecode,mbl_indate ,mbl_inman) select makebadrsloc_seq.nextval," + mbr_id);
  340. sql.Append(",:location,'" + bc_code.Text + "','" + nr_code.Text + "','" + GetSNCode.Text + "','" + macode + "',");
  341. sql.Append("sysdate,'" + User.UserCode + "' from dual");
  342. dh.BatchInsert(sql.GetString(), new string[] { "location" }, location.ToArray());
  343. }
  344. OperatResult.AppendText(">>不良位置保存成功\n", Color.Green);
  345. }
  346. }
  347. private void DeleteRepairInf_Click(object sender, EventArgs e)
  348. {
  349. DataTable dt = (DataTable)dh.ExecuteSql("select ms_makecode from makeserial where ms_id='" + msid + "' and ms_sncode='" + GetSNCode.Text + "' and ms_status=3", "select");
  350. if (dt.Rows.Count > 0)
  351. {
  352. if (mbr_id != "")
  353. {
  354. string delete1 = "delete from makebadrsloc where mbl_mbrid=" + mbr_id;
  355. string delete2 = "delete from makebadrspart where mbp_mbrid=" + mbr_id;
  356. string delete3 = "delete from makebadrscom where mbc_mbrid=" + mbr_id;
  357. string delete4 = "delete from makebadreason where mbr_id=" + mbr_id;
  358. dh.ExecuteSQLTran(delete1, delete2, delete3, delete4);
  359. OperatResult.AppendText(">>删除成功\n", Color.Green);
  360. BaseUtil.CleanControlsText(bc_name, bc_code, bg_name, bg_code, mb_badremark, nrg_name, nr_name, nr_code, mbr_solutioncode, mbr_dutycode, mbc_component);
  361. mbp_partdgv.DataSource = null;
  362. mbl_locdgv.DataSource = null;
  363. mbr_id = "";
  364. //删除后重新加载Tree的信息
  365. LoadBadInfTree(sender, e);
  366. }
  367. else OperatResult.AppendText(">>必须选择不良原因\n", Color.Red);
  368. }
  369. else OperatResult.AppendText(">>" + GetSNCode.Text + "序列号错误,不存在或者不处于维修状态\n", Color.Red);
  370. }
  371. private void SaveBadLocation_Click(object sender, EventArgs e)
  372. {
  373. DataTable dt = (DataTable)dh.ExecuteSql("select ms_makecode from makeserial where ms_id='" + msid + "' and ms_sncode='" + GetSNCode.Text + "' and ms_status=3", "select");
  374. if (dt.Rows.Count > 0)
  375. {
  376. if (mbl_loc.Text != "")
  377. {
  378. if (mbr_id != "")
  379. {
  380. dt = (DataTable)mbl_locdgv.DataSource;
  381. DataRow dr = dt.NewRow();
  382. dr["mbl_loc"] = mbl_loc.Text;
  383. dt.Rows.Add(dr);
  384. }
  385. else OperatResult.AppendText(">>请先选择不良原因\n", Color.Red);
  386. }
  387. else OperatResult.AppendText(">>不良位置不能为空\n", Color.Red);
  388. }
  389. else OperatResult.AppendText(">>" + GetSNCode.Text + "序列号错误,不存在或者不处于维修状态\n", Color.Red);
  390. }
  391. private void mbl_loc_TextChanged(object sender, EventArgs e)
  392. {
  393. if (mbl_loc.Text != "")
  394. prodcode.TableName = dbtable2.Replace(":macode", macode).Replace(":sncode", GetSNCode.Text).Replace(":msl_location", mbl_loc.Text);
  395. }
  396. private void nr_name_TextChanged(object sender, EventArgs e)
  397. {
  398. if (nr_name.Text == "")
  399. SaveBadLocation.Enabled = false;
  400. else
  401. SaveBadLocation.Enabled = true;
  402. }
  403. private void mbl_loc_KeyDown(object sender, KeyEventArgs e)
  404. {
  405. if (e.KeyCode == Keys.Enter)
  406. SaveBadLocation_Click(sender, e);
  407. }
  408. private void prodcode_TextKeyDown(object sender, KeyEventArgs e)
  409. {
  410. if (e.KeyCode == Keys.Enter)
  411. {
  412. if (prodcode.Text != "")
  413. {
  414. if (mbr_id != "")
  415. {
  416. DataTable dt = (DataTable)mbp_partdgv.DataSource;
  417. DataRow dr = dt.NewRow();
  418. dr["mbp_part"] = prodcode.Text;
  419. dt.Rows.Add(dr);
  420. }
  421. else OperatResult.AppendText(">>请先选择不良原因\n", Color.Red);
  422. }
  423. else OperatResult.AppendText(">>不良零件不能为空\n", Color.Red);
  424. }
  425. }
  426. private void cr_code_UserControlTextChanged(object sender, EventArgs e)
  427. {
  428. cd_stepcode.Condition = "ST_STATUSCODE='AUDITED' and cr_code='" + cr_code.Text + "'";
  429. }
  430. private void Clean_Click(object sender, EventArgs e)
  431. {
  432. OperatResult.Clear();
  433. }
  434. }
  435. }