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

/*******************************************************************************
 * Copyright(c) 2015 DongkeSoft All rights reserved. / Confidential
 * 类的信息：
 *      1.程序名称：F_RPT_040105.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_040105 : DKDockPanelBase
    {
        #region 成员变量

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

        #endregion

        #region 构造函数

        public F_RPT_040105()
        {
            InitializeComponent();
            // 窗体显示的Title
            this.Text = FormTitles.F_RPT_040105;
            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_040105 Instance
        {
            get
            {
                if (_instance == null || _instance.IsDisposed)
                {
                    _instance = new F_RPT_040105();
                }
                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).AddMinutes(-1);
                this.chkTestMouldFlag.AllItemCheck();
                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.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.dkGoodsSearchBox.ClearControl();
            //this.dkGoodsTypeSearchBox.ClearControl(); 
            this.dkproductionLineSearchBox.ClearControl();
            this.dtpAccountDateStart.Value = DateTime.Now.Date;
            this.dtpAccountDateEnd.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1);
            //this.dkGroutingLineSearchBox.ClearControl();
            //this.dkUserInfoSearchBox.ClearControl();

            this.chkAll.Checked = false;
            //this.dkProcedureSearchBox2.ClearControl();
            this.chkTestMouldFlag.AllItemCheck();
            this.scbGoodsType.ClearValue();
        }
       

        #endregion

        #region  私有方法
         
        /// <summary>
        /// 根据界面查询条件获取数据集
        /// </summary>
        private DataTable GetSearchData()
        {
            try
            {

                RPT040105_SE se = new RPT040105_SE();
                if (this.chkAll.Checked)
                {
                    //if (string.IsNullOrEmpty(dkProcedureSearchBox2.ProcedureIDS))
                    //{
                    //    MessageBox.Show("请选择出窑数统计工序", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    //    this.dkProcedureSearchBox2.Focus();
                    //    return null;
                    //}
                    //se.OutProcedureIDS = dkProcedureSearchBox2.ProcedureIDS;
                }
                else
                {
                    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 = this.dkGoodsSearchBox.GoodsIDS;
                //se.GoodsTypeIDS = this.dkGoodsTypeSearchBox.GoodsTypeIDS;
                if (!this.dropKilnCode.Text.Equals(Constant.CBO_SELECT_ALL_NAME))
                {
                    se.KilnID = Convert.ToInt32(this.dropKilnCode.SelectedValue);
                }

                //se.CreateTimeStart = DateTime.Parse(this.dtpAccountDateStart.Value.ToString("yyyy-MM-dd") + " 0:0:0");
                //se.CreateTimeEnd = DateTime.Parse(this.dtpAccountDateEnd.Value.ToString("yyyy-MM-dd") + " 23:59:59");
                se.CreateTimeStart = this.dtpAccountDateStart.Value;
                //se.CreateTimeEnd = this.dtpAccountDateEnd.Value.AddMinutes(1).AddSeconds(-1);
                se.CreateTimeEnd = this.dtpAccountDateEnd.Value.AddSeconds(1);

                object[] testMouldFlags = this.chkTestMouldFlag.SelectedValues;
                if (testMouldFlags.Length == 1)
                {
                    se.TestMouldFlag = testMouldFlags[0].ToString();
                }
                se.GoodsTypeCode = this.scbGoodsType.SearchedValue + "";

                //se.GroutingUserIDS = this.dkUserInfoSearchBox.UserIDS;
                //se.GroutingLineIDS = this.dkGroutingLineSearchBox.GroutingLineIDS;

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

        private void chkAll_CheckedChanged(object sender, EventArgs e)
        {
            if (this.chkAll.Checked)
            {
                dropRptProcedure.Enabled = false;
                //dkProcedureSearchBox2.Enabled = true;
            }
            else
            {
                dropRptProcedure.Enabled = true;
                //dkProcedureSearchBox2.Enabled = false;
            }
        }
    }
}