FrmPurOilCardMaintain.cs 33 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918
  1. using System;
  2. using System.Collections;
  3. using System.Collections.Generic;
  4. using System.ComponentModel;
  5. using System.Data;
  6. using System.Drawing;
  7. using System.Linq;
  8. using System.Text;
  9. using System.Windows.Forms;
  10. using com.hnshituo.pur.vo;
  11. using Core.Mes.Client.Comm.Control;
  12. using Core.Mes.Client.Comm.Tool;
  13. using Pur.Entity;
  14. using Pur.PublicTools;
  15. namespace Pur.require_plan
  16. {
  17. public partial class FrmPurOilCardMaintain : FrmPmsBase
  18. {
  19. public FrmPurOilCardMaintain()
  20. {
  21. InitializeComponent();
  22. this.IsLoadUserView = true;
  23. }
  24. private void FrmPurOilCardMaintain_Load(object sender, EventArgs e)
  25. {
  26. GridHelper.SetExcludeColumnsActive(ultraGrid1.DisplayLayout.Bands[0], new string[] {});
  27. GridHelper.SetExcludeColumnsActive(ultraGrid2.DisplayLayout.Bands[0], new string[] {});
  28. ultraExpandableGroupBox1.Expanded = false;
  29. ultraExpandableGroupBox2.Expanded = false;
  30. txt_type1_M.SelectedIndex = 0;
  31. ck_ctime.Checked = true;
  32. txtCreateTimeStart.Value = DateTime.Now.AddMonths(-2);
  33. txtCreateTimeEnd.Value = DateTime.Now.AddDays(2);
  34. txtCreateTimeStart.Enabled = true;
  35. txtCreateTimeEnd.Enabled = true;
  36. txt_status.SelectedIndex = 0;
  37. ultraExpandableGroupBox1.Expanded = true;
  38. ultraExpandableGroupBox4.Expanded = false;
  39. ultraExpandableGroupBox3.Expanded = false;
  40. ultraTabControl1.SelectedTab=ultraTabControl1.Tabs[0];
  41. ck_is_all.Checked = false;
  42. }
  43. private void FrmPurOilCardMaintain_Shown(object sender, EventArgs e)
  44. {
  45. this.ToolBarItemEnable(this, "Query", true);
  46. this.ToolBarItemEnable(this, "Add", true);
  47. this.ToolBarItemEnable(this, "Delete", true);
  48. this.ToolBarItemEnable(this, "Update", true);
  49. this.ToolBarItemEnable(this, "doExcel", true);
  50. this.ToolBarItemEnable(this, "Close", true);
  51. }
  52. #region toolbar工具栏
  53. //菜单按钮事件
  54. public override void ToolBar_Click(object sender, string ToolbarKey)
  55. {
  56. switch (ToolbarKey)
  57. {
  58. case "Query":
  59. doQuery("");
  60. break;
  61. case "Add"://新增
  62. doAdd();
  63. break;
  64. case "Delete"://删除
  65. doDelete();
  66. break;
  67. case "Update"://更新
  68. doUpdate();
  69. break;
  70. case "doExcel"://导出Excel
  71. doExcel();
  72. break;
  73. case "Close":
  74. if (MessageUtil.ShowYesNoAndQuestion("是否确认关闭页面?") == DialogResult.Yes)
  75. {
  76. this.Close();
  77. }
  78. break;
  79. }
  80. }
  81. /// <summary>
  82. /// 查询
  83. /// </summary>
  84. private void doQuery(string Mid)
  85. {
  86. if (ultraTabControl1.SelectedTab == ultraTabControl1.Tabs[0])
  87. {
  88. card.Clear();
  89. OilCardM cardM = new OilCardM();
  90. cardM.OilCardMId = txt_Card_No_M.Text.Trim();
  91. cardM.UserOrgName = txt_org_name.Text.Trim();
  92. if(txt_type1_M.SelectedIndex!=-1)
  93. {
  94. cardM.Type = txt_type1_M.Value.ToString().Trim();
  95. }
  96. cardM.DeleteUserid = txt_cardMD_no.Text.Trim();
  97. cardM.UpdateUserid = txt_User_name1.Text.Trim();
  98. DataTable dt = this.execute<DataTable>("com.hnshituo.pur.requireplan.service.OilCardMService", "find_CardM", new object[] { cardM });
  99. if (dt != null)
  100. {
  101. GridHelper.CopyDataToDatatable(ref dt, ref dataTable1, true);
  102. GridHelper.RefreshAndAutoSize(ultraGrid1);
  103. if (String.IsNullOrEmpty(Mid))
  104. {
  105. publicPms.doActiveSelRow(ultraGrid1, "OILCARDMID", Mid);
  106. }
  107. }
  108. }
  109. else
  110. {
  111. changeRecord.Clear();
  112. OilCardChange change = new OilCardChange();
  113. change.CardId = txt_card_change_d.Text;
  114. if (ck_ctime.Checked && String.IsNullOrEmpty(txtCreateTimeStart.Text))
  115. {
  116. change.CreateTime = Convert.ToDateTime(txtCreateTimeStart.Value);
  117. }
  118. if (ck_ctime.Checked && String.IsNullOrEmpty(txtCreateTimeEnd.Text))
  119. {
  120. change.DeleteTime = Convert.ToDateTime(txtCreateTimeEnd.Value);
  121. }
  122. DataTable dt = this.execute<DataTable>("com.hnshituo.pur.requireplan.service.OilCardChangeService", "find_Change", new object[] { change });
  123. if (dt != null)
  124. {
  125. GridHelper.CopyDataToDatatable(ref dt, ref dataTable3, true);
  126. GridHelper.RefreshAndAutoSize(ultraGrid4);
  127. }
  128. }
  129. }
  130. /// <summary>
  131. /// 新增
  132. /// </summary>
  133. private void doAdd()
  134. {
  135. if (testMInput() == false)
  136. {
  137. return;
  138. }
  139. String OilCardMNo = txt_card_m_add.Text.Trim();
  140. String OrgName = txt_org_add.Text.Trim();
  141. String strType1 = txt_type1_add.Value.ToString().Trim();
  142. OilCardM cardM = new OilCardM();
  143. cardM.OilCardMId = OilCardMNo;
  144. cardM.Validflag = "1";
  145. cardM.UserOrgName = OrgName;
  146. cardM.CreateName = UserInfo.GetUserName();
  147. cardM.CreateUserid = UserInfo.GetUserName();
  148. cardM.CreateTime = DateTime.Now;
  149. cardM.Type = strType1;
  150. CoreResult crt = this.execute<CoreResult>("com.hnshituo.pur.requireplan.service.OilCardMService", "insert_CardM", new object[] { cardM });
  151. if (crt.Resultcode != 0)
  152. {
  153. MessageUtil.ShowTips("新增失败:" + crt.Resultmsg.ToString());
  154. }
  155. else
  156. {
  157. MessageUtil.ShowTips("新增成功,新增油卡:"+OilCardMNo);
  158. doQuery(OilCardMNo);
  159. }
  160. }
  161. /// <summary>
  162. /// 删除
  163. /// </summary>
  164. private void doDelete()
  165. {
  166. if (ultraGrid1.ActiveRow == null)
  167. {
  168. MessageUtil.ShowTips("请选择主卡行信息");
  169. return;
  170. }
  171. String strMid = ultraGrid1.ActiveRow.GetCellValue("id").ToString().Trim();
  172. if (String.IsNullOrEmpty(strMid))
  173. {
  174. MessageUtil.ShowTips("主卡编号为空");
  175. return;
  176. }
  177. OilCardM cardM = new OilCardM();
  178. cardM.Id = strMid;
  179. cardM.DeleteName = UserInfo.GetUserName();
  180. cardM.DeleteUserid = UserInfo.GetUserName();
  181. cardM.DeleteTime = DateTime.Now;
  182. cardM.Validflag = "1";
  183. if (testMStatus(strMid) == false)
  184. {
  185. return;
  186. }
  187. OilCardD cardD = new OilCardD();
  188. cardD.MId = strMid;
  189. cardM.Validflag = "1";
  190. int count = this.execute<int>("com.hnshituo.pur.requireplan.service.OilCardDService", "count", new object[] { cardD });
  191. if (count > 0)
  192. {
  193. if (MessageUtil.ShowYesNoAndQuestion("该主卡已绑定副卡,若删除,则主卡和该主卡绑定的副卡将一起删除?") != DialogResult.Yes)
  194. {
  195. return;
  196. }
  197. }
  198. else
  199. {
  200. if (MessageUtil.ShowYesNoAndQuestion("确定删除编号为:" + strMid + "的主卡?") != DialogResult.Yes)
  201. {
  202. return;
  203. }
  204. }
  205. CoreResult crt = this.execute<CoreResult>("com.hnshituo.pur.requireplan.service.OilCardMService", "delete_CardM", new object[] { cardM });
  206. if (crt.Resultcode != 0)
  207. {
  208. MessageUtil.ShowTips("新增失败:" + crt.Resultmsg.ToString());
  209. }
  210. else
  211. {
  212. MessageUtil.ShowTips("操作成功");
  213. doQuery("");
  214. }
  215. }
  216. /// <summary>
  217. /// 更新
  218. /// </summary>
  219. private void doUpdate()
  220. {
  221. if (ultraGrid1.ActiveRow == null)
  222. {
  223. MessageUtil.ShowTips("请选择主卡");
  224. return;
  225. }
  226. String strMid = ultraGrid1.ActiveRow.GetCellValue("id").ToString().Trim();
  227. if (String.IsNullOrEmpty(strMid))
  228. {
  229. MessageUtil.ShowTips("主卡编号为空");
  230. return;
  231. }
  232. if (testMStatus(strMid) == false)
  233. {
  234. return;
  235. }
  236. if (testMInput() == false)
  237. {
  238. return;
  239. }
  240. String OilCardMNoNew = txt_card_m_add.Text.Trim();
  241. String OrgNameNew = txt_org_add.Text.Trim();
  242. String strType1 = txt_type1_add.Value.ToString().Trim();
  243. OilCardM cardM = new OilCardM();
  244. cardM.Id = strMid;
  245. cardM.OilCardMId = OilCardMNoNew;
  246. cardM.UserOrgName = OrgNameNew;
  247. cardM.UpdateName = UserInfo.GetUserName();
  248. cardM.UpdateUserid = UserInfo.GetUserName();
  249. cardM.UpdateTime = DateTime.Now;
  250. cardM.Validflag = "1";
  251. cardM.Type = strType1;
  252. if (MessageUtil.ShowYesNoAndQuestion("确定修改主卡:" + strMid + "?") != DialogResult.Yes)
  253. {
  254. return;
  255. }
  256. CoreResult crt = this.execute<CoreResult>("com.hnshituo.pur.requireplan.service.OilCardMService", "update_CardM", new object[] { cardM });
  257. if (crt.Resultcode != 0)
  258. {
  259. MessageUtil.ShowTips("修改失败:" + crt.Resultmsg.ToString());
  260. }
  261. else
  262. {
  263. MessageUtil.ShowTips("修改成功");
  264. doQuery(OilCardMNoNew);
  265. }
  266. }
  267. /// <summary>
  268. /// 导出Excel
  269. /// </summary>
  270. private void doExcel()
  271. {
  272. try
  273. {
  274. this.Cursor = Cursors.Default;
  275. if (ultraTabControl1.SelectedTab == ultraTabControl1.Tabs[0])
  276. {
  277. if (ultraGrid1.ActiveRow == null)
  278. {
  279. MessageUtil.ShowTips("请选择需导出油卡!");
  280. return;
  281. }
  282. ArrayList alUltraGrid = new ArrayList();
  283. alUltraGrid.Add(ultraGrid1);
  284. alUltraGrid.Add(ultraGrid2);
  285. ArrayList alSheeft = new ArrayList();
  286. alSheeft.Add("主油卡");
  287. alSheeft.Add("副油卡");
  288. GridHelper.ulGridToExcel(alUltraGrid, alSheeft, "油卡明细表");
  289. }
  290. else
  291. {
  292. if (ultraGrid4.Rows.Count<=0)
  293. {
  294. MessageUtil.ShowTips("无可导出变更明细!");
  295. return;
  296. }
  297. ArrayList alUltraGrid = new ArrayList();
  298. alUltraGrid.Add(ultraGrid4);
  299. ArrayList alSheeft = new ArrayList();
  300. alSheeft.Add("变更记录");
  301. GridHelper.ulGridToExcel(alUltraGrid, alSheeft, "变更记录");
  302. }
  303. }
  304. catch (Exception e)
  305. {
  306. MessageUtil.ShowTips("导出失败" + e.Message);
  307. }
  308. finally
  309. {
  310. this.Cursor = Cursors.Default;
  311. }
  312. }
  313. #endregion
  314. #region 行按钮
  315. private void ultraToolbarsManager1_ToolClick(object sender, Infragistics.Win.UltraWinToolbars.ToolClickEventArgs e)
  316. {
  317. switch (e.Tool.Key)
  318. {
  319. case "doEdit": // ButtonTool
  320. doEditD();
  321. break;
  322. case "doAdd": // ButtonTool
  323. doAddD();
  324. break;
  325. case "doSuspend": // ButtonTool
  326. doSuspendD();
  327. break;
  328. case "cancelSuspend":// ButtonTool
  329. cancelSuspendD();
  330. break;
  331. case "doCancel": // ButtonTool
  332. doCancelD();
  333. break;
  334. }
  335. }
  336. /// <summary>
  337. /// 查询
  338. /// </summary>
  339. /// <param name="sender"></param>
  340. /// <param name="e"></param>
  341. private void btn_query_d_Click(object sender, EventArgs e)
  342. {
  343. doQuery_d("");
  344. }
  345. /// <summary>
  346. /// 注销
  347. /// </summary>
  348. /// <param name="sender"></param>
  349. /// <param name="e"></param>
  350. private void doCancelD()
  351. {
  352. if (ultraGrid2.ActiveRow == null)
  353. {
  354. MessageUtil.ShowTips("请选择副卡行信息");
  355. return;
  356. }
  357. String strDid = ultraGrid2.ActiveRow.GetCellValue("id").ToString().Trim();
  358. String strCARDNo = ultraGrid2.ActiveRow.GetCellValue("OILCARDID").ToString().Trim();
  359. if (String.IsNullOrEmpty(strDid))
  360. {
  361. MessageUtil.ShowTips("副卡编号为空");
  362. return;
  363. }
  364. OilCardD a = new OilCardD();
  365. if (testDStatus(strDid, out a, 4) == false)
  366. {
  367. return;
  368. }
  369. if (MessageUtil.ShowYesNoAndQuestion("确定注销副卡:" + strCARDNo + "?") != DialogResult.Yes)
  370. {
  371. return;
  372. }
  373. a.UpdateName = UserInfo.GetUserName();
  374. a.UpdateUserid = UserInfo.GetUserID();
  375. a.UpdateTime = DateTime.Now;
  376. a.Status = "3";
  377. CoreResult crt = this.execute<CoreResult>("com.hnshituo.pur.requireplan.service.OilCardDService", "suspend_CardD", new object[] { a });
  378. if (crt.Resultcode != 0)
  379. {
  380. MessageUtil.ShowTips("注销失败:" + crt.Resultmsg);
  381. }
  382. else
  383. {
  384. MessageUtil.ShowTips("注销成功");
  385. doQuery_d(strDid);
  386. }
  387. }
  388. /// <summary>
  389. /// 取消暂停
  390. /// </summary>
  391. /// <param name="sender"></param>
  392. /// <param name="e"></param>
  393. private void cancelSuspendD()
  394. {
  395. if (ultraGrid2.ActiveRow == null)
  396. {
  397. MessageUtil.ShowTips("请选择副卡行信息");
  398. return;
  399. }
  400. String strDid = ultraGrid2.ActiveRow.GetCellValue("id").ToString().Trim();
  401. String strCARDNo = ultraGrid2.ActiveRow.GetCellValue("OILCARDID").ToString().Trim();
  402. if (String.IsNullOrEmpty(strDid))
  403. {
  404. MessageUtil.ShowTips("副卡编号为空");
  405. return;
  406. }
  407. OilCardD a = new OilCardD();
  408. if (testDStatus(strDid, out a, 3) == false)
  409. {
  410. return;
  411. }
  412. if (MessageUtil.ShowYesNoAndQuestion("确定取消暂停副卡:" + strCARDNo + "?") != DialogResult.Yes)
  413. {
  414. return;
  415. }
  416. a.UpdateName = UserInfo.GetUserName();
  417. a.UpdateUserid = UserInfo.GetUserID();
  418. a.UpdateTime = DateTime.Now;
  419. a.Status = "1";
  420. CoreResult crt = this.execute<CoreResult>("com.hnshituo.pur.requireplan.service.OilCardDService", "suspend_CardD", new object[] { a });
  421. if (crt.Resultcode != 0)
  422. {
  423. MessageUtil.ShowTips("暂停失败:" + crt.Resultmsg);
  424. }
  425. else
  426. {
  427. MessageUtil.ShowTips("暂停成功");
  428. doQuery_d(strDid);
  429. }
  430. }
  431. /// <summary>
  432. /// 暂停
  433. /// </summary>
  434. /// <param name="sender"></param>
  435. /// <param name="e"></param>
  436. private void doSuspendD()
  437. {
  438. if (ultraGrid2.ActiveRow == null)
  439. {
  440. MessageUtil.ShowTips("请选择副卡行信息");
  441. return;
  442. }
  443. String strDid = ultraGrid2.ActiveRow.GetCellValue("id").ToString().Trim();
  444. String strCARDNo = ultraGrid2.ActiveRow.GetCellValue("OILCARDID").ToString().Trim();
  445. if (String.IsNullOrEmpty(strDid))
  446. {
  447. MessageUtil.ShowTips("副卡编号为空");
  448. return;
  449. }
  450. OilCardD a = new OilCardD();
  451. if (testDStatus(strDid, out a, 2) == false)
  452. {
  453. return;
  454. }
  455. if (MessageUtil.ShowYesNoAndQuestion("确定暂停副卡:" + strCARDNo + "?") != DialogResult.Yes)
  456. {
  457. return;
  458. }
  459. a.UpdateName = UserInfo.GetUserName();
  460. a.UpdateUserid = UserInfo.GetUserID();
  461. a.UpdateTime = DateTime.Now;
  462. a.Status = "2";
  463. CoreResult crt = this.execute<CoreResult>("com.hnshituo.pur.requireplan.service.OilCardDService", "suspend_CardD", new object[] { a });
  464. if (crt.Resultcode != 0)
  465. {
  466. MessageUtil.ShowTips("暂停失败:" + crt.Resultmsg);
  467. }
  468. else
  469. {
  470. MessageUtil.ShowTips("暂停成功");
  471. doQuery_d(strDid);
  472. }
  473. }
  474. /// <summary>
  475. /// 添加
  476. /// </summary>
  477. /// <param name="sender"></param>
  478. /// <param name="e"></param>
  479. private void doAddD()
  480. {
  481. String strMid = ultraGrid1.ActiveRow.GetCellValue("Id").ToString().Trim();
  482. if (String.IsNullOrEmpty(strMid))
  483. {
  484. MessageUtil.ShowTips("主卡编号为空");
  485. return;
  486. }
  487. if (testDInput() == false)
  488. {
  489. return;
  490. }
  491. String strDid = txt_card_no_add.Text.Trim();
  492. String strUseName = txt_use_name_add.Text.Trim();
  493. String strType2 = txt_type2_add.Value.ToString().Trim();
  494. String remark = txt_remark.Text.Trim();
  495. String strCar = txt_car_add.Text.Trim();
  496. OilCardD cardD = new OilCardD();
  497. cardD.MId = strMid;
  498. cardD.OilCardId = txt_card_d_no.Text.Trim();
  499. cardD.UserName = strUseName;
  500. cardD.Remark = remark;
  501. cardD.Type = strType2;
  502. cardD.OilCardId = strDid;
  503. cardD.Validflag = "1";
  504. cardD.Car = strCar;
  505. cardD.CreateName = UserInfo.GetUserName();
  506. cardD.CreateUserid = UserInfo.GetUserName();
  507. cardD.CreateTime = DateTime.Now;
  508. CoreResult crt = this.execute<CoreResult>("com.hnshituo.pur.requireplan.service.OilCardDService", "insert_CardD", new object[] { cardD });
  509. if (crt.Resultcode != 0)
  510. {
  511. MessageUtil.ShowTips("添加失败:" + crt.Resultmsg);
  512. }
  513. else
  514. {
  515. MessageUtil.ShowTips("添加成功");
  516. doQuery_d(strDid);
  517. }
  518. }
  519. /// <summary>
  520. /// 修改
  521. /// </summary>
  522. /// <param name="sender"></param>
  523. /// <param name="e"></param>
  524. private void doEditD()
  525. {
  526. if (ultraGrid2.ActiveRow == null)
  527. {
  528. MessageUtil.ShowTips("请选择副卡行信息");
  529. return;
  530. }
  531. String strDid = ultraGrid2.ActiveRow.GetCellValue("Id").ToString().Trim();
  532. if (String.IsNullOrEmpty(strDid))
  533. {
  534. MessageUtil.ShowTips("副卡编号为空");
  535. return;
  536. }
  537. OilCardD a = new OilCardD();
  538. if (testDStatus(strDid, out a, 1) == false)
  539. {
  540. return;
  541. }
  542. if (testDInput() == false)
  543. {
  544. return;
  545. }
  546. String strCardDNew = txt_card_no_add.Text.Trim();
  547. String strUseName = txt_use_name_add.Text.Trim();
  548. String strType2 = txt_type2_add.Value.ToString().Trim();
  549. String remark = txt_remark.Text.Trim();
  550. String strCar = txt_car_add.Text.Trim();
  551. OilCardD cardD = new OilCardD();
  552. cardD.Id = strDid;
  553. cardD.OilCardId = strCardDNew;
  554. cardD.UserName = strUseName;
  555. cardD.Type = strType2;
  556. cardD.Car = strCar;
  557. cardD.Validflag = "1";
  558. cardD.Remark = remark;
  559. cardD.UpdateName = UserInfo.GetUserName();
  560. cardD.UpdateUserid = UserInfo.GetUserName();
  561. cardD.UpdateTime = DateTime.Now;
  562. if (MessageUtil.ShowYesNoAndQuestion("确定修改编号为:" + strDid + "的副卡?") != DialogResult.Yes)
  563. {
  564. return;
  565. }
  566. CoreResult crt = this.execute<CoreResult>("com.hnshituo.pur.requireplan.service.OilCardDService", "update_CardD", new object[] { cardD });
  567. if (crt.Resultcode != 0)
  568. {
  569. MessageUtil.ShowTips("修改失败:" + crt.Resultmsg);
  570. }
  571. else
  572. {
  573. MessageUtil.ShowTips("修改成功");
  574. doQuery_d(strDid);
  575. }
  576. }
  577. #endregion
  578. #region 界面事件
  579. private void ultraGrid1_AfterRowActivate(object sender, EventArgs e)
  580. {
  581. clearCardM();
  582. clearCardD();
  583. doQuery_d("");
  584. String strMid = ultraGrid1.ActiveRow.GetCellValue("Id").ToString().Trim();
  585. OilCardM cm = this.execute<OilCardM>("com.hnshituo.pur.requireplan.service.OilCardMService", "findById", new object[] { strMid });
  586. txt_org_add.Text = cm.UserOrgName;
  587. txt_card_m_add.Text = cm.OilCardMId;
  588. txt_type1_add.Value = cm.Type;
  589. }
  590. private void ultraGrid2_AfterRowActivate(object sender, EventArgs e)
  591. {
  592. clearCardD();
  593. String strDid = ultraGrid2.ActiveRow.GetCellValue("Id").ToString().Trim();
  594. OilCardD cd = this.execute<OilCardD>("com.hnshituo.pur.requireplan.service.OilCardDService", "findById", new object[] { strDid });
  595. txt_car_add.Text = cd.Car;
  596. txt_card_no_add.Text = cd.OilCardId;
  597. txt_remark.Text = cd.Remark;
  598. txt_type2_add.Value = cd.Type;
  599. txt_use_name_add.Text = cd.UserName;
  600. }
  601. private void ck_ctime_CheckedChanged(object sender, EventArgs e)
  602. {
  603. txtCreateTimeEnd.Enabled = ck_ctime.Checked;
  604. txtCreateTimeStart.Enabled = ck_ctime.Checked;
  605. }
  606. /// <summary>
  607. /// 标识颜色
  608. /// </summary>
  609. /// <param name="sender"></param>
  610. /// <param name="e"></param>
  611. private void ultraGrid2_InitializeRow(object sender, Infragistics.Win.UltraWinGrid.InitializeRowEventArgs e)
  612. {
  613. if (e.Row.Cells["status"].Value.ToString().Equals("暂停"))
  614. {
  615. e.Row.Appearance.ForeColor = Color.Red;
  616. }
  617. else if (e.Row.Cells["status"].Value.ToString().Equals("注销"))
  618. {
  619. e.Row.Appearance.ForeColor = Color.Gray;
  620. }
  621. else
  622. {
  623. e.Row.Appearance.ForeColor = Color.Black;
  624. }
  625. }
  626. /// <summary>
  627. /// 界面切换
  628. /// </summary>
  629. /// <param name="sender"></param>
  630. /// <param name="e"></param>
  631. private void ultraTabControl1_SelectedTabChanged(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e)
  632. {
  633. if (e.Tab == ultraTabControl1.Tabs[0])
  634. {
  635. this.ToolBarItemEnable(this, "Query", true);
  636. this.ToolBarItemEnable(this, "Add", true);
  637. this.ToolBarItemEnable(this, "Delete", true);
  638. this.ToolBarItemEnable(this, "Update", true);
  639. this.ToolBarItemEnable(this, "doExcel", true);
  640. this.ToolBarItemEnable(this, "Close", true);
  641. }
  642. else
  643. {
  644. this.ToolBarItemEnable(this, "Query", true);
  645. this.ToolBarItemEnable(this, "Add", false);
  646. this.ToolBarItemEnable(this, "Delete", false);
  647. this.ToolBarItemEnable(this, "Update", false);
  648. this.ToolBarItemEnable(this, "doExcel", true);
  649. this.ToolBarItemEnable(this, "Close", true);
  650. }
  651. }
  652. #endregion
  653. #region 公共函数
  654. /// <summary>
  655. /// 查询行
  656. /// </summary>
  657. private void doQuery_d(String CardNo)
  658. {
  659. dataTable2.Clear();
  660. if (ultraGrid1.ActiveRow == null)
  661. {
  662. return;
  663. }
  664. String strMid = ultraGrid1.ActiveRow.GetCellValue("ID").ToString().Trim();
  665. if (String.IsNullOrEmpty(strMid))
  666. {
  667. MessageUtil.ShowTips("主卡卡号为空");
  668. return;
  669. }
  670. OilCardD cardD = new OilCardD();
  671. if (!ck_is_all.Checked)
  672. {
  673. cardD.MId = strMid;
  674. }
  675. cardD.OilCardId = String.IsNullOrEmpty(txt_card_d_no.Text.Trim()) ? txt_cardMD_no.Text.Trim() : txt_card_d_no.Text.Trim();
  676. cardD.UserName = String.IsNullOrEmpty(txt_useName.Text.Trim())?txt_User_name1.Text.Trim():txt_useName.Text.Trim();
  677. if (txt_status.SelectedIndex != -1)
  678. {
  679. cardD.Status = txt_status.Value.ToString().Trim();
  680. }
  681. DataTable dt = this.execute<DataTable>("com.hnshituo.pur.requireplan.service.OilCardDService", "find_CardD", new object[] { cardD });
  682. if (dt != null)
  683. {
  684. GridHelper.CopyDataToDatatable(ref dt, ref dataTable2, true);
  685. GridHelper.RefreshAndAutoSize(ultraGrid2);
  686. if (String.IsNullOrEmpty(CardNo))
  687. {
  688. publicPms.doActiveSelRow(ultraGrid2, "OILCARDID", CardNo);
  689. }
  690. }
  691. }
  692. /// <summary>
  693. /// 校验主卡编辑区数据
  694. /// </summary>
  695. /// <returns></returns>
  696. private bool testMInput()
  697. {
  698. if (String.IsNullOrEmpty(txt_card_m_add.Text.Trim()))
  699. {
  700. MessageUtil.ShowTips("主卡卡号不能为空");
  701. txt_card_m_add.Focus();
  702. return false;
  703. }
  704. if (txt_card_m_add.Text.Trim().Length > 100)
  705. {
  706. MessageBox.Show("请输入卡号最多100位", "提示");
  707. txt_card_m_add.Focus();
  708. return false;
  709. }
  710. if (!StringUtil.IsOnlyLetterAndDigit(txt_card_m_add.Text.Trim()))
  711. {
  712. MessageBox.Show("卡号只能包含字母与数字", "提示");
  713. txt_card_m_add.Focus();
  714. return false;
  715. }
  716. if (String.IsNullOrEmpty(txt_org_add.Text.Trim()))
  717. {
  718. MessageUtil.ShowTips("所属部门为空");
  719. txt_org_add.Focus();
  720. return false;
  721. }
  722. if (txt_type1_add.SelectedIndex == -1)
  723. {
  724. MessageUtil.ShowTips("副卡类型1不能为空");
  725. txt_type1_add.Focus();
  726. return false;
  727. }
  728. return true;
  729. }
  730. /// <summary>
  731. /// 校验主卡编辑区数据
  732. /// </summary>
  733. /// <returns></returns>
  734. private bool testDInput()
  735. {
  736. if (String.IsNullOrEmpty(txt_card_no_add.Text.Trim()))
  737. {
  738. MessageUtil.ShowTips("副卡卡号不能为空");
  739. txt_card_no_add.Focus();
  740. return false;
  741. }
  742. if (txt_card_no_add.Text.Trim().Length > 100)
  743. {
  744. MessageBox.Show("请输入卡号最多100位", "提示");
  745. txt_card_no_add.Focus();
  746. return false;
  747. }
  748. if (!StringUtil.IsOnlyLetterAndDigit(txt_card_no_add.Text.Trim()))
  749. {
  750. MessageBox.Show("卡号只能包含字母与数字", "提示");
  751. txt_card_no_add.Focus();
  752. return false;
  753. }
  754. if (String.IsNullOrEmpty(txt_use_name_add.Text.Trim()))
  755. {
  756. MessageUtil.ShowTips("用户名不能为空");
  757. txt_use_name_add.Focus();
  758. return false;
  759. }
  760. if (txt_type2_add.SelectedIndex == -1)
  761. {
  762. MessageUtil.ShowTips("副卡类型不能为空");
  763. txt_type2_add.Focus();
  764. return false;
  765. }
  766. if (txt_remark.Text.Trim().Length > 1000)
  767. {
  768. MessageBox.Show("备注内容太多", "提示");
  769. txt_card_no_add.Focus();
  770. return false;
  771. }
  772. return true;
  773. }
  774. /// <summary>
  775. /// 验证主卡状态
  776. /// </summary>
  777. /// <param name="StrCardNo"></param>
  778. /// <returns></returns>
  779. private bool testMStatus(String StrCardMNo)
  780. {
  781. if (String.IsNullOrEmpty(StrCardMNo))
  782. {
  783. MessageUtil.ShowTips("主卡编号为空");
  784. return false;
  785. }
  786. OilCardM a = this.execute<OilCardM>("com.hnshituo.pur.requireplan.service.OilCardMService", "findById", new object[] { StrCardMNo });
  787. if (a == null)
  788. {
  789. MessageUtil.ShowTips("未发现编号:" + StrCardMNo + "的主卡信息记录");
  790. return false;
  791. }
  792. if (a.Validflag != "1")
  793. {
  794. MessageUtil.ShowTips("编号:" + StrCardMNo + "的主卡信息记录已作废");
  795. return false;
  796. }
  797. return true;
  798. }
  799. /// <summary>
  800. /// 验证副卡状态
  801. /// </summary>
  802. /// <param name="StrCardNo"></param>
  803. /// <returns></returns>
  804. private bool testDStatus(String StrDid,out OilCardD a,int p)
  805. {
  806. a = new OilCardD();
  807. if (String.IsNullOrEmpty(StrDid))
  808. {
  809. MessageUtil.ShowTips("副卡编号为空");
  810. return false;
  811. }
  812. a = this.execute<OilCardD>("com.hnshituo.pur.requireplan.service.OilCardDService", "findById", new object[] { StrDid });
  813. if (a == null)
  814. {
  815. MessageUtil.ShowTips("未发现编号:" + StrDid + "的副卡信息记录");
  816. return false;
  817. }
  818. if (a.Validflag!="1")
  819. {
  820. MessageUtil.ShowTips("编号:" + StrDid + "的副卡信息记录已作废");
  821. return false;
  822. }
  823. //修改
  824. if (p == 1)
  825. {
  826. if (a.Status != "1")
  827. {
  828. MessageUtil.ShowTips("非正常状态,无法修改");
  829. return false;
  830. }
  831. }
  832. //暂挂
  833. else if (p == 2)
  834. {
  835. if (a.Status != "1")
  836. {
  837. MessageUtil.ShowTips("非正常状态,无法暂停");
  838. return false;
  839. }
  840. }
  841. //恢复
  842. else if (p ==3)
  843. {
  844. if (a.Status != "2")
  845. {
  846. MessageUtil.ShowTips("不在暂停,无法恢复");
  847. return false;
  848. }
  849. }
  850. //注销
  851. else if (p == 4)
  852. {
  853. if (a.Status== "3")
  854. {
  855. MessageUtil.ShowTips("已注销,重复操作");
  856. return false;
  857. }
  858. }
  859. else
  860. {
  861. MessageUtil.ShowTips("未知参数,无效操作");
  862. return false;
  863. }
  864. return true;
  865. }
  866. /// <summary>
  867. /// 清空主主卡编辑区
  868. /// </summary>
  869. private void clearCardM()
  870. {
  871. txt_org_add.Clear();
  872. txt_card_m_add.Clear();
  873. txt_type1_add.SelectedIndex = -1;
  874. }
  875. /// <summary>
  876. /// 清空副卡编辑区
  877. /// </summary>
  878. private void clearCardD()
  879. {
  880. txt_car_add.Clear();
  881. txt_card_no_add.Clear();
  882. txt_remark.Clear(); ;
  883. txt_type2_add.SelectedIndex = -1; ;
  884. txt_use_name_add.Clear();
  885. }
  886. #endregion
  887. }
  888. }