F_SAP_HEGII_0109.cs 21 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638
  1. using Dongke.IBOSS.PRD.Basics.BaseControls;
  2. using Dongke.IBOSS.PRD.Basics.BaseResources;
  3. using Dongke.IBOSS.PRD.Client.CommonModule;
  4. using Dongke.IBOSS.PRD.Client.Controls;
  5. using Dongke.IBOSS.PRD.WCF.DataModels;
  6. using Dongke.IBOSS.PRD.WCF.Proxys;
  7. using System;
  8. using System.Collections.Generic;
  9. using System.ComponentModel;
  10. using System.Data;
  11. using System.Drawing;
  12. using System.Linq;
  13. using System.Reflection;
  14. using System.Text;
  15. using System.Windows.Forms;
  16. namespace Dongke.IBOSS.PRD.Client.SAPDataModule.Hegii
  17. {
  18. public partial class F_SAP_HEGII_0109 : DKDockPanelBase
  19. {
  20. #region 成员变量
  21. private static F_SAP_HEGII_0109 _instance = null;
  22. #endregion
  23. #region 单例模式
  24. /// <summary>
  25. /// 单例模式,防止重复创建窗体
  26. /// </summary>
  27. public static F_SAP_HEGII_0109 Instance
  28. {
  29. get
  30. {
  31. if (_instance == null)
  32. {
  33. _instance = new F_SAP_HEGII_0109();
  34. }
  35. return _instance;
  36. }
  37. }
  38. #endregion
  39. #region 构造函数
  40. /// <summary>
  41. /// 成品SAP日志
  42. /// </summary>
  43. public F_SAP_HEGII_0109()
  44. {
  45. InitializeComponent();
  46. this.Text = "BPM同步日志";
  47. this.tsbtnAdaptive.Text = ButtonText.TSBTN_ADAPTIVE;
  48. this.tsbtnClose.Text = ButtonText.TSBTN_CLOSE;
  49. this.dgvScrap.AutoGenerateColumns = false;
  50. }
  51. #endregion
  52. #region 事件
  53. /// <summary>
  54. /// 加载事件
  55. /// </summary>
  56. /// <param name="sender"></param>
  57. /// <param name="e"></param>
  58. private void F_SAP_HEGII_0109_Load(object sender, EventArgs e)
  59. {
  60. dgvScrap.AutoGenerateColumns = false;
  61. this.dtpDateAgin.Value = DateTime.Now.Date;
  62. this.dtpDateEnd.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1);
  63. //数据节点数据绑定确认状态
  64. DataTable DataCodeDt = new DataTable();
  65. DataCodeDt.Columns.Add("DataCodeName", typeof(string));
  66. DataCodeDt.Columns.Add("DataCode", typeof(string));
  67. DataRow dr = DataCodeDt.NewRow();
  68. dr["DataCodeName"] = "";
  69. dr["DataCode"] = "-1";
  70. DataCodeDt.Rows.InsertAt(dr, 0);
  71. dr = DataCodeDt.NewRow();
  72. dr["DataCodeName"] = "已确认";
  73. dr["DataCode"] = "1";
  74. DataCodeDt.Rows.InsertAt(dr, 1);
  75. dr = DataCodeDt.NewRow();
  76. dr["DataCodeName"] = "未确认";
  77. dr["DataCode"] = "0";
  78. DataCodeDt.Rows.InsertAt(dr, 2);
  79. this.cbCheckFlag.DisplayMember = "DataCodeName";
  80. this.cbCheckFlag.ValueMember = "DataCode";
  81. this.cbCheckFlag.DataSource = DataCodeDt;
  82. this.cbCheckFlag.SelectedValue = "-1";
  83. //数据节点数据绑定确认状态
  84. DataTable SyncFlagDt = new DataTable();
  85. SyncFlagDt.Columns.Add("DataCodeName", typeof(string));
  86. SyncFlagDt.Columns.Add("DataCode", typeof(string));
  87. DataRow SFdr = SyncFlagDt.NewRow();
  88. SFdr["DataCodeName"] = "";
  89. SFdr["DataCode"] = "-1";
  90. SyncFlagDt.Rows.InsertAt(SFdr, 0);
  91. SFdr = SyncFlagDt.NewRow();
  92. SFdr["DataCodeName"] = "已同步";
  93. SFdr["DataCode"] = "1";
  94. SyncFlagDt.Rows.InsertAt(SFdr, 1);
  95. SFdr = SyncFlagDt.NewRow();
  96. SFdr["DataCodeName"] = "未同步";
  97. SFdr["DataCode"] = "0";
  98. SyncFlagDt.Rows.InsertAt(SFdr, 2);
  99. SFdr = SyncFlagDt.NewRow();
  100. SFdr["DataCodeName"] = "BPM系统审批不通过";
  101. SFdr["DataCode"] = "2";
  102. SyncFlagDt.Rows.InsertAt(SFdr, 3);
  103. this.cbSyncFlag.DisplayMember = "DataCodeName";
  104. this.cbSyncFlag.ValueMember = "DataCode";
  105. this.cbSyncFlag.DataSource = SyncFlagDt;
  106. this.cbSyncFlag.SelectedValue = "-1";
  107. }
  108. /// <summary>
  109. /// 查询
  110. /// </summary>
  111. /// <param name="sender"></param>
  112. /// <param name="e"></param>
  113. private void tsbtnSearch_Click(object sender, EventArgs e)
  114. {
  115. this.QueryDataFromOther();
  116. this.tsbtnAdaptive_Click(null, null);
  117. }
  118. /// <summary>
  119. /// 确认组件报损
  120. /// </summary>
  121. /// <param name="sender"></param>
  122. /// <param name="e"></param>
  123. private void tsbtnConfirm_Click(object sender, EventArgs e)
  124. {
  125. try
  126. {
  127. tsrToolStrip1.Focus();
  128. DataTable data = (DataTable)this.dgvScrap.DataSource;
  129. if (data == null || data.Rows.Count==0)
  130. {
  131. return;
  132. }
  133. DataTable datacp = data.Copy();
  134. datacp.DefaultView.RowFilter= "check1 =1 ";
  135. DataTable checkedDt = datacp.DefaultView.ToTable();
  136. if (checkedDt.Rows.Count == 0)
  137. {
  138. DKMessageBox.ShowDialog(this, DKMessageCode.W_CMN_S_004, "未选择任何数据");
  139. return;
  140. }
  141. DataRow[] rows = checkedDt.Select("CheckFlagName = '已确认'");
  142. if (rows.Length > 0)
  143. {
  144. DKMessageBox.ShowDialog(this, DKMessageCode.W_CMN_S_004, "已确认数据不允许再确认");
  145. return;
  146. }
  147. DialogResult dr = MessageBox.Show("是否对所选数据进行确认?", this.Text, MessageBoxButtons.YesNo, MessageBoxIcon.Question);
  148. if (dr != System.Windows.Forms.DialogResult.Yes)
  149. {
  150. return;
  151. }
  152. ClientRequestEntity cre = new ClientRequestEntity();
  153. cre.NameSpace = "Hegii";
  154. cre.Name = "SaveConfirmIdnrkScrap";
  155. cre.Data = new DataSet();
  156. cre.Data.Tables.Add(checkedDt);
  157. ServiceResultEntity sre = DoAsync(() =>
  158. {
  159. return SAPDataModuleProxy.Service.DoRequest(cre);
  160. });
  161. if (sre.OtherStatus > 0)
  162. {
  163. DKMessageBox.ShowDialog(this, DKMessageCode.I_CMN_S_002);
  164. tsbtnSearch_Click(null, null);
  165. }
  166. else
  167. {
  168. DKMessageBox.ShowDialog(this, DKMessageCode.W_CMN_S_004, sre.Message);
  169. return;
  170. }
  171. }
  172. catch (Exception ex)
  173. {
  174. // 对异常进行共通处理
  175. ExceptionManager.HandleEventException(this.ToString(),
  176. MethodBase.GetCurrentMethod().Name, this.Text, ex);
  177. }
  178. }
  179. /// <summary>
  180. /// 撤销确认
  181. /// </summary>
  182. /// <param name="sender"></param>
  183. /// <param name="e"></param>
  184. private void tsbtnUNConfirm_Click(object sender, EventArgs e)
  185. {
  186. try
  187. {
  188. tsrToolStrip1.Focus();
  189. DataTable data = (DataTable)this.dgvScrap.DataSource;
  190. if (data == null || data.Rows.Count == 0)
  191. {
  192. return;
  193. }
  194. DataTable datacp = data.Copy();
  195. datacp.DefaultView.RowFilter = "check1 =1 ";
  196. DataTable checkedDt = datacp.DefaultView.ToTable();
  197. if (checkedDt.Rows.Count == 0)
  198. {
  199. DKMessageBox.ShowDialog(this, DKMessageCode.W_CMN_S_004, "未选择任何数据");
  200. return;
  201. }
  202. DataRow[] rows = checkedDt.Select("CheckFlagName = '未确认'");
  203. if (rows.Length > 0)
  204. {
  205. DKMessageBox.ShowDialog(this, DKMessageCode.W_CMN_S_004, "未确认数据不能撤销");
  206. return;
  207. }
  208. rows = checkedDt.Select("SyncFlagName = '已同步' or SyncFlagName = 'BPM系统审批不通过'");
  209. if (rows.Length > 0)
  210. {
  211. DKMessageBox.ShowDialog(this, DKMessageCode.W_CMN_S_004, "已同步数据不能撤销");
  212. return;
  213. }
  214. DialogResult dr = MessageBox.Show("是否对所选数据进行撤销?", this.Text, MessageBoxButtons.YesNo, MessageBoxIcon.Question);
  215. if (dr != System.Windows.Forms.DialogResult.Yes)
  216. {
  217. return;
  218. }
  219. ClientRequestEntity cre = new ClientRequestEntity();
  220. cre.NameSpace = "Hegii";
  221. cre.Name = "SaveUNConfirmIdnrkScrap";
  222. cre.Data = new DataSet();
  223. cre.Data.Tables.Add(checkedDt);
  224. ServiceResultEntity sre = DoAsync(() =>
  225. {
  226. return SAPDataModuleProxy.Service.DoRequest(cre);
  227. });
  228. if (sre.OtherStatus > 0)
  229. {
  230. DKMessageBox.ShowDialog(this, DKMessageCode.I_CMN_S_002);
  231. tsbtnSearch_Click(null, null);
  232. }
  233. }
  234. catch (Exception ex)
  235. {
  236. // 对异常进行共通处理
  237. ExceptionManager.HandleEventException(this.ToString(),
  238. MethodBase.GetCurrentMethod().Name, this.Text, ex);
  239. }
  240. }
  241. /// <summary>
  242. /// 同步
  243. /// </summary>
  244. /// <param name="sender"></param>
  245. /// <param name="e"></param>
  246. private void tsbtnSynLog_Click(object sender, EventArgs e)
  247. {
  248. try
  249. {
  250. tsrToolStrip1.Focus();
  251. DataTable data = (DataTable)this.dgvScrap.DataSource;
  252. if (data == null || data.Rows.Count == 0)
  253. {
  254. return;
  255. }
  256. DataTable datacp = data.Copy();
  257. datacp.DefaultView.RowFilter = "check1 =1 ";
  258. DataTable checkedDt = datacp.DefaultView.ToTable();
  259. if (checkedDt.Rows.Count == 0)
  260. {
  261. DKMessageBox.ShowDialog(this, DKMessageCode.W_CMN_S_004, "未选择任何数据");
  262. return;
  263. }
  264. DataRow[] rows = checkedDt.Select("CheckFlagName = '未确认'");
  265. if (rows.Length > 0)
  266. {
  267. DKMessageBox.ShowDialog(this, DKMessageCode.W_CMN_S_004, "未确认数据不允许同步");
  268. return;
  269. }
  270. rows = checkedDt.Select("SyncFlagName = '已同步'");
  271. if (rows.Length > 0)
  272. {
  273. DKMessageBox.ShowDialog(this, DKMessageCode.W_CMN_S_004, "已同步数据不允许同步");
  274. return;
  275. }
  276. DataRow[] Hasrows = checkedDt.Select("incident is not null");
  277. DataRow[] Nonerows = checkedDt.Select("incident is null");
  278. if(Hasrows.Length>0 && Nonerows.Length>0)
  279. {
  280. DKMessageBox.ShowDialog(this, DKMessageCode.W_CMN_S_004, "BPM拒绝数据和第一次同步数据不能同时推送");
  281. return;
  282. }
  283. if(Hasrows.Length > 0)
  284. {
  285. // 同一bpm流程实例数据是否全部勾选
  286. string ids = ",";
  287. foreach (DataRow item in Hasrows)
  288. {
  289. ids += item["SCRAPID"].ToString() + ",";
  290. }
  291. ClientRequestEntity cres = new ClientRequestEntity();
  292. cres.NameSpace = "Hegii";
  293. cres.Name = "CheckScrap";
  294. cres.Properties["SCRAPIDs"] = ids;
  295. ServiceResultEntity sres = DoAsync(() =>
  296. {
  297. return SAPDataModuleProxy.Service.DoRequest(cres);
  298. });
  299. if (sres.Data.Tables[0]!=null && sres.Data.Tables[0].Rows.Count>0)
  300. {
  301. DKMessageBox.ShowDialog(this, DKMessageCode.W_CMN_S_004, "BPM拒绝数据再次推送,需勾选全部数据");
  302. return;
  303. }
  304. }
  305. DialogResult dr = MessageBox.Show("是否对所选数据进行同步?", this.Text, MessageBoxButtons.YesNo, MessageBoxIcon.Question);
  306. if (dr != System.Windows.Forms.DialogResult.Yes)
  307. {
  308. return;
  309. }
  310. ClientRequestEntity cre = new ClientRequestEntity();
  311. cre.NameSpace = "Hegii";
  312. cre.Name = "SynIdnrkScrap";
  313. cre.Data = new DataSet();
  314. cre.Data.Tables.Add(checkedDt);
  315. ServiceResultEntity sre = DoAsync(() =>
  316. {
  317. return SAPDataModuleProxy.Service.DoRequest(cre);
  318. });
  319. if (sre.OtherStatus > 0)
  320. {
  321. DKMessageBox.ShowDialog(this, DKMessageCode.I_CMN_S_002);
  322. tsbtnSearch_Click(null, null);
  323. }
  324. else
  325. {
  326. DKMessageBox.ShowDialog(this, DKMessageCode.W_CMN_S_004, sre.Message);
  327. return;
  328. }
  329. }
  330. catch (Exception ex)
  331. {
  332. // 对异常进行共通处理
  333. ExceptionManager.HandleEventException(this.ToString(),
  334. MethodBase.GetCurrentMethod().Name, this.Text, ex);
  335. }
  336. }
  337. /// <summary>
  338. /// 撤销同步
  339. /// </summary>
  340. /// <param name="sender"></param>
  341. /// <param name="e"></param>
  342. private void tsbtnCancelSynLog_Click(object sender, EventArgs e)
  343. {
  344. try
  345. {
  346. tsrToolStrip1.Focus();
  347. DataTable data = (DataTable)this.dgvScrap.DataSource;
  348. if (data == null || data.Rows.Count == 0)
  349. {
  350. return;
  351. }
  352. DataTable datacp = data.Copy();
  353. datacp.DefaultView.RowFilter = "check1 =1 ";
  354. DataTable checkedDt = datacp.DefaultView.ToTable();
  355. if (checkedDt.Rows.Count == 0)
  356. {
  357. DKMessageBox.ShowDialog(this, DKMessageCode.W_CMN_S_004, "未选择任何数据");
  358. return;
  359. }
  360. DataRow[] rows = checkedDt.Select("SyncFlagName <> '已同步'");
  361. if (rows.Length > 0)
  362. {
  363. DKMessageBox.ShowDialog(this, DKMessageCode.W_CMN_S_004, "未同步数据不允许撤销");
  364. return;
  365. }
  366. DialogResult dr = MessageBox.Show("是否对所选数据进行撤销?", this.Text, MessageBoxButtons.YesNo, MessageBoxIcon.Question);
  367. if (dr != System.Windows.Forms.DialogResult.Yes)
  368. {
  369. return;
  370. }
  371. DataRow[] hasrow = checkedDt.Select("incident is not null");
  372. if(hasrow.Length>0)
  373. {
  374. // 同一bpm流程实例数据是否全部勾选
  375. string ids = ",";
  376. foreach (DataRow item in hasrow)
  377. {
  378. ids += item["SCRAPID"].ToString() + ",";
  379. }
  380. ClientRequestEntity cres = new ClientRequestEntity();
  381. cres.NameSpace = "Hegii";
  382. cres.Name = "CheckScrap";
  383. cres.Properties["SCRAPIDs"] = ids;
  384. ServiceResultEntity sres = DoAsync(() =>
  385. {
  386. return SAPDataModuleProxy.Service.DoRequest(cres);
  387. });
  388. if (sres.Data.Tables[0] != null && sres.Data.Tables[0].Rows.Count > 0)
  389. {
  390. DKMessageBox.ShowDialog(this, DKMessageCode.W_CMN_S_004, "BPM拒绝数据再次推送,需勾选全部数据");
  391. return;
  392. }
  393. }
  394. ClientRequestEntity cre = new ClientRequestEntity();
  395. cre.NameSpace = "Hegii";
  396. cre.Name = "CancelSynIdnrkScrap";
  397. cre.Data = new DataSet();
  398. cre.Data.Tables.Add(checkedDt);
  399. ServiceResultEntity sre = DoAsync(() =>
  400. {
  401. return SAPDataModuleProxy.Service.DoRequest(cre);
  402. });
  403. if (sre.OtherStatus > 0)
  404. {
  405. DKMessageBox.ShowDialog(this, DKMessageCode.I_CMN_S_002);
  406. tsbtnSearch_Click(null, null);
  407. }
  408. else
  409. {
  410. DKMessageBox.ShowDialog(this, DKMessageCode.W_CMN_S_004, "BPM系统同步失败!");
  411. return;
  412. }
  413. }
  414. catch (Exception ex)
  415. {
  416. // 对异常进行共通处理
  417. ExceptionManager.HandleEventException(this.ToString(),
  418. MethodBase.GetCurrentMethod().Name, this.Text, ex);
  419. }
  420. }
  421. /// <summary>
  422. /// 设置成本中心
  423. /// </summary>
  424. /// <param name="sender"></param>
  425. /// <param name="e"></param>
  426. private void btnSetCostCenter_Click(object sender, EventArgs e)
  427. {
  428. try
  429. {
  430. tsrToolStrip1.Focus();
  431. DataTable data = (DataTable)this.dgvScrap.DataSource;
  432. if (data == null || data.Rows.Count == 0)
  433. {
  434. return;
  435. }
  436. DataTable datacp = data.Copy();
  437. datacp.DefaultView.RowFilter = "check1 =1 ";
  438. DataTable checkedDt = datacp.DefaultView.ToTable();
  439. if (checkedDt.Rows.Count == 0)
  440. {
  441. DKMessageBox.ShowDialog(this, DKMessageCode.W_CMN_S_004, "未选择任何数据");
  442. return;
  443. }
  444. DataRow [] rows = checkedDt.Select("SyncFlagName = '已同步'");
  445. if (rows.Length > 0)
  446. {
  447. DKMessageBox.ShowDialog(this, DKMessageCode.W_CMN_S_004, "已同步数据不允许修改");
  448. return;
  449. }
  450. F_SAP_HEGII_0110 frmFsap0110 = new F_SAP_HEGII_0110(checkedDt);
  451. DialogResult dialogresult = frmFsap0110.ShowDialog();
  452. if (dialogresult.Equals(DialogResult.OK))
  453. {
  454. this.tsbtnSearch_Click(null, null);
  455. }
  456. }
  457. catch (Exception ex)
  458. {
  459. // 对异常进行共通处理
  460. ExceptionManager.HandleEventException(this.ToString(),
  461. MethodBase.GetCurrentMethod().Name, this.Text, ex);
  462. }
  463. }
  464. /// <summary>
  465. /// 清空条件
  466. /// </summary>
  467. /// <param name="sender"></param>
  468. /// <param name="e"></param>
  469. private void tsbtnClearCondition_Click(object sender, EventArgs e)
  470. {
  471. this.dtpDateAgin.Value = DateTime.Now.Date;
  472. this.dtpDateEnd.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1);
  473. this.cbCheckFlag.SelectedValue = "-1";
  474. this.cbSyncFlag.SelectedValue = "-1";
  475. }
  476. /// <summary>
  477. /// 自适应列宽
  478. /// </summary>
  479. /// <param name="sender"></param>
  480. /// <param name="e"></param>
  481. private void tsbtnAdaptive_Click(object sender, EventArgs e)
  482. {
  483. this.dgvScrap.AutoResizeColumns();
  484. }
  485. /// <summary>
  486. /// 关闭
  487. /// </summary>
  488. /// <param name="sender"></param>
  489. /// <param name="e"></param>
  490. private void tsbtnClose_Click(object sender, EventArgs e)
  491. {
  492. this.Close();
  493. }
  494. /// <summary>
  495. /// 窗体关闭
  496. /// </summary>
  497. /// <param name="sender"></param>
  498. /// <param name="e"></param>
  499. private void F_SAP_HEGII_0109_FormClosed(object sender, FormClosedEventArgs e)
  500. {
  501. _instance = null;
  502. }
  503. #endregion
  504. #region 私有方法
  505. /// <summary>
  506. /// 查询数据
  507. /// </summary>
  508. private void QueryDataFromOther()
  509. {
  510. try
  511. {
  512. this.dgvScrap.DataSource = null;
  513. this.tsrToolStrip1.Focus();
  514. ClientRequestEntity cre = new ClientRequestEntity();
  515. cre.Properties["dateagin"] = this.dtpDateAgin.Value;
  516. cre.Properties["dateend"] = Convert.ToDateTime( this.dtpDateEnd.Value).AddSeconds(1);
  517. cre.Properties["CheckFlag"] = this.cbCheckFlag.SelectedValue;
  518. cre.Properties["SyncFlag"] = this.cbSyncFlag.SelectedValue;
  519. cre.NameSpace = "Hegii";
  520. cre.Name = "GetDataBARCODEIDNRKSCRAP";
  521. ServiceResultEntity sre = DoAsync<ServiceResultEntity>(() =>
  522. {
  523. return SAPDataModuleProxy.Service.DoRequest(cre);
  524. });
  525. if (sre.Status == Constant.ServiceResultStatus.Success)
  526. {
  527. // 查询成功
  528. this.dgvScrap.DataSource = sre.Data.Tables[0];
  529. if (this.dgvScrap.RowCount == 0)
  530. {
  531. DKMessageBox.ShowDialog(this, DKMessageCode.I_CMN_S_001);
  532. }
  533. }
  534. }
  535. catch (Exception ex)
  536. {
  537. throw;
  538. }
  539. }
  540. #endregion
  541. }
  542. }