Esempio n. 1
0
        /// <summary>
        /// 修改费用参数
        /// </summary>
        /// <param name="costParameterSetting"></param>
        /// <returns></returns>
        public bool UpdateCostParameter(CostParameterSetting costParameterSetting)
        {
            string sqlstr = $"update CostParameterSetting set BacklogCost ={costParameterSetting.BacklogCost},FreezingAmount={costParameterSetting.FreezingAmount},PayBeforeServiceCost={costParameterSetting.PayBeforeServiceCost},RenewServiceCost='{costParameterSetting.RenewServiceCost}' where Status={costParameterSetting.Status} ";
            int    result = DbHelper.ExecuteSqlCommand(sqlstr, null);

            return(result > 0);
        }
Esempio n. 2
0
        /// <summary>
        /// 添加费用参数
        /// </summary>
        /// <param name="costParameterSetting"></param>
        /// <returns></returns>
        public bool AddCostParameter(CostParameterSetting costParameterSetting)
        {
            string sqlstr = $"insert into CostParameterSetting(BacklogCost,FreezingAmount,PayBeforeServiceCost,RenewServiceCost,Status) values({costParameterSetting.BacklogCost},{costParameterSetting.FreezingAmount},{costParameterSetting.PayBeforeServiceCost},'{costParameterSetting.RenewServiceCost}',{costParameterSetting.Status})";
            int    result = DbHelper.ExecuteSqlCommand(sqlstr, null);

            return(result > 0);
        }
Esempio n. 3
0
        public CostParameterSetting GetCostParameter(int status)
        {
            string sqlstr = $"select * from CostParameterSetting where Status={status}";
            CostParameterSetting model = DbHelper.QuerySingle <CostParameterSetting>(sqlstr);

            return(model);
        }
Esempio n. 4
0
        /// <summary>
        /// 保存收费参数
        /// </summary>
        /// <param name="parameter"></param>
        /// <returns></returns>
        public ActionResult SaveCostParameter(CostParameterSetting parameter)
        {
            CostParameterSetting model = _parameterSettingService.GetCostParameter(parameter.Status);

            string RenewServiceCost = string.Empty;

            for (int i = 0; i < parameter.StartTime.Length; i++)
            {
                if (parameter.StartTime[i] != 0 && parameter.EndTime[i] != 0)
                {
                    RenewServiceCost += parameter.StartTime[i] + "," + parameter.EndTime[i] + "," + parameter.ServiceCost[i] + ";";
                }
            }

            parameter.RenewServiceCost = RenewServiceCost.Trim(';');

            bool flag = false;

            if (model == null)
            {
                //添加
                flag = _parameterSettingService.AddCostParameter(parameter);

                #region 记录日志
                if (flag == true)
                {
                    LogService.WriteLogInfo(new Log {
                        UserName = HttpContext.User.Identity.Name, Contents = "修改了社保收费标准"
                    });
                }
                #endregion
            }
            else
            {
                //更新
                flag = _parameterSettingService.UpdateCostParameter(parameter);

                #region 记录日志
                if (flag == true)
                {
                    LogService.WriteLogInfo(new Log {
                        UserName = HttpContext.User.Identity.Name, Contents = "修改了公积金收费标准"
                    });
                }
                #endregion
            }

            ViewBag.Message = flag ? "更新成功" : "更新失败";
            return(GetCostParameter(parameter.Status));
        }
Esempio n. 5
0
        /// <summary>
        /// 参数设置
        /// </summary>
        /// <returns></returns>
        public ActionResult GetCostParameter(int Status)
        {
            CostParameterSetting model = _parameterSettingService.GetCostParameter(Status);

            if (model == null)
            {
                model = new CostParameterSetting();
            }
            else
            {
                if (!string.IsNullOrEmpty(model.RenewServiceCost))
                {
                    string[] array = model.RenewServiceCost.Split(';');
                    model.StartTime   = new int[array.Length];
                    model.EndTime     = new int[array.Length];
                    model.ServiceCost = new decimal[array.Length];
                    for (int i = 0; i < array.Length; i++)
                    {
                        string[] array1 = array[i].Split(',');
                        model.StartTime[i]   = Convert.ToInt32(array1[0]);
                        model.EndTime[i]     = Convert.ToInt32(array1[1]);
                        model.ServiceCost[i] = Convert.ToDecimal(array1[2]);
                    }
                }
            }

            if (Status == (int)PayTypeEnum.SocialSecurity)
            {
                return(View("GetSocialSecurityCostParameter", model));
            }
            else if (Status == (int)PayTypeEnum.AccumulationFund)
            {
                return(View("GetAccumulationFundCostParameter", model));
            }
            else
            {
                return(HttpNotFound());
            }
        }
