public JsonResult <SocialSecurityPeopleDetail> GetSocialSecurityPeopleDetail(int SocialSecurityPeopleID)
{
decimal SocialSecurityAmount = 0;
decimal SocialSecurityBacklogCost = 0;
decimal AccumulationFundAmount = 0;
decimal AccumulationFundBacklogCost = 0;
SocialSecurityPeopleDetail model = _socialSecurityService.GetSocialSecurityPeopleDetail(SocialSecurityPeopleID);
if (model.IsPaySocialSecurity)
{
string sql = $"select SocialSecurityBase * PayProportion/100*PayMonthCount from SocialSecurity where SocialSecurityPeopleID = {model.SocialSecurityPeopleID}";
SocialSecurityAmount = DbHelper.QuerySingle <decimal>(sql);
SocialSecurityBacklogCost = _parameterSettingService.GetCostParameter((int)PayTypeEnum.SocialSecurity).BacklogCost;
}
if (model.IsPayAccumulationFund)
{
string sql = $"select AccumulationFundBase * PayProportion/100*PayMonthCount from AccumulationFund where SocialSecurityPeopleID = {model.SocialSecurityPeopleID}";
AccumulationFundAmount = DbHelper.QuerySingle <decimal>(sql);
AccumulationFundBacklogCost = _parameterSettingService.GetCostParameter((int)PayTypeEnum.AccumulationFund).BacklogCost;
}
model.Amount = SocialSecurityAmount + AccumulationFundAmount + SocialSecurityBacklogCost + AccumulationFundBacklogCost;
model.IdentityCardPhoto = ConfigurationManager.AppSettings["ServerUrl"] + model.IdentityCardPhoto.Replace(";", ";" + ConfigurationManager.AppSettings["ServerUrl"]);
return(new JsonResult <SocialSecurityPeopleDetail>
{
status = true,
Message = "获取成功",
Data = model
});
}
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"));
}
