/*******************************************************************************
* 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
}
}