IMEX.mes.wcf/DK.Client/HRModule/F_HR_1001.cs

/*******************************************************************************
 * Copyright(c) 2014 DongkeSoft All rights reserved. / Confidential
 * 类的信息：
 *      1.程序名称：F_HR_1001.cs
 *      2.功能描述：员工考勤
 * 编辑履历：
 *      作者            日期                版本            修改内容
 *      任海            2014/09/22          1.00            新建
 *******************************************************************************/

using System;
using System.Data;
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.DataModels;
using Dongke.IBOSS.PRD.WCF.Proxys;
using Dongke.IBOSS.PRD.WCF.Proxys.HRModuleService;
using Dongke.IBOSS.PRD.Client.Controls.FormCommon;
using Dongke.IBOSS.PRD.WCF.Proxys.CommonModuleService;
using Dongke.IBOSS.PRD.Basics.BaseControls;
using Dongke.IBOSS.PRD.Basics.Library;
using Dongke.IBOSS.PRD.WCF.DataModels;

namespace Dongke.IBOSS.PRD.Client.HRModule
{
    public partial class F_HR_1001 : DockPanelBase
    {
        #region 成员变量

        // 单例模式
        private static F_HR_1001 _instance;
        // 最后选择行
        //private int _selecedRow;
        //员工ID
        //private int _staffID;
        //Grid当前选中的行
        private int _selectedRowIndex;
        //用户编辑的ID集合
        int[] _staffIDList;
        // 查询条件实体
        private HR_CMN_StaffEntity _staffEntity = new HR_CMN_StaffEntity();

        #endregion

        #region 构造函数

        public F_HR_1001()
        {
            InitializeComponent();
            this.SetFromTitleInfo();
            // 设置ToolStripButton状态
            this.SetToolStripButtonEnable();
        }

        #endregion

