Make_TestCollection.cs 57 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219
  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_NEW.DataOperate;
  8. using UAS_MES_NEW.Entity;
  9. using UAS_MES_NEW.PublicMethod;
  10. using System.Collections.Generic;
  11. using UAS_MES_NEW.CustomControl.PowerControlForm;
  12. using UAS_MES_NEW.Properties;
  13. using System.IO;
  14. namespace UAS_MES_NEW.Make
  15. {
  16. public partial class Make_TestCollection : Form
  17. {
  18. DataHelper dh = null;
  19. DataTable dt = null;
  20. //当前工序的名称
  21. string ErrorMessage = "";
  22. //用于保存是否之前输入的ms_sncode
  23. string LastSncode;
  24. string oMakeCode = "";
  25. string oMSID = "";
  26. string ifrework = "";
  27. string reworkstatus = "";
  28. LogStringBuilder sql = new LogStringBuilder();
  29. AutoSizeFormClass asc = new AutoSizeFormClass();
  30. Boolean startcheck = false;
  31. int getcheck = 0;
  32. Dictionary <string,DateTime> dateTimeDictionary = new Dictionary<string, DateTime>();
  33. /// <summary>
  34. /// 已选的不良
  35. /// </summary>
  36. List<string> ChoosedList = new List<string>();
  37. /// <summary>
  38. /// 待选的不良
  39. /// </summary>
  40. List<string> WaitList = new List<string>();
  41. bool AutoCut = false;
  42. bool LockSn = false;
  43. DataTable Dbfind;
  44. public Make_TestCollection()
  45. {
  46. InitializeComponent();
  47. }
  48. private void TestCollection_Load(object sender, EventArgs e)
  49. {
  50. GoodProduct.Checked = true;
  51. asc.controllInitializeSize(this);
  52. ms_sncode.GotFocus += text_getfocus;
  53. ms_sncode.Focus();
  54. //设置锁定工单
  55. LockMakeCode.GetMakeCodeCtl(ma_code);
  56. ma_code.SetLockCheckBox(LockMakeCode);
  57. //ControlLockTimer.Tick += ControlLockTimer_Tick;
  58. ControlLockTimer.Interval = 20000;
  59. ControlLockTimer.Enabled = true;
  60. SMTBind.Checked = Settings.Default.SMTBIND;
  61. Control.CheckForIllegalCrossThreadCalls = false;
  62. FolderPath.Text = BaseUtil.GetCacheData("FolderPath").ToString();
  63. //工单号放大镜配置
  64. ma_code.TableName = "make left join product on ma_prodcode=pr_code";
  65. ma_code.SelectField = "ma_code # 工单号,ma_prodcode # 产品编号,ma_qty # 工单数量,pr_spec # 产品规格,ma_softversion # 软件版本,ma_salecode # 销售单号,pr_sendchecktype # 产品送检方式";
  66. ma_code.FormName = Name;
  67. ma_code.SetValueField = new string[] { "ma_code", "ma_prodcode", "ma_qty", "pr_spec", "ma_softversion", "ma_salecode", "nvl(pr_sendchecktype,'LineCode')pr_sendchecktype" };
  68. ma_code.Condition = "ma_statuscode='STARTED'";
  69. ma_code.DbChange += Ma_code_DbChange;
  70. dh = SystemInf.dh;
  71. StepCount.StepCode = User.CurrentStepCode;
  72. StepCount.Source = User.UserSourceCode;
  73. StepCount.LineCode = User.UserLineCode;
  74. StepCount.Dh = dh;
  75. StepCount.Start();
  76. }
  77. private void text_getfocus(object sender, EventArgs e)
  78. {
  79. ms_sncode.ImeMode = ImeMode.Close;
  80. }
  81. private void ControlLockTimer_Tick(object sender, EventArgs e)
  82. {
  83. //this.Activate();
  84. //ms_sncode.Focus();
  85. }
  86. private void Ma_code_DbChange(object sender, EventArgs e)
  87. {
  88. Dbfind = ma_code.ReturnData;
  89. BaseUtil.SetFormValue(this.Controls, Dbfind);
  90. LoadBadGroupData();
  91. LoadCollectedNum();
  92. LoadCheckQTY();
  93. }
  94. /// <summary>
  95. /// 将已选不良移动到待选不良
  96. /// </summary>
  97. /// <param name="sender"></param>
  98. /// <param name="e"></param>
  99. private void WaitReject_Click(object sender, EventArgs e)
  100. {
  101. int CheckedNum = 0;
  102. //已存在在ListView中的Item是不能添加到其他ListView中的,需要调用其克隆的方法
  103. for (int i = ChoosedRejectList.Items.Count - 1; i >= 0; i--)
  104. {
  105. if (ChoosedRejectList.Items[i].Checked)
  106. {
  107. ChoosedRejectList.Items[i].Checked = false;
  108. WaitRejectList.Items.Add((ListViewItem)ChoosedRejectList.Items[i].Clone());
  109. ChoosedRejectList.Items[i].Remove();
  110. CheckedNum++;
  111. }
  112. }
  113. if (CheckedNum == 0)
  114. {
  115. for (int i = ChoosedRejectList.Items.Count - 1; i >= 0; i--)
  116. {
  117. WaitRejectList.Items.Add((ListViewItem)ChoosedRejectList.Items[i].Clone());
  118. ChoosedRejectList.Items[i].Remove();
  119. }
  120. }
  121. }
  122. /// <summary>
  123. /// 将不良信息移动到已选不良
  124. /// </summary>
  125. /// <param name="sender"></param>
  126. /// <param name="e"></param>
  127. private void ChooseedReject_Click(object sender, EventArgs e)
  128. {
  129. //if (ms_sncode.Text == "")
  130. //{
  131. // OperateResult.AppendText(">>序列号不能为空\n", Color.Red);
  132. // ms_sncode.Focus();
  133. // return;
  134. //}
  135. int CheckedNum = 0;
  136. //是否已经添加到不良
  137. bool AddToReject = false;
  138. for (int i = WaitRejectList.Items.Count - 1; i >= 0; i--)
  139. {
  140. if (WaitRejectList.Items[i].Checked)
  141. {
  142. AddToReject = false;
  143. for (int j = 0; j < ChoosedRejectList.Items.Count; j++)
  144. {
  145. if ((ChoosedRejectList.Items[j].SubItems[2].Text == WaitRejectList.Items[i].SubItems[2].Text))
  146. {
  147. AddToReject = true;
  148. OperateResult.AppendText(">>已存在" + ChoosedRejectList.Items[j].SubItems[2].Text + "不良\n", Color.Red);
  149. break;
  150. }
  151. }
  152. //未添加则进行添加
  153. if (!AddToReject)
  154. {
  155. WaitRejectList.Items[i].Checked = false;
  156. ChoosedRejectList.Items.Add((ListViewItem)WaitRejectList.Items[i].Clone());
  157. WaitRejectList.Items[i].Remove();
  158. CheckedNum++;
  159. }
  160. }
  161. }
  162. if (CheckedNum == 0)
  163. {
  164. OperateResult.AppendText(">>请勾选不良代码\n", Color.Red);
  165. }
  166. }
  167. private void CleanInfo_Click(object sender, EventArgs e)
  168. {
  169. OperateResult.Clear();
  170. }
  171. private void ms_code_KeyDown(object sender, KeyEventArgs e)
  172. {
  173. if (e.KeyCode == Keys.Enter)
  174. {
  175. if (LogicHandler.CheckStepAttribute(Tag.ToString(), User.UserSourceCode, out ErrorMessage))
  176. {
  177. bool NoteAlready = LogicHandler.CheckDiffMakeCodeBeforeStepCheck(ms_sncode.Text, ma_code.Text, NoteForChange.Checked, out oMakeCode, out ErrorMessage);
  178. if (!NoteAlready)
  179. {
  180. OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red, ms_sncode);
  181. return;
  182. }
  183. if (LogicHandler.CheckStepSNAndMacode(oMakeCode, User.UserSourceCode, ms_sncode.Text, User.UserCode, out oMakeCode, out oMSID, out ErrorMessage))
  184. {
  185. //是否提示过工单切换框,检测前后执行
  186. if (!LogicHandler.CheckDiffMakeCodeAfterStepCheck(ms_sncode.Text, oMakeCode, NoteForChange.Checked, NoteAlready, ma_code, out ErrorMessage))
  187. {
  188. OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red, ms_sncode);
  189. return;
  190. }
  191. if (ma_code.Text != oMakeCode && oMakeCode != null)
  192. {
  193. dt = (DataTable)dh.ExecuteSql("select ma_code,ma_prodcode,ma_softversion,ma_salecode,pr_spec,nvl(pr_sendchecktype,'LineCode')pr_sendchecktype,ma_qty from make left join product on ma_prodcode=pr_code where ma_code='" + oMakeCode + "'", "select");
  194. if (dt.Rows.Count > 0)
  195. {
  196. BaseUtil.SetFormValue(this.Controls, dt);
  197. LockMakeCode.Checked = true;
  198. }
  199. }
  200. dt = (DataTable)dh.ExecuteSql("select ms_nextstepcode,ms_sncode,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");
  201. string status = dt.Rows[0]["ms_status"].ToString();
  202. reworkstatus = dt.Rows[0]["ms_reworkstatus"].ToString();
  203. string stepcode = dt.Rows[0]["ms_stepcode"].ToString();
  204. string ifrepair = dt.Rows[0]["st_ifrepair"].ToString();
  205. string sncode = dt.Rows[0]["ms_sncode"].ToString();
  206. if (sncode != ms_sncode.Text)
  207. {
  208. OperateResult.AppendText(">>" + ms_sncode.Text + " 序列号已执行过转号,不允许使用TSN采集\n", Color.Red, ms_sncode);
  209. return;
  210. }
  211. ifrework = dt.Rows[0]["ms_ifrework"].ToString();
  212. if (GoodProduct.Checked)
  213. {
  214. if (ifrework != "0")
  215. {
  216. if (stepcode == User.CurrentStepCode && (reworkstatus == "1" || reworkstatus == "2") && ifrepair == "0")
  217. {
  218. OperateResult.AppendText(">>" + ms_sncode.Text + " 序列号已执行过" + User.CurrentStepCode + "工序,采集结果为良品\n", Color.Black, ms_sncode);
  219. return;
  220. }
  221. }
  222. else
  223. {
  224. if (stepcode == User.CurrentStepCode && (status == "1" || status == "2") && ifrepair == "0")
  225. {
  226. OperateResult.AppendText(">>" + ms_sncode.Text + " 序列号已执行过" + User.CurrentStepCode + "工序,采集结果为良品\n", Color.Black, ms_sncode);
  227. return;
  228. }
  229. }
  230. }
  231. SetCollectResult();
  232. }
  233. else OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red, ms_sncode);
  234. }
  235. else OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red, ms_sncode);
  236. }
  237. }
  238. private void bc_groupcode_SelectedIndexChanged(object sender, EventArgs e)
  239. {
  240. LoadBadCodeListView();
  241. }
  242. /// <summary>
  243. /// 填充不良组别信息
  244. /// </summary>
  245. private void LoadBadGroupData()
  246. {
  247. //如果ms_makecode的值修改过再去查询
  248. sql.Clear();
  249. sql.Append("select bg_code||':'||bg_name bg_name,bg_code from badgroup left join (select pb_badgroup,pr_kind ");
  250. sql.Append("from product left join productkind on pk_name=pr_kind ");
  251. sql.Append("left join productbadgroup on pk_code=PB_KINDCODE where pr_code='" + ma_prodcode.Text + "')");
  252. sql.Append("on pb_badgroup=bg_code where bg_statuscode='AUDITED' order by case when bg_code='" + User.DefaultBadGroup + "' then 0 else 1 end");
  253. DataTable dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
  254. bc_groupcode.DisplayMember = "bg_name";
  255. bc_groupcode.ValueMember = "bg_code";
  256. bc_groupcode.DataSource = dt;
  257. }
  258. /// <summary>
  259. /// 加载不良代码的ListView的信息
  260. /// </summary>
  261. private void LoadBadCodeListView()
  262. {
  263. object bg_code = bc_groupcode.SelectedValue;
  264. sql.Clear();
  265. sql.Append("select bg_code||':'||bg_name bg_code,bc_code,bc_name,'' bc_remark from badgroupdetail ");
  266. sql.Append("left join badgroup on bg_id=bgd_bgid left join badcode on bgd_badcode=bc_code where ");
  267. sql.Append("bg_code='" + (bg_code != null ? bg_code.ToString() : "") + "' and bg_code is not null order by bgd_detno");
  268. DataTable dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
  269. BadInfSource.DataSource = dt;
  270. //往listview中添加数据
  271. WaitRejectList.Items.Clear();
  272. WaitRejectList.BeginUpdate();
  273. for (int i = 0; i < dt.Rows.Count; i++)
  274. {
  275. if (!ChoosedList.Contains(dt.Rows[i]["bc_code"].ToString()))
  276. {
  277. ListViewItem lvi = new ListViewItem();
  278. //第一列是勾选列,设置列头文本为空
  279. lvi.Text = "";
  280. WaitList.Add(dt.Rows[i]["bc_code"].ToString());
  281. for (int j = 0; j < dt.Columns.Count; j++)
  282. lvi.SubItems.Add(dt.Rows[i][j].ToString());
  283. WaitRejectList.Items.Add(lvi);
  284. }
  285. }
  286. WaitRejectList.EndUpdate();
  287. }
  288. /// <summary>
  289. /// 加载已选不良的ListView
  290. /// </summary>
  291. private void LoadChoosedBadListView()
  292. {
  293. sql.Clear();
  294. sql.Append("select nvl(bg_code,mb_bgcode)||':'||nvl(bg_name,mb_badcode) bg_code,nvl(mb_badcode,bc_code) bc_code,bc_name,mb_badremark from makebad ");
  295. sql.Append("left join badgroup on mb_bgcode=bg_code left join badcode on mb_badcode=bc_code ");
  296. sql.Append(" where mb_sncode='" + ms_sncode.Text + "' and mb_makecode='" + ma_code.Text + "' and mb_status=0");
  297. dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
  298. ChoosedRejectList.Items.Clear();
  299. ChoosedRejectList.BeginUpdate();
  300. for (int i = 0; i < dt.Rows.Count; i++)
  301. {
  302. ListViewItem lvi = new ListViewItem();
  303. //第一列是勾选列,设置列头文本为空
  304. lvi.Text = "";
  305. ChoosedList.Add(dt.Rows[i]["bc_code"].ToString());
  306. for (int j = 0; j < dt.Columns.Count; j++)
  307. lvi.SubItems.Add(dt.Rows[i][j].ToString());
  308. ChoosedRejectList.Items.Add(lvi);
  309. }
  310. ChoosedRejectList.EndUpdate();
  311. }
  312. /// <summary>
  313. /// 设置良品或者不良品的采集结果
  314. /// </summary>
  315. private void SetCollectResult()
  316. {
  317. string ErrorMessage = "";
  318. //如果勾选的是不良品
  319. if (Reject.Checked)
  320. {
  321. //LoadBadCodeListView();
  322. //LoadChoosedBadListView();
  323. //OperateResult.AppendText(">>请采集不良代码\n", Color.Green);
  324. //bc_code.Focus();
  325. ////勾选了自动产生代码
  326. //if (AutoBadCode.Checked)
  327. // Save_Click(new object(), new EventArgs());
  328. if (ms_sncode.Text == "")
  329. {
  330. OperateResult.AppendText(">>序列号不允许为空\n", Color.Red);
  331. return;
  332. }
  333. if (GoodProduct.Checked)
  334. ms_code_KeyDown_one(this, new KeyEventArgs(Keys.Enter));
  335. else if (Reject.Checked)
  336. {
  337. if (LogicHandler.CheckStepAttribute(Tag.ToString(), User.UserSourceCode, out ErrorMessage))
  338. {
  339. //判断界面工单是否为空时的序列号是否自动归属工单
  340. string oStatus = "";
  341. if (!LogicHandler.GetMakeInfo(ms_sncode.Text, out oMakeCode, out oStatus, out ErrorMessage))
  342. {
  343. if (ma_code.Text == "")
  344. {
  345. OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red, ms_sncode);
  346. return;
  347. }
  348. }
  349. if (LogicHandler.CheckStepSNAndMacode(ma_code.Text == "" ? oMakeCode : ma_code.Text, User.UserSourceCode, ms_sncode.Text, User.UserCode, out oMakeCode, out oMSID, out ErrorMessage))
  350. {
  351. dt = (DataTable)dh.ExecuteSql("select ma_code,ma_prodcode,ma_softversion,pr_spec,ma_qty from make left join product on ma_prodcode=pr_code where ma_code='" + oMakeCode + "'", "select");
  352. if (dt.Rows.Count > 0)
  353. {
  354. BaseUtil.SetFormValue(this.Controls, dt);
  355. LockMakeCode.Checked = true;
  356. }
  357. }
  358. else
  359. {
  360. OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red, ms_sncode);
  361. return;
  362. }
  363. }
  364. else
  365. {
  366. OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red, ms_sncode);
  367. return;
  368. }
  369. int RejectCount = ChoosedRejectList.Items.Count;
  370. string[] bccode = new string[RejectCount];
  371. string[] bcremark = new string[RejectCount];
  372. string[] bgcode = new string[RejectCount];
  373. string[] bgname = new string[RejectCount];
  374. string[] bcname = new string[RejectCount];
  375. if (AutoBadCode.Checked)
  376. {
  377. string defaultvalue = Properties.Settings.Default.DefaultCollectionValue;
  378. bccode = new string[] { defaultvalue };
  379. bcremark = new string[] { defaultvalue };
  380. bgcode = new string[] { defaultvalue };
  381. bgname = new string[] { defaultvalue };
  382. bcname = new string[] { defaultvalue };
  383. }
  384. else
  385. {
  386. if (ChoosedRejectList.Items.Count == 0)
  387. {
  388. OperateResult.AppendText(">>不良品必须选择不良原因和不良代码!\n", Color.Red);
  389. return;
  390. }
  391. else
  392. {
  393. for (int i = 0; i < RejectCount; i++)
  394. {
  395. //获取不良代码组
  396. bgcode[i] = ChoosedRejectList.Items[i].SubItems[1].Text.Split(':')[0];
  397. //获取不良代码组名称
  398. bgname[i] = ChoosedRejectList.Items[i].SubItems[1].Text.Split(':')[1];
  399. //获取所有的不良代码
  400. bccode[i] = ChoosedRejectList.Items[i].SubItems[2].Text;
  401. //获取不良名称
  402. bcname[i] = ChoosedRejectList.Items[i].SubItems[3].Text;
  403. //获取所有的不良备注
  404. bcremark[i] = bc_remark.Text;
  405. }
  406. }
  407. }
  408. //如果之前是良品的
  409. dt = dh.getFieldsDataByCondition("makeserial", new string[] { "ms_status", "ms_checkno" }, "ms_id='" + oMSID + "' and ms_stepcode='" + User.CurrentStepCode + "'");
  410. if (dt.Rows.Count > 0)
  411. {
  412. string status = dt.Rows[0]["ms_status"].ToString();
  413. if (status == "1" || status == "2")
  414. {
  415. dh.UpdateByCondition("steppassed", "sp_result='不良品',sp_ifng=-1,sp_ymd=to_char(sysdate,'yyyymmdd'),sp_hm=to_char(sysdate,'hh24miss')", "sp_id=(select max(sp_id) from steppassed where sp_sncode='" + ms_sncode.Text + "')");
  416. dh.UpdateByCondition("makecraftdetail", "mcd_okqty=mcd_okqty-1", "mcd_macode='" + ma_code.Text + "' and mcd_stepcode='" + User.CurrentStepCode + "'");
  417. dh.UpdateByCondition("makeserial", "ms_nextstepcode='',ms_badtimes=nvl(ms_badtimes,0)+1", "ms_id='" + oMSID + "'");
  418. LogicHandler.InsertMakeProcess(ms_sncode.Text, ma_code.Text, User.UserSourceCode, "良品采集成不良", "测试不良", User.UserCode);
  419. LogicHandler.DoCommandLog(Tag.ToString(), User.UserCode, ma_code.Text, User.UserLineCode, User.UserSourceCode, "测试不良", "良品采集成不良", ms_sncode.Text, ob_checkno.Text);
  420. }
  421. string checkno = dt.Rows[0]["ms_checkno"].ToString();
  422. //存在抽检批次更新为空
  423. if (checkno != "")
  424. dh.UpdateByCondition("makeserial", "ms_checkno=''", "ms_id='" + oMSID + "'");
  425. }
  426. else
  427. {
  428. LogicHandler.InsertMakeProcess(ms_sncode.Text, ma_code.Text, User.UserSourceCode, "采集成不良", "测试不良", User.UserCode);
  429. LogicHandler.DoCommandLog(Tag.ToString(), User.UserCode, ma_code.Text, User.UserLineCode, User.UserSourceCode, "采集成不良", "测试不良", ms_sncode.Text, ob_checkno.Text);
  430. }
  431. //不良信息采集,mb_status<>0的是之前维修保存的,不能删除
  432. dh.ExecuteSql("delete from makebad where mb_sncode='" + ms_sncode.Text + "' and mb_makecode='" + ma_code.Text + "' and nvl(mb_status,0)=0", "delete");
  433. if (LogicHandler.SetTestNGDetail(ms_sncode.Text, ma_code.Text, User.UserCode, User.UserSourceCode, "检查未通过", bgcode, bccode, bgname, bcname, bcremark, out ErrorMessage))
  434. {
  435. ////存在的不良代码和
  436. //dt = (DataTable)dh.ExecuteSql("select sr_badcode from STEPRETURN where sr_stepcode='" + User.CurrentStepCode + "'", "select");
  437. //if (dt.Rows.Count > 0)
  438. //{
  439. // int BadCodeInStep = 0;
  440. // string badname = "";
  441. // for (int i = 0; i < dt.Rows.Count; i++)
  442. // {
  443. // for (int j = 0; j < bccode.Length; j++)
  444. // {
  445. // if (dt.Rows[i]["sr_badcode"].ToString() == bccode[j])
  446. // {
  447. // badname += "[" + bcname[j] + "]";
  448. // BadCodeInStep += 1;
  449. // }
  450. // }
  451. // }
  452. // //选中的不良代码必须全在工序默认的不良代码中才通过判断
  453. // if (BadCodeInStep == bccode.Length)
  454. // {
  455. // dh.UpdateByCondition("makebad", "mb_status=-1", "mb_sncode='" + ms_sncode.Text + "' and mb_makecode='" + ma_code.Text + "' and mb_stepcode='" + User.CurrentStepCode + "'");
  456. // dh.UpdateByCondition("makeserial", "ms_stepcode='',ms_status=1,ms_nextstepcode='" + User.CurrentStepCode + "'", "ms_id='" + oMSID + "'");
  457. // LogicHandler.DoCommandLog(Tag.ToString(), User.UserCode, ma_code.Text, User.UserLineCode, User.UserSourceCode, "快速维修成功", "快速维修", "", ob_checkno.Text);
  458. // OperateResult.AppendText(">>本次采集不良代码" + badname + "存在于本工序" + User.CurrentStepCode + "中,请解除故障后重新测试本站\n", Color.Black);
  459. // }
  460. // else OperateResult.AppendText(">>" + ms_sncode.Text + "成功采集为不良\n", Color.Green);
  461. //}
  462. //else
  463. OperateResult.AppendText(">>" + ms_sncode.Text + "成功采集为不良\n", Color.Red);
  464. LastSncode = ms_sncode.Text;
  465. //采集完不良,聚焦序列号
  466. ms_sncode.Text = "";
  467. //清除不良信息
  468. bc_code.Text = "";
  469. bc_remark.Text = "";
  470. ChoosedRejectList.Items.Clear();
  471. LoadCollectedNum();
  472. WaitList.Clear();
  473. ChoosedList.Clear();
  474. bc_code.Focus();
  475. }
  476. else OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red);
  477. }
  478. }
  479. else if (GoodProduct.Checked)
  480. {
  481. //如果不是返修的
  482. if (ifrework == "0")
  483. {
  484. 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_makecode='" + ma_code.Text + "' and mb_status=0", "select");
  485. for (int i = 0; i < dt.Rows.Count; i++)
  486. {
  487. if (dt.Rows[i]["mb_id"].ToString() != dt.Rows[i]["mbr_mbid"].ToString())
  488. ErrorMessage += "【" + dt.Rows[i]["bc_name"].ToString() + "】";
  489. }
  490. //存在不良记录
  491. if (ErrorMessage != "")
  492. {
  493. OperateResult.AppendText(">>序列号:" + ms_sncode.Text + " 已经判为不良品,不允许修改!\n", Color.Red);
  494. return;
  495. }
  496. else
  497. {
  498. //良品信息采集
  499. if (LogicHandler.SetStepResult(ma_code.Text, User.UserSourceCode, ms_sncode.Text, "良品采集", "检测合格", User.UserCode, out ErrorMessage))
  500. {
  501. LastSncode = ms_sncode.Text;
  502. //提示正确返回时传递的信息
  503. if (ErrorMessage.Contains("AFTERSUCCESS"))
  504. {
  505. OperateResult.AppendText(">>" + ms_sncode.Text + "良品采集成功 " + ErrorMessage + "\n", Color.Blue, ms_sncode);
  506. getcheck++;
  507. }
  508. else
  509. {
  510. OperateResult.AppendText(">>" + ms_sncode.Text + "良品采集成功\n", Color.Green, ms_sncode);
  511. getcheck++;
  512. }
  513. //记录操作日志
  514. LogicHandler.DoCommandLog(Tag.ToString(), User.UserCode, ma_code.Text, User.UserLineCode, User.UserSourceCode, "采集良品", "采集良品成功", LastSncode, ob_checkno.Text);
  515. if (!startcheck)
  516. {
  517. startcheck = true;
  518. Thread thread = new Thread(NewPrint); ;
  519. thread.Start();
  520. }
  521. }
  522. else OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red, ms_sncode);
  523. }
  524. }
  525. else
  526. {
  527. if (reworkstatus != "3")
  528. {
  529. if (LogicHandler.SetStepResult(ma_code.Text, User.UserSourceCode, ms_sncode.Text, "良品采集", "检测合格", User.UserCode, out ErrorMessage))
  530. {
  531. //提示正确返回时传递的信息
  532. if (ErrorMessage.Contains("AFTERSUCCESS"))
  533. OperateResult.AppendText(">>" + ErrorMessage + "\n");
  534. LastSncode = ms_sncode.Text;
  535. OperateResult.AppendText(">>" + ms_sncode.Text + "成功采集为良品\n", Color.Green, ms_sncode);
  536. //记录操作日志
  537. LogicHandler.DoCommandLog(Tag.ToString(), User.UserCode, ma_code.Text, User.UserLineCode, User.UserSourceCode, "采集良品", "采集良品成功", LastSncode, ob_checkno.Text);
  538. }
  539. else OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red, ms_sncode);
  540. }
  541. else
  542. {
  543. OperateResult.AppendText(">>返修的不良序列号必须先进行维修\n", Color.Red);
  544. }
  545. }
  546. }
  547. //加载页面信息
  548. LoadCollectedNum();
  549. LoadCheckQTY();
  550. }
  551. private void NewPrint()
  552. {
  553. Thread.Sleep(9000);
  554. oneget.Text = getcheck.ToString();
  555. getcheck = 0;
  556. startcheck = false;
  557. }
  558. private void 测试采集_SizeChanged(object sender, EventArgs e)
  559. {
  560. asc.controlAutoSize(this);
  561. }
  562. private void LoadCollectedNum()
  563. {
  564. dt = (DataTable)dh.ExecuteSql("select mcd_detno,mcd_stepcode,mcd_stepname,nvl(count(distinct A.ms_sncode),0) n,nvl(count(distinct B.ms_sncode),0) bn,(select nvl(count(distinct sp_sncode),0) from STEPPASSED where SP_MAKECODE = mcd_macode AND SP_STEPCODE = mcd_stepcode) mcd_inqty,(select nvl(count(distinct sp_sncode),0) from STEPPASSED where SP_MAKECODE = mcd_macode AND SP_STEPCODE = mcd_stepcode)-nvl(count(distinct B.ms_sncode),0) mcd_remainqty from MAKECRAFTdetail left join makeserial A on mcd_macode = A.ms_makecode and mcd_stepcode = A.ms_nextstepcode AND A.MS_STATUS = 1 LEFT JOIN MAKESERIAL B ON mcd_macode = B.ms_makecode AND MCD_STEPCODE = B.MS_STEPCODE AND B.MS_STATUS = 3 where mcd_macode = '"+ ma_code.Text + "' and mcd_stepcode = '"+ User.CurrentStepCode + "' group by mcd_macode,mcd_detno, mcd_stepcode, mcd_stepname order by mcd_detno asc", "select");
  565. if (dt != null)
  566. {
  567. BaseUtil.SetFormValue(Controls, dt);
  568. }
  569. }
  570. private void Save_Click(object sender, EventArgs e)
  571. {
  572. if (ms_sncode.Text == "")
  573. {
  574. OperateResult.AppendText(">>序列号不允许为空\n", Color.Red);
  575. return;
  576. }
  577. if (GoodProduct.Checked)
  578. ms_code_KeyDown_one(sender, new KeyEventArgs(Keys.Enter));
  579. else if (Reject.Checked)
  580. {
  581. if (LogicHandler.CheckStepAttribute(Tag.ToString(), User.UserSourceCode, out ErrorMessage))
  582. {
  583. //判断界面工单是否为空时的序列号是否自动归属工单
  584. string oStatus = "";
  585. if (!LogicHandler.GetMakeInfo(ms_sncode.Text, out oMakeCode, out oStatus, out ErrorMessage))
  586. {
  587. if (ma_code.Text == "")
  588. {
  589. OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red, ms_sncode);
  590. return;
  591. }
  592. }
  593. if (LogicHandler.CheckStepSNAndMacode(ma_code.Text == "" ? oMakeCode : ma_code.Text, User.UserSourceCode, ms_sncode.Text, User.UserCode, out oMakeCode, out oMSID, out ErrorMessage))
  594. {
  595. dt = (DataTable)dh.ExecuteSql("select ma_code,ma_prodcode,ma_softversion,pr_spec,ma_qty from make left join product on ma_prodcode=pr_code where ma_code='" + oMakeCode + "'", "select");
  596. if (dt.Rows.Count > 0)
  597. {
  598. BaseUtil.SetFormValue(this.Controls, dt);
  599. LockMakeCode.Checked = true;
  600. }
  601. }
  602. else
  603. {
  604. OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red, ms_sncode);
  605. return;
  606. }
  607. }
  608. else
  609. {
  610. OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red, ms_sncode);
  611. return;
  612. }
  613. int RejectCount = ChoosedRejectList.Items.Count;
  614. string[] bccode = new string[RejectCount];
  615. string[] bcremark = new string[RejectCount];
  616. string[] bgcode = new string[RejectCount];
  617. string[] bgname = new string[RejectCount];
  618. string[] bcname = new string[RejectCount];
  619. if (AutoBadCode.Checked)
  620. {
  621. string defaultvalue = Properties.Settings.Default.DefaultCollectionValue;
  622. bccode = new string[] { defaultvalue };
  623. bcremark = new string[] { defaultvalue };
  624. bgcode = new string[] { defaultvalue };
  625. bgname = new string[] { defaultvalue };
  626. bcname = new string[] { defaultvalue };
  627. }
  628. else
  629. {
  630. if (ChoosedRejectList.Items.Count == 0)
  631. {
  632. OperateResult.AppendText(">>不良品必须选择不良原因和不良代码!\n", Color.Red);
  633. return;
  634. }
  635. else if (string.IsNullOrEmpty(bc_remark.Text))
  636. {
  637. OperateResult.AppendText(">>不良品必须输入不良位号\n", Color.Red);
  638. return;
  639. }
  640. else
  641. {
  642. for (int i = 0; i < RejectCount; i++)
  643. {
  644. //获取不良代码组
  645. bgcode[i] = ChoosedRejectList.Items[i].SubItems[1].Text.Split(':')[0];
  646. //获取不良代码组名称
  647. bgname[i] = ChoosedRejectList.Items[i].SubItems[1].Text.Split(':')[1];
  648. //获取所有的不良代码
  649. bccode[i] = ChoosedRejectList.Items[i].SubItems[2].Text;
  650. //获取不良名称
  651. bcname[i] = ChoosedRejectList.Items[i].SubItems[3].Text;
  652. //获取所有的不良备注
  653. bcremark[i] = bc_remark.Text;
  654. }
  655. }
  656. }
  657. //如果之前是良品的
  658. dt = dh.getFieldsDataByCondition("makeserial", new string[] { "ms_status", "ms_checkno" }, "ms_id='" + oMSID + "' and ms_stepcode='" + User.CurrentStepCode + "'");
  659. if (dt.Rows.Count > 0)
  660. {
  661. string status = dt.Rows[0]["ms_status"].ToString();
  662. if (status == "1" || status == "2")
  663. {
  664. dh.UpdateByCondition("steppassed", "sp_result='不良品',sp_ifng=-1,sp_ymd=to_char(sysdate,'yyyymmdd'),sp_hm=to_char(sysdate,'hh24miss')", "sp_id=(select max(sp_id) from steppassed where sp_sncode='" + ms_sncode.Text + "')");
  665. dh.UpdateByCondition("makecraftdetail", "mcd_okqty=mcd_okqty-1", "mcd_macode='" + ma_code.Text + "' and mcd_stepcode='" + User.CurrentStepCode + "'");
  666. dh.UpdateByCondition("makeserial", "ms_nextstepcode='',ms_badtimes=nvl(ms_badtimes,0)+1", "ms_id='" + oMSID + "'");
  667. LogicHandler.InsertMakeProcess(ms_sncode.Text, ma_code.Text, User.UserSourceCode, "良品采集成不良", "测试不良", User.UserCode);
  668. LogicHandler.DoCommandLog(Tag.ToString(), User.UserCode, ma_code.Text, User.UserLineCode, User.UserSourceCode, "测试不良", "良品采集成不良", ms_sncode.Text, ob_checkno.Text);
  669. }
  670. string checkno = dt.Rows[0]["ms_checkno"].ToString();
  671. //存在抽检批次更新为空
  672. if (checkno != "")
  673. dh.UpdateByCondition("makeserial", "ms_checkno=''", "ms_id='" + oMSID + "'");
  674. }
  675. else
  676. {
  677. LogicHandler.InsertMakeProcess(ms_sncode.Text, ma_code.Text, User.UserSourceCode, "采集成不良", "测试不良", User.UserCode);
  678. LogicHandler.DoCommandLog(Tag.ToString(), User.UserCode, ma_code.Text, User.UserLineCode, User.UserSourceCode, "采集成不良", "测试不良", ms_sncode.Text, ob_checkno.Text);
  679. }
  680. //不良信息采集,mb_status<>0的是之前维修保存的,不能删除
  681. dh.ExecuteSql("delete from makebad where mb_sncode='" + ms_sncode.Text + "' and mb_makecode='" + ma_code.Text + "' and nvl(mb_status,0)=0", "delete");
  682. if (LogicHandler.SetTestNGDetail(ms_sncode.Text, ma_code.Text, User.UserCode, User.UserSourceCode, "检查未通过", bgcode, bccode, bgname, bcname, bcremark, out ErrorMessage))
  683. {
  684. //存在的不良代码和
  685. dt = (DataTable)dh.ExecuteSql("select sr_badcode from STEPRETURN where sr_stepcode='" + User.CurrentStepCode + "'", "select");
  686. if (dt.Rows.Count > 0)
  687. {
  688. int BadCodeInStep = 0;
  689. string badname = "";
  690. for (int i = 0; i < dt.Rows.Count; i++)
  691. {
  692. for (int j = 0; j < bccode.Length; j++)
  693. {
  694. if (dt.Rows[i]["sr_badcode"].ToString() == bccode[j])
  695. {
  696. badname += "[" + bcname[j] + "]";
  697. BadCodeInStep += 1;
  698. }
  699. }
  700. }
  701. //选中的不良代码必须全在工序默认的不良代码中才通过判断
  702. if (BadCodeInStep == bccode.Length)
  703. {
  704. dh.UpdateByCondition("makebad", "mb_status=-1", "mb_sncode='" + ms_sncode.Text + "' and mb_makecode='" + ma_code.Text + "' and mb_stepcode='" + User.CurrentStepCode + "'");
  705. dh.UpdateByCondition("makeserial", "ms_stepcode='',ms_status=1,ms_nextstepcode='" + User.CurrentStepCode + "'", "ms_id='" + oMSID + "'");
  706. LogicHandler.DoCommandLog(Tag.ToString(), User.UserCode, ma_code.Text, User.UserLineCode, User.UserSourceCode, "快速维修成功", "快速维修", "", ob_checkno.Text);
  707. OperateResult.AppendText(">>本次采集不良代码" + badname + "存在于本工序" + User.CurrentStepCode + "中,请解除故障后重新测试本站\n", Color.Black);
  708. }
  709. else OperateResult.AppendText(">>" + ms_sncode.Text + "成功采集为不良\n", Color.Red);
  710. }
  711. else OperateResult.AppendText(">>" + ms_sncode.Text + "成功采集为不良\n", Color.Red);
  712. LastSncode = ms_sncode.Text;
  713. //采集完不良,聚焦序列号
  714. //ms_sncode.Focus();
  715. //记录操作日志
  716. ms_sncode.Text = "";
  717. //清除不良信息
  718. bc_code.Text = "";
  719. bc_remark.Text = "";
  720. ChoosedRejectList.Items.Clear();
  721. LoadCollectedNum();
  722. WaitList.Clear();
  723. ChoosedList.Clear();
  724. bc_code.Focus();
  725. }
  726. else OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red);
  727. }
  728. }
  729. private void bc_code_KeyDown(object sender, KeyEventArgs e)
  730. {
  731. if (e.KeyCode == Keys.Enter)
  732. {
  733. sql.Clear();
  734. sql.Append("select bg_code||':'||bg_name bg_code,bc_code,bc_name,'' bc_remark from badgroupdetail left join ");
  735. sql.Append("badgroup on bg_id=bgd_bgid left join badcode on bgd_badcode = bc_code where bc_code='" + bc_code.Text + "' and rownum=1 ");
  736. DataTable dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
  737. if (dt.Rows.Count > 0)
  738. {
  739. for (int i = 0; i < ChoosedRejectList.Items.Count; i++)
  740. {
  741. if (ChoosedRejectList.Items[i].ListView.Items[i].SubItems[2].Text == bc_code.Text)
  742. {
  743. OperateResult.AppendText(">>已添加过不良代码" + bc_code.Text + "\n", Color.Red, bc_code);
  744. return;
  745. }
  746. }
  747. ListViewItem lvi = new ListViewItem();
  748. lvi.Text = "";
  749. for (int j = 0; j < dt.Columns.Count; j++)
  750. lvi.SubItems.Add(dt.Rows[0][j].ToString());
  751. ChoosedRejectList.Items.Add(lvi);
  752. bc_code.Clear();
  753. bc_remark.Focus();
  754. }
  755. else OperateResult.AppendText(">>" + bc_code.Text + "不良代码不存在\n", Color.Red, bc_code);
  756. }
  757. }
  758. private void LoadCheckQTY()
  759. {
  760. sql.Clear();
  761. string condition = "";
  762. int nowcheckqty = int.Parse(ob_nowcheckqty.Text == "" ? "0" : ob_nowcheckqty.Text);
  763. int batchqty = int.Parse(ob_batchqty.Text == "" ? "0" : ob_batchqty.Text);
  764. if (nowcheckqty + 1 == batchqty && AutoCut)
  765. {
  766. condition = "and ob_status='UNCHECK' and ob_checkno='" + ob_checkno.Text + "'";
  767. }
  768. else
  769. {
  770. condition = "and ob_status='ENTERING' ";
  771. }
  772. if (pr_sendchecktype.Text == "SaleCode")
  773. {
  774. condition += " and ob_salecode='" + ma_salecode.Text + "'";
  775. }
  776. sql.Append("select ob_batchqty,ob_nowcheckqty,ob_checkno from oqcbatch where ");
  777. sql.Append("ob_linecode='" + User.UserLineCode + "' and ob_prodcode='" + ma_prodcode.Text + "' and ");
  778. sql.Append("ob_stepcode='" + User.CurrentStepCode + "' " + condition);
  779. DataTable dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
  780. if (dt.Rows.Count > 0)
  781. {
  782. ob_sendqty.Text = dh.getFieldDataByCondition("oqcbatch", "sum(ob_nowcheckqty)", "ob_makecode='" + ma_code.Text + "' and ob_status<>'ENTERING'").ToString();
  783. ob_batchqty.Text = dt.Rows[0]["ob_batchqty"].ToString();
  784. ob_nowcheckqty.Text = dt.Rows[0]["ob_nowcheckqty"].ToString();
  785. ob_checkno.Text = dt.Rows[0]["ob_checkno"].ToString();
  786. nowcheckqty = int.Parse(ob_nowcheckqty.Text == "" ? "0" : ob_nowcheckqty.Text);
  787. batchqty = int.Parse(ob_batchqty.Text == "" ? "0" : ob_batchqty.Text);
  788. if (nowcheckqty == batchqty)
  789. {
  790. ob_nowcheckqty.ForeColor = Color.Red;
  791. OperateResult.AppendText(">>当前采集数量已达到送检数量\n", Color.Red);
  792. if (AutoCut)
  793. {
  794. OperateResult.AppendText(">>批次" + ob_checkno.Text + "自动断批\n", Color.Blue);
  795. }
  796. }
  797. }
  798. else
  799. {
  800. BaseUtil.CleanControlsText(ob_batchqty, ob_nowcheckqty, ob_checkno);
  801. SendCheck.Enabled = false;
  802. }
  803. if (ob_batchqty.Text != "")
  804. {
  805. SendCheck.Enabled = true;
  806. }
  807. else
  808. {
  809. SendCheck.Enabled = false;
  810. }
  811. }
  812. private void GoodProduct_CheckedChanged(object sender, EventArgs e)
  813. {
  814. if (GoodProduct.Checked)
  815. {
  816. bc_code.Enabled = false;
  817. WaitReject.Enabled = false;
  818. ChooseedReject.Enabled = false;
  819. Save.Visible = false;
  820. if (ms_sncode.Text == "")
  821. {
  822. ms_sncode.Focus();
  823. }
  824. }
  825. else
  826. {
  827. bc_code.Enabled = true;
  828. WaitReject.Enabled = true;
  829. ChooseedReject.Enabled = true;
  830. Save.Visible = true;
  831. bc_code.Focus();
  832. }
  833. }
  834. private void SendCheck_Click(object sender, EventArgs e)
  835. {
  836. sql.Clear();
  837. sql.Append("update oqcbatch set ob_status='UNCHECK' where ob_checkno ='" + ob_checkno.Text + "'");
  838. dh.ExecuteSql(sql.GetString(), "select");
  839. ob_sendqty.Text = dh.getFieldDataByCondition("oqcbatch", "sum(ob_nowcheckqty)", "ob_makecode='" + ma_code.Text + "' and ob_status<>'ENTERING'").ToString();
  840. ob_nowcheckqty.Text = "";
  841. ob_batchqty.Text = "";
  842. ob_nowcheckqty.ForeColor = Color.Black;
  843. SendCheck.Enabled = false;
  844. OperateResult.AppendText(">>批次" + ob_checkno.Text + "送检成功\n", Color.Blue);
  845. ms_sncode.Focus();
  846. LogicHandler.InsertMakeProcess(LastSncode, ma_code.Text, User.UserSourceCode, "手动送检", "手动送检成功", User.UserCode);
  847. //记录操作日志
  848. LogicHandler.DoCommandLog(Tag.ToString(), User.UserCode, ma_code.Text, User.UserLineCode, User.UserSourceCode, "手动送检", "手动送检成功", "", ob_checkno.Text);
  849. ob_checkno.Text = "";
  850. }
  851. private void ob_checkno_TextChanged(object sender, EventArgs e)
  852. {
  853. if (ob_checkno.Text != "")
  854. {
  855. string Cut = dh.getFieldDataByCondition("product left join oqcbatch on ob_prodcode=pr_code", "pr_ifautocutcheckno", "ob_checkno='" + ob_checkno.Text + "'").ToString();
  856. if (Cut == "" || Cut == "0")
  857. AutoCut = false;
  858. else
  859. AutoCut = true;
  860. SendCheck.Enabled = true;
  861. }
  862. }
  863. /// <summary>
  864. /// 工单变化修改数量
  865. /// </summary>
  866. /// <param name="sender"></param>
  867. /// <param name="e"></param>
  868. private void ma_code_UserControlTextChanged(object sender, EventArgs e)
  869. {
  870. if (ma_code.Text.Length > 4)
  871. {
  872. BaseUtil.CleanControlsText(mcd_inqty, mcd_remainqty, ob_batchqty, ob_nowcheckqty, ob_sendqty);
  873. LoadCollectedNum();
  874. LoadCheckQTY();
  875. }
  876. }
  877. private void Make_TestCollection_FormClosing(object sender, FormClosingEventArgs e)
  878. {
  879. dh.Dispose();
  880. }
  881. private void ma_prodcode_TextChanged(object sender, EventArgs e)
  882. {
  883. LoadBadGroupData();
  884. }
  885. private void Filter_UserControlTextChanged(object sender, EventArgs e)
  886. {
  887. try
  888. {
  889. DataRow[] dr = (BadInfSource.DataSource as DataTable).Select("bc_code like '%" + Filter.Text + "%' or bc_name like '%" + Filter.Text + "%'");
  890. DataTable dt = (BadInfSource.DataSource as DataTable).Clone();
  891. for (int i = 0; i < dr.Length; i++)
  892. {
  893. dt.Rows.Add(dr[i].ItemArray);
  894. }
  895. WaitRejectList.Items.Clear();
  896. WaitRejectList.BeginUpdate();
  897. for (int i = 0; i < dt.Rows.Count; i++)
  898. {
  899. if (!ChoosedList.Contains(dt.Rows[i]["bc_code"].ToString()))
  900. {
  901. ListViewItem lvi = new ListViewItem();
  902. //第一列是勾选列,设置列头文本为空
  903. lvi.Text = "";
  904. WaitList.Add(dt.Rows[i]["bc_code"].ToString());
  905. for (int j = 0; j < dt.Columns.Count; j++)
  906. lvi.SubItems.Add(dt.Rows[i][j].ToString());
  907. WaitRejectList.Items.Add(lvi);
  908. }
  909. }
  910. WaitRejectList.EndUpdate();
  911. }
  912. catch (Exception)
  913. {
  914. }
  915. }
  916. private void WaitRejectList_DoubleClick(object sender, EventArgs e)
  917. {
  918. for (int i = WaitRejectList.Items.Count - 1; i >= 0; i--)
  919. {
  920. if (WaitRejectList.Items[i].Checked)
  921. {
  922. //双击右移
  923. ChooseedReject.PerformClick();
  924. }
  925. }
  926. }
  927. private void Make_TestCollection_KeyDown(object sender, KeyEventArgs e)
  928. {
  929. if (e.Modifiers == Keys.Control && e.KeyCode == Keys.Q)
  930. {
  931. if (!LockSn)
  932. {
  933. ControlLockTimer.Start();
  934. LockSn = true;
  935. Lock_label.Visible = true;
  936. }
  937. else
  938. {
  939. ControlLockTimer.Stop();
  940. LockSn = false;
  941. Lock_label.Visible = false;
  942. }
  943. }
  944. }
  945. private void ms_code_KeyDown_one(object sender, KeyEventArgs e)
  946. {
  947. if (e.KeyCode == Keys.Enter)
  948. {
  949. if (SMTBind.Checked&& GoodProduct.Checked)
  950. {
  951. DataTable dt = (DataTable)dh.ExecuteSql("select A.SB_BARCODE from smtbind A LEFT JOIN SMTBIND B ON A.SB_MAINCODE = B.SB_MAINCODE WHERE B.SB_BARCODE = '" + ms_sncode.Text + "'", "select");
  952. if (dt.Rows.Count > 0)
  953. {
  954. for (int i = 0; i < dt.Rows.Count; i++)
  955. {
  956. ms_sncode.Text = dt.Rows[i]["sb_barcode"].ToString();
  957. ms_code_KeyDown(sender, new KeyEventArgs(Keys.Enter));
  958. }
  959. }
  960. else
  961. {
  962. OperateResult.AppendText(">>SN" + ms_sncode.Text + "未进行分板绑定\n", Color.Red, ms_sncode);
  963. }
  964. }
  965. else
  966. {
  967. ms_code_KeyDown(sender, new KeyEventArgs(Keys.Enter));
  968. }
  969. }
  970. }
  971. private void SMTBind_CheckedChanged(object sender, EventArgs e)
  972. {
  973. Settings.Default.SMTBIND = SMTBind.Checked;
  974. Settings.Default.Save();
  975. }
  976. private void StartWatch_Click(object sender, EventArgs e)
  977. {
  978. if (FolderPath.Text == "")
  979. {
  980. OperateResult.AppendText("请选择监控文件夹\n");
  981. return;
  982. }
  983. else
  984. {
  985. if (!Directory.Exists(FolderPath.Text))
  986. {
  987. OperateResult.AppendText("监控文件夹不存在\n");
  988. return;
  989. }
  990. }
  991. XmlWatcher.Path = FolderPath.Text;
  992. XmlWatcher.Filter = "*.csv";
  993. XmlWatcher.EnableRaisingEvents = true;
  994. //设置缓存数据
  995. BaseUtil.SetCacheData("FolderPath", FolderPath.Text);
  996. //设置按钮不可点击
  997. StartWatch.Enabled = false;
  998. ChooseFolder.Enabled = false;
  999. StopWatch.Enabled = true;
  1000. OperateResult.AppendText("开始执行监控\n");
  1001. }
  1002. private void StopWatch_Click(object sender, EventArgs e)
  1003. {
  1004. XmlWatcher.EnableRaisingEvents = false;
  1005. StartWatch.Enabled = true;
  1006. ChooseFolder.Enabled = true;
  1007. StopWatch.Enabled = false;
  1008. OperateResult.AppendText("停止执行监控\n");
  1009. }
  1010. private void ChooseFolder_Click(object sender, EventArgs e)
  1011. {
  1012. FolderBrowserDialog folder = new FolderBrowserDialog();
  1013. folder.Description = "选择监控文件夹";
  1014. DialogResult result = folder.ShowDialog();
  1015. if (result == DialogResult.OK)
  1016. {
  1017. FolderPath.Text = folder.SelectedPath;
  1018. }
  1019. }
  1020. private void XmlWatcher_Created(object sender, FileSystemEventArgs e)
  1021. {
  1022. //while (true)
  1023. //{
  1024. // try
  1025. // {
  1026. // using (Stream stream = File.Open(e.FullPath, FileMode.Open, FileAccess.ReadWrite, FileShare.ReadWrite))
  1027. // {
  1028. // if (stream != null)
  1029. // break;
  1030. // }
  1031. // }
  1032. // catch (Exception ex)
  1033. // {
  1034. // Console.WriteLine(ex.Message);
  1035. // }
  1036. //}
  1037. //StreamReader _Sr = new StreamReader(FolderPath.Text + @"\" + e.Name, Encoding.UTF8);
  1038. //String[] strData;
  1039. //string line;
  1040. //while ((line = _Sr.ReadLine()) != null)
  1041. //{
  1042. // strData = line.Replace("\r", "").Replace("\n", "").Replace("\t", "").Split(',');
  1043. // if (strData.Length > 5 && strData[0] == "ArrayID")
  1044. // {
  1045. // if (strData[5] != ""&& strData[5] != "NOREAD")
  1046. // {
  1047. // if (strData[3] == "Good"|| strData[3] == "Pass")
  1048. // {
  1049. // ms_sncode.Text = strData[5];
  1050. // ms_code_KeyDown(this, new KeyEventArgs(Keys.Enter));
  1051. // }
  1052. // else {
  1053. // OperateResult.AppendText(">>解析数据" + strData[5] + "非良品,无法采集\n", Color.Red, ms_sncode);
  1054. // }
  1055. // }
  1056. // }
  1057. //}
  1058. //_Sr.Close();
  1059. }
  1060. private void XmlWatcher_Changed(object sender, FileSystemEventArgs e)
  1061. {
  1062. if (e.ChangeType == WatcherChangeTypes.Changed || e.ChangeType == WatcherChangeTypes.Created)
  1063. {
  1064. Stream stream = null;
  1065. while (true)
  1066. {
  1067. try
  1068. {
  1069. using (stream = File.Open(e.FullPath, FileMode.Open, FileAccess.Read, FileShare.Read))
  1070. {
  1071. if (stream != null)
  1072. stream.Close();
  1073. break;
  1074. }
  1075. }
  1076. catch (Exception ex)
  1077. {
  1078. Console.WriteLine(ex.Message);
  1079. }
  1080. }
  1081. FileInfo fileInfo = new FileInfo(e.FullPath);
  1082. if (dateTimeDictionary.ContainsKey(e.FullPath))
  1083. {
  1084. if ((DateTime.Now - dateTimeDictionary[e.FullPath]).Seconds < 8)
  1085. {
  1086. return;
  1087. }
  1088. else
  1089. {
  1090. dateTimeDictionary.Remove(e.FullPath);
  1091. dateTimeDictionary.Add(e.FullPath, DateTime.Now);
  1092. }
  1093. }
  1094. else
  1095. {
  1096. dateTimeDictionary.Add(e.FullPath, DateTime.Now);
  1097. }
  1098. StreamReader _Sr = new StreamReader(e.FullPath, Encoding.UTF8);
  1099. String[] strData;
  1100. string line;
  1101. while ((line = _Sr.ReadLine()) != null)
  1102. {
  1103. strData = line.Replace("\r", "").Replace("\n", "").Replace("\t", "").Split(',');
  1104. if (strData.Length > 5 && strData[0] == "ArrayID")
  1105. {
  1106. if (strData[5] != "" && strData[5] != "NOREAD")
  1107. {
  1108. if (strData[3] == "Good" || strData[3] == "Pass")
  1109. {
  1110. ms_sncode.Text = strData[5];
  1111. ms_code_KeyDown(this, new KeyEventArgs(Keys.Enter));
  1112. }
  1113. else
  1114. {
  1115. OperateResult.AppendText(">>解析数据" + strData[5] + "非良品,无法采集\n", Color.Red, ms_sncode);
  1116. }
  1117. }
  1118. }
  1119. }
  1120. _Sr.Close();
  1121. }
  1122. }
  1123. private void normalButton2_Click(object sender, EventArgs e)
  1124. {
  1125. Make_NewDev badcode = new Make_NewDev(ma_code.Text, User.UserLineCode);
  1126. BaseUtil.SetFormCenter(badcode);
  1127. badcode.ShowDialog();
  1128. }
  1129. private void bc_remark_KeyDown(object sender, KeyEventArgs e)
  1130. {
  1131. if (e.KeyCode == Keys.Enter)
  1132. {
  1133. ms_sncode.Focus();
  1134. ms_sncode.SelectAll();
  1135. }
  1136. }
  1137. private void ControlLockTimer_Tick_1(object sender, EventArgs e)
  1138. {
  1139. LoadCollectedNum();
  1140. }
  1141. }
  1142. }