Esempio n. 6
0
        /// <summary>
        /// 提交充值
        /// </summary>
        /// <param name="parameter"></param>
        /// <returns></returns>
        public bool SubmitRechargeAmount(RechargeParameters parameter)
        {
            bool result = false;

            using (TransactionScope transaction = new TransactionScope())
            {
                try
                {
                    decimal MonthTotal = _socialSecurityService.GetMonthTotalAmountByMemberID(parameter.MemberID);
                    //计算第一个月
                    decimal     TotalServiceCost = 0;
                    decimal     SSServiceCost    = 0; //社保服务费
                    decimal     AFServiceCost    = 0; //公积金服务费
                    AccountInfo accountInfo      = _memberService.GetAccountInfo(parameter.MemberID);

                    string sqlAccountRecord = "";//记录
                    if (accountInfo.Account < MonthTotal)
                    {
                        int day = DateTime.Now.Day;
                        //社保服务费
                        CostParameterSetting SSParameter = _parameterSettingService.GetCostParameter((int)PayTypeEnum.SocialSecurity);
                        if (SSParameter != null && !string.IsNullOrEmpty(SSParameter.RenewServiceCost))
                        {
                            string[] str = SSParameter.RenewServiceCost.Split(';');
                            foreach (var item in str)
                            {
                                string[] str1 = item.Split(',');

                                if (Convert.ToInt32(str1[0]) <= day && day <= Convert.ToInt32(str1[1]))
                                {
                                    List <SocialSecurityPeople> SocialSecurityPeopleList = _socialSecurityService.GetSocialSecurityRenewListByMemberID(parameter.MemberID);
                                    //社保待办与正常的人数
                                    SSServiceCost = SocialSecurityPeopleList.Count * Convert.ToDecimal(str1[2]);
                                    //记录支出
                                    sqlAccountRecord += $@"insert into AccountRecord(MemberID,SocialSecurityPeopleID,SocialSecurityPeopleName,ShouZhiType,LaiYuan,OperationType,Cost,CreateTime) 
values({parameter.MemberID},'','','支出','余额','社保服务费',{SSServiceCost},getdate());";
                                    break;
                                }
                            }
                        }
                        //公积金服务费
                        CostParameterSetting AFParameter = _parameterSettingService.GetCostParameter((int)PayTypeEnum.AccumulationFund);
                        if (AFParameter != null && !string.IsNullOrEmpty(AFParameter.RenewServiceCost))
                        {
                            string[] str = AFParameter.RenewServiceCost.Split(';');
                            foreach (var item in str)
                            {
                                string[] str1 = item.Split(',');

                                if (Convert.ToInt32(str1[0]) <= day && day <= Convert.ToInt32(str1[1]))
                                {
                                    List <SocialSecurityPeople> SocialSecurityPeopleList = _socialSecurityService.GetAccumulationFundRenewListByMemberID(parameter.MemberID);
                                    //社保待办与正常的人数
                                    AFServiceCost = SocialSecurityPeopleList.Count * Convert.ToDecimal(str1[2]);
                                    //记录支出
                                    sqlAccountRecord += $@"insert into AccountRecord(MemberID,SocialSecurityPeopleID,SocialSecurityPeopleName,ShouZhiType,LaiYuan,OperationType,Cost,CreateTime) 
values({parameter.MemberID},'','','支出','余额','公积金服务费',{AFServiceCost},getdate());";
                                    break;
                                }
                            }
                        }
                    }
                    TotalServiceCost = SSServiceCost + AFServiceCost;
                    //修改账户余额
                    decimal account      = parameter.Amount - TotalServiceCost;
                    string  sqlMember    = $"update Members set Account=ISNULL(Account,0)+{account} where MemberID={parameter.MemberID}";
                    int     updateResult = DbHelper.ExecuteSqlCommand(sqlMember, null);
                    if (!(updateResult > 0))
                    {
                        throw new Exception("更新个人账户失败");
                    }

                    //记录收入
                    sqlAccountRecord += $"insert into AccountRecord(MemberID,SocialSecurityPeopleID,SocialSecurityPeopleName,ShouZhiType,LaiYuan,OperationType,Cost,CreateTime) values({parameter.MemberID},'','','收入','{parameter.PayMethod}','续费',{parameter.Amount},getdate());";
                    //更新记录
                    DbHelper.ExecuteSqlCommand(sqlAccountRecord, null);

                    //将所有的待续费变成正常,并将剩余月数变成服务月数  --待修改
                    string sqlstr = $@"update SocialSecurity set SocialSecurity.Status = {(int)SocialSecurityStatusEnum.Normal} where socialsecurity.SocialSecurityID in
  (select SocialSecurity.SocialSecurityID from SocialSecurity
left join SocialSecurityPeople on SocialSecurity.SocialSecurityPeopleID = SocialSecurityPeople.SocialSecurityPeopleID
  where SocialSecurityPeople.MemberID = {parameter.MemberID} and SocialSecurity.Status = {(int)SocialSecurityStatusEnum.Renew});
update AccumulationFund set AccumulationFund.Status = {(int)SocialSecurityStatusEnum.Normal} where AccumulationFund.AccumulationFundID in
  (select AccumulationFund.AccumulationFundID from AccumulationFund
left join SocialSecurityPeople on AccumulationFund.SocialSecurityPeopleID = SocialSecurityPeople.SocialSecurityPeopleID
  where SocialSecurityPeople.MemberID = {parameter.MemberID} and AccumulationFund.Status = {(int)SocialSecurityStatusEnum.Renew}) ";
                    DbHelper.ExecuteSqlCommand(sqlstr, null);

                    transaction.Complete();

                    result = true;
                }
                catch (Exception ex)
                {
                    result = false;
                }
                finally
                {
                    transaction.Dispose();
                }
            }

            return(result);
        }