        #region 单例模式

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

                }
                return _instance;
            }
        }

        #endregion

        #region 事件

        /// <summary>
        /// 窗体加载事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void F_HR_1001_Load(object sender, EventArgs e)
        {
            try
            {
                #region 绑定数据源
                this.dkStaffName.WhereCondition = "(StaffStatus = 1 Or StaffStatus = 2) AND ValueFlag = 1";
                //绑定工资结算标识数据源
                this.comSettlementFlag.DataSource = GetSettlementFlagInfo();
                this.comSettlementFlag.DisplayMember = "SettlementFlagName";
                this.comSettlementFlag.ValueMember = "SettlementFlagID";
                //绑定出勤状态数据源
                this.comAttendanceStatus.DataSource = GetAttendanceStatusInfo();
                this.comAttendanceStatus.DisplayMember = "AttendanceStatusName";
                this.comAttendanceStatus.ValueMember = "AttendanceStatusID";
                //绑定缺勤原因数据源
                this.comAbsenceReason.DataSource = GetAbsenceReasonInfo();
                this.comAbsenceReason.DisplayMember = "AbsenceReasonName";
                this.comAbsenceReason.ValueMember = "AbsenceReasonID";
                //绑定月份数据源
                this.dtpmonth.Value = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day);
                FormPermissionManager.FormPermissionControl(this.Name, this,
                    LogInUserInfo.CurrentUser.CurrentUserEntity.UserRightData, LogInUserInfo.CurrentUser.CurrentUserEntity.FunctionData);
                #endregion
            }
            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_HR_1001_FormClosed(object sender, FormClosedEventArgs e)
        {
            _instance = null;
        }

        /// <summary>
        /// 行获取焦点事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void dgvStaffAttendance_CellEnter(object sender, DataGridViewCellEventArgs e)
        {
            try
            {
                if (this.dgvStaffAttendance.CurrentCell != null)
                {
                    // 记录最后选择行
                    this._selectedRowIndex = this.dgvStaffAttendance.CurrentCell.RowIndex;
                }
            }
            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 dgvStaffAttendance_CellMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)
        {
            if (Constant.INT_IS_NEGATIE_ONE < e.RowIndex && Constant.INT_IS_NEGATIE_ONE < e.ColumnIndex
                    && this.tsbtnEdit.Enabled && this.tsbtnEdit.Visible)
            {
                this.tsbtnEdit_Click(sender, e);
            }
        }

        /// <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 tsbtnDownloadTemplate_Click(object sender, EventArgs e)
        {
            try
            {
                TempletFileEntity resultTemplet = (TempletFileEntity)DoAsync(new AsyncMethod(() =>
                {
                    return CommonModuleProxy.Service.GetTempletFileContentByUrl(Constant.HR_STAFF_ATTENDANCE_TEMPLET);
                }));
                if (string.IsNullOrEmpty(resultTemplet.FileName))
                {
                    // 提示未查找到数据
                    MessageBox.Show(Messages.MSG_CMN_W021, this.Text,
                         MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    return;
                }
                this.sfDialogTemplet.FileName = resultTemplet.FileName;
                this.sfDialogTemplet.Filter = "Excel文件（*.xlsx）|*.xlsx";
                if (this.sfDialogTemplet.ShowDialog() == DialogResult.OK)
                {
                    string localFilePath = this.sfDialogTemplet.FileName.ToString(); //获得文件路径 
                    System.IO.File.WriteAllBytes(localFilePath, resultTemplet.FileContent);
                }
            }
            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.dgvStaffAttendance.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells);
        }

        /// <summary>
        /// 更多条件按钮事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void tsbtnMoreCondition_Click(object sender, EventArgs e)
        {
            HR_CMN_001 frmCMN001 = new HR_CMN_001();
            frmCMN001.StaffEntity = this._staffEntity;
            if (frmCMN001.ShowDialog() == DialogResult.OK)
            {
                this.txtOtherWhere.Text = frmCMN001.StaffEntity.GetSqlDispText();
                this._staffEntity = frmCMN001.StaffEntity;
            }
        }

        /// <summary>
        /// 清空条件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btnClearCondition_Click(object sender, EventArgs e)
        {
            this.dkStaffName.UserID = null;
            this.dkStaffName.UserCode = string.Empty;
            this.dkStaffName.UserName = string.Empty;
            this.dkStaffName.StaffEntity = null;
            this.txtCardNumber.Clear();
            this.comSettlementFlag.SelectedIndex = 0;
            this.comAbsenceReason.SelectedIndex = 0;
            this.comAttendanceStatus.SelectedIndex = 0;
            this.txtOtherWhere.Text = string.Empty;
            this._staffEntity.ClearEntityValue();
        }

        /// <summary>
        /// 查询按钮事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btnSearch_Click(object sender, EventArgs e)
        {
            try
            {
                this._staffIDList = null;
                // 记录当前选中行
                int selectRowIndex = this._selectedRowIndex;
                SearchAttendanceEntity SearchAttendanceEntity = SetSearchAttendanceEntity();
                DataSet dsResultStaff = (DataSet)DoAsync(new AsyncMethod(() =>
                {
                    return HRModuleProxy.Service.SearcStaffAttendance(SearchAttendanceEntity);
                }));
                if (dsResultStaff != null)
                {
                    base.DataSource = dsResultStaff;
                    if (this.DataSource != null && this.DataSource.Tables.Count > Constant.INT_IS_ZERO)
                    {
                        this.dgvStaffAttendance.DataSource = this.DataSource.Tables[0];
                        if (this.DataSource.Tables[0].Rows.Count <= Constant.INT_IS_ZERO)
                        {
                            // 提示未查找到数据
                            MessageBox.Show(Messages.MSG_CMN_I002, this.Text,
                                 MessageBoxButtons.OK, MessageBoxIcon.Information);
                        }
                        else
                        {
                            #region 选择原有行
                            if (selectRowIndex >= Constant.INT_IS_ZERO)
                            {
                                if (selectRowIndex >= dsResultStaff.Tables[0].Rows.Count)
                                {
                                    this.dgvStaffAttendance.Rows[this.dgvStaffAttendance.Rows.Count - 1].Selected = true;
                                    this.dgvStaffAttendance.CurrentCell = this.dgvStaffAttendance.Rows[this.dgvStaffAttendance.Rows.Count - 1].Cells["StaffName"];
                                }
                                else
                                {
                                    this.dgvStaffAttendance.Rows[selectRowIndex].Selected = true;
                                    this.dgvStaffAttendance.CurrentCell = this.dgvStaffAttendance.Rows[selectRowIndex].Cells["StaffName"];
                                }
                            }
                            #endregion
                        }
                    }
                }
                this.SetToolStripButtonEnable();
            }
            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 tsbtnEdit_Click(object sender, EventArgs e)
        {
            F_HR_1002 frmHR1002 = new F_HR_1002();
            frmHR1002.ShowDialog();
        }

        #endregion

        #region 私有方法

        /// <summary>
        /// 设置窗体按钮的文本信息
        /// </summary>
        private void SetFromTitleInfo()
        {
            this.Text = FormTitles.F_HR_1001;
            this.tsbtnEdit.Text = ButtonText.TSBTN_EDIT;
            this.tsbtnDownloadTemplate.Text = ButtonText.TSBTN_DOWNLOADTEMPLATE;
            this.tsbtnMoreCondition.Text = ButtonText.TSBTN_MORECONDITION;
            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;
            // 设置表格不自动创建列
            this.dgvStaffAttendance.AutoGenerateColumns = false;
            // 设置ToolStripButton状态
            this.SetToolStripButtonEnable();
        }


        /// <summary>
        /// 根据查询条件 形成查询实体
        /// </summary>
        /// <returns></returns>
        private SearchAttendanceEntity SetSearchAttendanceEntity()
        {
            SearchAttendanceEntity searchAttendanceEntity = new SearchAttendanceEntity();
            DataConvert.Convert(this._staffEntity, searchAttendanceEntity);
            if (this.dkStaffName.UserID != null)
            {
                searchAttendanceEntity.StaffID = this.dkStaffName.UserID;
            }
            searchAttendanceEntity.CardNumber = this.txtCardNumber.Text.Trim();
            if (this.comSettlementFlag.SelectedValue != null
                    && !Constant.CBO_SELECT_ALL_VALUE.Equals(this.comSettlementFlag.SelectedValue.ToString()))
            {
                searchAttendanceEntity.SettlementFlag = this.comSettlementFlag.SelectedValue.ToString();
            }
            if (this.comAttendanceStatus.SelectedValue != null
                && !Constant.CBO_SELECT_ALL_VALUE.Equals(this.comAttendanceStatus.SelectedValue.ToString()))
            {
                searchAttendanceEntity.AttendanceStatus = this.comAttendanceStatus.SelectedValue.ToString();
            }
            if (this.comAbsenceReason.SelectedValue != null
                && !Constant.CBO_SELECT_ALL_VALUE.Equals(this.comAbsenceReason.SelectedValue.ToString()))
            {
                searchAttendanceEntity.AbsenceReason = this.comAbsenceReason.SelectedValue.ToString();
            }
            DateTime time = this.dtpmonth.Value;
            searchAttendanceEntity.StartAttendanceDate = new DateTime(time.Year, time.Month, 1);
            searchAttendanceEntity.EndAttendanceDate = new DateTime(time.Year, time.Month, DateTime.DaysInMonth(time.Year, time.Month)).AddDays(1);
            return searchAttendanceEntity;
        }

        ///// <summary>
        ///// 设置工具按钮的可用状态
        ///// </summary>
        private void SetToolStripButtonEnable()
        {
            if (this.dgvStaffAttendance.CurrentCell != null)
            {
                this.tsbtnEdit.Enabled = true;
            }
            else
            {
                this.tsbtnEdit.Enabled = true;
            }
        }

        /// <summary>
        /// 工资结算标识数据源  
        /// </summary>
        /// <returns></returns>
        private DataTable GetSettlementFlagInfo()
        {
            //1：已经结算  0：未结算
            DataTable dtRAPType = new DataTable();
            dtRAPType.Columns.Add("SettlementFlagID");
            dtRAPType.Columns.Add("SettlementFlagName");
            DataRow newRowType = dtRAPType.NewRow();
            newRowType["SettlementFlagID"] = Constant.CBO_SELECT_ALL_VALUE;
            newRowType["SettlementFlagName"] = Constant.CBO_SELECT_ALL_NAME;
            dtRAPType.Rows.Add(newRowType);
            newRowType = dtRAPType.NewRow();
            newRowType["SettlementFlagID"] = "0";
            newRowType["SettlementFlagName"] = "未结算";
            dtRAPType.Rows.Add(newRowType);
            newRowType = dtRAPType.NewRow();
            newRowType["SettlementFlagID"] = "1";
            newRowType["SettlementFlagName"] = "已经结算";
            dtRAPType.Rows.Add(newRowType);
            return dtRAPType;
        }

        /// <summary>
        /// 出勤状态数据源  
        /// </summary>
        /// <returns></returns>
        private DataTable GetAttendanceStatusInfo()
        {
            DataTable dtAttendanceStatus = new DataTable();
            dtAttendanceStatus.Columns.Add("AttendanceStatusID");
            dtAttendanceStatus.Columns.Add("AttendanceStatusName");
            DataRow newRowType = dtAttendanceStatus.NewRow();
            newRowType["AttendanceStatusID"] = Constant.CBO_SELECT_ALL_VALUE;
            newRowType["AttendanceStatusName"] = Constant.CBO_SELECT_ALL_NAME;
            dtAttendanceStatus.Rows.Add(newRowType);
            newRowType = dtAttendanceStatus.NewRow();
            newRowType["AttendanceStatusID"] = "1";
            newRowType["AttendanceStatusName"] = "全天";
            dtAttendanceStatus.Rows.Add(newRowType);
            newRowType = dtAttendanceStatus.NewRow();
            newRowType["AttendanceStatusID"] = "2";
            newRowType["AttendanceStatusName"] = "半天";
            dtAttendanceStatus.Rows.Add(newRowType);
            newRowType = dtAttendanceStatus.NewRow();
            newRowType["AttendanceStatusID"] = "3";
            newRowType["AttendanceStatusName"] = "缺勤";
            dtAttendanceStatus.Rows.Add(newRowType);
            return dtAttendanceStatus;
        }

        /// <summary>
        /// 缺勤原因数据源  
        /// </summary>
        /// <returns></returns>
        private DataTable GetAbsenceReasonInfo()
        {
            DataTable dtAbsenceReason = new DataTable();
            dtAbsenceReason.Columns.Add("AbsenceReasonID");
            dtAbsenceReason.Columns.Add("AbsenceReasonName");
            DataRow newRowType = dtAbsenceReason.NewRow();
            newRowType["AbsenceReasonID"] = Constant.CBO_SELECT_ALL_VALUE;
            newRowType["AbsenceReasonName"] = Constant.CBO_SELECT_ALL_NAME;
            dtAbsenceReason.Rows.Add(newRowType);
            newRowType = dtAbsenceReason.NewRow();
            newRowType["AbsenceReasonID"] = "0";
            newRowType["AbsenceReasonName"] = "休息";
            dtAbsenceReason.Rows.Add(newRowType);
            newRowType = dtAbsenceReason.NewRow();
            newRowType["AbsenceReasonID"] = "1";
            newRowType["AbsenceReasonName"] = "病假";
            dtAbsenceReason.Rows.Add(newRowType);
            newRowType = dtAbsenceReason.NewRow();
            newRowType["AbsenceReasonID"] = "2";
            newRowType["AbsenceReasonName"] = "事假";
            dtAbsenceReason.Rows.Add(newRowType);
            newRowType = dtAbsenceReason.NewRow();
            newRowType["AbsenceReasonID"] = "3";
            newRowType["AbsenceReasonName"] = "旷工";
            dtAbsenceReason.Rows.Add(newRowType);
            newRowType = dtAbsenceReason.NewRow();
            newRowType["AbsenceReasonID"] = "4";
            newRowType["AbsenceReasonName"] = "其它";
            dtAbsenceReason.Rows.Add(newRowType);
            return dtAbsenceReason;
        }

        #endregion
    }
}