Make_TestCollection2.cs 57 KB

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