Make_TestCollection.cs 27 KB

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