public int AddLocalSocialSecurity(InsuranceAdd2ViewModel model) { SocialSecurity socialSecurity = new SocialSecurity(); SocialSecurityPeople people = (SocialSecurityPeople)Session["SocialSecurityPeople"]; socialSecurity.SocialSecurityPeopleID = people.SocialSecurityPeopleID; //socialSecurity.SocialSecurityPeopleID = 49; //socialSecurity.InsuranceArea = string.Format("{0}|{1}",Request["provinceText"], Request["city"]); socialSecurity.InsuranceArea = "山东省|青岛市|崂山区"; socialSecurity.HouseholdProperty = people.HouseholdProperty; //socialSecurity.HouseholdProperty = "本市城镇"; socialSecurity.SocialSecurityBase = model.SocialSecurityBase; socialSecurity.PayProportion = 0; socialSecurity.PayTime = model.PayTime; socialSecurity.PayMonthCount = model.PayMonthCount; socialSecurity.PayBeforeMonthCount = model.PayBeforeMonthCount; socialSecurity.BankPayMonth = model.BankPayMonth; socialSecurity.EnterprisePayMonth = model.EnterprisePayMonth; socialSecurity.Note = model.Note; socialSecurity.RelationEnterprise = 0; //保存数据到数据库 int id = socialSv.AddSocialSecurity(socialSecurity); return(id); }
public JsonResult <SocialSecurityPeople> GetSocialSecurityScheme(int SocialSecurityPeopleID) { SocialSecurityPeople model = new SocialSecurityPeople(); //获取参保人信息 string sql = $"select * from SocialSecurityPeople where SocialSecurityPeopleID={SocialSecurityPeopleID}"; model = DbHelper.QuerySingle <SocialSecurityPeople>(sql); model.IdentityCardPhoto = ConfigurationManager.AppSettings["ServerUrl"] + model.IdentityCardPhoto.Replace(";", ";" + ConfigurationManager.AppSettings["ServerUrl"]); //获取社保信息 if (model.IsPaySocialSecurity) { model.socialSecurity = _socialSecurityService.GetSocialSecurityDetail(SocialSecurityPeopleID); } //获取公积金信息 if (model.IsPayAccumulationFund) { model.accumulationFund = _accumulationFundService.GetAccumulationFundDetail(SocialSecurityPeopleID); } return(new JsonResult <SocialSecurityPeople> { status = true, Message = "获取成功", Data = model }); }
public ActionResult Add1(InsuranceAdd1ViewModel model) { if (ModelState.IsValid) { SocialSecurityPeople socialPeople = new SocialSecurityPeople(); socialPeople.MemberID = CommonHelper.CurrentUser.MemberID; socialPeople.IdentityCard = model.IdentityCard; socialPeople.SocialSecurityPeopleName = model.SocialSecurityPeopleName; socialPeople.IdentityCardPhoto = model.IdentityCardPhoto.Substring(1); socialPeople.HouseholdProperty = EnumExt.GetEnumCustomDescription((HouseholdPropertyEnum)int.Parse(model.HouseholdProperty)); //保持参保人到数据库,返回参保人ID int id = localSocialSv.AddSocialSecurityPeople(socialPeople); if (id > 0) { socialPeople.SocialSecurityPeopleID = id; //把参保人保存到session中 Session["SocialSecurityPeople"] = socialPeople; return(RedirectToAction("Add2")); } else { bulidHouseholdPropertyDropdown(model.HouseholdProperty); return(View(model)); } } else { bulidHouseholdPropertyDropdown(model.HouseholdProperty); return(View(model)); } }
/// <summary> /// 参保人添加 /// </summary> /// <param name="socialSecurityPeople"></param> /// <returns></returns> public int AddSocialSecurityPeople(SocialSecurityPeople socialSecurityPeople) { DbParameter[] parameters = new DbParameter[] { new SqlParameter("@Flag", SqlDbType.Bit) { Direction = ParameterDirection.Output }, //参保人 new SqlParameter("@MemberID", SqlDbType.Int) { Value = socialSecurityPeople.MemberID }, new SqlParameter("@SocialSecurityPeopleName", SqlDbType.NVarChar, 50) { Value = socialSecurityPeople.SocialSecurityPeopleName }, new SqlParameter("@IdentityCard", SqlDbType.NVarChar, 50) { Value = socialSecurityPeople.IdentityCard }, new SqlParameter("@IdentityCardPhoto", SqlDbType.NVarChar, 512) { Value = socialSecurityPeople.IdentityCardPhoto }, new SqlParameter("@HouseholdProperty", SqlDbType.NVarChar, 512) { Value = socialSecurityPeople.HouseholdProperty }, }; string sql = @"insert into SocialSecurityPeople ( MemberID, SocialSecurityPeopleName, IdentityCard, IdentityCardPhoto, HouseholdProperty, IsPaySocialSecurity, IsPayAccumulationFund ) values ( @MemberID, @SocialSecurityPeopleName, @IdentityCard, @IdentityCardPhoto, @HouseholdProperty, 0, 0 )" ; int id = DbHelper.ExecuteSqlCommandScalar(sql, parameters); return(id); }
public async Task <JsonResult <dynamic> > ModifySocialSecurityPeople(SocialSecurityPeople socialSecurityPeople) { //只修改参保人主页面 if (socialSecurityPeople.socialSecurity == null && socialSecurityPeople.accumulationFund == null) { string sql = $"update SocialSecurityPeople set SocialSecurityPeopleName='{socialSecurityPeople.SocialSecurityPeopleName}',IdentityCard='{socialSecurityPeople.IdentityCard}',IdentityCardPhoto='{socialSecurityPeople.IdentityCardPhoto}',HouseholdProperty='{socialSecurityPeople.HouseholdProperty}' where SocialSecurityPeopleID={socialSecurityPeople.SocialSecurityPeopleID}"; bool flag1 = DbHelper.ExecuteSqlCommand(sql, null) > 0; return(new JsonResult <dynamic> { status = flag1, Message = flag1 ? "修改成功" : "修改失败" }); } if (socialSecurityPeople.socialSecurity.SocialSecurityID == 0 && socialSecurityPeople.accumulationFund.AccumulationFundID == 0) { return new JsonResult <dynamic> { status = false, Message = "必须选择参保方案" } } ; ////验证身份证 //if (!Regex.IsMatch(socialSecurityPeople.IdentityCard, @"(^\d{18}$)|(^\d{15}$)")) // return new JsonResult<dynamic> // { // status = false, // Message = "身份证号填写错误" // }; ////判断身份证是否已存在 应排除该条对应的 --todo //if (_socialSecurityService.IsExistsSocialSecurityPeopleIdentityCard(socialSecurityPeople.IdentityCard, socialSecurityPeople.SocialSecurityPeopleID)) // return new JsonResult<dynamic> // { // status = false, // Message = "身份证已存在" // }; bool flag = await _socialSecurityService.ModifySocialSecurityPeople(socialSecurityPeople); return(new JsonResult <dynamic> { status = flag, Message = flag ? "修改成功" : "修改失败" }); }
/// <summary> /// 根据参保人ID获取详情 /// </summary> /// <param name="SocialSecurityPeopleID"></param> /// <param name="MemberID"></param> /// <returns></returns> public ActionResult GetSocialSecurityPeopleDetail(int SocialSecurityPeopleID, int MemberID, int Type) { SocialSecurityPeople socialSecurityPeople = _socialSecurityService.GetSocialSecurityPeopleForAdmin(SocialSecurityPeopleID); if (socialSecurityPeople.IsPaySocialSecurity) { socialSecurityPeople.socialSecurity = _socialSecurityService.GetSocialSecurityDetail(SocialSecurityPeopleID); //企业签约单位列表 List <EnterpriseSocialSecurity> SSList = _socialSecurityService.GetEnterpriseSocialSecurityByAreaList(socialSecurityPeople.socialSecurity.InsuranceArea, socialSecurityPeople.HouseholdProperty); EnterpriseSocialSecurity SS = _socialSecurityService.GetDefaultEnterpriseSocialSecurityByArea(socialSecurityPeople.socialSecurity.InsuranceArea, socialSecurityPeople.HouseholdProperty); ViewData["SSEnterpriseList"] = new SelectList(SSList, "EnterpriseID", "EnterpriseName", socialSecurityPeople.socialSecurity.RelationEnterprise); ViewData["SSMaxBase"] = Math.Round(SS.SocialAvgSalary * SS.MaxSocial / 100); ViewData["SSMinBase"] = Math.Round(SS.SocialAvgSalary * SS.MinSocial / 100); } if (socialSecurityPeople.IsPayAccumulationFund) { socialSecurityPeople.accumulationFund = _accumulationFundService.GetAccumulationFundDetail(SocialSecurityPeopleID); //企业签约单位列表 List <EnterpriseSocialSecurity> AFList = _socialSecurityService.GetEnterpriseSocialSecurityByAreaList(socialSecurityPeople.accumulationFund.AccumulationFundArea, socialSecurityPeople.HouseholdProperty); EnterpriseSocialSecurity AF = _socialSecurityService.GetDefaultEnterpriseSocialSecurityByArea(socialSecurityPeople.accumulationFund.AccumulationFundArea, socialSecurityPeople.HouseholdProperty); ViewData["AFEnterpriseList"] = new SelectList(AFList, "EnterpriseID", "EnterpriseName", socialSecurityPeople.accumulationFund.RelationEnterprise); ViewData["AFMaxBase"] = AF.MaxAccumulationFund; ViewData["AFMinBase"] = AF.MinAccumulationFund; } //获取会员信息 ViewData["member"] = _memberService.GetMemberInfoForAdmin(MemberID); //获取账户列表 ViewData["accountRecordList"] = _memberService.GetAccountRecordList(MemberID).OrderByDescending(n => n.CreateTime).ToList(); #region 户口性质 List <SelectListItem> list = EnumExt.GetSelectList(typeof(HouseholdPropertyEnum)); int householdType = 0; foreach (var item in list) { if (item.Text == socialSecurityPeople.HouseholdProperty) { householdType = Convert.ToInt32(item.Value); break; } } ViewData["HouseholdProperty"] = new SelectList(list, "value", "text", householdType); #endregion return(View(socialSecurityPeople)); }
public ActionResult TestDapper(SocialSecurityPeople model) { string sql = "select Users.UserID, Users.UserName , Roles.RoleID, Roles.RoleName from Users left join UserRole on Users.UserID = UserRole.UserID left join Roles on UserRole.RoleID = Roles.RoleID"; List <Users> list = DbHelper.CustomQuery <Users, Entity.Roles, Users>(sql, (user, role) => { user.roles = role; return(user); }, "RoleID").ToList(); //string sql = "update Test set name=1 where name='1';update Test set name=2 where name='王五'"; //int result = DbHelper.ExecuteSqlCommand(sql, null); return(View()); }
public async Task <JsonResult <dynamic> > AddSocialSecurityPeople(SocialSecurityPeople socialSecurityPeople) { if (socialSecurityPeople.socialSecurity.SocialSecurityID == 0 && socialSecurityPeople.accumulationFund.AccumulationFundID == 0) { return new JsonResult <dynamic> { status = false, Message = "必须选择参保方案" } } ; //验证身份证 if (!Regex.IsMatch(socialSecurityPeople.IdentityCard, @"(^\d{18}$)|(^\d{15}$)")) { return new JsonResult <dynamic> { status = false, Message = "身份证号填写错误" } } ; //判断身份证是否已存在 if (_socialSecurityService.IsExistsSocialSecurityPeopleIdentityCard(socialSecurityPeople.IdentityCard)) { return new JsonResult <dynamic> { status = false, Message = "身份证已存在" } } ; bool flag = await _socialSecurityService.AddSocialSecurityPeople(socialSecurityPeople); return(new JsonResult <dynamic> { status = flag, Message = flag ? "添加成功" : "添加失败" }); }
public ActionResult Add2(InsuranceAdd2ViewModel model) { if (ModelState.IsValid) { //保存数据到数据库 int id = AddLocalSocialSecurity(model); if (id > 0) { SocialSecurityPeople people = (SocialSecurityPeople)Session["SocialSecurityPeople"]; //跳转到确认页面 return(Redirect("/UserOrder/Create/" + people.SocialSecurityPeopleID)); } else { return(RedirectToAction("Add2")); } } else { return(RedirectToAction("Add2")); } }
public ActionResult Confirm(InsuranceAdd3ViewModel model) { if (ModelState.IsValid) { SocialSecurityPeople people = (SocialSecurityPeople)Session["SocialSecurityPeople"]; AccumulationFund accumulationFund = new AccumulationFund(); accumulationFund.SocialSecurityPeopleID = people.SocialSecurityPeopleID; //accumulationFund.SocialSecurityPeopleID = 49; //accumulationFund.AccumulationFundArea = string.Format("{0}|{1}", Request["provinceText"], Request["city"]); accumulationFund.AccumulationFundArea = "山东省|青岛市|崂山区"; accumulationFund.AccumulationFundBase = model.AccumulationFundBase; accumulationFund.PayProportion = 0; accumulationFund.PayTime = model.PayTime; accumulationFund.PayMonthCount = model.PayMonthCount; accumulationFund.PayBeforeMonthCount = model.PayBeforeMonthCount; accumulationFund.Note = model.Note; accumulationFund.RelationEnterprise = 0; int id = socialSv.AddAccumulationFund(accumulationFund); if (id > 0) { //跳转到确认页面 return(Redirect("/UserOrder/Create/" + people.SocialSecurityPeopleID)); } else { return(RedirectToAction("Add3")); } } else { return(RedirectToAction("Add3")); } }
public ActionResult SaveEnterprise(SocialSecurityPeopleDetail model) { SocialSecurityPeople socialSecurityPeople = new SocialSecurityPeople(); socialSecurityPeople.IdentityCard = model.IdentityCard; #region 户籍性质 List <SelectListItem> list = EnumExt.GetSelectList(typeof(HouseholdPropertyEnum)); foreach (var item in list) { if (item.Value == model.HouseholdProperty) { socialSecurityPeople.HouseholdProperty = item.Text; break; } } #endregion using (TransactionScope transaction = new TransactionScope()) { try { #region 更新参保人 socialSecurityPeople.IdentityCardPhoto = string.Join(";", model.ImgUrls).Replace(ConfigurationManager.AppSettings["ServerUrl"], string.Empty); DbHelper.ExecuteSqlCommand($"update SocialSecurityPeople set IdentityCard='{socialSecurityPeople.IdentityCard}',HouseholdProperty='{socialSecurityPeople.HouseholdProperty}',IdentityCardPhoto='{socialSecurityPeople.IdentityCardPhoto}' where SocialSecurityPeopleID={model.SocialSecurityPeopleID}", null); #endregion #region 更新用户 string inviteCode = string.Empty; if (!string.IsNullOrEmpty(model.InviteCode)) { inviteCode = _userService.GetUserInfoByUserID(model.InviteCode).InviteCode; } DbHelper.ExecuteSqlCommand($"update Members set InviteCode='{inviteCode}' where MemberID={model.MemberID}", null); #endregion if (model.IsPaySocialSecurity) { #region 更新社保 DbHelper.ExecuteSqlCommand($"update SocialSecurity set SocialSecurityNo='{model.SocialSecurityNo}',SocialSecurityBase='{model.SocialSecurityBase}',RelationEnterprise='{model.SSEnterpriseList}',PayProportion='{model.ssPayProportion.TrimEnd('%')}' where SocialSecurityPeopleID={model.SocialSecurityPeopleID}", null); #endregion } if (model.IsPayAccumulationFund) { #region 更新公积金 DbHelper.ExecuteSqlCommand($"update AccumulationFund set AccumulationFundNo='{model.AccumulationFundNo}',AccumulationFundBase='{model.AccumulationFundBase}',RelationEnterprise='{model.AFEnterpriseList}',PayProportion='{model.afPayProportion.TrimEnd('%')}' where SocialSecurityPeopleID={model.SocialSecurityPeopleID}", null); #endregion } transaction.Complete(); } catch (Exception ex) { TempData["Message"] = "更新失败"; return(RedirectToAction("GetCustomerServiceList")); } finally { transaction.Dispose(); } } TempData["Message"] = "更新成功"; return(RedirectToAction("GetCustomerServiceList")); }
public ActionResult BatchAuditing(string[] OrderCodes, int Type) { using (TransactionScope transaction = new TransactionScope()) { try { string OrderCodeStr = string.Join("','", OrderCodes); //修改订单状态 bool flag1 = orderService.ModifyOrderStatus(OrderCodeStr); //修改订单对应的参保人的社保和公积金状态 SocialSecurityStatusEnum.WaitingHandle //首先需要判断参保人是否已经通过客服审核 foreach (var orderCode in OrderCodes) { string sqlstr = $"select SocialSecurityPeopleID from OrderDetails where OrderCode ='{orderCode}'"; List <OrderDetails> orderDetailList = DbHelper.Query <OrderDetails>(sqlstr); foreach (var orderDetail in orderDetailList) { string sqlStr1 = $"select * from SocialSecurityPeople where SocialSecurityPeopleID ={orderDetail.SocialSecurityPeopleID}"; SocialSecurityPeople socialSecurityPeople = DbHelper.QuerySingle <SocialSecurityPeople>(sqlStr1); //是否通过客服审核,若通过,则修改社保和公积金状态 if (Convert.ToInt32(socialSecurityPeople.Status) == (int)CustomerServiceAuditEnum.Pass) { string sqlStr2 = $"update SocialSecurity set Status = {(int)SocialSecurityStatusEnum.WaitingHandle} where SocialSecurityPeopleID ={socialSecurityPeople.SocialSecurityPeopleID};update AccumulationFund set Status = {(int)SocialSecurityStatusEnum.WaitingHandle} where SocialSecurityPeopleID ={socialSecurityPeople.SocialSecurityPeopleID};"; DbHelper.ExecuteSqlCommand(sqlStr2, null); } } LogService.WriteLogInfo(new Log { UserName = HttpContext.User.Identity.Name, Contents = string.Format("审核通过了订单:{0}", orderCode) }); } transaction.Complete(); } catch (Exception ex) { if (Type == 0) { return(Json(new { status = false, message = "审核不通过" }, JsonRequestBehavior.AllowGet)); } else { TempData["Message"] = "审核不通过"; return(RedirectToAction("GetOrderList")); } } finally { transaction.Dispose(); } } if (Type == 0) { return(Json(new { status = true, message = "审核通过" }, JsonRequestBehavior.AllowGet)); } else { TempData["Message"] = "审核通过"; return(RedirectToAction("GetOrderList")); } }
/// <summary> /// 添加社保方案 返回社保ID:SocialSecurityID,公积金ID:AccumulationFundID,总金额:Amount /// </summary> /// <param name="socialSecurityPeople"></param> /// <returns></returns> public JsonResult <dynamic> AddSocialSecurityScheme(SocialSecurityPeople socialSecurityPeople) { int SocialSecurityID = 0; decimal SocialSecurityAmount = 0; int SocialSecurityMonthCount = 0; decimal SocialSecurityBacklogCost = 0; int AccumulationFundID = 0; decimal AccumulationFundAmount = 0; int AccumulationFundMonthCount = 0; decimal AccumulationFundBacklogCost = 0; using (TransactionScope transaction = new TransactionScope()) { try { //保存社保参保方案 if (socialSecurityPeople.socialSecurity != null) { //if (socialSecurityPeople.socialSecurity.PayTime.Day > 14) // socialSecurityPeople.socialSecurity.PayTime.AddMonths(1); //返回社保ID SocialSecurityID = _socialSecurityService.AddSocialSecurity(socialSecurityPeople.socialSecurity); //查询社保金额 SocialSecurityAmount = _socialSecurityService.GetSocialSecurityAmount(SocialSecurityID); //查询社保月数 SocialSecurityMonthCount = _socialSecurityService.GetSocialSecurityMonthCount(SocialSecurityID); SocialSecurityBacklogCost = _parameterSettingService.GetCostParameter((int)PayTypeEnum.SocialSecurity).BacklogCost; } //保存公积金参保方案 if (socialSecurityPeople.accumulationFund != null) { //if (socialSecurityPeople.accumulationFund.PayTime.Day > 14) // socialSecurityPeople.accumulationFund.PayTime.AddMonths(1); //返回公积金ID AccumulationFundID = _socialSecurityService.AddAccumulationFund(socialSecurityPeople.accumulationFund); //查询公积金金额 AccumulationFundAmount = _socialSecurityService.GetAccumulationFundAmount(AccumulationFundID); //查询公积金月数 AccumulationFundMonthCount = _socialSecurityService.GetAccumulationFundMonthCount(AccumulationFundID); AccumulationFundBacklogCost = _parameterSettingService.GetCostParameter((int)PayTypeEnum.AccumulationFund).BacklogCost; } transaction.Complete(); } catch (Exception ex) { return(new JsonResult <dynamic> { status = false, Message = "添加社保方案失败" }); } finally { transaction.Dispose(); } } return(new JsonResult <dynamic> { status = true, Message = "添加社保方案成功", Data = new { SocialSecurityID = SocialSecurityID, AccumulationFundID = AccumulationFundID, Amount = SocialSecurityAmount * SocialSecurityMonthCount + AccumulationFundAmount * AccumulationFundMonthCount + SocialSecurityBacklogCost + AccumulationFundBacklogCost } }); }
/// <summary> /// 更新参保方案 socialSecurityPeople下的SocialSecurityPeopleID也需要传 /// </summary> /// <param name="socialSecurityPeople"></param> /// <returns></returns> public JsonResult <dynamic> ModifySocialSecurityScheme(SocialSecurityPeople socialSecurityPeople) { int SocialSecurityID = 0; decimal SocialSecurityAmount = 0; int SocialSecurityMonthCount = 0; decimal SocialSecurityBacklogCost = 0; int AccumulationFundID = 0; decimal AccumulationFundAmount = 0; int AccumulationFundMonthCount = 0; decimal AccumulationFundBacklogCost = 0; using (TransactionScope transaction = new TransactionScope()) { try { //删除该参保人下的参保方案 string sqlDel = $"delete from SocialSecurity where SocialSecurityPeopleID={socialSecurityPeople.SocialSecurityPeopleID};" + $" delete from AccumulationFund where SocialSecurityPeopleID ={socialSecurityPeople.SocialSecurityPeopleID};"; DbHelper.ExecuteSqlCommand(sqlDel, null); //保存社保参保方案 if (socialSecurityPeople.socialSecurity != null) { socialSecurityPeople.socialSecurity.SocialSecurityPeopleID = socialSecurityPeople.SocialSecurityPeopleID; //if (socialSecurityPeople.socialSecurity.PayTime.Day > 14) // socialSecurityPeople.socialSecurity.PayTime.AddMonths(1); SocialSecurityID = _socialSecurityService.AddSocialSecurity(socialSecurityPeople.socialSecurity); //查询社保金额 SocialSecurityAmount = _socialSecurityService.GetSocialSecurityAmount(SocialSecurityID); //查询社保月数 SocialSecurityMonthCount = _socialSecurityService.GetSocialSecurityMonthCount(SocialSecurityID); SocialSecurityBacklogCost = _parameterSettingService.GetCostParameter((int)PayTypeEnum.SocialSecurity).BacklogCost; } //保存公积金参保方案 if (socialSecurityPeople.accumulationFund != null) { socialSecurityPeople.accumulationFund.SocialSecurityPeopleID = socialSecurityPeople.SocialSecurityPeopleID; //if (socialSecurityPeople.accumulationFund.PayTime.Day > 14) // socialSecurityPeople.accumulationFund.PayTime.AddMonths(1); AccumulationFundID = _socialSecurityService.AddAccumulationFund(socialSecurityPeople.accumulationFund); //查询公积金金额 AccumulationFundAmount = _socialSecurityService.GetAccumulationFundAmount(AccumulationFundID); //查询公积金月数 AccumulationFundMonthCount = _socialSecurityService.GetAccumulationFundMonthCount(AccumulationFundID); AccumulationFundBacklogCost = _parameterSettingService.GetCostParameter((int)PayTypeEnum.AccumulationFund).BacklogCost; } transaction.Complete(); } catch (Exception ex) { return(new JsonResult <dynamic> { status = false, Message = "更新社保方案失败" }); } finally { transaction.Dispose(); } } return(new JsonResult <dynamic> { status = true, Message = "更新社保方案成功", Data = new { SocialSecurityID = SocialSecurityID, AccumulationFundID = AccumulationFundID, Amount = SocialSecurityAmount * SocialSecurityMonthCount + AccumulationFundAmount * AccumulationFundMonthCount + SocialSecurityBacklogCost + AccumulationFundBacklogCost } }); }
public JsonResult <dynamic> ConfirmSocialSecurityScheme(SocialSecurityPeople socialSecurityPeople) { //社保 bool IsExistSocialSecurityCase = false; DateTime socialSecurityStartTime = DateTime.MinValue; DateTime socialSecurityEndTime = DateTime.MinValue; int socialSecuritypayMonth = 0; decimal socialSecurityFirstBacklogCost = 0; decimal SocialSecurityBase = 0; decimal FreezingCharge = 0; decimal SocialSecurityAmount = 0; if (socialSecurityPeople.socialSecurity != null) { IsExistSocialSecurityCase = true; socialSecurityStartTime = socialSecurityPeople.socialSecurity.PayTime; socialSecurityEndTime = socialSecurityPeople.socialSecurity.PayTime.AddMonths(socialSecurityPeople.socialSecurity.PayMonthCount - 1); socialSecuritypayMonth = socialSecurityPeople.socialSecurity.PayMonthCount; socialSecurityFirstBacklogCost = _parameterSettingService.GetCostParameter((int)PayTypeEnum.SocialSecurity).BacklogCost; SocialSecurityBase = socialSecurityPeople.socialSecurity.SocialSecurityBase; FreezingCharge = 0; EnterpriseSocialSecurity enterpriseSocialSecurity = _socialSecurityService.GetDefaultEnterpriseSocialSecurityByArea(socialSecurityPeople.socialSecurity.InsuranceArea, socialSecurityPeople.HouseholdProperty); if (enterpriseSocialSecurity == null) { return new JsonResult <dynamic> { status = false, Message = "该区域不能进行缴费操作,请选择其他区域" } } ; decimal value = 0; //model.PersonalShiYeTown if (socialSecurityPeople.HouseholdProperty == EnumExt.GetEnumCustomDescription((HouseholdPropertyEnum)((int)HouseholdPropertyEnum.InRural)) || socialSecurityPeople.HouseholdProperty == EnumExt.GetEnumCustomDescription((HouseholdPropertyEnum)((int)HouseholdPropertyEnum.OutRural))) { value = enterpriseSocialSecurity.PersonalShiYeRural; } else if (socialSecurityPeople.HouseholdProperty == EnumExt.GetEnumCustomDescription((HouseholdPropertyEnum)((int)HouseholdPropertyEnum.InTown)) || socialSecurityPeople.HouseholdProperty == EnumExt.GetEnumCustomDescription((HouseholdPropertyEnum)((int)HouseholdPropertyEnum.OutTown))) { value = enterpriseSocialSecurity.PersonalShiYeTown; } decimal PayProportion = enterpriseSocialSecurity.CompYangLao + enterpriseSocialSecurity.CompYiLiao + enterpriseSocialSecurity.CompShiYe + enterpriseSocialSecurity.CompGongShang + enterpriseSocialSecurity.CompShengYu + enterpriseSocialSecurity.PersonalYangLao + enterpriseSocialSecurity.PersonalYiLiao + value + enterpriseSocialSecurity.PersonalGongShang + enterpriseSocialSecurity.PersonalShengYu; SocialSecurityAmount = PayProportion * socialSecurityPeople.socialSecurity.SocialSecurityBase / 100; } //公积金 bool IsExistaAccumulationFundCase = false; DateTime AccumulationFundStartTime = DateTime.MinValue; DateTime AccumulationFundEndTime = DateTime.MinValue; int AccumulationFundpayMonth = 0; decimal AccumulationFundFirstBacklogCost = 0; decimal AccumulationFundBase = 0; decimal AccumulationFundAmount = 0; if (socialSecurityPeople.accumulationFund != null) { IsExistaAccumulationFundCase = true; AccumulationFundStartTime = socialSecurityPeople.accumulationFund.PayTime; AccumulationFundEndTime = socialSecurityPeople.accumulationFund.PayTime.AddMonths(socialSecurityPeople.accumulationFund.PayMonthCount - 1); AccumulationFundpayMonth = socialSecurityPeople.accumulationFund.PayMonthCount; AccumulationFundFirstBacklogCost = _parameterSettingService.GetCostParameter((int)PayTypeEnum.AccumulationFund).BacklogCost; AccumulationFundBase = socialSecurityPeople.accumulationFund.AccumulationFundBase; EnterpriseSocialSecurity enterpriseSocialSecurity2 = _socialSecurityService.GetDefaultEnterpriseSocialSecurityByArea(socialSecurityPeople.accumulationFund.AccumulationFundArea, socialSecurityPeople.HouseholdProperty); if (enterpriseSocialSecurity2 == null) { return new JsonResult <dynamic> { status = false, Message = "该区域不能进行缴费操作,请选择其他区域" } } ; decimal PayProportion2 = enterpriseSocialSecurity2.CompProportion + enterpriseSocialSecurity2.PersonalProportion; AccumulationFundAmount = PayProportion2 * socialSecurityPeople.accumulationFund.AccumulationFundBase / 100; } return(new JsonResult <dynamic> { status = true, Message = "获取成功", Data = new { IsExistSocialSecurityCase = IsExistSocialSecurityCase, socialSecurityStartTime = socialSecurityStartTime.ToString("yyyy-MM"), socialSecurityEndTime = socialSecurityEndTime.ToString("yyyy-MM"), socialSecuritypayMonth = socialSecuritypayMonth, socialSecurityFirstBacklogCost = socialSecurityFirstBacklogCost, SocialSecurityBase = SocialSecurityBase, FreezingCharge = FreezingCharge, SocialSecurityAmount = SocialSecurityAmount, IsExistaAccumulationFundCase = IsExistaAccumulationFundCase, AccumulationFundStartTime = AccumulationFundStartTime.ToString("yyyy-MM"), AccumulationFundEndTime = AccumulationFundEndTime.ToString("yyyy-MM"), AccumulationFundpayMonth = AccumulationFundpayMonth, AccumulationFundFirstBacklogCost = AccumulationFundFirstBacklogCost, AccumulationFundBase = AccumulationFundBase, AccumulationFundAmount = AccumulationFundAmount } }); }
public ActionResult TestDapper() { SocialSecurityPeople model = new SocialSecurityPeople(); return(View(model)); }