public ActionResult ChangeFund(AccumulationFund af)
{
SocialSecurityViewModel socialSecurity = localSocialSv.GetAccumulationFundDetail(af.SocialSecurityPeopleID);
Dictionary <string, decimal> dict = socialSecurity.SocialAccumulationDict;
decimal minBase = dict["AFMinBase"];
decimal maxBase = dict["AFMaxBase"];
if (af.AccumulationFundBase < minBase || af.AccumulationFundBase > maxBase)
{
assignMessage("基数范围错误", false);
return(RedirectToAction("ChangeFund"));
}
AdjustingBaseParameter adjustParam = new AdjustingBaseParameter();
adjustParam.AccumulationFundBaseAdjusted = af.AccumulationFundBase;
adjustParam.SocialSecurityPeopleID = af.SocialSecurityPeopleID;
adjustParam.IsPayAccumulationFund = true;
if (socialSv.AddAdjustingBase(adjustParam))
{
assignMessage("变更成功", true);
return(RedirectToAction("RecFund"));
}
assignMessage("变更失败", false);
return(RedirectToAction("ChangeFund"));
}
public ActionResult ChangeSB(SocialSecurity ss)
{
SocialSecurityViewModel socialSecurity = localSocialSv.GetSocialSecurity(ss.SocialSecurityPeopleID);
Dictionary <string, decimal> dict = socialSecurity.SocialAccumulationDict;
decimal minBase = dict["MinBase"];
decimal maxBase = dict["MaxBase"];
if (ss.SocialSecurityBase < minBase || ss.SocialSecurityBase > maxBase)
{
assignMessage("基数范围错误", false);
return(RedirectToAction("ChangeSB"));;
}
AdjustingBaseParameter adjustParam = new AdjustingBaseParameter();
adjustParam.SocialSecurityBaseAdjusted = ss.SocialSecurityBase;
adjustParam.SocialSecurityPeopleID = ss.SocialSecurityPeopleID;
adjustParam.IsPaySocialSecurity = true;
if (socialSv.AddAdjustingBase(adjustParam))
{
assignMessage("变更成功", true);
return(RedirectToAction("RecSB"));
}
assignMessage("变更失败", false);
return(RedirectToAction("ChangeSB"));
}
/// <summary>
/// 获取参保人详情
/// </summary>
/// <param name="socialId"></param>
/// <returns></returns>
public SocialSecurityViewModel GetSocialSecurity(int socialId)
{
string sql = $@"select
ssp.SocialSecurityPeopleID,
ssp.IdentityCard,
ss.SocialSecurityBase,
ssp.HouseholdProperty,
ss.InsuranceArea
from SocialSecurityPeople ssp
inner join SocialSecurity ss on ssp.SocialSecurityPeopleID = ss.SocialSecurityPeopleID
where ssp.SocialSecurityPeopleID = {socialId}";
SocialSecurityViewModel vm = DbHelper.QuerySingle <SocialSecurityViewModel>(sql);
vm.SocialAccumulationDict = SocialAccumulationBase(vm.InsuranceArea, vm.HouseholdProperty);
return(vm);
}
/// <summary>
/// 获取参保人详情
/// </summary>
/// <param name="socialId"></param>
/// <returns></returns>
public SocialSecurityViewModel GetAccumulationFundDetail(int socialId)
{
string sql = $@"select
ac.SocialSecurityPeopleID,
ssp.SocialSecurityPeopleName,
ssp.IdentityCard,
ac.AccumulationFundArea,
ac.AccumulationFundBase,
ssp.HouseholdProperty
from AccumulationFund ac
inner join SocialSecurityPeople ssp on ac.SocialSecurityPeopleID = ssp.SocialSecurityPeopleID
where ssp.SocialSecurityPeopleID = {socialId} " ;
SocialSecurityViewModel vm = DbHelper.QuerySingle <SocialSecurityViewModel>(sql);
vm.SocialAccumulationDict = SocialAccumulationBase(vm.InsuranceArea, vm.HouseholdProperty);
return(vm);
}
/// <summary>
/// 获取参保详情
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public ActionResult AccumulationFundDetail(int id)
{
SocialSecurityViewModel socialSecurity = localSocialSv.GetAccumulationFundDetail(id);
return(Json(socialSecurity, JsonRequestBehavior.AllowGet));
}
