SANHOPE.mes.wcf/DK.Client/ReportModule/R03/M01/F_RPT_030105.cs

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

		// 窗体的单例模式
		private static F_RPT_030105 _instance;
		//实体类 
		private RPT030105_SE rptse = new RPT030105_SE();
		//默认清空工序，重置回用户当前权限工序
		private string _currentUserPurview = null;
		//默认清空生产线，重置回用户当前权限生产线
		private string _currentUserLinePurview = null;

		#endregion

		#region 构造函数

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

		#endregion

		#region  事件处理

		/// <summary>
		/// 窗体加载事件
		/// </summary>
		/// <param name="sender"></param>
		/// <param name="e"></param>
		private void F_RPT_030101_1_Load(object sender, EventArgs e)
		{
			try
			{
				// 加载权限
				FormPermissionManager.FormPermissionControl(this.Name, this,
					LogInUserInfo.CurrentUser.CurrentUserEntity.UserRightData,
					LogInUserInfo.CurrentUser.CurrentUserEntity.FunctionData);
				// 设置表格不自动创建列
				this.dgvReportModule.AutoGenerateColumns = false;
				this.dkproductionLineSearchBox.IsEnablePurview = true;
				this.dkProcedureSearchBox.IsEnablePurview = true;
				getPurview();
				getPurviewLine();//生产线
			}
			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.dgvReportModule.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells);
			this.dgvDetailReportModule.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells);
		}

		/// <summary>
		/// 窗体关闭事件
		/// </summary>
		/// <param name="sender"></param>
		/// <param name="e"></param>
		private void F_RPT_030101_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 btnSearch_Click(object sender, EventArgs e)
		{
			try
			{
				if (string.IsNullOrEmpty(this._currentUserPurview))
				{
					// 提示未查找到数据
					MessageBox.Show(Messages.MSG_CMN_I002, this.Text,
						MessageBoxButtons.OK, MessageBoxIcon.Information);
					return;
				}

				if (string.IsNullOrEmpty(this._currentUserLinePurview))
				{
					// 提示未查找到数据
					MessageBox.Show(Messages.MSG_CMN_I002, this.Text,
						MessageBoxButtons.OK, MessageBoxIcon.Information);
					return;
				}
				this.dgvReportModule.DataSource = null;
				this.dgvDetailReportModule.DataSource = null;
				CreateSearchCondition();
				if (this.tblReportModule.SelectedIndex == Constant.INT_IS_ZERO)
				{
					this.dgvReportModule.DataSource = null;
					this.dgvReportModule.DataSource = GetSearchDetailData();
				}
				else
				{
					this.dgvDetailReportModule.DataSource = null;
					this.dgvDetailReportModule.DataSource = GetSearchDetailIData(rptse);
				}

			}
			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.scbGoodsType.ClearValue();
			this.dkProcedureSearchBox.ClearControl();
			this.dkproductionLineSearchBox.ClearControl();
			this.dkProcedureSearchBox.ProcedureIDS = this._currentUserPurview;
			this.dkproductionLineSearchBox.ProductionLineIDS = this._currentUserLinePurview;
			this.txtGoodsCode.Text = string.Empty;
			this.txtSTAFFNAME.Text = string.Empty;
		}

		private void dgvReportModule_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
		{
			try
			{
				//判断是否为空
				if (this.dgvReportModule.CurrentRow == null)
				{
					return;
				}
				//获取数据信息
				DataGridViewRow dgvr = dgvReportModule.CurrentRow;
				//string goodsCode = dgvr.Cells["GoodsCode"].Value.ToString();
				string procedureId = dgvr.Cells["ProcedureId"].Value + "";
                string GoodsTypeIDS = dgvr.Cells["colGoodsTypeCode2"].Value + "";
                string goodsid = dgvr.Cells["colgoodsid"].Value + "";
				string userid = dgvr.Cells["coluserid"].Value + "";
				//判断是否选择统计行
				//if (!goodsCode.Equals("--"))
				{
					this.tblReportModule.SelectTab(1);

                    RPT030105_SE rptse_d = new RPT030105_SE();
                    rptse_d.GoodsCode = rptse.GoodsCode;

                    if (string.IsNullOrWhiteSpace(procedureId))
                    {
                        rptse_d.ProcedureIDS = rptse.ProcedureIDS;
                    }
                    else
                    {
                        rptse_d.ProcedureIDS = procedureId;
                    }
                    if (string.IsNullOrWhiteSpace(GoodsTypeIDS))
                    {
                        rptse_d.GoodsTypeIDS = rptse.GoodsTypeIDS;
                    }
                    else
                    {
                        rptse_d.GoodsTypeIDS = GoodsTypeIDS;
                    }

                    if (!string.IsNullOrEmpty(goodsid))
                    {
                        rptse_d.GoodsID = Convert.ToInt32(goodsid);
					}
					if (!string.IsNullOrEmpty(userid))
					{
                        rptse_d.UserID = Convert.ToInt32(userid);
                    }

                    this.dgvDetailReportModule.DataSource = null;
					this.dgvDetailReportModule.DataSource = GetSearchDetailIData(rptse_d);
				}
			}
			catch (Exception ex)
			{
				this.btnSearch.Enabled = true;
				this.btnClearCondition.Enabled = true;
				// 对异常进行共通处理
				ExceptionManager.HandleEventException(this.ToString(),
					System.Reflection.MethodBase.GetCurrentMethod().Name, this.Text, ex);
			}
		}
		#endregion

		#region  私有方法
		/// <summary>
		/// 搜索条件
		/// </summary>
		/// <returns></returns>
		private void CreateSearchCondition()
		{
			rptse = new RPT030105_SE();
			rptse.GoodsTypeIDS = scbGoodsType.SearchedValue + "";
			rptse.LineIDS = this.dkproductionLineSearchBox.ProductionLineIDS;
			rptse.ProcedureIDS = this.dkProcedureSearchBox.ProcedureIDS;
			rptse.GoodsCode = this.txtGoodsCode.Text.Trim();
			rptse.StaffName = this.txtSTAFFNAME.Text.Trim();
		}

		/// <summary>
		/// 查询表
		/// </summary>
		private DataTable GetSearchDetailData()
		{
			try
			{
				//调用服务器端获取数据集
				ServiceResultEntity sre = DoAsync<ServiceResultEntity>(() =>
				{
					return ReportModuleProxy.Service.GetRPT030105Data(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.Information);
						//清空数据
						return null;
					}
					return sre.Data.Tables[0];
				}

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


		/// <summary>
		/// 查询表
		/// </summary>
		private DataTable GetSearchDetailIData(RPT030105_SE rptse_d)
		{
			try
			{
				//调用服务器端获取数据集
				ServiceResultEntity sre = DoAsync<ServiceResultEntity>(() =>
				{
					return ReportModuleProxy.Service.GetRPT030105IData(rptse_d);
				}
				);

				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.Information);
						//清空数据
						return null;
					}
					return sre.Data.Tables[0];
				}

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

		/// <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._currentUserLinePurview = 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._currentUserLinePurview = sbProcedurePurview.ToString().Substring(Constant.INT_IS_ZERO, sbProcedurePurview.Length - 1);
						}
					}
				}
			}
			catch (Exception ex)
			{
				throw ex;
			}
		}


		/// <summary>
		/// 获取权限
		/// </summary>
		protected void getPurview()
		{
			try
			{
				StringBuilder sbProcedurePurview = new StringBuilder();
				//得到工序查看权限
				DataSet dsProcedurePurview = (DataSet)DoAsync(new AsyncMethod(() =>
				{
					return SystemModuleProxy.Service.GetUserPurview(9, 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.dkProcedureSearchBox.Purview = sbProcedurePurview.ToString().Substring(Constant.INT_IS_ZERO, sbProcedurePurview.Length - 1);
							this.dkProcedureSearchBox.ProcedureIDS = sbProcedurePurview.ToString().Substring(Constant.INT_IS_ZERO, sbProcedurePurview.Length - 1);
							this._currentUserPurview = sbProcedurePurview.ToString().Substring(Constant.INT_IS_ZERO, sbProcedurePurview.Length - 1);
						}
					}
					else
					{
						SearchProductionLineEntity line = new SearchProductionLineEntity();
						dsProcedurePurview = SystemModuleProxy.Service.GetProdureList(line);
						foreach (DataRow dr in dsProcedurePurview.Tables[Constant.INT_IS_ZERO].Rows)
						{
							sbProcedurePurview.Append(dr["ProcedureID"].ToString() + ",");
						}
						if (sbProcedurePurview.Length != Constant.INT_IS_ZERO)
						{
							this.dkProcedureSearchBox.Purview = sbProcedurePurview.ToString().Substring(Constant.INT_IS_ZERO, sbProcedurePurview.Length - 1);
							this.dkProcedureSearchBox.ProcedureIDS = sbProcedurePurview.ToString().Substring(Constant.INT_IS_ZERO, sbProcedurePurview.Length - 1);
							this._currentUserPurview = sbProcedurePurview.ToString().Substring(Constant.INT_IS_ZERO, sbProcedurePurview.Length - 1);
						}
					}
				}
			}
			catch (Exception ex)
			{
				throw ex;
			}
		}
		#endregion
	}
}