IMEX.mes.wcf/DK.Client/PMModule/F_PM_2112.cs

/*******************************************************************************
 * Copyright(c) 2015 DongkeSoft All rights reserved. / Confidential
 * 类的信息：
 *      1.程序名称：F_PM_2112.cs
 *      2.功能描述：查询在产临时表数据
 * 编辑履历：
 *      作者            日期                版本            修改内容
 *      王鑫          2015/08/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.PMModule
{
    public partial class F_PM_2112 : DKDockPanelBase
    {
        #region 成员变量

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

        #endregion

        #region 构造函数

        public F_PM_2112()
        {
            InitializeComponent();
            //自动适应列宽
            this.tsbtnAdaptive.Text = ButtonText.TSBTN_ADAPTIVE;
            //关闭
            this.tsbtnClose.Text = ButtonText.TSBTN_CLOSE;
            //查询
            this.btnSearch.Text = ButtonText.BTN_SEARCH;
            // 清除选择
            this.tsbtnClearSelected.Text = ButtonText.TSBTN_CLEARSELECTED;
            //批量清除
            this.tsbtnAllClear.Text = ButtonText.TSBTN_CLEARALL;
            //清空条件
            this.btnClearCondition.Text = ButtonText.BTN_CLEARCONDITION;
            //查询条件
            this.gbxCondition.Text = Constant.LABEL_QUERY_CONDITIONS;
            // 窗体显示的Title
            this.Text = FormTitles.F_PM_2112;
            //恢复数据
            this.tsbtnResetData.Text = ButtonText.TSBTN_RESETDATA;
            this.tsbtnResetSelected.Text = ButtonText.TSBTN_RESETSELECTEDDATA;
        }

        #endregion

        #region 单例模式

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

        #endregion

        #region 事件

        /// <summary>
        /// 窗体加载事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void F_PM_2112_Load(object sender, EventArgs e)
        {
            try
            {
                // 加载权限 
                FormPermissionManager.FormPermissionControl(this.Name, this,
                    LogInUserInfo.CurrentUser.CurrentUserEntity.UserRightData,
                        LogInUserInfo.CurrentUser.CurrentUserEntity.FunctionData);
                this.tsbtnClearSelected.Visible = false;
                this.tsbtnAllClear.Visible = false;

                // 设置表格不自动创建列
                this.dgvInProduction.AutoGenerateColumns = false;
                // 初始化时间控件为当前日期
                this.dtpUpdateTimeStart.Value = DateTime.Now.Date;
                this.dtpUpdateTimeEnd.Value = DateTime.Now.Date;
                this.dtpScrapDate.Value = DateTime.Now.Date;
                this.dtpScrapDateEnd.Value = DateTime.Now.Date;
                this.dtpDeletedDateStart.Value = DateTime.Now.Date;
                this.dtpDeletedDateEnd.Value = DateTime.Now.Date;

                this.dtpScrapDate.Enabled = false;
                this.dtpScrapDateEnd.Enabled = false;
                this.dtpDeletedDateStart.Enabled = false;
                this.dtpDeletedDateEnd.Enabled = false;

                this.dtpUpdateTimeStart.Enabled = false;
                this.dtpUpdateTimeEnd.Enabled = false;

                this.dtpDeletedDateStart.Enabled = false;
                this.dtpDeletedDateEnd.Enabled = false;
                //绑定产品分级
                BindGoodsType();
                //绑定数据来源
                BindComDataSource();
            }
            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_PM_2112_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.dgvInProduction.DataSource = null;
                this.dgvInProduction.DataSource = this.GetSearchData();
                chkAll_CheckedChanged(null, null);
            }
            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 tsbtnAdaptive_Click(object sender, EventArgs e)
        {
            this.dgvInProduction.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells);
        }

        /// <summary>
        /// 清空条件按钮事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btnClearCondition_Click(object sender, EventArgs e)
        {
            //清空更多条件内容
            this.dkProcedureSearchBox.ClearControl();
            this.dkproductionLineSearchBox.ClearControl();
            this.dtpUpdateTimeStart.Value = DateTime.Now.Date;
            this.dtpUpdateTimeEnd.Value = DateTime.Now.Date;
            this.dtpScrapDate.Value = DateTime.Now.Date;
            this.dtpScrapDateEnd.Value = DateTime.Now.Date;
            this.dtpDeletedDateStart.Value = DateTime.Now.Date;
            this.dtpDeletedDateEnd.Value = DateTime.Now.Date;

            this.comGoodsType.SelectedValue = -100;
            this.dkProcedureSearchBox.ProcedureIDS = this._currentUserPurview;
            this.dkproductionLineSearchBox.ProductionLineIDS = this._currentUserLinePuview;
            this.cmbDataSource.SelectedValue = 0;
            this.chkDateTime.Checked = false;
            this.chkScrapDate.Checked = false;
            this.chkDeletedate.Checked = false;
            this.txtBarcode.Text = "";
            chkAll.Checked = false;
        }

        /// <summary>
        /// 清除选择按钮事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void tsbtnClearSelected_Click(object sender, EventArgs e)
        {
            try
            {
                DataTable dt = this.dgvInProduction.DataSource as DataTable;
                if (dt == null)
                {
                    return;
                }
                dt.AcceptChanges();
                DataRow[] dr = dt.Select("Sel=1");
                if (dr.Length == 0)
                {
                    MessageBox.Show("请选择清除在产临时数据",
                          this.Text, MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    return;
                }
                DialogResult dialogResult
                    = MessageBox.Show("确认是否清除选中的在产临时数据？",
                      this.Text, MessageBoxButtons.YesNo, MessageBoxIcon.Question);
                if (dialogResult.Equals(DialogResult.No))
                {
                    return;
                }
                string barcodes = "";
                foreach (DataRow r in dr)
                {
                    barcodes += r["barcode"].ToString() + ",";
                }

                barcodes = barcodes.TrimEnd(',');
                // 清除
                int result = (int)DoAsync(() =>
                {
                    return PMModuleProxy.Service.SaveClearInproductionTmp(barcodes);
                });
                if (result > Constant.INT_IS_ZERO)
                {
                    MessageBox.Show(string.Format(Messages.MSG_CMN_I001, "在产临时表", "清除数据"),
                        this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
                    // 刷新窗口数据
                    this.btnSearch_Click(sender, e);
                }
                else
                {
                    MessageBox.Show(string.Format(Messages.MSG_CMN_W001, "在产临时表", "清除数据"),
                        this.Text, MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    return;
                }
            }
            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 tsbtnAllClear_Click(object sender, EventArgs e)
        {
            try
            {
                F_PM_2113 frmPM2113 = new F_PM_2113();
                DialogResult dialogResult = frmPM2113.ShowDialog();
                // 重新加载GridView
                if (dialogResult == DialogResult.OK)
                {
                    btnSearch_Click(sender, e);
                }
            }
            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 tsbtnResetData_Click(object sender, EventArgs e)
        {
            try
            {
                F_PM_2114 frmPM2114 = new F_PM_2114();
                DialogResult dialogResult = frmPM2114.ShowDialog();
                // 重新加载GridView
                if (dialogResult == DialogResult.OK)
                {
                    btnSearch_Click(sender, e);
                }
            }
            catch (Exception ex)
            {
                // 对异常进行共通处理
                ExceptionManager.HandleEventException(this.ToString(),
                    System.Reflection.MethodBase.GetCurrentMethod().Name, this.Text, ex);
            }
        }

        private void dgvInProduction_CurrentCellDirtyStateChanged(object sender, EventArgs e)
        {
            try
            {
                if (this.dgvInProduction.CurrentRow != null && this.dgvInProduction.IsCurrentCellDirty)
                {
                    if ("Sel".Equals(this.dgvInProduction.Columns
                            [this.dgvInProduction.CurrentCell.ColumnIndex].Name))
                    {
                        this.dgvInProduction.CommitEdit(DataGridViewDataErrorContexts.Commit);
                    }
                }
            }
            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 cmbDataSource_SelectedIndexChanged(object sender, EventArgs e)
        {
            if (cmbDataSource.SelectedIndex == 0)
            {
                this.dtpScrapDate.Enabled = false;
                this.dtpScrapDateEnd.Enabled = false;
                if (!this.chkDateTime.Checked)
                {
                    this.dtpUpdateTimeStart.Enabled = false;
                    this.dtpUpdateTimeEnd.Enabled = false;
                }
                this.chkScrapDate.Enabled = false;
                this.comGoodsType.SelectedValue = -100;
                this.comGoodsType.Enabled = false;
                this.chkScrapDate.Checked = false;
            }
            else
            {
                //this.dtpScrapDate.Enabled = true;
                //this.dtpScrapDateEnd.Enabled = true;
                //this.dtpUpdateTimeStart.Enabled = true;
                //this.dtpUpdateTimeEnd.Enabled = true;

                if (this.chkDateTime.Checked)
                {
                    this.dtpUpdateTimeStart.Enabled = true;
                    this.dtpUpdateTimeEnd.Enabled = true;
                }
               // this.chkDateTime.Checked = false;
                this.chkScrapDate.Enabled = true;
                this.comGoodsType.Enabled = true;
            }
        }

        /// <summary>
        /// 恢复选定数据按钮事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void tsbtnResetSelected_Click(object sender, EventArgs e)
        {
            try
            {
                DataTable dt = this.dgvInProduction.DataSource as DataTable;
                if (dt == null)
                {
                    return;
                }
                dt.AcceptChanges();
                DataRow[] dr = dt.Select("Sel=1");
                if (dr.Length == 0)
                {
                    MessageBox.Show("请选择恢复的数据",
                          this.Text, MessageBoxButtons.OK, MessageBoxIcon.Question);
                    return;
                }
                DialogResult dialogResult
                    = MessageBox.Show("确认是否恢复选中的在产临时数据？",
                      this.Text, MessageBoxButtons.YesNo, MessageBoxIcon.Question);
                if (dialogResult.Equals(DialogResult.No))
                {
                    return;
                }
                string barcodes = "";
                foreach (DataRow r in dr)
                {
                    barcodes += r["barcode"].ToString() + ",";
                }

                barcodes = barcodes.TrimEnd(',');
                // 恢复
                int returnValue = (int)DoAsync(new AsyncMethod(() =>
                {
                    return PMModuleProxy.Service.ResetSelectedBarCode(barcodes);
                }));
                if (returnValue == -1)
                {
                    MessageBox.Show("此条码没有清除，不能恢复", this.Text,
                        MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    return;
                }
                else if (returnValue == 0)
                {
                    MessageBox.Show("没有可恢复的数据", this.Text,
                        MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    return;
                }
                else if (returnValue > 0)
                {
                    MessageBox.Show("恢复数据成功", this.Text,
                       MessageBoxButtons.OK, MessageBoxIcon.Information);
                    // 刷新窗口数据
                    this.btnSearch_Click(sender, e);
                }

            }
            catch (Exception ex)
            {
                // 对异常进行共通处理
                ExceptionManager.HandleEventException(this.ToString(),
                    System.Reflection.MethodBase.GetCurrentMethod().Name, this.Text, ex);
            }
        }

        private void chkDateTime_CheckedChanged(object sender, EventArgs e)
        {
            dtpUpdateTimeStart.Enabled = chkDateTime.Checked;
            dtpUpdateTimeEnd.Enabled = chkDateTime.Checked;
        }

        private void chkScrapDate_CheckedChanged(object sender, EventArgs e)
        {
            dtpScrapDate.Enabled = chkScrapDate.Checked;
            dtpScrapDateEnd.Enabled = chkScrapDate.Checked;
        }

        private void chkDeletedate_CheckedChanged(object sender, EventArgs e)
        {
            dtpDeletedDateStart.Enabled = chkDeletedate.Checked;
            dtpDeletedDateEnd.Enabled = chkDeletedate.Checked;
        }

        /// <summary>
        /// 全选改变事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void chkAll_CheckedChanged(object sender, EventArgs e)
        {
            try
            {
                DataTable dtInProduction = dgvInProduction.DataSource as DataTable;
                if (dtInProduction == null || dtInProduction.Rows.Count == 0)
                {
                    return;
                }

                int isChoose = chkAll.Checked ? 1 : 0;
                foreach (DataRow row in dtInProduction.Rows)
                {
                    row["Sel"] = isChoose;
                }
            }
            catch (Exception ex)
            {
                // 对异常进行共通处理
                ExceptionManager.HandleEventException(this.ToString(),
                    System.Reflection.MethodBase.GetCurrentMethod().Name, this.Text, ex);
            }
        }
        #endregion

        #region  私有方法

        /// <summary>
        /// 根据界面查询条件获取数据集
        /// </summary>
        private DataTable GetSearchData()
        {
            try
            {
                FPM2112_SE se = new FPM2112_SE();
                se.ProductionLineIDS = dkproductionLineSearchBox.ProductionLineIDS;
                se.ProcedureIDS = dkProcedureSearchBox.ProcedureIDS;

                if (this.chkDateTime.Checked)
                {
                    se.UpdateTimeStart = DateTime.Parse(this.dtpUpdateTimeStart.Value.ToString("yyyy-MM-dd") + " 0:0:0");
                    se.UpdateTimeEnd = DateTime.Parse(this.dtpUpdateTimeEnd.Value.ToString("yyyy-MM-dd") + " 23:59:59");
                }

                if (this.chkScrapDate.Checked)
                {
                    //报废日期
                    se.ScrapDataStart = DateTime.Parse(this.dtpScrapDate.Value.ToString("yyyy-MM-dd") + " 0:0:0");
                    se.ScrapDataEnd = DateTime.Parse(this.dtpScrapDateEnd.Value.ToString("yyyy-MM-dd") + " 0:0:0");
                }

                if(this.chkDeletedate.Checked)
                {
                    se.DeletedTimeStart = DateTime.Parse(this.dtpDeletedDateStart.Value.ToString("yyyy-MM-dd") + " 0:0:0");
                    se.DeletedTimeEnd = DateTime.Parse(this.dtpDeletedDateEnd.Value.ToString("yyyy-MM-dd") + " 23:59:59");
                }

                se.GooddLevelTypeID = Convert.ToInt32(comGoodsType.SelectedValue);
                se.TrashFlag = Convert.ToInt32(cmbDataSource.SelectedValue);
                se.Barcode = this.txtBarcode.Text.Trim();
                // 调用服务器端获取数据集
                ServiceResultEntity sre = DoAsync<ServiceResultEntity>(() =>
                {
                    return PMModuleProxy.Service.GetPM2112Data(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>
        private void BindGoodsType()
        {
            DataTable dt = new DataTable();
            dt.Columns.Add("GoodsLevelTypeID");
            dt.Columns.Add("GoodsLevelTypeName");
            DataRow dr = dt.NewRow();
            dr["GoodsLevelTypeID"] = -100;
            dr["GoodsLevelTypeName"] = "";
            dt.Rows.Add(dr);

            dr = dt.NewRow();
            dr["GoodsLevelTypeID"] = 8;
            dr["GoodsLevelTypeName"] = "损坯";
            dt.Rows.Add(dr);

            dr = dt.NewRow();
            dr["GoodsLevelTypeID"] = 7;
            dr["GoodsLevelTypeName"] = "次品";
            dt.Rows.Add(dr);

            dr = dt.NewRow();
            dr["GoodsLevelTypeID"] = 3;
            dr["GoodsLevelTypeName"] = "废品";
            dt.Rows.Add(dr);

            dr = dt.NewRow();
            dr["GoodsLevelTypeID"] = 13;
            dr["GoodsLevelTypeName"] = "不合格";
            dt.Rows.Add(dr);

            dr = dt.NewRow();
            dr["GoodsLevelTypeID"] = 14;
            dr["GoodsLevelTypeName"] = "不合格(返)";
            dt.Rows.Add(dr);

            this.comGoodsType.DataSource = dt;
            this.comGoodsType.DisplayMember = "GoodsLevelTypeName";
            this.comGoodsType.ValueMember = "GoodsLevelTypeID";
        }

        /// <summary>
        /// 绑定数据来源
        /// </summary>
        private void BindComDataSource()
        {
            DataTable dt = new DataTable();
            dt.Columns.Add("DataSourceID");
            dt.Columns.Add("DataSourceName");

            DataRow dr = dt.NewRow();
            dr["DataSourceID"] = 0;
            dr["DataSourceName"] = "在产";
            dt.Rows.Add(dr);

            dr = dt.NewRow();
            dr["DataSourceID"] = 1;
            dr["DataSourceName"] = "回收站";
            dt.Rows.Add(dr);

            this.cmbDataSource.DataSource = dt;
            this.cmbDataSource.DisplayMember = "DataSourceName";
            this.cmbDataSource.ValueMember = "DataSourceID";
        }

        #endregion
    }
}