IMEX.mes.wcf/DK.Client/ReportModule/R03/M01/F_RPT_030119.cs

/*******************************************************************************
 * Copyright(c) 2016 DongkeSoft All rights reserved. / Confidential
 * 类的信息：
 *      1.程序名称：F_RPT_030119.cs
 *      2.功能描述：半检返修缺陷汇总表
 * 编辑履历：
 *      作者            日期                版本            修改内容
 *      陈晓野          2017/12/26          1.00            新建
 *******************************************************************************/
using System;
using System.Collections.Generic;
using System.Data;
using System.Reflection;
using System.Windows.Forms;
using Dongke.IBOSS.PRD.Basics.BaseResources;
using Dongke.IBOSS.PRD.Client.CommonModule;
using Dongke.IBOSS.PRD.Client.Controls;
using Dongke.IBOSS.PRD.Client.DataModels;
using Dongke.IBOSS.PRD.WCF.DataModels;
using Dongke.IBOSS.PRD.WCF.Proxys;

namespace Dongke.IBOSS.PRD.Client.ReportModule
{
    /// <summary>
    /// 半检返修缺陷汇总表
    /// </summary>
    public partial class F_RPT_030119 : DKDockPanelBase
	{
		#region 成员变量
		private static F_RPT_030119 _instance = null;
		#endregion

		#region 单例模式

		/// <summary>
		/// 单例模式，防止重复创建窗体
		/// </summary>
		public static F_RPT_030119 Instance
		{
			get
			{
				if (_instance == null)
				{
					_instance = new F_RPT_030119();
				}
				return _instance;
			}
		}

		#endregion

		#region 构造函数
		/// <summary>
		/// 
		/// </summary>
		public F_RPT_030119()
		{
			InitializeComponent();
			this.Text = "半检返修缺陷汇总表";

			this.tsbtnAdaptive.Text = ButtonText.TSBTN_ADAPTIVE;
			this.tsbtnClose.Text = ButtonText.TSBTN_CLOSE;

			this.dgvSum.AutoGenerateColumns = false;
		}
		#endregion

		#region 控件事件
		/// <summary>
		/// 关闭
		/// </summary>
		/// <param name="sender"></param>
		/// <param name="e"></param>
		private void F_PC_1001_FormClosed(object sender, FormClosedEventArgs e)
		{
			_instance = null;
		}

		/// <summary>
		/// 画面加载
		/// </summary>
		/// <param name="sender"></param>
		/// <param name="e"></param>
		private void F_PC_1001_Load(object sender, System.EventArgs e)
		{
			try
            {
                this.txtSemiCheckDateTimeStart.Value = DateTime.Now.Date;
                this.txtSemiCheckDateTimeEnd.Value = this.txtSemiCheckDateTimeStart.Value.AddDays(1).AddSeconds(-1);
            }
			catch (Exception ex)
			{
				// 对异常进行共通处理
				ExceptionManager.HandleEventException(this.ToString(),
					MethodBase.GetCurrentMethod().Name, this.Text, ex);
			}
		}

		/// <summary>
		/// 查询
		/// </summary>
		/// <param name="sender"></param>
		/// <param name="e"></param>
		private void tsbtnSearch_Click(object sender, EventArgs e)
		{
			try
			{
				this.dgvSum.DataSource = null;
                this.dgvSum.Columns.Clear();
                this.dgvSum.Columns.Add(this.defectcode);
                this.dgvSum.Columns.Add(this.defectname);
                this.QueryDataFromOther();
                this.dgvSum.AutoResizeColumns();
            }
			catch (Exception ex)
			{
				// 对异常进行共通处理
				ExceptionManager.HandleEventException(this.ToString(),
					MethodBase.GetCurrentMethod().Name, this.Text, ex);
			}
		}

		/// <summary>
		/// 清除条件
		/// </summary>
		/// <param name="sender"></param>
		/// <param name="e"></param>
		private void tsbtnClearCondition_Click(object sender, EventArgs e)
        {
            this.txtGoodsCode.ClearValue();
            this.txtGroutingUserCode.ClearControl();
            this.txtSemiCheckDateTimeStart.Value = DateTime.Now.Date;
            this.txtSemiCheckDateTimeEnd.Value = this.txtSemiCheckDateTimeStart.Value.AddDays(1).AddSeconds(-1);

            this.txtSemiCheckUserCode.ClearControl();
            this.txtDefectCode.ClearControl();
            this.dkSemiCheckDefectPositionSearchBox1.ClearControl();
            this.scbGoodsType.ClearValue();
            this.txtGoodsCode.ClearValue();
        }