Esempio n. 7
0
        ///// <summary>
        ///// 创建续费服务
        ///// </summary>
        ///// <param name="MemberID"></param>
        ///// <returns></returns>
        //private JsonResult<dynamic> CreateRenewalService(int MemberID)
        //{
        //    return new JsonResult<dynamic>
        //    {
        //        status = true,
        //        Message = "获取状态成功"
        //    };
        //}

        /// <summary>
        /// 续费
        /// </summary>
        /// <returns></returns>
        public JsonResult <dynamic> SubmitRenewalService(RenewalServiceParameters parameter)
        {
            using (TransactionScope transaction = new TransactionScope())
            {
                try
                {
                    //获取某用户下的所有待续费金额之和
                    decimal RenewMonthTotal = _socialSecurityService.GetRenewAmountByMemberID(parameter.MemberID);

                    //计算第一个月
                    decimal     TotalServiceCost = 0;
                    decimal     SSServiceCost    = 0; //社保服务费
                    decimal     AFServiceCost    = 0; //公积金服务费
                    AccountInfo accountInfo      = _memberService.GetAccountInfo(parameter.MemberID);

                    string sqlAccountRecord = ""; //记录
                    sqlAccountRecord = "";
                    string ShouNote = "续费:";      //收入备注
                    string ZhiNote  = "";         //支出备注
                    int    day      = DateTime.Now.Day;
                    //社保待续费人员列表
                    List <SocialSecurityPeople> SocialSecurityPeopleList = _socialSecurityService.GetSocialSecurityRenewListByMemberID(parameter.MemberID);
                    //收入
                    foreach (var socialSecurityPeople in SocialSecurityPeopleList)
                    {
                        ShouNote += string.Format("{0}:{1}个月社保;", socialSecurityPeople.SocialSecurityPeopleName, parameter.MonthCount);
                    }
                    //社保服务费
                    CostParameterSetting SSParameter = _parameterSettingService.GetCostParameter((int)PayTypeEnum.SocialSecurity);
                    if (SSParameter != null && !string.IsNullOrEmpty(SSParameter.RenewServiceCost))
                    {
                        string[] str = SSParameter.RenewServiceCost.Split(';');
                        foreach (var item in str)
                        {
                            string[] str1 = item.Split(',');

                            if (Convert.ToInt32(str1[0]) <= day && day <= Convert.ToInt32(str1[1]))
                            {
                                //社保待续费的人数
                                SSServiceCost = SocialSecurityPeopleList.Count * Convert.ToDecimal(str1[2]);
                                //收入
                                foreach (var socialSecurityPeople in SocialSecurityPeopleList)
                                {
                                    ShouNote += string.Format("{0}:社保服务费:{1};", socialSecurityPeople.SocialSecurityPeopleName, str1[2]);
                                    ZhiNote  += string.Format("{0}:社保服务费:{1};", socialSecurityPeople.SocialSecurityPeopleName, str1[2]);
                                }
                                break;
                            }
                        }
                    }
                    //公积金人员列表
                    List <SocialSecurityPeople> SocialSecurityPeopleList1 = _socialSecurityService.GetAccumulationFundRenewListByMemberID(parameter.MemberID);
                    //收入
                    foreach (var socialSecurityPeople in SocialSecurityPeopleList1)
                    {
                        ShouNote += string.Format("{0}:{1}个月公积金;", socialSecurityPeople.SocialSecurityPeopleName, parameter.MonthCount);
                    }
                    //公积金服务费
                    CostParameterSetting AFParameter = _parameterSettingService.GetCostParameter((int)PayTypeEnum.AccumulationFund);
                    if (AFParameter != null && !string.IsNullOrEmpty(AFParameter.RenewServiceCost))
                    {
                        string[] str = AFParameter.RenewServiceCost.Split(';');
                        foreach (var item in str)
                        {
                            string[] str1 = item.Split(',');

                            if (Convert.ToInt32(str1[0]) <= day && day <= Convert.ToInt32(str1[1]))
                            {
                                //社保待续费的人数*金额
                                AFServiceCost = SocialSecurityPeopleList1.Count * Convert.ToDecimal(str1[2]);
                                //收入
                                foreach (var socialSecurityPeople in SocialSecurityPeopleList1)
                                {
                                    ShouNote += string.Format("{0}:公积金服务费:{1};", socialSecurityPeople.SocialSecurityPeopleName, str1[2]);
                                    ZhiNote  += string.Format("{0}:公积金服务费:{1};", socialSecurityPeople.SocialSecurityPeopleName, str1[2]);
                                }
                                break;
                            }
                        }
                        //服务费总数
                        TotalServiceCost = SSServiceCost + AFServiceCost;


                        sqlAccountRecord += $@"insert into AccountRecord(SerialNum,MemberID,SocialSecurityPeopleID,SocialSecurityPeopleName,ShouZhiType,LaiYuan,OperationType,Cost,Balance,CreateTime)
values({DateTime.Now.ToString("yyyyMMddHHmmssfff") + new Random(Guid.NewGuid().GetHashCode()).Next(1000).ToString().PadLeft(3, '0')},{parameter.MemberID},'','','收入','{parameter.PayMethod}','{ShouNote}',{parameter.Amount},{accountInfo.Account + parameter.Amount},getdate());
                                       insert into AccountRecord(SerialNum,MemberID,SocialSecurityPeopleID,SocialSecurityPeopleName,ShouZhiType,LaiYuan,OperationType,Cost,Balance,CreateTime) 
values({DateTime.Now.ToString("yyyyMMddHHmmssfff") + new Random(Guid.NewGuid().GetHashCode()).Next(1000).ToString().PadLeft(3, '0')},{parameter.MemberID},'','','支出','余额','{ZhiNote}',{TotalServiceCost},{accountInfo.Account + parameter.Amount - TotalServiceCost},getdate()); ";


                        //修改账户余额
                        decimal account      = parameter.Amount - TotalServiceCost;
                        string  sqlMember    = $"update Members set Account=ISNULL(Account,0)+{account} where MemberID={parameter.MemberID}";
                        int     updateResult = DbHelper.ExecuteSqlCommand(sqlMember, null);

                        //更新记录
                        DbHelper.ExecuteSqlCommand(sqlAccountRecord, null);

                        //将所有的待续费变成正常,并将剩余月数变成服务月数
                        _socialSecurityService.UpdateRenewToNormalByMemberID(parameter.MemberID, parameter.MonthCount);

                        #region 作废
                        //                    decimal MonthTotal = _socialSecurityService.GetMonthTotalAmountByMemberID(parameter.MemberID);
                        //                    //计算第一个月
                        //                    decimal TotalServiceCost = 0;
                        //                    decimal SSServiceCost = 0;//社保服务费
                        //                    decimal AFServiceCost = 0;//公积金服务费
                        //                    AccountInfo accountInfo = _memberService.GetAccountInfo(parameter.MemberID);

                        //                    string sqlAccountRecord = "";//记录
                        //                    if (accountInfo.Account < MonthTotal)
                        //                    {
                        //                        int day = DateTime.Now.Day;
                        //                        //社保服务费
                        //                        CostParameterSetting SSParameter = _parameterSettingService.GetCostParameter((int)PayTypeEnum.SocialSecurity);
                        //                        if (SSParameter != null && !string.IsNullOrEmpty(SSParameter.RenewServiceCost))
                        //                        {
                        //                            string[] str = SSParameter.RenewServiceCost.Split(';');
                        //                            foreach (var item in str)
                        //                            {
                        //                                string[] str1 = item.Split(',');

                        //                                if (Convert.ToInt32(str1[0]) <= day && day <= Convert.ToInt32(str1[1]))
                        //                                {
                        //                                    List<SocialSecurityPeople> SocialSecurityPeopleList = _socialSecurityService.GetSocialSecurityRenewListByMemberID(parameter.MemberID);
                        //                                    //社保待办与正常的人数
                        //                                    SSServiceCost = SocialSecurityPeopleList.Count * Convert.ToDecimal(str1[2]);
                        //                                    //记录支出
                        //                                    sqlAccountRecord += $@"insert into AccountRecord(MemberID,SocialSecurityPeopleID,SocialSecurityPeopleName,ShouZhiType,LaiYuan,OperationType,Cost,CreateTime)
                        //values({parameter.MemberID},'','','支出','余额','社保服务费',{SSServiceCost},getdate());";
                        //                                    //                                    if (SocialSecurityPeopleList.Count > 0)
                        //                                    //                                    {
                        //                                    //                                        foreach (var item1 in SocialSecurityPeopleList)
                        //                                    //                                        {
                        //                                    //                                            sqlAccountRecord += $@"insert into AccountRecord(MemberID,SocialSecurityPeopleID,SocialSecurityPeopleName,ShouZhiType,LaiYuan,OperationType,Cost,CreateTime)
                        //                                    //values({parameter.MemberID},{item1.SocialSecurityPeopleID},'{item1.SocialSecurityPeopleName}','支出','余额','社保服务费',{str1[2]},getdate());";
                        //                                    //                                        }
                        //                                    //                                    }
                        //                                    break;
                        //                                }

                        //                            }
                        //                        }
                        //                        //公积金服务费
                        //                        CostParameterSetting AFParameter = _parameterSettingService.GetCostParameter((int)PayTypeEnum.AccumulationFund);
                        //                        if (AFParameter != null && !string.IsNullOrEmpty(AFParameter.RenewServiceCost))
                        //                        {
                        //                            string[] str = AFParameter.RenewServiceCost.Split(';');
                        //                            foreach (var item in str)
                        //                            {
                        //                                string[] str1 = item.Split(',');

                        //                                if (Convert.ToInt32(str1[0]) <= day && day <= Convert.ToInt32(str1[1]))
                        //                                {
                        //                                    List<SocialSecurityPeople> SocialSecurityPeopleList = _socialSecurityService.GetAccumulationFundRenewListByMemberID(parameter.MemberID);
                        //                                    //社保待办与正常的人数
                        //                                    AFServiceCost = SocialSecurityPeopleList.Count * Convert.ToDecimal(str1[2]);
                        //                                    //记录支出
                        //                                    sqlAccountRecord += $@"insert into AccountRecord(MemberID,SocialSecurityPeopleID,SocialSecurityPeopleName,ShouZhiType,LaiYuan,OperationType,Cost,CreateTime)
                        //values({parameter.MemberID},'','','支出','余额','公积金服务费',{AFServiceCost},getdate());";
                        //                                    //                                    if (SocialSecurityPeopleList.Count > 0)
                        //                                    //                                    {
                        //                                    //                                        foreach (var item1 in SocialSecurityPeopleList)
                        //                                    //                                        {
                        //                                    //                                            sqlAccountRecord += $@"insert into AccountRecord(MemberID,SocialSecurityPeopleID,SocialSecurityPeopleName,ShouZhiType,LaiYuan,OperationType,Cost,CreateTime)
                        //                                    //values({parameter.MemberID},{item1.SocialSecurityPeopleID},'{item1.SocialSecurityPeopleName}','支出','余额','公积金服务费',{str1[2]},getdate());";
                        //                                    //                                        }
                        //                                    //                                    }
                        //                                    break;
                        //                                }
                        //                            }
                        //                        }
                        //                    }
                        //                    TotalServiceCost = SSServiceCost + AFServiceCost;
                        //                    //修改账户余额
                        //                    decimal account = parameter.Amount - TotalServiceCost;
                        //                    string sqlMember = $"update Members set Account=ISNULL(Account,0)+{account} where MemberID={parameter.MemberID}";
                        //                    int updateResult = DbHelper.ExecuteSqlCommand(sqlMember, null);
                        //                    if (!(updateResult > 0)) throw new Exception("更新个人账户失败");

                        //                    //记录收入
                        //                    sqlAccountRecord += $"insert into AccountRecord(MemberID,SocialSecurityPeopleID,SocialSecurityPeopleName,ShouZhiType,LaiYuan,OperationType,Cost,CreateTime) values({parameter.MemberID},'','','收入','{parameter.PayMethod}','续费',{parameter.Amount},getdate());";
                        //                    //更新记录
                        //                    DbHelper.ExecuteSqlCommand(sqlAccountRecord, null);

                        //                    //将所有的待续费变成正常,并将剩余月数变成服务月数  --待修改
                        //                    _socialSecurityService.UpdateRenewToNormalByMemberID(parameter.MemberID, parameter.MonthCount);
                        #endregion

                        transaction.Complete();
                    }
                }
                catch (Exception ex)
                {
                    return(new JsonResult <dynamic>
                    {
                        status = false,
                        Message = "续费失败"
                    });
                }
                finally
                {
                    transaction.Dispose();
                }
            }

            return(new JsonResult <dynamic>
            {
                status = true,
                Message = "续费成功"
            });
        }
