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); }