HEGII.ss.mes.wcf/DK.Client/ReportModule/R03/M01/F_RPT_030120.cs

/*******************************************************************************
 * Copyright(c) 2015 DongkeSoft All rights reserved. / Confidential
 * 类的信息：
 *      1.程序名称：F_RPT_030120.cs
 *      2.功能描述：跨车间作业量统汇总表
 * 编辑履历：
 *      作者            日期                版本            修改内容
 *      fy              2022/9/1            1.00            新建
 *******************************************************************************/

using System;
using System.Data;
using System.Text;
using System.Windows.Forms;
using Dongke.IBOSS.PRD.Basics.BaseResources;
using Dongke.IBOSS.PRD.Basics.DockPanel;
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;
using Dongke.IBOSS.PRD.WCF.DataModels.PMModule;

namespace Dongke.IBOSS.PRD.Client.ReportModule
{
	public partial class F_RPT_030120 : DKDockPanelBase
	{
		#region 成员变量

		// 窗体的单例模式
		private static F_RPT_030120 _instance;
		private ClientRequestEntity cre = new ClientRequestEntity();//存储查询条件
        #endregion

        #region 构造函数

        public F_RPT_030120()
		{
			InitializeComponent();
			// 窗体显示的Title
			this.Text = FormTitles.F_RPT_030120;
			this.tsbtnAdaptive.Text = ButtonText.TSBTN_ADAPTIVE;
			this.tsbtnClose.Text = ButtonText.TSBTN_CLOSE;
			this.btnSearch.Text = ButtonText.BTN_SEARCH;
			this.btnClearCondition.Text = ButtonText.BTN_CLEARCONDITION;
			this.gbxCondition.Text = Constant.LABEL_QUERY_CONDITIONS;
		}

		#endregion

		#region 单例模式

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

		#endregion

		#region  事件处理

		/// <summary>
		/// 窗体加载事件
		/// </summary>
		/// <param name="sender"></param>
		/// <param name="e"></param>
		private void F_RPT_030102_1_Load(object sender, EventArgs e)
		{
			try
			{
				// 加载权限
				FormPermissionManager.FormPermissionControl(this.Name, this,
				LogInUserInfo.CurrentUser.CurrentUserEntity.UserRightData,
				LogInUserInfo.CurrentUser.CurrentUserEntity.FunctionData);
				// 设置表格不自动创建列
				this.dgvAll.AutoGenerateColumns = false;
				this.dtpStartTime.Value = DateTime.Now.Date;
				this.dtpEndTime.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1);
				this.chkTestMouldFlag.AllItemCheck();

                //绑定履历类型
                DataTable dtDataCode = new DataTable();
                dtDataCode.Columns.Add("DATACODE");

                DataRow dr = dtDataCode.NewRow();
                dr["DATACODE"] = "";
                dtDataCode.Rows.Add(dr);

                dr = dtDataCode.NewRow();
                dr["DATACODE"] = "30";
                dtDataCode.Rows.Add(dr);

                dr = dtDataCode.NewRow();
                dr["DATACODE"] = "40";
                dtDataCode.Rows.Add(dr);

                dr = dtDataCode.NewRow();
                dr["DATACODE"] = "50";
                dtDataCode.Rows.Add(dr);

                this.cmbDataCode.DataSource = dtDataCode;
                this.cmbDataCode.ValueMember = "DATACODE";
                this.cmbDataCode.DisplayMember = "DATACODE";

                DataTable dtWorkShop = new DataTable();
				dtWorkShop.Columns.Add("WORKSHOPID");
				dtWorkShop.Columns.Add("WORKSHOP");

                DataRow dr2 = dtWorkShop.NewRow();
				dr2["WORKSHOPID"] = "";
				dr2["WORKSHOP"] = "";
                dtWorkShop.Rows.Add(dr2);

                dr2 = dtWorkShop.NewRow();
                dr2["WORKSHOPID"] = "2";
				dr2["WORKSHOP"] = "二车间";
				dtWorkShop.Rows.Add(dr2);

                dr2 = dtWorkShop.NewRow();
                dr2["WORKSHOPID"] = "3";
				dr2["WORKSHOP"] = "三车间";
				dtWorkShop.Rows.Add(dr2);

                this.cmbWorkShop.DataSource = dtWorkShop;
                this.cmbWorkShop.ValueMember = "WORKSHOPID";
                this.cmbWorkShop.DisplayMember = "WORKSHOP";

                DataTable dtItem = new DataTable();
				dtItem.Columns.Add("ITEMIID");
				dtItem.Columns.Add("ITEM");

				DataRow dr3 = dtItem.NewRow();
				dr3["ITEMIID"] = "";
				dr3["ITEM"] = "";
				dtItem.Rows.Add(dr3);

				dr3 = dtItem.NewRow();
				dr3["ITEMIID"] = "1";
				dr3["ITEM"] = "产量";
				dtItem.Rows.Add(dr3);

				dr3 = dtItem.NewRow();
				dr3["ITEMIID"] = "2";
				dr3["ITEM"] = "产量撤销";
				dtItem.Rows.Add(dr3);

				dr3 = dtItem.NewRow();
				dr3["ITEMIID"] = "3";
				dr3["ITEM"] = "工序报损";
				dtItem.Rows.Add(dr3);

				dr3 = dtItem.NewRow();
				dr3["ITEMIID"] = "4";
				dr3["ITEM"] = "工序报损撤销";
				dtItem.Rows.Add(dr3);

				dr3 = dtItem.NewRow();
				dr3["ITEMIID"] = "5";
				dr3["ITEM"] = "盘点清除";
				dtItem.Rows.Add(dr3);

				dr3 = dtItem.NewRow();
				dr3["ITEMIID"] = "6";
				dr3["ITEM"] = "干补";
				dtItem.Rows.Add(dr3);

				dr3 = dtItem.NewRow();
				dr3["ITEMIID"] = "7";
				dr3["ITEM"] = "回收";
				dtItem.Rows.Add(dr3);

				this.cmbItem.DataSource = dtItem;
				this.cmbItem.ValueMember = "ITEMIID";
				this.cmbItem.DisplayMember = "ITEM";
			}
			catch (Exception ex)
			{
				// 对异常进行共通处理
				ExceptionManager.HandleEventException(this.ToString(),
					System.Reflection.MethodBase.GetCurrentMethod().Name, this.Text, ex);
			}
		}

