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

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

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
{
    public partial class S_CMN_025 : FormBase
    {
        #region 成员变量

        private DataTable _dataSource;                          // 画面的数据源
        private DataRow _jobsRow;                       // 返回用户的DataRow

        private DataRow _productionLineRow;                 // 返回类别的DataRow
        private DataTable _dataDT;                          //返回选择数据源

        #endregion

        #region 构造函数

        /// <summary>
        /// 重载的构造函数
        /// </summary>
        public S_CMN_025()
        {
            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;
        }

        public S_CMN_025(int flag)
        {
            InitializeComponent();
            if (flag == 1)
            {
                this.Sel.Visible = true;
                this.chkChooseAll.Visible = true;
            }
            else
            {
                this.Sel.Visible = false;
                this.chkChooseAll.Visible = false;
            }
            // 按钮
            this.btnSearch.Text = ButtonText.BTN_SEARCH;
            this.btnOK.Text = ButtonText.BTN_OK;
            this.btnClose.Text = ButtonText.BTN_CANCEL;
            this.btnClearCondition.Text = ButtonText.BTN_CLEARCONDITION;
        }


        public S_CMN_025(string DefectFineCode)
        {
            InitializeComponent();
            this.txtDefectCode.Text = DefectFineCode;
            // 按钮
            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>
        public DataTable dataDT
        {
            get
            {
                return _dataDT;
            }
            set
            {
                _dataDT = value;
            }
        }


        /// <summary>
        /// 返回选择的组织行
        /// </summary>
        public DataRow ProductionLineRow
        {
            get
            {
                return _productionLineRow;
            }
            set
            {
                _productionLineRow = value;
            }
        }

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

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

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

        /// <summary>
        /// 返回选择的行
        /// </summary>
        public DataRow JobsRow
        {
            get
            {
                return _jobsRow;
            }
            set
            {
                _jobsRow = value;
            }
        }

        #endregion

        #region 控件事件

        /// <summary>
        /// 窗体加载
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void S_CMN_024_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.dgvJobs.AutoGenerateColumns = false;
                this.txtDefectCode.Text = SetDefectFineCodeCode;
                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 (dgvJobs.CurrentRow != null
                        && !string.IsNullOrEmpty(dgvJobs.CurrentRow.Cells[dgvJobs.CurrentCell.ColumnIndex].EditedFormattedValue + ""))
                    {
                        Clipboard.SetText(dgvJobs.CurrentRow.Cells[dgvJobs.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.dgvJobs.Rows.Count; i++)
                {
                    this.dgvJobs.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.dgvJobs.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.dgvJobs.DataSource = _dataSource.DefaultView.ToTable();
                this.dgvJobs.Focus();
            }
            // 当没有查询结果时，提示无查询结构消息
            if (this.dgvJobs.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
            {
                if (this.Sel.Visible)
                {
                    if (this.dgvJobs.CurrentCell != null)
                    {
                        this.dataDT = (DataTable)this.dgvJobs.DataSource;
                        this.DialogResult = DialogResult.OK;
                    }
                }
                else
                {
                    if (this.dgvJobs.CurrentCell != null)
                    {
                        ProductionLineRow = this.dgvJobs.GetDataRow(this.dgvJobs.CurrentCell.RowIndex);
                        this.DialogResult = DialogResult.OK;
                    }
                }
                this.Close();
            }
            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) || !string.IsNullOrEmpty(this.txtDefectName.Text))
            {
                // 编码条件
                strbFilterExpressions.Append(string.Format(" AND DefectCode LIKE '%{0}%'",
                    Utility.SelectFilterLike(this.txtDefectCode.Text.Trim())));
                // 名称条件
                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;
        }
    }
}