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