Make_TestCollection.cs 28 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610
  1. using System;
  2. using System.Data;
  3. using System.Text;
  4. using System.Threading;
  5. using System.Drawing;
  6. using System.Windows.Forms;
  7. using UAS_MES.DataOperate;
  8. using UAS_MES.Entity;
  9. using UAS_MES.PublicMethod;
  10. using System.Collections.Generic;
  11. using UAS_MES.CustomControl.PowerControlForm;
  12. namespace UAS_MES.Make
  13. {
  14. public partial class Make_TestCollection : Form
  15. {
  16. DataHelper dh = null;
  17. DataTable dt = null;
  18. //当前工序的名称
  19. string ErrorMessage = "";
  20. //用于保存是否之前输入的ms_sncode
  21. string LastSncode;
  22. string oMakeCode = "";
  23. string oMSID = "";
  24. string ifrework = "";
  25. string reworkstatus = "";
  26. LogStringBuilder sql = new LogStringBuilder();
  27. AutoSizeFormClass asc = new AutoSizeFormClass();
  28. /// <summary>
  29. /// 已选的不良
  30. /// </summary>
  31. List<string> ChoosedList = new List<string>();
  32. /// <summary>
  33. /// 待选的不良
  34. /// </summary>
  35. List<string> WaitList = new List<string>();
  36. bool AutoCut = false;
  37. DataTable Dbfind;
  38. public Make_TestCollection()
  39. {
  40. InitializeComponent();
  41. }
  42. private void TestCollection_Load(object sender, EventArgs e)
  43. {
  44. dh = new DataHelper();
  45. GoodProduct.Checked = true;
  46. asc.controllInitializeSize(this);
  47. ms_sncode.Focus();
  48. //设置锁定工单
  49. LockMakeCode.GetMakeCodeCtl(ma_code);
  50. ma_code.SetLockCheckBox(LockMakeCode);
  51. //工单号放大镜配置
  52. ma_code.TableName = "make left join product on ma_prodcode=pr_code";
  53. ma_code.SelectField = "ma_code # 工单号,ma_prodcode # 产品编号,ma_qty # 工单数量,pr_detail # 产品名称";
  54. ma_code.FormName = Name;
  55. ma_code.SetValueField = new string[] { "ma_code", "ma_prodcode", "ma_qty", "pr_detail" };
  56. ma_code.Condition = "ma_statuscode='STARTED'";
  57. ma_code.DbChange += Ma_code_DbChange;
  58. }
  59. private void Ma_code_DbChange(object sender, EventArgs e)
  60. {
  61. Dbfind = ma_code.ReturnData;
  62. BaseUtil.SetFormValue(this.Controls,Dbfind);
  63. }
  64. /// <summary>
  65. /// 将已选不良移动到待选不良
  66. /// </summary>
  67. /// <param name="sender"></param>
  68. /// <param name="e"></param>
  69. private void WaitReject_Click(object sender, EventArgs e)
  70. {
  71. int CheckedNum = 0;
  72. //已存在在ListView中的Item是不能添加到其他ListView中的,需要调用其克隆的方法
  73. for (int i = ChoosedRejectList.Items.Count - 1; i >= 0; i--)
  74. {
  75. if (ChoosedRejectList.Items[i].Checked)
  76. {
  77. WaitRejectList.Items.Add((ListViewItem)ChoosedRejectList.Items[i].Clone());
  78. ChoosedRejectList.Items[i].Remove();
  79. CheckedNum++;
  80. }
  81. }
  82. if (CheckedNum == 0)
  83. {
  84. for (int i = ChoosedRejectList.Items.Count - 1; i >= 0; i--)
  85. {
  86. WaitRejectList.Items.Add((ListViewItem)ChoosedRejectList.Items[i].Clone());
  87. ChoosedRejectList.Items[i].Remove();
  88. }
  89. }
  90. }
  91. /// <summary>
  92. /// 将不良信息移动到已选不良
  93. /// </summary>
  94. /// <param name="sender"></param>
  95. /// <param name="e"></param>
  96. private void ChooseedReject_Click(object sender, EventArgs e)
  97. {
  98. if (ms_sncode.Text == "")
  99. {
  100. OperateResult.AppendText(">>序列号不能为空\n", Color.Red);
  101. ms_sncode.Focus();
  102. return;
  103. }
  104. int CheckedNum = 0;
  105. //是否已经添加到不良
  106. bool AddToReject = false;
  107. for (int i = WaitRejectList.Items.Count - 1; i >= 0; i--)
  108. {
  109. if (WaitRejectList.Items[i].Checked)
  110. {
  111. AddToReject = false;
  112. for (int j = 0; j < ChoosedRejectList.Items.Count; j++)
  113. {
  114. if ((ChoosedRejectList.Items[j].SubItems[2].Text == WaitRejectList.Items[i].SubItems[2].Text))
  115. {
  116. AddToReject = true;
  117. break;
  118. }
  119. }
  120. //未添加则进行添加
  121. if (!AddToReject)
  122. {
  123. ChoosedRejectList.Items.Add((ListViewItem)WaitRejectList.Items[i].Clone());
  124. WaitRejectList.Items[i].Remove();
  125. CheckedNum++;
  126. }
  127. }
  128. }
  129. if (CheckedNum == 0)
  130. {
  131. OperateResult.AppendText(">>请勾选不良代码\n", Color.Red);
  132. }
  133. }
  134. private void CleanInfo_Click(object sender, EventArgs e)
  135. {
  136. OperateResult.Clear();
  137. }
  138. private void ms_code_KeyDown(object sender, KeyEventArgs e)
  139. {
  140. if (e.KeyCode == Keys.Enter)
  141. {
  142. ChoosedRejectList.Items.Clear();
  143. WaitList.Clear();
  144. ChoosedList.Clear();
  145. if (LogicHandler.CheckStepAttribute(Tag.ToString(), User.UserSourceCode, out ErrorMessage))
  146. {
  147. //判断界面工单是否为空时的序列号是否自动归属工单
  148. if (!LogicHandler.GetMakeInfo(ms_sncode.Text, out oMakeCode, out ErrorMessage))
  149. {
  150. if (ma_code.Text == "")
  151. {
  152. OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red, ms_sncode);
  153. return;
  154. }
  155. }
  156. if (LogicHandler.CheckStepSNAndMacode(ma_code.Text == "" ? oMakeCode : ma_code.Text, User.UserSourceCode, ms_sncode.Text, User.UserCode, out oMakeCode, out oMSID, out ErrorMessage))
  157. {
  158. dt = (DataTable)dh.ExecuteSql("select ma_code,ma_prodcode,pr_detail,ma_qty from make left join product on ma_prodcode=pr_code where ma_code='" + oMakeCode + "'", "select");
  159. if (dt.Rows.Count > 0)
  160. {
  161. BaseUtil.SetFormValue(this.Controls, dt);
  162. LockMakeCode.Checked = true;
  163. }
  164. dt = (DataTable)dh.ExecuteSql("select ms_nextstepcode,ms_reworkstatus,nvl(ms_ifrework,0)ms_ifrework,ms_stepcode,ms_status,nvl(st_ifrepair,0) st_ifrepair from makeserial left join step on ms_stepcode=st_code where ms_id='" + oMSID + "'", "select");
  165. string status = dt.Rows[0]["ms_status"].ToString();
  166. reworkstatus = dt.Rows[0]["ms_reworkstatus"].ToString();
  167. string stepcode = dt.Rows[0]["ms_stepcode"].ToString();
  168. string ifrepair = dt.Rows[0]["st_ifrepair"].ToString();
  169. ifrework = dt.Rows[0]["ms_ifrework"].ToString();
  170. if (GoodProduct.Checked)
  171. {
  172. if (ifrework != "0")
  173. {
  174. if (stepcode == User.CurrentStepCode && (reworkstatus == "1" || reworkstatus == "2") && ifrepair == "0")
  175. {
  176. OperateResult.AppendText(">>" + ms_sncode.Text + " 序列号已执行过" + User.CurrentStepCode + "工序,采集结果为良品\n", Color.Red, ms_sncode);
  177. return;
  178. }
  179. }
  180. else
  181. {
  182. if (stepcode == User.CurrentStepCode && (status == "1" || status == "2") && ifrepair == "0")
  183. {
  184. OperateResult.AppendText(">>" + ms_sncode.Text + " 序列号已执行过" + User.CurrentStepCode + "工序,采集结果为良品\n", Color.Red, ms_sncode);
  185. return;
  186. }
  187. }
  188. }
  189. SetCollectResult();
  190. }
  191. else OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red, ms_sncode);
  192. }
  193. else OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red, ms_sncode);
  194. }
  195. }
  196. private void bc_groupcode_SelectedIndexChanged(object sender, EventArgs e)
  197. {
  198. LoadBadCodeListView();
  199. }
  200. /// <summary>
  201. /// 填充不良组别信息
  202. /// </summary>
  203. private void LoadBadGroupData()
  204. {
  205. //如果ms_makecode的值修改过再去查询
  206. sql.Clear();
  207. sql.Append("select bg_code||':'||bg_name bg_name,bg_code from badgroup left join (select pb_badgroup,pr_kind ");
  208. sql.Append("from product left join productkind on pk_name=pr_kind ");
  209. sql.Append("left join productbadgroup on pk_code=PB_KINDCODE where pr_code='" + ma_prodcode.Text + "')");
  210. sql.Append("on pb_badgroup=bg_code order by pr_kind ");
  211. DataTable dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
  212. bc_groupcode.DisplayMember = "bg_name";
  213. bc_groupcode.ValueMember = "bg_code";
  214. bc_groupcode.DataSource = dt;
  215. }
  216. /// <summary>
  217. /// 加载不良代码的ListView的信息
  218. /// </summary>
  219. private void LoadBadCodeListView()
  220. {
  221. object bg_code = bc_groupcode.SelectedValue;
  222. sql.Clear();
  223. sql.Append("select bg_code||':'||bg_name bg_code,bc_code,bc_name from badgroupdetail ");
  224. sql.Append("left join badgroup on bg_id=bgd_bgid left join badcode on bgd_badcode=bc_code where ");
  225. sql.Append("bg_code='" + (bg_code != null ? bg_code.ToString() : "") + "' and bg_code is not null");
  226. dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
  227. //往listview中添加数据
  228. WaitRejectList.Items.Clear();
  229. WaitRejectList.BeginUpdate();
  230. for (int i = 0; i < dt.Rows.Count; i++)
  231. {
  232. if (!ChoosedList.Contains(dt.Rows[i]["bc_code"].ToString()))
  233. {
  234. ListViewItem lvi = new ListViewItem();
  235. //第一列是勾选列,设置列头文本为空
  236. lvi.Text = "";
  237. WaitList.Add(dt.Rows[i]["bc_code"].ToString());
  238. for (int j = 0; j < dt.Columns.Count; j++)
  239. lvi.SubItems.Add(dt.Rows[i][j].ToString());
  240. WaitRejectList.Items.Add(lvi);
  241. }
  242. }
  243. WaitRejectList.EndUpdate();
  244. }
  245. /// <summary>
  246. /// 加载已选不良的ListView
  247. /// </summary>
  248. private void LoadChoosedBadListView()
  249. {
  250. sql.Clear();
  251. sql.Append("select nvl(bg_code,mb_bgcode)||':'||nvl(bg_name,mb_badcode) bg_code,nvl(mb_badcode,bc_code) bc_code,bc_name from makebad ");
  252. sql.Append("left join badgroup on mb_bgcode=bg_code left join badcode on mb_badcode=bc_code ");
  253. sql.Append(" where mb_sncode='" + ms_sncode.Text + "' and mb_makecode='" + ma_code.Text + "' and mb_status=0");
  254. dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
  255. ChoosedRejectList.Items.Clear();
  256. ChoosedRejectList.BeginUpdate();
  257. for (int i = 0; i < dt.Rows.Count; i++)
  258. {
  259. ListViewItem lvi = new ListViewItem();
  260. //第一列是勾选列,设置列头文本为空
  261. lvi.Text = "";
  262. ChoosedList.Add(dt.Rows[i]["bc_code"].ToString());
  263. for (int j = 0; j < dt.Columns.Count; j++)
  264. lvi.SubItems.Add(dt.Rows[i][j].ToString());
  265. ChoosedRejectList.Items.Add(lvi);
  266. }
  267. ChoosedRejectList.EndUpdate();
  268. }
  269. /// <summary>
  270. /// 设置良品或者不良品的采集结果
  271. /// </summary>
  272. private void SetCollectResult()
  273. {
  274. string ErrorMessage = "";
  275. //如果勾选的是不良品
  276. if (Reject.Checked)
  277. {
  278. LoadBadCodeListView();
  279. LoadChoosedBadListView();
  280. OperateResult.AppendText(">>请采集不良代码\n", Color.Green);
  281. bc_code.Focus();
  282. //勾选了自动产生代码
  283. if (AutoBadCode.Checked)
  284. Save_Click(new object(), new EventArgs());
  285. }
  286. else if (GoodProduct.Checked)
  287. {
  288. //如果不是返修的
  289. if (ifrework == "0")
  290. {
  291. 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 + "' and mb_status=0", "select");
  292. for (int i = 0; i < dt.Rows.Count; i++)
  293. {
  294. if (dt.Rows[i]["mb_id"].ToString() != dt.Rows[i]["mbr_mbid"].ToString())
  295. ErrorMessage += "【" + dt.Rows[i]["bc_name"].ToString() + "】";
  296. }
  297. //存在不良记录
  298. if (ErrorMessage != "")
  299. {
  300. OperateResult.AppendText(">>序列号:" + ms_sncode.Text + " 已经判为不良品,不允许修改!\n", Color.Red);
  301. return;
  302. }
  303. else
  304. {
  305. //良品信息采集
  306. if (LogicHandler.UpdateMakeMessage(ms_sncode.Text, ma_code.Text, "良品采集", User.UserSourceCode, User.UserCode, "检测合格", out ErrorMessage))
  307. {
  308. LastSncode = ms_sncode.Text;
  309. OperateResult.AppendText(">>" + ms_sncode.Text + "良品采集成功\n", Color.Green, ms_sncode);
  310. //记录操作日志
  311. LogicHandler.DoCommandLog(User.UserCode, ma_code.Text, User.UserLineCode, User.UserSourceCode, "采集良品", "采集良品成功", LastSncode, ob_checkno.Text);
  312. }
  313. else OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red, ms_sncode);
  314. }
  315. }
  316. else
  317. {
  318. if (reworkstatus != "3")
  319. {
  320. if (LogicHandler.UpdateMakeMessage(ms_sncode.Text, ma_code.Text, "良品采集", User.UserSourceCode, User.UserCode, "检测合格", out ErrorMessage))
  321. {
  322. LastSncode = ms_sncode.Text;
  323. OperateResult.AppendText(">>" + ms_sncode.Text + "成功采集为良品\n", Color.Green, ms_sncode);
  324. //记录操作日志
  325. LogicHandler.DoCommandLog(User.UserCode, ma_code.Text, User.UserLineCode, User.UserSourceCode, "采集良品", "采集良品成功", LastSncode, ob_checkno.Text);
  326. }
  327. else OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red, ms_sncode);
  328. }
  329. else
  330. {
  331. OperateResult.AppendText(">>返修的不良序列号必须先进行维修\n", Color.Red);
  332. }
  333. }
  334. }
  335. //加载页面信息
  336. LoadCollectedNum();
  337. LoadCheckQTY();
  338. }
  339. private void 测试采集_SizeChanged(object sender, EventArgs e)
  340. {
  341. asc.controlAutoSize(this);
  342. }
  343. private void LoadCollectedNum()
  344. {
  345. dt = (DataTable)dh.ExecuteSql("select mcd_inqty,ma_qty-mcd_inqty mcd_remainqty from make left join makecraftdetail on mcd_macode=ma_code where ma_code='" + ma_code.Text + "' and mcd_stepcode='" + User.CurrentStepCode + "'", "select");
  346. BaseUtil.SetFormValue(Controls, dt);
  347. }
  348. private void Save_Click(object sender, EventArgs e)
  349. {
  350. if (ms_sncode.Text == "")
  351. {
  352. OperateResult.AppendText(">>序列号不允许为空\n", Color.Red);
  353. return;
  354. }
  355. if (GoodProduct.Checked)
  356. ms_code_KeyDown(sender, new KeyEventArgs(Keys.Enter));
  357. else if (Reject.Checked)
  358. {
  359. if (LogicHandler.CheckStepAttribute(Tag.ToString(), User.UserSourceCode, out ErrorMessage))
  360. {
  361. //判断界面工单是否为空时的序列号是否自动归属工单
  362. if (!LogicHandler.GetMakeInfo(ms_sncode.Text, out oMakeCode, out ErrorMessage))
  363. {
  364. if (ma_code.Text == "")
  365. {
  366. OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red, ms_sncode);
  367. return;
  368. }
  369. }
  370. if (LogicHandler.CheckStepSNAndMacode(ma_code.Text == "" ? oMakeCode : ma_code.Text, User.UserSourceCode, ms_sncode.Text, User.UserCode, out oMakeCode, out oMSID, out ErrorMessage))
  371. {
  372. dt = (DataTable)dh.ExecuteSql("select ma_code,ma_prodcode,pr_detail,ma_qty from make left join product on ma_prodcode=pr_code where ma_code='" + oMakeCode + "'", "select");
  373. if (dt.Rows.Count > 0)
  374. {
  375. BaseUtil.SetFormValue(this.Controls, dt);
  376. LockMakeCode.Checked = true;
  377. }
  378. }
  379. else OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red, ms_sncode);
  380. }
  381. else OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red, ms_sncode);
  382. int RejectCount = ChoosedRejectList.Items.Count;
  383. string[] bccode = new string[RejectCount];
  384. string[] bcremark = new string[RejectCount];
  385. string[] bgcode = new string[RejectCount];
  386. if (AutoBadCode.Checked)
  387. {
  388. string defaultvalue = Properties.Settings.Default.DefaultCollectionValue;
  389. bccode = new string[] { defaultvalue };
  390. bcremark = new string[] { defaultvalue };
  391. bgcode = new string[] { defaultvalue };
  392. }
  393. else
  394. {
  395. if (ChoosedRejectList.Items.Count == 0)
  396. {
  397. OperateResult.AppendText(">>不良品必须选择不良原因和不良代码!\n", Color.Red);
  398. return;
  399. }
  400. else
  401. {
  402. for (int i = 0; i < RejectCount; i++)
  403. {
  404. //截取分号前面的内容
  405. bgcode[i] = ChoosedRejectList.Items[i].SubItems[1].Text.Split(':')[0];
  406. //获取所有的不良代码
  407. bccode[i] = ChoosedRejectList.Items[i].SubItems[2].Text;
  408. //获取所有的不良备注
  409. bcremark[i] = bc_remark.Text;
  410. }
  411. }
  412. }
  413. //如果之前是良品的
  414. dt = dh.getFieldsDataByCondition("makeserial", new string[] { "ms_status", "ms_checkno" }, "ms_sncode='" + ms_sncode.Text + "' and ms_stepcode='" + User.CurrentStepCode + "'");
  415. if (dt.Rows.Count > 0)
  416. {
  417. string status = dt.Rows[0]["ms_status"].ToString();
  418. if (status == "1" || status == "2")
  419. {
  420. dh.UpdateByCondition("makecraftdetail", "mcd_okqty=mcd_okqty-1", "mcd_macode='" + ma_code.Text + "' and mcd_stepcode='" + User.CurrentStepCode + "'");
  421. dh.UpdateByCondition("makeserial", "ms_nextstepcode=''", "ms_sncode='" + ms_sncode.Text + "'");
  422. LogicHandler.DoCommandLog(User.UserCode, ma_code.Text, User.UserLineCode, User.UserSourceCode, "采集不良", "采集不良成功", ms_sncode.Text, ob_checkno.Text);
  423. }
  424. string checkno = dt.Rows[0]["ms_checkno"].ToString();
  425. //存在抽检批次更新为空
  426. if (checkno != "")
  427. dh.UpdateByCondition("makeserial", "ms_checkno=''", "ms_sncode='" + ms_sncode.Text + "' and ms_makecode='" + ma_code.Text + "'");
  428. }
  429. //不良信息采集,mb_status<>0的是之前维修保存的,不能删除
  430. dh.ExecuteSql("delete from makebad where mb_sncode='" + ms_sncode.Text + "' and mb_makecode='" + ma_code.Text + "' and nvl(mb_status,0)=0", "delete");
  431. if (LogicHandler.SetTestNGDetail(ms_sncode.Text, ma_code.Text, User.UserCode, User.UserSourceCode, "检查未通过", bgcode, bccode, bcremark, out ErrorMessage))
  432. {
  433. LastSncode = ms_sncode.Text;
  434. OperateResult.AppendText(">>" + ms_sncode.Text + "成功采集为不良\n", Color.Green);
  435. //记录操作日志
  436. ms_sncode.Text = "";
  437. //清除不良信息
  438. bc_code.Text = "";
  439. ChoosedRejectList.Items.Clear();
  440. LoadCollectedNum();
  441. WaitList.Clear();
  442. ChoosedList.Clear();
  443. }
  444. else
  445. OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red);
  446. }
  447. }
  448. private void bc_code_KeyDown(object sender, KeyEventArgs e)
  449. {
  450. if (e.KeyCode == Keys.Enter)
  451. {
  452. DataTable dt = dh.getFieldsDataByCondition("badcode", new string[] { "bc_groupcode", "bc_code", "bc_note" }, "bc_code='" + bc_code.Text + "'");
  453. if (dt.Rows.Count > 0)
  454. {
  455. for (int i = 0; i < ChoosedRejectList.Items.Count; i++)
  456. {
  457. if (ChoosedRejectList.Items[i].ListView.Items[i].SubItems[2].Text == bc_code.Text)
  458. {
  459. OperateResult.AppendText(">>已添加过不良代码" + bc_code.Text + "\n", Color.Red, bc_code);
  460. return;
  461. }
  462. }
  463. ListViewItem lvi = new ListViewItem();
  464. lvi.Text = "";
  465. for (int j = 0; j < dt.Columns.Count; j++)
  466. lvi.SubItems.Add(dt.Rows[0][j].ToString());
  467. ChoosedRejectList.Items.Add(lvi);
  468. }
  469. else OperateResult.AppendText(">>" + bc_code.Text + "不良代码不存在\n", Color.Red, bc_code);
  470. }
  471. }
  472. private void LoadCheckQTY()
  473. {
  474. sql.Clear();
  475. string condition = "";
  476. int nowcheckqty = int.Parse(ob_nowcheckqty.Text == "" ? "0" : ob_nowcheckqty.Text);
  477. int batchqty = int.Parse(ob_batchqty.Text == "" ? "0" : ob_batchqty.Text);
  478. if (nowcheckqty + 1 == batchqty && AutoCut)
  479. {
  480. condition = "and ob_status='UNCHECK' and ob_checkno='" + ob_checkno.Text + "'";
  481. }
  482. else
  483. {
  484. condition = "and ob_status='ENTERING' ";
  485. }
  486. sql.Append("select ob_batchqty,ob_nowcheckqty,ob_checkno from oqcbatch where ");
  487. sql.Append("ob_linecode='" + User.UserLineCode + "' and ob_prodcode='" + ma_prodcode.Text + "' and ");
  488. sql.Append("ob_stepcode='" + User.CurrentStepCode + "' " + condition);
  489. DataTable dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
  490. if (dt.Rows.Count > 0)
  491. {
  492. ob_sendqty.Text = dh.getFieldDataByCondition("oqcbatch", "sum(ob_nowcheckqty)","ob_makecode='"+ma_code.Text+"' and ob_status<>'ENTERING'").ToString();
  493. ob_batchqty.Text = dt.Rows[0]["ob_batchqty"].ToString();
  494. ob_nowcheckqty.Text = dt.Rows[0]["ob_nowcheckqty"].ToString();
  495. ob_checkno.Text = dt.Rows[0]["ob_checkno"].ToString();
  496. nowcheckqty = int.Parse(ob_nowcheckqty.Text == "" ? "0" : ob_nowcheckqty.Text);
  497. batchqty = int.Parse(ob_batchqty.Text == "" ? "0" : ob_batchqty.Text);
  498. if (nowcheckqty == batchqty)
  499. {
  500. ob_nowcheckqty.ForeColor = Color.Red;
  501. OperateResult.AppendText(">>当前采集数量已达到送检数量\n",Color.Red);
  502. }
  503. }
  504. else
  505. {
  506. ob_batchqty.Text = "";
  507. ob_nowcheckqty.Text = "";
  508. ob_checkno.Text = "";
  509. SendCheck.Enabled = false;
  510. }
  511. if (ob_batchqty.Text != "")
  512. {
  513. SendCheck.Enabled = true;
  514. }
  515. else
  516. {
  517. SendCheck.Enabled = false;
  518. }
  519. }
  520. private void GoodProduct_CheckedChanged(object sender, EventArgs e)
  521. {
  522. if (GoodProduct.Checked)
  523. {
  524. bc_code.Enabled = false;
  525. WaitReject.Enabled = false;
  526. ChooseedReject.Enabled = false;
  527. Save.Visible = false;
  528. }
  529. else
  530. {
  531. bc_code.Enabled = true;
  532. WaitReject.Enabled = true;
  533. ChooseedReject.Enabled = true;
  534. Save.Visible = true;
  535. }
  536. if (ms_sncode.Text == "")
  537. {
  538. ms_sncode.Focus();
  539. }
  540. }
  541. private void SendCheck_Click(object sender, EventArgs e)
  542. {
  543. sql.Clear();
  544. sql.Append("update oqcbatch set ob_status='UNCHECK' where ob_checkno ='" + ob_checkno.Text + "'");
  545. dh.ExecuteSql(sql.GetString(), "select");
  546. ob_sendqty.Text = dh.getFieldDataByCondition("oqcbatch", "sum(ob_nowcheckqty)", "ob_makecode='" + ma_code.Text + "' and ob_status<>'ENTERING'").ToString();
  547. ob_nowcheckqty.Text = "";
  548. ob_batchqty.Text = "";
  549. ob_nowcheckqty.ForeColor = Color.Black;
  550. SendCheck.Enabled = false;
  551. OperateResult.AppendText(">>批次" + ob_checkno.Text + "送检成功\n", Color.Green);
  552. ms_sncode.Focus();
  553. LogicHandler.InsertMakeProcess(LastSncode, ma_code.Text, User.UserSourceCode, "手动送检", "手动送检成功", User.UserCode);
  554. //记录操作日志
  555. LogicHandler.DoCommandLog(User.UserCode, ma_code.Text, User.UserLineCode, User.UserSourceCode, "手动送检", "手动送检成功", "", ob_checkno.Text);
  556. ob_checkno.Text = "";
  557. }
  558. private void ob_checkno_TextChanged(object sender, EventArgs e)
  559. {
  560. if (ob_checkno.Text != "")
  561. {
  562. string Cut = dh.getFieldDataByCondition("product left join oqcbatch on ob_prodcode=pr_code", "pr_ifautocutcheckno", "ob_checkno='" + ob_checkno.Text + "'").ToString();
  563. if (Cut == "" || Cut == "0")
  564. AutoCut = false;
  565. else
  566. AutoCut = true;
  567. SendCheck.Enabled = true;
  568. }
  569. }
  570. private void ma_code_UserControlTextChanged(object sender, EventArgs e)
  571. {
  572. //加载不良信息
  573. LoadCollectedNum();
  574. LoadCheckQTY();
  575. }
  576. }
  577. }