		/// <summary>
		/// 自适应列宽
		/// </summary>
		/// <param name="sender"></param>
		/// <param name="e"></param>
		private void tsbtnAdaptive_Click(object sender, EventArgs e)
		{
			this.dgvSum.AutoResizeColumns();
		}

		/// <summary>
		/// 关闭画面
		/// </summary>
		/// <param name="sender"></param>
		/// <param name="e"></param>
		private void tsbtnClose_Click(object sender, EventArgs e)
		{
			this.Close();
		}
		#endregion

		#region 私有方法

		/// <summary>
		/// 查询数据
		/// </summary>
		private void QueryDataFromOther()
		{
			try
			{
				this.tsrToolStrip1.Focus();
				ClientRequestEntity cre = new ClientRequestEntity();
				cre.NameSpace = "R03";
				cre.Name = "R030119Data";

                // 半检日期
                cre.Properties["SemireWorkTimeBegin"] = this.txtSemiCheckDateTimeStart.Value;
                cre.Properties["SemireWorkTimeEnd"] = this.txtSemiCheckDateTimeEnd.Value.AddSeconds(1);
                // 产品编码 GOODSCODE
                cre.Properties["GOODSCODE"] = this.txtGoodsCode.CheckedValue;
                // 成型工号 GROUTINGUSERCODE
                // xuwei modify 2019-11-13
                //cre.Properties["GROUTINGUSERCODE"] = this.txtGroutingUserCode.Text.Trim();
                cre.Properties["GROUTINGUSERCODE"] = this.txtGroutingUserCode.UserCode.Trim();
                // xuwei end
                // 半检工号 SEMIREWORKUSERCODE
                // xuwei modify 2019-11-13
                //cre.Properties["SEMIREWORKUSERCODE"] = this.txtSemiCheckUserCode.Text.Trim();
                cre.Properties["SEMIREWORKUSERCODE"] = this.txtSemiCheckUserCode.UserCode.Trim();
                // xuwei end
                // 缺陷位置 scdp.defectpositionname
                //cre.Properties["defectpositionname"] = dkSemiCheckDefectPositionSearchBox1.DefectPositionIDS;
                cre.Properties["defectpositionIDS"] = dkSemiCheckDefectPositionSearchBox1.DefectPositionIDS;
                // 缺陷名称 scd.defectname
                //cre.Properties["defectname"] = this.txtDefectCode.Text.Trim();
                cre.Properties["defectcode"] = this.txtDefectCode.Text;

                //产品类型 xuwei add 2019-11-29
                //cre.Properties["GOODSTYPEID"] = this.scbGoodsType.SearchedValue;
                cre.Properties["GOODSTYPECODE"] = this.scbGoodsType.SearchedValue;

                //返修工序 xuwei add 2019-11-29
                cre.Properties["REWORKPROCEDUREID"] = this.dkProcedureSearchBox.ProcedureIDS;

                ServiceResultEntity sre = DoAsync<ServiceResultEntity>(() =>
					{
						return ReportModuleProxy.Service.DoRequest(cre);
					}
				);

				if (sre.Status == Constant.ServiceResultStatus.Success)
                {
                    foreach (DataColumn item in sre.Data.Tables[0].Columns)
                    {
                        if (!item.ColumnName.StartsWith("D_"))
                        {
                            continue;
                        }

                        DataGridViewTextBoxColumn dgvCol = new DataGridViewTextBoxColumn();
                        dgvCol.Name = item.ColumnName;
                        dgvCol.HeaderText = item.Caption;
                        dgvCol.ReadOnly = true;
                        dgvCol.SortMode = DataGridViewColumnSortMode.Automatic;
                        dgvCol.DataPropertyName = item.ColumnName;
                        dgvCol.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
                        dgvCol.DefaultCellStyle.Format = "N0";
                        dgvCol.DefaultCellStyle.NullValue = "0";
                        this.dgvSum.Columns.Add(dgvCol);
                    }

                    // 查询成功
                    this.dgvSum.DataSource = sre.Data.Tables[0];
				}
			}
			catch (Exception ex)
			{
				throw ex;
			}
		}
        #endregion
    }
}