public ActionResult MyBasicInfoEdit()
{
LaborEntity entity = LaborEntity.Empty;
entity = LaborBLL.Instance.Get(BusinessUserBLL.CurrentUserGuid);
return(View(entity));
}
public ActionResult MyBasicInfoEdit(LaborEntity editedEntity)
{
LaborEntity entity = LaborEntity.Empty;
entity = LaborBLL.Instance.Get(BusinessUserBLL.CurrentUserGuid);
entity.UserSex = editedEntity.UserSex;
entity.UserBirthDay = editedEntity.UserBirthDay;
entity.UserHeight = editedEntity.UserHeight;
entity.UserWeight = editedEntity.UserWeight;
entity.UserEducationalBackground = editedEntity.UserEducationalBackground;
entity.UserEducationalSchool = editedEntity.UserEducationalSchool;
entity.UserNation = editedEntity.UserNation;
entity.NativePlace = editedEntity.NativePlace;
entity.UserMobileNO = editedEntity.UserMobileNO;
entity.HomeTelephone = editedEntity.HomeTelephone;
entity.WorkSkill = editedEntity.WorkSkill;
entity.WorkSkillPaper = editedEntity.WorkSkillPaper;
entity.WorkSituation = editedEntity.WorkSituation;
entity.PreWorkSituation = editedEntity.PreWorkSituation;
entity.HopeWorkSituation = editedEntity.HopeWorkSituation;
entity.HopeWorkSalary = editedEntity.HopeWorkSalary;
entity.MaritalStatus = editedEntity.MaritalStatus;
entity.UrgentLinkMan = editedEntity.UrgentLinkMan;
entity.UrgentRelationship = editedEntity.UrgentRelationship;
entity.UrgentTelephone = editedEntity.UrgentTelephone;
LaborBLL.Instance.Update(entity);
return(RedirectToActionPermanent("MyBasicInfo"));
}
public ActionResult MyBasicInfoEdit(LaborEntity editedEntity)
{
LaborEntity entity = LaborEntity.Empty;
entity = LaborBLL.Instance.Get(BusinessUserBLL.CurrentUserGuid);
entity.UserSex = editedEntity.UserSex;
entity.UserBirthDay = editedEntity.UserBirthDay;
entity.UserHeight = editedEntity.UserHeight;
entity.UserWeight = editedEntity.UserWeight;
entity.UserEducationalBackground = editedEntity.UserEducationalBackground;
entity.UserEducationalSchool = editedEntity.UserEducationalSchool;
entity.UserNation = editedEntity.UserNation;
entity.NativePlace = editedEntity.NativePlace;
entity.UserMobileNO = editedEntity.UserMobileNO;
entity.HomeTelephone = editedEntity.HomeTelephone;
entity.WorkSkill = editedEntity.WorkSkill;
entity.WorkSkillPaper = editedEntity.WorkSkillPaper;
entity.WorkSituation = editedEntity.WorkSituation;
entity.PreWorkSituation = editedEntity.PreWorkSituation;
entity.HopeWorkSituation = editedEntity.HopeWorkSituation;
entity.HopeWorkSalary = editedEntity.HopeWorkSalary;
entity.MaritalStatus = editedEntity.MaritalStatus;
entity.UrgentLinkMan = editedEntity.UrgentLinkMan;
entity.UrgentRelationship = editedEntity.UrgentRelationship;
entity.UrgentTelephone = editedEntity.UrgentTelephone;
LaborBLL.Instance.Update(entity);
return RedirectToActionPermanent("MyBasicInfo");
}
/// <summary>
/// 更新当前合同的关联信息
/// </summary>
/// <param name="model">当前劳务合同</param>
private void UpdateCurrentContractData(LaborContractEntity model)
{
//1.更新此劳务人员其他的合同是否为当前项为假
this.SaveDAL.RemoveCurrentStatusOfLaborContract(model.LaborUserGuid, model.LaborContractGuid);
//2.更新此劳务人员基本信息中当前劳务合同信息的部分
LaborEntity laborEntity = LaborBLL.Instance.Get(model.LaborUserGuid);
UpdateLaborCurrentData(laborEntity, model);
}
private void DispatchRemindMessage(List <LaborContractEntity> laborContractList)
{
RemindEntity remindEntity = CreateRemindEntity();
foreach (LaborContractEntity laborContractEntity in laborContractList)
{
LaborEntity labor = laborContractEntity.Labor;
remindEntity.RemindTitle = string.Format("劳务人员【{0}】的合同【{1}】将在{2}到期", labor.UserNameCN, laborContractEntity.LaborContractDetails, laborContractEntity.LaborContractStopDate.ToShortDateString());
remindEntity.RemindCategory = RemindCategories.ContractRemindOfLabor;
remindEntity.RemindUrl = string.Empty;
RemindBLL.Instance.Create(labor.ServiceUserGuid, ExecutorTypes.User, remindEntity);
}
}
/// <summary>
/// 劳务人员的生日提醒是发送到为其服务的客服人员
/// </summary>
/// <param name="birthdayUserList"></param>
protected override void DispatchRemindMessage(List <BusinessUser> birthdayUserList)
{
RemindEntity remindEntity = CreateRemindEntity();
foreach (BusinessUser currentUser in birthdayUserList)
{
remindEntity.RemindTitle = string.Format("劳务人员【{0}】将在{1}过生日", currentUser.UserNameDisplay, currentUser.UserBirthDay.ToShortDateString());
remindEntity.RemindCategory = RemindCategories.BirthdayRemindOfLabor;
remindEntity.RemindUrl = string.Empty;
//向劳务人员的对应的业务人员发送提醒数据
LaborEntity labor = LaborBLL.Instance.Get(currentUser.UserGuid);
if (labor.BusinessUserGuid != Guid.Empty)
{
RemindBLL.Instance.Create(labor.ServiceUserGuid, ExecutorTypes.User, remindEntity);
}
}
}
public ActionResult Create(ComeFromTypes comeFromType, string controlNamePrefix = "")
{
LaborEntity labor = new LaborEntity();
labor.ComeFromType = comeFromType;
labor.UserNameCN = RequestHelper.GetValue(controlNamePrefix + "txbUserName");
labor.UserGuid = GuidHelper.NewGuid();
labor.UserName = labor.UserGuid.ToString();
labor.UserSex = (Sexes)RequestHelper.GetValue(controlNamePrefix + "drpSex", (int)Sexes.UnSet);
labor.UserBirthDay = RequestHelper.GetValue(controlNamePrefix + "txbBirthday", DateTimeHelper.Min);
labor.NativePlace = RequestHelper.GetValue(controlNamePrefix + "txbUserCountry");
labor.UserEmail = RequestHelper.GetValue(controlNamePrefix + "txbEmail");
labor.UserMobileNO = RequestHelper.GetValue(controlNamePrefix + "txbUserMobiNumber");
labor.HomeTelephone = RequestHelper.GetValue(controlNamePrefix + "txbHomeTelephone");
labor.HopeWorkSalary = RequestHelper.GetValue(controlNamePrefix + "txbHopeWorkSalary");
labor.UserEducationalSchool = RequestHelper.GetValue(controlNamePrefix + "txbUserEducationalBackground");
labor.WorkSkill = RequestHelper.GetValue(controlNamePrefix + "txbWorkSkill");
CreateUserRoleStatuses status = LaborBLL.Instance.Create(labor);
string requestUrl = RequestHelper.GetValue(controlNamePrefix + "txbPostBackURL");//"http://192.168.10.15:8001/DispatchServices/OnlineJobHunting.aspx";
if (requestUrl.Contains("?"))
{
requestUrl += "®Status=";
}
else
{
requestUrl += "?regStatus=";
}
if (status == CreateUserRoleStatuses.Successful)
{
return(RedirectPermanent(requestUrl + "true"));
}
else
{
return(RedirectPermanent(requestUrl + "false"));
}
}
/// <summary>
/// 更新劳务人员基础信息中当前劳务合同的部分
/// </summary>
/// <param name="laborEntity"></param>
/// <param name="contractEntity"></param>
private bool UpdateLaborCurrentData(LaborEntity laborEntity, LaborContractEntity contractEntity)
{
laborEntity.CurrentEnterpriseKey = contractEntity.EnterpriseGuid.ToString();
laborEntity.CurrentEnterpriseName = contractEntity.Enterprise.CompanyName;
laborEntity.CurrentContractKey = contractEntity.LaborContractGuid.ToString();
laborEntity.CurrentContractStartDate = contractEntity.LaborContractStartDate;
laborEntity.CurrentContractStopDate = contractEntity.LaborContractStopDate;
laborEntity.CurrentContractDesc = contractEntity.EnterpriseContract.ContractTitle;
laborEntity.CurrentContractDiscontinueDate = contractEntity.LaborContractDiscontinueDate;
laborEntity.CurrentContractDiscontinueDesc = contractEntity.LaborContractDiscontinueDesc;
laborEntity.LaborWorkStatus = contractEntity.LaborContractStatus;
laborEntity.LaborCode = contractEntity.LaborCode;
laborEntity.CurrentLaborDepartment = contractEntity.LaborDepartment;
laborEntity.CurrentLaborWorkShop = contractEntity.LaborWorkShop;
laborEntity.CurrentDispatchType = contractEntity.DispatchType;
return(LaborBLL.Instance.Update(laborEntity));
}
public ActionResult Create(ComeFromTypes comeFromType, string controlNamePrefix = "")
{
LaborEntity labor = new LaborEntity();
labor.ComeFromType = comeFromType;
labor.UserNameCN = RequestHelper.GetValue(controlNamePrefix + "txbUserName");
labor.UserGuid = GuidHelper.NewGuid();
labor.UserName = labor.UserGuid.ToString();
labor.UserSex = (Sexes)RequestHelper.GetValue(controlNamePrefix + "drpSex", (int)Sexes.UnSet);
labor.UserBirthDay = RequestHelper.GetValue(controlNamePrefix + "txbBirthday", DateTimeHelper.Min);
labor.NativePlace = RequestHelper.GetValue(controlNamePrefix + "txbUserCountry");
labor.UserEmail = RequestHelper.GetValue(controlNamePrefix + "txbEmail");
labor.UserMobileNO = RequestHelper.GetValue(controlNamePrefix + "txbUserMobiNumber");
labor.HomeTelephone = RequestHelper.GetValue(controlNamePrefix + "txbHomeTelephone");
labor.HopeWorkSalary = RequestHelper.GetValue(controlNamePrefix + "txbHopeWorkSalary");
labor.UserEducationalSchool = RequestHelper.GetValue(controlNamePrefix + "txbUserEducationalBackground");
labor.WorkSkill = RequestHelper.GetValue(controlNamePrefix + "txbWorkSkill");
CreateUserRoleStatuses status = LaborBLL.Instance.Create(labor);
string requestUrl = RequestHelper.GetValue(controlNamePrefix + "txbPostBackURL");//"http://192.168.10.15:8001/DispatchServices/OnlineJobHunting.aspx";
if (requestUrl.Contains("?"))
{
requestUrl += "®Status=";
}
else
{
requestUrl += "?regStatus=";
}
if (status == CreateUserRoleStatuses.Successful)
{
return RedirectPermanent(requestUrl + "true");
}
else
{
return RedirectPermanent(requestUrl + "false");
}
}
public ActionResult Item(string itemKey, LaborEntity entity, bool isOnlyPlaceHolder = true)
{
bool isSuccessful = false;
string displayMessage = string.Empty;
CreateUserRoleStatuses createStatus = CreateUserRoleStatuses.Successful;
string returnUrl = RequestHelper.GetValue("returnUrl");
if (string.IsNullOrWhiteSpace(returnUrl))
{
returnUrl = Url.Action("Index");
}
else
{
bool isUsingCompress = RequestHelper.GetValue<bool>("isUsingCompress");
if (isUsingCompress == true)
{
returnUrl = CompressHelper.Decompress(returnUrl);
}
}
LaborEntity targetEntity = null;
if (GuidHelper.IsInvalidOrEmpty(itemKey))
{
targetEntity = new LaborEntity();
SetTargetEntityValue(entity, ref targetEntity);
targetEntity.UserRegisterDate = DateTime.Now;
targetEntity.UserType = UserTypes.CommonUser;
targetEntity.Password = SystemConst.InitialUserPassword;
targetEntity.LaborWorkStatus = LaborWorkStatuses.NewWorker;
targetEntity.ComeFromType = ComeFromTypes.ManageWrite;
//首次录入系统，劳务人员的状态为未激活
targetEntity.UserStatus = UserStatuses.Unactivated;
createStatus = LaborBLL.Instance.Create(targetEntity);
if (createStatus == CreateUserRoleStatuses.Successful)
{
isSuccessful = true;
}
}
else
{
targetEntity = LaborBLL.Instance.Get(itemKey);
SetTargetEntityValue(entity, ref targetEntity);
isSuccessful = LaborBLL.Instance.Update(targetEntity);
if (isSuccessful == false)
{
createStatus = CreateUserRoleStatuses.FailureUnknowReason;
}
}
if (isSuccessful == true)
{
displayMessage = "数据保存成功";
}
else
{
displayMessage = string.Format("数据保存失败,原因为{0}", EnumHelper.GetDisplayValue(createStatus));
}
if (isSuccessful == true)
{
return Redirect(returnUrl);
}
else
{
List<SystemStatusInfo> infoList = new List<SystemStatusInfo>();
SystemStatusInfo itemStatus = new SystemStatusInfo();
itemStatus.SystemStatus = SystemStatuses.Failuer;
itemStatus.Message = string.Format("{0}", displayMessage);
infoList.Add(itemStatus);
this.TempData.Add("OperationResultData", infoList);
return RedirectToAction("OperationResults", "System", new { returnUrl = returnUrl });
}
}
public ActionResult BatchEntering(bool isOnlyPlaceholder = true)
{
List<SystemStatusInfo> infoList = new List<SystemStatusInfo>();
string returnUrl = RequestHelper.CurrentFullUrl;
int headerRowNumber = RequestHelper.GetValue<int>("headerRowNumber", 1);
HttpPostedFile postedFile = RequestHelper.CurrentRequest.Files["fileSelector"];
if (HttpPostedFileHelper.HasFile(postedFile))
{
try
{
int userCountSuccessful = 0;
int userCountFailure = 0;
string userListFailure = string.Empty;
DataTable dataTable = ExcelHelper.ReadExcel(postedFile.InputStream, headerRowNumber);
NameValueCollection laborMapData = (NameValueCollection)ConfigurationManager.GetSection("laborBasicDataMap");
List<string> columnNameList = new List<string>();
for (int i = 0; i < dataTable.Columns.Count; i++)
{
columnNameList.Add(dataTable.Columns[i].ColumnName);
}
//Hack:xieran20121109 为了匹配所有的服务角色的guid，这里获取全部内部员工的信息，如果以后员工人数数量
//增加到一个程度后，可能会有性能问题
List<BusinessUser> employeeList = BusinessUserBLL.GetList(UserTypes.Manager);
for (int i = 0; i < dataTable.Rows.Count; i++)
{
int originalExcelRowNumber = headerRowNumber + i + 1;
try
{
DataRow row = dataTable.Rows[i];
if (row == null)
{
continue;
}
string userAgeString = string.Empty;
string userBirhdayString = string.Empty;
string userSexString = string.Empty;
LaborEntity laborEntity = new LaborEntity();
foreach (string columnName in columnNameList)
{
//1.根据Excel文件中的列名称映射Labor实体的属性名称
string propertyName = laborMapData[columnName];
if (string.IsNullOrWhiteSpace(propertyName))
{
continue;
}
//2.给Labor实体属性赋值
object cellValue = row[columnName];
if (cellValue != null)
{
switch (propertyName)
{
case "HouseHoldType":
laborEntity.HouseHoldType = EnumHelper.GetItem<HouseHoldTypes>(cellValue.ToString());
break;
case "MaritalStatus":
laborEntity.MaritalStatus = EnumHelper.GetItem<MaritalStatuses>(cellValue.ToString());
break;
case "UserSex":
userSexString = cellValue.ToString();
break;
case "UserEducationalBackground":
laborEntity.UserEducationalBackground = EnumHelper.GetItem<EducationalBackgrounds>(cellValue.ToString());
break;
case "UserAge":
userAgeString = cellValue.ToString();
break;
case "UserBirthday":
userBirhdayString = cellValue.ToString();
break;
default:
ReflectHelper.SetPropertyValue<LaborEntity>(laborEntity, propertyName, cellValue);
break;
}
}
}
laborEntity.Password = SystemConst.InitialUserPassword;
laborEntity.UserType = UserTypes.CommonUser;
laborEntity.UserRegisterDate = DateTime.Now;
//从Excel导入的各个服务角色的姓名，以下将其转换为guid
laborEntity.ProviderUserGuid = GetEmployeeGuid(employeeList, laborEntity.ProviderUserName);
laborEntity.RecommendUserGuid = GetEmployeeGuid(employeeList, laborEntity.RecommendUserName);
laborEntity.FinanceUserGuid = GetEmployeeGuid(employeeList, laborEntity.FinanceUserName);
laborEntity.ServiceUserGuid = GetEmployeeGuid(employeeList, laborEntity.ServiceUserName);
laborEntity.BusinessUserGuid = GetEmployeeGuid(employeeList, laborEntity.BusinessUserName);
laborEntity.SettleUserGuid = GetEmployeeGuid(employeeList, laborEntity.SettleUserName);
laborEntity.InformationBrokerUserGuid = GetInformationBrokerGuid(laborEntity.InformationBrokerUserName);
IDCard idCard = IDCard.Parse(laborEntity.UserCardID);
//人员生日的抽取先后顺序1、直接的生日输入 2、身份证中提取 3、年龄计算。（满足前面的条件，自动跳过后面的条件）
DateTime userBirthDay = DateTimeHelper.Parse(userBirhdayString, DateFormats.YMD);
if (userBirthDay == DateTimeHelper.Min)
{
userBirthDay = idCard.BirthDay;
}
if (userBirthDay == DateTimeHelper.Min)
{
userBirthDay = new DateTime(DateTime.Today.Year - Converter.ChangeType(userAgeString, 25), 1, 1);
}
laborEntity.UserBirthDay = userBirthDay;
//人员性别的抽取顺序1、直接输入的性别 2、身份证中提取
Sexes userSex = EnumHelper.GetItem<Sexes>(userSexString, string.Empty, Sexes.UnSet);
if (userSex == Sexes.UnSet)
{
userSex = idCard.Sex;
}
laborEntity.UserSex = userSex;
//必须人员姓名和身份证同时为空时，不保存
if (string.IsNullOrWhiteSpace(laborEntity.UserNameCN) && string.IsNullOrWhiteSpace(laborEntity.UserCardID))
{
userCountFailure++;
userListFailure += string.Format("{0}(人员姓名和身份证同时为空), <br />", originalExcelRowNumber);
}
else
{
laborEntity.ComeFromType = ComeFromTypes.ManageBatch;
//首次录入系统，劳务人员的状态为未激活
laborEntity.UserStatus = UserStatuses.Unactivated;
CreateUserRoleStatuses createStatus = LaborBLL.Instance.Create(laborEntity);
if (createStatus == CreateUserRoleStatuses.Successful)
{
userCountSuccessful++;
}
else
{
userCountFailure++;
userListFailure += string.Format("{0}({1}), <br />", originalExcelRowNumber, EnumHelper.GetDisplayValue(createStatus));
}
}
}
catch (Exception)
{
userCountFailure++;
userListFailure += originalExcelRowNumber + ", <br />";
}
}
SystemStatusInfo itemSuccessful = new SystemStatusInfo();
itemSuccessful.SystemStatus = SystemStatuses.Success;
itemSuccessful.Message = string.Format("共有{0}人导入成功。", userCountSuccessful);
infoList.Add(itemSuccessful);
if (userCountFailure > 0)
{
SystemStatusInfo itemError = new SystemStatusInfo();
itemError.SystemStatus = SystemStatuses.Failuer;
itemError.Message = string.Format("共有{0}人导入失败。", userCountFailure);
if (string.IsNullOrWhiteSpace(userListFailure) == false)
{
itemError.Message += string.Format("导入失败的人员分别位于{0}行", userListFailure);
}
infoList.Add(itemError);
}
}
catch (NPOI.POIFS.FileSystem.OfficeXmlFileException)
{
SystemStatusInfo itemError = new SystemStatusInfo();
itemError.SystemStatus = SystemStatuses.Failuer;
itemError.Message = "请选择Excel2003格式的文件。你可以将本文件在Excel中另存的时候选择97/2003格式！";
infoList.Add(itemError);
}
}
else
{
SystemStatusInfo itemError = new SystemStatusInfo();
itemError.SystemStatus = SystemStatuses.Warnning;
itemError.Message = "没有选择Excel文件，请先选择文件然后再进行导入！";
infoList.Add(itemError);
}
this.TempData.Add("OperationResultData", infoList);
return RedirectToAction("OperationResults", "System", new { returnUrl = returnUrl });
}
/// <summary>
/// 通过一个实体给另外一个实体赋值
/// </summary>
/// <param name="entity"></param>
/// <param name="targetEntity"></param>
private static void SetTargetEntityValue(LaborEntity originalEntity, ref LaborEntity targetEntity)
{
targetEntity.UserStatus = originalEntity.UserStatus;
targetEntity.UserNameCN = originalEntity.UserNameCN;
targetEntity.UserCardID = originalEntity.UserCardID;
targetEntity.UserHeight = originalEntity.UserHeight;
targetEntity.UserWeight = originalEntity.UserWeight;
targetEntity.UserEducationalBackground = originalEntity.UserEducationalBackground;
targetEntity.UserNation = originalEntity.UserNation;
targetEntity.NativePlace = originalEntity.NativePlace;
targetEntity.UserMobileNO = originalEntity.UserMobileNO;
targetEntity.HomeTelephone = originalEntity.HomeTelephone;
targetEntity.WorkSkill = originalEntity.WorkSkill;
targetEntity.WorkSkillPaper = originalEntity.WorkSkillPaper;
targetEntity.WorkSituation = originalEntity.WorkSituation;
targetEntity.PreWorkSituation = originalEntity.PreWorkSituation;
targetEntity.HopeWorkSituation = originalEntity.HopeWorkSituation;
targetEntity.HopeWorkSalary = originalEntity.HopeWorkSalary;
targetEntity.MaritalStatus = originalEntity.MaritalStatus;
targetEntity.UrgentLinkMan = originalEntity.UrgentLinkMan;
targetEntity.UrgentTelephone = originalEntity.UrgentTelephone;
targetEntity.UrgentRelationship = originalEntity.UrgentRelationship;
targetEntity.Memo1 = originalEntity.Memo1;
targetEntity.Memo2 = originalEntity.Memo2;
targetEntity.Memo3 = originalEntity.Memo3;
targetEntity.Memo4 = originalEntity.Memo4;
targetEntity.Memo5 = originalEntity.Memo5;
//targetEntity.CurrentDispatchType = originalEntity.CurrentDispatchType;
targetEntity.ComeFromType = originalEntity.ComeFromType;
targetEntity.SocialSecurityNumber = originalEntity.SocialSecurityNumber;
targetEntity.HouseHoldType = originalEntity.HouseHoldType;
targetEntity.UserEducationalSchool = originalEntity.UserEducationalSchool;
IDCard idCard = IDCard.Parse(targetEntity.UserCardID);
targetEntity.UserSex = originalEntity.UserSex;
if (targetEntity.UserSex == Sexes.UnSet)
{
targetEntity.UserSex = idCard.Sex;
}
targetEntity.UserBirthDay = originalEntity.UserBirthDay;
if (targetEntity.UserBirthDay == DateTimeHelper.Min)
{
targetEntity.UserBirthDay = idCard.BirthDay;
}
targetEntity.IDCardPlace = originalEntity.IDCardPlace;
if (string.IsNullOrWhiteSpace(targetEntity.IDCardPlace))
{
targetEntity.IDCardPlace = idCard.GetAddress();
}
targetEntity.InformationBrokerUserGuid = ControlHelper.GetRealValue<Guid>("InformationBroker");
targetEntity.InformationBrokerUserName = RequestHelper.GetValue("InformationBroker");
targetEntity.FinanceUserName = RequestHelper.GetValue("FinanceUser");
targetEntity.FinanceUserGuid = RequestHelper.GetValue<Guid>("FinanceUser_Value");
targetEntity.ProviderUserName = RequestHelper.GetValue("ProviderUser");
targetEntity.ProviderUserGuid = RequestHelper.GetValue<Guid>("ProviderUser_Value");
targetEntity.RecommendUserName = RequestHelper.GetValue("RecommendUser");
targetEntity.RecommendUserGuid = RequestHelper.GetValue<Guid>("RecommendUser_Value");
targetEntity.ServiceUserName = RequestHelper.GetValue("ServiceUser");
targetEntity.ServiceUserGuid = RequestHelper.GetValue<Guid>("ServiceUser_Value");
targetEntity.BusinessUserName = RequestHelper.GetValue("BusinessUser");
targetEntity.BusinessUserGuid = RequestHelper.GetValue<Guid>("BusinessUser_Value");
targetEntity.SettleUserName = RequestHelper.GetValue("SettleUser");
targetEntity.SettleUserGuid = RequestHelper.GetValue<Guid>("SettleUser_Value");
}
protected override TParameter[] PrepareParasAll(LaborEntity entity)
{
List <TParameter> list = new List <TParameter>()
{
GenerateParameter("LaborID", entity.LaborID),
GenerateParameter("UserGuid", entity.UserGuid),
GenerateParameter("LaborCode", entity.LaborCode ?? String.Empty),
GenerateParameter("NativePlace", entity.NativePlace ?? String.Empty),
GenerateParameter("CurrentPlace", entity.CurrentPlace ?? String.Empty),
GenerateParameter("IDCardPlace", entity.IDCardPlace ?? String.Empty),
GenerateParameter("HouseHoldType", (int)entity.HouseHoldType),
GenerateParameter("WorkSkill", entity.WorkSkill ?? String.Empty),
GenerateParameter("WorkSkillPaper", entity.WorkSkillPaper ?? String.Empty),
GenerateParameter("WorkSituation", entity.WorkSituation ?? String.Empty),
GenerateParameter("PreWorkSituation", entity.PreWorkSituation ?? String.Empty),
GenerateParameter("HopeWorkSituation", entity.HopeWorkSituation ?? String.Empty),
GenerateParameter("HopeWorkSalary", entity.HopeWorkSalary ?? String.Empty),
GenerateParameter("UrgentLinkMan", entity.UrgentLinkMan ?? String.Empty),
GenerateParameter("UrgentTelephone", entity.UrgentTelephone ?? String.Empty),
GenerateParameter("UrgentRelationship", entity.UrgentRelationship ?? String.Empty),
GenerateParameter("InformationComeFrom", entity.InformationComeFrom ?? String.Empty),
GenerateParameter("ProviderUserGuid", entity.ProviderUserGuid),
GenerateParameter("ProviderUserName", entity.ProviderUserName ?? String.Empty),
GenerateParameter("RecommendUserGuid", entity.RecommendUserGuid),
GenerateParameter("RecommendUserName", entity.RecommendUserName ?? String.Empty),
GenerateParameter("ServiceUserGuid", entity.ServiceUserGuid),
GenerateParameter("ServiceUserName", entity.ServiceUserName ?? String.Empty),
GenerateParameter("FinanceUserGuid", entity.FinanceUserGuid),
GenerateParameter("FinanceUserName", entity.FinanceUserName ?? String.Empty),
GenerateParameter("BusinessUserGuid", entity.BusinessUserGuid),
GenerateParameter("BusinessUserName", entity.BusinessUserName ?? String.Empty),
GenerateParameter("SettleUserGuid", entity.SettleUserGuid),
GenerateParameter("SettleUserName", entity.SettleUserName ?? String.Empty),
GenerateParameter("InformationBrokerUserGuid", entity.InformationBrokerUserGuid),
GenerateParameter("InformationBrokerUserName", entity.InformationBrokerUserName ?? String.Empty),
GenerateParameter("InsureType", entity.InsureType),
GenerateParameter("LaborWorkStatus", entity.LaborWorkStatus),
GenerateParameter("CurrentLaborDepartment", entity.CurrentLaborDepartment ?? String.Empty),
GenerateParameter("CurrentLaborWorkShop", entity.CurrentLaborWorkShop ?? String.Empty),
GenerateParameter("CurrentContractStartDate", entity.CurrentContractStartDate),
GenerateParameter("CurrentContractStopDate", entity.CurrentContractStopDate),
GenerateParameter("CurrentContractDesc", entity.CurrentContractDesc ?? String.Empty),
GenerateParameter("CurrentContractDiscontinueDate", entity.CurrentContractDiscontinueDate),
GenerateParameter("CurrentContractDiscontinueDesc", entity.CurrentContractDiscontinueDesc ?? String.Empty),
GenerateParameter("CurrentEnterpriseKey", entity.CurrentEnterpriseKey ?? String.Empty),
GenerateParameter("CurrentEnterpriseName", entity.CurrentEnterpriseName ?? String.Empty),
GenerateParameter("CurrentContractKey", entity.CurrentContractKey ?? String.Empty),
GenerateParameter("Memo1", entity.Memo1 ?? String.Empty),
GenerateParameter("Memo2", entity.Memo2 ?? String.Empty),
GenerateParameter("Memo3", entity.Memo3 ?? String.Empty),
GenerateParameter("Memo4", entity.Memo4 ?? String.Empty),
GenerateParameter("Memo5", entity.Memo5 ?? String.Empty),
GenerateParameter("CreateUserKey", entity.CreateUserKey ?? String.Empty),
GenerateParameter("CreateUserName", entity.CreateUserName ?? String.Empty),
GenerateParameter("CreateDate", entity.CreateDate),
GenerateParameter("LastUpdateUserKey", entity.LastUpdateUserKey ?? String.Empty),
GenerateParameter("LastUpdateUserName", entity.LastUpdateUserName ?? String.Empty),
GenerateParameter("LastUpdateDate", entity.LastUpdateDate),
GenerateParameter("IsProtectedByOwner", entity.IsProtectedByOwner),
GenerateParameter("CurrentDispatchType", entity.CurrentDispatchType),
GenerateParameter("ComeFromType", entity.ComeFromType),
GenerateParameter("PropertyNames", entity.PropertyNames ?? String.Empty),
GenerateParameter("PropertyValues", entity.PropertyValues ?? String.Empty)
};
return(list.ToArray());
}
public override bool Create(LaborEntity entity)
{
if (entity.CreateDate == DateTimeHelper.Min)
{
entity.CreateDate = DateTime.Now;
}
if (string.IsNullOrEmpty(entity.CreateUserKey))
{
entity.CreateUserKey = BusinessUserBLL.CurrentUserGuid.ToString();
entity.CreateUserName = BusinessUserBLL.CurrentUser.UserNameDisplay;
}
string commandText = string.Format(@"Insert Into [XQYCLabor] (
[UserGuid],
[LaborCode],
[NativePlace],
[CurrentPlace],
[IDCardPlace],
[HouseHoldType],
[WorkSkill],
[WorkSkillPaper],
[WorkSituation],
[PreWorkSituation],
[HopeWorkSituation],
[HopeWorkSalary],
[UrgentLinkMan],
[UrgentTelephone],
[UrgentRelationship],
[InformationComeFrom],
[ProviderUserGuid],
[ProviderUserName],
[RecommendUserGuid],
[RecommendUserName],
[ServiceUserGuid],
[ServiceUserName],
[FinanceUserGuid],
[FinanceUserName],
[BusinessUserGuid],
[BusinessUserName],
[SettleUserGuid],
[SettleUserName],
[InformationBrokerUserGuid],
[InformationBrokerUserName],
[InsureType],
[LaborWorkStatus],
[CurrentLaborDepartment],
[CurrentLaborWorkShop],
[CurrentContractStartDate],
[CurrentContractStopDate],
[CurrentContractDesc],
[CurrentContractDiscontinueDate],
[CurrentContractDiscontinueDesc],
[CurrentEnterpriseKey],
[CurrentEnterpriseName],
[CurrentContractKey],
[Memo1],
[Memo2],
[Memo3],
[Memo4],
[Memo5],
[CreateUserKey],
[CreateUserName],
[CreateDate],
[LastUpdateUserKey],
[LastUpdateUserName],
[LastUpdateDate],
[IsProtectedByOwner],
[CurrentDispatchType],
[ComeFromType],
[PropertyNames],
[PropertyValues]
)
Values (
{0}UserGuid,
{0}LaborCode,
{0}NativePlace,
{0}CurrentPlace,
{0}IDCardPlace,
{0}HouseHoldType,
{0}WorkSkill,
{0}WorkSkillPaper,
{0}WorkSituation,
{0}PreWorkSituation,
{0}HopeWorkSituation,
{0}HopeWorkSalary,
{0}UrgentLinkMan,
{0}UrgentTelephone,
{0}UrgentRelationship,
{0}InformationComeFrom,
{0}ProviderUserGuid,
{0}ProviderUserName,
{0}RecommendUserGuid,
{0}RecommendUserName,
{0}ServiceUserGuid,
{0}ServiceUserName,
{0}FinanceUserGuid,
{0}FinanceUserName,
{0}BusinessUserGuid,
{0}BusinessUserName,
{0}SettleUserGuid,
{0}SettleUserName,
{0}InformationBrokerUserGuid,
{0}InformationBrokerUserName,
{0}InsureType,
{0}LaborWorkStatus,
{0}CurrentLaborDepartment,
{0}CurrentLaborWorkShop,
{0}CurrentContractStartDate,
{0}CurrentContractStopDate,
{0}CurrentContractDesc,
{0}CurrentContractDiscontinueDate,
{0}CurrentContractDiscontinueDesc,
{0}CurrentEnterpriseKey,
{0}CurrentEnterpriseName,
{0}CurrentContractKey,
{0}Memo1,
{0}Memo2,
{0}Memo3,
{0}Memo4,
{0}Memo5,
{0}CreateUserKey,
{0}CreateUserName,
{0}CreateDate,
{0}LastUpdateUserKey,
{0}LastUpdateUserName,
{0}LastUpdateDate,
{0}IsProtectedByOwner,
{0}CurrentDispatchType,
{0}ComeFromType,
{0}PropertyNames,
{0}PropertyValues
)", ParameterNamePrefix);
TParameter[] sqlParas = PrepareParasAll(entity);
bool isSuccessful = HelperExInstance.ExecuteSingleRowNonQuery(commandText, sqlParas);
return(isSuccessful);
}
protected override LaborEntity Load(IDataReader reader)
{
LaborEntity entity = null;
if (reader != null && reader.IsClosed == false)
{
BusinessUser businessUser = BusinessUserCommonDAL <TTransaction, TConnection, TCommand, TDataReader, TParameter> .Load((TDataReader)reader);
entity = Converter.InheritedEntityConvert <BusinessUser, LaborEntity>(businessUser);
if (DataReaderHelper.IsExistFieldAndNotNull(reader, "LaborID"))
{
entity.LaborID = reader.GetInt32(reader.GetOrdinal("LaborID"));
}
if (DataReaderHelper.IsExistFieldAndNotNull(reader, "UserGuid"))
{
entity.UserGuid = reader.GetGuid(reader.GetOrdinal("UserGuid"));
}
if (DataReaderHelper.IsExistFieldAndNotNull(reader, "LaborCode"))
{
entity.LaborCode = reader.GetString(reader.GetOrdinal("LaborCode"));
}
if (DataReaderHelper.IsExistFieldAndNotNull(reader, "NativePlace"))
{
entity.NativePlace = reader.GetString(reader.GetOrdinal("NativePlace"));
}
if (DataReaderHelper.IsExistFieldAndNotNull(reader, "CurrentPlace"))
{
entity.CurrentPlace = reader.GetString(reader.GetOrdinal("CurrentPlace"));
}
if (DataReaderHelper.IsExistFieldAndNotNull(reader, "IDCardPlace"))
{
entity.IDCardPlace = reader.GetString(reader.GetOrdinal("IDCardPlace"));
}
if (DataReaderHelper.IsExistFieldAndNotNull(reader, "HouseHoldType"))
{
entity.HouseHoldType = (HouseHoldTypes)reader.GetInt32(reader.GetOrdinal("HouseHoldType"));
}
if (DataReaderHelper.IsExistFieldAndNotNull(reader, "WorkSkill"))
{
entity.WorkSkill = reader.GetString(reader.GetOrdinal("WorkSkill"));
}
if (DataReaderHelper.IsExistFieldAndNotNull(reader, "WorkSkillPaper"))
{
entity.WorkSkillPaper = reader.GetString(reader.GetOrdinal("WorkSkillPaper"));
}
if (DataReaderHelper.IsExistFieldAndNotNull(reader, "WorkSituation"))
{
entity.WorkSituation = reader.GetString(reader.GetOrdinal("WorkSituation"));
}
if (DataReaderHelper.IsExistFieldAndNotNull(reader, "PreWorkSituation"))
{
entity.PreWorkSituation = reader.GetString(reader.GetOrdinal("PreWorkSituation"));
}
if (DataReaderHelper.IsExistFieldAndNotNull(reader, "HopeWorkSituation"))
{
entity.HopeWorkSituation = reader.GetString(reader.GetOrdinal("HopeWorkSituation"));
}
if (DataReaderHelper.IsExistFieldAndNotNull(reader, "HopeWorkSalary"))
{
entity.HopeWorkSalary = reader.GetString(reader.GetOrdinal("HopeWorkSalary"));
}
if (DataReaderHelper.IsExistFieldAndNotNull(reader, "UrgentLinkMan"))
{
entity.UrgentLinkMan = reader.GetString(reader.GetOrdinal("UrgentLinkMan"));
}
if (DataReaderHelper.IsExistFieldAndNotNull(reader, "UrgentTelephone"))
{
entity.UrgentTelephone = reader.GetString(reader.GetOrdinal("UrgentTelephone"));
}
if (DataReaderHelper.IsExistFieldAndNotNull(reader, "UrgentRelationship"))
{
entity.UrgentRelationship = reader.GetString(reader.GetOrdinal("UrgentRelationship"));
}
if (DataReaderHelper.IsExistFieldAndNotNull(reader, "InformationComeFrom"))
{
entity.InformationComeFrom = reader.GetString(reader.GetOrdinal("InformationComeFrom"));
}
if (DataReaderHelper.IsExistFieldAndNotNull(reader, "ProviderUserGuid"))
{
entity.ProviderUserGuid = reader.GetGuid(reader.GetOrdinal("ProviderUserGuid"));
}
if (DataReaderHelper.IsExistFieldAndNotNull(reader, "ProviderUserName"))
{
entity.ProviderUserName = reader.GetString(reader.GetOrdinal("ProviderUserName"));
}
if (DataReaderHelper.IsExistFieldAndNotNull(reader, "RecommendUserGuid"))
{
entity.RecommendUserGuid = reader.GetGuid(reader.GetOrdinal("RecommendUserGuid"));
}
if (DataReaderHelper.IsExistFieldAndNotNull(reader, "RecommendUserName"))
{
entity.RecommendUserName = reader.GetString(reader.GetOrdinal("RecommendUserName"));
}
if (DataReaderHelper.IsExistFieldAndNotNull(reader, "ServiceUserGuid"))
{
entity.ServiceUserGuid = reader.GetGuid(reader.GetOrdinal("ServiceUserGuid"));
}
if (DataReaderHelper.IsExistFieldAndNotNull(reader, "ServiceUserName"))
{
entity.ServiceUserName = reader.GetString(reader.GetOrdinal("ServiceUserName"));
}
if (DataReaderHelper.IsExistFieldAndNotNull(reader, "FinanceUserGuid"))
{
entity.FinanceUserGuid = reader.GetGuid(reader.GetOrdinal("FinanceUserGuid"));
}
if (DataReaderHelper.IsExistFieldAndNotNull(reader, "FinanceUserName"))
{
entity.FinanceUserName = reader.GetString(reader.GetOrdinal("FinanceUserName"));
}
if (DataReaderHelper.IsExistFieldAndNotNull(reader, "BusinessUserGuid"))
{
entity.BusinessUserGuid = reader.GetGuid(reader.GetOrdinal("BusinessUserGuid"));
}
if (DataReaderHelper.IsExistFieldAndNotNull(reader, "BusinessUserName"))
{
entity.BusinessUserName = reader.GetString(reader.GetOrdinal("BusinessUserName"));
}
if (DataReaderHelper.IsExistFieldAndNotNull(reader, "SettleUserGuid"))
{
entity.SettleUserGuid = reader.GetGuid(reader.GetOrdinal("SettleUserGuid"));
}
if (DataReaderHelper.IsExistFieldAndNotNull(reader, "SettleUserName"))
{
entity.SettleUserName = reader.GetString(reader.GetOrdinal("SettleUserName"));
}
if (DataReaderHelper.IsExistFieldAndNotNull(reader, "InformationBrokerUserGuid"))
{
entity.InformationBrokerUserGuid = reader.GetGuid(reader.GetOrdinal("InformationBrokerUserGuid"));
}
if (DataReaderHelper.IsExistFieldAndNotNull(reader, "InformationBrokerUserName"))
{
entity.InformationBrokerUserName = reader.GetString(reader.GetOrdinal("InformationBrokerUserName"));
}
if (DataReaderHelper.IsExistFieldAndNotNull(reader, "InsureType"))
{
entity.InsureType = reader.GetInt32(reader.GetOrdinal("InsureType"));
}
if (DataReaderHelper.IsExistFieldAndNotNull(reader, "LaborWorkStatus"))
{
entity.LaborWorkStatus = (LaborWorkStatuses)reader.GetInt32(reader.GetOrdinal("LaborWorkStatus"));
}
if (DataReaderHelper.IsExistFieldAndNotNull(reader, "CurrentLaborDepartment"))
{
entity.CurrentLaborDepartment = reader.GetString(reader.GetOrdinal("CurrentLaborDepartment"));
}
if (DataReaderHelper.IsExistFieldAndNotNull(reader, "CurrentLaborWorkShop"))
{
entity.CurrentLaborWorkShop = reader.GetString(reader.GetOrdinal("CurrentLaborWorkShop"));
}
if (DataReaderHelper.IsExistFieldAndNotNull(reader, "CurrentContractStartDate"))
{
entity.CurrentContractStartDate = reader.GetDateTime(reader.GetOrdinal("CurrentContractStartDate"));
}
if (DataReaderHelper.IsExistFieldAndNotNull(reader, "CurrentContractStopDate"))
{
entity.CurrentContractStopDate = reader.GetDateTime(reader.GetOrdinal("CurrentContractStopDate"));
}
if (DataReaderHelper.IsExistFieldAndNotNull(reader, "CurrentContractDesc"))
{
entity.CurrentContractDesc = reader.GetString(reader.GetOrdinal("CurrentContractDesc"));
}
if (DataReaderHelper.IsExistFieldAndNotNull(reader, "CurrentContractDiscontinueDate"))
{
entity.CurrentContractDiscontinueDate = reader.GetDateTime(reader.GetOrdinal("CurrentContractDiscontinueDate"));
}
if (DataReaderHelper.IsExistFieldAndNotNull(reader, "CurrentContractDiscontinueDesc"))
{
entity.CurrentContractDiscontinueDesc = reader.GetString(reader.GetOrdinal("CurrentContractDiscontinueDesc"));
}
if (DataReaderHelper.IsExistFieldAndNotNull(reader, "CurrentEnterpriseKey"))
{
entity.CurrentEnterpriseKey = reader.GetString(reader.GetOrdinal("CurrentEnterpriseKey"));
}
if (DataReaderHelper.IsExistFieldAndNotNull(reader, "CurrentEnterpriseName"))
{
entity.CurrentEnterpriseName = reader.GetString(reader.GetOrdinal("CurrentEnterpriseName"));
}
if (DataReaderHelper.IsExistFieldAndNotNull(reader, "CurrentContractKey"))
{
entity.CurrentContractKey = reader.GetString(reader.GetOrdinal("CurrentContractKey"));
}
if (DataReaderHelper.IsExistFieldAndNotNull(reader, "Memo1"))
{
entity.Memo1 = reader.GetString(reader.GetOrdinal("Memo1"));
}
if (DataReaderHelper.IsExistFieldAndNotNull(reader, "Memo2"))
{
entity.Memo2 = reader.GetString(reader.GetOrdinal("Memo2"));
}
if (DataReaderHelper.IsExistFieldAndNotNull(reader, "Memo3"))
{
entity.Memo3 = reader.GetString(reader.GetOrdinal("Memo3"));
}
if (DataReaderHelper.IsExistFieldAndNotNull(reader, "Memo4"))
{
entity.Memo4 = reader.GetString(reader.GetOrdinal("Memo4"));
}
if (DataReaderHelper.IsExistFieldAndNotNull(reader, "Memo5"))
{
entity.Memo5 = reader.GetString(reader.GetOrdinal("Memo5"));
}
if (DataReaderHelper.IsExistFieldAndNotNull(reader, "CreateUserKey"))
{
entity.CreateUserKey = reader.GetString(reader.GetOrdinal("CreateUserKey"));
}
if (DataReaderHelper.IsExistFieldAndNotNull(reader, "CreateUserName"))
{
entity.CreateUserName = reader.GetString(reader.GetOrdinal("CreateUserName"));
}
if (DataReaderHelper.IsExistFieldAndNotNull(reader, "CreateDate"))
{
entity.CreateDate = reader.GetDateTime(reader.GetOrdinal("CreateDate"));
}
if (DataReaderHelper.IsExistFieldAndNotNull(reader, "LastUpdateUserKey"))
{
entity.LastUpdateUserKey = reader.GetString(reader.GetOrdinal("LastUpdateUserKey"));
}
if (DataReaderHelper.IsExistFieldAndNotNull(reader, "LastUpdateUserName"))
{
entity.LastUpdateUserName = reader.GetString(reader.GetOrdinal("LastUpdateUserName"));
}
if (DataReaderHelper.IsExistFieldAndNotNull(reader, "LastUpdateDate"))
{
entity.LastUpdateDate = reader.GetDateTime(reader.GetOrdinal("LastUpdateDate"));
}
if (DataReaderHelper.IsExistFieldAndNotNull(reader, "IsProtectedByOwner"))
{
entity.IsProtectedByOwner = (Logics)reader.GetInt32(reader.GetOrdinal("IsProtectedByOwner"));
}
if (DataReaderHelper.IsExistFieldAndNotNull(reader, "CurrentDispatchType"))
{
entity.CurrentDispatchType = (DispatchTypes)reader.GetInt32(reader.GetOrdinal("CurrentDispatchType"));
}
if (DataReaderHelper.IsExistFieldAndNotNull(reader, "ComeFromType"))
{
entity.ComeFromType = (ComeFromTypes)reader.GetInt32(reader.GetOrdinal("ComeFromType"));
}
if (DataReaderHelper.IsExistFieldAndNotNull(reader, "PropertyNames"))
{
entity.PropertyNames = reader.GetString(reader.GetOrdinal("PropertyNames"));
}
if (DataReaderHelper.IsExistFieldAndNotNull(reader, "PropertyValues"))
{
entity.PropertyValues = reader.GetString(reader.GetOrdinal("PropertyValues"));
}
}
return(entity);
}
/// <summary>
/// 计算某劳务人员各种应付费用（保险，公积金，管理费等）
/// </summary>
/// <param name="isUpdateSalaryTaxDetails">是否同时更新工资税的明细记录</param>
/// <param name="salarySummary"></param>
/// <returns></returns>
private static SalarySummaryEntity CalculateNeedCost(SalarySummaryEntity salarySummary, bool isUpdateSalaryTaxDetails = true)
{
LaborEntity labor = LaborBLL.Instance.Get(salarySummary.LaborKey);
if (GuidHelper.IsInvalidOrEmpty(labor.CurrentLaborContract.EnterpriseInsuranceFormularKey) == false)
{
salarySummary.EnterpriseInsuranceCalculated = CalculateCostDetails(new Guid(labor.CurrentLaborContract.EnterpriseInsuranceFormularKey), salarySummary);
}
if (GuidHelper.IsInvalidOrEmpty(labor.CurrentLaborContract.EnterpriseReserveFundFormularKey) == false)
{
salarySummary.EnterpriseReserveFundCalculated = CalculateCostDetails(new Guid(labor.CurrentLaborContract.EnterpriseReserveFundFormularKey), salarySummary);
}
if (GuidHelper.IsInvalidOrEmpty(labor.CurrentLaborContract.EnterpriseManageFeeFormularKey) == false)
{
salarySummary.EnterpriseManageFeeCalculated = CalculateCostDetails(new Guid(labor.CurrentLaborContract.EnterpriseManageFeeFormularKey), salarySummary);
}
if (GuidHelper.IsInvalidOrEmpty(labor.CurrentLaborContract.EnterpriseOtherCostFormularKey) == false)
{
salarySummary.EnterpriseOtherCostCalculated = CalculateCostDetails(new Guid(labor.CurrentLaborContract.EnterpriseOtherCostFormularKey), salarySummary);
}
if (GuidHelper.IsInvalidOrEmpty(labor.CurrentLaborContract.EnterpriseMixCostFormularKey) == false)
{
salarySummary.EnterpriseMixCostCalculated = CalculateCostDetails(new Guid(labor.CurrentLaborContract.EnterpriseMixCostFormularKey), salarySummary);
}
if (GuidHelper.IsInvalidOrEmpty(labor.CurrentLaborContract.PersonInsuranceFormularKey) == false)
{
salarySummary.PersonInsuranceCalculated = CalculateCostDetails(new Guid(labor.CurrentLaborContract.PersonInsuranceFormularKey), salarySummary);
}
if (GuidHelper.IsInvalidOrEmpty(labor.CurrentLaborContract.PersonReserveFundFormularKey) == false)
{
salarySummary.PersonReserveFundCalculated = CalculateCostDetails(new Guid(labor.CurrentLaborContract.PersonReserveFundFormularKey), salarySummary);
}
if (GuidHelper.IsInvalidOrEmpty(labor.CurrentLaborContract.PersonManageFeeFormularKey) == false)
{
salarySummary.PersonManageFeeCalculated = CalculateCostDetails(new Guid(labor.CurrentLaborContract.PersonManageFeeFormularKey), salarySummary);
}
if (GuidHelper.IsInvalidOrEmpty(labor.CurrentLaborContract.PersonOtherCostFormularKey) == false)
{
salarySummary.PersonOtherCostCalculated = CalculateCostDetails(new Guid(labor.CurrentLaborContract.PersonOtherCostFormularKey), salarySummary);
}
if (GuidHelper.IsInvalidOrEmpty(labor.CurrentLaborContract.PersonMixCostFormularKey) == false)
{
salarySummary.PersonMixCostCalculated = CalculateCostDetails(new Guid(labor.CurrentLaborContract.PersonMixCostFormularKey), salarySummary);
}
if (GuidHelper.IsInvalidOrEmpty(labor.CurrentLaborContract.EnterpriseOtherInsuranceFormularKey) == false)
{
salarySummary.EnterpriseOtherInsuranceCalculated = CalculateCostDetails(new Guid(labor.CurrentLaborContract.EnterpriseOtherInsuranceFormularKey), salarySummary);
}
if (GuidHelper.IsInvalidOrEmpty(labor.CurrentLaborContract.EnterpriseTaxFeeFormularKey) == false)
{
salarySummary.EnterpriseTaxFeeCalculated = CalculateCostDetails(new Guid(labor.CurrentLaborContract.EnterpriseTaxFeeFormularKey), salarySummary);
}
if (isUpdateSalaryTaxDetails == true)
{
SalaryDetailsBLL.Instance.CreateOrUpdateSalaryTax(salarySummary.SalarySummaryGuid, salarySummary.SalaryTax);
}
return(salarySummary);
}
public override bool Update(LaborEntity entity)
{
entity.LastUpdateDate = DateTime.Now;
entity.LastUpdateUserKey = BusinessUserBLL.CurrentUserGuid.ToString();
entity.LastUpdateUserName = BusinessUserBLL.CurrentUser.UserNameDisplay;
string commandText = string.Format(@"Update [XQYCLabor] Set
[UserGuid] = {0}UserGuid,
[LaborCode]={0}LaborCode,
[NativePlace] = {0}NativePlace,
[CurrentPlace] = {0}CurrentPlace,
[IDCardPlace] = {0}IDCardPlace,
[HouseHoldType] = {0}HouseHoldType,
[WorkSkill] = {0}WorkSkill,
[WorkSkillPaper] = {0}WorkSkillPaper,
[WorkSituation] = {0}WorkSituation,
[PreWorkSituation] = {0}PreWorkSituation,
[HopeWorkSituation] = {0}HopeWorkSituation,
[HopeWorkSalary] = {0}HopeWorkSalary,
[UrgentLinkMan] = {0}UrgentLinkMan,
[UrgentTelephone] = {0}UrgentTelephone,
[UrgentRelationship] = {0}UrgentRelationship,
[InformationComeFrom] = {0}InformationComeFrom,
[ProviderUserGuid] = {0}ProviderUserGuid,
[ProviderUserName] = {0}ProviderUserName,
[RecommendUserGuid] = {0}RecommendUserGuid,
[RecommendUserName] = {0}RecommendUserName,
[ServiceUserGuid] = {0}ServiceUserGuid,
[ServiceUserName] = {0}ServiceUserName,
[FinanceUserGuid] = {0}FinanceUserGuid,
[FinanceUserName] = {0}FinanceUserName,
[BusinessUserGuid] = {0}BusinessUserGuid,
[BusinessUserName] = {0}BusinessUserName,
[SettleUserGuid] = {0}SettleUserGuid,
[SettleUserName] = {0}SettleUserName,
[InformationBrokerUserGuid] = {0}InformationBrokerUserGuid,
[InformationBrokerUserName] = {0}InformationBrokerUserName,
[InsureType] = {0}InsureType,
[LaborWorkStatus] = {0}LaborWorkStatus,
[CurrentLaborDepartment] = {0}CurrentLaborDepartment,
[CurrentLaborWorkShop] = {0}CurrentLaborWorkShop,
[CurrentContractStartDate] = {0}CurrentContractStartDate,
[CurrentContractStopDate] = {0}CurrentContractStopDate,
[CurrentContractDesc] = {0}CurrentContractDesc,
[CurrentContractDiscontinueDate] = {0}CurrentContractDiscontinueDate,
[CurrentContractDiscontinueDesc] = {0}CurrentContractDiscontinueDesc,
[CurrentEnterpriseKey] = {0}CurrentEnterpriseKey,
[CurrentEnterpriseName]= {0}CurrentEnterpriseName,
[CurrentContractKey] = {0}CurrentContractKey,
[Memo1] = {0}Memo1,
[Memo2] = {0}Memo2,
[Memo3] = {0}Memo3,
[Memo4] = {0}Memo4,
[Memo5] = {0}Memo5,
[CreateUserKey] = {0}CreateUserKey,
[CreateUserName] = {0}CreateUserName,
[CreateDate] = {0}CreateDate,
[LastUpdateUserKey] = {0}LastUpdateUserKey,
[LastUpdateUserName] = {0}LastUpdateUserName,
[LastUpdateDate] = {0}LastUpdateDate,
[IsProtectedByOwner] = {0}IsProtectedByOwner,
[CurrentDispatchType] = {0}CurrentDispatchType,
[ComeFromType] = {0}ComeFromType,
[PropertyNames] = {0}PropertyNames,
[PropertyValues] = {0}PropertyValues
Where [LaborID] = {0}LaborID", ParameterNamePrefix);
TParameter[] sqlParas = PrepareParasAll(entity);
bool isSuccessful = HelperExInstance.ExecuteSingleRowNonQuery(commandText, sqlParas);
return(isSuccessful);
}
