IMEX.mes.wcf/DK.Client/SystemModule/F_MST_0407.cs

/*******************************************************************************
 * Copyright(c) 2014 dongke All rights reserved. / Confidential
 * 类的信息：
 *      1.程序名称：F_MST_0407.cs
 *      2.功能描述：产品缺陷
 * 编辑履历：
 *      作者            日期                版本            修改内容
 *      任海            2014/09/10          1.00            新建
 *******************************************************************************/

using System;
using System.Data;
using System.Windows.Forms;

using Dongke.IBOSS.PRD.Basics.BaseResources;
using Dongke.IBOSS.PRD.Basics.BaseControls;
using Dongke.IBOSS.PRD.Client.CommonModule;
using Dongke.IBOSS.PRD.Basics.Library;
using Dongke.IBOSS.PRD.WCF.Proxys;
using Dongke.IBOSS.PRD.Client.DataModels;

namespace Dongke.IBOSS.PRD.Client.SystemModule
{
    /// <summary>
    /// 产品缺陷
    /// </summary>
    public partial class F_MST_0407 : FormBase
    {
        #region 成员变量

        // 窗体的单例模式
        private static F_MST_0407 _instance;
        // 产品缺陷数据源
        private DataTable _dtSourse;

        // 缺陷类别
        private int _DefectTypeId = Constant.INT_IS_ZERO;

        #endregion

        #region 构造函数

        /// <summary>
        /// 构造函数
        /// </summary>
        public F_MST_0407()
        {
            InitializeComponent();
            // 窗口标题
            this.Text = FormTitles.F_MST_0407;
            // 按钮
            this.btnSave.Text = ButtonText.BTN_SAVE;
            this.btnCancel.Text = ButtonText.BTN_CLOSE;
        }

        #endregion

        #region 单例模式

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

        #endregion

        #region 事件

