F_RPT_080109.cs 11 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339
  1. /*******************************************************************************
  2. * Copyright(c) 2015 DongkeSoft All rights reserved. / Confidential
  3. * 类的信息:
  4. * 1.程序名称:F_RPT_080109.cs
  5. * 2.功能描述:半成检缺陷对照表
  6. * 编辑履历:
  7. * 作者 日期 版本 修改内容
  8. * 王鑫 2015/06/13 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. public partial class F_RPT_080109 : DKDockPanelBase
  24. {
  25. #region 成员变量
  26. // 窗体的单例模式
  27. private static F_RPT_080109 _instance;
  28. //实体类
  29. private RPT030106_SE rptse = null;
  30. //默认清空工序,重置回用户当前权限工序
  31. private string _currentUserPurview = null;
  32. //默认清空生产线,重置回用户当前权限生产线
  33. private string _currentUserLinePuview = null;
  34. //默认清空查看工号,重置回用户当前权限工号
  35. private string _currentUserCodePuview = null;
  36. #endregion
  37. #region 构造函数
  38. public F_RPT_080109()
  39. {
  40. InitializeComponent();
  41. // 窗体显示的Title
  42. this.Text = "半成检缺陷对照表";
  43. this.tsbtnAdaptive.Text = ButtonText.TSBTN_ADAPTIVE;
  44. this.tsbtnClose.Text = ButtonText.TSBTN_CLOSE;
  45. this.btnSearch.Text = ButtonText.BTN_SEARCH;
  46. this.btnClearCondition.Text = ButtonText.BTN_CLEARCONDITION;
  47. this.gbxCondition.Text = Constant.LABEL_QUERY_CONDITIONS;
  48. }
  49. #endregion
  50. #region 单例模式
  51. /// <summary>
  52. /// 单例模式,防止重复创建窗体
  53. /// </summary>
  54. public static F_RPT_080109 Instance
  55. {
  56. get
  57. {
  58. if (_instance == null || _instance.IsDisposed)
  59. {
  60. _instance = new F_RPT_080109();
  61. }
  62. return _instance;
  63. }
  64. }
  65. #endregion
  66. #region 事件处理
  67. /// <summary>
  68. /// 窗体加载事件
  69. /// </summary>
  70. /// <param name="sender"></param>
  71. /// <param name="e"></param>
  72. private void F_RPT_080109_Load(object sender, EventArgs e)
  73. {
  74. try
  75. {
  76. // 加载权限
  77. FormPermissionManager.FormPermissionControl(this.Name, this,
  78. LogInUserInfo.CurrentUser.CurrentUserEntity.UserRightData,
  79. LogInUserInfo.CurrentUser.CurrentUserEntity.FunctionData);
  80. // 设置表格不自动创建列
  81. this.dgvDefectDetail.AutoGenerateColumns = false;
  82. // 初始化时间控件为当前日期
  83. this.dtpAccountDateStart.Value = DateTime.Now.Date;
  84. this.dtpAccountDateEnd.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1);
  85. this.dtpHandOverStart.Value = DateTime.Now.Date;
  86. this.dtpHandOverEnd.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1);
  87. this.dtpCheckDateStart.Value = DateTime.Now.Date;
  88. this.dtpCheckDateEnd.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1);
  89. //getPurview();
  90. //getPurviewLine();
  91. // 交接工序
  92. ServiceResultEntity sresource = ReportModuleProxy.Service.GetRptProcedureModule();
  93. if (sresource != null && sresource.Data != null && sresource.Data.Tables.Count > 0)
  94. {
  95. this.dropRptProcedure.DataSource = sresource.Data.Tables[0];
  96. this.dropRptProcedure.ValueMember = "Rptprocedureid";
  97. this.dropRptProcedure.DisplayMember = "Rptprocedurename";
  98. }
  99. }
  100. catch (Exception ex)
  101. {
  102. // 对异常进行共通处理
  103. ExceptionManager.HandleEventException(this.ToString(),
  104. System.Reflection.MethodBase.GetCurrentMethod().Name, this.Text, ex);
  105. }
  106. }
  107. /// <summary>
  108. /// 自动适应列宽
  109. /// </summary>
  110. /// <param name="sender"></param>
  111. /// <param name="e"></param>
  112. private void tsbtnAdaptive_Click(object sender, EventArgs e)
  113. {
  114. this.dgvDefectDetail.AutoResizeColumns();
  115. }
  116. /// <summary>
  117. /// 窗体关闭事件
  118. /// </summary>
  119. /// <param name="sender"></param>
  120. /// <param name="e"></param>
  121. private void F_RPT_080109_FormClosed(object sender, FormClosedEventArgs e)
  122. {
  123. _instance = null;
  124. }
  125. /// <summary>
  126. /// 关闭按钮
  127. /// </summary>
  128. /// <param name="sender"></param>
  129. /// <param name="e"></param>
  130. private void tsbtnClose_Click(object sender, EventArgs e)
  131. {
  132. this.Close();
  133. }
  134. /// <summary>
  135. /// 查询按钮事件
  136. /// </summary>
  137. /// <param name="sender"></param>
  138. /// <param name="e"></param>
  139. private void btnSearch_Click(object sender, EventArgs e)
  140. {
  141. try
  142. {
  143. //没有对应的生产线权限,返回 因为有无责任工序,则可以不用分配工序的权限,不分配,只能查无责任工序
  144. //if (string.IsNullOrEmpty(this._currentUserLinePuview))
  145. //{
  146. // // 提示未查找到数据
  147. // MessageBox.Show(Messages.MSG_CMN_I002, this.Text,
  148. // MessageBoxButtons.OK, MessageBoxIcon.Information);
  149. // return;
  150. //}
  151. // 交接工序必须输入项
  152. if (this.dropRptProcedure.SelectedValue == null)
  153. {
  154. MessageBox.Show(Messages.MSG_CMN_W005, this.Text,
  155. MessageBoxButtons.OK, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button1);
  156. return;
  157. }
  158. // 登记时间与交接时间必须选择一个
  159. if ((!this.chkCdate.Checked && (this.chkCheckDate.Enabled && !this.chkCheckDate.Checked)) && !this.chkHandOver.Checked)
  160. {
  161. MessageBox.Show("(缺陷)登记时间与交接时间至少选择一个作为查询条件。", this.Text,
  162. MessageBoxButtons.OK, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button1);
  163. return;
  164. }
  165. CreateSearchCondition();
  166. this.dgvDefectDetail.DataSource = null;
  167. this.dgvDefectDetail.DataSource = GetSearchDefectData();
  168. }
  169. catch (Exception ex)
  170. {
  171. this.btnSearch.Enabled = true;
  172. this.btnClearCondition.Enabled = true;
  173. // 对异常进行共通处理
  174. ExceptionManager.HandleEventException(this.ToString(),
  175. System.Reflection.MethodBase.GetCurrentMethod().Name, this.Text, ex);
  176. }
  177. }
  178. /// <summary>
  179. /// 清空条件按钮事件
  180. /// </summary>
  181. /// <param name="sender"></param>
  182. /// <param name="e"></param>
  183. private void btnClearCondition_Click(object sender, EventArgs e)
  184. {
  185. this.scbGoods.ClearValue();
  186. this.scbGoodsType.ClearValue();
  187. this.dkProcedureSearchBox.ClearControl();
  188. this.dkDefectTypeNameSearchBox1.ClearControl();
  189. this.dtpAccountDateStart.Value = DateTime.Now.Date;
  190. this.dtpAccountDateEnd.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1);
  191. this.dtpHandOverStart.Value = DateTime.Now.Date;
  192. this.dtpHandOverEnd.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1);
  193. this.dtpCheckDateStart.Value = DateTime.Now.Date;
  194. this.dtpCheckDateEnd.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1);
  195. this.chkCdate.Checked = true;
  196. this.chkHandOver.Checked = false;
  197. this.chkCheckDate.Checked = false;
  198. this.dkCheckProcedureSearchBox.ClearControl();
  199. this.txtKilnCode.Clear();
  200. this.txtDefectUserCode.Text = "";
  201. this.txtDefectCode.Text = "";
  202. this.txtCheckUserCode.Text = "";
  203. this.txtDefectName.Text = "";
  204. this.txtGoodsCode.Text = "";
  205. this.dkProcedureSearchBox.ProcedureIDS = this._currentUserPurview;
  206. if (this.dropRptProcedure.Items.Count > 0)
  207. {
  208. this.dropRptProcedure.SelectedIndex = 0;
  209. }
  210. }
  211. private void chkCdate_CheckedChanged(object sender, EventArgs e)
  212. {
  213. this.dtpAccountDateStart.Value = DateTime.Now.Date;
  214. this.dtpAccountDateEnd.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1);
  215. this.dtpAccountDateStart.Enabled = this.chkCdate.Checked;
  216. this.dtpAccountDateEnd.Enabled = this.chkCdate.Checked;
  217. }
  218. private void chkHandOver_CheckedChanged(object sender, EventArgs e)
  219. {
  220. this.dtpHandOverStart.Value = DateTime.Now.Date;
  221. this.dtpHandOverEnd.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1);
  222. this.dtpHandOverStart.Enabled = this.chkHandOver.Checked;
  223. this.dtpHandOverEnd.Enabled = this.chkHandOver.Checked;
  224. }
  225. private void chkCheckDate_CheckedChanged(object sender, EventArgs e)
  226. {
  227. this.dtpCheckDateStart.Value = DateTime.Now.Date;
  228. this.dtpCheckDateEnd.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1);
  229. this.dtpCheckDateStart.Enabled = this.chkCheckDate.Checked;
  230. this.dtpCheckDateEnd.Enabled = this.chkCheckDate.Checked;
  231. }
  232. #endregion
  233. #region 私有方法
  234. /// <summary>
  235. /// 搜索条件
  236. /// </summary>
  237. /// <returns></returns>
  238. private void CreateSearchCondition()
  239. {
  240. rptse = new RPT030106_SE();
  241. rptse.GoodsTypeCode = scbGoodsType.SearchedValue + "";
  242. rptse.DefectProcedureIDS = this.dkProcedureSearchBox.ProcedureIDS;
  243. //rptse.PurViewUserCodeIDS = this._currentUserCodePuview;//默认查看对应权限工号
  244. if (this.chkCdate.Checked)
  245. {
  246. rptse.CreateTimeStart = DateTime.Parse(this.dtpAccountDateStart.Value.ToString("yyyy-MM-dd HH:mm") + ":00");
  247. rptse.CreateTimeEnd = DateTime.Parse(this.dtpAccountDateEnd.Value.ToString("yyyy-MM-dd HH:mm") + ":59");
  248. }
  249. rptse.DefectTypeIDS = this.dkDefectTypeNameSearchBox1.DefectTypeIDS;
  250. rptse.DefectUserCode = this.txtDefectUserCode.Text.Trim();
  251. rptse.CheckUserCode = this.txtCheckUserCode.Text.Trim();
  252. rptse.DefectCode = this.txtDefectCode.Text.Trim();
  253. rptse.DefectName = this.txtDefectName.Text.Trim();
  254. rptse.GoodsCode = this.txtGoodsCode.Text.Trim();
  255. rptse.GoodsIDS = scbGoods.CheckedPKMember;
  256. if (this.dropRptProcedure.SelectedValue != null)
  257. {
  258. rptse.HandOverProcedureID = Convert.ToInt32(this.dropRptProcedure.SelectedValue);
  259. }
  260. if (this.chkHandOver.Checked)
  261. {
  262. rptse.HandOverTimeStart = DateTime.Parse(this.dtpHandOverStart.Value.ToString("yyyy-MM-dd HH:mm") + ":00");
  263. rptse.HandOverTimeEnd = DateTime.Parse(this.dtpHandOverEnd.Value.ToString("yyyy-MM-dd HH:mm") + ":59");
  264. }
  265. if (this.chkCheckDate.Enabled && this.chkCheckDate.Checked)
  266. {
  267. rptse.CheckTimeStart = DateTime.Parse(this.dtpCheckDateStart.Value.ToString("yyyy-MM-dd HH:mm") + ":00");
  268. rptse.CheckTimeEnd = DateTime.Parse(this.dtpCheckDateEnd.Value.ToString("yyyy-MM-dd HH:mm") + ":59");
  269. }
  270. rptse.CheckProcedureIDS = this.dkCheckProcedureSearchBox.ProcedureIDS;
  271. rptse.KilnCode = this.txtKilnCode.Text.Trim();
  272. }
  273. /// <summary>
  274. /// 查询缺陷登记明细表
  275. /// </summary>
  276. private DataTable GetSearchDefectData()
  277. {
  278. try
  279. {
  280. // 调用服务器端获取数据集
  281. ServiceResultEntity sre = DoAsync<ServiceResultEntity>(() =>
  282. {
  283. return ReportModuleProxy.Service.GetRPT080109DData(rptse);
  284. }
  285. );
  286. if (sre.Status == Constant.ServiceResultStatus.Success)
  287. {
  288. if (sre.Data.Tables[0].Rows.Count <= Constant.INT_IS_ZERO)
  289. {
  290. // 提示未查找到数据
  291. MessageBox.Show(Messages.MSG_CMN_I002, this.Text,
  292. MessageBoxButtons.OK, MessageBoxIcon.Information);
  293. //清空数据
  294. return null;
  295. }
  296. return sre.Data.Tables[0];
  297. }
  298. return null;
  299. }
  300. catch (Exception ex)
  301. {
  302. throw ex;
  303. }
  304. }
  305. #endregion
  306. }
  307. }