public void Exec(FapDynamicObject billData, FapDynamicObject bizData)
{
string empUid = billData.Get("AppEmpUid").ToString();
string oriBillUid = billData.Get("OriBillUid").ToString();
//删除原有统计
_dbContext.ExecuteOriginal($"delete from {nameof(TmLeaveStat)} where BillUid=@BillUid and EmpUid=@EmpUid"
, new Dapper.DynamicParameters(new { BillUid = oriBillUid, EmpUid = empUid }));
//新增现有统计
string startDateTime = billData.Get("StartTime").ToString();
string endDateTime = billData.Get("EndTime").ToString();
var appInfoList = _timeService.LeaveDaysInfo(empUid, startDateTime, endDateTime);
string billUid = billData.Get("Fid").ToString();
string leaveType = billData.Get("RevokType").ToString();
IList <TmLeaveStat> stats = new List <TmLeaveStat>();
foreach (var appinfo in appInfoList)
{
TmLeaveStat lstat = new TmLeaveStat
{
EmpUid = empUid,
BillUid = billUid,
WorkDate = appinfo.ApplyDate,
LeaveTypeUid = leaveType,
LeaveDays = appinfo.Days,
LeaveHours = appinfo.Hours
};
stats.Add(lstat);
}
_dbContext.InsertBatchSql(stats);
if (leaveType == "Annaul")
{
var annualLeave = _dbContext.QueryFirstOrDefault <TmAnnualLeave>("select * from TmAnnualLeave where EmpUid=@EmpUid and Annual=@Year",
new Dapper.DynamicParameters(new { EmpUid = empUid, Year = DateTimeUtils.ToDateTime(startDateTime).Year }));
if (annualLeave != null)
{
annualLeave.UsedNum = annualLeave.UsedNum - billData.Get("OriIntervalDay").ToDouble() + billData.Get("IntervalDay").ToDouble();
annualLeave.RemainderNum = annualLeave.CurrRealNum - annualLeave.UsedNum;
_dbContext.Update(annualLeave);
}
}
}
public void Exec(FapDynamicObject billData, FapDynamicObject bizData)
{
string empUid = billData.Get("AppEmpUid").ToString();
string startDateTime = billData.Get("StartTime").ToString();
string endDateTime = billData.Get("EndTime").ToString();
var appInfoList = _timeService.LeaveDaysInfo(empUid, startDateTime, endDateTime);
string billUid = billData.Get("Fid").ToString();
string leaveType = billData.Get("LeaveType").ToString();
IList <TmLeaveStat> stats = new List <TmLeaveStat>();
foreach (var appinfo in appInfoList)
{
TmLeaveStat lstat = new TmLeaveStat
{
EmpUid = empUid,
BillUid = billUid,
WorkDate = appinfo.ApplyDate,
LeaveTypeUid = leaveType,
LeaveDays = appinfo.Days,
LeaveHours = appinfo.Hours
};
stats.Add(lstat);
}
_dbContext.InsertBatchSql(stats);
if (leaveType == LeavTypeEnum.Annaul.ToString())
{
//扣减年假
var annualLeave = _dbContext.QueryFirstOrDefault <TmAnnualLeave>("select * from TmAnnualLeave where EmpUid=@EmpUid and Annual=@Year",
new Dapper.DynamicParameters(new { EmpUid = empUid, Year = DateTimeUtils.ToDateTime(startDateTime).Year }));
if (annualLeave != null)
{
annualLeave.UsedNum += (billData.Get("IntervalDay").ToDouble());
annualLeave.RemainderNum = annualLeave.CurrRealNum - annualLeave.UsedNum;
_dbContext.Update(annualLeave);
}
}
if (leaveType == LeavTypeEnum.Tuneoff.ToString())
{
//调休扣减加班
var overtimes = _dbContext.Query <TmOvertimeStat>("select * from TmOvertimeStat where EmpUid=@EmpUid and Invalid=0", new Dapper.DynamicParameters(new { EmpUid = empUid }));
double hours = billData.Get("IntervalHour").ToDouble();
foreach (var overtime in overtimes)
{
//可用小时数
double available = overtime.HoursLength - overtime.DaysOffHours;
if (hours <= available)
{
overtime.DaysOffHours += hours;
if (overtime.DaysOffHours >= overtime.HoursLength)
{
overtime.Invalid = 1;
}
_dbContext.Update(overtime);
break;
}
else
{
hours -= available;
overtime.DaysOffHours = overtime.HoursLength;
overtime.Invalid = 1;
_dbContext.Update(overtime);
}
}
}
}