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

/*******************************************************************************
 * Copyright(c) 2016 DongkeSoft All rights reserved. / Confidential
 * 类的信息：
 *      1.程序名称：F_RPT_030111.cs
 *      2.功能描述：工序收发存汇总表
 * 编辑履历：
 *      作者            日期                版本            修改内容
 *      陈晓野          2016/07/12          1.00            新建
 *******************************************************************************/

using System;
using System.Data;
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.WCF.DataModels;
using Dongke.IBOSS.PRD.WCF.Proxys;
using Dongke.IBOSS.PRD.WCF.Proxys.PMModuleService;
using Dongke.IBOSS.PRD.WCF.DataModels.PMModule;

namespace Dongke.IBOSS.PRD.Client.ReportModule
{
	/// <summary>
	/// 工序收发存汇总表
	/// </summary>
	public partial class F_RPT_030111 : DockPanelBase
	{
		#region 成员变量

		//单例模式
		private static F_RPT_030111 _instance;

		#endregion

		#region 构造函数

		/// <summary>
		/// 废弃一览构造
		/// </summary>
		public F_RPT_030111()
		{
			InitializeComponent();
			this.Text = "工序收发存汇总表";
			this.tsbtnAdaptive.Text = ButtonText.TSBTN_ADAPTIVE;
			this.tsbtnClose.Text = ButtonText.TSBTN_CLOSE;
			this.btnSearch.Text = ButtonText.BTN_SEARCH;
			this.btnClearCondition.Text = ButtonText.BTN_CLEARCONDITION;
		}

		#endregion

		#region 单例模式

		/// <summary>
		/// 单例模式，防止重复创建窗体
		/// </summary>
		public static F_RPT_030111 Instance
		{
			get
			{
				if (_instance == null)
				{
					_instance = new F_RPT_030111();
				}
				return _instance;
			}
		}

		#endregion

		#region 事件

		/// <summary>
		/// 查询事件
		/// </summary>
		/// <param name="sender"></param>
		/// <param name="e"></param>
		private void btnSearch_Click(object sender, EventArgs e)
		{
			try
			{
				object value = this.cboPT.SelectedValue;
				if (value == null || value == DBNull.Value)
				{
					MessageBox.Show(string.Format(Messages.MSG_CMN_W005, "工序配置"), this.Text,
						MessageBoxButtons.OK, MessageBoxIcon.Warning);
				}

				this.dgvPT.DataSource = null;
				this.dgvPT.Columns.Clear();
				this.dgvPT.Columns.Add(this.GOODSCODE);
                this.dgvPT.Columns.Add(this.GOODSMODEL);
                this.dgvPT.Columns.Add(this.TECDEPNAME);
				this.dgvPT.Columns.Add(this.colA);
				this.dgvPT.Columns.Add(this.colB);
				this.dgvPT.Columns.Add(this.colC);
				this.dgvPT.Columns.Add(this.colD);
				this.dgvPT.Columns.Add(this.colE);
				this.dgvPT.Columns.Add(this.colF);
				//this.dgvPT.Columns.Add(this.GOODSID);
				//this.dgvPT.Columns.Add(this.OUTTDID);

				RPT030111_SE se = new RPT030111_SE();
				se.PTID = Convert.ToInt32(this.cboPT.SelectedValue);
				se.GoodsTypeCode = scbGoodsType.SearchedValue + "";
				se.GoodsCode = this.txtGoodsCode.Text.Trim();
				se.GTimeStart = this.txtTimeStart.Value;
				se.GTimeEnd = this.txtTimeEnd.Value;

				DataTable data = (DataTable)DoAsync(new AsyncMethod(() =>
				{
					return this.GetData(se);
				}));
				if (data != null && data.Rows.Count > 0)
				{
					//foreach (DataColumn item in data.Tables[0].Columns)
					//{
					//    if (!item.ColumnName.StartsWith("C_") && )
					//    {
					//    }
					//}
					for (int i = 11; i < data.Columns.Count; i++)
					{
						DataColumn d = data.Columns[i];
						DataGridViewTextBoxColumn dc = new DataGridViewTextBoxColumn();
						dc.DataPropertyName = d.ColumnName;
						dc.HeaderText = d.ColumnName;
						dc.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
						this.dgvPT.Columns.Add(dc);
					}

					this.dgvPT.DataSource = data;
					this.dgvPT.ReadOnly = true;
					this.dgvPT.Rows[0].Selected = true;
				}
			}
			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 btnClearCondition_Click(object sender, EventArgs e)
		{
			if (this.cboPT.Items.Count > 0)
			{
				this.cboPT.SelectedIndex = 0;
			}
			this.scbGoodsType.ClearValue();
			this.txtGoodsCode.Text = string.Empty;
			DateTime date = DateTime.Now;
			this.txtTimeStart.Value = new DateTime(date.Year, date.Month, 1);
			this.txtTimeEnd.Value = this.txtTimeStart.Value.AddMonths(1).AddSeconds(-1);
		}

		/// <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 F_RPT_030110_FormClosed(object sender, FormClosedEventArgs e)
		{
			_instance = null;
		}

		/// <summary>
		/// 自动列宽
		/// </summary>
		/// <param name="sender"></param>
		/// <param name="e"></param>
		private void tsbtnAdaptive_Click(object sender, EventArgs e)
		{
			this.dgvPT.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells);
		}

		/// <summary>
		/// 窗体加载
		/// </summary>
		/// <param name="sender"></param>
		/// <param name="e"></param>
		private void F_RPT_030110_Load(object sender, EventArgs e)
		{
			try
			{
				// 加载权限
				FormPermissionManager.FormPermissionControl(this.Name, this,
					Dongke.IBOSS.PRD.Client.DataModels.LogInUserInfo.CurrentUser.CurrentUserEntity.UserRightData,
					Dongke.IBOSS.PRD.Client.DataModels.LogInUserInfo.CurrentUser.CurrentUserEntity.FunctionData);

				this.dgvPT.AutoGenerateColumns = false;
				// 设置日期控件默认值
				DateTime date = DateTime.Now;
				this.txtTimeStart.Value = new DateTime(date.Year, date.Month, 1);
				this.txtTimeEnd.Value = this.txtTimeStart.Value.AddMonths(1).AddSeconds(-1);
				// 加载初始化数据源 工序配置
				ServiceResultEntity sre = ReportModuleProxy.Service.GetRPT030111IData();
				if (sre != null && sre.Data != null && sre.Data.Tables.Count > 0)
				{
					this.cboPT.DataSource = sre.Data.Tables[0];
					this.cboPT.DisplayMember = "Name";
					this.cboPT.ValueMember = "ptid";
				}

				foreach (DataGridViewColumn item in this.dgvPT.Columns)
				{
					item.Tag = 1;
				}
			}
			catch (Exception ex)
			{
				// 对异常进行共通处理
				ExceptionManager.HandleEventException(this.ToString(),
					System.Reflection.MethodBase.GetCurrentMethod().Name, this.Text, ex);
			}
		}
		#endregion

		#region 私有方法

		/// <summary>
		/// 根据界面查询条件获取数据集
		/// </summary>
		private DataTable GetData(RPT030111_SE se)
		{
			try
			{
				ServiceResultEntity resultEntity = ReportModuleProxy.Service.GetRPT030111SData(se);
				if (resultEntity.Data == null || resultEntity.Data.Tables.Count == 0)
				{
					return null;
				}
				return resultEntity.Data.Tables[0];
			}
			catch (Exception ex)
			{
				throw ex;
			}
		}

		#endregion
	}
}