HEGII.gt.mes.wcf/DK.Client/ReportModule/R03/M01/F_RPT_030112.cs

/*******************************************************************************
 * Copyright(c) 2015 DongkeSoft All rights reserved. / Confidential
 * 类的信息：
 *      1.程序名称：F_RPT_030102_1.cs
 *      2.功能描述：产成品交接汇总表
 * 编辑履历：
 *      作者            日期                版本            修改内容
 *      袁新成          2015/4/14           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_030112 : DKDockPanelBase
	{
		#region 成员变量

		// 窗体的单例模式
		private static F_RPT_030112 _instance;
		//实体类 
		private RPT030102_SE _rptse = null;
		private RPT030102_SE _rptse1 = null;
		// 存储查询条件
		private SearchFinishedProductEntity _orderEntity = null;
		//private SearchFinishedProductEntity _orderEntity2 = null;
        private SearchFinishedProductEntity _orderCRE = null;
        #endregion

        #region 构造函数

        public F_RPT_030112()
		{
			InitializeComponent();
			// 窗体显示的Title
			this.Text = FormTitles.F_RPT_030112;
			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_030112 Instance
		{
			get
			{
				if (_instance == null || _instance.IsDisposed)
				{
					_instance = new F_RPT_030112();
				}
				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.dgvOrder.AutoGenerateColumns = false;
				this.dgvOrderDetail.AutoGenerateColumns = false;
				//this.dtpStartTime.Enabled = false;
				//this.dtpEndTime.Enabled = false;
				this.dtpStartTime.Value = DateTime.Now.Date;
				this.dtpEndTime.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1);
			}
			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.tblScrapTotalModule.SelectedIndex == Constant.INT_IS_ZERO)
			{
				this.dgvOrder.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells);
			}
			else if (this.tblScrapTotalModule.SelectedIndex == Constant.INT_IS_ONE)
			{
				this.dgvOrderDetail.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells);
			}
			else if (this.tblScrapTotalModule.SelectedIndex == Constant.INT_IS_FOUR)
			{
				this.dgvlc.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells);
			}
			else if (this.tblScrapTotalModule.SelectedIndex == Constant.INT_IS_FIVE)
			{
				this.dgvlcDetail.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells);
			}
		}

		/// <summary>
		/// 查询按钮事件
		/// </summary>
		/// <param name="sender"></param>
		/// <param name="e"></param>
		private void btnSearch_Click(object sender, EventArgs e)
		{
			try
			{
				GetOrderEntityFromLayout();// 设置查询实体类
				if (this.tblScrapTotalModule.SelectedIndex == 0)//交接汇总查询
				{
					//this._orderEntity2 = this._orderEntity;
					//this.dgvOrder.DataSource = null;
					//this.dgvOrder.DataSource = this.GetSearchTotalData();
					_orderCRE = this._orderEntity;
					this.GetSearchTotalData();
				}
				else if (this.tblScrapTotalModule.SelectedIndex == 1)//交接明细查询
				{
					this.dgvOrderDetail.DataSource = null;
					this.dgvOrderDetail.DataSource = this.GetSearchDetailData();
				}
				else if (this.tblScrapTotalModule.SelectedIndex == 2)//交接数量查询
				{
					this.dgvNum.DataSource = null;

					ClientRequestEntity cre = new ClientRequestEntity();
					cre.NameSpace = "R03";
					cre.Name = "R030112Num";

					cre.Properties["OrderNo"] = this.txtOrderNo.Text.Trim();
					cre.Properties["FHUserCode"] = this.txtFHUserCode.Text.Trim();
					if (this.chkDateTime.Checked)
					{
						cre.Properties["FHTimeStart"] = this.dtpStartTime.Value;
						cre.Properties["FHTimeEnd"] = this.dtpEndTime.Value;
					}
					cre.Properties["GoodsTypeCode"] = scbGoodsType.SearchedValue + "";
					cre.Properties["GoodsCode"] = this.txtGoodsCode.Text.Trim();
					cre.Properties["GoodsModel"] = this.txtGoodsModel.Text.Trim();
					cre.Properties["LogoIDS"] = this.dkLogoSearchBox1.LogoIDS;

					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.dgvNum.AutoResizeColumns();
						return;
					}
					else
					{
						this.dgvNum.DataSource = resultEntity.Data.Tables[0];
						this.dgvNum.ReadOnly = true;
						this.dgvNum.Rows[0].Selected = true;
						this.dgvNum.AutoResizeColumns();
					}
				}
				else if (this.tblScrapTotalModule.SelectedIndex == 3)//型号数量查询
				{
					this.dgvGoodsNum.DataSource = null;

					ClientRequestEntity cre = new ClientRequestEntity();
					cre.NameSpace = "R03";
					cre.Name = "R030112GoodsNum";

					cre.Properties["OrderNo"] = this.txtOrderNo.Text.Trim();
					cre.Properties["FHUserCode"] = this.txtFHUserCode.Text.Trim();
					if (this.chkDateTime.Checked)
					{
						cre.Properties["FHTimeStart"] = this.dtpStartTime.Value;
						cre.Properties["FHTimeEnd"] = this.dtpEndTime.Value;
					}
					cre.Properties["GoodsTypeCode"] = scbGoodsType.SearchedValue + "";
					cre.Properties["GoodsCode"] = this.txtGoodsCode.Text.Trim();
					cre.Properties["GoodsModel"] = this.txtGoodsModel.Text.Trim();
					cre.Properties["LogoIDS"] = this.dkLogoSearchBox1.LogoIDS;

					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.dgvGoodsNum.AutoResizeColumns();
						return;
					}
					else
					{
						this.dgvGoodsNum.DataSource = resultEntity.Data.Tables[0];
						this.dgvGoodsNum.ReadOnly = true;
						this.dgvGoodsNum.Rows[0].Selected = true;
						this.dgvGoodsNum.AutoResizeColumns();
					}
				}
				else if (this.tblScrapTotalModule.SelectedIndex == 4)//裸瓷交接汇总 add  by  qq 20250605
				{
					this.dgvlc.DataSource = null;

					ClientRequestEntity cre = new ClientRequestEntity();
					cre.NameSpace = "R03";
					cre.Name = "LCData";

					cre.Properties["FHUserCode"] = this.txtFHUserCode.Text.Trim();
					if (this.chkDateTime.Checked)
					{
						cre.Properties["FHTimeStart"] = this.dtpStartTime.Value;
						cre.Properties["FHTimeEnd"] = this.dtpEndTime.Value;
					}
					cre.Properties["GoodsTypeCode"] = scbGoodsType.SearchedValue + "";
					cre.Properties["GoodsCode"] = this.txtGoodsCode.Text.Trim();
					cre.Properties["GoodsModel"] = this.txtGoodsModel.Text.Trim();
					cre.Properties["LogoIDS"] = this.dkLogoSearchBox1.LogoIDS;

					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.dgvlc.AutoResizeColumns();
						return;
					}
					else
					{
						this.dgvlc.DataSource = resultEntity.Data.Tables[0];
						this.dgvlc.ReadOnly = true;
						this.dgvlc.Rows[0].Selected = true;
						this.dgvlc.AutoResizeColumns();
					}

				}
				else if (this.tblScrapTotalModule.SelectedIndex == 5)//裸瓷交接明细表 add  by  qq 20250605
				{
					this.dgvlcDetail.DataSource = null;

					ClientRequestEntity cre = new ClientRequestEntity();
					cre.NameSpace = "R03";
					cre.Name = "LCDetail";

					cre.Properties["FHUserCode"] = this.txtFHUserCode.Text.Trim();
					if (this.chkDateTime.Checked)
					{
						cre.Properties["FHTimeStart"] = this.dtpStartTime.Value;
						cre.Properties["FHTimeEnd"] = this.dtpEndTime.Value;
					}
					cre.Properties["GoodsTypeCode"] = scbGoodsType.SearchedValue + "";
					cre.Properties["GoodsCode"] = this.txtGoodsCode.Text.Trim();
					cre.Properties["GoodsModel"] = this.txtGoodsModel.Text.Trim();
					cre.Properties["LogoIDS"] = this.dkLogoSearchBox1.LogoIDS;



					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.dgvlcDetail.AutoResizeColumns();
						return;
					}
					else
					{
						this.dgvlcDetail.DataSource = resultEntity.Data.Tables[0];
						this.dgvlcDetail.ReadOnly = true;
						this.dgvlcDetail.Rows[0].Selected = true;
						this.dgvlcDetail.AutoResizeColumns();
					}
				}
			}
			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.txtOrderNo.Clear();
			this.txtFHUserCode.Clear();
			this.chkDateTime.Checked = false;
			this.dtpStartTime.Value = DateTime.Now.Date;
			this.dtpEndTime.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1);
			this.scbGoodsType.ClearValue();
			this.txtGoodsCode.Clear();
			this.dkLogoSearchBox1.ClearControl();
		}

		/// <summary>
		/// 双击单元格事件
		/// </summary>
		/// <param name="sender"></param>
		/// <param name="e"></param>
		private void dgvScrapTotalModule_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
		{
			try
			{
				//判断是否为空
				if (this.dgvOrder.CurrentRow == null)
				{
					return;
				}

                //获取数据信息
                DataRowView row = dgvOrder.CurrentRow.DataBoundItem as DataRowView;
				//this._orderEntity = _orderCRE;
                if (row["fhorderid"] == DBNull.Value)
                {
                    this._orderCRE.OrderID = null;
                }
                else
                {
                    this._orderCRE.OrderID = Convert.ToInt32(row["fhorderid"]);
                }
                if (row["goodsid"] == DBNull.Value)
                {
                    this._orderCRE.GoodsID = null;
                }
                else
                {
                    this._orderCRE.GoodsID = Convert.ToInt32(row["goodsid"]);
                }
                if (row["logoid"] == DBNull.Value)
                {
                    this._orderCRE.LogoID = null;
                }
                else
                {
                    this._orderCRE.LogoID = Convert.ToInt32(row["logoid"]);
                }

                this.dgvOrderDetail.DataSource = null;
				this.tblScrapTotalModule.SelectTab(1);
				this.dgvOrderDetail.DataSource = GetSearchDetailDataByDouble();
			}
			catch (Exception ex)
			{
				this.btnSearch.Enabled = true;
				this.btnClearCondition.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 chkDateTime_CheckedChanged(object sender, EventArgs e)
		{
			this.dtpStartTime.Enabled = chkDateTime.Checked;
			this.dtpEndTime.Enabled = chkDateTime.Checked;
		}
		#endregion

		#region 私有方法

		/// <summary>
		/// 搜索条件
		/// </summary>
		/// <returns></returns>
		private SearchFinishedProductEntity GetOrderEntityFromLayout()
		{
			this._orderEntity = new SearchFinishedProductEntity();
			this._orderEntity.OrderNo = this.txtOrderNo.Text.Trim();
			this._orderEntity.FHUserCode = this.txtFHUserCode.Text.Trim();
			if (this.chkDateTime.Checked)
			{
				this._orderEntity.FHTimeStart = this.dtpStartTime.Value;
				this._orderEntity.FHTimeEnd = this.dtpEndTime.Value;
			}
			this._orderEntity.GoodsTypeCode = scbGoodsType.SearchedValue + "";

			this._orderEntity.GoodsCode = this.txtGoodsCode.Text.Trim();
            this._orderEntity.GoodsModel = this.txtGoodsModel.Text.Trim();
            this._orderEntity.LogoIDS = this.dkLogoSearchBox1.LogoIDS;
			return this._orderEntity;
		}

		/// <summary>
		/// 明细搜索条件
		/// </summary>
		/// <returns></returns>
		private void CreateSearchConditionDetail()
		{
			this._rptse = new RPT030102_SE();

			this._rptse.ProductionLineID = this._rptse1.ProductionLineID;
			this._rptse.GoodsTypeCode = this._rptse1.GoodsTypeCode;
			this._rptse.GoodsCode = this._rptse1.GoodsCode;
			this._rptse.ProcedureIDS = this._rptse1.ProcedureIDS;
			this._rptse.ScrapDateStart = this._rptse1.ScrapDateStart;
			this._rptse.ScrapDateEnd = this._rptse1.ScrapDateEnd;

			this._rptse.ResponProcedureIDS = this._rptse1.ResponProcedureIDS;
			this._rptse.ResponUserIDS = this._rptse1.ResponUserIDS;
			this._rptse.CreatUser = this._rptse1.CreatUser;
			this._rptse.AuditUser = this._rptse1.AuditUser;
			this._rptse.SpecialRepairFlag = this._rptse1.SpecialRepairFlag;
		}

		/// <summary>
		/// 查询损坏汇总表
		/// </summary>
		private DataTable GetSearchTotalData()
		{
			try
			{
                //// 调用服务器端获取数据集
                //ServiceResultEntity sre = DoAsync<ServiceResultEntity>(() =>
                //{
                //	return ReportModuleProxy.Service.GetRPT0030112SData(this._orderEntity);
                //}
                //);

                //if (sre.Status == Constant.ServiceResultStatus.Success)
                //{
                //	if (sre.Data.Tables[0].Rows.Count <= Constant.INT_IS_ZERO)
                //	{
                //		// 提示未查找到数据
                //		MessageBox.Show(Messages.MSG_CMN_I002, this.Text,
                //			MessageBoxButtons.OK, MessageBoxIcon.Warning);
                //		//清空数据
                //		return null;
                //	}
                //	return sre.Data.Tables[0];
                //}
                this.dgvOrder.DataSource = null;
                ClientRequestEntity cre = new ClientRequestEntity();
                cre.NameSpace = "R03";
                cre.Name = "R030112Sum";

                cre.Properties["OrderNo"] = this.txtOrderNo.Text.Trim();
                cre.Properties["FHUserCode"] = this.txtFHUserCode.Text.Trim();
                if (this.chkDateTime.Checked)
                {
                    cre.Properties["FHTimeStart"] = this.dtpStartTime.Value;
                    cre.Properties["FHTimeEnd"] = this.dtpEndTime.Value;
                }
                cre.Properties["GoodsTypeCode"] = scbGoodsType.SearchedValue + "";
                cre.Properties["GoodsCode"] = this.txtGoodsCode.Text.Trim();
                cre.Properties["GoodsModel"] = this.txtGoodsModel.Text.Trim();
                cre.Properties["LogoIDS"] = this.dkLogoSearchBox1.LogoIDS;

                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.dgvOrder.AutoResizeColumns();
                    return null;
                }
                else
                {
                    this.dgvOrder.DataSource = resultEntity.Data.Tables[0];
                    this.dgvOrder.ReadOnly = true;
                    this.dgvOrder.Rows[0].Selected = true;
                    this.dgvOrder.AutoResizeColumns();
                }
                return null;
			}
			catch (Exception ex)
			{
				throw ex;
			}
		}

		/// <summary>
		/// 查询损坏明细表
		/// </summary>
		private DataTable GetSearchDetailData()
		{
			try
			{
				// 调用服务器端获取数据集
				ServiceResultEntity sre = DoAsync<ServiceResultEntity>(() =>
				{
					return ReportModuleProxy.Service.GetRPT0030112DetailSData(this._orderEntity);
				}
				);

				if (sre.Status == Constant.ServiceResultStatus.Success)
				{
					if (sre.Data.Tables[0].Rows.Count <= Constant.INT_IS_ZERO)
					{
						// 提示未查找到数据
						MessageBox.Show(Messages.MSG_CMN_I002, this.Text,
							MessageBoxButtons.OK, MessageBoxIcon.Warning);
						//清空数据
						return null;
					}
					return sre.Data.Tables[0];
				}

				return null;
			}
			catch (Exception ex)
			{
				throw ex;
			}
		}


		/// <summary>
		/// 查询损坏明细表
		/// </summary>
		private DataTable GetSearchDetailDataByDouble()
		{
			try
			{
				// 调用服务器端获取数据集
				ServiceResultEntity sre = DoAsync<ServiceResultEntity>(() =>
				{
					return ReportModuleProxy.Service.GetRPT0030112DetailSData(this._orderCRE);
				}
				);

				if (sre.Status == Constant.ServiceResultStatus.Success)
				{
					if (sre.Data.Tables[0].Rows.Count <= Constant.INT_IS_ZERO)
					{
						// 提示未查找到数据
						MessageBox.Show(Messages.MSG_CMN_I002, this.Text,
							MessageBoxButtons.OK, MessageBoxIcon.Warning);
						//清空数据
						return null;
					}
					return sre.Data.Tables[0];
				}

				return null;
			}
			catch (Exception ex)
			{
				throw ex;
			}
		}

		#endregion
	}
}