protected override void ExecuteDetails(JobExecutionContext context)
{
int fromCreatedToSignedProtectedDays = 3;
int fromUpdatedToSignedProtectedDays = 1;
int fromContractEndToResignedProtectedDays = 7;
if (SystemTaskInConfig != null)
{
//对得到的时间，做一天的修正处理
fromCreatedToSignedProtectedDays = Converter.ChangeType(SystemTaskInConfig.GetAddonItemValue("fromCreatedToSignedProtectedDays"), 3) + 1;
fromUpdatedToSignedProtectedDays = Converter.ChangeType(SystemTaskInConfig.GetAddonItemValue("fromUpdatedToSignedProtectedDays"), 1) + 1;
fromContractEndToResignedProtectedDays = Converter.ChangeType(SystemTaskInConfig.GetAddonItemValue("fromContractEndToResignedProtectedDays"), 7) + 1;
}
//1. 释放录入及其修改后在一段时间内都未能形成派遣的劳务人员的保护
//string sqlClauseForSignProtected = string.Format("update [XQYCLabor] set IsProtectedByOwner ={0} where LaborWorkStatus={1} AND CreateDate< '{2}' AND LastUpdateDate<'{3}' ",
// (int)Logics.False, (int)LaborWorkStatuses.NewWorker, DateTime.Today.AddDays(-fromCreatedToSignedProtectedDays), DateTime.Today.AddDays(-fromUpdatedToSignedProtectedDays));
//int rowCountForCreateUpdateProtected = LaborBLL.Instance.ExcuteNonQuery(sqlClauseForSignProtected);
//2.释放合同到期之后的一段时间内未能形成二次签约的劳务人员的保护
string sqlClauseForReSignProtected = string.Format("update [XQYCLabor] set IsProtectedByOwner ={0} where LaborWorkStatus !={1} AND CurrentContractDiscontinueDate<='{2}' AND CurrentContractDiscontinueDate!='{3}' AND LastUpdateDate<'{4}' ",
(int)Logics.False, (int)LaborWorkStatuses.Worked, DateTime.Today.AddDays(-fromContractEndToResignedProtectedDays), DateTimeHelper.Min, DateTime.Today.AddDays(fromUpdatedToSignedProtectedDays));
LaborBLL.Instance.ExcuteNonQuery(sqlClauseForReSignProtected);
//3.释放****对劳务人员的保护
}
/// <summary>
/// 企业合同到期的提醒发给所有的内部人员
/// </summary>
/// <param name="context"></param>
protected override void ExecuteDetails(JobExecutionContext context)
{
int daysOffToday = 3;
if (SystemTaskInConfig != null)
{
daysOffToday = Converter.ChangeType(SystemTaskInConfig.GetAddonItemValue("aheadDays"), 7);
}
DateTime dateLower = DateTime.Today.AddDays(daysOffToday);
DateTime dateUpper = dateLower.AddDays(1);
List <EnterpriseContractEntity> enterpriseContractList = EnterpriseContractBLL.Instance.GetList(string.Format("[ContractStatus] ={0} AND ContractStopDate>= '{1}' AND ContractStopDate<'{2}' ", (int)Logics.True, dateLower, dateUpper));
DispatchRemindMessage(enterpriseContractList);
}
/// <summary>
/// Job执行的具体实现
/// </summary>
/// <param name="context"></param>
protected override void ExecuteDetails(JobExecutionContext context)
{
int daysOffToday = 3;
if (SystemTaskInConfig != null)
{
daysOffToday = Converter.ChangeType(SystemTaskInConfig.GetAddonItemValue("aheadDays"), 3);
}
int dayOfYear = DateTime.Today.DayOfYear;
int dateLower = dayOfYear + daysOffToday;
int dateUpper = dateLower + 1;
List <BusinessUser> birthdayUserList = BusinessUserBLL.GetList(string.Format("[UserType] ={0} AND DATEPART(DY,UserBirthDay)>= {1} AND DATEPART(DY,UserBirthDay)<{2} ", (int)this.UserType, dateLower, dateUpper));
DispatchRemindMessage(birthdayUserList);
}
/// <summary>
/// 内部员工生日提醒是发送到配置文件中设置的生日提醒接收人角色
/// </summary>
/// <param name="birthdayUserList"></param>
protected override void DispatchRemindMessage(List <BusinessUser> birthdayUserList)
{
string[] roles = StringHelper.SplitToArray(SystemTaskInConfig.GetAddonItemValue("receiveRoleNames"));
RemindEntity remindEntity = CreateRemindEntity();
foreach (BusinessUser currentUser in birthdayUserList)
{
remindEntity.RemindTitle = string.Format("同事【{0}】将在{1}过生日", currentUser.UserNameDisplay, currentUser.UserBirthDay.ToShortDateString());
remindEntity.RemindCategory = RemindCategories.BirthdayRemindOfEmployee;
remindEntity.RemindUrl = string.Empty;
//向指定的角色发送提醒数据
foreach (string currentRole in roles)
{
BusinessRole role = BusinessRoleBLL.Get(currentRole);
RemindBLL.Instance.Create(role.ExecutorGuid, ExecutorTypes.Role, remindEntity);
}
}
}
protected override void ExecuteDetails(JobExecutionContext context)
{
int fromCreatedToSignedProtectedDays = 3;
int fromUpdatedToSignedProtectedDays = 1;
int fromContractEndToResignedProtectedDays = 7;
if (SystemTaskInConfig != null)
{
//对得到的时间，做一天的修正处理
fromCreatedToSignedProtectedDays = Converter.ChangeType(SystemTaskInConfig.GetAddonItemValue("fromCreatedToSignedProtectedDays"), 3) - 1;
fromUpdatedToSignedProtectedDays = Converter.ChangeType(SystemTaskInConfig.GetAddonItemValue("fromUpdatedToSignedProtectedDays"), 1) - 1;
fromContractEndToResignedProtectedDays = Converter.ChangeType(SystemTaskInConfig.GetAddonItemValue("fromContractEndToResignedProtectedDays"), 7) - 1;
}
//1. 释放录入及其修改后在一段时间内都未能形成签约的企业的保护
string sqlClauseForSignProtected = string.Format("update [GeneralEnterprise] set IsProtectedByOwner ={0} where (CooperateStatus= 0 OR CooperateStatus is null ) AND CreateDate< '{1}' AND ( LastUpdateDate<'{2}' OR LastUpdateDate is null ) ",
(int)Logics.False, DateTime.Today.AddDays(-fromCreatedToSignedProtectedDays), DateTime.Today.AddDays(-fromUpdatedToSignedProtectedDays));
int rowCountForCreateUpdateProtected = EnterpriseBLL.Instance.ExcuteNonQuery(sqlClauseForSignProtected);
//2.释放合同到期之后的一段时间内未能形成二次签约的企业的保护
//string sqlClauseForReSignProtected = string.Format("update [XQYCLabor] set IsProtectedByOwner ={0} where LaborWorkStatus={1} AND CurrentContractStopDate!='{2}' AND CurrentContractStopDate< '{3}' AND LastUpdateDate<'{4}' ",
// (int)Logics.True, (int)LaborWorkStatuses.NewWorker, DateTime.Today.AddDays(-fromCreatedToSignedProtectedDays), DateTime.Today.AddDays(fromUpdatedToSignedProtectedDays));
}
