F_RPT_030119.cs 7.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235
  1. /*******************************************************************************
  2. * Copyright(c) 2016 DongkeSoft All rights reserved. / Confidential
  3. * 类的信息:
  4. * 1.程序名称:F_RPT_030119.cs
  5. * 2.功能描述:半检返修缺陷汇总表
  6. * 编辑履历:
  7. * 作者 日期 版本 修改内容
  8. * 陈晓野 2017/12/26 1.00 新建
  9. *******************************************************************************/
  10. using System;
  11. using System.Collections.Generic;
  12. using System.Data;
  13. using System.Reflection;
  14. using System.Windows.Forms;
  15. using Dongke.IBOSS.PRD.Basics.BaseResources;
  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_030119 : DKDockPanelBase
  27. {
  28. #region 成员变量
  29. private static F_RPT_030119 _instance = null;
  30. #endregion
  31. #region 单例模式
  32. /// <summary>
  33. /// 单例模式,防止重复创建窗体
  34. /// </summary>
  35. public static F_RPT_030119 Instance
  36. {
  37. get
  38. {
  39. if (_instance == null)
  40. {
  41. _instance = new F_RPT_030119();
  42. }
  43. return _instance;
  44. }
  45. }
  46. #endregion
  47. #region 构造函数
  48. /// <summary>
  49. ///
  50. /// </summary>
  51. public F_RPT_030119()
  52. {
  53. InitializeComponent();
  54. this.Text = "半检返修缺陷汇总表";
  55. this.tsbtnAdaptive.Text = ButtonText.TSBTN_ADAPTIVE;
  56. this.tsbtnClose.Text = ButtonText.TSBTN_CLOSE;
  57. this.dgvSum.AutoGenerateColumns = false;
  58. }
  59. #endregion
  60. #region 控件事件
  61. /// <summary>
  62. /// 关闭
  63. /// </summary>
  64. /// <param name="sender"></param>
  65. /// <param name="e"></param>
  66. private void F_PC_1001_FormClosed(object sender, FormClosedEventArgs e)
  67. {
  68. _instance = null;
  69. }
  70. /// <summary>
  71. /// 画面加载
  72. /// </summary>
  73. /// <param name="sender"></param>
  74. /// <param name="e"></param>
  75. private void F_PC_1001_Load(object sender, System.EventArgs e)
  76. {
  77. try
  78. {
  79. this.txtSemiCheckDateTimeStart.Value = DateTime.Now.Date;
  80. this.txtSemiCheckDateTimeEnd.Value = this.txtSemiCheckDateTimeStart.Value.AddDays(1).AddSeconds(-1);
  81. }
  82. catch (Exception ex)
  83. {
  84. // 对异常进行共通处理
  85. ExceptionManager.HandleEventException(this.ToString(),
  86. MethodBase.GetCurrentMethod().Name, this.Text, ex);
  87. }
  88. }
  89. /// <summary>
  90. /// 查询
  91. /// </summary>
  92. /// <param name="sender"></param>
  93. /// <param name="e"></param>
  94. private void tsbtnSearch_Click(object sender, EventArgs e)
  95. {
  96. try
  97. {
  98. this.dgvSum.DataSource = null;
  99. this.dgvSum.Columns.Clear();
  100. this.dgvSum.Columns.Add(this.defectcode);
  101. this.dgvSum.Columns.Add(this.defectname);
  102. this.QueryDataFromOther();
  103. this.dgvSum.AutoResizeColumns();
  104. }
  105. catch (Exception ex)
  106. {
  107. // 对异常进行共通处理
  108. ExceptionManager.HandleEventException(this.ToString(),
  109. MethodBase.GetCurrentMethod().Name, this.Text, ex);
  110. }
  111. }
  112. /// <summary>
  113. /// 清除条件
  114. /// </summary>
  115. /// <param name="sender"></param>
  116. /// <param name="e"></param>
  117. private void tsbtnClearCondition_Click(object sender, EventArgs e)
  118. {
  119. this.txtGoodsCode.Text = string.Empty;
  120. this.txtGroutingUserCode.Text = string.Empty;
  121. this.txtSemiCheckDateTimeStart.Value = DateTime.Now.Date;
  122. this.txtSemiCheckDateTimeEnd.Value = this.txtSemiCheckDateTimeStart.Value.AddDays(1).AddSeconds(-1);
  123. this.txtSemiCheckUserCode.Text = string.Empty;
  124. this.txtDefectCode.Text = string.Empty;
  125. this.dkSemiCheckDefectPositionSearchBox1.ClearControl();
  126. }
  127. /// <summary>
  128. /// 自适应列宽
  129. /// </summary>
  130. /// <param name="sender"></param>
  131. /// <param name="e"></param>
  132. private void tsbtnAdaptive_Click(object sender, EventArgs e)
  133. {
  134. this.dgvSum.AutoResizeColumns();
  135. }
  136. /// <summary>
  137. /// 关闭画面
  138. /// </summary>
  139. /// <param name="sender"></param>
  140. /// <param name="e"></param>
  141. private void tsbtnClose_Click(object sender, EventArgs e)
  142. {
  143. this.Close();
  144. }
  145. #endregion
  146. #region 私有方法
  147. /// <summary>
  148. /// 查询数据
  149. /// </summary>
  150. private void QueryDataFromOther()
  151. {
  152. try
  153. {
  154. this.tsrToolStrip1.Focus();
  155. ClientRequestEntity cre = new ClientRequestEntity();
  156. cre.NameSpace = "R03";
  157. cre.Name = "R030119Data";
  158. // 半检日期
  159. cre.Properties["SemireWorkTimeBegin"] = this.txtSemiCheckDateTimeStart.Value;
  160. cre.Properties["SemireWorkTimeEnd"] = this.txtSemiCheckDateTimeEnd.Value.AddSeconds(1);
  161. // 产品编码 GOODSCODE
  162. cre.Properties["GOODSCODE"] = this.txtGoodsCode.Text.Trim();
  163. // 成型工号 GROUTINGUSERCODE
  164. // xuwei modify 2019-11-13
  165. //cre.Properties["GROUTINGUSERCODE"] = this.txtGroutingUserCode.Text.Trim();
  166. cre.Properties["GROUTINGUSERCODE"] = this.txtGroutingUserCode.UserCode.Trim();
  167. // xuwei end
  168. // 半检工号 SEMIREWORKUSERCODE
  169. // xuwei modify 2019-11-13
  170. //cre.Properties["SEMIREWORKUSERCODE"] = this.txtSemiCheckUserCode.Text.Trim();
  171. cre.Properties["SEMIREWORKUSERCODE"] = this.txtSemiCheckUserCode.UserCode.Trim();
  172. // xuwei end
  173. // 缺陷位置 scdp.defectpositionname
  174. //cre.Properties["defectpositionname"] = dkSemiCheckDefectPositionSearchBox1.DefectPositionIDS;
  175. cre.Properties["defectpositionIDS"] = dkSemiCheckDefectPositionSearchBox1.DefectPositionIDS;
  176. // 缺陷名称 scd.defectname
  177. //cre.Properties["defectname"] = this.txtDefectCode.Text.Trim();
  178. cre.Properties["defectcode"] = this.txtDefectCode.Text.Trim();
  179. ServiceResultEntity sre = DoAsync<ServiceResultEntity>(() =>
  180. {
  181. return ReportModuleProxy.Service.DoRequest(cre);
  182. }
  183. );
  184. if (sre.Status == Constant.ServiceResultStatus.Success)
  185. {
  186. foreach (DataColumn item in sre.Data.Tables[0].Columns)
  187. {
  188. if (!item.ColumnName.StartsWith("D_"))
  189. {
  190. continue;
  191. }
  192. DataGridViewTextBoxColumn dgvCol = new DataGridViewTextBoxColumn();
  193. dgvCol.Name = item.ColumnName;
  194. dgvCol.HeaderText = item.Caption;
  195. dgvCol.ReadOnly = true;
  196. dgvCol.SortMode = DataGridViewColumnSortMode.Automatic;
  197. dgvCol.DataPropertyName = item.ColumnName;
  198. dgvCol.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
  199. dgvCol.DefaultCellStyle.Format = "N0";
  200. dgvCol.DefaultCellStyle.NullValue = "0";
  201. this.dgvSum.Columns.Add(dgvCol);
  202. }
  203. // 查询成功
  204. this.dgvSum.DataSource = sre.Data.Tables[0];
  205. }
  206. }
  207. catch (Exception ex)
  208. {
  209. throw ex;
  210. }
  211. }
  212. #endregion
  213. }
  214. }