HEGII.ss.mes.wcf/DK.Client/ReportModule/R04/M01/F_RPT_040104.cs

/*******************************************************************************
 * Copyright(c) 2015 DongkeSoft All rights reserved. / Confidential
 * 类的信息：
 *      1.程序名称：F_RPT_040104.cs
 *      2.功能描述：产成品质量分析表
 * 编辑履历：
 *      作者            日期                版本            修改内容
 *      袁新成          2015/05/11          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;

namespace Dongke.IBOSS.PRD.Client.ReportModule
{
	public partial class F_RPT_040104 : DKDockPanelBase
	{

		#region 成员变量

		// 窗体的单例模式
		private static F_RPT_040104 _instance;
		//默认清空生产线，重置回用户当前权限生产线
		private string _currentUserLinePuview = null;

		#endregion

		#region 构造函数

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

		#endregion

		#region  事件处理

		/// <summary>
		/// 窗体加载事件
		/// </summary>
		/// <param name="sender"></param>
		/// <param name="e"></param>
		private void F_RPT_040104_Load(object sender, EventArgs e)
		{
			try
			{
				// 加载权限
				FormPermissionManager.FormPermissionControl(this.Name, this,
					LogInUserInfo.CurrentUser.CurrentUserEntity.UserRightData, LogInUserInfo.CurrentUser.CurrentUserEntity.FunctionData);
				//绑定下了列表
				BindPage();
				// 设置表格不自动创建列
				this.dgvRptProcedure.AutoGenerateColumns = false;
				this.dropRptProcedure.Focus();
				this.dkproductionLineSearchBox.IsEnablePurview = true;
				// 初始化时间控件为当前日期
				this.dtpAccountDateStart.Value = DateTime.Now.Date;
				this.dtpAccountDateEnd.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1);
				this.chkTestMouldFlag.AllItemCheck();
				this.chkRecyclingFlag.FalseItemCheck();
				getPurviewLine();
				//实验单
				DataTable dtTest = new DataTable();
				dtTest.Columns.Add("TestFormFlagid", typeof(int));
				dtTest.Columns.Add("TestFormFlagname", typeof(string));
				DataRow drTest = dtTest.NewRow();
				drTest["TestFormFlagid"] = 0;
				drTest["TestFormFlagname"] = "全部";
				dtTest.Rows.Add(drTest);
				drTest = dtTest.NewRow();
				drTest["TestFormFlagid"] = 1;
				drTest["TestFormFlagname"] = "实验单";
				dtTest.Rows.Add(drTest);
				drTest = dtTest.NewRow();
				drTest["TestFormFlagid"] = 2;
				drTest["TestFormFlagname"] = "研发实验单";
				dtTest.Rows.Add(drTest);
				drTest = dtTest.NewRow();
				drTest["TestFormFlagid"] = 3;
				drTest["TestFormFlagname"] = "非研发实验单";
				dtTest.Rows.Add(drTest);

				this.dropTestFormFlag.DataSource = dtTest;
				this.dropTestFormFlag.ValueMember = "TestFormFlagid";
				this.dropTestFormFlag.DisplayMember = "TestFormFlagname";
			}
			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 tsbtnAdaptive_Click(object sender, EventArgs e)
		{
			this.dgvRptProcedure.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells);
		}

		/// <summary>
		/// 窗体关闭事件
		/// </summary>
		/// <param name="sender"></param>
		/// <param name="e"></param>
		private void F_RPT_040104_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 btnSearch_Click(object sender, EventArgs e)
		{
			try
			{
				this.dgvRptProcedure.DataSource = null;
				this.dgvRptProcedure.DataSource = this.GetSearchData();
			}
			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 btnClearCondition_Click(object sender, EventArgs e)
		{
			//this.dropKilnCode.Text = string.Empty;
			this.dropKilnCode.SelectedIndex = 0;
			this.scbGoods.ClearValue();
			this.scbGoodsType.ClearValue();
			this.dkproductionLineSearchBox.ClearControl();
			this.dtpAccountDateStart.Value = DateTime.Now.Date;
			this.dtpAccountDateEnd.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1);
			this.GroutingLineLh.Clear();
			this.GroutingLineLc.Clear();
			this.GroutingLineMh.Clear();
			this.GroutingLineXh.Clear();
			this.dkUserInfoSearchBox.ClearControl();
			this.chkTestMouldFlag.AllItemCheck();
			this.chkRecyclingFlag.FalseItemCheck();
			this.dropTestFormFlag.SelectedIndex = 0;
		}


		#endregion

		#region  私有方法

		/// <summary>
		/// 根据界面查询条件获取数据集
		/// </summary>
		private DataTable GetSearchData()
		{
			try
			{

				RPT040104_SE se = new RPT040104_SE();

				if (string.IsNullOrEmpty(this.dropRptProcedure.Text))
				{
					this.dropRptProcedure.Focus();
					return null;
				}
				se.RptProcedureID = Convert.ToInt32(this.dropRptProcedure.SelectedValue);

				//获取数据来源工序Id
				ServiceResultEntity sre0 = this.DoAsync<ServiceResultEntity>(() =>
				{
					return ReportModuleProxy.Service.GetRptSourceProcedureModule(se.RptProcedureID);
				}
				);
				if (sre0.Data != null && sre0.Data.Tables.Count > 0)
				{
					se.RptSProcedureID = int.Parse(sre0.Data.Tables[0].Rows[Constant.INT_IS_ZERO]["Procedureid"].ToString());
				}

				//获取数据来源工序Id  
				se.ProductionLineID = this.dkproductionLineSearchBox.ProductionLineID;
				se.GoodsIDS = scbGoods.CheckedPKMember;
				se.GoodsTypeIDS = scbGoodsType.SearchedValue + "";
				if (!this.dropKilnCode.Text.Equals(Constant.CBO_SELECT_ALL_NAME))
				{
					se.KilnID = Convert.ToInt32(this.dropKilnCode.SelectedValue);
				}

				se.CreateTimeStart = this.dtpAccountDateStart.Value;
				//se.CreateTimeEnd = this.dtpAccountDateEnd.Value;
                se.CreateTimeEnd = this.dtpAccountDateEnd.Value.AddSeconds(1);
                se.GroutingUserIDS = this.dkUserInfoSearchBox.UserIDS;
				se.GroutingLineLh = this.GroutingLineLh.Text.Trim();
				se.GroutingLineLc = this.GroutingLineLc.Text.Trim();
				se.GroutingLineMh = this.GroutingLineMh.Text.Trim();
				se.GroutingLineXh = this.GroutingLineXh.Text.Trim();

				object[] testMouldFlags = this.chkTestMouldFlag.SelectedValues;
				if (testMouldFlags.Length == 1)
				{
					se.TestMouldFlag = testMouldFlags[0].ToString();
				}
				object[] testRecyclingFlags = this.chkRecyclingFlag.SelectedValues;
				if (testRecyclingFlags.Length == 1)
				{
					se.TestRecyclingFlags = testRecyclingFlags[0].ToString();
				}
				if (this.dropTestFormFlag.SelectedValue != null)
				{
					se.TestFormFlag = int.Parse(this.dropTestFormFlag.SelectedValue.ToString());
				}
				// 调用服务器端获取数据集
				ServiceResultEntity sre = DoAsync<ServiceResultEntity>(() =>
				{
					return ReportModuleProxy.Service.GetRPT040104SData(se);
				}
				);

				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 BindPage()
		{
			//绑定数据来源下拉列表

			ServiceResultEntity sre1 = DoAsync<ServiceResultEntity>(() =>
			{
				return ReportModuleProxy.Service.GetRptProcedureModule();
			}
			);

			this.dropRptProcedure.DataSource = sre1.Data.Tables[Constant.INT_IS_ZERO];
			this.dropRptProcedure.ValueMember = "Rptprocedureid";
			this.dropRptProcedure.DisplayMember = "Rptprocedurename";

			//绑定窑炉下来列表

			ServiceResultEntity sre2 = DoAsync<ServiceResultEntity>(() =>
			{
				byte byFlage = Convert.ToByte(Constant.ValueFlag.Invalid);
				return ReportModuleProxy.Service.GetKilnData(byFlage);
			}
			);
			DataTable dtKilnInfo = sre2.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>
		protected void getPurviewLine()
		{
			try
			{
				StringBuilder sbProcedurePurview = new StringBuilder();
				//得到工序查看权限
				DataSet dsProcedurePurview = (DataSet)DoAsync(new AsyncMethod(() =>
				{
					return SystemModuleProxy.Service.GetUserPurview(7, LogInUserInfo.CurrentUser.UserID);
				}));
				if (dsProcedurePurview != null)
				{
					DataRow[] drPurview = dsProcedurePurview.Tables[Constant.INT_IS_ZERO].Select("PurviewID=-1");
					if (drPurview.Length == 0)
					{
						foreach (DataRow dr in dsProcedurePurview.Tables[Constant.INT_IS_ZERO].Rows)
						{
							sbProcedurePurview.Append(dr[Constant.INT_IS_ZERO].ToString() + ",");
						}
						if (sbProcedurePurview.Length != Constant.INT_IS_ZERO)
						{
							this.dkproductionLineSearchBox.Purview = sbProcedurePurview.ToString().Substring(Constant.INT_IS_ZERO, sbProcedurePurview.Length - 1);
							this.dkproductionLineSearchBox.ProductionLineIDS = sbProcedurePurview.ToString().Substring(Constant.INT_IS_ZERO, sbProcedurePurview.Length - 1);
							this._currentUserLinePuview = sbProcedurePurview.ToString().Substring(Constant.INT_IS_ZERO, sbProcedurePurview.Length - 1);
						}
					}
					else
					{
						ProductionLineEntity line = new ProductionLineEntity();
						line.ValueFlags = new object[] { 1 };
						dsProcedurePurview = (DataSet)DoAsync(() =>
						{
							return PCModuleProxy.Service.SearchProductionLine(line);
						});
						foreach (DataRow dr in dsProcedurePurview.Tables[Constant.INT_IS_ZERO].Rows)
						{
							sbProcedurePurview.Append(dr["productionlineID"].ToString() + ",");
						}
						if (sbProcedurePurview.Length != Constant.INT_IS_ZERO)
						{
							this.dkproductionLineSearchBox.Purview = sbProcedurePurview.ToString().Substring(Constant.INT_IS_ZERO, sbProcedurePurview.Length - 1);
							this.dkproductionLineSearchBox.ProductionLineIDS = sbProcedurePurview.ToString().Substring(Constant.INT_IS_ZERO, sbProcedurePurview.Length - 1);
							this._currentUserLinePuview = sbProcedurePurview.ToString().Substring(Constant.INT_IS_ZERO, sbProcedurePurview.Length - 1);
						}
					}
				}
			}
			catch (Exception ex)
			{
				throw ex;
			}
		}
		#endregion
	}
}