Make_SMTStencil.cs 25 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561
  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_SMTStencil : 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_SMTStencil()
  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_wcname = 'SMT车间' and instr(li_name,'YAMAHA') = 0 order by li_indate,li_code";
  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='在线'");
  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. DataTable dt;
  89. int WaringCount = int.Parse(dh.GetConfig("WaringCount", "Stencil").ToString());
  90. dt = (DataTable)dh.ExecuteSql("select st_kind,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'", "select");
  91. string st_kind = "";
  92. string status = "";
  93. string version = "";
  94. int st_maxusecount = 0;
  95. int st_usecount = 0;
  96. if (dt.Rows.Count > 0)
  97. {
  98. st_kind = dt.Rows[0]["st_kind"].ToString();
  99. status = dt.Rows[0]["ST_USESTATUS"].ToString();
  100. version = dt.Rows[0]["st_version"].ToString();
  101. st_maxusecount = int.Parse(dt.Rows[0]["st_maxusecount"].ToString());
  102. st_usecount = int.Parse(dt.Rows[0]["st_usecount"].ToString());
  103. if (status == "在线" || status == "报废"/* || status == "在仓"*/)
  104. {
  105. MessageBox.Show("当前" + st_kind + SU_DEVCODE.Text + "处于" + status + "状态,无法领用");
  106. return;
  107. }
  108. }
  109. else
  110. {
  111. MessageBox.Show("编号" + SU_DEVCODE.Text + "不存在或者未审核");
  112. return;
  113. }
  114. //使用次数预警
  115. if (st_maxusecount - st_usecount < WaringCount)
  116. {
  117. string close = MessageBox.Show(this.ParentForm, "已使用" + st_usecount + ",距离使用上限还有" + (st_maxusecount - st_usecount) + "次", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question).ToString();
  118. if (close != "Yes")
  119. {
  120. return;
  121. }
  122. }
  123. if (st_kind == "钢网")
  124. {
  125. if (ma_code.Text == "")
  126. {
  127. MessageBox.Show("工单号不能为空");
  128. return;
  129. }
  130. //限制钢网使用的产品
  131. dt = (DataTable)dh.ExecuteSql("select 1 from STENILCANUSEPRO where sp_stcode='" + SU_DEVCODE.Text + "' and sp_prodcode='" + ma_prodcode.Text + "'", "select");
  132. if (dt.Rows.Count == 0)
  133. {
  134. dt = (DataTable)dh.ExecuteSql("select 1 from makematerial where mm_code='" + ma_code.Text + "' and mm_prodcode in (select SP_PRODCODE from " +
  135. "STENILCANUSEPRO where SP_STCODE='" + SU_DEVCODE.Text + "')", "select");
  136. if (dt.Rows.Count == 0)
  137. {
  138. MessageBox.Show("钢网编号" + SU_DEVCODE.Text + "不能在产品" + ma_prodcode.Text + "中使用");
  139. return;
  140. }
  141. }
  142. }
  143. else if (st_kind == "刮刀")
  144. {
  145. }
  146. dt = (DataTable)dh.ExecuteSql("select em_name from employee where em_code='" + em_code.Text + "'", "select");
  147. if (dt.Rows.Count > 0)
  148. {
  149. if (int.Parse(su_singlepringqty1.Text) > 0)
  150. {
  151. string em_name = dt.Rows[0]["em_name"].ToString();
  152. sql.Clear();
  153. 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)");
  154. 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 + "'");
  155. sql.Append(",'" + su_singlepringqty1.Text + "',st_version,'在线' from ");
  156. sql.Append("Stencil where st_code='" + SU_DEVCODE.Text + "'");
  157. dh.ExecuteSql(sql.ToString(), "insert");
  158. dt = (DataTable)dh.ExecuteSql("select ST_USESTATUS,St_USECOUNT from Stencil where st_code='" + SU_DEVCODE.Text + "' and st_statuscode='AUDITED'", "select");
  159. string St_USECOUNT = dt.Rows[0]["St_USECOUNT"].ToString();
  160. dt = (DataTable)dh.ExecuteSql("select em_name from employee where em_code='" + em_code.Text + "'", "select");
  161. if (dt.Rows.Count > 0)
  162. {
  163. sql.Clear();
  164. 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 + "' ");
  165. sql.Append("where su_id=(select max(su_id) from stenciluse where su_stcode='" + SU_DEVCODE.Text + "' and su_status='在线')");
  166. dh.ExecuteSql(sql.ToString(), "update");
  167. }
  168. dh.ExecuteSql("update Stencil set ST_USESTATUS='在线' where st_code='" + SU_DEVCODE.Text + "'", "update");
  169. MessageBox.Show("领用成功");
  170. st_table.SelectedItem = null;
  171. SU_DEVCODE.Text = "";
  172. em_code.Text = "";
  173. Receive.Enabled = false;
  174. LoadGridData();
  175. }
  176. else
  177. {
  178. MessageBox.Show("单片印刷次数必须大于0");
  179. }
  180. }
  181. else
  182. {
  183. MessageBox.Show("人员编号" + em_code.Text + "不存在");
  184. }
  185. }
  186. private void Return_Click(object sender, EventArgs e)
  187. {
  188. if (string.IsNullOrEmpty(st_combinenumber.Text))
  189. {
  190. MessageBox.Show("请维护印刷次数");
  191. return;
  192. }
  193. if (CheckTension()) return;
  194. if (SU_RETURNIFCLEAN.Checked)
  195. {
  196. DataTable dt = (DataTable)dh.ExecuteSql("select st_kind,ST_USESTATUS,St_USECOUNT from Stencil where st_code='" + SU_DEVCODE1.Text + "' and st_statuscode='AUDITED'", "select");
  197. if (dt.Rows.Count > 0)
  198. {
  199. string status = dt.Rows[0]["ST_USESTATUS"].ToString();
  200. string st_kind = dt.Rows[0]["st_kind"].ToString();
  201. if (status == "在仓" || status == "在仓")
  202. {
  203. MessageBox.Show("当前" + st_kind + SU_DEVCODE.Text + "未在线,无需归还");
  204. return;
  205. }
  206. if (status == "报废")
  207. {
  208. MessageBox.Show("当前" + st_kind + SU_DEVCODE.Text + "处于" + status + "状态,无法退回");
  209. return;
  210. }
  211. }
  212. else
  213. {
  214. MessageBox.Show("编号" + SU_DEVCODE1.Text + "不存在或者未审核");
  215. }
  216. string St_USECOUNT = dt.Rows[0]["St_USECOUNT"].ToString();
  217. dt = (DataTable)dh.ExecuteSql("select em_name from employee where em_code='" + em_code1.Text + "'", "select");
  218. if (dt.Rows.Count > 0)
  219. {
  220. if (int.Parse(st_combinenumber.Text) >= 0)
  221. {
  222. sql.Clear();
  223. 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 + "',");
  224. sql.Append("SU_THISUSETIMES='" + (st_combinenumber.Text == "" ? "0" : st_combinenumber.Text) + "',SU_STATUS='在仓',su_usecount=" + (St_USECOUNT == "" ? "0" : St_USECOUNT) + "+" + st_combinenumber.Text);
  225. 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='在线')");
  226. dh.ExecuteSql(sql.ToString(), "update");
  227. sql.Clear();
  228. sql.Append("update Stencil set st_cleannums=nvl(st_cleannums,0)+1,ST_USESTATUS='在仓',st_usecount=nvl(st_usecount,0)+" + (st_combinenumber.Text == "" ? "0" : st_combinenumber.Text) + " where st_code='" + SU_DEVCODE1.Text + "'");
  229. dh.ExecuteSql(sql.ToString(), "update");
  230. MessageBox.Show(SU_DEVCODE1.Text + "退回成功!");
  231. SU_DEVCODE1.Text = "";
  232. st_combinenumber.Text = "";
  233. em_code1.Text = "";
  234. SU_RETURNIFCLEAN.Checked = false;
  235. Return.Enabled = false;
  236. ST_ENSIONA.Text = "";
  237. ST_ENSIONB.Text = "";
  238. ST_ENSIONC.Text = "";
  239. ST_ENSIOND.Text = "";
  240. ST_ENSIONE.Text = "";
  241. Confirm.PerformClick();
  242. }
  243. else
  244. {
  245. MessageBox.Show("加工小板数必须大于等于0");
  246. }
  247. }
  248. else
  249. {
  250. MessageBox.Show("人员编号" + em_code1.Text + "不存在");
  251. }
  252. }
  253. else
  254. {
  255. MessageBox.Show("请确认是否清洗");
  256. }
  257. }
  258. private void Radio_CheckedChanged(object sender, EventArgs e)
  259. {
  260. switch ((sender as Control).Name)
  261. {
  262. case "RadioReceive":
  263. if ((sender as RadioButton).Checked)
  264. {
  265. SU_DEVCODE.Enabled = true;
  266. Receive.Enabled = true;
  267. st_table.Enabled = true;
  268. su_singlepringqty1.Enabled = true;
  269. Receive.Enabled = true;
  270. st_combinenumber.Enabled = false;
  271. SU_DEVCODE1.Enabled = false;
  272. Return.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. }
  286. break;
  287. default:
  288. break;
  289. }
  290. }
  291. private void SU_DEVCODE_KeyDown(object sender, KeyEventArgs e)
  292. {
  293. if (e.KeyCode == Keys.Enter)
  294. {
  295. SU_DEVCODE.Text = SU_DEVCODE.Text.Replace(" ", "");
  296. DataTable dt = (DataTable)dh.ExecuteSql("select st_kind,st_usestatus,st_table from stencil where st_code='" + SU_DEVCODE.Text + "' and st_statuscode='AUDITED'", "select");
  297. if (dt.Rows.Count == 0)
  298. {
  299. MessageBox.Show("编号" + SU_DEVCODE.Text + "不存在或者未审核");
  300. }
  301. if (dt.Rows.Count > 0)
  302. {
  303. string st_kind = dt.Rows[0]["st_kind"].ToString();
  304. for (int i = 0; i < st_table.Items.Count; i++)
  305. {
  306. if (st_table.Items[i].ToString() == dt.Rows[0]["st_table"].ToString())
  307. {
  308. st_table.SelectedItem = st_table.Items[i];
  309. }
  310. }
  311. Receive.Enabled = true;
  312. if (dt.Rows[0]["st_usestatus"].ToString() == "报废")
  313. {
  314. MessageBox.Show(st_kind + "编号" + SU_DEVCODE.Text + "已报废");
  315. }
  316. }
  317. }
  318. }
  319. private void SU_DEVCODE1_KeyDown(object sender, KeyEventArgs e)
  320. {
  321. if (e.KeyCode == Keys.Enter)
  322. {
  323. SU_DEVCODE1.Text = SU_DEVCODE1.Text.Replace(" ", "");
  324. 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'", "select");
  325. if (dt.Rows.Count > 0)
  326. {
  327. try
  328. {
  329. st_combinenumber.Text = (Math.Ceiling(decimal.Parse(ma_qty.Text) / decimal.Parse(dt.Rows[0][0].ToString()))).ToString();
  330. }
  331. catch (Exception)
  332. {
  333. }
  334. }
  335. else
  336. {
  337. MessageBox.Show("钢网编号" + SU_DEVCODE1.Text + "不存在或者未审核");
  338. }
  339. 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'", "select");
  340. if (dt.Rows.Count == 0)
  341. {
  342. MessageBox.Show("钢网编号" + SU_DEVCODE1.Text + "不存在或者未审核");
  343. }
  344. else
  345. {
  346. st_usecount.Text = dt.Rows[0]["st_usecount"].ToString();
  347. if (int.Parse(st_usecount.Text) > 0)
  348. {
  349. ifUsed = true;
  350. }
  351. else
  352. {
  353. ifUsed = false;
  354. }
  355. }
  356. }
  357. }
  358. private bool CheckTension()
  359. {
  360. DataTable dt = (DataTable)dh.ExecuteSql($"select * from stencil where st_code = '{SU_DEVCODE1.Text.Trim()}' and st_kind = '刮刀'", "select");
  361. if (dt.Rows.Count > 0) return false;
  362. List<string> Num = new List<string>();
  363. Num.Add(ST_ENSIONA.Text);
  364. Num.Add(ST_ENSIONB.Text);
  365. Num.Add(ST_ENSIONC.Text);
  366. Num.Add(ST_ENSIOND.Text);
  367. Num.Add(ST_ENSIONE.Text);
  368. dt = (DataTable)dh.ExecuteSql($"SELECT st_tension_min min,st_tension_max max FROM stencil WHERE st_statuscode = 'AUDITED' AND st_code = '{SU_DEVCODE1.Text.Trim()}'", "select");
  369. if (dt.Rows.Count == 0)
  370. {
  371. MessageBox.Show("钢网编号" + SU_DEVCODE1.Text + "不存在或者未审核");
  372. return true;
  373. }
  374. if(string.IsNullOrEmpty(dt.Rows[0]["MIN"].ToString()) || string.IsNullOrEmpty(dt.Rows[0]["MAX"].ToString()))
  375. {
  376. MessageBox.Show($"钢网{SU_DEVCODE1.Text} 未维护张力范围");
  377. return true;
  378. }
  379. foreach (string item in Num)
  380. {
  381. if (string.IsNullOrEmpty(item))
  382. {
  383. MessageBox.Show("请填写张力值");
  384. return true;
  385. }
  386. if (Convert.ToInt32(item) < Convert.ToInt32(dt.Rows[0]["MIN"].ToString()))
  387. {
  388. MessageBox.Show($"张力值: {item}小于最小张力值: {dt.Rows[0]["MIN"].ToString()}");
  389. return true;
  390. }
  391. if (Convert.ToInt32(item) > Convert.ToInt32(dt.Rows[0]["MAX"].ToString()))
  392. {
  393. MessageBox.Show($"张力值: {item}大于最大张力值: {dt.Rows[0]["MAX"].ToString()}");
  394. return true;
  395. }
  396. }
  397. return false;
  398. }
  399. //默认范围39-55,如不在范围内则可以报废
  400. private void ST_ENSION_TextChanged(object sender, EventArgs e)
  401. {
  402. double Range = 0;
  403. List<string> Num = new List<string>();
  404. Num.Add(ST_ENSIONA.Text);
  405. Num.Add(ST_ENSIONB.Text);
  406. Num.Add(ST_ENSIONC.Text);
  407. Num.Add(ST_ENSIOND.Text);
  408. Num.Add(ST_ENSIONE.Text);
  409. int CheckCount = 0;
  410. int FillCount = 0;
  411. foreach (string item in Num)
  412. {
  413. if (item != "")
  414. {
  415. FillCount = FillCount + 1;
  416. if (double.TryParse(item, out Range))
  417. {
  418. //如果使用过张力范围39-55,使用过30-55
  419. if (ifUsed)
  420. {
  421. if (Range > 30 && Range <= 55)
  422. {
  423. CheckCount = CheckCount + 1;
  424. }
  425. }
  426. else
  427. {
  428. if (Range > 30 && Range <= 55)
  429. {
  430. CheckCount = CheckCount + 1;
  431. }
  432. }
  433. }
  434. }
  435. }
  436. if (FillCount == 5)
  437. {
  438. if (CheckCount == 5)
  439. {
  440. Return.Enabled = true;
  441. Scrap.Enabled = false;
  442. }
  443. else
  444. {
  445. Return.Enabled = false;
  446. Scrap.Enabled = true;
  447. }
  448. }
  449. }
  450. Make_StencilScrapReason form;
  451. private void Scrap_Click(object sender, EventArgs e)
  452. {
  453. DataTable dt = (DataTable)dh.ExecuteSql("select st_usestatus,st_status from stencil where st_code='" + SU_DEVCODE1.Text + "' and st_statuscode='AUDITED'", "select");
  454. if (dt.Rows.Count > 0)
  455. {
  456. if (dt.Rows[0]["st_usestatus"].ToString() == "报废")
  457. {
  458. MessageBox.Show( SU_DEVCODE1.Text + "已处于报废状态");
  459. return;
  460. }
  461. if (dt.Rows[0]["st_usestatus"].ToString() != "在仓")
  462. {
  463. MessageBox.Show("报废必须" + SU_DEVCODE1.Text + "处于在仓状态");
  464. return;
  465. }
  466. string closetab_confirm = MessageBox.Show(this.ParentForm, "报废后不可撤销,是否确认报废", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question).ToString();
  467. if (closetab_confirm != "Yes")
  468. {
  469. return;
  470. }
  471. form = new Make_StencilScrapReason();
  472. BaseUtil.SetFormCenter(form);
  473. form.Controls["ConfirmScrap"].Click += Make_SMTStencil_Click;
  474. form.ShowDialog();
  475. }
  476. else
  477. {
  478. MessageBox.Show("编号" + SU_DEVCODE1.Text + "不存在或者未审核");
  479. }
  480. }
  481. private void Make_SMTStencil_Click(object sender, EventArgs e)
  482. {
  483. string Code = "";
  484. string scrapreason = form.Controls["Reason"].Text;
  485. if (scrapreason == "")
  486. {
  487. MessageBox.Show("报废原因不能为空");
  488. return;
  489. }
  490. sql.Clear();
  491. 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 + "'");
  492. sql.Append(",SU_RETURNIFCLEAN='" + (SU_RETURNIFCLEAN.Checked ? "-1" : "0") + "' where su_id=(select max(su_id) from stenciluse where su_stcode='" + SU_DEVCODE1.Text + "')");
  493. dh.ExecuteSql(sql.ToString(), "update");
  494. sql.Clear();
  495. 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 + "',");
  496. sql.Append("ST_ENSIONC='" + ST_ENSIONC.Text + "',ST_ENSIOND='" + ST_ENSIOND.Text + "',ST_ENSIONE='" + ST_ENSIONE.Text + "' ");
  497. sql.Append("where st_code='" + SU_DEVCODE1.Text + "'");
  498. dh.ExecuteSql(sql.ToString(), "insert");
  499. ////推送人员信息
  500. //string[] emid = dh.GetConfig("sendEmp", "Stencil").ToString().Replace("\n", "#").Split('#');
  501. //for (int i = 0; i < emid.Length; i++)
  502. //{
  503. // string em_name = dh.getFieldDataByCondition("employee", "em_name", "em_id='" + emid[i] + "'").ToString();
  504. // // LogicHandler.SendMessage(emid[i], em_name, "钢网" + SU_DEVCODE1.Text + "已报废" + ",原因" + scrapreason + ",人员" + User.UserName);
  505. //}
  506. form.Close();
  507. SU_DEVCODE1.Text = "";
  508. ST_ENSIONA.Text = "";
  509. ST_ENSIONB.Text = "";
  510. ST_ENSIONC.Text = "";
  511. ST_ENSIOND.Text = "";
  512. ST_ENSIONE.Text = "";
  513. SU_RETURNIFCLEAN.Checked = false;
  514. Scrap.Enabled = false;
  515. MessageBox.Show("报废成功!");
  516. }
  517. private void ma_code_TextKeyDown(object sender, KeyEventArgs e)
  518. {
  519. if (e.KeyCode == Keys.Enter)
  520. {
  521. Confirm.PerformClick();
  522. }
  523. }
  524. }
  525. }