Make_SMTSStencil.cs 26 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566
  1. using System;
  2. using System.Collections.Generic;
  3. using System.ComponentModel;
  4. using System.Data;
  5. using System.Drawing;
  6. using System.Linq;
  7. using System.Text;
  8. using System.Windows.Forms;
  9. using UAS_MES_NEW;
  10. using UAS_MES_NEW.DataOperate;
  11. using UAS_MES_NEW.Entity;
  12. using UAS_MES_NEW.PublicMethod;
  13. namespace UAS_MES_NEW.Make
  14. {
  15. public partial class Make_SMTSStencil : Form
  16. {
  17. DataTable Dbfind;
  18. bool ifUsed = false;
  19. AutoSizeFormClass asc = new AutoSizeFormClass();
  20. DataHelper dh = SystemInf.dh;
  21. StringBuilder sql = new StringBuilder();
  22. public Make_SMTSStencil()
  23. {
  24. InitializeComponent();
  25. SU_DEVCODE.Enabled = false;
  26. st_combinenumber.Enabled = false;
  27. SU_DEVCODE1.Enabled = false;
  28. st_table.Enabled = false;
  29. su_singlepringqty1.Enabled = false;
  30. Receive.Enabled = false;
  31. Return.Enabled = false;
  32. SU_DEVCODE.Enabled = false;
  33. SU_DEVCODE1.Enabled = false;
  34. ST_ENSIONA.Enabled = false;
  35. ST_ENSIONB.Enabled = false;
  36. ST_ENSIONC.Enabled = false;
  37. ST_ENSIOND.Enabled = false;
  38. ST_ENSIONE.Enabled = false;
  39. Scrap.Enabled = false;
  40. }
  41. private void Make_SMTStencil_Load(object sender, EventArgs e)
  42. {
  43. asc.controllInitializeSize(this);
  44. li_code.Text = User.UserLineCode;
  45. //工单号放大镜配置
  46. ma_code.TableName = "make left join product on ma_prodcode=pr_code";
  47. ma_code.SelectField = "ma_code # 工单号,ma_prodcode # 产品编号,ma_qty # 工单数量,pr_detail # 产品名称,ma_softversion # 软件版本,ma_salecode # 销售单号,pr_sendchecktype # 产品送检方式";
  48. ma_code.FormName = Name;
  49. ma_code.SetValueField = new string[] { "ma_code", "ma_prodcode", "ma_qty", "pr_detail", "ma_softversion", "ma_salecode", "nvl(pr_sendchecktype,'LineCode')pr_sendchecktype" };
  50. ma_code.DbChange += Ma_code_DbChange;
  51. li_code.TableName = "Line";
  52. li_code.SelectField = "li_code # 线别编号,li_name # 线别名称";
  53. li_code.Condition = "li_wccode='SMT'";
  54. li_code.FormName = Name;
  55. li_code.SetValueField = new string[] { "li_code", "li_name" };
  56. li_code.DbChange += Li_code_DbChange;
  57. ma_code.Controls["TextBox"].Focus();
  58. }
  59. private void Li_code_DbChange(object sender, EventArgs e)
  60. {
  61. Dbfind = li_code.ReturnData;
  62. BaseUtil.SetFormValue(this.Controls, Dbfind);
  63. }
  64. private void Ma_code_DbChange(object sender, EventArgs e)
  65. {
  66. Dbfind = ma_code.ReturnData;
  67. BaseUtil.SetFormValue(this.Controls, Dbfind);
  68. Confirm.PerformClick();
  69. }
  70. private void Make_SMTStencil_SizeChanged(object sender, EventArgs e)
  71. {
  72. asc.controlAutoSize(this);
  73. }
  74. private void LoadGridData()
  75. {
  76. sql.Clear();
  77. sql.Append("select St_PCBCODE,su_stcode,su_table,su_status,su_linecode,su_usemacode,su_singlepringqty,su_stverison ");
  78. sql.Append("from StencilUse left join stencil on st_code=su_stcode where su_usemacode='" + ma_code.Text + "' and su_status='在线' and st_kind = '刮刀'");
  79. DataTable dt = (DataTable)dh.ExecuteSql(sql.ToString(), "select");
  80. BaseUtil.FillDgvWithDataTable(ToolsBom, dt);
  81. }
  82. private void Confirm_Click(object sender, EventArgs e)
  83. {
  84. LoadGridData();
  85. }
  86. private void Receive_Click(object sender, EventArgs e)
  87. {
  88. if (ma_code.Text == "")
  89. {
  90. MessageBox.Show("工单号不能为空");
  91. return;
  92. }
  93. int WaringCount =int.Parse(dh.GetConfig("WaringCount", "Stencil").ToString());
  94. DataTable dt = (DataTable)dh.ExecuteSql("select ST_USESTATUS,st_version,nvl(st_maxusecount,0)st_maxusecount,nvl(st_usecount,0)st_usecount from Stencil where st_code='" + SU_DEVCODE.Text + "' and st_statuscode='AUDITED' and st_kind = '刮刀'", "select");
  95. string status = "";
  96. string version = "";
  97. int st_maxusecount = 0;
  98. int st_usecount = 0;
  99. if (dt.Rows.Count > 0)
  100. {
  101. status = dt.Rows[0]["ST_USESTATUS"].ToString();
  102. version = dt.Rows[0]["st_version"].ToString();
  103. st_maxusecount =int.Parse( dt.Rows[0]["st_maxusecount"].ToString());
  104. st_usecount = int.Parse(dt.Rows[0]["st_usecount"].ToString());
  105. if (status == "在线" || status == "报废" || status == "在仓")
  106. {
  107. MessageBox.Show("当前刮刀" + SU_DEVCODE.Text + "处于" + status + "状态,无法领用");
  108. return;
  109. }
  110. }
  111. else
  112. {
  113. MessageBox.Show("刮刀编号" + SU_DEVCODE.Text + "不存在或者未审核");
  114. return;
  115. }
  116. //使用次数预警
  117. if (st_maxusecount - st_usecount < WaringCount)
  118. {
  119. string close = MessageBox.Show(this.ParentForm, "刮刀已使用"+ st_usecount+",距离使用上限还有"+(st_maxusecount - st_usecount)+"次", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question).ToString();
  120. if (close != "Yes")
  121. {
  122. return;
  123. }
  124. }
  125. //限制钢网使用的产品
  126. String pr_spec = dh.getFieldDataByCondition("product", "pr_spec", "pr_code = '" + ma_prodcode.Text + "'").ToString();
  127. String st_vendcode = dh.getFieldDataByCondition("STENCIL", "nvl(st_vendcode,'aabbcc')", "st_code = '" + SU_DEVCODE.Text + "'").ToString();
  128. //if (!pr_spec.Contains(st_vendcode))
  129. //{
  130. // MessageBox.Show("钢网编号" + SU_DEVCODE.Text + "不能在产品" + ma_prodcode.Text + "中使用");
  131. // return;
  132. //}
  133. //dt = (DataTable)dh.ExecuteSql("select 1 from STENILCANUSEPRO where sp_stcode='" + SU_DEVCODE.Text + "' and sp_prodcode='" + ma_prodcode.Text + "'", "select");
  134. //if (dt.Rows.Count == 0)
  135. //{
  136. // MessageBox.Show("钢网编号" + SU_DEVCODE.Text + "不能在产品" + ma_prodcode.Text + "中使用");
  137. // return;
  138. //}
  139. //一条线只能在线一个钢网
  140. //dt = (DataTable)dh.ExecuteSql("select su_stcode from stenciluse where su_linecode='" + li_code.Text + "' and su_status='在线'", "select");
  141. //if (dt.Rows.Count > 0)
  142. //{
  143. // MessageBox.Show("线别" + li_code.Text + "已有领用的钢网" + dt.Rows[0]["su_stcode"].ToString() + ",请先退回");
  144. // return;
  145. //}
  146. //else
  147. //{
  148. dt = (DataTable)dh.ExecuteSql("select em_name from employee where em_code='" + em_code.Text + "'", "select");
  149. if (dt.Rows.Count > 0)
  150. {
  151. if (int.Parse(su_singlepringqty1.Text) > 0)
  152. {
  153. string em_name = dt.Rows[0]["em_name"].ToString();
  154. sql.Clear();
  155. sql.Append("insert into StencilUse(su_id,SU_USEPRODCODE,SU_CLEANNUMS,su_stid,su_linecode,su_stcode,su_usedate,su_useman,SU_USEMANCODE,SU_TABLE,su_usemacode,su_singlepringqty,su_stverison,SU_STATUS)");
  156. sql.Append("select StencilUse_seq.nextval,'" + ma_prodcode.Text + "',ST_CLEANNUMS,st_id,'" + li_code.Text + "','" + SU_DEVCODE.Text + "',sysdate,'" + em_name + "','" + em_code.Text + "','" + st_table.Text + "','" + ma_code.Text + "'");
  157. sql.Append(",'" + su_singlepringqty1.Text + "',st_version,'在线' from ");
  158. sql.Append("Stencil where st_code='" + SU_DEVCODE.Text + "'");
  159. dh.ExecuteSql(sql.ToString(), "insert");
  160. dh.ExecuteSql("update Stencil set ST_USESTATUS='在线' where st_code='" + SU_DEVCODE.Text + "'", "update");
  161. MessageBox.Show("领用成功");
  162. st_table.SelectedItem = null;
  163. SU_DEVCODE.Text = "";
  164. em_code.Text = "";
  165. Receive.Enabled = false;
  166. LoadGridData();
  167. }
  168. else
  169. {
  170. MessageBox.Show("单片次数必须大于0");
  171. }
  172. }
  173. else
  174. {
  175. MessageBox.Show("人员编号" + em_code.Text + "不存在");
  176. }
  177. // }
  178. }
  179. private void Return_Click(object sender, EventArgs e)
  180. {
  181. //if (ST_ENSIONA.Text != "" && ST_ENSIONB.Text != "" && ST_ENSIONC.Text != "" && ST_ENSIOND.Text != "" && ST_ENSIONE.Text != "")
  182. //{
  183. if (SU_RETURNIFCLEAN.Checked)
  184. {
  185. DataTable dt = (DataTable)dh.ExecuteSql("select ST_USESTATUS,St_USECOUNT from Stencil where st_code='" + SU_DEVCODE1.Text + "' and st_statuscode='AUDITED' and st_kind = '刮刀' ", "select");
  186. if (dt.Rows.Count > 0)
  187. {
  188. string status = dt.Rows[0]["ST_USESTATUS"].ToString();
  189. if (status == "在仓" || status == "借出")
  190. {
  191. MessageBox.Show("当前刮刀" + SU_DEVCODE.Text + "未在线,无需归还");
  192. return;
  193. }
  194. if (status == "报废")
  195. {
  196. MessageBox.Show("当前刮刀" + SU_DEVCODE.Text + "处于" + status + "状态,无法退回");
  197. return;
  198. }
  199. }
  200. else
  201. {
  202. MessageBox.Show("刮刀编号" + SU_DEVCODE1.Text + "不存在或者未审核");
  203. }
  204. string St_USECOUNT = dt.Rows[0]["St_USECOUNT"].ToString();
  205. dt = (DataTable)dh.ExecuteSql("select em_name from employee where em_code='" + em_code1.Text + "'", "select");
  206. if (dt.Rows.Count > 0)
  207. {
  208. //if (int.Parse(st_combinenumber.Text) >= 0)
  209. //{
  210. sql.Clear();
  211. sql.Append("update StencilUse set SU_ENSIONA='" + ST_ENSIONA.Text + "',SU_ENSIONB='" + ST_ENSIONB.Text + "',SU_ENSIONC='" + ST_ENSIONC.Text + "',SU_ENSIOND='" + ST_ENSIOND.Text + "',SU_ENSIONE='" + ST_ENSIONE.Text + "', su_cleannums=nvl(su_cleannums,0)+1, SU_BACKDATE=sysdate,su_returnman='" + dt.Rows[0]["em_name"].ToString() + "',su_returnmancode='" + em_code1.Text + "',");
  212. sql.Append("SU_THISUSETIMES='" + (st_combinenumber.Text == "" ? "0" : st_combinenumber.Text) + "',SU_STATUS='借出'");
  213. sql.Append(",SU_RETURNIFCLEAN='" + (SU_RETURNIFCLEAN.Checked ? "-1" : "0") + "' where su_id=(select max(su_id) from stenciluse where su_stcode='" + SU_DEVCODE1.Text + "' and su_status='在线')");
  214. dh.ExecuteSql(sql.ToString(), "update");
  215. sql.Clear();
  216. sql.Append("update Stencil set st_cleannums=nvl(st_cleannums,0)+1,ST_ENSIONA='" + ST_ENSIONA.Text + "',ST_ENSIONB='" + ST_ENSIONB.Text + "',ST_ENSIONC='" + ST_ENSIONC.Text + "',ST_ENSIOND='" + ST_ENSIOND.Text + "',ST_ENSIONE='" + ST_ENSIONE.Text + "',St_USECOUNT=nvl(St_USECOUNT,0)+" + (st_combinenumber.Text == "" ? "0" : st_combinenumber.Text) + ",ST_USESTATUS='借出' where st_code='" + SU_DEVCODE1.Text + "'");
  217. dh.ExecuteSql(sql.ToString(), "update");
  218. MessageBox.Show("刮刀" + SU_DEVCODE1.Text + "退回成功!");
  219. SU_DEVCODE1.Text = "";
  220. st_combinenumber.Text = "";
  221. em_code1.Text = "";
  222. ST_ENSIONA.Text = "";
  223. ST_ENSIONB.Text = "";
  224. ST_ENSIONC.Text = "";
  225. ST_ENSIOND.Text = "";
  226. ST_ENSIONE.Text = "";
  227. SU_RETURNIFCLEAN.Checked = false;
  228. Return.Enabled = false;
  229. Confirm.PerformClick();
  230. //}
  231. //else
  232. //{
  233. // MessageBox.Show("加工小板数必须大于等于0");
  234. //}
  235. }
  236. else
  237. {
  238. MessageBox.Show("人员编号" + em_code1.Text + "不存在");
  239. }
  240. }
  241. else
  242. {
  243. MessageBox.Show("请确认是否清洗刮刀");
  244. }
  245. //}
  246. // else
  247. // {
  248. // MessageBox.Show("请维护完成的测试参数");
  249. // }
  250. }
  251. private void Radio_CheckedChanged(object sender, EventArgs e)
  252. {
  253. switch ((sender as Control).Name)
  254. {
  255. case "RadioReceive":
  256. if ((sender as RadioButton).Checked)
  257. {
  258. SU_DEVCODE.Enabled = true;
  259. Receive.Enabled = true;
  260. st_table.Enabled = true;
  261. su_singlepringqty1.Enabled = true;
  262. Receive.Enabled = true;
  263. st_combinenumber.Enabled = false;
  264. SU_DEVCODE1.Enabled = false;
  265. Return.Enabled = false;
  266. ST_ENSIONA.Enabled = false;
  267. ST_ENSIONB.Enabled = false;
  268. ST_ENSIONC.Enabled = false;
  269. ST_ENSIOND.Enabled = false;
  270. ST_ENSIONE.Enabled = false;
  271. Return.Enabled = false;
  272. Scrap.Enabled = false;
  273. }
  274. break;
  275. case "RadioReturn":
  276. if ((sender as RadioButton).Checked)
  277. {
  278. SU_DEVCODE1.Enabled = true;
  279. st_combinenumber.Enabled = true;
  280. Return.Enabled = true;
  281. SU_DEVCODE.Enabled = false;
  282. st_table.Enabled = false;
  283. su_singlepringqty1.Enabled = false;
  284. Receive.Enabled = false;
  285. ST_ENSIONA.Enabled = true;
  286. ST_ENSIONB.Enabled = true;
  287. ST_ENSIONC.Enabled = true;
  288. ST_ENSIOND.Enabled = true;
  289. ST_ENSIONE.Enabled = true;
  290. SU_DEVCODE.Enabled = false;
  291. Return.Enabled = true;
  292. Scrap.Enabled = true;
  293. }
  294. break;
  295. default:
  296. break;
  297. }
  298. }
  299. private void SU_DEVCODE_KeyDown(object sender, KeyEventArgs e)
  300. {
  301. if (e.KeyCode == Keys.Enter)
  302. {
  303. DataTable dt = (DataTable)dh.ExecuteSql("select st_usestatus,st_table from stencil where st_code='" + SU_DEVCODE.Text + "' and st_statuscode='AUDITED' and st_kind = '刮刀' ", "select");
  304. if (dt.Rows.Count == 0)
  305. {
  306. MessageBox.Show("刮刀编号" + SU_DEVCODE.Text + "不存在或者未审核");
  307. }
  308. if (dt.Rows.Count > 0)
  309. {
  310. for (int i = 0; i < st_table.Items.Count; i++)
  311. {
  312. if (st_table.Items[i].ToString() == dt.Rows[0]["st_table"].ToString())
  313. {
  314. st_table.SelectedItem = st_table.Items[i];
  315. }
  316. }
  317. Receive.Enabled = true;
  318. if (dt.Rows[0]["st_usestatus"].ToString() == "报废")
  319. {
  320. MessageBox.Show("刮刀编号" + SU_DEVCODE.Text + "已报废");
  321. }
  322. }
  323. }
  324. }
  325. private void SU_DEVCODE1_KeyDown(object sender, KeyEventArgs e)
  326. {
  327. if (e.KeyCode == Keys.Enter)
  328. {
  329. DataTable dt = (DataTable)dh.ExecuteSql("select case when nvl(ST_COMBINENUMBER,1)=0 then 1 else nvl(ST_COMBINENUMBER,1) end from STENCIL where st_code='" + SU_DEVCODE1.Text + "' and st_statuscode='AUDITED' and st_kind = '刮刀'", "select");
  330. //if (dt.Rows.Count > 0)
  331. //{
  332. // try
  333. // {
  334. // st_combinenumber.Text = (Math.Ceiling(decimal.Parse(ma_qty.Text) / decimal.Parse(dt.Rows[0][0].ToString()))).ToString();
  335. // }
  336. // catch (Exception)
  337. // {
  338. // }
  339. //}
  340. //else
  341. //{
  342. // MessageBox.Show("钢网编号" + SU_DEVCODE1.Text + "不存在或者未审核");
  343. //}
  344. dt = (DataTable)dh.ExecuteSql("select nvl(st_usecount,0)st_usecount,case when nvl(ST_COMBINENUMBER,1)=0 then 1 else nvl(ST_COMBINENUMBER,1) end from STENCIL where st_code='" + SU_DEVCODE1.Text + "' and st_statuscode='AUDITED' and st_kind = '刮刀'", "select");
  345. if (dt.Rows.Count == 0)
  346. {
  347. MessageBox.Show("刮刀编号" + SU_DEVCODE1.Text + "不存在或者未审核");
  348. }
  349. else
  350. {
  351. st_usecount.Text = dt.Rows[0]["st_usecount"].ToString();
  352. if (int.Parse(st_usecount.Text) > 0)
  353. {
  354. ifUsed = true;
  355. }
  356. else
  357. {
  358. ifUsed = false;
  359. }
  360. }
  361. }
  362. }
  363. //默认范围39-55,如不在范围内则可以报废
  364. private void ST_ENSION_TextChanged(object sender, EventArgs e)
  365. {
  366. //double Range = 0;
  367. //List<string> Num = new List<string>();
  368. //Num.Add(ST_ENSIONA.Text);
  369. //Num.Add(ST_ENSIONB.Text);
  370. //Num.Add(ST_ENSIONC.Text);
  371. //Num.Add(ST_ENSIOND.Text);
  372. //Num.Add(ST_ENSIONE.Text);
  373. //int CheckCount = 0;
  374. //int FillCount = 0;
  375. //foreach (string item in Num)
  376. //{
  377. // if (item != "")
  378. // {
  379. // FillCount = FillCount + 1;
  380. // if (double.TryParse(item, out Range))
  381. // {
  382. // //如果使用过张力范围39-55,使用过30-55
  383. // if (ifUsed)
  384. // {
  385. // if (Range > 30 && Range <= 50)
  386. // {
  387. // CheckCount = CheckCount + 1;
  388. // }
  389. // }
  390. // else
  391. // {
  392. // if (Range > 30 && Range <= 50)
  393. // {
  394. // CheckCount = CheckCount + 1;
  395. // }
  396. // }
  397. // }
  398. // }
  399. //}
  400. //if (FillCount == 5)
  401. //{
  402. // if (CheckCount == 5)
  403. // {
  404. // Return.Enabled = true;
  405. // Scrap.Enabled = false;
  406. // }
  407. // else
  408. // {
  409. // Return.Enabled = false;
  410. // Scrap.Enabled = true;
  411. // }
  412. //}
  413. }
  414. Make_StencilScrapReason form;
  415. private void Scrap_Click(object sender, EventArgs e)
  416. {
  417. DataTable dt = (DataTable)dh.ExecuteSql("select st_usestatus,st_status from stencil where st_code='" + SU_DEVCODE1.Text + "' and st_statuscode='AUDITED' and st_kind = '刮刀'", "select");
  418. if (dt.Rows.Count > 0)
  419. {
  420. if (dt.Rows[0]["st_usestatus"].ToString() == "报废")
  421. {
  422. MessageBox.Show("刮刀" + SU_DEVCODE1.Text + "已处于报废状态");
  423. return;
  424. }
  425. if (dt.Rows[0]["st_usestatus"].ToString() != "在仓")
  426. {
  427. MessageBox.Show("报废刮刀必须" + SU_DEVCODE1.Text + "处于在仓状态");
  428. return;
  429. }
  430. string closetab_confirm = MessageBox.Show(this.ParentForm, "报废后不可撤销,是否确认报废", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question).ToString();
  431. if (closetab_confirm != "Yes")
  432. {
  433. return;
  434. }
  435. form = new Make_StencilScrapReason();
  436. BaseUtil.SetFormCenter(form);
  437. form.Controls["ConfirmScrap"].Click += Make_SMTStencil_Click;
  438. form.ShowDialog();
  439. }
  440. else
  441. {
  442. MessageBox.Show("刮刀编号" + SU_DEVCODE1.Text + "不存在或者未审核");
  443. }
  444. }
  445. private void Make_SMTStencil_Click(object sender, EventArgs e)
  446. {
  447. string Code = "";
  448. string scrapreason = form.Controls["Reason"].Text;
  449. if (scrapreason == "")
  450. {
  451. MessageBox.Show("报废原因不能为空");
  452. return;
  453. }
  454. sql.Clear();
  455. sql.Append("update StencilUse set SU_IFSCRAPOLD=-1,SU_STATUS='报废',SU_ENSIONA='" + ST_ENSIONA.Text + "',SU_ENSIONB='" + ST_ENSIONB.Text + "',SU_ENSIONC='" + ST_ENSIONC.Text + "',SU_ENSIOND='" + ST_ENSIOND.Text + "',SU_ENSIONE='" + ST_ENSIONE.Text + "'");
  456. sql.Append(",SU_RETURNIFCLEAN='" + (SU_RETURNIFCLEAN.Checked ? "-1" : "0") + "' where su_id=(select max(su_id) from stenciluse where su_stcode='" + SU_DEVCODE1.Text + "')");
  457. dh.ExecuteSql(sql.ToString(), "update");
  458. sql.Clear();
  459. sql.Append("update Stencil set ST_SCRAPREASON='" + scrapreason + "',ST_SCRAPMANCODE='" + User.UserCode + "',st_scrapman='" + User.UserName + "',st_scrapdate=sysdate,ST_USESTATUS='报废',ST_ENSIONA='" + ST_ENSIONA.Text + "',ST_ENSIONB='" + ST_ENSIONB.Text + "',");
  460. sql.Append("ST_ENSIONC='" + ST_ENSIONC.Text + "',ST_ENSIOND='" + ST_ENSIOND.Text + "',ST_ENSIONE='" + ST_ENSIONE.Text + "' ");
  461. sql.Append("where st_code='" + SU_DEVCODE1.Text + "'");
  462. dh.ExecuteSql(sql.ToString(), "insert");
  463. ////推送人员信息
  464. //string[] emid = dh.GetConfig("sendEmp", "Stencil").ToString().Replace("\n", "#").Split('#');
  465. //for (int i = 0; i < emid.Length; i++)
  466. //{
  467. // string em_name = dh.getFieldDataByCondition("employee", "em_name", "em_id='" + emid[i] + "'").ToString();
  468. // // LogicHandler.SendMessage(emid[i], em_name, "钢网" + SU_DEVCODE1.Text + "已报废" + ",原因" + scrapreason + ",人员" + User.UserName);
  469. //}
  470. form.Close();
  471. SU_DEVCODE1.Text = "";
  472. ST_ENSIONA.Text = "";
  473. ST_ENSIONB.Text = "";
  474. ST_ENSIONC.Text = "";
  475. ST_ENSIOND.Text = "";
  476. ST_ENSIONE.Text = "";
  477. SU_RETURNIFCLEAN.Checked = false;
  478. Scrap.Enabled = false;
  479. MessageBox.Show("报废成功!");
  480. }
  481. private void ma_code_TextKeyDown(object sender, KeyEventArgs e)
  482. {
  483. if (e.KeyCode == Keys.Enter)
  484. {
  485. Confirm.PerformClick();
  486. }
  487. }
  488. private void Scrap_Click_1(object sender, EventArgs e)
  489. {
  490. }
  491. private void normalButton1_Click(object sender, EventArgs e)
  492. {
  493. DataTable dt = (DataTable)dh.ExecuteSql("select ST_USESTATUS,St_USECOUNT from Stencil where st_code='" + SU_DEVCODE1.Text + "' and st_statuscode='AUDITED' and st_kind = '刮刀'", "select");
  494. if (dt.Rows.Count > 0)
  495. {
  496. string status = dt.Rows[0]["ST_USESTATUS"].ToString();
  497. if (status == "在仓" || status == "借出")
  498. {
  499. MessageBox.Show("当前刮刀" + SU_DEVCODE.Text + "未在线,无法操作");
  500. return;
  501. }
  502. if (status == "报废")
  503. {
  504. MessageBox.Show("当前刮刀" + SU_DEVCODE.Text + "处于" + status + "状态,无法操作");
  505. return;
  506. }
  507. }
  508. else
  509. {
  510. MessageBox.Show("刮刀编号" + SU_DEVCODE1.Text + "不存在或者未审核");
  511. return;
  512. }
  513. sql.Clear();
  514. sql.Append("update StencilUse set su_cleannums=nvl(su_cleannums,0)+1, su_auditdate=sysdate");
  515. sql.Append(" where su_id=(select max(su_id) from stenciluse where su_stcode='" + SU_DEVCODE1.Text + "' and su_status='在线')");
  516. dh.ExecuteSql(sql.ToString(), "update");
  517. MessageBox.Show("刮刀" + SU_DEVCODE1.Text + "6小时清洗成功!");
  518. SU_DEVCODE1.Text = "";
  519. st_combinenumber.Text = "";
  520. em_code1.Text = "";
  521. ST_ENSIONA.Text = "";
  522. ST_ENSIONB.Text = "";
  523. ST_ENSIONC.Text = "";
  524. ST_ENSIOND.Text = "";
  525. ST_ENSIONE.Text = "";
  526. Confirm.PerformClick();
  527. }
  528. }
  529. }