F_RPT_010202.cs 15 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501
  1. /*******************************************************************************
  2. * Copyright(c) 2015 DongkeSoft All rights reserved. / Confidential
  3. * 类的信息:
  4. * 1.程序名称:F_RPT_010202.cs
  5. * 2.功能描述:产品损坯明细表
  6. * 编辑履历:
  7. * 作者 日期 版本 修改内容
  8. * 袁新成 2015/4/14 1.00 新建
  9. *******************************************************************************/
  10. using System;
  11. using System.Data;
  12. using System.Text;
  13. using System.Windows.Forms;
  14. using Dongke.IBOSS.PRD.Basics.BaseResources;
  15. using Dongke.IBOSS.PRD.Basics.DockPanel;
  16. using Dongke.IBOSS.PRD.Client.CommonModule;
  17. using Dongke.IBOSS.PRD.Client.Controls;
  18. using Dongke.IBOSS.PRD.Client.DataModels;
  19. using Dongke.IBOSS.PRD.WCF.DataModels;
  20. using Dongke.IBOSS.PRD.WCF.Proxys;
  21. namespace Dongke.IBOSS.PRD.Client.ReportModule
  22. {
  23. /// <summary>
  24. /// 产品损坯明细表
  25. /// </summary>
  26. public partial class F_RPT_010202 : DKDockPanelBase
  27. {
  28. #region 成员变量
  29. // 窗体的单例模式
  30. private static F_RPT_010202 _instance;
  31. //实体类
  32. private RPT030102_SE _rptse = null;
  33. private RPT030102_SE _rptse1 = null;
  34. //默认清空工序,重置回用户当前权限工序
  35. private string _currentUserPurview = null;
  36. //默认清空生产线,重置回用户当前权限生产线
  37. private string _currentUserLinePuview = null;
  38. #endregion
  39. #region 构造函数
  40. public F_RPT_010202()
  41. {
  42. InitializeComponent();
  43. // 窗体显示的Title
  44. this.Text = "产品损坯明细表";
  45. this.tsbtnAdaptive.Text = ButtonText.TSBTN_ADAPTIVE;
  46. this.tsbtnClose.Text = ButtonText.TSBTN_CLOSE;
  47. this.btnSearch.Text = ButtonText.BTN_SEARCH;
  48. this.btnClearCondition.Text = ButtonText.BTN_CLEARCONDITION;
  49. this.gbxCondition.Text = Constant.LABEL_QUERY_CONDITIONS;
  50. }
  51. #endregion
  52. #region 单例模式
  53. /// <summary>
  54. /// 单例模式,防止重复创建窗体
  55. /// </summary>
  56. public static F_RPT_010202 Instance
  57. {
  58. get
  59. {
  60. if (_instance == null || _instance.IsDisposed)
  61. {
  62. _instance = new F_RPT_010202();
  63. }
  64. return _instance;
  65. }
  66. }
  67. #endregion
  68. #region 事件处理
  69. /// <summary>
  70. /// 窗体加载事件
  71. /// </summary>
  72. /// <param name="sender"></param>
  73. /// <param name="e"></param>
  74. private void F_RPT_010202_Load(object sender, EventArgs e)
  75. {
  76. try
  77. {
  78. // 加载权限
  79. FormPermissionManager.FormPermissionControl(this.Name, this,
  80. LogInUserInfo.CurrentUser.CurrentUserEntity.UserRightData,
  81. LogInUserInfo.CurrentUser.CurrentUserEntity.FunctionData);
  82. // 设置表格不自动创建列
  83. //this.dgvScrapTotalModule.AutoGenerateColumns = false;
  84. this.dgvScrapTotalModuleDetail.AutoGenerateColumns = false;
  85. //this.dkproductionLineSearchBox.IsEnablePurview = true;
  86. //this.dkProcedureSearchBox.IsEnablePurview = true;
  87. // 初始化时间控件为当前日期
  88. this.dtpScrapDateStart.Value = DateTime.Now.Date;
  89. this.dtpScrapDateEnd.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1);
  90. //getPurview();
  91. //getPurviewLine()
  92. // wangx 2016-06-21
  93. // 完成时间
  94. this.dtpCDateStart.Value = DateTime.Now.Date;
  95. this.dtpCDateEnd.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1);
  96. this.dtpCDateStart.Enabled = false;
  97. this.dtpCDateEnd.Enabled = false;
  98. // 交坯时间
  99. this.dtpDDateStart.Value = DateTime.Now.Date;
  100. this.dtpDDateEnd.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1);
  101. this.dtpDDateStart.Enabled = false;
  102. this.dtpDDateEnd.Enabled = false;
  103. // 注浆时间
  104. this.dtpGDateStart.Value = DateTime.Now.Date;
  105. this.dtpGDateEnd.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1);
  106. this.dtpGDateStart.Enabled = false;
  107. this.dtpGDateEnd.Enabled = false;
  108. // wangx 2016-06-21 end
  109. // 审核时间
  110. this.dtpAuditDateStart.Value = DateTime.Now.Date;
  111. this.dtpAuditDateEnd.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1);
  112. this.dtpAuditDateStart.Enabled = false;
  113. this.dtpAuditDateEnd.Enabled = false;
  114. }
  115. catch (Exception ex)
  116. {
  117. // 对异常进行共通处理
  118. ExceptionManager.HandleEventException(this.ToString(),
  119. System.Reflection.MethodBase.GetCurrentMethod().Name, this.Text, ex);
  120. }
  121. }
  122. /// <summary>
  123. /// 窗体关闭事件
  124. /// </summary>
  125. /// <param name="sender"></param>
  126. /// <param name="e"></param>
  127. private void F_RPT_010202_FormClosed(object sender, FormClosedEventArgs e)
  128. {
  129. _instance = null;
  130. }
  131. /// <summary>
  132. /// 关闭按钮
  133. /// </summary>
  134. /// <param name="sender"></param>
  135. /// <param name="e"></param>
  136. private void tsbtnClose_Click(object sender, EventArgs e)
  137. {
  138. this.Close();
  139. }
  140. /// <summary>
  141. /// 自动适应列宽
  142. /// </summary>
  143. /// <param name="sender"></param>
  144. /// <param name="e"></param>
  145. private void tsbtnAdaptive_Click(object sender, EventArgs e)
  146. {
  147. this.dgvScrapTotalModuleDetail.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells);
  148. }
  149. /// <summary>
  150. /// 查询按钮事件
  151. /// </summary>
  152. /// <param name="sender"></param>
  153. /// <param name="e"></param>
  154. private void btnSearch_Click(object sender, EventArgs e)
  155. {
  156. try
  157. {
  158. CreateSearchCondition();
  159. this.dgvScrapTotalModuleDetail.DataSource = null;
  160. this.dgvScrapTotalModuleDetail.DataSource = this.GetSearchDetailData();
  161. }
  162. catch (Exception ex)
  163. {
  164. this.btnSearch.Enabled = true;
  165. // 对异常进行共通处理
  166. ExceptionManager.HandleEventException(this.ToString(),
  167. System.Reflection.MethodBase.GetCurrentMethod().Name, this.Text, ex);
  168. }
  169. }
  170. /// <summary>
  171. /// 清空条件按钮事件
  172. /// </summary>
  173. /// <param name="sender"></param>
  174. /// <param name="e"></param>
  175. private void btnClearCondition_Click(object sender, EventArgs e)
  176. {
  177. this.dkproductionLineSearchBox.ClearControl();
  178. this.scbGoodsType.ClearValue();
  179. this.txtGoodCode.Clear();
  180. this.dkProcedureSearchBox.ClearControl();
  181. this.dtpScrapDateStart.Value = DateTime.Now.Date;
  182. this.dtpScrapDateEnd.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1);
  183. this.chkScrapDateStart.Checked = true;
  184. this.dkResponProcedureSearchBox.ClearControl();
  185. this.dkResponUserInfoSearchBox.ClearControl();
  186. //this.dkResponProcedureSearchBox.ProcedureIDS = this._currentUserPurview;
  187. //this.dkproductionLineSearchBox.ProductionLineIDS = this._currentUserLinePuview;
  188. this.txtAuditUser.Clear();
  189. this.txtCreatUser.Clear();
  190. this.chkSpecialRepairFlag.Checked = true;
  191. this.chkReFireFlag.Checked = false;
  192. // 完成时间
  193. this.dtpCDateStart.Value = DateTime.Now.Date;
  194. this.dtpCDateEnd.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1);
  195. this.dtpCDateStart.Enabled = false;
  196. this.dtpCDateEnd.Enabled = false;
  197. this.chkPDate.Checked = false;
  198. // 交坯时间
  199. this.dtpDDateStart.Value = DateTime.Now.Date;
  200. this.dtpDDateEnd.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1);
  201. this.dtpDDateStart.Enabled = false;
  202. this.dtpDDateEnd.Enabled = false;
  203. this.chkDDate.Checked = false;
  204. // 注浆时间
  205. this.dtpGDateStart.Value = DateTime.Now.Date;
  206. this.dtpGDateEnd.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1);
  207. this.dtpGDateStart.Enabled = false;
  208. this.dtpGDateEnd.Enabled = false;
  209. this.chkGDate.Checked = false;
  210. // 审核时间
  211. this.dtpAuditDateStart.Value = DateTime.Now.Date;
  212. this.dtpAuditDateEnd.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1);
  213. this.dtpAuditDateStart.Enabled = false;
  214. this.dtpAuditDateEnd.Enabled = false;
  215. this.chkAuditDate.Checked = false;
  216. }
  217. /// <summary>
  218. /// 报损日期选中改变事件
  219. /// </summary>
  220. /// <param name="sender"></param>
  221. /// <param name="e"></param>
  222. private void chkScrapDateStart_CheckedChanged(object sender, EventArgs e)
  223. {
  224. if (this.chkScrapDateStart.Checked)
  225. {
  226. this.dtpScrapDateStart.Enabled = true;
  227. this.dtpScrapDateEnd.Enabled = true;
  228. }
  229. else
  230. {
  231. this.dtpScrapDateStart.Enabled = false;
  232. this.dtpScrapDateEnd.Enabled = false;
  233. this.dtpScrapDateStart.Value = DateTime.Now.Date;
  234. this.dtpScrapDateEnd.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1);
  235. }
  236. }
  237. /// <summary>
  238. /// 完成时间选中改变事件
  239. /// </summary>
  240. /// <param name="sender"></param>
  241. /// <param name="e"></param>
  242. private void chkPDate_CheckedChanged(object sender, EventArgs e)
  243. {
  244. if (this.chkPDate.Checked)
  245. {
  246. this.dtpCDateStart.Enabled = true;
  247. this.dtpCDateEnd.Enabled = true;
  248. }
  249. else
  250. {
  251. this.dtpCDateStart.Enabled = false;
  252. this.dtpCDateEnd.Enabled = false;
  253. this.dtpCDateStart.Value = DateTime.Now.Date;
  254. this.dtpCDateEnd.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1);
  255. }
  256. }
  257. /// <summary>
  258. /// 交坯时间选中改变事件
  259. /// </summary>
  260. /// <param name="sender"></param>
  261. /// <param name="e"></param>
  262. private void chkDDate_CheckedChanged(object sender, EventArgs e)
  263. {
  264. if (this.chkDDate.Checked)
  265. {
  266. this.dtpDDateStart.Enabled = true;
  267. this.dtpDDateEnd.Enabled = true;
  268. }
  269. else
  270. {
  271. this.dtpDDateStart.Enabled = false;
  272. this.dtpDDateEnd.Enabled = false;
  273. this.dtpDDateStart.Value = DateTime.Now.Date;
  274. this.dtpDDateEnd.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1);
  275. }
  276. }
  277. /// <summary>
  278. /// 注浆时间选中改变事件
  279. /// </summary>
  280. /// <param name="sender"></param>
  281. /// <param name="e"></param>
  282. private void chkGDate_CheckedChanged(object sender, EventArgs e)
  283. {
  284. if (this.chkGDate.Checked)
  285. {
  286. this.dtpGDateStart.Enabled = true;
  287. this.dtpGDateEnd.Enabled = true;
  288. }
  289. else
  290. {
  291. this.dtpGDateStart.Enabled = false;
  292. this.dtpGDateEnd.Enabled = false;
  293. this.dtpGDateStart.Value = DateTime.Now.Date;
  294. this.dtpGDateEnd.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1);
  295. }
  296. }
  297. /// <summary>
  298. /// 审核日期
  299. /// </summary>
  300. /// <param name="sender"></param>
  301. /// <param name="e"></param>
  302. private void chkAuditDate_CheckedChanged(object sender, EventArgs e)
  303. {
  304. if (this.chkAuditDate.Checked)
  305. {
  306. this.dtpAuditDateStart.Enabled = true;
  307. this.dtpAuditDateEnd.Enabled = true;
  308. }
  309. else
  310. {
  311. this.dtpAuditDateStart.Enabled = false;
  312. this.dtpAuditDateEnd.Enabled = false;
  313. this.dtpAuditDateStart.Value = DateTime.Now.Date;
  314. this.dtpAuditDateEnd.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1);
  315. }
  316. }
  317. #endregion
  318. #region 私有方法
  319. /// <summary>
  320. /// 搜索条件
  321. /// </summary>
  322. /// <returns></returns>
  323. private void CreateSearchCondition()
  324. {
  325. _rptse = new RPT030102_SE();
  326. _rptse.ProductionLineID = this.dkproductionLineSearchBox.ProductionLineID;
  327. _rptse.GoodsTypeCode = scbGoodsType.SearchedValue + "";
  328. _rptse.GoodsCode = this.txtGoodCode.Text.Trim();
  329. _rptse.ProcedureIDS = this.dkProcedureSearchBox.ProcedureIDS;
  330. if (this.chkScrapDateStart.Checked)
  331. {
  332. _rptse.ScrapDateStart = DateTime.Parse(this.dtpScrapDateStart.Value.ToString("yyyy-MM-dd HH:mm") + ":00");
  333. _rptse.ScrapDateEnd = DateTime.Parse(this.dtpScrapDateEnd.Value.ToString("yyyy-MM-dd HH:mm") + ":59");
  334. }
  335. if (this.chkPDate.Checked)
  336. {
  337. _rptse.CTimeStart = DateTime.Parse(this.dtpCDateStart.Value.ToString("yyyy-MM-dd HH:mm") + ":00");
  338. _rptse.CTimeEnd = DateTime.Parse(this.dtpCDateEnd.Value.ToString("yyyy-MM-dd HH:mm") + ":59");
  339. }
  340. if (this.chkDDate.Checked)
  341. {
  342. _rptse.DTimeStart = DateTime.Parse(this.dtpDDateStart.Value.ToString("yyyy-MM-dd HH:mm") + ":00");
  343. _rptse.DTimeEnd = DateTime.Parse(this.dtpDDateEnd.Value.ToString("yyyy-MM-dd HH:mm") + ":59");
  344. }
  345. if (this.chkGDate.Checked)
  346. {
  347. _rptse.GTimeStart = DateTime.Parse(this.dtpGDateStart.Value.ToString("yyyy-MM-dd HH:mm") + ":00");
  348. _rptse.GTimeEnd = DateTime.Parse(this.dtpGDateEnd.Value.ToString("yyyy-MM-dd HH:mm") + ":59");
  349. }
  350. if (this.chkAuditDate.Checked)
  351. {
  352. _rptse.AuditTimeStart = DateTime.Parse(this.dtpAuditDateStart.Value.ToString("yyyy-MM-dd HH:mm") + ":00");
  353. _rptse.AuditTimeEnd = DateTime.Parse(this.dtpAuditDateEnd.Value.ToString("yyyy-MM-dd HH:mm") + ":59");
  354. }
  355. _rptse.ResponProcedureIDS = this.dkResponProcedureSearchBox.ProcedureIDS;
  356. _rptse.ResponUserIDS = this.dkResponUserInfoSearchBox.UserIDS;
  357. _rptse.CreatUser = this.txtCreatUser.Text.Trim();
  358. _rptse.AuditUser = this.txtAuditUser.Text.Trim();
  359. _rptse.SpecialRepairFlag = this.chkSpecialRepairFlag.Checked;
  360. _rptse.ReFireFlag = this.chkReFireFlag.Checked;
  361. }
  362. /// <summary>
  363. /// 查询损坏明细表
  364. /// </summary>
  365. private DataTable GetSearchDetailData()
  366. {
  367. try
  368. {
  369. // 调用服务器端获取数据集
  370. ServiceResultEntity sre = DoAsync<ServiceResultEntity>(() =>
  371. {
  372. return ReportModuleProxy.Service.GetRPT030102IData(this._rptse);
  373. }
  374. );
  375. if (sre.Status == Constant.ServiceResultStatus.Success)
  376. {
  377. if (sre.Data.Tables[0].Rows.Count <= Constant.INT_IS_ZERO)
  378. {
  379. // 提示未查找到数据
  380. MessageBox.Show(Messages.MSG_CMN_I002, this.Text,
  381. MessageBoxButtons.OK, MessageBoxIcon.Warning);
  382. //清空数据
  383. return null;
  384. }
  385. return sre.Data.Tables[0];
  386. }
  387. return null;
  388. }
  389. catch (Exception ex)
  390. {
  391. throw ex;
  392. }
  393. }
  394. /// <summary>
  395. /// 获取权限
  396. /// </summary>
  397. protected void getPurview()
  398. {
  399. try
  400. {
  401. StringBuilder sbProcedurePurview = new StringBuilder();
  402. //得到工序查看权限
  403. DataSet dsProcedurePurview = (DataSet)DoAsync(new AsyncMethod(() =>
  404. {
  405. return SystemModuleProxy.Service.GetUserPurview(9, LogInUserInfo.CurrentUser.UserID);
  406. }));
  407. if (dsProcedurePurview != null)
  408. {
  409. foreach (DataRow dr in dsProcedurePurview.Tables[Constant.INT_IS_ZERO].Rows)
  410. {
  411. sbProcedurePurview.Append(dr[Constant.INT_IS_ZERO].ToString() + ",");
  412. }
  413. if (sbProcedurePurview.Length != Constant.INT_IS_ZERO)
  414. {
  415. this.dkResponProcedureSearchBox.Purview = sbProcedurePurview.ToString().Substring(Constant.INT_IS_ZERO, sbProcedurePurview.Length - 1);
  416. //this.dkResponProcedureSearchBox.ProcedureIDS = sbProcedurePurview.ToString().Substring(Constant.INT_IS_ZERO, sbProcedurePurview.Length - 1);
  417. this._currentUserPurview = sbProcedurePurview.ToString().Substring(Constant.INT_IS_ZERO, sbProcedurePurview.Length - 1);
  418. }
  419. }
  420. }
  421. catch (Exception ex)
  422. {
  423. throw ex;
  424. }
  425. }
  426. /// <summary>
  427. /// 获取权限(生产线)
  428. /// </summary>
  429. protected void getPurviewLine()
  430. {
  431. try
  432. {
  433. StringBuilder sbProcedurePurview = new StringBuilder();
  434. //得到工序查看权限
  435. DataSet dsProcedurePurview = (DataSet)DoAsync(new AsyncMethod(() =>
  436. {
  437. return SystemModuleProxy.Service.GetUserPurview(7, LogInUserInfo.CurrentUser.UserID);
  438. }));
  439. if (dsProcedurePurview != null)
  440. {
  441. foreach (DataRow dr in dsProcedurePurview.Tables[Constant.INT_IS_ZERO].Rows)
  442. {
  443. sbProcedurePurview.Append(dr[Constant.INT_IS_ZERO].ToString() + ",");
  444. }
  445. if (sbProcedurePurview.Length != Constant.INT_IS_ZERO)
  446. {
  447. this.dkproductionLineSearchBox.Purview = sbProcedurePurview.ToString().Substring(Constant.INT_IS_ZERO, sbProcedurePurview.Length - 1);
  448. //this.dkproductionLineSearchBox.ProductionLineIDS = sbProcedurePurview.ToString().Substring(Constant.INT_IS_ZERO, sbProcedurePurview.Length - 1);
  449. this._currentUserLinePuview = sbProcedurePurview.ToString().Substring(Constant.INT_IS_ZERO, sbProcedurePurview.Length - 1);
  450. }
  451. }
  452. }
  453. catch (Exception ex)
  454. {
  455. throw ex;
  456. }
  457. }
  458. #endregion
  459. }
  460. }