IMEX.mes.wcf/DK.Client/Client.Controls/FormCommon/S_CMN_014.cs

/*******************************************************************************
 * Copyright(c) 2012 dongke All rights reserved. / Confidential
 * 类的信息：
 *      1.程序名称：S_CMN_014.cs
 *      2.功能描述：缺陷控件查询界面
 * 编辑履历：
 *      作者            日期                版本            修改内容
 *      陈冰            2014/08/30          1.00            新建
 *******************************************************************************/

using System;
using System.ComponentModel;
using System.Data;
using System.Text;
using System.Windows.Forms;

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

namespace Dongke.IBOSS.PRD.Client.Controls
{
    /// <summary>
    /// 缺陷控件查询界面
    /// </summary>
    public partial class S_CMN_014 : FormBase
    {
        #region 成员变量

        private DataTable _dataSource;                      // 画面的数据源

        #endregion

        #region 属性

        /// <summary>
        /// 选择的数据
        /// </summary>
        public DataTable SelTable { get; set; }

        /// <summary>
        /// 传入的缺陷编码
        /// </summary>
        public string SetDefectCode { get; set; }

        #endregion

        #region 构造函数

        /// <summary>
        /// 重载的构造函数
        /// </summary>
        public S_CMN_014()
        {
            InitializeComponent();
            // 按钮
            this.btnSearch.Text = ButtonText.BTN_SEARCH;
            this.btnOK.Text = ButtonText.BTN_OK;
            this.btnClose.Text = ButtonText.BTN_CANCEL;
            this.btnClearCondition.Text = ButtonText.BTN_CLEARCONDITION;
        }

        #endregion

        #region 属性

        /// <summary>
        /// 获取或者设定画面的数据源。
        /// </summary>
        [Description("获取或者设定画面的数据源。")]
        public new DataTable DataSource
        {
            get
            {
                return _dataSource;
            }
            set
            {
                _dataSource = value;
            }
        }

        #endregion

        #region 控件事件

