Make_TestCollection.cs 57 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214
  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
  636. {
  637. for (int i = 0; i < RejectCount; i++)
  638. {
  639. //获取不良代码组
  640. bgcode[i] = ChoosedRejectList.Items[i].SubItems[1].Text.Split(':')[0];
  641. //获取不良代码组名称
  642. bgname[i] = ChoosedRejectList.Items[i].SubItems[1].Text.Split(':')[1];
  643. //获取所有的不良代码
  644. bccode[i] = ChoosedRejectList.Items[i].SubItems[2].Text;
  645. //获取不良名称
  646. bcname[i] = ChoosedRejectList.Items[i].SubItems[3].Text;
  647. //获取所有的不良备注
  648. bcremark[i] = bc_remark.Text;
  649. }
  650. }
  651. }
  652. //如果之前是良品的
  653. dt = dh.getFieldsDataByCondition("makeserial", new string[] { "ms_status", "ms_checkno" }, "ms_id='" + oMSID + "' and ms_stepcode='" + User.CurrentStepCode + "'");
  654. if (dt.Rows.Count > 0)
  655. {
  656. string status = dt.Rows[0]["ms_status"].ToString();
  657. if (status == "1" || status == "2")
  658. {
  659. 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 + "')");
  660. dh.UpdateByCondition("makecraftdetail", "mcd_okqty=mcd_okqty-1", "mcd_macode='" + ma_code.Text + "' and mcd_stepcode='" + User.CurrentStepCode + "'");
  661. dh.UpdateByCondition("makeserial", "ms_nextstepcode='',ms_badtimes=nvl(ms_badtimes,0)+1", "ms_id='" + oMSID + "'");
  662. LogicHandler.InsertMakeProcess(ms_sncode.Text, ma_code.Text, User.UserSourceCode, "良品采集成不良", "测试不良", User.UserCode);
  663. LogicHandler.DoCommandLog(Tag.ToString(), User.UserCode, ma_code.Text, User.UserLineCode, User.UserSourceCode, "测试不良", "良品采集成不良", ms_sncode.Text, ob_checkno.Text);
  664. }
  665. string checkno = dt.Rows[0]["ms_checkno"].ToString();
  666. //存在抽检批次更新为空
  667. if (checkno != "")
  668. dh.UpdateByCondition("makeserial", "ms_checkno=''", "ms_id='" + oMSID + "'");
  669. }
  670. else
  671. {
  672. LogicHandler.InsertMakeProcess(ms_sncode.Text, ma_code.Text, User.UserSourceCode, "采集成不良", "测试不良", User.UserCode);
  673. LogicHandler.DoCommandLog(Tag.ToString(), User.UserCode, ma_code.Text, User.UserLineCode, User.UserSourceCode, "采集成不良", "测试不良", ms_sncode.Text, ob_checkno.Text);
  674. }
  675. //不良信息采集,mb_status<>0的是之前维修保存的,不能删除
  676. dh.ExecuteSql("delete from makebad where mb_sncode='" + ms_sncode.Text + "' and mb_makecode='" + ma_code.Text + "' and nvl(mb_status,0)=0", "delete");
  677. if (LogicHandler.SetTestNGDetail(ms_sncode.Text, ma_code.Text, User.UserCode, User.UserSourceCode, "检查未通过", bgcode, bccode, bgname, bcname, bcremark, out ErrorMessage))
  678. {
  679. //存在的不良代码和
  680. dt = (DataTable)dh.ExecuteSql("select sr_badcode from STEPRETURN where sr_stepcode='" + User.CurrentStepCode + "'", "select");
  681. if (dt.Rows.Count > 0)
  682. {
  683. int BadCodeInStep = 0;
  684. string badname = "";
  685. for (int i = 0; i < dt.Rows.Count; i++)
  686. {
  687. for (int j = 0; j < bccode.Length; j++)
  688. {
  689. if (dt.Rows[i]["sr_badcode"].ToString() == bccode[j])
  690. {
  691. badname += "[" + bcname[j] + "]";
  692. BadCodeInStep += 1;
  693. }
  694. }
  695. }
  696. //选中的不良代码必须全在工序默认的不良代码中才通过判断
  697. if (BadCodeInStep == bccode.Length)
  698. {
  699. dh.UpdateByCondition("makebad", "mb_status=-1", "mb_sncode='" + ms_sncode.Text + "' and mb_makecode='" + ma_code.Text + "' and mb_stepcode='" + User.CurrentStepCode + "'");
  700. dh.UpdateByCondition("makeserial", "ms_stepcode='',ms_status=1,ms_nextstepcode='" + User.CurrentStepCode + "'", "ms_id='" + oMSID + "'");
  701. LogicHandler.DoCommandLog(Tag.ToString(), User.UserCode, ma_code.Text, User.UserLineCode, User.UserSourceCode, "快速维修成功", "快速维修", "", ob_checkno.Text);
  702. OperateResult.AppendText(">>本次采集不良代码" + badname + "存在于本工序" + User.CurrentStepCode + "中,请解除故障后重新测试本站\n", Color.Black);
  703. }
  704. else OperateResult.AppendText(">>" + ms_sncode.Text + "成功采集为不良\n", Color.Red);
  705. }
  706. else OperateResult.AppendText(">>" + ms_sncode.Text + "成功采集为不良\n", Color.Red);
  707. LastSncode = ms_sncode.Text;
  708. //采集完不良,聚焦序列号
  709. //ms_sncode.Focus();
  710. //记录操作日志
  711. ms_sncode.Text = "";
  712. //清除不良信息
  713. bc_code.Text = "";
  714. bc_remark.Text = "";
  715. ChoosedRejectList.Items.Clear();
  716. LoadCollectedNum();
  717. WaitList.Clear();
  718. ChoosedList.Clear();
  719. bc_code.Focus();
  720. }
  721. else OperateResult.AppendText(">>" + ErrorMessage + "\n", Color.Red);
  722. }
  723. }
  724. private void bc_code_KeyDown(object sender, KeyEventArgs e)
  725. {
  726. if (e.KeyCode == Keys.Enter)
  727. {
  728. sql.Clear();
  729. sql.Append("select bg_code||':'||bg_name bg_code,bc_code,bc_name,'' bc_remark from badgroupdetail left join ");
  730. 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 ");
  731. DataTable dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
  732. if (dt.Rows.Count > 0)
  733. {
  734. for (int i = 0; i < ChoosedRejectList.Items.Count; i++)
  735. {
  736. if (ChoosedRejectList.Items[i].ListView.Items[i].SubItems[2].Text == bc_code.Text)
  737. {
  738. OperateResult.AppendText(">>已添加过不良代码" + bc_code.Text + "\n", Color.Red, bc_code);
  739. return;
  740. }
  741. }
  742. ListViewItem lvi = new ListViewItem();
  743. lvi.Text = "";
  744. for (int j = 0; j < dt.Columns.Count; j++)
  745. lvi.SubItems.Add(dt.Rows[0][j].ToString());
  746. ChoosedRejectList.Items.Add(lvi);
  747. bc_code.Clear();
  748. bc_remark.Focus();
  749. }
  750. else OperateResult.AppendText(">>" + bc_code.Text + "不良代码不存在\n", Color.Red, bc_code);
  751. }
  752. }
  753. private void LoadCheckQTY()
  754. {
  755. sql.Clear();
  756. string condition = "";
  757. int nowcheckqty = int.Parse(ob_nowcheckqty.Text == "" ? "0" : ob_nowcheckqty.Text);
  758. int batchqty = int.Parse(ob_batchqty.Text == "" ? "0" : ob_batchqty.Text);
  759. if (nowcheckqty + 1 == batchqty && AutoCut)
  760. {
  761. condition = "and ob_status='UNCHECK' and ob_checkno='" + ob_checkno.Text + "'";
  762. }
  763. else
  764. {
  765. condition = "and ob_status='ENTERING' ";
  766. }
  767. if (pr_sendchecktype.Text == "SaleCode")
  768. {
  769. condition += " and ob_salecode='" + ma_salecode.Text + "'";
  770. }
  771. sql.Append("select ob_batchqty,ob_nowcheckqty,ob_checkno from oqcbatch where ");
  772. sql.Append("ob_linecode='" + User.UserLineCode + "' and ob_prodcode='" + ma_prodcode.Text + "' and ");
  773. sql.Append("ob_stepcode='" + User.CurrentStepCode + "' " + condition);
  774. DataTable dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
  775. if (dt.Rows.Count > 0)
  776. {
  777. ob_sendqty.Text = dh.getFieldDataByCondition("oqcbatch", "sum(ob_nowcheckqty)", "ob_makecode='" + ma_code.Text + "' and ob_status<>'ENTERING'").ToString();
  778. ob_batchqty.Text = dt.Rows[0]["ob_batchqty"].ToString();
  779. ob_nowcheckqty.Text = dt.Rows[0]["ob_nowcheckqty"].ToString();
  780. ob_checkno.Text = dt.Rows[0]["ob_checkno"].ToString();
  781. nowcheckqty = int.Parse(ob_nowcheckqty.Text == "" ? "0" : ob_nowcheckqty.Text);
  782. batchqty = int.Parse(ob_batchqty.Text == "" ? "0" : ob_batchqty.Text);
  783. if (nowcheckqty == batchqty)
  784. {
  785. ob_nowcheckqty.ForeColor = Color.Red;
  786. OperateResult.AppendText(">>当前采集数量已达到送检数量\n", Color.Red);
  787. if (AutoCut)
  788. {
  789. OperateResult.AppendText(">>批次" + ob_checkno.Text + "自动断批\n", Color.Blue);
  790. }
  791. }
  792. }
  793. else
  794. {
  795. BaseUtil.CleanControlsText(ob_batchqty, ob_nowcheckqty, ob_checkno);
  796. SendCheck.Enabled = false;
  797. }
  798. if (ob_batchqty.Text != "")
  799. {
  800. SendCheck.Enabled = true;
  801. }
  802. else
  803. {
  804. SendCheck.Enabled = false;
  805. }
  806. }
  807. private void GoodProduct_CheckedChanged(object sender, EventArgs e)
  808. {
  809. if (GoodProduct.Checked)
  810. {
  811. bc_code.Enabled = false;
  812. WaitReject.Enabled = false;
  813. ChooseedReject.Enabled = false;
  814. Save.Visible = false;
  815. if (ms_sncode.Text == "")
  816. {
  817. ms_sncode.Focus();
  818. }
  819. }
  820. else
  821. {
  822. bc_code.Enabled = true;
  823. WaitReject.Enabled = true;
  824. ChooseedReject.Enabled = true;
  825. Save.Visible = true;
  826. bc_code.Focus();
  827. }
  828. }
  829. private void SendCheck_Click(object sender, EventArgs e)
  830. {
  831. sql.Clear();
  832. sql.Append("update oqcbatch set ob_status='UNCHECK' where ob_checkno ='" + ob_checkno.Text + "'");
  833. dh.ExecuteSql(sql.GetString(), "select");
  834. ob_sendqty.Text = dh.getFieldDataByCondition("oqcbatch", "sum(ob_nowcheckqty)", "ob_makecode='" + ma_code.Text + "' and ob_status<>'ENTERING'").ToString();
  835. ob_nowcheckqty.Text = "";
  836. ob_batchqty.Text = "";
  837. ob_nowcheckqty.ForeColor = Color.Black;
  838. SendCheck.Enabled = false;
  839. OperateResult.AppendText(">>批次" + ob_checkno.Text + "送检成功\n", Color.Blue);
  840. ms_sncode.Focus();
  841. LogicHandler.InsertMakeProcess(LastSncode, ma_code.Text, User.UserSourceCode, "手动送检", "手动送检成功", User.UserCode);
  842. //记录操作日志
  843. LogicHandler.DoCommandLog(Tag.ToString(), User.UserCode, ma_code.Text, User.UserLineCode, User.UserSourceCode, "手动送检", "手动送检成功", "", ob_checkno.Text);
  844. ob_checkno.Text = "";
  845. }
  846. private void ob_checkno_TextChanged(object sender, EventArgs e)
  847. {
  848. if (ob_checkno.Text != "")
  849. {
  850. string Cut = dh.getFieldDataByCondition("product left join oqcbatch on ob_prodcode=pr_code", "pr_ifautocutcheckno", "ob_checkno='" + ob_checkno.Text + "'").ToString();
  851. if (Cut == "" || Cut == "0")
  852. AutoCut = false;
  853. else
  854. AutoCut = true;
  855. SendCheck.Enabled = true;
  856. }
  857. }
  858. /// <summary>
  859. /// 工单变化修改数量
  860. /// </summary>
  861. /// <param name="sender"></param>
  862. /// <param name="e"></param>
  863. private void ma_code_UserControlTextChanged(object sender, EventArgs e)
  864. {
  865. if (ma_code.Text.Length > 4)
  866. {
  867. BaseUtil.CleanControlsText(mcd_inqty, mcd_remainqty, ob_batchqty, ob_nowcheckqty, ob_sendqty);
  868. LoadCollectedNum();
  869. LoadCheckQTY();
  870. }
  871. }
  872. private void Make_TestCollection_FormClosing(object sender, FormClosingEventArgs e)
  873. {
  874. dh.Dispose();
  875. }
  876. private void ma_prodcode_TextChanged(object sender, EventArgs e)
  877. {
  878. LoadBadGroupData();
  879. }
  880. private void Filter_UserControlTextChanged(object sender, EventArgs e)
  881. {
  882. try
  883. {
  884. DataRow[] dr = (BadInfSource.DataSource as DataTable).Select("bc_code like '%" + Filter.Text + "%' or bc_name like '%" + Filter.Text + "%'");
  885. DataTable dt = (BadInfSource.DataSource as DataTable).Clone();
  886. for (int i = 0; i < dr.Length; i++)
  887. {
  888. dt.Rows.Add(dr[i].ItemArray);
  889. }
  890. WaitRejectList.Items.Clear();
  891. WaitRejectList.BeginUpdate();
  892. for (int i = 0; i < dt.Rows.Count; i++)
  893. {
  894. if (!ChoosedList.Contains(dt.Rows[i]["bc_code"].ToString()))
  895. {
  896. ListViewItem lvi = new ListViewItem();
  897. //第一列是勾选列,设置列头文本为空
  898. lvi.Text = "";
  899. WaitList.Add(dt.Rows[i]["bc_code"].ToString());
  900. for (int j = 0; j < dt.Columns.Count; j++)
  901. lvi.SubItems.Add(dt.Rows[i][j].ToString());
  902. WaitRejectList.Items.Add(lvi);
  903. }
  904. }
  905. WaitRejectList.EndUpdate();
  906. }
  907. catch (Exception)
  908. {
  909. }
  910. }
  911. private void WaitRejectList_DoubleClick(object sender, EventArgs e)
  912. {
  913. for (int i = WaitRejectList.Items.Count - 1; i >= 0; i--)
  914. {
  915. if (WaitRejectList.Items[i].Checked)
  916. {
  917. //双击右移
  918. ChooseedReject.PerformClick();
  919. }
  920. }
  921. }
  922. private void Make_TestCollection_KeyDown(object sender, KeyEventArgs e)
  923. {
  924. if (e.Modifiers == Keys.Control && e.KeyCode == Keys.Q)
  925. {
  926. if (!LockSn)
  927. {
  928. ControlLockTimer.Start();
  929. LockSn = true;
  930. Lock_label.Visible = true;
  931. }
  932. else
  933. {
  934. ControlLockTimer.Stop();
  935. LockSn = false;
  936. Lock_label.Visible = false;
  937. }
  938. }
  939. }
  940. private void ms_code_KeyDown_one(object sender, KeyEventArgs e)
  941. {
  942. if (e.KeyCode == Keys.Enter)
  943. {
  944. if (SMTBind.Checked&& GoodProduct.Checked)
  945. {
  946. 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");
  947. if (dt.Rows.Count > 0)
  948. {
  949. for (int i = 0; i < dt.Rows.Count; i++)
  950. {
  951. ms_sncode.Text = dt.Rows[i]["sb_barcode"].ToString();
  952. ms_code_KeyDown(sender, new KeyEventArgs(Keys.Enter));
  953. }
  954. }
  955. else
  956. {
  957. OperateResult.AppendText(">>SN" + ms_sncode.Text + "未进行分板绑定\n", Color.Red, ms_sncode);
  958. }
  959. }
  960. else
  961. {
  962. ms_code_KeyDown(sender, new KeyEventArgs(Keys.Enter));
  963. }
  964. }
  965. }
  966. private void SMTBind_CheckedChanged(object sender, EventArgs e)
  967. {
  968. Settings.Default.SMTBIND = SMTBind.Checked;
  969. Settings.Default.Save();
  970. }
  971. private void StartWatch_Click(object sender, EventArgs e)
  972. {
  973. if (FolderPath.Text == "")
  974. {
  975. OperateResult.AppendText("请选择监控文件夹\n");
  976. return;
  977. }
  978. else
  979. {
  980. if (!Directory.Exists(FolderPath.Text))
  981. {
  982. OperateResult.AppendText("监控文件夹不存在\n");
  983. return;
  984. }
  985. }
  986. XmlWatcher.Path = FolderPath.Text;
  987. XmlWatcher.Filter = "*.csv";
  988. XmlWatcher.EnableRaisingEvents = true;
  989. //设置缓存数据
  990. BaseUtil.SetCacheData("FolderPath", FolderPath.Text);
  991. //设置按钮不可点击
  992. StartWatch.Enabled = false;
  993. ChooseFolder.Enabled = false;
  994. StopWatch.Enabled = true;
  995. OperateResult.AppendText("开始执行监控\n");
  996. }
  997. private void StopWatch_Click(object sender, EventArgs e)
  998. {
  999. XmlWatcher.EnableRaisingEvents = false;
  1000. StartWatch.Enabled = true;
  1001. ChooseFolder.Enabled = true;
  1002. StopWatch.Enabled = false;
  1003. OperateResult.AppendText("停止执行监控\n");
  1004. }
  1005. private void ChooseFolder_Click(object sender, EventArgs e)
  1006. {
  1007. FolderBrowserDialog folder = new FolderBrowserDialog();
  1008. folder.Description = "选择监控文件夹";
  1009. DialogResult result = folder.ShowDialog();
  1010. if (result == DialogResult.OK)
  1011. {
  1012. FolderPath.Text = folder.SelectedPath;
  1013. }
  1014. }
  1015. private void XmlWatcher_Created(object sender, FileSystemEventArgs e)
  1016. {
  1017. //while (true)
  1018. //{
  1019. // try
  1020. // {
  1021. // using (Stream stream = File.Open(e.FullPath, FileMode.Open, FileAccess.ReadWrite, FileShare.ReadWrite))
  1022. // {
  1023. // if (stream != null)
  1024. // break;
  1025. // }
  1026. // }
  1027. // catch (Exception ex)
  1028. // {
  1029. // Console.WriteLine(ex.Message);
  1030. // }
  1031. //}
  1032. //StreamReader _Sr = new StreamReader(FolderPath.Text + @"\" + e.Name, Encoding.UTF8);
  1033. //String[] strData;
  1034. //string line;
  1035. //while ((line = _Sr.ReadLine()) != null)
  1036. //{
  1037. // strData = line.Replace("\r", "").Replace("\n", "").Replace("\t", "").Split(',');
  1038. // if (strData.Length > 5 && strData[0] == "ArrayID")
  1039. // {
  1040. // if (strData[5] != ""&& strData[5] != "NOREAD")
  1041. // {
  1042. // if (strData[3] == "Good"|| strData[3] == "Pass")
  1043. // {
  1044. // ms_sncode.Text = strData[5];
  1045. // ms_code_KeyDown(this, new KeyEventArgs(Keys.Enter));
  1046. // }
  1047. // else {
  1048. // OperateResult.AppendText(">>解析数据" + strData[5] + "非良品,无法采集\n", Color.Red, ms_sncode);
  1049. // }
  1050. // }
  1051. // }
  1052. //}
  1053. //_Sr.Close();
  1054. }
  1055. private void XmlWatcher_Changed(object sender, FileSystemEventArgs e)
  1056. {
  1057. if (e.ChangeType == WatcherChangeTypes.Changed || e.ChangeType == WatcherChangeTypes.Created)
  1058. {
  1059. Stream stream = null;
  1060. while (true)
  1061. {
  1062. try
  1063. {
  1064. using (stream = File.Open(e.FullPath, FileMode.Open, FileAccess.Read, FileShare.Read))
  1065. {
  1066. if (stream != null)
  1067. stream.Close();
  1068. break;
  1069. }
  1070. }
  1071. catch (Exception ex)
  1072. {
  1073. Console.WriteLine(ex.Message);
  1074. }
  1075. }
  1076. FileInfo fileInfo = new FileInfo(e.FullPath);
  1077. if (dateTimeDictionary.ContainsKey(e.FullPath))
  1078. {
  1079. if ((DateTime.Now - dateTimeDictionary[e.FullPath]).Seconds < 8)
  1080. {
  1081. return;
  1082. }
  1083. else
  1084. {
  1085. dateTimeDictionary.Remove(e.FullPath);
  1086. dateTimeDictionary.Add(e.FullPath, DateTime.Now);
  1087. }
  1088. }
  1089. else
  1090. {
  1091. dateTimeDictionary.Add(e.FullPath, DateTime.Now);
  1092. }
  1093. StreamReader _Sr = new StreamReader(e.FullPath, Encoding.UTF8);
  1094. String[] strData;
  1095. string line;
  1096. while ((line = _Sr.ReadLine()) != null)
  1097. {
  1098. strData = line.Replace("\r", "").Replace("\n", "").Replace("\t", "").Split(',');
  1099. if (strData.Length > 5 && strData[0] == "ArrayID")
  1100. {
  1101. if (strData[5] != "" && strData[5] != "NOREAD")
  1102. {
  1103. if (strData[3] == "Good" || strData[3] == "Pass")
  1104. {
  1105. ms_sncode.Text = strData[5];
  1106. ms_code_KeyDown(this, new KeyEventArgs(Keys.Enter));
  1107. }
  1108. else
  1109. {
  1110. OperateResult.AppendText(">>解析数据" + strData[5] + "非良品,无法采集\n", Color.Red, ms_sncode);
  1111. }
  1112. }
  1113. }
  1114. }
  1115. _Sr.Close();
  1116. }
  1117. }
  1118. private void normalButton2_Click(object sender, EventArgs e)
  1119. {
  1120. Make_NewDev badcode = new Make_NewDev(ma_code.Text, User.UserLineCode);
  1121. BaseUtil.SetFormCenter(badcode);
  1122. badcode.ShowDialog();
  1123. }
  1124. private void bc_remark_KeyDown(object sender, KeyEventArgs e)
  1125. {
  1126. if (e.KeyCode == Keys.Enter)
  1127. {
  1128. ms_sncode.Focus();
  1129. ms_sncode.SelectAll();
  1130. }
  1131. }
  1132. private void ControlLockTimer_Tick_1(object sender, EventArgs e)
  1133. {
  1134. LoadCollectedNum();
  1135. }
  1136. }
  1137. }