        /// <summary>
        /// 窗体加载
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void F_MST_0407_Load(object sender, System.EventArgs e)
        {
            try
            {
                // 设置datagridview不自动创建列
                this.dgvDataDefect.AutoGenerateColumns = false;
                // 加载产品缺陷管理数据
                // 窗体启动立即加载全部产品缺陷信息
                this.GetAllDefect();
                this.RefreshDataGridViewData();
                this.dgvDataDefect.IsSetInputColumnsColor = true;

                // 绑定缺陷类型数据
                DataSet dsResultAccount = (DataSet)DoAsync(new BaseAsyncMethod(() =>
                {
                    return SystemModuleProxy.Service.GetAllDefectTypeInfo();
                }));
                DataView dv = dsResultAccount.Tables[0].DefaultView;
                dv.RowFilter = "valueflag=1";
                DataTable dtDefectType = dv.ToTable();
                this.DefectTypeID.ValueMember = "DefectTypeID";
                this.DefectTypeID.DisplayMember = "DefectTypeName";
                this.DefectTypeID.DataSource = dtDefectType;
                //把第一条数据绑定给窑炉类型
                if (dtDefectType != null && dtDefectType.Rows.Count > Constant.INT_IS_ZERO)
                {
                    this._DefectTypeId = Convert.ToInt32(dtDefectType.Rows[0]["DefectTypeID"]);
                }

                //权限控制
                FormPermissionManager.FormPermissionControl(this.Name, this,
                    LogInUserInfo.CurrentUser.CurrentUserEntity.UserRightData, LogInUserInfo.CurrentUser.CurrentUserEntity.FunctionData);
                this.dgvDataDefect.SelectionMode = DataGridViewSelectionMode.RowHeaderSelect;
            }
            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_MST_0407_FormClosing(object sender, FormClosingEventArgs e)
        {
            try
            {
                // 关闭的时候需要判断是否有数据变化
                if (DataJudge.IsChange((DataTable)this.dgvDataDefect.DataSource))
                {
                    DialogResult dialogResult = MessageBox.Show(Messages.MSG_CMN_Q001, this.Text,
                        MessageBoxButtons.YesNoCancel, MessageBoxIcon.Question);
                    // 保存改变的数据
                    if (dialogResult == DialogResult.Yes)
                    {
                        DataGridViewRow row = dgvDataDefect.CurrentRow;
                        if (!row.IsNewRow)
                        {
                            // 判断产品缺陷编码不能为空
                            if (row.Cells["DefectCode"].Value == null
                                || string.IsNullOrEmpty(row.Cells["DefectCode"].Value + string.Empty))
                            {
                                // 错误消息
                                MessageBox.Show(string.Format(Messages.MSG_CMN_W005, "产品缺陷编码"),
                                    this.Text, MessageBoxButtons.OK, MessageBoxIcon.Warning);
                                e.Cancel = true;
                                this.btnSave.Enabled = false;
                                return;
                            }
                            // 判断产品缺陷名称不能为空
                            if (row.Cells["DefectName"].Value == null
                                || string.IsNullOrEmpty(row.Cells["DefectName"].Value + string.Empty))
                            {
                                // 单元格的错误消息
                                MessageBox.Show(string.Format(Messages.MSG_CMN_W005, "产品缺陷名称"),
                                    this.Text, MessageBoxButtons.OK, MessageBoxIcon.Warning);
                                e.Cancel = true;
                                this.btnSave.Enabled = false;
                                return;
                            }
                            // 判断缺陷类别不能为空
                            if (row.Cells["DefectTypeID"].Value == null
                                || string.IsNullOrEmpty(row.Cells["DefectTypeID"].Value + string.Empty))
                            {
                                // 单元格的错误消息
                                MessageBox.Show(string.Format(Messages.MSG_CMN_W005, "缺陷类别"),
                                    this.Text, MessageBoxButtons.OK, MessageBoxIcon.Warning);
                                e.Cancel = true;
                                this.btnSave.Enabled = false;
                                return;
                            }
                        }
                        // 异步处理
                        object result = DoAsync(new BaseAsyncMethod(SaveDefectData));
                        if (result.Equals(Constant.INT_IS_ONE))
                        {
                            MessageBox.Show(string.Format(Messages.MSG_CMN_W006, "产品缺陷编码"),
                                this.Text, MessageBoxButtons.OK, MessageBoxIcon.Warning);
                            e.Cancel = true;
                            this.btnSave.Enabled = false;
                            return;
                        }
                        // 保存成功，不关闭窗体
                        if (Convert.ToInt32(result) > Constant.INT_IS_ZERO)
                        {
                            e.Cancel = true;
                            MessageBox.Show(string.Format(Messages.MSG_CMN_I001, "产品缺陷管理", "保存"),
                                this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
                            this.btnSave.Enabled = false;
                            // 加载产品缺陷管理数据
                            this._dtSourse.AcceptChanges();
                        }
                        else if (Convert.ToInt32(result) == (int)Constant.RETURN_IS_EXIST)
                        {
                            e.Cancel = true;
                            MessageBox.Show(string.Format(Messages.MSG_CMN_W006, "产品缺陷名称"),
                                this.Text, MessageBoxButtons.OK, MessageBoxIcon.Warning);
                        }
                        else
                        {
                            e.Cancel = true;
                            MessageBox.Show(string.Format(Messages.MSG_CMN_W001, "产品缺陷管理", "保存"),
                                this.Text, MessageBoxButtons.OK, MessageBoxIcon.Warning);
                        }
                    }
                    else if (dialogResult == DialogResult.Cancel)
                    {
                        e.Cancel = 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 F_MST_0407_FormClosed(object sender, FormClosedEventArgs e)
        {
            _instance = null;
        }

        /// <summary>
        /// 选中新行时，设置默认值
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void dgvDataDefect_DefaultValuesNeeded(object sender, DataGridViewRowEventArgs e)
        {
            // 设置有效属性为选中状态
            e.Row.Cells["ValueFlag"].Value = Constant.INT_IS_ONE;
            if (_DefectTypeId > 0)
            {
                e.Row.Cells["DefectTypeID"].Value = _DefectTypeId;
            }
            e.Row.Cells["DisplayNo"].Value = e.Row.Index + 1;
        }

        /// <summary>
        /// 产品缺陷管理信息输入格式控制
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void dgvDataDefect_EditingControlShowing(object sender, DataGridViewEditingControlShowingEventArgs e)
        {
            try
            {
                // 只对文本框做控制
				//if (e.Control is DataGridViewTextBoxEditingControl)
				//{
				//	DataGridViewTextBoxEditingControl EditingControl = (DataGridViewTextBoxEditingControl)e.Control;
				//}
				TextBox tb = (e.Control as TextBox);
				if (tb != null)
				{
					if ("DefectCode" == this.dgvDataDefect.Columns[this.dgvDataDefect.CurrentCell.ColumnIndex].Name)
					{
						tb.CharacterCasing = CharacterCasing.Upper;
					}
					else
					{
						tb.CharacterCasing = CharacterCasing.Normal;
					}
				}
            }
            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 dgvDataDefect_CellValidating(object sender, DataGridViewCellValidatingEventArgs e)
        {
            try
            {
                if (this.ActiveControl != null && "btnClose".Equals(this.ActiveControl.Name))
                {
                    return;
                }
                if (!dgvDataDefect.CurrentRow.IsNewRow)
                {
                    DataGridViewRow rowItem = dgvDataDefect.Rows[e.RowIndex];
                    DataGridViewColumn columnItem = dgvDataDefect.Columns[e.ColumnIndex];
                    object columnvalue = rowItem.Cells[columnItem.Name].EditedFormattedValue;
                    // 产品缺陷编码
                    if ("DefectCode".Equals(columnItem.Name))
                    {
                        if (columnvalue != null && !string.IsNullOrEmpty(columnvalue + string.Empty))
                        {
                            if (!Utility.IsUnique(columnvalue.ToString(),
                                dgvDataDefect.CurrentRow.Index, this.dgvDataDefect, "DefectCode"))
                            {
                                // 单元格的错误消息
                                this.dgvDataDefect.CurrentRow.ErrorText = string.Format(
                                    Messages.MSG_CMN_W006, "产品缺陷编码");
                                e.Cancel = true;
                                this.btnSave.Enabled = false;
                                return;
                            }
                        }
                    }
                    // 清除单元格的错误消息
                    this.dgvDataDefect.CurrentRow.ErrorText = string.Empty;
                }
            }
            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 dgvDataDefect_CellValidated(object sender, DataGridViewCellEventArgs e)
        {
            try
            {
                this.SetSaveBtnStatus();
            }
            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 dgvDataDefect_RowValidating(object sender, DataGridViewCellCancelEventArgs e)
        {
            try
            {
                // 按Esc键时不校验
                if (!dgvDataDefect.IsCurrentRowDirty)
                {
                    this.dgvDataDefect.IsSetInputColumnsColor = true;
                    return;
                }
                if (this.ActiveControl != null && "btnClose".Equals(this.ActiveControl.Name))
                {
                    // 清除单元格的错误消息
                    this.dgvDataDefect.CurrentRow.ErrorText = string.Empty;
                    return;
                }
                DataGridViewRow row = dgvDataDefect.CurrentRow;
                if (!row.IsNewRow)
                {
                    // 判断产品缺陷编码能为空
                    if (row.Cells["DefectCode"].Value == null
                        || string.IsNullOrEmpty(row.Cells["DefectCode"].Value + string.Empty))
                    {
                        // 单元格的错误消息
                        this.dgvDataDefect.CurrentRow.ErrorText = string.Format(Messages.MSG_CMN_W005, "产品缺陷编码");
                        e.Cancel = true;
                        this.btnSave.Enabled = false;
                        return;
                    }
                    // 判断产品缺陷名称不能为空
                    if (row.Cells["DefectName"].Value == null
                        || string.IsNullOrEmpty(row.Cells["DefectName"].Value + string.Empty))
                    {
                        // 单元格的错误消息
                        this.dgvDataDefect.CurrentRow.ErrorText = string.Format(Messages.MSG_CMN_W005, "产品缺陷名称");
                        e.Cancel = true;
                        this.btnSave.Enabled = false;
                        return;
                    }

                    // 判断窑炉类别不能为空
                    if (row.Cells["DefectTypeID"].Value == null
                        || string.IsNullOrEmpty(row.Cells["DefectTypeID"].Value + string.Empty))
                    {
                        // 单元格的错误消息
                        this.dgvDataDefect.CurrentRow.ErrorText = string.Format(Messages.MSG_CMN_W005, "缺陷类别");
                        e.Cancel = true;
                        this.btnSave.Enabled = false;
                        return;
                    }
                    // 清除单元格的错误消息
                    this.dgvDataDefect.CurrentRow.ErrorText = string.Empty;
                }
            }
            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 dgvDataDefect_RowValidated(object sender, DataGridViewCellEventArgs e)
        {
            try
            {
                this.SetSaveBtnStatus();
            }
            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 chkDisplayDisabledData_CheckedChanged(object sender, EventArgs e)
        {
            try
            {
                this.RefreshDataGridViewData();
                this.SetSaveBtnStatus();
                this.dgvDataDefect.IsSetInputColumnsColor = 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 dgvDataDefect_UserAddedRow(object sender, DataGridViewRowEventArgs e)
        {
            this.dgvDataDefect.IsSetInputColumnsColor = true;
        }

        /// <summary>
        /// 设置排序时列表的颜色
        /// </summary>
        private void dgvDataDefect_Sorted(object sender, EventArgs e)
        {
            this.dgvDataDefect.IsSetInputColumnsColor = true;
        }

        /// <summary>
        /// 保存产品缺陷数据
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btnSave_Click(object sender, EventArgs e)
        {
            try
            {
                int results = Conservation();
                //判断单元格必输项不能为空
                if (results == Constant.INT_IS_ONE)
                {
                    MessageBox.Show(string.Format(Messages.MSG_CMN_W005, "产品缺陷编码"),
                        this.Text, MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    this.btnSave.Enabled = false;
                    return;
                }
                if (results == Constant.INT_IS_TWO)
                {
                    MessageBox.Show(string.Format(Messages.MSG_CMN_W005, "产品缺陷名称"),
                        this.Text, MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    this.btnSave.Enabled = false;
                    return;
                }
                if (results == Constant.INT_IS_THREE)
                {
                    MessageBox.Show(string.Format(Messages.MSG_CMN_W005, "缺陷类别"),
                        this.Text, MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    this.btnSave.Enabled = false;
                    return;
                }
                // 异步处理
                this.btnSave.Enabled = false;
                this.btnCancel.Enabled = false;
                int result = (int)DoAsync(new BaseAsyncMethod(SaveDefectData));
                this.btnSave.Enabled = true;
                this.btnCancel.Enabled = true;
                // 产品缺陷数据保存成功
                if (result == Constant.INT_IS_TWO)
                {
                    MessageBox.Show(string.Format(Messages.MSG_CMN_I001, "产品缺陷管理", "保存"),
                        this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
                    // 加载产品缺陷管理数据
                    this._dtSourse.AcceptChanges();
                    this.btnSave.Enabled = false;
                }
                else if (result == Constant.INT_IS_ONE)
                {
                    MessageBox.Show(string.Format(Messages.MSG_CMN_W006, "产品缺陷编码"),
                        this.Text, MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    return;
                }
                else
                {
                    MessageBox.Show(string.Format(Messages.MSG_CMN_W001, "产品缺陷管理", "保存"),
                        this.Text, MessageBoxButtons.OK, MessageBoxIcon.Warning);
                }
                this.dgvDataDefect.IsSetInputColumnsColor = true;
            }
            catch (Exception ex)
            {
                this.btnSave.Enabled = true;
                this.btnCancel.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 btnCancel_Click(object sender, EventArgs e)
        {
            this.Close();
        }

        #endregion

        #region 私有方法

        /// <summary>
        /// 加载产品缺陷管理数据
        /// </summary>
        /// <returns></returns>
        private DataSet GetDefectData()
        {
            try
            {
                byte valueFlag = Convert.ToByte(chkDisplayDisabledData.Checked);
                return SystemModuleProxy.Service.GetDefectData(valueFlag);

            }
            catch (Exception ex)
            {
                throw ex;
            }
        }

        /// <summary>
        /// 获取产品缺陷管理的全部数据
        /// </summary>
        /// <param name="sUserInfo">用户信息</param>
        /// <returns></returns>
        /// <remarks>
        /// 2014.10.30      任海      新建
        /// </remarks>
        private void GetAllDefect()
        {
            try
            {
                DataSet dsResultAccount = (DataSet)DoAsync(new BaseAsyncMethod(() =>
                {
                    return SystemModuleProxy.Service.GetAllDefectInfo();
                }));
                this._dtSourse = dsResultAccount.Tables[0];
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }

        /// <summary>
        /// 得到产品缺陷信息
        /// </summary>
        /// <returns></returns>
        private void RefreshDataGridViewData()
        {
            try
            {
                if (this.chkDisplayDisabledData.Checked == false)
                {
                    this._dtSourse.DefaultView.RowFilter = "ValueFlag=1";
                }
                else
                {
                    this._dtSourse.DefaultView.RowFilter = null;
                }
                this.dgvDataDefect.DataSource = _dtSourse;
                this.btnSave.Enabled = false;
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }

        /// <summary>
        /// 保存产品缺陷数据
        /// </summary>
        /// <returns>是否成功</returns>
        private object SaveDefectData()
        {
            try
            {
                // 获取当前dataDefectData数据源
                DataTable dataDefectData = (DataTable)this.dgvDataDefect.DataSource;
                int result = SystemModuleProxy.Service.SaveDefectData(dataDefectData);
                return result;
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }

        /// <summary>
        /// 设置保存按钮的可用状态
        /// </summary>
        private void SetSaveBtnStatus()
        {
            if (DataJudge.IsChange((DataTable)this.dgvDataDefect.DataSource))
            {
                this.btnSave.Enabled = true;
            }
            else
            {
                this.btnSave.Enabled = false;
            }
        }

        /// <summary>
        /// 保存时单元格必输项不能为空
        /// </summary>
        private int Conservation()
        {
            int isConservation = Constant.INT_IS_ZERO;
            DataTable dataDefectData = (DataTable)this.dgvDataDefect.DataSource;
            foreach (DataRow drproductionData in dataDefectData.Rows)
            {
                //判断必输项是否为空
                if (drproductionData["DefectCode"].ToString() == string.Empty)
                {
                    isConservation = Constant.INT_IS_ONE;
                    break;
                }
                if (drproductionData["DefectName"].ToString() == string.Empty)
                {
                    isConservation = Constant.INT_IS_TWO;
                    break;
                }
                if (drproductionData["DefectTypeID"].ToString() == string.Empty)
                {
                    isConservation = Constant.INT_IS_THREE;
                    break;
                }
            }
            return isConservation;
        }

        #endregion
    }
}