4a1e08d4f869c4e5f0fa02c3bd2f07e0cadeeb97.svn-base 31 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674
  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 CoreFS.CA06;
  10. using System.Collections;
  11. namespace Core.LZMes.Client.UIK
  12. {
  13. public partial class UIK030020 : FrmBase
  14. {
  15. public UIK030020()
  16. {
  17. InitializeComponent();
  18. }
  19. public override void ToolBar_Click(object sender, string ToolbarKey)
  20. {
  21. switch (ToolbarKey)
  22. {
  23. case "Query":
  24. this.DoQuery();
  25. break;
  26. case "Insert":
  27. this.DoInsert();
  28. break;
  29. case "Update":
  30. this.DoUpdate();
  31. break;
  32. case "SQQueRen":
  33. this.DoQueRen();
  34. break;
  35. case "SQQuXiao":
  36. this.DoQuXiao();
  37. break;
  38. }
  39. }
  40. private void DoQuery()
  41. {
  42. if (this.ultraCalendarENDTIME.Enabled == false && this.ultraCalendarSTRATTIME.Enabled == false)
  43. {
  44. this.ultraCalendarENDTIME.Text = "";
  45. this.ultraCalendarSTRATTIME.Text = "";
  46. }
  47. try
  48. {
  49. string mc_id = this.ultraTextMC_ID.Text.ToString();
  50. string starttiem = this.ultraCalendarSTRATTIME.Text.ToString();
  51. string endtime = this.ultraCalendarENDTIME.Text.ToString();
  52. bool flag = false;
  53. CoreClientParam ccp = new CoreClientParam();
  54. DataTable dt = new DataTable();
  55. if (mc_id == "" && starttiem == "" && endtime == "" && this.ultraCheckAll.Checked == false)
  56. {
  57. MessageBox.Show("请选择查询条件!");
  58. }
  59. else
  60. {
  61. if (this.ultraCheckAll.Checked)
  62. {
  63. this.ultraCheckAll.Checked = false;
  64. ccp.ServerName = "UIK.UIK03.UIK030020";
  65. ccp.MethodName = "DoQuery";
  66. ccp.ServerParams = new object[] { mc_id, starttiem, endtime, flag };
  67. ccp.SourceDataTable = dt;
  68. this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
  69. this.ultraGrid1.DataSource = dt;
  70. if (dt.Rows.Count <= 0)
  71. {
  72. MessageBox.Show("暂无记录!");
  73. }
  74. this.ultraCalendarENDTIME.Enabled = false;
  75. this.ultraCalendarSTRATTIME.Enabled = false;
  76. return;
  77. }
  78. else
  79. {
  80. flag = true;
  81. if (this.ultraTextMC_ID.Text != "" || this.ultraCheckEditor1.Checked == true)
  82. {
  83. if (this.ultraTextMC_ID.Text == "")
  84. {
  85. this.ultraTextMC_ID.Clear();
  86. this.ultraCheckEditor1.Checked = false;
  87. this.ultraCheckAll.Checked = false;
  88. ccp.ServerName = "UIK.UIK03.UIK030020";
  89. ccp.MethodName = "DoQuery";
  90. ccp.ServerParams = new object[] { mc_id, starttiem, endtime, flag };
  91. ccp.SourceDataTable = dt;
  92. this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
  93. this.ultraGrid1.DataSource = dt;
  94. if (dt.Rows.Count <= 0)
  95. {
  96. MessageBox.Show("该时间内没有入库信息!");
  97. }
  98. this.ultraCalendarENDTIME.Enabled = false;
  99. this.ultraCalendarSTRATTIME.Enabled = false;
  100. return;
  101. }
  102. if (this.ultraCheckEditor1.Checked == false)
  103. {
  104. this.ultraTextMC_ID.Clear();
  105. this.ultraCheckAll.Checked = false;
  106. ccp.ServerName = "UIK.UIK03.UIK030020";
  107. ccp.MethodName = "DoQuery";
  108. ccp.ServerParams = new object[] { mc_id, starttiem, endtime, flag };
  109. ccp.SourceDataTable = dt;
  110. this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
  111. this.ultraGrid1.DataSource = dt;
  112. if (dt.Rows.Count <= 0)
  113. {
  114. MessageBox.Show("该设备编号不存在!");
  115. }
  116. this.ultraCalendarENDTIME.Enabled = false;
  117. this.ultraCalendarSTRATTIME.Enabled = false;
  118. return;
  119. }
  120. if (this.ultraTextMC_ID.Text != "" && this.ultraCheckEditor1.Checked == true)
  121. {
  122. this.ultraTextMC_ID.Clear();
  123. this.ultraCheckEditor1.Checked = false;
  124. this.ultraCheckAll.Checked = false;
  125. ccp.ServerName = "UIK.UIK03.UIK030020";
  126. ccp.MethodName = "DoQuery";
  127. ccp.ServerParams = new object[] { mc_id, starttiem, endtime, flag };
  128. ccp.SourceDataTable = dt;
  129. this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
  130. this.ultraGrid1.DataSource = dt;
  131. if (dt.Rows.Count <= 0)
  132. {
  133. MessageBox.Show("记录不存在,请查证后查询!");
  134. }
  135. this.ultraCalendarENDTIME.Enabled = false;
  136. this.ultraCalendarSTRATTIME.Enabled = false;
  137. return;
  138. }
  139. }
  140. }
  141. }
  142. }
  143. catch (Exception Ex)
  144. {
  145. MessageBox.Show(Ex.ToString());
  146. }
  147. }
  148. private void UIK030020_Load(object sender, EventArgs e)
  149. {
  150. this.ultraCalendarENDTIME.Enabled = false;
  151. this.ultraCalendarSTRATTIME.Enabled = false;
  152. this.ultraCalendarMC_IN_DTIME.Text = "";
  153. this.ultraCalendarMC_USE_TIME.Text = "";
  154. this.ultraCalendarREG_IN_DTIME.Text = "";
  155. }
  156. private void ultraCheckEditor1_CheckedChanged(object sender, EventArgs e)
  157. {
  158. if (this.ultraCheckEditor1.Checked)
  159. {
  160. this.ultraCalendarENDTIME.Enabled = true;
  161. this.ultraCalendarSTRATTIME.Enabled = true;
  162. }
  163. if (!this.ultraCheckEditor1.Checked)
  164. {
  165. this.ultraCalendarENDTIME.Enabled = false;
  166. this.ultraCalendarSTRATTIME.Enabled = false;
  167. this.ultraCalendarSTRATTIME.Text = "";
  168. this.ultraCalendarENDTIME.Text = "";
  169. }
  170. }
  171. private void ultraCheckAll_CheckedChanged(object sender, EventArgs e)
  172. {
  173. try
  174. {
  175. if (this.ultraCheckAll.Checked)
  176. {
  177. this.ultraTextMC_ID.Enabled = false;
  178. this.ultraCalendarSTRATTIME.Enabled = false;
  179. this.ultraCalendarENDTIME.Enabled = false;
  180. }
  181. if (!this.ultraCheckAll.Checked)
  182. {
  183. this.ultraTextMC_ID.Enabled = true;
  184. this.ultraCalendarSTRATTIME.Enabled = true;
  185. this.ultraCalendarENDTIME.Enabled = true;
  186. }
  187. }
  188. catch (Exception Ex)
  189. {
  190. MessageBox.Show(Ex.ToString());
  191. }
  192. }
  193. private void ultraGrid1_CellChange(object sender, Infragistics.Win.UltraWinGrid.CellEventArgs e)
  194. {
  195. if (e.Cell.Column.Key == "SELECT_ITEM")
  196. {
  197. if (e.Cell.Text == "True")
  198. {
  199. string mcid, IREG_IN_DTIME;
  200. ultraTextMCID2.Text = e.Cell.Row.Cells["MC_ID"].Text;
  201. this.ultraTextMCID2.Text = e.Cell.Row.Cells["MC_ID"].Text;
  202. mcid = e.Cell.Row.Cells["MC_ID"].Text;
  203. this.ultraTextMCID2.Enabled = false;
  204. IREG_IN_DTIME = e.Cell.Row.Cells["REG_IN_DTIME"].Text;
  205. DataTable dt = new DataTable();
  206. CoreClientParam ccp = new CoreClientParam();
  207. ccp.ServerName = "UIK.UIK03.UIK030020";
  208. ccp.MethodName = "DoSelect";
  209. ccp.ServerParams = new object[] { IREG_IN_DTIME };
  210. ccp.SourceDataTable = dt;
  211. this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
  212. foreach (DataRow dr in dt.Rows)
  213. {
  214. this.ultraTextMC_NAME.Text = dr["MC_NAME"].ToString();
  215. this.ultraTextMC_MODEL.Text = dr["MC_MODEL"].ToString();
  216. this.ultraTextMC_SPEC.Text = dr["MC_SPEC"].ToString();
  217. this.ultraTextMC_FACTORY.Text = dr["MC_FACTORY"].ToString();
  218. this.ultraCalendarMC_IN_DTIME.Text = dr["MC_IN_DTIME"].ToString();
  219. this.ultraTextMC_PRICE.Text = dr["MC_PRICE"].ToString();
  220. this.ultraTextMC_CARE_SECTOR.Text = dr["MC_CARE_SECTOR"].ToString();
  221. this.ultraTextMC_NOM_CAP.Text = dr["MC_NOM_CAP"].ToString();
  222. this.ultraTextMC_UNIT.Text = dr["MC_UNIT"].ToString();
  223. this.ultraTextMC_TAI.Text = dr["MC_TAI"].ToString();
  224. this.ultraTextMC_ACT.Text = dr["MC_ACT"].ToString();
  225. this.ultraTextMC_MFACTUR_UNITS.Text = dr["MC_MFACTUR_UNITS"].ToString();
  226. this.ultraTextMC_USE_YEAR.Text = dr["MC_USE_YEAR"].ToString();
  227. this.ultraCalendarMC_USE_TIME.Text = dr["MC_USE_TIME"].ToString();
  228. this.ultraTextMC_INSTAL_LOCAL.Text = dr["MC_INSTAL_LOCAL"].ToString();
  229. this.ultraComboMC_REG_OUT_STAT.Text = dr["MC_REG_OUT_STAT"].ToString();
  230. this.ultraComboMC_STAT.Text = dr["MC_STAT"].ToString();
  231. this.ultraCalendarREG_IN_DTIME.Text = dr["REG_OUT_DTIME"].ToString();
  232. this.ultraTextREG_IN_ID.Text = dr["REG_OUT_ID"].ToString();
  233. this.ultraTextMAIN_MC_NAME.Text = dr["MAIN_MC_NAME"].ToString();
  234. }
  235. }
  236. else
  237. {
  238. this.ultraTextMCID2.Enabled = true;
  239. this.ultraTextMCID2.Clear();
  240. this.ultraTextMC_NAME.Clear();
  241. this.ultraTextMC_MODEL.Clear();
  242. this.ultraTextMC_SPEC.Clear();
  243. this.ultraTextMC_FACTORY.Clear();
  244. this.ultraCalendarMC_IN_DTIME.Text = "";
  245. this.ultraTextMC_PRICE.Clear();
  246. this.ultraTextMC_CARE_SECTOR.Clear();
  247. this.ultraTextMC_NOM_CAP.Clear();
  248. this.ultraTextMC_UNIT.Clear();
  249. this.ultraTextMC_TAI.Clear();
  250. this.ultraTextMC_ACT.Clear();
  251. this.ultraTextMC_MFACTUR_UNITS.Clear();
  252. this.ultraTextMC_USE_YEAR.Clear();
  253. this.ultraCalendarMC_USE_TIME.Text = "";
  254. this.ultraTextMC_INSTAL_LOCAL.Clear();
  255. this.ultraComboMC_REG_OUT_STAT.Clear();
  256. this.ultraComboMC_STAT.Clear();
  257. this.ultraCalendarREG_IN_DTIME.Text = "";
  258. this.ultraTextREG_IN_ID.Clear();
  259. this.ultraTextMAIN_MC_NAME.Clear();
  260. }
  261. }
  262. }
  263. private void DoUpdate()
  264. {
  265. if (MessageBox.Show("您确认要修改?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.Yes)
  266. {
  267. try
  268. {
  269. Infragistics.Win.UltraWinGrid.UltraGridRow ugr = this.ultraGrid1.ActiveRow;
  270. if (ugr.Cells["SELECT_ITEM"].Text.ToString() == "True")
  271. {
  272. string mcid, IREG_IN_DTIME, IMC_NAME, IMC_MODEL, IMC_SPEC, IMC_FACTORY, IMC_IN_DTIME, IMC_PRICE, IMC_CARE_SECTOR, IMC_NOM_CAP, IMC_UNIT, IMC_TAI, IMC_ACT, IMC_MFACTUR_UNITS, IMC_USE_YEAR, IMC_USE_TIME, IMC_INSTAL_LOCAL, IMC_REG_OUT_STAT, IMC_STAT, IREG_OUT_DTIME, IREG_OUT_ID, IMAIN_MC_NAME;
  273. mcid = ugr.Cells["MC_ID"].Value.ToString();
  274. this.ultraTextMCID2.Enabled = false;
  275. IREG_IN_DTIME = ugr.Cells["REG_IN_DTIME"].Value.ToString();
  276. IMC_NAME = this.ultraTextMC_NAME.Text;
  277. IMC_MODEL = this.ultraTextMC_MODEL.Text;
  278. IMC_SPEC = this.ultraTextMC_SPEC.Text;
  279. IMC_FACTORY = this.ultraTextMC_FACTORY.Text;
  280. IMC_IN_DTIME = this.ultraCalendarMC_IN_DTIME.Text;
  281. IMC_PRICE = this.ultraTextMC_PRICE.Text;
  282. IMC_CARE_SECTOR = this.ultraTextMC_CARE_SECTOR.Text;
  283. IMC_NOM_CAP = this.ultraTextMC_NOM_CAP.Text;
  284. IMC_UNIT = this.ultraTextMC_UNIT.Text;
  285. IMC_TAI = this.ultraTextMC_TAI.Text;
  286. IMC_ACT = this.ultraTextMC_ACT.Text;
  287. IMC_MFACTUR_UNITS = this.ultraTextMC_MFACTUR_UNITS.Text;
  288. IMC_USE_YEAR = this.ultraTextMC_USE_YEAR.Text;
  289. IMC_USE_TIME = this.ultraCalendarMC_USE_TIME.Text;
  290. IMC_INSTAL_LOCAL = this.ultraTextMC_INSTAL_LOCAL.Text;
  291. IMC_REG_OUT_STAT = this.ultraComboMC_REG_OUT_STAT.Text;
  292. IMC_STAT = this.ultraComboMC_STAT.Text;
  293. IREG_OUT_DTIME = this.ultraCalendarREG_IN_DTIME.Text;
  294. IREG_OUT_ID = this.ultraTextREG_IN_ID.Text;
  295. IMAIN_MC_NAME = this.ultraTextMAIN_MC_NAME.Text;
  296. CoreClientParam ccp2 = new CoreClientParam();
  297. ccp2.ServerName = "UIK.UIK03.UIK030020";
  298. ccp2.MethodName = "DoUpdate";
  299. ccp2.ServerParams = new object[] { IMC_NAME, IMC_MODEL, IMC_SPEC, IMC_FACTORY, IMC_IN_DTIME, IMC_PRICE, IMC_CARE_SECTOR, IMC_NOM_CAP, IMC_UNIT, IMC_TAI, IMC_ACT, IMC_MFACTUR_UNITS, IMC_USE_YEAR, IMC_USE_TIME, IMC_INSTAL_LOCAL, IMC_REG_OUT_STAT, IMC_STAT, IREG_OUT_DTIME, IREG_OUT_ID,IMAIN_MC_NAME, IREG_IN_DTIME };
  300. ccp2 = this.ExecuteNonQuery(ccp2, CoreInvokeType.Internal);
  301. if (0 != ccp2.ReturnCode)
  302. {
  303. MessageBox.Show("修改失败!");
  304. }
  305. else
  306. {
  307. MessageBox.Show("修改成功!");
  308. this.ultraTextMCID2.Enabled = true;
  309. this.ultraTextMCID2.Clear();
  310. this.ultraTextMC_NAME.Clear();
  311. this.ultraTextMC_MODEL.Clear();
  312. this.ultraTextMC_SPEC.Clear();
  313. this.ultraTextMC_FACTORY.Clear();
  314. this.ultraCalendarMC_IN_DTIME.Text = "";
  315. this.ultraTextMC_PRICE.Clear();
  316. this.ultraTextMC_CARE_SECTOR.Clear();
  317. this.ultraTextMC_NOM_CAP.Clear();
  318. this.ultraTextMC_UNIT.Clear();
  319. this.ultraTextMC_TAI.Clear();
  320. this.ultraTextMC_ACT.Clear();
  321. this.ultraTextMC_MFACTUR_UNITS.Clear();
  322. this.ultraTextMC_USE_YEAR.Clear();
  323. this.ultraCalendarMC_USE_TIME.Text = "";
  324. this.ultraTextMC_INSTAL_LOCAL.Clear();
  325. this.ultraComboMC_REG_OUT_STAT.Clear();
  326. this.ultraComboMC_STAT.Clear();
  327. this.ultraCalendarREG_IN_DTIME.Text = "";
  328. this.ultraTextREG_IN_ID.Clear();
  329. this.ultraTextMAIN_MC_NAME.Clear();
  330. }
  331. }
  332. else
  333. {
  334. MessageBox.Show("请选择修改行!");
  335. }
  336. }
  337. catch (Exception Ex)
  338. {
  339. MessageBox.Show(Ex.ToString());
  340. }
  341. }
  342. }
  343. private void DoInsert()
  344. {
  345. if (MessageBox.Show("您确认要添加信息吗?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.Yes)
  346. {
  347. string mcid, IMC_NAME, IMC_MODEL, IMC_SPEC, IMC_FACTORY, IMC_IN_DTIME, IMC_PRICE, IMC_CARE_SECTOR, IMC_NOM_CAP, IMC_UNIT, IMC_TAI, IMC_ACT, IMC_MFACTUR_UNITS, IMC_USE_YEAR, IMC_USE_TIME, IMC_INSTAL_LOCAL, IMC_REG_OUT_STAT, IMC_STAT, IREG_OUT_DTIME, IREG_OUT_ID, IMAIN_MC_NAME, IREG_IN_DTIME;
  348. mcid = this.ultraTextMCID2.Text;
  349. IMC_NAME = this.ultraTextMC_NAME.Text;
  350. IMC_MODEL = this.ultraTextMC_MODEL.Text;
  351. IMC_SPEC = this.ultraTextMC_SPEC.Text;
  352. IMC_FACTORY = this.ultraTextMC_FACTORY.Text;
  353. IMC_IN_DTIME = this.ultraCalendarMC_IN_DTIME.Text;
  354. IMC_PRICE = this.ultraTextMC_PRICE.Text;
  355. IMC_CARE_SECTOR = this.ultraTextMC_CARE_SECTOR.Text;
  356. IMC_NOM_CAP = this.ultraTextMC_NOM_CAP.Text;
  357. IMC_UNIT = this.ultraTextMC_UNIT.Text;
  358. IMC_TAI = this.ultraTextMC_TAI.Text;
  359. IMC_ACT = this.ultraTextMC_ACT.Text;
  360. IMC_MFACTUR_UNITS = this.ultraTextMC_MFACTUR_UNITS.Text;
  361. IMC_USE_YEAR = this.ultraTextMC_USE_YEAR.Text;
  362. IMC_USE_TIME = this.ultraCalendarMC_USE_TIME.Text;
  363. IMC_INSTAL_LOCAL = this.ultraTextMC_INSTAL_LOCAL.Text;
  364. IMC_REG_OUT_STAT = this.ultraComboMC_REG_OUT_STAT.Text;
  365. IMC_STAT = this.ultraComboMC_STAT.Text;
  366. IREG_OUT_DTIME = this.ultraCalendarREG_IN_DTIME.Text;
  367. IREG_OUT_ID = this.ultraTextREG_IN_ID.Text;
  368. IMAIN_MC_NAME = this.ultraTextMAIN_MC_NAME.Text;
  369. IREG_IN_DTIME = DateTime.Now.ToString();
  370. DataTable dt = new DataTable();
  371. CoreClientParam ccp = new CoreClientParam();
  372. ccp.ServerName = "UIK.UIK03.UIK030020";
  373. ccp.MethodName = "DoSelect";
  374. ccp.ServerParams = new object[] { IREG_IN_DTIME };
  375. ccp.SourceDataTable = dt;
  376. this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
  377. if (dt.Rows.Count > 0)
  378. {
  379. MessageBox.Show("该编设备号已经存在,请重新输入");
  380. }
  381. else
  382. {
  383. CoreClientParam ccp2 = new CoreClientParam();
  384. ccp2.ServerName = "UIK.UIK03.UIK030020";
  385. ccp2.MethodName = "DoInsert";
  386. ccp2.ServerParams = new object[] { mcid, IMC_NAME, IMC_MODEL, IMC_SPEC, IMC_FACTORY, IMC_IN_DTIME, IMC_PRICE, IMC_CARE_SECTOR, IMC_NOM_CAP, IMC_UNIT, IMC_TAI, IMC_ACT, IMC_MFACTUR_UNITS, IMC_USE_YEAR, IMC_USE_TIME, IMC_INSTAL_LOCAL, IMC_REG_OUT_STAT, IMC_STAT, IREG_OUT_DTIME, IREG_OUT_ID, IMAIN_MC_NAME, IREG_IN_DTIME };
  387. ccp2 = this.ExecuteNonQuery(ccp2, CoreInvokeType.Internal);
  388. if (0 != ccp2.ReturnCode)
  389. {
  390. MessageBox.Show("添加失败!");
  391. }
  392. else
  393. {
  394. MessageBox.Show("添加成功!");
  395. this.ultraTextMCID2.Enabled = true;
  396. this.ultraTextMCID2.Clear();
  397. this.ultraTextMC_NAME.Clear();
  398. this.ultraTextMC_MODEL.Clear();
  399. this.ultraTextMC_SPEC.Clear();
  400. this.ultraTextMC_FACTORY.Clear();
  401. this.ultraCalendarMC_IN_DTIME.Text = "";
  402. this.ultraTextMC_PRICE.Clear();
  403. this.ultraTextMC_CARE_SECTOR.Clear();
  404. this.ultraTextMC_NOM_CAP.Clear();
  405. this.ultraTextMC_UNIT.Clear();
  406. this.ultraTextMC_TAI.Clear();
  407. this.ultraTextMC_ACT.Clear();
  408. this.ultraTextMC_MFACTUR_UNITS.Clear();
  409. this.ultraTextMC_USE_YEAR.Clear();
  410. this.ultraCalendarMC_USE_TIME.Text = "";
  411. this.ultraTextMC_INSTAL_LOCAL.Clear();
  412. this.ultraComboMC_REG_OUT_STAT.Clear();
  413. this.ultraComboMC_STAT.Clear();
  414. this.ultraCalendarREG_IN_DTIME.Text = "";
  415. this.ultraTextREG_IN_ID.Clear();
  416. this.ultraTextMAIN_MC_NAME.Clear();
  417. }
  418. }
  419. }
  420. }
  421. private void ultraButtonShengQing_Click(object sender, EventArgs e)
  422. {
  423. try
  424. {
  425. Infragistics.Win.UltraWinGrid.UltraGridRow ugr = this.ultraGrid1.ActiveRow;
  426. if (ugr.Cells["SELECT_ITEM"].Text.ToString() == "True")
  427. {
  428. string IREG_IN_DTIME, IMC_REG_OUT_STAT = "", IMC_PROCESS_REG;
  429. IREG_IN_DTIME = ugr.Cells["REG_IN_DTIME"].Value.ToString();
  430. DataTable dt = new DataTable();
  431. CoreClientParam ccp = new CoreClientParam();
  432. ccp.ServerName = "UIK.UIK03.UIK030020";
  433. ccp.MethodName = "DoSelect";
  434. ccp.ServerParams = new object[] { IREG_IN_DTIME };
  435. ccp.SourceDataTable = dt;
  436. this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
  437. foreach (DataRow dr in dt.Rows)
  438. {
  439. IMC_REG_OUT_STAT = dr["MC_REG_OUT_STAT"].ToString();
  440. }
  441. if (IMC_REG_OUT_STAT == "已报废")
  442. {
  443. MessageBox.Show("设备已报废,无法申请报废!");
  444. }
  445. else
  446. {
  447. if (MessageBox.Show("您确认要申请报废吗?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.Yes)
  448. {
  449. IMC_PROCESS_REG = "申请报废中";
  450. CoreClientParam ccp3 = new CoreClientParam();
  451. ccp3.ServerName = "UIK.UIK03.UIK030020";
  452. ccp3.MethodName = "DoUpdateMC_REG_OUT_STAT";
  453. ccp3.ServerParams = new object[] { IMC_PROCESS_REG, IREG_IN_DTIME };
  454. ccp3 = this.ExecuteNonQuery(ccp3, CoreInvokeType.Internal);
  455. if (0 != ccp3.ReturnCode)
  456. {
  457. MessageBox.Show("申请失败!");
  458. }
  459. else
  460. {
  461. MessageBox.Show("申请成功,请等待处理!");
  462. }
  463. }
  464. }
  465. }
  466. else
  467. {
  468. MessageBox.Show("请选择申请报废行!");
  469. }
  470. }
  471. catch (Exception Ex)
  472. {
  473. MessageBox.Show(Ex.ToString());
  474. }
  475. }
  476. private void DoQueRen()
  477. {
  478. try
  479. {
  480. Infragistics.Win.UltraWinGrid.UltraGridRow ugr = this.ultraGrid1.ActiveRow;
  481. if (ugr.Cells["SELECT_ITEM"].Text.ToString() == "True")
  482. {
  483. string IREG_IN_DTIME, IMC_PROCESS_REG = "", IMC_REG_OUT_STAT, IMC_STAT, IREG_OUT_DTIME;
  484. IREG_IN_DTIME = ugr.Cells["REG_IN_DTIME"].Value.ToString();
  485. IREG_OUT_DTIME = System.DateTime.Now.ToString();
  486. DataTable dt = new DataTable();
  487. CoreClientParam ccp = new CoreClientParam();
  488. ccp.ServerName = "UIK.UIK03.UIK030020";
  489. ccp.MethodName = "DoSelect";
  490. ccp.ServerParams = new object[] { IREG_IN_DTIME };
  491. ccp.SourceDataTable = dt;
  492. this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
  493. foreach (DataRow dr in dt.Rows)
  494. {
  495. IMC_PROCESS_REG = dr["MC_PROCESS_REG"].ToString();
  496. }
  497. if (IMC_PROCESS_REG != "申请报废中")
  498. {
  499. MessageBox.Show("该项没有报废申请,请查证后操作");
  500. }
  501. if (IMC_PROCESS_REG == "申请报废中")
  502. {
  503. if (MessageBox.Show("您确认要申请报废吗?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.Yes)
  504. {
  505. IMC_REG_OUT_STAT = "已报废";
  506. IMC_STAT = "已报废";
  507. IMC_PROCESS_REG = "已处理";
  508. CoreClientParam ccp2 = new CoreClientParam();
  509. ccp2.ServerName = "UIK.UIK03.UIK030020";
  510. ccp2.MethodName = "DoUpdateMC_PROCESS_REG";
  511. ccp2.ServerParams = new object[] { IMC_REG_OUT_STAT, IMC_STAT, IMC_PROCESS_REG, IREG_IN_DTIME };
  512. ccp2 = this.ExecuteNonQuery(ccp2, CoreInvokeType.Internal);
  513. if (0 != ccp2.ReturnCode)
  514. {
  515. MessageBox.Show("处理失败!");
  516. }
  517. else
  518. {
  519. CoreClientParam ccp3 = new CoreClientParam();
  520. ccp3.ServerName = "UIK.UIK03.UIK030020";
  521. ccp3.MethodName = "DoUpdateREG_OUT_DTIME";
  522. ccp3.ServerParams = new object[] { IREG_OUT_DTIME, IREG_IN_DTIME };
  523. ccp2 = this.ExecuteNonQuery(ccp3, CoreInvokeType.Internal);
  524. if (0 != ccp3.ReturnCode)
  525. {
  526. MessageBox.Show("处理失败!");
  527. }
  528. else
  529. {
  530. MessageBox.Show("处理成功!");
  531. }
  532. }
  533. }
  534. }
  535. }
  536. else
  537. {
  538. MessageBox.Show("请选择处理申请报废行!");
  539. }
  540. }
  541. catch (Exception Ex)
  542. {
  543. MessageBox.Show(Ex.ToString());
  544. }
  545. }
  546. private void DoQuXiao()
  547. {
  548. try
  549. {
  550. Infragistics.Win.UltraWinGrid.UltraGridRow ugr = this.ultraGrid1.ActiveRow;
  551. if (ugr.Cells["SELECT_ITEM"].Text.ToString() == "True")
  552. {
  553. //string mcid, IMC_PROCESS_REG = "", IMC_REG_OUT_STAT, IMC_STAT;
  554. string IREG_IN_DTIME, IMC_PROCESS_REG = "", IMC_REG_OUT_STAT;
  555. IREG_IN_DTIME = ugr.Cells["REG_IN_DTIME"].Value.ToString();
  556. DataTable dt = new DataTable();
  557. CoreClientParam ccp = new CoreClientParam();
  558. ccp.ServerName = "UIK.UIK03.UIK030020";
  559. ccp.MethodName = "DoSelect";
  560. ccp.ServerParams = new object[] { IREG_IN_DTIME };
  561. ccp.SourceDataTable = dt;
  562. this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
  563. foreach (DataRow dr in dt.Rows)
  564. {
  565. IMC_PROCESS_REG = dr["MC_PROCESS_REG"].ToString();
  566. }
  567. if (IMC_PROCESS_REG != "申请报废中")
  568. {
  569. MessageBox.Show("该项没有报废申请,请查证后操作");
  570. }
  571. if (IMC_PROCESS_REG == "申请报废中")
  572. {
  573. if (MessageBox.Show("您确认要取消报废申请吗?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.Yes)
  574. {
  575. IMC_REG_OUT_STAT = "未报废";
  576. IMC_PROCESS_REG = "等待";
  577. CoreClientParam ccp2 = new CoreClientParam();
  578. ccp2.ServerName = "UIK.UIK03.UIK030020";
  579. ccp2.MethodName = "DoUpdateQUXIAO";
  580. ccp2.ServerParams = new object[] { IMC_REG_OUT_STAT, IMC_PROCESS_REG, IREG_IN_DTIME };
  581. ccp2 = this.ExecuteNonQuery(ccp2, CoreInvokeType.Internal);
  582. if (0 != ccp2.ReturnCode)
  583. {
  584. MessageBox.Show("取消失败!");
  585. }
  586. else
  587. {
  588. MessageBox.Show("取消成功!");
  589. }
  590. }
  591. }
  592. }
  593. else
  594. {
  595. MessageBox.Show("请选择处理申请报废行!");
  596. }
  597. }
  598. catch (Exception Ex)
  599. {
  600. MessageBox.Show(Ex.ToString());
  601. }
  602. }
  603. }
  604. }