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


/*******************************************************************************
 * Copyright(c) 2015 DongkeSoft All rights reserved. / Confidential
 * 类的信息：
 *      1.程序名称：F_RPT_030104_1.cs
 *      2.功能描述：窑车产量汇总表
 * 编辑履历：
 *      作者            日期                版本            修改内容
 *      袁新成          2015/4/14           1.00            新建
 *******************************************************************************/

using System;
using System.Data;
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_030104_1 : DKDockPanelBase
	{
		#region 成员变量

		// 窗体的单例模式
		private static F_RPT_030104_1 _instance;
		//实体类
		private RPT030104_SE rptse = new RPT030104_SE();

		#endregion

		#region 构造函数

		public F_RPT_030104_1()
		{
			InitializeComponent();
			// 窗体显示的Title
			this.Text = FormTitles.F_RPT_030104;
			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_030104_1 Instance
		{
			get
			{
				if (_instance == null || _instance.IsDisposed)
				{
					_instance = new F_RPT_030104_1();
				}
				return _instance;
			}
		}

		#endregion

		#region  事件处理

		/// <summary>
		/// 窗体加载事件
		/// </summary>
		/// <param name="sender"></param>
		/// <param name="e"></param>
		private void F_RPT_030104_1_Load(object sender, EventArgs e)
		{
			try
			{
				// 加载权限
				FormPermissionManager.FormPermissionControl(this.Name, this,
					LogInUserInfo.CurrentUser.CurrentUserEntity.UserRightData,
					LogInUserInfo.CurrentUser.CurrentUserEntity.FunctionData);
				// 设置表格不自动创建列
				this.dgvKilnCarTotal.AutoGenerateColumns = false;
				this.dgvKilnCarGoodsTotal.AutoGenerateColumns = false;
				//绑下拉列定
				BindPageKiln();
				BindPageProcessModelType();
				//BindPageKilnCar();
				//判断控件是否可用
				if (this.tblKilnTotalModule.SelectedIndex == Constant.INT_IS_ZERO)
				{
					this.scbGoods.Enabled = false;
					this.scbGoodsType.Enabled = false;
				}
				// 初始化时间控件为当前日期
				this.dtpCreateDateStart.Value = DateTime.Now.Date;
				this.dtpCreateDateEnd.Value = DateTime.Now.Date.AddDays(1).AddMinutes(-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_030104_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.tblKilnTotalModule.SelectedIndex == Constant.INT_IS_ZERO)
			{
				this.dgvKilnCarTotal.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells);
			}
			else if (this.tblKilnTotalModule.SelectedIndex == Constant.INT_IS_ONE)
			{
				this.dgvKilnCarGoodsTotal.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells);
			}
			else
			{
				this.dgvKilnCarGoodsDetailTotal.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells);
			}
		}

		/// <summary>
		/// 查询按钮事件
		/// </summary>
		/// <param name="sender"></param>
		/// <param name="e"></param>
		private void btnSearch_Click(object sender, EventArgs e)
		{
			try
			{
				if (string.IsNullOrEmpty(this.ddlProcessModelType.Text))
				{
					MessageBox.Show(string.Format(Messages.MSG_CMN_W005, "工序类型"),
					 this.Text, MessageBoxButtons.OK, MessageBoxIcon.Warning);
					return;
				}
				CreateSearchCondition();
				if (this.tblKilnTotalModule.SelectedIndex == Constant.INT_IS_ZERO)//窑车汇总查询
				{
					this.dgvKilnCarTotal.DataSource = null;
					this.dgvKilnCarTotal.DataSource = this.GetSearchKilnCarTotalData();
				}
				else if (this.tblKilnTotalModule.SelectedIndex == Constant.INT_IS_ONE) //窑车产量汇总查询
				{
					this.dgvKilnCarGoodsTotal.DataSource = null;
					this.dgvKilnCarGoodsTotal.DataSource = this.GetSearchKilnCarGoodsTotalData();
				}
				else if (this.tblKilnTotalModule.SelectedIndex == Constant.INT_IS_TWO) //窑车产量明细查询
				{
					this.dgvKilnCarGoodsDetailTotal.DataSource = null;
					this.dgvKilnCarGoodsDetailTotal.DataSource = this.GetSearchKilnCarGoodsDetailData();
				}
			}
			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.scbGoods.ClearValue();
			this.scbGoodsType.ClearValue();
			this.dkUserInfoSearchBox.ClearControl();
			this.dropKilnCode.Text = string.Empty;

			this.txtKilnCarCode.Clear();
			this.txtKilnCarNumBegin.Clear();
			this.txtKilnCarNumEnd.Clear();

			this.dtpCreateDateStart.Value = DateTime.Now.Date;
			this.dtpCreateDateEnd.Value = DateTime.Now.Date.AddDays(1).AddMinutes(-1);
		}

		/// <summary>
		/// 属性值改变事件
		/// </summary>
		/// <param name="sender"></param>
		/// <param name="e"></param>
		private void tblScrapTotalModule_SelectedIndexChanged(object sender, EventArgs e)
		{
			if (this.tblKilnTotalModule.SelectedTab.Text.ToString().Equals("窑车汇总表"))
			{
				this.scbGoods.Enabled = false;
				this.scbGoodsType.Enabled = false;
			}
			else
			{
				this.scbGoods.Enabled = true;
				this.scbGoodsType.Enabled = true;
			}
		}

		#endregion

		#region 私有方法

		/// <summary>
		/// 搜索条件
		/// </summary>
		/// <returns></returns>
		private void CreateSearchCondition()
		{
			rptse = new RPT030104_SE();

			if (!this.dropKilnCode.Text.Equals(Constant.CBO_SELECT_ALL_NAME))
			{
				this.rptse.KilnID = Convert.ToInt32(this.dropKilnCode.SelectedValue);
			}

			//if (!string.IsNullOrEmpty(this.dropKilnCarCode.Text))
			//{
			//    this.rptse.KilnCarID = Convert.ToInt32(this.dropKilnCarCode.SelectedValue);
			//}
			this.rptse.KilnCarCode = this.txtKilnCarCode.Text.Trim();

			if (this.txtKilnCarNumBegin.DataValue.HasValue)
			{
				this.rptse.KilnCarNumBegin = Convert.ToInt32(this.txtKilnCarNumBegin.DataValue.Value);
			}
			if (this.txtKilnCarNumEnd.DataValue.HasValue)
			{
				this.rptse.KilnCarNumEnd = Convert.ToInt32(this.txtKilnCarNumEnd.DataValue.Value);
			}

			this.rptse.ProcedureModelTypeID = Convert.ToInt32(this.ddlProcessModelType.SelectedValue);
			this.rptse.GoodsIDS = scbGoods.CheckedPKMember;
			this.rptse.GoodsTypeIDS = scbGoodsType.SearchedValue + "";
			this.rptse.UserIDS = this.dkUserInfoSearchBox.UserIDS;
			this.rptse.CreateTimeStart = DateTime.Parse(this.dtpCreateDateStart.Value.ToString("yyyy-MM-dd HH:mm"));
			this.rptse.CreateTimeEnd = DateTime.Parse(this.dtpCreateDateEnd.Value.ToString("yyyy-MM-dd HH:mm") + ":59");
		}

		/// <summary>
		/// 查询窑车汇总表
		/// </summary>
		private DataTable GetSearchKilnCarTotalData()
		{
			try
			{
				// 调用服务器端获取数据集
				ServiceResultEntity sre = DoAsync<ServiceResultEntity>(() =>
				{
					return ReportModuleProxy.Service.GetRPT030104SData(rptse);
				}
				);

				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 GetSearchKilnCarGoodsTotalData()
		{
			try
			{
				// 调用服务器端获取数据集
				ServiceResultEntity sre = DoAsync<ServiceResultEntity>(() =>
				{
					return ReportModuleProxy.Service.GetRPT030104IData(rptse);
				}
				);

				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 GetSearchKilnCarGoodsDetailData()
		{
			try
			{
				// 调用服务器端获取数据集
				ServiceResultEntity sre = DoAsync<ServiceResultEntity>(() =>
				{
					return ReportModuleProxy.Service.GetRPT030104UData(rptse);
				}
				);

				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>
		/// <returns></returns>
		private void BindPageKiln()
		{
			ServiceResultEntity sre = DoAsync<ServiceResultEntity>(() =>
			{
				byte byFlage = Convert.ToByte(Constant.ValueFlag.Invalid);
				return ReportModuleProxy.Service.GetKilnData(byFlage);
			}
			);
			DataTable dtKilnInfo = sre.Data.Tables[Constant.INT_IS_ZERO];
			DataRow newRowDic = dtKilnInfo.NewRow();
			newRowDic["KilnID"] = Constant.CBO_SELECT_ALL_VALUE;
			newRowDic["KilnCode"] = Constant.CBO_SELECT_ALL_NAME;
			dtKilnInfo.Rows.InsertAt(newRowDic, Constant.INT_IS_ZERO);
			this.dropKilnCode.DataSource = dtKilnInfo;
			this.dropKilnCode.ValueMember = "KilnID";
			this.dropKilnCode.DisplayMember = "KilnCode";
		}

		/// <summary>
		/// 绑定下拉列表工序类别值
		/// </summary>
		/// <returns></returns>
		private void BindPageProcessModelType()
		{
			DataTable dtModelType = LogInUserInfo.CurrentUser.GetSystemParameterByName(Constant.SysCacheTable.TP_SYS_ProcedureModelType);
			this.ddlProcessModelType.DataSource = dtModelType.Select("ProcedureModelTypeID in (1,2,3,4)").CopyToDataTable();
			this.ddlProcessModelType.DisplayMember = "ProcedureModelTypeName";
			this.ddlProcessModelType.ValueMember = "ProcedureModelTypeID";
		}

		/// <summary>
		/// 绑定下拉列表窑车值
		/// </summary>
		/// <returns></returns>
		private void BindPageKilnCar()
		{
			ServiceResultEntity sre = DoAsync<ServiceResultEntity>(() =>
			{
				return ReportModuleProxy.Service.GetAllKilnCarInfo();
			}
			);
			//this.dropKilnCarCode.DataSource = sre.Data.Tables[Constant.INT_IS_ZERO];
			//this.dropKilnCarCode.ValueMember = "KilnCarID";
			//this.dropKilnCarCode.DisplayMember = "KilnCarCode";
			//this.dropKilnCarCode.Text = "";
		}

		#endregion
	}
}