/// <summary>
/// Update a HrDailyEmployeeAttendInfo.
/// </summary>
public void Update(Model.HrDailyEmployeeAttendInfo hrDailyEmployeeAttendInfo)
{
//
// todo: add other logic here.
//
accessor.Update(hrDailyEmployeeAttendInfo);
}
// 加载异常考勤信息
private void AnormalySalaryEditForm_Load(object sender, EventArgs e)
{
if (this._hrDaily_begUpdate != null)
{
this.lblEmployeeName.Text = this._hrDaily_begUpdate.EmployeeName;
this.lblNote.Text = this._hrDaily_begUpdate.Note;
this.lblShouldCheckIn.Text = this._hrDaily_begUpdate.ShouldCheckIn.Value.ToString("HH:mm");
this.lblShouldCheckOut.Text = this._hrDaily_begUpdate.ShouldCheckOut.Value.ToString("HH:mm");
this.lblActualCheckIn.Text = this._hrDaily_begUpdate.ActualCheckIn == global::Helper.DateTimeParse.NullDate ? "" : this._hrDaily_begUpdate.ActualCheckIn.Value.ToString("HH:mm");
this.lblActualCheckOut.Text = this._hrDaily_begUpdate.ActualCheckOut == global::Helper.DateTimeParse.NullDate ? "" : this._hrDaily_begUpdate.ActualCheckOut.Value.ToString("HH:mm");
this.lblDutyDate.Text = this._hrDaily_begUpdate.DutyDate.Value.ToString("HH:mm");
//获取重新考勤之后的结果
Model.Employee emp = new BL.EmployeeManager().Get(this._hrDaily_begUpdate.EmployeeId);
this._hrDaily = new BL.HrDailyEmployeeAttendInfoManager().Reatten_Controller(this._hrDaily_begUpdate.DutyDate.Value, emp);
if (this._hrDaily != null)
{
this.ShouldCheckIn.Text = this._hrDaily.ShouldCheckIn.Value.ToString("HH:mm");
this.ShouldCheckOut.Text = this._hrDaily.ShouldCheckOut.Value.ToString("HH:mm");
this.txtActualCheckInTime.EditValue = this._hrDaily.ActualCheckIn == null ? "" : this._hrDaily_begUpdate.ActualCheckIn.Value.ToString("HH:mm");
this.txtActualCheckOutTime.EditValue = this._hrDaily.ActualCheckOut == null ? "" : this._hrDaily_begUpdate.ActualCheckOut.Value.ToString("HH:mm");
this.Note.Text = this._hrDaily.Note;
}
}
}
/// <summary>
/// Insert a HrDailyEmployeeAttendInfo.
/// </summary>
public void Insert(Model.HrDailyEmployeeAttendInfo hrDailyEmployeeAttendInfo)
{
//
// todo:add other logic here
//
hrDailyEmployeeAttendInfo.HrDailyEmployeeAttendInfoId = Guid.NewGuid().ToString();
accessor.Insert(hrDailyEmployeeAttendInfo);
}
private void gridView1_DoubleClick(object sender, EventArgs e)
{
Model.HrDailyEmployeeAttendInfo model = ((this.bindingSource_atten.Current as DataRowView) == null ? null : _hrManager.Get((this.bindingSource_atten.Current as DataRowView)["HrDailyEmployeeAttendInfoId"].ToString()));
if (model != null)
{
AnormalySalaryEditForm f = new AnormalySalaryEditForm(model);
f.ShowDialog();
this.bindingSource_atten.DataSource = _hrManager.SelectDailyInfoByEmployee(this.lookUpEmployeeId.EditValue.ToString(), new DateTime(Convert.ToInt32(this.cmbDutyDate.Text.Substring(0, 4)), Convert.ToInt32(this.cmbDutyDate.Text.Substring(5)), 1), "2").Tables[0];
}
}
public void UpdateDailyInfo(Model.HrDailyEmployeeAttendInfo dailyInfo, IList <Model.HrDailyEmployeeAttendInfo> dailyInfolist)
{
if (dailyInfo.ShouldCheckIn == null || dailyInfo.ShouldCheckOut == null)
{
foreach (Model.HrDailyEmployeeAttendInfo item in dailyInfolist)
{
item.OverTimeOff = dailyInfo.ActualCheckOut == null ? null : dailyInfo.ActualCheckOut;
item.OverTimeON = dailyInfo.ActualCheckIn == null ? null : dailyInfo.ActualCheckIn;
this.Update(item);
}
}
else
{
foreach (Model.HrDailyEmployeeAttendInfo item in dailyInfolist)
{
DataSet annualHolidayData = annualholidayManager.SelectSingleAnnualInfo(Convert.ToDateTime(item.DutyDate));
dailyInfo.HrDailyEmployeeAttendInfoId = item.HrDailyEmployeeAttendInfoId;
if (item.Note != null)
{
if (item.Note == "缺刷卡資料")
{
this.Update(dailyInfo);
}
else
{
foreach (DataRow rows in annualHolidayData.Tables[0].Rows)
{
if (Convert.ToDateTime(rows[Model.AnnualHoliday.PRO_HolidayDate]) == item.DutyDate)
{
item.OverTimeOff = dailyInfo.ActualCheckOut == null ? null : dailyInfo.ActualCheckOut;
item.OverTimeON = dailyInfo.ActualCheckIn == null ? null : dailyInfo.ActualCheckIn;
this.Update(item);
}
}
}
}
else
{
dailyInfo.OverTimeOff = item.OverTimeOff;
dailyInfo.OverTimeON = item.OverTimeON;
this.Update(dailyInfo);
}
}
}
}
public int ReattenSave(Model.HrDailyEmployeeAttendInfo _hrEA)
{
SqlConnection con = new SqlConnection(sqlmapper.DataSource.ConnectionString);
SqlCommand cmd = new SqlCommand("addDailyEmployeeAttendInfo", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection.Open();
SqlParameter[] Parameters =
{
new SqlParameter("@Id", DbType.String),
new SqlParameter("@DutyDate", DbType.DateTime),
new SqlParameter("@EmployeeId", DbType.String),
new SqlParameter("@ShouldCheckIn", DbType.DateTime),
new SqlParameter("@ShouldCheckOut", DbType.DateTime),
new SqlParameter("@ActualCheckIn", DbType.DateTime),
new SqlParameter("@ActualCheckOut", DbType.DateTime),
new SqlParameter("@LateInMinute", DbType.Int32),
new SqlParameter("@DayFactor", DbType.Double),
new SqlParameter("@MonthFactor", DbType.Double),
new SqlParameter("@SpecialBonus", DbType.Double),
new SqlParameter("@IsNormal", DbType.Byte),
new SqlParameter("@Note", DbType.String)
};
Parameters[0].Value = _hrEA.HrDailyEmployeeAttendInfoId;
Parameters[1].Value = _hrEA.DutyDate;
Parameters[2].Value = _hrEA.EmployeeId;
Parameters[3].Value = _hrEA.ShouldCheckIn;
Parameters[4].Value = _hrEA.ShouldCheckOut;
Parameters[5].Value = _hrEA.ActualCheckIn;
Parameters[6].Value = _hrEA.ActualCheckOut;
Parameters[7].Value = _hrEA.LateInMinute;
Parameters[8].Value = _hrEA.DayFactor;
Parameters[9].Value = _hrEA.MonthFactor;
Parameters[10].Value = _hrEA.SpecialBonus;
Parameters[11].Value = _hrEA.IsNormal;
Parameters[12].Value = _hrEA.Note;
cmd.Parameters.AddRange(Parameters);
return(cmd.ExecuteNonQuery());
}
public void Update(Model.HrDailyEmployeeAttendInfo e)
{
this.Update <Model.HrDailyEmployeeAttendInfo>(e);
}
public void Insert(Model.HrDailyEmployeeAttendInfo e)
{
this.Insert <Model.HrDailyEmployeeAttendInfo>(e);
}
//获取传来异常数据Model
public AnormalySalaryEditForm(Model.HrDailyEmployeeAttendInfo trans_HDEA)
{
InitializeComponent();
this._hrDaily_begUpdate = trans_HDEA;
}
//保存修改
private void barBtn_save_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
#region 原方法
//if (this.txtActualCheckInTime.Text != string.Empty)
//{
// try
// {
// this._hrDaily.ActualCheckIn = DateTime.Parse(this._hrDaily_begUpdate.DutyDate.Value.ToString("yyyy-MM-dd") + " " + this.txtActualCheckInTime.Text);
// }
// catch (Exception ex)
// {
// MessageBox.Show("輸入時間格式有誤,請查證!");
// return;
// }
//}
//else
//{
// MessageBox.Show("實際上班時間不能為空!");
// return;
//}
//if (this.txtActualCheckOutTime.Text != string.Empty)
//{
// try
// {
// this._hrDaily.ActualCheckOut = DateTime.Parse(this._hrDaily_begUpdate.DutyDate.Value.ToString("yyyy-MM-dd") + " " + this.txtActualCheckOutTime.Text);
// }
// catch (Exception ex)
// {
// MessageBox.Show("輸入時間格式有誤,請查證!");
// return;
// }
//}
//else
//{
// MessageBox.Show("實際下班時間不能為空!");
// return;
//}
////判断换日
//TimeSpan? ts_1 = this._hrDaily.ShouldCheckIn - this._hrDaily.ActualCheckIn;
//if (Math.Abs(ts_1.Value.Days * 24 + ts_1.Value.Hours) > 13)
// this._hrDaily.ActualCheckIn = this._hrDaily.ActualCheckIn.Value.AddDays(1);
//TimeSpan? ts_2 = this._hrDaily.ShouldCheckOut - this._hrDaily.ActualCheckOut;
//if (Math.Abs(ts_2.Value.Days * 24 + ts_2.Value.Hours) > 13)
// this._hrDaily.ActualCheckOut = this._hrDaily.ActualCheckOut.Value.AddDays(1);
//if (this._hrDaily.ActualCheckIn > this._hrDaily.ActualCheckOut)
//{
// MessageBox.Show("實際上班時間,不能大於實際下班時間!");
// return;
//}
//if (this._hrDaily.MLeave != null)
//{
// if (this._hrDaily.MLeave.LeaveRange != 0)
// {
// this._hrDaily.DayFactor = 0.5 + 0.5 * this._hrDaily.MLeave.LeaveType.PayRate;
// this._hrDaily.SpecialBonus = Convert.ToInt32(Convert.ToDouble(this._hrDaily.MBusinessHours.SpecialPay) * 0.5);
// this._hrDaily.MonthFactor = 1;
// if (this._hrDaily.MLeave.LeaveRange == 1)
// {
// this._hrDaily.Note = this._hrDaily.MLeave.LeaveType.ToString() + "(上半日)";
// }
// else
// {
// this._hrDaily.Note = this._hrDaily.MLeave.LeaveType.ToString() + "(下半日)";
// }
// }
//}
//else
//{
// this._hrDaily.SpecialBonus = Convert.ToInt32(this._hrDaily.MBusinessHours.SpecialPay);
// this._hrDaily.DayFactor = 1;
//}
//TimeSpan? ts = this._hrDaily.ActualCheckIn - this._hrDaily.ShouldCheckIn;
//if ((ts.Value.Hours * 60 + ts.Value.Minutes) > 0 && !(this._hrDaily.MLeave != null && this._hrDaily.MLeave.LeaveRange == 0))
//{
// this._hrDaily.LateInMinute = ts.Value.Hours * 60 + ts.Value.Minutes;
// this._hrDaily.Note += ";遲到";
//}
//else
//{
// this._hrDaily.LateInMinute = 0;
//}
//TimeSpan? ts2 = this._hrDaily.ShouldCheckOut - this._hrDaily.ActualCheckOut;
//if (ts2.Value.Hours * 60 + ts2.Value.Minutes > 0 && !(this._hrDaily.MLeave != null && this._hrDaily.MLeave.LeaveRange == 0))
//{
// this._hrDaily.LateInMinute = ts2.Value.Hours * 60 + ts2.Value.Minutes;
// this._hrDaily.Note += ";早退";
//}
//this._hrDaily.Note = this._hrDaily.Note.Replace(";卻刷卡資料", "");
//this._hrDaily.Note = this._hrDaily.Note.Replace("卻刷卡資料", "");
//this._hrDaily.MonthFactor = 1; //月基数设为1
//this._hrDaily.IsNormal = true; //设置为不存在异常
//if (this._hrManger.UpdateSave_AnormalySalaryEditForm(this._hrDaily) > 0)//保存修改
//{
// MessageBox.Show(Properties.Resources.SaveSuccess);
// this.DialogResult = DialogResult.OK;
//}
//else
//{
// MessageBox.Show(Properties.Resources.SavaFailure);
//}
#endregion
#region 新方法，曹瑞 2016年7月16日
this._hrDaily = _hrManger.Get(this._hrDaily_begUpdate.HrDailyEmployeeAttendInfoId);
if (this.txtActualCheckInTime.Text != string.Empty)
{
try
{
this._hrDaily.ActualCheckIn = DateTime.Parse(this._hrDaily_begUpdate.DutyDate.Value.ToString("yyyy-MM-dd") + " " + this.txtActualCheckInTime.Text);
}
catch (Exception ex)
{
MessageBox.Show("輸入時間格式有誤,請查證!");
return;
}
}
else
{
this._hrDaily.ActualCheckIn = null;
}
if (this.txtActualCheckOutTime.Text != string.Empty)
{
try
{
this._hrDaily.ActualCheckOut = DateTime.Parse(this._hrDaily_begUpdate.DutyDate.Value.ToString("yyyy-MM-dd") + " " + this.txtActualCheckOutTime.Text);
}
catch (Exception ex)
{
MessageBox.Show("輸入時間格式有誤,請查證!");
return;
}
}
else
{
this._hrDaily.ActualCheckOut = null;
}
if (this._hrDaily.ActualCheckIn != null && this._hrDaily.ShouldCheckIn != null)
{
TimeSpan?ts_1 = this._hrDaily.ShouldCheckIn - this._hrDaily.ActualCheckIn;
if (Math.Abs(ts_1.Value.Days * 24 + ts_1.Value.Hours) > 13)
{
this._hrDaily.ActualCheckIn = this._hrDaily.ActualCheckIn.Value.AddDays(1);
}
}
if (this._hrDaily.ActualCheckOut != null && this._hrDaily.ShouldCheckOut != null)
{
TimeSpan?ts_2 = this._hrDaily.ShouldCheckOut - this._hrDaily.ActualCheckOut;
if (Math.Abs(ts_2.Value.Days * 24 + ts_2.Value.Hours) > 13)
{
this._hrDaily.ActualCheckOut = this._hrDaily.ActualCheckOut.Value.AddDays(1);
}
}
try
{
DateTime checkDate = Convert.ToDateTime(this._hrDaily_begUpdate.DutyDate);
Model.Employee emp = new BL.EmployeeManager().Get(this._hrDaily_begUpdate.EmployeeId);
BL.V.BeginTransaction();
_hrManger.Reatten_Controller(checkDate, emp, this._hrDaily.ActualCheckIn, this._hrDaily.ActualCheckOut);
MessageBox.Show("訂正成功！", this.Text, MessageBoxButtons.OK);
BL.V.CommitTransaction();
}
catch (Exception ex)
{
BL.V.RollbackTransaction();
MessageBox.Show("訂正失敗！", this.Text, MessageBoxButtons.OK);
return;
}
#endregion
}
/// <summary>
/// 重新保存
/// </summary>
public int ReattenSave(Model.HrDailyEmployeeAttendInfo _hrEA)
{
return(accessor.ReattenSave(_hrEA));
}
public int UpdateSave_AnormalySalaryEditForm(Model.HrDailyEmployeeAttendInfo _hrDaily)
{
return(accessor.UpdateSave_AnormalySalaryEditForm(_hrDaily));
}