        /// <summary>
        /// 窗体加载
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void S_CMN_003_Load(object sender, EventArgs e)
        {
            try
            {
                // 绑定缺陷类型数据
                DataSet dsResultAccount = SystemModuleProxy.Service.GetAllDefectTypeInfo();
                DataView dv = dsResultAccount.Tables[0].DefaultView;
                dv.RowFilter = "valueflag=1";
                DataTable dtDefectType = dv.ToTable();
                DataRow nullrow = dtDefectType.NewRow();
                //nullrow["DefectTypeID"] = DBNull.Value;
                //nullrow["DefectTypeName"] = DBNull.Value;
                dtDefectType.Rows.InsertAt(nullrow, 0);
                this.cboDEFECTTYPENAME.ValueMember = "DefectTypeID";
                this.cboDEFECTTYPENAME.DisplayMember = "DefectTypeName";
                this.cboDEFECTTYPENAME.DataSource = dtDefectType;

                this.dgvDefect.AutoGenerateColumns = false;
                this.txtDefectCode.Text = SetDefectCode;
                if (!string.IsNullOrEmpty(this.txtDefectCode.Text))
                {
                    Search();
                }
            }
            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 btnSearch_Click(object sender, System.EventArgs e)
        {
            try
            {
                Search();
            }
            catch (Exception ex)
            {
                // 对异常进行共通处理
                ExceptionManager.HandleEventException(this.ToString(),
                    System.Reflection.MethodBase.GetCurrentMethod().Name, this.Text, ex);
            }
        }

        /// <summary>
        /// KeyDown事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void dgvOrganization_KeyDown(object sender, KeyEventArgs e)
        {
            try
            {
                // 拷贝单元格文本到剪切板
                if (e.KeyData == (Keys.Control | Keys.C))
                {
                    if (dgvDefect.CurrentRow != null
                        && !string.IsNullOrEmpty(dgvDefect.CurrentRow.Cells[dgvDefect.CurrentCell.ColumnIndex].EditedFormattedValue + ""))
                    {
                        Clipboard.SetText(dgvDefect.CurrentRow.Cells[dgvDefect.CurrentCell.ColumnIndex].EditedFormattedValue + "");
                    }
                }
                else if (e.KeyData == Keys.Enter)
                {
                    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 btnOK_Click(object sender, System.EventArgs e)
        {
            try
            {
                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 btnClose_Click(object sender, System.EventArgs e)
        {
            this.DialogResult = DialogResult.Cancel;
            this.Close();
        }

        /// <summary>
        /// 双击DataGridView窗体，返回选中记录
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void dgvOrganization_CellMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)
        {
            try
            {
                // 判断是否是双击列头，如果是双击列头的话，不做任何操作
                if (-1 < e.RowIndex && -1 < e.ColumnIndex)
                {
                    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 chkChooseAll_CheckedChanged(object sender, EventArgs e)
        {
            try
            {
                for (int i = 0; i < this.dgvDefect.Rows.Count; i++)
                {
                    this.dgvDefect.Rows[i].Cells["Sel"].Value = this.chkChooseAll.Checked;
                }
            }
            catch (Exception ex)
            {
                // 对异常进行共通处理
                ExceptionManager.HandleEventException(this.ToString(),
                    System.Reflection.MethodBase.GetCurrentMethod().Name, this.Text, ex);
            }
        }

        #endregion

        #region 私有方法

        /// <summary>
        /// 查询方法
        /// </summary>
        private void Search()
        {
            // 清空之前的查询结果

            this.dgvDefect.DataSource = null;
            if (_dataSource == null)
            {
                DataSet defectds = (DataSet)DoAsync(new BaseAsyncMethod(() =>
                {
                    return SystemModuleProxy.Service.GetDefectData(1);
                }));
                if (defectds != null
                    && defectds.Tables.Count > Constant.INT_IS_ZERO
                    && defectds.Tables[0].Rows.Count > Constant.INT_IS_ZERO)
                {
                    defectds.Tables[0].DefaultView.RowFilter = "valueflag =1";
                    _dataSource = defectds.Tables[0].DefaultView.ToTable();
                }
            }
            if (_dataSource != null)
            {
                _dataSource.DefaultView.RowFilter = GetFilterExpression();
                this.dgvDefect.DataSource = _dataSource.DefaultView.ToTable();
                this.dgvDefect.Focus();
            }
            // 当没有查询结果时，提示无查询结构消息
            if (this.dgvDefect.RowCount <= 0)
            {
                MessageBox.Show(ControlsTips.DK_SearchBox_NoResult,
                    this.Text,MessageBoxButtons.OK,MessageBoxIcon.Warning);
                this.txtDefectCode.Focus();
                this.btnOK.Enabled = false;
                return;
            }
            this.btnOK.Enabled = true;
        }

        /// <summary>
        /// 提交时给取得的行赋值
        /// </summary>
        private void Commit()
        {
            try
            {
                DataTable invDt = (DataTable)this.dgvDefect.DataSource;
                if (invDt == null || invDt.Rows.Count == Constant.INT_IS_ZERO)
                {
                    MessageBox.Show(string.Format(Messages.MSG_CMN_W007,
                        "没有选择数据"),this.Text,MessageBoxButtons.OK,MessageBoxIcon.Warning);
                    return;
                }
                invDt.AcceptChanges();
                invDt = invDt.Copy();
                string filter = "Sel = 1";
                invDt.DefaultView.RowFilter = filter;
                invDt = invDt.DefaultView.ToTable();
                // 如果选中了数据就关闭窗体，反之则不关
                if (invDt.Rows.Count > 0)
                {
                    SelTable = invDt;
                    this.DialogResult = DialogResult.OK;
                    this.Close();
                }
                else
                {
                    MessageBox.Show(string.Format(Messages.MSG_CMN_W007,
                        "没有选择数据"),this.Text,MessageBoxButtons.OK,MessageBoxIcon.Warning);
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }

        /// <summary>
        /// 根据画面输入内容拼接过滤条件
        /// </summary>
        /// <returns></returns>
        private string GetFilterExpression()
        {
            StringBuilder strbFilterExpressions = new StringBuilder();
            strbFilterExpressions.Append("(1=1");
            if (!string.IsNullOrEmpty(this.txtDefectCode.Text))
            {
                // 缺陷编码条件
                strbFilterExpressions.Append(string.Format(" AND DefectCode LIKE '%{0}%'",
                    Utility.SelectFilterLike(this.txtDefectCode.Text.Trim())));
            }
            if (!string.IsNullOrEmpty(this.txtDefectName.Text))
            {
                // 缺陷名称条件
                strbFilterExpressions.Append(string.Format(" AND DefectName LIKE '%{0}%'",
                    Utility.SelectFilterLike(this.txtDefectName.Text.Trim())));
            }
            if (!string.IsNullOrEmpty(this.cboDEFECTTYPENAME.Text))
            {
                // 缺陷名称条件
                strbFilterExpressions.Append(string.Format(" AND DEFECTTYPEID = {0}",
                    this.cboDEFECTTYPENAME.SelectedValue));
            }
            if (!string.IsNullOrWhiteSpace(this.txtREMARKS.Text))
            {
                // 缺陷名称条件
                strbFilterExpressions.Append(string.Format(" AND REMARKS LIKE '%{0}%'",
                    Utility.SelectFilterLike(this.txtREMARKS.Text.Trim())));
            }
            
            strbFilterExpressions.Append(")");
            return strbFilterExpressions.ToString();
        }

        #endregion

        private void btnClearCondition_Click(object sender, EventArgs e)
        {
            this.txtDefectCode.Clear();
            this.txtDefectName.Clear();
            this.txtREMARKS.Clear();
            this.cboDEFECTTYPENAME.SelectedIndex = -1;
        }
    }
}