HEGII.ss.mes.wcf/DK.Client/ReportModule/R03/M01/F_RPT_030102_1.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;

namespace Dongke.IBOSS.PRD.Client.ReportModule
{
	/// <summary>
	/// 产品损坏汇总表
	/// </summary>
	public partial class F_RPT_030102_1 : DKDockPanelBase
	{
		#region 成员变量

		// 窗体的单例模式
		private static F_RPT_030102_1 _instance;
		//实体类 
		private RPT030102_SE _rptse = null;
		private RPT030102_SE _rptse1 = null;
		//默认清空工序，重置回用户当前权限工序
		private string _currentUserPurview = null;
		//默认清空生产线，重置回用户当前权限生产线
		private string _currentUserLinePuview = null;

		#endregion

		#region 构造函数

		public F_RPT_030102_1()
		{
			InitializeComponent();
			// 窗体显示的Title
			this.Text = FormTitles.F_RPT_030102;
			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_030102_1 Instance
		{
			get
			{
				if (_instance == null || _instance.IsDisposed)
				{
					_instance = new F_RPT_030102_1();
				}
				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.dgvScrapTotalModule.AutoGenerateColumns = false;
				this.dgvScrapTotalModuleDetail.AutoGenerateColumns = false;
				//this.dkproductionLineSearchBox.IsEnablePurview = true;
				//this.dkProcedureSearchBox.IsEnablePurview = true;
				// 初始化时间控件为当前日期
				this.dtpScrapDateStart.Value = DateTime.Now.Date;
				this.dtpScrapDateEnd.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1);
				//getPurview();
				//getPurviewLine()
				// wangx 2016-06-21
				// 完成时间
				this.dtpCDateStart.Value = DateTime.Now.Date;
				this.dtpCDateEnd.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1);
				this.dtpCDateStart.Enabled = false;
				this.dtpCDateEnd.Enabled = false;
				// 交坯时间
				this.dtpDDateStart.Value = DateTime.Now.Date;
				this.dtpDDateEnd.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1);
				this.dtpDDateStart.Enabled = false;
				this.dtpDDateEnd.Enabled = false;
				// 注浆时间
				this.dtpGDateStart.Value = DateTime.Now.Date;
				this.dtpGDateEnd.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1);
				this.dtpGDateStart.Enabled = false;
				this.dtpGDateEnd.Enabled = false;
				// wangx 2016-06-21 end 
				// 审核时间
				this.dtpAuditDateStart.Value = DateTime.Now.Date;
				this.dtpAuditDateEnd.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1);
				this.dtpAuditDateStart.Enabled = false;
				this.dtpAuditDateEnd.Enabled = false;
				this.chkTestMouldFlag.AllItemCheck();
			}
			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.dgvScrapTotalModule.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells);
			}
			else
			{
				this.dgvScrapTotalModuleDetail.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells);
			}
		}

		/// <summary>
		/// 查询按钮事件
		/// </summary>
		/// <param name="sender"></param>
		/// <param name="e"></param>
		private void btnSearch_Click(object sender, EventArgs e)
		{
			try
			{
				CreateSearchCondition();
				if (this.tblScrapTotalModule.SelectedIndex == Constant.INT_IS_ZERO)//产品损坏汇总查询
				{
					this._rptse1 = this._rptse;
					this.dgvScrapTotalModule.DataSource = null;
					this.dgvScrapTotalModule.DataSource = this.GetSearchTotalData();
				}
				else //产品损坏明细查询
				{
					this.dgvScrapTotalModuleDetail.DataSource = null;
					this.dgvScrapTotalModuleDetail.DataSource = this.GetSearchDetailData();
				}
			}
			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.dkproductionLineSearchBox.ClearControl();
			this.scbGoodsType.ClearValue();
			this.txtGoodCode.Clear();
			this.dkProcedureSearchBox.ClearControl();
			this.dtpScrapDateStart.Value = DateTime.Now.Date;
			this.dtpScrapDateEnd.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1);
			this.chkScrapDateStart.Checked = true;

			this.dkResponProcedureSearchBox.ClearControl();
			this.dkResponUserInfoSearchBox.ClearControl();
			//this.dkResponProcedureSearchBox.ProcedureIDS = this._currentUserPurview;
			//this.dkproductionLineSearchBox.ProductionLineIDS = this._currentUserLinePuview;
			this.txtAuditUser.Clear();
			this.txtCreatUser.Clear();

			this.chkSpecialRepairFlag.Checked = true;
			this.chkReFireFlag.Checked = false;

			// 完成时间
			this.dtpCDateStart.Value = DateTime.Now.Date;
			this.dtpCDateEnd.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1);
			this.dtpCDateStart.Enabled = false;
			this.dtpCDateEnd.Enabled = false;
			this.chkPDate.Checked = false;
			// 交坯时间
			this.dtpDDateStart.Value = DateTime.Now.Date;
			this.dtpDDateEnd.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1);
			this.dtpDDateStart.Enabled = false;
			this.dtpDDateEnd.Enabled = false;
			this.chkDDate.Checked = false;
			// 注浆时间
			this.dtpGDateStart.Value = DateTime.Now.Date;
			this.dtpGDateEnd.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1);
			this.dtpGDateStart.Enabled = false;
			this.dtpGDateEnd.Enabled = false;
			this.chkGDate.Checked = false;
			// 审核时间
			this.dtpAuditDateStart.Value = DateTime.Now.Date;
			this.dtpAuditDateEnd.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1);
			this.dtpAuditDateStart.Enabled = false;
			this.dtpAuditDateEnd.Enabled = false;
			this.chkAuditDate.Checked = false;
			this.chkTestMouldFlag.AllItemCheck();
		}

		/// <summary>
		/// 双击单元格事件
		/// </summary>
		/// <param name="sender"></param>
		/// <param name="e"></param>
		private void dgvScrapTotalModule_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
		{
			try
			{
				//判断是否为空
				if (this.dgvScrapTotalModule.CurrentRow == null)
				{
					return;
				}
				//获取数据信息
				DataGridViewRow dgvr = dgvScrapTotalModule.CurrentRow;
				string zruserid = dgvr.Cells["zruserid"].Value.ToString();
				string goodsId = dgvr.Cells["GoodsId"].Value.ToString();
				string goodstypecode2 = dgvr.Cells["GoodsTypeCode2"].Value.ToString();
				string zrprocedureId = dgvr.Cells["ZRProcedureId"].Value.ToString();
				string productionlineid = dgvr.Cells["productionlineid"].Value.ToString();
				//判断是否选择统计行
				//if (!goodsCode.Equals("--"))
				//{
				//    this.tblScrapTotalModule.SelectTab(1);

				//    //获取查询条件
				//    //CreateSearchCondition();
				//    this.rptse1.GoodsIDS = goodsId.ToString();

				//    //获取工序id
				//    if (string.IsNullOrEmpty(procedureId))
				//    {
				//        this.rptse1.ResponProcedureID = 0;
				//    }
				//    else
				//    {
				//        this.rptse1.ResponProcedureID = Convert.ToInt32(procedureId);
				//    }
				//    this.dgvScrapTotalModuleDetail.DataSource = null;
				//    this.dgvScrapTotalModuleDetail.DataSource = GetSearchDetailData(this.rptse1);
				//}

				if (!string.IsNullOrEmpty(goodsId))
				{
					this.dgvScrapTotalModuleDetail.DataSource = null;
					this.tblScrapTotalModule.SelectTab(1);
					//获取条件
					this.CreateSearchConditionDetail();
					this._rptse.GoodsID = goodsId;
					this._rptse.ResponProcedureID = zrprocedureId;
					this._rptse.ResponUserID = zruserid;
					this.dgvScrapTotalModuleDetail.DataSource = null;
					this.dgvScrapTotalModuleDetail.DataSource = GetSearchDetailData();
					return;
				}

				if (!string.IsNullOrEmpty(goodstypecode2))
				{
					this.dgvScrapTotalModuleDetail.DataSource = null;
					this.tblScrapTotalModule.SelectTab(1);
					//获取条件
					this.CreateSearchConditionDetail();
					this._rptse.ResponProcedureID = zrprocedureId;
					this._rptse.GoodsTypeCode = goodstypecode2;
					this.dgvScrapTotalModuleDetail.DataSource = null;
					this.dgvScrapTotalModuleDetail.DataSource = GetSearchDetailData();
					return;
				}

				if (!string.IsNullOrEmpty(productionlineid))
				{
					this.dgvScrapTotalModuleDetail.DataSource = null;
					this.tblScrapTotalModule.SelectTab(1);
					//获取条件
					this.CreateSearchConditionDetail();
					this._rptse.ResponProcedureID = zrprocedureId;
					this.dgvScrapTotalModuleDetail.DataSource = null;
					this.dgvScrapTotalModuleDetail.DataSource = GetSearchDetailData();
					return;
				}

				this.dgvScrapTotalModuleDetail.DataSource = null;
				this.tblScrapTotalModule.SelectTab(1);
				//获取条件
				this.CreateSearchConditionDetail();
				this.dgvScrapTotalModuleDetail.DataSource = null;
				this.dgvScrapTotalModuleDetail.DataSource = GetSearchDetailData();
			}
			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 chkScrapDateStart_CheckedChanged(object sender, EventArgs e)
		{
			if (this.chkScrapDateStart.Checked)
			{
				this.dtpScrapDateStart.Enabled = true;
				this.dtpScrapDateEnd.Enabled = true;
			}
			else
			{
				this.dtpScrapDateStart.Enabled = false;
				this.dtpScrapDateEnd.Enabled = false;
				this.dtpScrapDateStart.Value = DateTime.Now.Date;
				this.dtpScrapDateEnd.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1);
			}
		}

		/// <summary>
		/// 完成时间选中改变事件
		/// </summary>
		/// <param name="sender"></param>
		/// <param name="e"></param>
		private void chkPDate_CheckedChanged(object sender, EventArgs e)
		{
			if (this.chkPDate.Checked)
			{
				this.dtpCDateStart.Enabled = true;
				this.dtpCDateEnd.Enabled = true;
			}
			else
			{
				this.dtpCDateStart.Enabled = false;
				this.dtpCDateEnd.Enabled = false;
				this.dtpCDateStart.Value = DateTime.Now.Date;
				this.dtpCDateEnd.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1);
			}
		}

		/// <summary>
		/// 交坯时间选中改变事件
		/// </summary>
		/// <param name="sender"></param>
		/// <param name="e"></param>
		private void chkDDate_CheckedChanged(object sender, EventArgs e)
		{
			if (this.chkDDate.Checked)
			{
				this.dtpDDateStart.Enabled = true;
				this.dtpDDateEnd.Enabled = true;
			}
			else
			{
				this.dtpDDateStart.Enabled = false;
				this.dtpDDateEnd.Enabled = false;
				this.dtpDDateStart.Value = DateTime.Now.Date;
				this.dtpDDateEnd.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1);
			}
		}

		/// <summary>
		/// 注浆时间选中改变事件
		/// </summary>
		/// <param name="sender"></param>
		/// <param name="e"></param>
		private void chkGDate_CheckedChanged(object sender, EventArgs e)
		{
			if (this.chkGDate.Checked)
			{
				this.dtpGDateStart.Enabled = true;
				this.dtpGDateEnd.Enabled = true;
			}
			else
			{
				this.dtpGDateStart.Enabled = false;
				this.dtpGDateEnd.Enabled = false;
				this.dtpGDateStart.Value = DateTime.Now.Date;
				this.dtpGDateEnd.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1);
			}
		}

		/// <summary>
		/// 审核日期
		/// </summary>
		/// <param name="sender"></param>
		/// <param name="e"></param>
		private void chkAuditDate_CheckedChanged(object sender, EventArgs e)
		{
			if (this.chkAuditDate.Checked)
			{
				this.dtpAuditDateStart.Enabled = true;
				this.dtpAuditDateEnd.Enabled = true;
			}
			else
			{
				this.dtpAuditDateStart.Enabled = false;
				this.dtpAuditDateEnd.Enabled = false;
				this.dtpAuditDateStart.Value = DateTime.Now.Date;
				this.dtpAuditDateEnd.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1);
			}
		}
		#endregion

		#region 私有方法

		/// <summary>
		/// 搜索条件
		/// </summary>
		/// <returns></returns>
		private void CreateSearchCondition()
		{
			_rptse = new RPT030102_SE();
			_rptse.ProductionLineID = this.dkproductionLineSearchBox.ProductionLineID;
			_rptse.GoodsTypeCode = scbGoodsType.SearchedValue + "";
			_rptse.GoodsCode = this.txtGoodCode.Text.Trim();
			_rptse.ProcedureIDS = this.dkProcedureSearchBox.ProcedureIDS;

			if (this.chkScrapDateStart.Checked)
			{
				_rptse.ScrapDateStart = DateTime.Parse(this.dtpScrapDateStart.Value.ToString("yyyy-MM-dd HH:mm") + ":00");
				_rptse.ScrapDateEnd = DateTime.Parse(this.dtpScrapDateEnd.Value.ToString("yyyy-MM-dd HH:mm") + ":59");
			}

			if (this.chkPDate.Checked)
			{
				_rptse.CTimeStart = DateTime.Parse(this.dtpCDateStart.Value.ToString("yyyy-MM-dd HH:mm") + ":00");
				_rptse.CTimeEnd = DateTime.Parse(this.dtpCDateEnd.Value.ToString("yyyy-MM-dd HH:mm") + ":59");
			}

			if (this.chkDDate.Checked)
			{
				_rptse.DTimeStart = DateTime.Parse(this.dtpDDateStart.Value.ToString("yyyy-MM-dd HH:mm") + ":00");
				_rptse.DTimeEnd = DateTime.Parse(this.dtpDDateEnd.Value.ToString("yyyy-MM-dd HH:mm") + ":59");
			}

			if (this.chkGDate.Checked)
			{
				_rptse.GTimeStart = DateTime.Parse(this.dtpGDateStart.Value.ToString("yyyy-MM-dd HH:mm") + ":00");
				_rptse.GTimeEnd = DateTime.Parse(this.dtpGDateEnd.Value.ToString("yyyy-MM-dd HH:mm") + ":59");
			}

			if (this.chkAuditDate.Checked)
			{
				_rptse.AuditTimeStart = DateTime.Parse(this.dtpAuditDateStart.Value.ToString("yyyy-MM-dd HH:mm") + ":00");
				_rptse.AuditTimeEnd = DateTime.Parse(this.dtpAuditDateEnd.Value.ToString("yyyy-MM-dd HH:mm") + ":59");
			}

			_rptse.ResponProcedureIDS = this.dkResponProcedureSearchBox.ProcedureIDS;
			_rptse.ResponUserIDS = this.dkResponUserInfoSearchBox.UserIDS;
			_rptse.CreatUser = this.txtCreatUser.Text.Trim();
			_rptse.AuditUser = this.txtAuditUser.Text.Trim();

			_rptse.SpecialRepairFlag = this.chkSpecialRepairFlag.Checked;
			_rptse.ReFireFlag = this.chkReFireFlag.Checked;

			object[] testMouldFlags = this.chkTestMouldFlag.SelectedValues;
			if (testMouldFlags.Length == 1)
			{
				_rptse.TestMouldFlag = testMouldFlags[0].ToString();
			}
		}

		/// <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.GetRPT030102SData(_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 GetSearchDetailData()
		{
			try
			{
				// 调用服务器端获取数据集
				ServiceResultEntity sre = DoAsync<ServiceResultEntity>(() =>
				{
					return ReportModuleProxy.Service.GetRPT030102IData(this._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>
		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)
				{
					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.dkResponProcedureSearchBox.Purview = sbProcedurePurview.ToString().Substring(Constant.INT_IS_ZERO, sbProcedurePurview.Length - 1);
						//this.dkResponProcedureSearchBox.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;
			}
		}

		/// <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)
				{
					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);
					}
				}
			}
			catch (Exception ex)
			{
				throw ex;
			}
		}

		#endregion
	}
}