HEGII.ss.mes.wcf/DK.Client/ReportModule/R04/M01/F_RPT_040106.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_040106 : DKDockPanelBase
    {
        #region 成员变量

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

        #endregion

        #region 构造函数

        public F_RPT_040106()
        {
            InitializeComponent();
            // 窗体显示的Title
            this.Text = FormTitles.F_RPT_040106;
            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_040106 Instance
        {
            get
            {
                if (_instance == null || _instance.IsDisposed)
                {
                    _instance = new F_RPT_040106();
                }
                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);
                getPurviewLine();
                //this.dkCJProcedureSearchBox.IsEnablePurview = true;//add xiacm 2022-11-02
                //getPurview();//add xiacm 2022-11-02
            }
            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.dkProcedureSearchBox3.ClearControl();
            this.dtpAccountDateStart.Value = DateTime.Now.Date;
            this.dtpAccountDateEnd.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1);
            this.txtDefectCode.Clear();
            this.txtDefectName.Clear();
            //this.dkGroutingLineSearchBox.ClearControl();
            //this.dkUserInfoSearchBox.ClearControl();
            this.chkOutKilnNum.Checked = true;
            //this.dkCJProcedureSearchBox.ClearControl();//add xiacm 2022-11-02
        }
        #endregion

        #region  私有方法

        /// <summary>
        /// 根据界面查询条件获取数据集
        /// </summary>
        private DataTable GetSearchData()
        {
            try
            {
                RPT040106_SE se = new RPT040106_SE();
                if (string.IsNullOrEmpty(this.dropRptProcedure.Text))
                {
                    this.dropRptProcedure.Focus();
                    return null;
                }
                //se.RptProcedureID = Convert.ToInt32(this.dropRptProcedure.SelectedValue);

                DataRowView drv = this.dropRptProcedure.SelectedItem as DataRowView;
                if (drv == null)
                {
                    return null;
                }
                //获取数据来源工序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());
                //}
                se.RptSProcedureID = Convert.ToInt32(drv["SProcedureID"]);
                if (!this.dropKilnCode.Text.Equals(Constant.CBO_SELECT_ALL_NAME))
                {
                    se.KilnID = Convert.ToInt32(this.dropKilnCode.SelectedValue);
                }
                // 质量工序id
                se.ProcedureIDS = dkProcedureSearchBox3.ProcedureIDS == null ? string.Empty : dkProcedureSearchBox3.ProcedureIDS;
                //se.CJprocedureids = dkCJProcedureSearchBox.ProcedureIDS; //add xiacm 2022-11-09
                se.CreateTimeStart = this.dtpAccountDateStart.Value;
                se.CreateTimeEnd = this.dtpAccountDateEnd.Value;

                se.DefectCode = this.txtDefectCode.Text.Trim();
                se.DefectName = this.txtDefectName.Text.Trim();

                se.OutKilnNumByGoodsType = this.chkOutKilnNum.Checked;

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

  //      /// <summary>
		///// 获取权限（成检工序）
		///// </summary>
		//protected void getPurview()
  //      {
  //          try
  //          {
  //              StringBuilder sbProcedurePurview = new StringBuilder();
  //              StringBuilder CJProcedure = 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)
  //                      {
  //                          //add xiacm 2022-10-25 成检工序数据
  //                          this.dkCJProcedureSearchBox.Purview = sbProcedurePurview.ToString().Substring(Constant.INT_IS_ZERO, sbProcedurePurview.Length - 1);
  //                          SearchProductionLineEntity line = new SearchProductionLineEntity();
  //                          DataSet dsCJProcedure = SystemModuleProxy.Service.GetProdureList(line);
  //                          DataRow[] drCJProcedure = dsCJProcedure.Tables[Constant.INT_IS_ZERO].Select("FINISHEDCHECKPROCEDUREID is not null and ProcedureID in (" + sbProcedurePurview.ToString().Substring(Constant.INT_IS_ZERO, sbProcedurePurview.Length - 1) + ")");
  //                          foreach (DataRow item in drCJProcedure)
  //                          {
  //                              CJProcedure.Append(item["FINISHEDCHECKPROCEDUREID"].ToString() + ",");
  //                          }
  //                          if (CJProcedure.Length > 0)
  //                          {
  //                              this.dkCJProcedureSearchBox.Purview = CJProcedure.ToString().Substring(Constant.INT_IS_ZERO, CJProcedure.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)
  //                      {


  //                          //add xiacm 2022-10-25 成检工序数据
  //                          this.dkCJProcedureSearchBox.Purview = sbProcedurePurview.ToString().Substring(Constant.INT_IS_ZERO, sbProcedurePurview.Length - 1);

  //                          DataRow[] drCJProcedure = dsProcedurePurview.Tables[Constant.INT_IS_ZERO].Select("FINISHEDCHECKPROCEDUREID is not null and ProcedureID in (" + sbProcedurePurview.ToString().Substring(Constant.INT_IS_ZERO, sbProcedurePurview.Length - 1) + ")");
  //                          foreach (DataRow item in drCJProcedure)
  //                          {
  //                              CJProcedure.Append(item["FINISHEDCHECKPROCEDUREID"].ToString() + ",");
  //                          }
  //                          if (CJProcedure.Length > 0)
  //                          {
  //                              this.dkCJProcedureSearchBox.Purview = CJProcedure.ToString().Substring(Constant.INT_IS_ZERO, CJProcedure.Length - 1);
  //                          }
  //                      }
  //                  }
  //              }
  //          }
  //          catch (Exception ex)
  //          {
  //              throw ex;
  //          }
  //      }
        #endregion

        private void dgvRptProcedure_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
        {
            //string colName = this.dgvRptProcedure.Columns[e.ColumnIndex].Name;
            //if ("DefectPercent1" == colName)
            //{
            //    if(Convert.ToDecimal(e.Value) == -1)
            //    {
            //        e.Value = "N/A";
            //    }
            //}
        }
    }
}