		/// <summary>
		/// 窗体关闭事件
		/// </summary>
		/// <param name="sender"></param>
		/// <param name="e"></param>
		private void F_RPT_030102_1_FormClosed(object sender, FormClosedEventArgs e)
		{
			_instance = null;
		}

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

		/// <summary>
		/// 自动适应列宽
		/// </summary>
		/// <param name="sender"></param>
		/// <param name="e"></param>
		private void tsbtnAdaptive_Click(object sender, EventArgs e)
		{
			if (this.tblworkShopTotalModule.SelectedIndex == Constant.INT_IS_ZERO)
			{
				this.dgvAll.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells);
			}
			else
			{
				this.dgvDetail.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells);
			}
		}

		/// <summary>
		/// 查询按钮事件
		/// </summary>
		/// <param name="sender"></param>
		/// <param name="e"></param>
		private void btnSearch_Click(object sender, EventArgs e)
		{
			try
			{
				GetEntityFromLayout();// 设置查询实体类
				if (this.tblworkShopTotalModule.SelectedIndex == 0)//汇总查询
				{
					this.GetSearchTotalData();
				}
				else
				{
					this.GetSearchDetailData(null);
				}
			}
			catch (Exception ex)
			{
				this.btnSearch.Enabled = true;
				// 对异常进行共通处理
				ExceptionManager.HandleEventException(this.ToString(),
					System.Reflection.MethodBase.GetCurrentMethod().Name, this.Text, ex);
			}
		}

		/// <summary>
		/// 清空条件按钮事件
		/// </summary>
		/// <param name="sender"></param>
		/// <param name="e"></param>
		private void btnClearCondition_Click(object sender, EventArgs e)
		{
			this.dtpStartTime.Value = DateTime.Now.Date;
			this.dtpEndTime.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1);
			this.txtGoodsCode.Clear();
			this.chkTestMouldFlag.AllItemCheck();
			this.cmbItem.SelectedIndex = 0;
			this.cmbDataCode.SelectedIndex = 0;
			this.cmbWorkShop.SelectedIndex = 0;
		}

		/// <summary>
		/// 双击单元格事件
		/// </summary>
		/// <param name="sender"></param>
		/// <param name="e"></param>
		private void dgvAll_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
		{
			if (this.dgvAll.CurrentRow == null)
			{
				return;
			}
			// 跳转页
			this.tblworkShopTotalModule.SelectTab(1);
			//获取数据信息
			DataGridViewRow dgvr = dgvAll.CurrentRow;
			this.GetSearchDetailData(dgvr);
		}
		#endregion

		#region 私有方法

		/// <summary>
		/// 搜索条件
		/// </summary>
		/// <returns></returns>
		private ClientRequestEntity GetEntityFromLayout()
		{
			cre.Properties["TIMESTART"] = this.dtpStartTime.Value;
			cre.Properties["TIMEEND"] = this.dtpEndTime.Value;
			cre.Properties["GOODSCODE"] = this.txtGoodsCode.Text.Trim().ToString();
			cre.Properties["DATACODE"] = cmbDataCode.SelectedValue.ToString();
			cre.Properties["WORKSHOP"] = cmbWorkShop.SelectedValue.ToString();
			cre.Properties["ITEM"] = cmbItem.SelectedValue.ToString();

			object[] testMouldFlags = this.chkTestMouldFlag.SelectedValues;
			if (testMouldFlags.Length == 1)
			{
				cre.Properties["TESTMOULDFLAG"] = testMouldFlags[0].ToString();
			}
			return this.cre;
		}

		/// <summary>
		/// 查询汇总表
		/// </summary>
		private DataTable GetSearchTotalData()
		{
			try
			{
                this.dgvAll.DataSource = null;
                cre.NameSpace = "R03";
                cre.Name = "R030120Sum";

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

                if (resultEntity == null || resultEntity.Data == null ||
                    resultEntity.Data.Tables.Count == 0 ||
                    resultEntity.Data.Tables[0].Rows.Count == 0)
                {
                    this.dgvAll.AutoResizeColumns();
                    return null;
                }
                else
                {
                    this.dgvAll.DataSource = resultEntity.Data.Tables[0];
                    this.dgvAll.ReadOnly = true;
                    this.dgvAll.Rows[0].Selected = true;
                    this.dgvAll.AutoResizeColumns();
                }
                return null;
			}
			catch (Exception ex)
			{
				throw ex;
			}
		}

		/// <summary>
		/// 查询明细表
		/// </summary>
		private DataTable GetSearchDetailData(DataGridViewRow dgvr)
		{
			try
			{
				this.dgvDetail.DataSource = null;
				ClientRequestEntity creDetail = cre;//存储查询条件
				creDetail.NameSpace = "R03";
				creDetail.Name = "R030120Detail";
				if (dgvr != null) {
					creDetail.Properties["GOODSCODE"] = dgvr.Cells["GOODSCODE"].Value.ToString();
					creDetail.Properties["DATACODE"] = dgvr.Cells["DATACODE"].Value.ToString(); 
					creDetail.Properties["WORKSHOP"] = dgvr.Cells["WORKSHOP"].Value.ToString();
					creDetail.Properties["ITEM"] = dgvr.Cells["ITEM"].Value.ToString(); 
				}
				ServiceResultEntity resultEntity = DoAsync<ServiceResultEntity>(() =>
				{
					return ReportModuleProxy.Service.DoRequest(creDetail);
				});

				if (resultEntity == null || resultEntity.Data == null ||
					resultEntity.Data.Tables.Count == 0 ||
					resultEntity.Data.Tables[0].Rows.Count == 0)
				{
					this.dgvDetail.AutoResizeColumns();
					return null;
				}
				else
				{
					this.dgvDetail.DataSource = resultEntity.Data.Tables[0];
					this.dgvDetail.ReadOnly = true;
					this.dgvDetail.Rows[0].Selected = true;
					this.dgvDetail.AutoResizeColumns();
				}
				return null;
			}
			catch (Exception ex)
			{
				throw ex;
			}
		}
		#endregion
    }
}