Esempio n. 8
0
        /// <summary>
        /// 获取续费服务集合 只有需要续费的才能进入
        /// </summary>
        /// <param name="MemberID"></param>
        /// <returns></returns>
        public JsonResult <List <KeyValuePair <int, decimal> > > GetRenewalServiceList(int MemberID)
        {
            //只有账户状态为待续费状态下才能进行续费服务,付费提供1-12个月的服务,1号前无需缴纳服务费,其它需按设置缴纳,不管续几个月,只缴纳一个月服务费


            //计算第一个月
            decimal TotalServiceCost = 0;
            decimal SSServiceCost    = 0;
            decimal AFServiceCost    = 0;


            int day = DateTime.Now.Day;
            //社保服务费
            CostParameterSetting SSParameter = _parameterSettingService.GetCostParameter((int)PayTypeEnum.SocialSecurity);

            if (SSParameter != null && !string.IsNullOrEmpty(SSParameter.RenewServiceCost))
            {
                string[] str = SSParameter.RenewServiceCost.Split(';');
                foreach (var item in str)
                {
                    string[] str1 = item.Split(',');

                    if (Convert.ToInt32(str1[0]) <= day && day <= Convert.ToInt32(str1[1]))
                    {
                        //社保续费的人数*服务费
                        SSServiceCost = _socialSecurityService.GetSocialSecurityRenewListByMemberID(MemberID).Count *Convert.ToDecimal(str1[2]);
                        break;
                    }
                }
            }
            //公积金服务费
            CostParameterSetting AFParameter = _parameterSettingService.GetCostParameter((int)PayTypeEnum.AccumulationFund);

            if (AFParameter != null && !string.IsNullOrEmpty(AFParameter.RenewServiceCost))
            {
                string[] str = AFParameter.RenewServiceCost.Split(';');
                foreach (var item in str)
                {
                    string[] str1 = item.Split(',');

                    if (Convert.ToInt32(str1[0]) <= day && day <= Convert.ToInt32(str1[1]))
                    {
                        //社保待续费任务*服务费
                        AFServiceCost = _socialSecurityService.GetAccumulationFundRenewListByMemberID(MemberID).Count *Convert.ToDecimal(str1[2]);
                        break;
                    }
                }
            }

            //不管充几个月服务,都要加上这个服务费,然后减去账户金额
            decimal     RenewMonthTotal = _socialSecurityService.GetRenewAmountByMemberID(MemberID);
            AccountInfo accountInfo     = _memberService.GetAccountInfo(MemberID);

            TotalServiceCost = SSServiceCost + AFServiceCost;
            Dictionary <int, decimal> dic = new Dictionary <int, decimal>();

            for (int i = 0; i < 12; i++)
            {
                dic.Add(i + 1, RenewMonthTotal * (i + 1) + TotalServiceCost - accountInfo.Account);
            }

            return(new JsonResult <List <KeyValuePair <int, decimal> > >
            {
                status = true,
                Message = "获取续费服务集合成功",
                Data = dic.ToList()
            });

            #region 作废
            ////所有服务月-账户余额,如果<0则去除
            //for (int i = 0; i < 12; i++)
            //{
            //    dic[i + 1] = dic[i + 1] - accountInfo.Account;
            //    if (dic[i + 1] <= 0)
            //        dic.Remove(i + 1);
            //}


            ////1号前无需服务费;1号后看账户余额,如果够缴纳一个月,则不需要交服务费,否则需交所有人一个月服务费(同下)
            ////账户余额够一个月,则无需交服务费,如果不够,则看1号前还是1号后,前不需要交,后需要交
            ////一个月服务
            //decimal MonthTotal = _socialSecurityService.GetMonthTotalAmountByMemberID(MemberID);
            //Dictionary<int, decimal> dic = new Dictionary<int, decimal>();
            //for (int i = 0; i < 12; i++)
            //{
            //    dic.Add(i + 1, MonthTotal * (i + 1));
            //}
            ////计算第一个月
            //decimal TotalServiceCost = 0;
            //decimal SSServiceCost = 0;
            //decimal AFServiceCost = 0;

            //AccountInfo accountInfo = _memberService.GetAccountInfo(MemberID);
            //if (accountInfo.Account < MonthTotal)
            //{
            //    int day = DateTime.Now.Day;
            //    //社保服务费
            //    CostParameterSetting SSParameter = _parameterSettingService.GetCostParameter((int)PayTypeEnum.SocialSecurity);
            //    if (SSParameter != null && !string.IsNullOrEmpty(SSParameter.RenewServiceCost))
            //    {
            //        string[] str = SSParameter.RenewServiceCost.Split(';');
            //        foreach (var item in str)
            //        {
            //            string[] str1 = item.Split(',');

            //            if (Convert.ToInt32(str1[0]) <= day && day <= Convert.ToInt32(str1[1]))
            //            {
            //                //社保待办与正常与续费的人数
            //                SSServiceCost = _socialSecurityService.GetSocialSecurityRenewListByMemberID(MemberID).Count * Convert.ToDecimal(str1[2]);
            //                break;
            //            }

            //        }
            //    }
            //    //公积金服务费
            //    CostParameterSetting AFParameter = _parameterSettingService.GetCostParameter((int)PayTypeEnum.AccumulationFund);
            //    if (AFParameter != null && !string.IsNullOrEmpty(AFParameter.RenewServiceCost))
            //    {
            //        string[] str = AFParameter.RenewServiceCost.Split(';');
            //        foreach (var item in str)
            //        {
            //            string[] str1 = item.Split(',');

            //            if (Convert.ToInt32(str1[0]) <= day && day <= Convert.ToInt32(str1[1]))
            //            {
            //                //社保待办与正常的人数
            //                AFServiceCost = _socialSecurityService.GetAccumulationFundRenewListByMemberID(MemberID).Count * Convert.ToDecimal(str1[2]);
            //                break;
            //            }

            //        }
            //    }

            //    //小于一个月的(现在处于小于一个月内),不管充几个月服务,都要加上这个服务费,然后减去账户金额
            //    TotalServiceCost = SSServiceCost + AFServiceCost;
            //    for (int i = 0; i < 12; i++)
            //    {
            //        dic[i + 1] = dic[i + 1] + TotalServiceCost;
            //    }
            //}

            ////所有服务月-账户余额,如果<0则去除
            //for (int i = 0; i < 12; i++)
            //{
            //    dic[i + 1] = dic[i + 1] - accountInfo.Account;
            //    if (dic[i + 1] <= 0)
            //        dic.Remove(i + 1);
            //}

            //return new JsonResult<List<KeyValuePair<int, decimal>>>
            //{
            //    status = true,
            //    Message = "获取集合成功",
            //    Data = dic.ToList()
            //};
            #endregion
        }