/// <summary>
/// 根据单据类型编号，生成单号
/// </summary>
/// <param name="BillTypeNumber">单据类型编号,连接字符串</param>
/// <returns>单号</returns>
public static string GenerateBillNumber(string BillTypeNumber, string connString)
{
BonsaiiDbContext db = new BonsaiiDbContext(connString);
BillPropertyModels tmp = db.BillProperties.Where(p => p.Type == BillTypeNumber).Single();
string date = DateTime.Now.ToString("yyyyMMdd");
//为流水号补充零
string SerialNumber = AddZero(tmp.Count, tmp.SerialNumber);
//更新单号的计数值
tmp.Count++;
db.Entry(tmp).State = EntityState.Modified;
db.SaveChanges();
switch (tmp.CodeMethod)
{
case CodeMethod.One:
return(DateTime.Now.ToString("yyyyMMdd").ToString() + SerialNumber);
case CodeMethod.Two:
return(DateTime.Now.ToString("yyyyMM").ToString() + SerialNumber);
case CodeMethod.Three:
return(tmp.Code.Substring(0, 10 - tmp.SerialNumber) + SerialNumber);
default:
return("");
}
}
public static string GenerateContractNumber(string abbr, string connString)
{
BonsaiiDbContext db = new BonsaiiDbContext(connString);
ParamCodes tmp = db.ParamCodes.Where(p => p.ParamName == "合同编号").Single();
string date = DateTime.Now.ToString("yyyyMMdd");
string SerialNumber = null;
//为流水号补充零
if (tmp.SerialNumber != 0)
{
SerialNumber = AddZero(tmp.Count, tmp.SerialNumber);
//更员工号计数值
tmp.Count++;
db.Entry(tmp).State = EntityState.Modified;
db.SaveChanges();
}
switch (tmp.CodeMethod)
{
case CodeMethod.Day:
return(DateTime.Now.ToString("yyMMdd").ToString() + SerialNumber);
case CodeMethod.Month:
return(DateTime.Now.ToString("yyMM").ToString() + SerialNumber);
case CodeMethod.Serial:
return(tmp.Code.Substring(0, 10 - tmp.SerialNumber) + SerialNumber);
case CodeMethod.Five:
return(abbr + SerialNumber);
default:
return("");
}
}
//如果审核通过 执行这段代码
public static void PassStep(int id, string userName)
{
UserModels user = (from u in sdb.Users where u.UserName == userName select u).FirstOrDefault();
BonsaiiDbContext db = new BonsaiiDbContext(user.ConnectionString);
AuditProcess auditProcess = db.AuditProcesses.Find(id);
var item = (from p in db.AuditSteps where p.SId == auditProcess.SId select p).FirstOrDefault();
//表明item是最后一个节点。返回一个结果：审核成功
if (item.ApprovedToSId == -1)
{
//AuditApplication auditApplication = db.AuditApplications.Find(auditProcess.AId);
//auditApplication.State = 3;//已审
ReturnStatus(auditProcess.AId, 3, userName);
}
else//如果不是最后一个节点，那么寻找下一个节点，插入到AuditProcess表中
{
int temp = item.ApprovedToSId;
var nextstep = (from p in db.AuditSteps where p.SId == temp select p).FirstOrDefault();//下一个节点
AuditProcess nextauditProcess = new AuditProcess();
nextauditProcess.AId = auditProcess.AId;//还是auditProcess的AId
nextauditProcess.SId = nextstep.SId;
nextauditProcess.TId = nextstep.TId;
nextauditProcess.BType = auditProcess.BType;
nextauditProcess.BNumber = auditProcess.BNumber;
nextauditProcess.TypeName = auditProcess.TypeName;
nextauditProcess.Info = auditProcess.Info;
nextauditProcess.CreateDate = auditProcess.CreateDate; //还是记录auditProcess的申请时间；
nextauditProcess.Result = 0; //待审核
nextauditProcess.Comment = null;
nextauditProcess.DeadlineDate = DateTime.Now.AddDays(item.Days); //记录一下该节点最晚的审核时间；
nextauditProcess.AuditDate = DateTime.Now; //实际的审核时间
nextauditProcess.Approver = nextstep.Approver;
db.AuditProcesses.Add(nextauditProcess);
db.SaveChanges();
Audit(nextstep.Approver, user.CompanyId);
}
// db.SaveChanges();
}
//如果审核不通过就执行这个函数
public static void NotPassStep(int id, string userName)
{
UserModels user = (from u in sdb.Users where u.UserName == userName select u).FirstOrDefault();
BonsaiiDbContext db = new BonsaiiDbContext(user.ConnectionString);
AuditProcess auditProcess = db.AuditProcesses.Find(id);
// auditProcess.Result = 4;//直接返回结果就是不通过
var item = (from p in db.AuditSteps where p.SId == auditProcess.SId select p).FirstOrDefault();
if (item.NotApprovedToSId == -1)//如果不再需要执行下一步了，就直接返回审核失败
{
ReturnStatus(auditProcess.AId, 4, userName);
}
else
{
int temp = item.NotApprovedToSId;
var laststep = (from p in db.AuditSteps where p.SId == temp select p).FirstOrDefault();//返回上一个节点
AuditProcess lastauditProcess = new AuditProcess();
lastauditProcess.AId = auditProcess.AId;//还是这个AId
lastauditProcess.SId = laststep.SId;
lastauditProcess.TId = laststep.TId;
lastauditProcess.BType = auditProcess.BType;
lastauditProcess.BNumber = auditProcess.BNumber;
lastauditProcess.TypeName = auditProcess.TypeName;
lastauditProcess.Info = auditProcess.Info;
lastauditProcess.CreateDate = auditProcess.CreateDate;//还是记录auditProcess的申请时间；
lastauditProcess.Result = 0;
lastauditProcess.Comment = null;
lastauditProcess.DeadlineDate = DateTime.Now.AddDays(item.Days); //记录一下该节点最晚的审核时间；
lastauditProcess.AuditDate = DateTime.Now; //AuditDate就记录为当前的时间；
lastauditProcess.Approver = laststep.Approver;
db.AuditProcesses.Add(lastauditProcess);
db.SaveChanges();
Audit(laststep.Approver, user.CompanyId);
}
}
public static void ReturnStatus(int auditProcessAId, byte status, string userName)
{
UserModels user = (from u in sdb.Users where u.UserName == userName select u).FirstOrDefault();
BonsaiiDbContext db = new BonsaiiDbContext(user.ConnectionString);
AuditApplication application = db.AuditApplications.Find(auditProcessAId);//修改Application的状态
application.State = status;
string btype = application.BType.Substring(0, 2);
switch (btype)
{
case "21":
{ //员工
Staff someone = (from p in db.Staffs where (p.BillNumber == application.BNumber) && (p.BillTypeNumber == application.BType) select p).ToList().SingleOrDefault();
if (someone != null)
{
someone.AuditStatus = status; //已审
SystemDbContext sysdb = new SystemDbContext();
/*BindCodes*/
var Ucount = (from p in sysdb.BindCodes where (p.CompanyId == user.CompanyId && p.StaffNumber == someone.StaffNumber) select p).ToList();
if (Ucount.Count == 0)
{ //木有该员工
BindCode user1 = new BindCode();
string CompanyDbName = "Bonsaii" + user1.CompanyId;
user1.ConnectionString = ConfigurationManager.AppSettings["UserDbConnectionString"] + CompanyDbName + ";"; //"Data Source = localhost,1433;Network Library = DBMSSOCN;Initial Catalog = " + CompanyDbName + ";User ID = test;Password = admin;";
user1.CompanyId = user1.CompanyId;
user1.StaffNumber = someone.StaffNumber;
user1.RealName = someone.Name;
user1.BindingCode = someone.BindingCode;
user1.Phone = someone.IndividualTelNumber;
user1.BindTag = false;
user1.LastTime = DateTime.Now;
user1.IsAvail = true;
sysdb.BindCodes.Add(user1);
sysdb.SaveChanges();
}
db.SaveChanges();
Push(someone.StaffNumber, user.CompanyId, status);
}
} break;
case "22":
{ //变更
StaffChange someone = (from p in db.StaffChanges where (p.BillNumber == application.BNumber) && (p.BillTypeNumber == application.BType) select p).ToList().SingleOrDefault();
if (someone != null)
{
someone.AuditStatus = status;
if (someone.AuditStatus == 3)
{
var staffId = (from p in db.Staffs where p.StaffNumber == someone.StaffNumber && p.ArchiveTag != true select p.Number).ToList().FirstOrDefault();
Staff staff = db.Staffs.Find(staffId);
staff.Name = someone.Name;
staff.Gender = someone.Gender;
staff.Department = someone.Department;
staff.WorkType = someone.WorkType;
staff.Position = someone.Position;
staff.IdentificationNumber = someone.IdentificationNumber;
staff.Nationality = someone.Nationality;
staff.IdentificationNumber = someone.IdentificationNumber;
staff.Entrydate = someone.Entrydate;
staff.ClassOrder = someone.ClassOrder;
staff.ApplyOvertimeSwitch = staff.ApplyOvertimeSwitch;
staff.JobState = someone.JobState;
staff.AbnormalChange = someone.AbnormalChange;
staff.FreeCard = someone.FreeCard;
staff.WorkProperty = someone.WorkProperty;
staff.WorkType = someone.WorkType;
staff.Source = someone.Source;
staff.QualifyingPeriodFull = someone.QualifyingPeriodFull;
staff.MaritalStatus = someone.MaritalStatus;
staff.BirthDate = someone.BirthDate;
staff.NativePlace = someone.NativePlace;
staff.HealthCondition = someone.HealthCondition;
staff.Nation = someone.Nation;
staff.Address = someone.Address;
staff.VisaOffice = someone.VisaOffice;
staff.HomeTelNumber = someone.HomeTelNumber;
staff.EducationBackground = someone.EducationBackground;
staff.GraduationSchool = someone.GraduationSchool;
staff.SchoolMajor = someone.SchoolMajor;
staff.Degree = someone.SchoolMajor;
staff.Introducer = someone.Introducer;
staff.IndividualTelNumber = someone.IndividualTelNumber;
staff.BankCardNumber = someone.BankCardNumber;
staff.UrgencyContactMan = someone.UrgencyContactMan;
staff.UrgencyContactAddress = someone.UrgencyContactAddress;
staff.UrgencyContactPhoneNumber = someone.UrgencyContactPhoneNumber;
staff.PhysicalCardNumber = someone.PhysicalCardNumber;
staff.LeaveDate = someone.LeaveDate;
staff.LeaveType = someone.LeaveType;
staff.LeaveReason = someone.LeaveReason;
staff.AuditStatus = someone.AuditStatus;
staff.HealthCondition = someone.HealthCondition;
staff.ChangeTime = someone.RecordTime;
staff.ChangePerson = someone.RecordPerson;
staff.AuditTime = DateTime.Now;
staff.AuditPerson = userName;
staff.Head = someone.Head;
staff.LogicCardNumber = someone.LogicCardNumber;
staff.HeadType = someone.HeadType;
staff.IDCardNumber = someone.IDCardNumber;
staff.DeadlineDate = someone.DeadlineDate;
}
db.SaveChanges();
Push(someone.StaffNumber, user.CompanyId, status);
}
}
break;
case "23":
{ //离职
StaffApplication someone = (from p in db.StaffApplications where (p.BillNumber == application.BNumber) && (p.BillTypeNumber == application.BType) select p).ToList().SingleOrDefault();
if (someone != null)
{
someone.AuditStatus = status;
if (someone.AuditStatus == 3)
{ //审核通过就在Staff里面把标志置为1
var staffId = (from p in db.Staffs where p.StaffNumber == someone.StaffNumber && p.ArchiveTag != true select p.Number).ToList().FirstOrDefault();
Staff staff = db.Staffs.Find(staffId);
staff.ArchiveTag = true; //true 代表离职
staff.BindingCode = null;
//要把信息写到离职档案中
StaffArchive staffArchive = new StaffArchive();
staffArchive.BillTypeNumber = someone.BillTypeNumber;
staffArchive.BillTypeName = someone.BillTypeName;
staffArchive.BillNumber = someone.BillNumber;
staffArchive.StaffNumber = staff.StaffNumber;
staffArchive.StaffName = staff.Name;
staffArchive.LeaveDate = someone.HopeLeaveDate;
staffArchive.Department = (from p in db.Departments where p.DepartmentId == staff.Department select p.Name).ToList().FirstOrDefault();
staffArchive.IdenticationNumber = staff.IdentificationNumber;
staffArchive.RecordPerson = staff.RecordPerson;
staffArchive.RecordTime = staff.RecordTime;
staffArchive.BlackList = false;
staffArchive.WorkPlus = false;
staff.ArchiveTag = true; //true 代表离职
db.StaffArchives.Add(staffArchive); //Users表中离职；
//修改系统表
SystemDbContext sysdb = new SystemDbContext();
var Ucount = (from p in sysdb.BindCodes where (p.CompanyId == user.CompanyId && p.StaffNumber == someone.StaffNumber) select p).SingleOrDefault();
if (Ucount != null)
{
sysdb.BindCodes.Remove(Ucount);
sysdb.SaveChanges();
}
db.SaveChanges();
Push(someone.StaffNumber, user.CompanyId, status);
}
}
}
break;
case "24":
{ //技能
StaffSkill someone = (from p in db.StaffSkills where (p.BillNumber == application.BNumber) && (p.BillTypeNumber == application.BType) select p).ToList().SingleOrDefault();
if (someone != null)
{
someone.AuditStatus = status;
}
Push(someone.StaffNumber, user.CompanyId, status);
}
break;
case "25":
{ //招聘
Recruitments someone = (from p in db.Recruitments where (p.BillCode == application.BNumber) && (p.BillType == application.BType) select p).ToList().SingleOrDefault();
if (someone != null)
{
someone.AuditStatus = status;
}
}
break;
case "26":
{ //培训
TrainStart someone = (from p in db.TrainStarts where (p.BillNumber == application.BNumber) && (p.BillTypeNumber == application.BType) select p).ToList().SingleOrDefault();
if (someone != null)
{
someone.AuditStatus = status;
}
}
break;
case "27":
{ //合同
Contract someone = (from p in db.Contracts where (p.BillNumber == application.BNumber) && (p.BillTypeNumber == application.BType) select p).ToList().SingleOrDefault();
if (someone != null)
{
someone.AuditStatus = status; //已审
}
} break;
case "31":
{ //出差
EvectionApplies someone = (from p in db.EvectionApplies where (p.BillNumber == application.BNumber) && (p.BillType == application.BType) select p).SingleOrDefault();
if (someone != null)
{
someone.AuditStatus = status;
}
Push(someone.StaffNumber, user.CompanyId, status);
}
break;
case "32":
{ //请假
VacateApplies someone = (from p in db.VacateApplies where (p.BillNumber == application.BNumber) && (p.BillType == application.BType) select p).ToList().SingleOrDefault();
if (someone != null)
{
someone.AuditStatus = status;
}
Push(someone.StaffNumber, user.CompanyId, status);
}
break;
case "33":
{ //加班
OvertimeApplies someone = (from p in db.OvertimeApplies where (p.BillNumber == application.BNumber) && (p.BillType == application.BType) select p).ToList().SingleOrDefault();
if (someone != null)
{
OvertimeApplies correct = db.OvertimeApplies.Find(someone.Id);
correct.AuditPerson = someone.AuditPerson;
correct.AuditStatus = status;
correct.AuditStatusName = someone.AuditStatusName;
correct.AuditTime = someone.AuditTime;
correct.BillNumber = someone.BillNumber;
correct.BillType = someone.BillType;
correct.Date = someone.Date;
correct.EndDateTime = someone.EndDateTime;
correct.Hours = someone.Hours;
correct.IsRead = someone.IsRead;
correct.Reason = someone.Reason;
correct.Remark = someone.Remark;
correct.StaffNumber = someone.StaffNumber;
correct.StartDateTime = someone.StartDateTime;
db.SaveChanges();
}
Push(someone.StaffNumber, user.CompanyId, status);
}
break;
case "34":
{ //签卡
ChargeCardApplies someone = (from p in db.ChargeCardApplies where (p.BillNumber == application.BNumber) && (p.BillType == p.BillType) select p).ToList().SingleOrDefault();
if (someone != null)
{
someone.AuditStatus = status;
}
Push(someone.StaffNumber, user.CompanyId, status);
}
break;
case "35":
{ //调休
DaysOffApplies someone = (from p in db.DaysOffApplies where (p.BillNumber == application.BNumber) && (p.BillType == application.BType) select p).ToList().SingleOrDefault();
if (someone != null)
{
someone.AuditStatus = status;
}
Push(someone.StaffNumber, user.CompanyId, status);
}
break;
case "36":
{ //异地
VacateApplies someone = (from p in db.VacateApplies where (p.BillNumber == application.BNumber) && (p.BillType == application.BType) select p).ToList().SingleOrDefault();
if (someone != null)
{
someone.AuditStatus = status;
}
Push(someone.StaffNumber, user.CompanyId, status);
}
break;
case "37":
{ //值班
OnDutyApplies someone = (from p in db.OnDutyApplies where (p.BillNumber == application.BNumber) && (p.BillType == application.BType) select p).ToList().SingleOrDefault();
if (someone != null)
{
someone.AuditStatus = status;
}
Push(someone.StaffNumber, user.CompanyId, status);
}
break;
default:
break;
}
switch (btype)
{
case "27":
{ //合同
Contract someone = (from p in db.Contracts where p.BillNumber == application.BNumber select p).ToList().SingleOrDefault();
someone.AuditStatus = status; //已审
} break;
case "21":
{ //员工
Staff someone = (from p in db.Staffs where p.BillNumber == application.BNumber select p).ToList().SingleOrDefault();
someone.AuditStatus = status; //已审
} break;
case "24":
{ //技能
StaffSkill someone = (from p in db.StaffSkills where p.BillNumber == application.BNumber select p).ToList().SingleOrDefault();
someone.AuditStatus = status;
}
break;
case "26":
{ //培训
TrainStart someone = (from p in db.TrainStarts where p.BillNumber == application.BNumber select p).ToList().SingleOrDefault();
someone.AuditStatus = status;
}
break;
case "23":
{ //离职
StaffApplication someone = (from p in db.StaffApplications where p.BillNumber == application.BNumber select p).ToList().SingleOrDefault();
someone.AuditStatus = status;
if (someone.AuditStatus == 3)
{ //审核通过就在Staff里面把标志置为1
var staffId = (from p in db.Staffs where p.StaffNumber == someone.StaffNumber && p.ArchiveTag != true select p.Number).ToList().FirstOrDefault();
Staff staff = db.Staffs.Find(staffId);
staff.ArchiveTag = true; //true 代表离职
//要把信息写到离职档案中
StaffArchive staffArchive = new StaffArchive();
staffArchive.BillTypeNumber = someone.BillTypeNumber;
staffArchive.BillTypeName = someone.BillTypeName;
staffArchive.StaffNumber = staff.StaffNumber;
staffArchive.StaffName = staff.Name;
staffArchive.Department = staff.Department;
staffArchive.IdenticationNumber = staff.IdentificationNumber;
staffArchive.RecordPerson = staff.RecordPerson;
staffArchive.RecordTime = staff.RecordTime;
staffArchive.BillNumber = Generate.GenerateBillNumber(staffArchive.BillTypeNumber, user.ConnectionString);
db.StaffArchives.Add(staffArchive);
db.SaveChanges();
}
}
break;
case "22":
{ //变更
StaffChange someone = (from p in db.StaffChanges where p.BillNumber == application.BNumber select p).ToList().SingleOrDefault();
someone.AuditStatus = status;
if (someone.AuditStatus == 3)
{
var staffId = (from p in db.Staffs where p.StaffNumber == someone.StaffNumber && p.ArchiveTag != true select p.Number).ToList().FirstOrDefault();
Staff staff = db.Staffs.Find(staffId);
staff.Name = someone.Name;
staff.Gender = someone.Gender;
staff.Department = someone.Department;
staff.WorkType = someone.WorkType;
staff.Position = someone.Position;
staff.IdentificationNumber = someone.IdentificationNumber;
staff.Nationality = someone.Nationality;
staff.IdentificationNumber = someone.IdentificationNumber;
staff.Entrydate = someone.Entrydate;
staff.ClassOrder = someone.ClassOrder;
staff.ApplyOvertimeSwitch = staff.ApplyOvertimeSwitch;
staff.JobState = someone.JobState;
staff.AbnormalChange = someone.AbnormalChange;
staff.FreeCard = someone.FreeCard;
staff.WorkProperty = someone.WorkProperty;
staff.WorkType = someone.WorkType;
staff.Source = someone.Source;
staff.QualifyingPeriodFull = someone.QualifyingPeriodFull;
staff.MaritalStatus = someone.MaritalStatus;
staff.BirthDate = someone.BirthDate;
staff.NativePlace = someone.NativePlace;
staff.HealthCondition = someone.HealthCondition;
staff.Nation = someone.Nation;
staff.Address = someone.Address;
staff.VisaOffice = someone.VisaOffice;
staff.HomeTelNumber = someone.HomeTelNumber;
staff.EducationBackground = someone.EducationBackground;
staff.GraduationSchool = someone.GraduationSchool;
staff.SchoolMajor = someone.SchoolMajor;
staff.Degree = someone.SchoolMajor;
staff.Introducer = someone.Introducer;
staff.IndividualTelNumber = someone.IndividualTelNumber;
staff.BankCardNumber = someone.BankCardNumber;
staff.UrgencyContactMan = someone.UrgencyContactMan;
staff.UrgencyContactAddress = someone.UrgencyContactAddress;
staff.UrgencyContactPhoneNumber = someone.UrgencyContactPhoneNumber;
staff.PhysicalCardNumber = someone.PhysicalCardNumber;
staff.LeaveDate = someone.LeaveDate;
staff.LeaveType = someone.LeaveType;
staff.LeaveReason = someone.LeaveReason;
staff.AuditStatus = someone.AuditStatus;
staff.HealthCondition = someone.HealthCondition;
staff.ChangeTime = someone.RecordTime;
staff.ChangePerson = someone.RecordPerson;
staff.AuditTime = DateTime.Now;
staff.AuditPerson = user.Name;
staff.Head = someone.Head;
staff.LogicCardNumber = someone.LogicCardNumber;
staff.HeadType = someone.HeadType;
staff.IDCardNumber = someone.IDCardNumber;
staff.DeadlineDate = someone.DeadlineDate;
}
db.SaveChanges();
}
break;
case "33":
{ //加班
OvertimeApplies someone = (from p in db.OvertimeApplies where p.BillNumber == application.BNumber select p).ToList().SingleOrDefault();
someone.AuditStatus = status;
Push(someone.StaffNumber, user.CompanyId, status);
}
break;
case "32":
{ //请假
VacateApplies someone = (from p in db.VacateApplies where p.BillNumber == application.BNumber select p).ToList().SingleOrDefault();
someone.AuditStatus = status;
Push(someone.StaffNumber, user.CompanyId, status);
}
break;
case "34":
{ //请假
ChargeCardApplies someone = (from p in db.ChargeCardApplies where p.BillNumber == application.BNumber select p).ToList().SingleOrDefault();
someone.AuditStatus = status;
Push(someone.StaffNumber, user.CompanyId, status);
}
break;
case "31":
{ //出差
EvectionApplies someone = (from p in db.EvectionApplies where p.BillNumber == application.BNumber select p).SingleOrDefault();
someone.AuditStatus = status;
Push(someone.StaffNumber, user.CompanyId, status);
}
break;
case "35":
{ //出差
DaysOffApplies someone = (from p in db.DaysOffApplies where p.BillNumber == application.BNumber select p).SingleOrDefault();
someone.AuditStatus = status;
Push(someone.StaffNumber, user.CompanyId, status);
}
break;
case "36":
{ //出差
OffSiteApplies someone = (from p in db.OffSiteApplies where p.BillNumber == application.BNumber select p).SingleOrDefault();
someone.AuditStatus = status;
Push(someone.StaffNumber, user.CompanyId, status);
}
break;
case "37":
{ //出差
OnDutyApplies someone = (from p in db.OnDutyApplies where p.BillNumber == application.BNumber select p).SingleOrDefault();
someone.AuditStatus = status;
Push(someone.StaffNumber, user.CompanyId, status);
}
break;
default:
break;
}
db.SaveChanges();
}
/// <summary>
/// 处理员工请假情况
/// </summary>
/// <param name="CurrentDate">当前时间</param>
public void VacateDell(DateTime CurrentDate)
{
BonsaiiDbContext db = new BonsaiiDbContext("Data Source = 211.149.199.42,1433;Initial Catalog = Bonsaii0000000008;User ID = sa;Password = admin123@;");
SystemDbContext sysDb = new SystemDbContext("Data Source = 211.149.199.42,1433;Initial Catalog = BonsaiiSystem;User ID = sa;Password = admin123@;");
//获取请假表中未读的请假申请,条件为IsRead，当前员工号和，，以列表形式输出；
List <VacateApplies> VacateApplies = db.VacateApplies.Where(p => p.IsRead == false && DbFunctions.TruncateTime(p.StartDateTime) <= CurrentDate && DbFunctions.TruncateTime(p.EndDateTime) >= CurrentDate && p.AuditStatus == 3).ToList();
List <EveryDaySignInDate> tmpEveryDay = db.EveryDaySignInDates.Where(p => p.Date == CurrentDate).ToList();
// 遍历请假申请表，从未读的请假申请中获取员工号，请假开始时间，请假结束时间，请假日期；
foreach (VacateApplies va in VacateApplies)
{
//获取请假表中StartDateTime ,EndDateTime ,和CurrentDate做比较
//获取日考勤报表中的当前时间;
EveryDaySignInDate everydaysignindate = null;
try
{
everydaysignindate = tmpEveryDay.Where(p => p.Date == CurrentDate && p.StaffNumber == va.StaffNumber).Single();
}
catch (Exception e)
{
Tools.WriteErrorLog(e);
return;
}
List <SignInCardStatus> signincardstatus = db.SignInCardStatus.Where(p1 => p1.StaffNumber == va.StaffNumber && p1.WorkDate == CurrentDate).ToList();
foreach (SignInCardStatus sica in signincardstatus)
{
//遍历打卡表，获得NeedWorksTime,如果NeedWorksTime在请假表之间，便直接在打卡表中删除此点。
if (sica.NeedWorkTime >= va.StartDateTime.TimeOfDay && sica.NeedWorkTime <= va.EndDateTime.TimeOfDay)
{
db.SignInCardStatus.Remove(sica);
db.SaveChanges();
}
//向日考勤表报中写入数据，具体属性是添加请假类型和请假时数。
string BillType = va.BillType;
string BillTypeName = null;
try
{
BillTypeName = db.BillProperties.Where(p => p.Type == BillType).Single().TypeName;
}
catch (Exception e)
{
Tools.WriteErrorLog(e);
return;
}
// 向日考勤报表中添加请假类型
everydaysignindate.VacateType = BillTypeName;
//向日考勤报表中添加请假时数
//根据排班表和请假表中一样员工号获得员工的排班ID。根据排班ID获得Ｗorks中的TotalWorkHours
// 获取请假表中请假时数 ，与Works表中规定的工作时数做判断，判断是否大于规定工作时间，如果大于则表示请假一整天，将请假时间赋值为规定工作时间
float Hours = CalcuteVacateHours(va.StaffNumber, va.StartDateTime, va.EndDateTime, CurrentDate);
everydaysignindate.VacateHours = Hours;
}
// 保存所做编辑
db.Entry(everydaysignindate).State = EntityState.Modified;
db.SaveChanges();
//设置请假表中的IsRead属性。如果请假结束时间 < CurrentDate,那么将IsRead属性设为ture
if (va.EndDateTime <= CurrentDate)
{
va.IsRead = true;
}
db.Entry(va).State = EntityState.Modified;
db.SaveChanges();
}
}
