Make_SMTStencil.cs 24 KB

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