/******************************************************************************* * 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 单例模式 /// /// 单例模式,防止重复创建窗体 /// public static F_HR_1001 Instance { get { if (_instance == null) { _instance = new F_HR_1001(); } return _instance; } } #endregion #region 事件 /// /// 窗体加载事件 /// /// /// 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); } } /// /// 窗体关闭事件 /// /// /// private void F_HR_1001_FormClosed(object sender, FormClosedEventArgs e) { _instance = null; } /// /// 行获取焦点事件 /// /// /// 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); } } /// /// 单元格鼠标双击事件 /// /// /// 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); } } /// /// 关闭按钮事件 /// /// /// private void tsbtnClose_Click(object sender, EventArgs e) { this.Close(); } /// /// 下载模板按钮 /// /// /// 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); } } /// /// 自动适应列宽 /// /// /// private void tsbtnAdaptive_Click(object sender, EventArgs e) { this.dgvStaffAttendance.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells); } /// /// 更多条件按钮事件 /// /// /// 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; } } /// /// 清空条件 /// /// /// 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(); } /// /// 查询按钮事件 /// /// /// 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); } } /// /// 编辑按钮事件 /// /// /// private void tsbtnEdit_Click(object sender, EventArgs e) { F_HR_1002 frmHR1002 = new F_HR_1002(); frmHR1002.ShowDialog(); } #endregion #region 私有方法 /// /// 设置窗体按钮的文本信息 /// 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(); } /// /// 根据查询条件 形成查询实体 /// /// 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; } ///// ///// 设置工具按钮的可用状态 ///// private void SetToolStripButtonEnable() { if (this.dgvStaffAttendance.CurrentCell != null) { this.tsbtnEdit.Enabled = true; } else { this.tsbtnEdit.Enabled = true; } } /// /// 工资结算标识数据源 /// /// 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; } /// /// 出勤状态数据源 /// /// 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; } /// /// 缺勤原因数据源 /// /// 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 } }