示例#1
0
        public string FP50301(int pageSize)
        {
            string consultantUserSN = session["userSN"].ToString();

            //string consultantUserSN = "U00003";

            using (DBMA1DataContext dbma1 = new DBMA1DataContext())
            {
                var linqData = (from c in dbma1.VP503001s
                                where c.consultantUserSN == consultantUserSN
                                orderby c.acceptReserveDate descending
                                select c).Take(pageSize).ToList();

                return(string.Format("{{\"crDataList\":{0},\"maxDatetime\":\"{1}\"}}", C101.FC10107(linqData), DateTime.Now));
            }
        }
示例#2
0
        //“0”:成功; “1”:交易密码错误; "2":姓名错误
        public string FM060301(string phone, string name, decimal changeAmount, string changeReasonType, string pwd, string note)
        {
            using (DBMA1DataContext dbma1 = new DBMA1DataContext())
            {
                //查看密码是否正确
                int operatorSN = Convert.ToInt32(session["internalUserId"].ToString());
                var data       = dbma1.internal_users.Where(c => c.internal_user_id == operatorSN && c.pwd == pwd).FirstOrDefault();
                if (data == null)
                {
                    return("{\"sucStatus\":\"1\"}");
                }

                var    u000   = dbma1.U000s.Where(c => c.phone == phone).First();
                string userSN = u000.userSN;

                //姓名是否正确
                if (u000.name.Trim() != name)
                {
                    return("{\"sucStatus\":\"2\"}");
                }

                //更新余额表 F000
                F000 f000 = dbma1.F000s.Where(c => c.userSN == userSN).First();
                f000.balance += changeAmount;

                //添加调账表 F007
                F007 f007 = new F007();
                f007.changeAccountSN  = C101.FC10102("F007", 7, "UF");
                f007.userSN           = userSN;
                f007.phone            = phone;
                f007.name             = name;
                f007.changeAmount     = changeAmount;
                f007.changeReasonType = changeReasonType;
                f007.note             = note;
                f007.changeDate       = DateTime.Now;
                dbma1.F007s.InsertOnSubmit(f007);

                //添加收支明细表 F003
                F003 f003 = new F003();
                f003.revenueExpenditureSN = C101.FC10102("F003", 8, "UA");
                f003.generetorUserSN      = userSN;
                f003.generateDate         = DateTime.Now;
                f003.type        = changeReasonType;
                f003.revenue     = changeAmount;
                f003.expenditure = 0;
                f003.balance     = f000.balance;
                f003.referSN     = f007.changeAccountSN;
                dbma1.F003s.InsertOnSubmit(f003);

                //添加后台修改记录 B00
                B000 b000 = new B000();
                b000.bgOperateSN  = C101.FC10102("B000", 5, "B");
                b000.tableName    = "B005";
                b000.pkSN         = f007.changeAccountSN;
                b000.actionTypeSN = "B0G";
                b000.operatorSN   = operatorSN;
                b000.operateDate  = DateTime.Now;
                dbma1.B000s.InsertOnSubmit(b000);

                dbma1.SubmitChanges();


                dbma1.SubmitChanges();

                return(string.Format("{{\"sucStatus\":\"0\",\"SN\":\"{0}\",\"date\":{1}}}", f007.changeAccountSN, C101.FC10107(DateTime.Now)));
            }
        }
示例#3
0
        public string FP80306()
        {
            //判断是否登录
            if (session["userSN"] == null)
            {
                return("notLogin");
            }

            string userSN = session["userSN"].ToString();

            using (DBMA1DataContext dbma1 = new DBMA1DataContext())
            {
                U000 u000 = dbma1.U000s.Where(c => c.userSN == userSN).First();

                //获取用户名
                string userName = u000.name;

                //获取短信费用
                decimal shortMessageFee = Convert.ToDecimal(dbma1.A028s.First().shortMessageCost);

                //获取手机号码
                string phone = u000.phone;

                //获取原邮箱
                string email = dbma1.U002s.Where(c => c.userSN == userSN).First().email;

                //获取通知设定
                var u003 = (from c in dbma1.U003s
                            where c.userSN == userSN
                            select new
                {
                    c.billGenerate_shortMessage,
                    c.billGenerate_email,
                    c.overdue_shortMessage,
                    c.overdue_email,
                    c.receiveReserve_shortMessage,
                    c.receiveReserve_email
                }).First();

                return(string.Format("{{\"userName\":\"{0}\",\"shortMessageFee\":\"{1}\",\"phone\":\"{2}\",\"email\":\"{3}\",\"messageConfig\":{4},\"userSN\":\"{5}\"}}", userName, shortMessageFee, phone, email, C101.FC10107(u003), userSN));
            }
        }
示例#4
0
        /// <summary>
        /// 获取投资方详细信息
        /// </summary>
        public string FP20108(string investorUserSN)
        {
            using (DBMA1DataContext dbma1 = new DBMA1DataContext())
            {
                var investorData = (from c in dbma1.VP801001s
                                    where c.userSN == investorUserSN
                                    select new
                {
                    c.userSN,
                    c.birthday,
                    c.gender,
                    c.registeredResidence,
                    c.idCard,
                    c.email,
                    c.maritalStatusType,
                    c.enterpriseType,
                    c.hiredate,
                    c.workTel,
                    c.post,
                    c.enterpriseSwitchboard,
                    c.enterpriseWebsite,
                    c.investMainType,
                    c.financingMain,
                    c.maxMortgageRate,
                    c.guaranteeType,
                    c.investProvince,
                    c.investCity,
                    c.minInvestMoneyAmount,
                    c.minInterestRate,
                    c.minInvestDays,
                    c.maxInvestDays,
                    c.collateralDemand
                }).First();


                var investStatus = dbma1.VP104011s.Where(c => c.investorUserSN == investorUserSN).First();

                string res = string.Format("{{\"investorData\":{0},\"investCaseAmount\":{1},\"investMoneyAmount\":{2}}}", C101.FC10107(investorData), investStatus.investCaseAmount, investStatus.InvestMoneyAmount);

                return(res);
            }
        }
示例#5
0
        /// <summary>
        /// 获取uip
        /// </summary>
        public string FP80200()
        {
            if (session["userSN"] == null)
            {
                return("notLogin");
            }
            string userSN = session["userSN"].ToString();

            using (DBMA1DataContext dbma1 = new DBMA1DataContext())
            {
                string provinceData   = C201.FC20121(dbma1).Replace("[", "").Replace("]", "");
                string marital        = C201.FC20100(dbma1).Replace("[", "").Replace("]", "");
                string enterpriseType = C201.FC20104(dbma1).Replace("[", "").Replace("]", "");
                string investMain     = C201.FC20106(dbma1).Replace("[", "").Replace("]", "");
                string guaranteeType  = C201.FC20117(dbma1).Replace("[", "").Replace("]", "");
                string assetsType     = C201.FC20108(dbma1).Replace("[", "").Replace("]", "");
                string degreeType     = C201.FC20102(dbma1).Replace("[", "").Replace("]", "");
                string healthStatus   = C201.FC20101(dbma1).Replace("[", "").Replace("]", "");
                //string creditStatusType = C201.FC20105(dbma1).Replace("[", "").Replace("]", "");
                string industryType = C201.FC20113(dbma1).Replace("[", "").Replace("]", "");
                string cityData     = C201.FC20148(dbma1);

                U002 u002 = dbma1.U002s.Where(c => c.userSN == userSN).First();
                //当前成长值
                decimal currentGroupValue = Convert.ToInt32(dbma1.F006s.Where(c => c.userSN == userSN).Sum(c => c.groupUpValue));
                var     userInfo          = new { No = u002.userSN, Name = u002.name, Sex = u002.gender, BirthDay = u002.birthday, CardID = u002.idCard.Substring(0, 6) + "*", Mobile = u002.phone, CardAddress = u002.registeredResidence, MyGrow = currentGroupValue };

                string userInfoStr = C101.FC10107(userInfo);

                var investParams     = dbma1.A023s.First();
                var financingParams  = dbma1.A024s.First();
                var consultantParams = dbma1.A025s.First();
                var purchaseParams   = dbma1.A026s.First();
                var sellParams       = dbma1.A027s.First();

                var PawnRate    = new { Min = investParams.minMorgageRate, Max = investParams.maxMorgageRate };
                var InvestAmt   = new { Min = investParams.minInvestMoneyAmount, Max = investParams.maxInvestMoneyAmount };
                var DayRate     = new { Min = investParams.minDailyRate, Max = investParams.maxDailyRate };
                var InvestLimit = new { Min = investParams.minInvestDays, Max = investParams.maxInvestDays };
                var BayAmt      = new { Min = purchaseParams.minPurchasePrice, Max = purchaseParams.maxPurchasePrice };
                //var MTIn = new {Min = null,Max = null};
                //var MTOut = new {Min = null,Max = null};
                //var MCIn = new { Min = null, MAx = null };
                var TAsset  = new { Min = financingParams.minTotalAssets, Max = financingParams.maxTotalAssets };
                var TBorrow = new { Min = financingParams.minTotalLiability, Max = financingParams.maxTotalLiability };
                var CAsset  = new { Min = financingParams.minTotalAssets, Max = financingParams.maxTotalAssets };

                string PawnRateStr    = C101.FC10107(PawnRate);
                string InvestAmtStr   = C101.FC10107(InvestAmt);
                string DayRateStr     = C101.FC10107(DayRate);
                string InvestLimitStr = C101.FC10107(InvestLimit);
                string BayAmtStr      = C101.FC10107(BayAmt);
                string TAssetStr      = C101.FC10107(TAsset);
                string TBorrowStr     = C101.FC10107(TBorrow);
                string CAssetStr      = C101.FC10107(CAsset);

                U001   u001 = dbma1.U001s.Where(c => c.userSN == userSN).First();
                string investApplyStatus     = u001.creditRightInvestApplyStauts == 2 ? "1" : "0";
                string financingApplyStatus  = u001.creditRightFinancingApplyStatus == 2 ? "1" : "0";
                string sellApplyStatus       = u001.assetsSellingApplyStatus == 2 ? "1" : "0";
                string purchaseApplyStatus   = u001.assetsPurchaseApplyStatus == 2 ? "1" : "0";
                string consultantApplyStatus = u001.consultantApplyStatus == 2 ? "1" : "0";
                if (u001.consultantApplyStatus == 0)
                {
                    consultantApplyStatus = "0";
                }
                else if (u001.consultantApplyStatus == 1)
                {
                    consultantApplyStatus = "2";
                }
                else if (u001.consultantApplyStatus == 2)
                {
                    consultantApplyStatus = "1";
                }
                else if (u001.consultantApplyStatus == 3)
                {
                    consultantApplyStatus = "0";
                }

                string CreditInvestStr  = "\"\"";
                string CreditBorrowStr  = "\"\"";
                string AssetsSalesStr   = "\"\"";
                string AssetsBuyStr     = "\"\"";
                string AdviserServerStr = "\"\"";

                //投资
                if (investApplyStatus == "1")
                {
                    var userLinq = dbma1.P102s.Where(c => c.investorUserSN == userSN);

                    //债权总额
                    decimal crMoneyAmount = (from c in dbma1.P102s
                                             where c.investorUserSN == userSN
                                             //&& c.closeCaseDate == null
                                             select new
                    {
                        c.investMoneyAmount
                    }).ToList().Sum(r => r.investMoneyAmount);

                    //债权数量
                    int crAmount = (from c in dbma1.P102s
                                    where c.investorUserSN == userSN
                                    //&& c.closeCaseDate == null
                                    select c).Count();

                    //投资收益
                    decimal investEarnings = (from c in userLinq
                                              from o in c.P103s
                                              where c.closeCaseDate != null
                                              select new
                    {
                        earnings = (o.repayDate - c.investDate).Days * c.dailyRate * c.investMoneyAmount
                    }).ToList().Sum(c => c.earnings);

                    var CreditInvest = new { TotalPrice = crMoneyAmount, TotalNum = crAmount, TotalIncome = investEarnings };
                    CreditInvestStr = C101.FC10107(CreditInvest);
                }
                //融资
                if (financingApplyStatus == "1")
                {
                    //正在融资
                    int financingAmount = (from c in dbma1.P200s
                                           where c.publisherUserSN == userSN &&
                                           c.cancelDate == null &&
                                           !dbma1.P102s.Any(o => o.creditRightSN == c.creditRightSN)
                                           select c).Count();

                    //正在还款
                    int repayingAmount = (from c in dbma1.P102s
                                          where c.financierUserSN == userSN &&
                                          c.closeCaseDate == null
                                          select c).Count();

                    //即将逾期
                    //即将逾期天数
                    int aboutToOverdueDays   = 30;
                    int aboutToOverdueAmount = (from c in dbma1.P102s
                                                where c.financierUserSN == userSN &&
                                                c.closeCaseDate == null &&
                                                DateTime.Now.AddDays(aboutToOverdueDays) > c.deadlineDate &&
                                                DateTime.Now <= c.deadlineDate
                                                select c).Count();

                    var CreditBorrow = new { Borrowing = financingAmount, Paying = repayingAmount, Overdue = aboutToOverdueAmount };
                    CreditBorrowStr = C101.FC10107(CreditBorrow);
                }
                //资产出售
                if (sellApplyStatus == "1")
                {
                    //已发布
                    int publishAssetsAmount = (from c in dbma1.VP401001s
                                               where c.publisherUserSN == userSN
                                               select c).Count();

                    //预约中
                    //int reservingAssetsAmount = (from c in dbma1.P400s
                    //                             where c.receiverUserSN == userSN
                    //                                 && c.senderCancelReserveDate == null
                    //                                 && c.receiverRefuseReserveDate == null
                    //                                 && !c.P401s.Any()
                    //                             select c).Count();
                    int reservingAssetsAmount = (from c in dbma1.VP402011s
                                                 where c.receiverUserSN == userSN
                                                 select c).Count();

                    //已成交
                    //int purchasedAssetsAmount = dbma1.P401s.Where(c => c.sellerUserSN == userSN).Count();
                    int purchasedAssetsAmount = (from c in dbma1.VP404001s
                                                 where c.sellerUserSN == userSN &&
                                                 c.sellerDeleteDate == null
                                                 select c).Count();

                    var AssetsSales = new { Publish = publishAssetsAmount, Booking = reservingAssetsAmount, Close = purchasedAssetsAmount };
                    AssetsSalesStr = C101.FC10107(AssetsSales);
                }
                //资产购买
                if (purchaseApplyStatus == "1")
                {
                    //预约中
                    //int reservingAssetsAmount = (from c in dbma1.P400s
                    //                             where c.senderUserSN == userSN
                    //                                 && c.senderCancelReserveDate == null
                    //                                 && c.receiverRefuseReserveDate == null
                    //                                 && !c.P401s.Any()
                    //                             select c).Count();
                    int reservingAssetsAmount = (from c in dbma1.VP402011s
                                                 where c.senderUserSN == userSN
                                                 select c).Count();

                    //已成交
                    //int purchasedAssetsAmount = dbma1.P401s.Where(c => c.purchaserUserSN == userSN).Count();
                    int purchasedAssetsAmount = (from c in dbma1.VP404001s
                                                 where c.purchaserUserSN == userSN &&
                                                 c.purchaserDeleteDate == null
                                                 select c).Count();


                    var AssetsBuy = new { Booking = reservingAssetsAmount, Close = purchasedAssetsAmount };
                    AssetsBuyStr = C101.FC10107(AssetsBuy);
                }
                //财务管理
                if (consultantApplyStatus == "1")
                {
                    //预约中
                    int reserveAmount = (from c in dbma1.VP502001s
                                         where c.consultantUserSN == userSN
                                         select c).Count();

                    //服务中
                    int servicingAmount = (from c in dbma1.VP503001s
                                           where c.consultantUserSN == userSN
                                           select c).Count();

                    //已结案
                    int servicedAmount = (from c in dbma1.VP504021s
                                          where c.consultantUserSN == userSN
                                          select c).Count();

                    ////已成交
                    //int investAmount = (from c in dbma1.P500s.Where(c => c.consultantUserSN == userSN && c.auditStatus != null)
                    //                    join o in dbma1.P101s on c.reserveSN equals o.reserveSN
                    //                    join p in dbma1.P102s on o.creditRightReserveSN equals p.reserveSN
                    //                    select c).Count();

                    var AdviserServer = new { Booking = reserveAmount, Serving = servicingAmount, Close = servicedAmount };
                    AdviserServerStr = C101.FC10107(AdviserServer);
                }

                //财务管理
                decimal balanceV = dbma1.F000s.Where(c => c.userSN == userSN).First().balance;
                decimal usedV    = Convert.ToDecimal
                                   (
                    (from c in dbma1.F003s
                     where c.generetorUserSN == userSN &&
                     c.expenditure != null
                     select c.expenditure).Sum()
                                   );

                int needPayBillAmount = (from c in dbma1.F001s
                                         where c.payerUserSN == userSN &&
                                         !dbma1.F002s.Any(o => o.billSN == c.billSN)
                                         select c).Count();

                var    cwData    = new { RemainVB = balanceV, UsedVB = usedV, Payable = needPayBillAmount };
                string FinaceStr = C101.FC10107(cwData);

                //成长值
                string GrowUpInfoStr = GrowUp(dbma1, userSN, currentGroupValue);

                //安全管理
                int temp = 0;
                if (dbma1.U000s.Where(c => c.userSN == userSN).First().ifChangePwd == true)
                {
                    temp++;
                }
                if (dbma1.U003s.Where(c => c.userSN == userSN).First().ifChangeTransactPwd == true)
                {
                    temp++;
                }
                if (u002.ifChangeEmail == true)
                {
                    temp++;
                }
                string level = string.Empty;
                if (temp == 0 || temp == 1)
                {
                    level = "低";
                }
                else if (temp == 2)
                {
                    level = "中";
                }
                else
                {
                    level = "高";
                }
                var    SafeManage    = new { Leval = level, Mobile = u002.phone, Email = u002.email == null ? "" : u002.email };
                string SafeManageStr = C101.FC10107(SafeManage);

                //服务费
                var    SvrFee    = new { Invest = investParams.openServerCost, Borrow = financingParams.openServerCost, AssetSale = sellParams.openServerCost, AssetBuy = purchaseParams.openServerCost, Adviser = consultantParams.openServerCost };
                string SvrFeeStr = C101.FC10107(SvrFee);

                //账单逾期及停止服务
                A028   a028          = dbma1.A028s.First();
                var    SvrStopTip    = new { Day = a028.serverStopDays, Rate = a028.serverStopRate };
                var    OverdueTip    = new { Day = Convert.ToInt32(a028.needPayDays), Rate = a028.overdueRateDaily };
                string SvrStopTipStr = C101.FC10107(SvrStopTip);
                string OverdueTipStr = C101.FC10107(OverdueTip);

                //注册奖励V币数
                decimal SentScore = Convert.ToInt32(dbma1.A031s.First().regPresentV);

                //账单情况
                string billStatus;
                //无未付账单
                if (needPayBillAmount == 0)
                {
                    billStatus = "0";
                }
                else
                {
                    var linq = (from c in dbma1.F001s
                                where c.payerUserSN == userSN &&
                                !dbma1.F002s.Any(o => o.billSN == c.billSN) &&
                                (DateTime.Now - c.generateDate).Days >= OverdueTip.Day
                                select c).FirstOrDefault();

                    //付款未超过规定时间
                    if (linq == null)
                    {
                        billStatus = "1";
                    }
                    //付款超过规定时间
                    else
                    {
                        billStatus = "2";
                    }
                }

                //是否已经领取V币
                string ifGetV = (from c in dbma1.F004s
                                 where c.userSN == userSN &&
                                 c.rewardType.Trim() == "注册赠送"
                                 select c).FirstOrDefault() == null ? "1" : "0";

                string res;
                res = string.Format("{{\"SltConfigData\":[{0},{1},{2},{3},{4},{5},{6},{7},{8}],\"PawnRate\":{9},\"InvestAmt\":{10},\"DayRate\":{11},\"InvestLimit\":{12},\"BayAmt\":{13},\"TAsset\":{14},\"TBorrow\":{15},\"CAsset\":{16},\"CreditInvest\":{17},\"CreditBorrow\":{18},\"AssetsSales\":{19},\"AssetsBuy\":{20},\"AdviserServer\":{21},\"Finace\":{22},\"GrowUpInfo\":{23},\"SafeManage\":{24},\"SvrFee\":{25},\"SvrStopTip\":{26},\"OverdueTip\":{27},\"SentScore\":\"{28}\",\"investApplyStatus\":\"{29}\",\"financingApplyStatus\":\"{30}\",\"sellApplyStatus\":\"{31}\",\"purchaseApplyStatus\":\"{32}\",\"consultantApplyStatus\":\"{33}\",\"investStatus\":\"{34}\",\"financingStatus\":\"{35}\",\"sellStatus\":\"{36}\",\"purchaseStatus\":\"{37}\",\"consultantStatus\":\"{38}\",\"ifGetV\":\"{39}\",\"UserInfo\":{40},\"billStatus\":\"{41}\",\"cityData\":{42}}}", provinceData, marital, enterpriseType, investMain, guaranteeType, assetsType, degreeType, healthStatus, industryType, PawnRateStr, InvestAmtStr, DayRateStr, InvestLimitStr, BayAmtStr, TAssetStr, TBorrowStr, CAssetStr, CreditInvestStr, CreditBorrowStr, AssetsSalesStr, AssetsBuyStr, AdviserServerStr, FinaceStr, GrowUpInfoStr, SafeManageStr, SvrFeeStr, SvrStopTipStr, OverdueTipStr, SentScore, investApplyStatus, financingApplyStatus, sellApplyStatus, purchaseApplyStatus, consultantApplyStatus, u001.creditRightInvestStatus, u001.creditRightFinancingStatus, u001.assetsSellingStatus, u001.assetsPruchaseStatus, u001.consultantStatus, ifGetV, userInfoStr, billStatus, cityData);

                return(res);
            }
        }
示例#6
0
        public string FM020210(int pageFrom, int pageSize, string sortStr)
        {
            using (DBBC1DataContext dbbc1 = new DBBC1DataContext())
            {
                var dataList = Sort(dbbc1, sortStr).Skip(pageFrom).Take(pageSize).ToList();

                //服务状态
                string serverStatusListStr = GetServerStatusList(dataList);

                return(string.Format("{{\"dataList\":{0},\"serverStatusList\":{1}}}", C101.FC10107(dataList), serverStatusListStr));
            }
        }
示例#7
0
        /// <summary>
        /// 获取选择顾问列表
        /// </summary>
        public string FP10210(string crSN, string sortStr)
        {
            string investorUserSN = session["userSN"].ToString();

            string orderStr = string.Empty;

            string[] sortStrSplit = sortStr.Split(',');
            for (int i = 1; i < (sortStrSplit.Length - 1); i++)
            {
                string[] sortStrSplitSplit = sortStrSplit[i].Split('#');
                if ((i != 1))
                {
                    orderStr += ",";
                }
                orderStr += sortStrSplitSplit[0] == "1" ? " successCaseAmount" : " caseAmount";
                orderStr += sortStrSplitSplit[1] == "A" ? "" : " desc";
            }

            using (DBMA1DataContext dbma1 = new DBMA1DataContext())
            {
                List <SelectConsultantList> consultantList = null;

                string sqlStr = string.Format("select VP509011.consultantUserSN,VP509011.serviceProvince,VP509011.serviceCity,VP509011.caseAmount,VP509011.successCaseAmount,A.qualificationSN from VP509011 left join (select consultantUserSN,qualificationSN from P104 where  investorUserSN = '{0}' and creditRightSN = '{1}') as A on VP509011.consultantUserSN = A.consultantUserSN", investorUserSN, crSN);

                if (orderStr == string.Empty)
                {
                    consultantList = dbma1.ExecuteQuery <SelectConsultantList>(sqlStr).ToList();
                }
                else
                {
                    sqlStr         = string.Format("{0} order by {1}", sqlStr, orderStr);
                    consultantList = dbma1.ExecuteQuery <SelectConsultantList>(sqlStr).ToList();
                }

                //发布费用
                A023    a023 = dbma1.A023s.First();
                decimal?fee  = a023.consultantReserveCost;

                //账户余额
                F000    f000    = dbma1.F000s.Where(c => c.userSN == investorUserSN).First();
                decimal balance = f000.balance;

                return(string.Format("{{\"balance\":\"{0}\",\"fee\":\"{1}\",\"consultantDataList\":{2}}}", balance, fee, C101.FC10107(consultantList)));
            }
        }
示例#8
0
        /// <summary>
        /// 获取隐藏融资方信息
        /// </summary>
        public string FP10105(string financierUserSN)
        {
            using (DBMA1DataContext dbma1 = new DBMA1DataContext())
            {
                //案例情况
                var     caseStatus      = dbma1.P102s.Where(c => c.financierUserSN == financierUserSN);
                int     caseAmount      = caseStatus.Count();
                decimal?caseMoneyAmount = caseAmount == 0 ? 0 : caseStatus.Sum(c => c.investMoneyAmount);

                //当前债务情况
                var     debtStatus      = dbma1.P102s.Where(c => c.financierUserSN == financierUserSN && c.closeCaseDate == null);
                int     debtAmount      = debtStatus.Count();
                decimal?debtMoneyAmount = debtAmount == 0 ? 0 : debtStatus.Sum(c => c.investMoneyAmount);

                //当前逾期情况
                var currentOverdueStatus = from c in dbma1.P102s
                                           where c.financierUserSN == financierUserSN &&
                                           c.closeCaseDate == null &&
                                           DateTime.Now > c.deadlineDate
                                           select c;
                int     currentOverdueAmount      = currentOverdueStatus.Count();
                decimal?currentOverdueMoneyAmount = currentOverdueAmount == 0 ? 0 : currentOverdueStatus.Sum(c => c.investMoneyAmount);

                //历史逾期数量
                var historyOverdueStatus = from c in dbma1.P102s
                                           from p in c.P103s
                                           where c.financierUserSN == financierUserSN &&
                                           c.deadlineDate < p.repayDate &&
                                           c.investSN == p.investSN
                                           select c;
                int historyOverdueAmount = historyOverdueStatus.Count();

                //注册时间
                DateTime regDatetime    = dbma1.U000s.Where(c => c.userSN == financierUserSN).First().registerDate;
                string   regDatetimeStr = C101.FC10107(regDatetime);

                //基本信息
                var financierBasicData = (from c in dbma1.VP801001s
                                          where c.userSN == financierUserSN
                                          select new
                {
                    c.userSN,
                    c.birthday,
                    c.gender,
                    c.registeredResidence,
                    idCard = c.idCard.Substring(0, 6),
                    c.maritalStatusType,
                    c.procreateStatus,
                    c.healthyStatusType,
                    c.ifBasicLivingAllowance,
                    c.graduateSchool,
                    c.degreeType,
                    c.enterpriseType,
                    c.hiredate,
                    c.post,
                    c.monthlyTotalIncome,
                    c.monthlyTotalExpenditure,
                    c.monthlyNetIncome,
                    c.totalAssets,
                    c.totalDebt,
                    netAssests = c.totalAssets - c.totalDebt,
                    c.ifCourtImplementation,
                    c.creditStatus
                }).First();
                string financierBasicDataStr = C101.FC10107(financierBasicData);

                string res = string.Format("{{\"financierBasicData\":{0},\"caseAmount\":{1},\"caseMoneyAmount\":{2},\"debtAmount\":{3},\"debtMoneyAmount\":{4},\"currentOverdueAmount\":{5},\"currentOverdueMoneyAmount\":{6},\"historyOverdueAmount\":{7},\"regDatetime\":{8}}}", financierBasicDataStr, caseAmount, caseMoneyAmount, debtAmount, debtMoneyAmount, currentOverdueAmount, currentOverdueMoneyAmount, historyOverdueAmount, regDatetimeStr);

                return(res);
            }
        }
示例#9
0
        public string FP90201(int pageSize)
        {
            //判断是否登录
            if (session["userSN"] == null)
            {
                return("notLogin");
            }

            string userSN = session["userSN"].ToString();

            using (DBMA1DataContext dbma1 = new DBMA1DataContext())
            {
                string userName = dbma1.U000s.Where(c => c.userSN == userSN).First().name;

                A028    a028             = dbma1.A028s.First();
                int     needPayDays      = Convert.ToInt32(a028.needPayDays);
                decimal overdueRateDaily = Convert.ToDecimal(a028.overdueRateDaily);

                var billList = (from c in dbma1.F001s
                                where c.payerUserSN == userSN &&
                                !c.F002s.Any()
                                orderby c.generateDate descending
                                select new
                {
                    c.billSN,
                    c.businessSN,
                    c.billType,
                    c.MoneyAmount,
                    c.generateDate,
                    needPayDate = c.generateDate.AddDays(needPayDays),
                    lateFee = (DateTime.Now - c.generateDate).Days > needPayDays ? c.MoneyAmount * overdueRateDaily * ((DateTime.Now - c.generateDate).Days - needPayDays) : 0
                }).Take(pageSize).ToList();

                return(string.Format("{{\"dataList\":{0},\"maxDatetime\":\"{1}\",\"userName\":\"{2}\",\"userSN\":\"{3}\"}}", C101.FC10107(billList), DateTime.Now, userName, userSN));
            }
        }
示例#10
0
        /// <summary>
        /// 投资
        /// </summary>
        public void FP10204(string financierUserSN, string crSN, decimal investMoneyAmount, DateTime investDate, DateTime dealineDate, string repaymentTypeSN, decimal dailyRate)
        {
            using (DBMA1DataContext dbma1 = new DBMA1DataContext())
            {
                //检查有效性(1、未被投资。2、债权未取消或者拒绝.)
                var data1 = dbma1.P102s.Where(c => c.creditRightSN == crSN).FirstOrDefault();
                if (data1 != null)
                {
                    return;
                }

                string reserveSN;
                var    reserveCrP203 = (from c in dbma1.P203s
                                        where c.creditRightSN == crSN &&
                                        c.senderCancelReserveDate == null &&
                                        c.receiverRefuseReserveDate == null
                                        select c).FirstOrDefault();
                if (reserveCrP203 == null)
                {
                    var reserveCrP100 = (from c in dbma1.P100s
                                         where c.creditRightSN == crSN &&
                                         c.senderCancelReserveDate == null &&
                                         c.receiverRefuseReserveDate == null
                                         select c).FirstOrDefault();
                    //债权已被取消或者拒绝
                    if (reserveCrP100 == null)
                    {
                        return;
                    }

                    reserveSN = reserveCrP100.reserveSN;
                }
                else
                {
                    reserveSN = reserveCrP203.reserveSN;
                }

                string investorUserSN = session["userSN"].ToString();

                string max33 = C101.FC10102("P102", 6, "C");
                P102   p102  = new P102();
                p102.investSN          = max33;
                p102.reserveSN         = reserveSN;
                p102.investorUserSN    = investorUserSN;
                p102.financierUserSN   = financierUserSN;
                p102.creditRightSN     = crSN;
                p102.investMoneyAmount = investMoneyAmount;
                p102.investDate        = investDate;
                p102.deadlineDate      = dealineDate;
                p102.repaymentTypeSN   = repaymentTypeSN;
                p102.dailyRate         = dailyRate;
                p102.verifyInvestDate  = DateTime.Now;
                dbma1.P102s.InsertOnSubmit(p102);

                //产生账单
                A024    a024    = dbma1.A024s.First();
                decimal feeRate = Convert.ToDecimal(a024.serviceRateDaily);
                decimal minRate = Convert.ToDecimal(a024.minServiceRateTotel);
                decimal maxRate = Convert.ToDecimal(a024.maxServiceRateTotel);

                int     loanDays   = (dealineDate - investDate).Days;
                int     loanMonth  = loanDays / 30 + (loanDays % 30 == 0 ? 0 : 1);
                decimal serverRate = Convert.ToDecimal(feeRate * Convert.ToDecimal(loanMonth));
                serverRate = serverRate < minRate ? minRate : serverRate;
                serverRate = serverRate > maxRate ? maxRate : serverRate;

                string F001max33SN = C101.FC10102("F001", 6, "L");
                F001   f001        = new F001();
                f001.billSN       = F001max33SN;
                f001.payerUserSN  = financierUserSN;
                f001.businessSN   = crSN;
                f001.billType     = "债权融资";
                f001.MoneyAmount  = serverRate * investMoneyAmount * 10000;
                f001.generateDate = DateTime.Now;
                dbma1.F001s.InsertOnSubmit(f001);

                //融资方历史信息
                U002   u002    = dbma1.U002s.Where(c => c.userSN == financierUserSN).First();
                P105   p105    = new P105();
                string max33SN = C101.FC10102("P105", 7, "CB");
                //案例情况
                var     caseStatus      = dbma1.P102s.Where(c => c.financierUserSN == financierUserSN);
                short   caseAmount      = Convert.ToInt16(caseStatus.Count());
                decimal caseMoneyAmount = caseAmount == 0 ? 0 : caseStatus.Sum(c => c.investMoneyAmount);

                //当前债务情况
                var     debtStatus      = dbma1.P102s.Where(c => c.financierUserSN == financierUserSN && c.closeCaseDate == null);
                short   debtAmount      = Convert.ToInt16(debtStatus.Count());
                decimal debtMoneyAmount = debtAmount == 0 ? 0 : debtStatus.Sum(c => c.investMoneyAmount);

                //当前逾期情况
                var currentOverdueStatus = from c in dbma1.P102s
                                           where c.financierUserSN == financierUserSN &&
                                           c.closeCaseDate == null &&
                                           DateTime.Now > c.deadlineDate
                                           select c;
                short   currentOverdueAmount      = Convert.ToInt16(currentOverdueStatus.Count());
                decimal currentOverdueMoneyAmount = currentOverdueAmount == 0 ? 0 : currentOverdueStatus.Sum(c => c.investMoneyAmount);

                //历史逾期数量
                var historyOverdueStatus = from c in dbma1.P102s
                                           from p in c.P103s
                                           where c.financierUserSN == financierUserSN &&
                                           c.deadlineDate < p.repayDate &&
                                           c.investSN == p.investSN
                                           select c;
                short historyOverdueAmount = Convert.ToInt16(historyOverdueStatus.Count());

                p105.financierHistoryInfoSN = max33SN;
                p105.creditRightSN          = crSN;
                p105.investSN                 = max33;
                p105.historyDate              = DateTime.Now;
                p105.userSN                   = u002.userSN;
                p105.name                     = u002.name;
                p105.birthday                 = u002.birthday;
                p105.gender                   = u002.gender;
                p105.registeredResidence      = u002.registeredResidence;
                p105.idCard                   = u002.idCard;
                p105.phone                    = u002.phone;
                p105.email                    = u002.email;
                p105.maritalStatusTypeSN      = u002.maritalStatusTypeSN;
                p105.procreateStatus          = u002.procreateStatus;
                p105.healthyStatusTypeSN      = u002.healthyStatusTypeSN;
                p105.ifBasicLivingAllowance   = u002.ifBasicLivingAllowance;
                p105.currentAddressProvinceSN = u002.currentAddressProvinceSN;
                p105.currentAddressCitySN     = u002.currentAddressCitySN;
                p105.currentAddressDetails    = u002.currentAddressDetails;
                p105.graduateSchool           = u002.graduateSchool;
                p105.degreeTypeSN             = u002.degreeTypeSN;
                p105.degreeCard               = u002.degreeCard;
                p105.friendName               = u002.friendName;
                p105.friendPhone              = u002.friendPhone;
                p105.spouseName               = u002.spouseName;
                p105.spousePhone              = u002.spousePhone;
                p105.spouseIdCard             = u002.spouseIdCard;
                p105.spouseEnterprise         = u002.spouseEnterprise;
                p105.kinName                  = u002.kinName;
                p105.kinRelationshipTypeSN    = u002.kinRelationshipTypeSN;
                p105.kinPhone                 = u002.kinPhone;
                p105.kinIdCard                = u002.kinIdCard;
                p105.kinEnterprise            = u002.kinEnterprise;
                p105.workEnterprise           = u002.workEnterprise;
                p105.enterpriseTypeSN         = u002.enterpriseTypeSN;
                p105.hiredate                 = u002.hiredate;
                p105.workTel                  = u002.workTel;
                p105.post                     = u002.post;
                p105.enterpriseSwitchboard    = u002.enterpriseSwitchboard;
                p105.enterpriseWebsite        = u002.enterpriseWebsite;
                p105.colleageName             = u002.colleageName;
                p105.colleagePhone            = u002.colleagePhone;
                p105.monthlyTotalIncome       = u002.monthlyTotalIncome;
                p105.monthlyTotalExpenditure  = u002.monthlyTotalExpenditure;
                p105.monthlyNetIncome         = u002.monthlyNetIncome;
                p105.totalAssets              = u002.totalAssets;
                p105.totalDebt                = u002.totalDebt;
                p105.ifCourtImplementation    = u002.ifCourtImplementation;
                p105.creditStatus             = u002.creditStatus;
                p105.caseAmount               = caseAmount;
                p105.caseMoneyAmount          = caseMoneyAmount;
                p105.currentDebtAmount        = debtAmount;
                p105.debtMoneyAmount          = debtMoneyAmount;
                p105.currentOverdue           = currentOverdueAmount;
                p105.overdueMoneyAmount       = currentOverdueMoneyAmount;
                p105.historyOverdueAmount     = historyOverdueAmount;
                dbma1.P105s.InsertOnSubmit(p105);

                dbma1.SubmitChanges();

                U003 u003 = dbma1.U003s.Where(c => c.userSN == financierUserSN).First();

                //如有邮箱提醒
                if (u003.billGenerate_email == true)
                {
                    SendBillEmail(dbma1, financierUserSN, crSN, f001.billSN, Convert.ToDecimal(f001.MoneyAmount));
                }

                //如有短信提醒
                if (u003.billGenerate_shortMessage == true)
                {
                    SendBillSM(dbma1, financierUserSN, crSN, f001.billSN, Convert.ToDecimal(f001.MoneyAmount));
                }

                dbma1.SubmitChanges();
            }
        }
示例#11
0
        public string FP90202(string billSN, string pwd)
        {
            string userSN = session["userSN"].ToString();

            //string userSN = "U00001";

            using (DBMA1DataContext dbma1 = new DBMA1DataContext())
            {
                //有效性检查(1、已经付款)
                var data1 = dbma1.F002s.Where(c => c.billSN == billSN).FirstOrDefault();
                if (data1 != null)
                {
                    return("true");
                }

                //验证交易密码是否正确
                string transPwd = dbma1.U003s.Where(c => c.userSN == userSN).First().transactPwd;
                if (C101.FC10104(pwd, transPwd) == false)
                {
                    return("false");
                }

                //从余额中扣除服务费 F000
                A028    a028             = dbma1.A028s.First();
                int     needPayDays      = Convert.ToInt32(a028.needPayDays);
                decimal overdueRateDaily = Convert.ToDecimal(a028.overdueRateDaily);

                F001    f001        = dbma1.F001s.Where(c => c.billSN == billSN).First();
                decimal moneyAmount = Convert.ToDecimal(f001.MoneyAmount);
                decimal lateFee     = Convert.ToDecimal((DateTime.Now - f001.generateDate).Days > needPayDays ? f001.MoneyAmount * overdueRateDaily * ((DateTime.Now - f001.generateDate).Days - needPayDays) : 0);
                decimal fee         = moneyAmount + lateFee;

                F000 f000 = dbma1.F000s.Where(c => c.userSN == userSN).First();
                if (f000.balance < fee)
                {
                    return("false");
                }
                f000.balance -= fee;

                //加入收支明细表中 F003
                string F003max33SN = C101.FC10102("F003", 8, "UA");
                F003   f003        = new F003();
                f003.revenueExpenditureSN = F003max33SN;
                f003.generetorUserSN      = userSN;
                f003.generateDate         = DateTime.Now;
                f003.type        = "资产出售账单";
                f003.expenditure = fee;
                f003.balance     = f000.balance;
                dbma1.F003s.InsertOnSubmit(f003);

                //加入付款表 F001
                string F002max33SN = C101.FC10102("F002", 6, "QA");
                F002   f002        = new F002();
                f002.paySN          = F002max33SN;
                f002.billSN         = billSN;
                f002.payMoneyAmount = fee;
                f002.payDate        = DateTime.Now;
                dbma1.F002s.InsertOnSubmit(f002);

                //加入成长值表 F006
                string F006Max33SN = C101.FC10102("F006", 7, "UD");
                F006   f006        = new F006();
                f006.groupUpSN              = F006Max33SN;
                f006.userSN                 = userSN;
                f006.businessSN             = F002max33SN;
                f006.businessType           = "账单付款";
                f006.transactionMoneyAmount = fee;
                f006.groupUpValue           = fee;
                f006.acquireDate            = DateTime.Now;
                dbma1.F006s.InsertOnSubmit(f006);

                dbma1.SubmitChanges();

                return("true");
            }
        }
示例#12
0
        //0:成功; 1:岗位已经删除
        public string FM100401(string roleSN)
        {
            using (DBMA1DataContext dbma1 = new DBMA1DataContext())
            {
                //岗位已经删除
                var dataVarify = dbma1.B004s.Where(c => c.roleTypeSN == roleSN && c.deleteDate == null).FirstOrDefault();
                if (dataVarify == null)
                {
                    return("{\"status\":\"1\"}");
                }

                //属于该岗位的用户
                var data1 = from c in dbma1.B003s.Where(c => c.roleTypeSN == roleSN && c.deleteDate == null)
                            from o in dbma1.internal_users.Where(o => o.internal_user_id == c.internalUserSN)
                            select new
                {
                    o.work_num,
                    o.name,
                    o.gender,
                    o.department_name,
                    o.jobs,
                    o.internal_user_id,
                    o.fk_user_group_id
                };
                var dataUse = (from c in data1
                               join p in dbma1.user_groups on c.fk_user_group_id equals p.user_group_id into g
                               from p in g.DefaultIfEmpty()
                               select new
                {
                    c.work_num,
                    c.name,
                    c.gender,
                    c.department_name,
                    c.jobs,
                    p.user_group_name,
                    c.internal_user_id
                }).ToList();

                //未分配岗位的用户
                var dataNotUse = (from o in dbma1.internal_users.Where(o => !dbma1.B003s.Where(c => c.deleteDate == null && c.internalUserSN == o.internal_user_id).Any())
                                  join p in dbma1.user_groups on o.fk_user_group_id equals p.user_group_id into g
                                  from p in g.DefaultIfEmpty()
                                  select new
                {
                    o.work_num,
                    o.name,
                    o.gender,
                    o.department_name,
                    o.jobs,
                    p.user_group_name,
                    o.internal_user_id
                }).ToList();

                return(string.Format("{{\"status\":\"0\",\"dataUse\":{0},\"dataNotUse\":{1}}}", C101.FC10107(dataUse), C101.FC10107(dataNotUse)));
            }
        }
示例#13
0
        /// <summary>
        /// 融资方发出预约
        /// </summary>
        public string FP20109(string pwd, string investorUserSN, string crSN)
        {
            using (DBMA1DataContext dbma1 = new DBMA1DataContext())
            {
                string financierUserSN = session["userSN"].ToString();
                //string financierUserSN = "U00001";

                //检查有效性(1、债权没有被取消。2、债权没有被预约)
                var data1 = dbma1.P200s.Where(c => c.creditRightSN == crSN && c.cancelDate != null).FirstOrDefault();
                var data2 = dbma1.P203s.Where(c => c.creditRightSN == crSN && c.senderCancelReserveDate == null && c.receiverRefuseReserveDate == null).FirstOrDefault();
                var data3 = dbma1.P100s.Where(c => c.creditRightSN == crSN && c.senderCancelReserveDate == null && c.receiverRefuseReserveDate == null).FirstOrDefault();
                if (data1 != null || data2 != null || data3 != null)
                {
                    return("false");
                }

                //验证交易密码是否正确
                string transPwd = dbma1.U003s.Where(c => c.userSN == financierUserSN).First().transactPwd;

                if (C101.FC10104(pwd, transPwd) == false)
                {
                    return("false");
                }

                //从余额中扣除服务费 F000
                A024    a024 = dbma1.A024s.First();
                decimal investorRecommendCost = Convert.ToDecimal(a024.investorRecommendCost);

                F000 f000 = dbma1.F000s.Where(c => c.userSN == financierUserSN).First();
                if (f000.balance < investorRecommendCost)
                {
                    return("false");
                }
                f000.balance -= investorRecommendCost;

                //加入收支明细表中 F003
                string F003max33SN = C101.FC10102("F003", 8, "UA");
                F003   f003        = new F003();
                f003.revenueExpenditureSN = F003max33SN;
                f003.generetorUserSN      = financierUserSN;
                f003.generateDate         = DateTime.Now;
                f003.type        = "投资方推荐";
                f003.expenditure = investorRecommendCost;
                f003.balance     = f000.balance;
                dbma1.F003s.InsertOnSubmit(f003);

                //债权预约表添加记录 P203
                string max33SN = C101.FC10102("P203", 7, "F");
                P203   p203    = new P203();
                p203.reserveSN      = max33SN;
                p203.senderUserSN   = financierUserSN;
                p203.receiverUserSN = investorUserSN;
                p203.creditRightSN  = crSN;
                p203.sendDate       = DateTime.Now;
                dbma1.P203s.InsertOnSubmit(p203);

                //加入成长值表 F006
                string F006Max33SN = C101.FC10102("F006", 7, "UD");
                F006   f006        = new F006();
                f006.groupUpSN              = F006Max33SN;
                f006.userSN                 = financierUserSN;
                f006.businessSN             = max33SN;
                f006.businessType           = "投资方推荐";
                f006.transactionMoneyAmount = investorRecommendCost;
                f006.groupUpValue           = investorRecommendCost;
                f006.acquireDate            = DateTime.Now;
                dbma1.F006s.InsertOnSubmit(f006);

                dbma1.SubmitChanges();

                U003 u003 = dbma1.U003s.Where(c => c.userSN == investorUserSN).First();

                //如有邮箱提醒
                if (u003.billGenerate_email == true)
                {
                    SendByEmail(dbma1, investorUserSN, crSN);
                }
                //如有短信提醒
                if (u003.billGenerate_shortMessage == true)
                {
                    SendBySM(dbma1, investorUserSN, crSN);
                }

                dbma1.SubmitChanges();

                return("true");
            }
        }
示例#14
0
        public string FP70101()
        {
            //判断是否登录
            if (session["userSN"] == null)
            {
                return("notLogin");
            }

            string userSN = session["userSN"].ToString();

            using (DBMA1DataContext dbma1 = new DBMA1DataContext())
            {
                //用户名
                string userName = dbma1.U000s.Where(c => c.userSN == userSN).First().name;

                //vip等级设置
                A029   a029    = dbma1.A029s.First();
                string a029Str = C101.FC10107(a029);

                //当前成长值
                decimal currentGroupValue = Convert.ToInt32(dbma1.F006s.Where(c => c.userSN == userSN).Sum(c => c.groupUpValue));

                //当前vip等级及奖励率
                string  vipLevel = string.Empty;
                decimal rewardRate;
                if (currentGroupValue < a029.vip1_originateValue)
                {
                    vipLevel   = "0";
                    rewardRate = 0;
                }
                else if (currentGroupValue < a029.vip2_originateValue)
                {
                    vipLevel   = "1";
                    rewardRate = a029.vip1_rewardRate;
                }
                else if (currentGroupValue < a029.vip3_originateValue)
                {
                    vipLevel   = "2";
                    rewardRate = a029.vip2_rewardRate;
                }
                else if (currentGroupValue < a029.vip4_originateValue)
                {
                    vipLevel   = "3";
                    rewardRate = a029.vip3_rewardRate;
                }
                else if (currentGroupValue < a029.vip5_originateValue)
                {
                    vipLevel   = "4";
                    rewardRate = a029.vip4_rewardRate;
                }
                else if (currentGroupValue < a029.vip6_originateValue)
                {
                    vipLevel   = "5";
                    rewardRate = a029.vip5_rewardRate;
                }
                else if (currentGroupValue < a029.vip7_originateValue)
                {
                    vipLevel   = "6";
                    rewardRate = a029.vip6_rewardRate;
                }
                else
                {
                    vipLevel   = "7";
                    rewardRate = a029.vip7_rewardRate;
                }

                //已奖励的V币
                int rewardV = Convert.ToInt32
                              (
                    (from c in dbma1.F004s
                     where c.userSN == userSN &&
                     c.rewardType == "充值奖励"
                     select c.rewardAmount).Sum()
                              );

                return(string.Format("{{\"userName\":\"{0}\",\"vipConfig\":{1},\"currentGroupValue\":\"{2}\",\"vipLevel\":\"{3}\",\"rewardRate\":\"{4}\",\"rewardV\":\"{5}\",\"userSN\":\"{6}\"}}", userName, a029Str, currentGroupValue, vipLevel, rewardRate, rewardV, userSN));
            }
        }
示例#15
0
        /// <summary>
        /// 获得顾问隐藏后信息
        /// </summary>
        public string FP10211(string consultantUserSN, int ifVisiable)
        {
            using (DBMA1DataContext dbma1 = new DBMA1DataContext())
            {
                string consultantBasicDataStr = null;

                //传递隐藏信息
                if (ifVisiable == 0)
                {
                    //基本信息
                    var consultantBasicData = (from c in dbma1.VP801001s
                                               where c.userSN == consultantUserSN
                                               select new
                    {
                        c.userSN,
                        c.birthday,
                        c.gender,
                        c.registeredResidence,
                        idCard = c.idCard.Substring(0, 6),
                        c.maritalStatusType,
                        c.procreateStatus,
                        c.graduateSchool,
                        c.degreeType,
                        c.industryType,
                        c.enterpriseType,
                        c.serviceProvince,
                        c.serviceCity,
                        c.investigate,
                        c.assetsEvaluate,
                        c.badLoanCollect,
                        c.creditRightGuarantee,
                        c.consultantDetails
                    }).First();

                    consultantBasicDataStr = C101.FC10107(consultantBasicData);
                }
                else
                {
                    //基本信息
                    var consultantBasicData = (from c in dbma1.VP801001s
                                               where c.userSN == consultantUserSN
                                               select new
                    {
                        c.userSN,
                        c.name,
                        c.birthday,
                        c.gender,
                        c.registeredResidence,
                        idCard = c.idCard.Substring(0, 6),
                        c.phone,
                        c.email,
                        c.maritalStatusType,
                        c.procreateStatus,
                        c.currentAddressProvince,
                        c.currentAddressCity,
                        c.currentAddressDetails,
                        c.graduateSchool,
                        c.degreeType,
                        c.industryType,
                        c.enterpriseType,
                        c.serviceProvince,
                        c.serviceCity,
                        c.investigate,
                        c.assetsEvaluate,
                        c.badLoanCollect,
                        c.creditRightGuarantee,
                        c.consultantDetails
                    }).First();

                    consultantBasicDataStr = C101.FC10107(consultantBasicData);
                }



                //注册时间
                DateTime regDatetime    = dbma1.U000s.Where(c => c.userSN == consultantUserSN).First().registerDate;
                string   regDatetimeStr = C101.FC10107(regDatetime);

                //案例数量
                int caseAmount = (from c in dbma1.P500s
                                  where c.consultantUserSN == consultantUserSN
                                  select c).Count();

                //成功案例
                int successCaseAmount = (from c in dbma1.P102s
                                         join o in dbma1.P103s.Where(oo => oo.ifOverdue == false) on c.investSN equals o.investSN
                                         join p in dbma1.P500s.Where(pp => pp.consultantUserSN == consultantUserSN && pp.auditStatus == true) on c.reserveSN equals p.reserveSN
                                         select c).Count();

                //当前坏账
                int currentBadLoanCaseAmount = (from c in dbma1.P500s.Where(cc => cc.consultantUserSN == consultantUserSN && cc.auditStatus != false)
                                                join o in dbma1.P102s.Where(oo => oo.closeCaseDate == null && oo.deadlineDate.Date < DateTime.Now.Date)
                                                on c.reserveSN equals o.reserveSN
                                                select c).Count();

                //历史坏账
                int historyBadLoanCaseAmount = (from c in dbma1.P102s
                                                join o in dbma1.P103s.Where(oo => oo.ifOverdue == true) on c.investSN equals o.investSN
                                                join p in dbma1.P500s.Where(pp => pp.consultantUserSN == consultantUserSN && pp.auditStatus != false) on c.reserveSN equals p.reserveSN
                                                select c).Count();

                //坏账数量
                int badLoanCaseAmount = currentBadLoanCaseAmount + historyBadLoanCaseAmount;

                return(string.Format("{{\"consultantBasicData\":{0},\"regDatetime\":{1},\"caseAmount\":\"{2}\",\"successCaseAmount\":\"{3}\",\"badLoanCaseAmount\":\"{4}\",\"currentBadLoanCaseAmount\":\"{5}\"}}", consultantBasicDataStr, regDatetimeStr, caseAmount, successCaseAmount, badLoanCaseAmount, currentBadLoanCaseAmount));
            }
        }
示例#16
0
        /// <summary>
        /// 投资方债权预约
        /// </summary>
        public string FP10107(string pwd, string crSN, string financierUserSN)
        {
            string investorSN = session["userSN"].ToString();

            //string investorSN = "U00002";

            using (DBMA1DataContext dbma1 = new DBMA1DataContext())
            {
                //预约失效
                if (dbma1.VP101001s.Where(c => c.creditRightSN == crSN).FirstOrDefault() == null)
                {
                    return("false");
                }

                //验证交易密码是否正确
                string transPwd = dbma1.U003s.Where(c => c.userSN == investorSN).First().transactPwd;

                if (C101.FC10104(pwd, transPwd) == false)
                {
                    return("false");
                }

                //从余额中扣除服务费 F000
                A023    a023       = dbma1.A023s.First();
                decimal reserveFee = Convert.ToDecimal(a023.financingReserveCost);

                F000 f000 = dbma1.F000s.Where(c => c.userSN == investorSN).First();
                if (f000.balance < reserveFee)
                {
                    return("false");
                }
                f000.balance -= reserveFee;

                //加入收支明细表中 F003
                string F003max33SN = C101.FC10102("F003", 8, "UA");
                F003   f003        = new F003();
                f003.revenueExpenditureSN = F003max33SN;
                f003.generetorUserSN      = investorSN;
                f003.generateDate         = DateTime.Now;
                f003.type        = "债权预约";
                f003.expenditure = reserveFee;
                f003.balance     = f000.balance;
                dbma1.F003s.InsertOnSubmit(f003);

                //预约
                string max33SN = C101.FC10102("P100", 7, "A");
                P100   p100    = new P100();
                p100.reserveSN      = max33SN;
                p100.senderUserSN   = investorSN;
                p100.receiverUserSN = financierUserSN;
                p100.creditRightSN  = crSN;
                p100.sendDate       = DateTime.Now;
                dbma1.P100s.InsertOnSubmit(p100);

                //加入成长值表 F006
                string F006Max33SN = C101.FC10102("F006", 7, "UD");
                F006   f006        = new F006();
                f006.groupUpSN              = F006Max33SN;
                f006.userSN                 = investorSN;
                f006.businessSN             = max33SN;
                f006.businessType           = "债权预约";
                f006.transactionMoneyAmount = reserveFee;
                f006.groupUpValue           = reserveFee;
                f006.acquireDate            = DateTime.Now;
                dbma1.F006s.InsertOnSubmit(f006);

                dbma1.SubmitChanges();

                U003 u003 = dbma1.U003s.Where(c => c.userSN == financierUserSN).First();

                //如有邮箱提醒
                if (u003.billGenerate_email == true)
                {
                    SendByEmail(dbma1, financierUserSN, crSN);
                }
                //如有短信提醒
                if (u003.billGenerate_shortMessage == true)
                {
                    SendBySM(dbma1, financierUserSN, crSN);
                }

                dbma1.SubmitChanges();

                return("true");
            }
        }
示例#17
0
        /// <summary>
        /// 获得顾问隐藏的信息
        /// 0:操作失败 不返回失败原因;1:操作成功;2;操作失败 失败原因余额不足
        /// </summary>
        public string FP10213(string pwd, string consultantUserSN, string crSN)
        {
            string investorUserSN = session["userSN"].ToString();

            //string investorUserSN = "U00002";

            using (DBMA1DataContext dbma1 = new DBMA1DataContext())
            {
                //检查有效性(1、没有被投资。2、债权已经被取消或者拒绝)
                var data1 = dbma1.P102s.Where(c => c.creditRightSN == crSN).FirstOrDefault();
                var data2 = (from c in dbma1.P203s
                             where c.creditRightSN == crSN &&
                             c.senderCancelReserveDate == null &&
                             c.receiverRefuseReserveDate == null
                             select c).FirstOrDefault();
                var data3 = (from c in dbma1.P100s
                             where c.creditRightSN == crSN &&
                             c.senderCancelReserveDate == null &&
                             c.receiverRefuseReserveDate == null
                             select c).FirstOrDefault();
                if (data1 != null || (data2 == null && data3 == null))
                {
                    return("0");
                }

                ///验证交易密码是否正确
                string transPwd = dbma1.U003s.Where(c => c.userSN == investorUserSN).First().transactPwd;

                if (C101.FC10104(pwd, transPwd) == false)
                {
                    return("0");
                }

                //从余额中扣除服务费 F000
                A023    a023 = dbma1.A023s.First();
                decimal fee  = Convert.ToDecimal(a023.consultantReserveCost);

                F000 f000 = dbma1.F000s.Where(c => c.userSN == investorUserSN).First();
                if (f000.balance < fee)
                {
                    return("2");
                }
                f000.balance -= fee;

                //加入收支明细表中 F003
                string F003max33SN = C101.FC10102("F003", 8, "UA");
                F003   f003        = new F003();
                f003.revenueExpenditureSN = F003max33SN;
                f003.generetorUserSN      = investorUserSN;
                f003.generateDate         = DateTime.Now;
                f003.type        = "顾问预约";
                f003.expenditure = fee;
                f003.balance     = f000.balance;
                dbma1.F003s.InsertOnSubmit(f003);

                //获取隐藏信息
                var consultantBasicData = (from c in dbma1.VP801001s
                                           where c.userSN == consultantUserSN
                                           select new
                {
                    c.name,
                    idCard = c.idCard.Substring(0, 6),
                    c.phone,
                    c.email,
                    c.currentAddressProvince,
                    c.currentAddressCity,
                    c.currentAddressDetails
                }).First();
                string consultantBasicDataStr = C101.FC10107(consultantBasicData);

                //添加一条投资方查看顾问信息资格表记录,P104
                string max33SN = AddRecord(dbma1, investorUserSN, consultantUserSN, crSN);

                //加入成长值表 F006
                string F006Max33SN = C101.FC10102("F006", 7, "UD");
                F006   f006        = new F006();
                f006.groupUpSN              = F006Max33SN;
                f006.userSN                 = investorUserSN;
                f006.businessSN             = max33SN;
                f006.businessType           = "顾问预约";
                f006.transactionMoneyAmount = fee;
                f006.groupUpValue           = fee;
                f006.acquireDate            = DateTime.Now;
                dbma1.F006s.InsertOnSubmit(f006);

                dbma1.SubmitChanges();

                return(string.Format("{{\"status\":\"{0}\",\"consultantHideData\":{1}}}", 1, consultantBasicDataStr));
            }
        }
示例#18
0
        //0:成功。1:密码错误。2:余额不足。 3:资产已被取消。4:资产已被预约
        public string FP40201(string assetsSN, string pwd)
        {
            string userSN = session["userSN"].ToString();

            using (DBMA1DataContext dbma1 = new DBMA1DataContext())
            {
                //有效性检查(1、已被取消。2、已被预约)
                var data1 = dbma1.P300s.Where(c => c.assetsSN == assetsSN && c.cancelDate != null).FirstOrDefault();
                var data2 = dbma1.P400s.Where(c => c.assetsSN == assetsSN && c.senderCancelReserveDate == null && c.receiverRefuseReserveDate == null).FirstOrDefault();
                if (data1 != null)
                {
                    return("3");
                }
                if (data2 != null)
                {
                    return("4");
                }

                //密码是否正确
                if (C201.FC20146(dbma1, userSN, pwd) == false)
                {
                    return("1");
                }

                //余额是否充足
                decimal assetsReserveFee = Convert.ToDecimal(dbma1.A026s.First().assetsReserveCost);
                //扣款
                if (C201.FC20147(dbma1, userSN, assetsReserveFee, "资产预约", null) == false)
                {
                    return("2");
                }

                //加入资产预约表 P400
                string sellerUserSN = dbma1.P300s.Where(c => c.assetsSN == assetsSN).First().publisherUserSN;
                string max33SN      = C101.FC10102("P400", 7, "H");
                P400   p400         = new P400();
                p400.reserveSN      = max33SN;
                p400.senderUserSN   = userSN;
                p400.receiverUserSN = sellerUserSN;
                p400.assetsSN       = assetsSN;
                p400.reserveDate    = DateTime.Now;
                dbma1.P400s.InsertOnSubmit(p400);

                //加入成长值表 F006
                F006 f006 = new F006();
                f006.groupUpSN              = C101.FC10102("F006", 7, "UD");
                f006.userSN                 = userSN;
                f006.businessSN             = max33SN;
                f006.businessType           = "资产预约";
                f006.transactionMoneyAmount = assetsReserveFee;
                f006.groupUpValue           = assetsReserveFee;
                f006.acquireDate            = DateTime.Now;
                dbma1.F006s.InsertOnSubmit(f006);

                dbma1.SubmitChanges();

                U003 u003 = dbma1.U003s.Where(c => c.userSN == sellerUserSN).First();

                //如有邮箱提醒
                if (u003.billGenerate_email == true)
                {
                    ReserveSendByEmail(dbma1, sellerUserSN, assetsSN);
                }
                //如有短信提醒
                if (u003.billGenerate_shortMessage == true)
                {
                    ReserveSendBySM(dbma1, sellerUserSN, assetsSN);
                }

                dbma1.SubmitChanges();

                return("0");
            }
        }
示例#19
0
        /// <summary>
        /// 确认预约财务顾问
        /// </summary>
        public void FP10301(string consultantUserSN, string crSN, decimal quotePricePercent)
        {
            string investorUserSN = session["userSN"].ToString();

            //string investorUserSN = "U00002";

            using (DBMA1DataContext dbma1 = new DBMA1DataContext())
            {
                //检查有效性(1、没有被投资。)
                var data1 = dbma1.P102s.Where(c => c.creditRightSN == crSN).FirstOrDefault();
                if (data1 != null)
                {
                    return;
                }

                //获取reserveSN
                string crReserveSN = string.Empty;

                var linqData1 = (from c in dbma1.P203s
                                 where c.creditRightSN == crSN &&
                                 c.senderCancelReserveDate == null &&
                                 c.receiverRefuseReserveDate == null
                                 select c).FirstOrDefault();
                if (linqData1 == null)
                {
                    var linqData2 = (from c in dbma1.P100s
                                     where c.creditRightSN == crSN &&
                                     c.senderCancelReserveDate == null &&
                                     c.receiverRefuseReserveDate == null
                                     select c).FirstOrDefault();

                    if (linqData2 == null)
                    {
                        return;
                    }

                    crReserveSN = linqData2.reserveSN;
                }
                else
                {
                    crReserveSN = linqData1.reserveSN;
                }

                string max33SN = C101.FC10102("P101", 7, "B");

                P101 p101 = new P101();
                p101.reserveSN            = max33SN;
                p101.creditRightReserveSN = crReserveSN;
                p101.senderUserSN         = investorUserSN;
                p101.receiverUserSN       = consultantUserSN;
                p101.creditRightSN        = crSN;
                p101.costPercent          = quotePricePercent;
                p101.sendTime             = DateTime.Now;
                dbma1.P101s.InsertOnSubmit(p101);
                dbma1.SubmitChanges();

                U003 u003 = dbma1.U003s.Where(c => c.userSN == consultantUserSN).First();

                //如有邮箱提醒
                if (u003.billGenerate_email == true)
                {
                    SendByEmail(dbma1, consultantUserSN, investorUserSN);
                }
                //如有短信提醒
                if (u003.billGenerate_shortMessage == true)
                {
                    SendBySM(dbma1, consultantUserSN, investorUserSN);
                }

                dbma1.SubmitChanges();
            }
        }
示例#20
0
        public string FINIT(int pageSize)
        {
            string pawnStr     = string.Empty;
            string dataListStr = string.Empty;

            using (DBBC1DataContext dbbc1 = new DBBC1DataContext())
            {
                //数据
                var dataList = dbbc1.B200s.Take(pageSize).ToList();
                dataListStr = C101.FC10107(dataList);

                using (DBBS1DataContext dbbs1 = new DBBS1DataContext())
                {
                    //uip
                    pawnStr = C102.FC20108(dbbs1);

                    //服务状态
                    string serverStatusListStr = GetServerStatusList(dataList);

                    return(string.Format("{{\"dataList\":{0},\"serverStatusList\":{1},\"pawn\":{2}}}", C101.FC10107(dataList), serverStatusListStr, pawnStr));
                }
            }
        }
示例#21
0
        public string FP10208(string crSN, string consultantUserSN)
        {
            string investorUserSN = session["userSN"].ToString();

            //string investorUserSN = "U00002";

            using (DBMA1DataContext dbma1 = new DBMA1DataContext())
            {
                //基本信息
                var consultantBasicData = (from c in dbma1.VP801001s
                                           where c.userSN == consultantUserSN
                                           select new
                {
                    c.userSN,
                    c.name,
                    c.birthday,
                    c.gender,
                    c.registeredResidence,
                    idCard = c.idCard.Substring(0, 6),
                    c.phone,
                    c.email,
                    c.maritalStatusType,
                    c.procreateStatus,
                    c.currentAddressProvince,
                    c.currentAddressCity,
                    c.currentAddressDetails,
                    c.graduateSchool,
                    c.degreeType,
                    c.industryType,
                    c.enterpriseType,
                    c.serviceProvince,
                    c.serviceCity,
                    c.investigate,
                    c.assetsEvaluate,
                    c.badLoanCollect,
                    c.creditRightGuarantee,
                    c.consultantDetails
                }).First();
                string consultantBasicDataStr = C101.FC10107(consultantBasicData);

                //注册时间
                DateTime regDatetime    = dbma1.U000s.Where(c => c.userSN == consultantUserSN).First().registerDate;
                string   regDatetimeStr = C101.FC10107(regDatetime);

                //案例数量
                int caseAmount = (from c in dbma1.P500s
                                  where c.consultantUserSN == consultantUserSN
                                  select c).Count();

                //成功案例
                int successCaseAmount = (from c in dbma1.P102s
                                         join o in dbma1.P103s.Where(oo => oo.ifOverdue == false) on c.investSN equals o.investSN
                                         join p in dbma1.P500s.Where(pp => pp.consultantUserSN == consultantUserSN && pp.auditStatus == true) on c.reserveSN equals p.reserveSN
                                         select c).Count();

                //当前坏账
                int currentBadLoanCaseAmount = (from c in dbma1.P500s.Where(cc => cc.consultantUserSN == consultantUserSN && cc.auditStatus != false)
                                                join o in dbma1.P102s.Where(oo => oo.closeCaseDate == null && oo.deadlineDate.Date < DateTime.Now.Date)
                                                on c.reserveSN equals o.reserveSN
                                                select c).Count();

                //历史坏账
                int historyBadLoanCaseAmount = (from c in dbma1.P102s
                                                join o in dbma1.P103s.Where(oo => oo.ifOverdue == true) on c.investSN equals o.investSN
                                                join p in dbma1.P500s.Where(pp => pp.consultantUserSN == consultantUserSN && pp.auditStatus != false) on c.reserveSN equals p.reserveSN
                                                select c).Count();

                //坏账数量
                int badLoanCaseAmount = currentBadLoanCaseAmount + historyBadLoanCaseAmount;

                //报价
                decimal quotePricePercent = (from c in dbma1.P101s
                                             where c.senderUserSN == investorUserSN &&
                                             c.receiverUserSN == consultantUserSN &&
                                             c.creditRightSN == crSN &&
                                             c.senderCancelReserveDate == null
                                             select c).OrderByDescending(c => c.sendTime).First().costPercent;

                decimal financingMoneyAmount = (from c in dbma1.P200s
                                                where c.creditRightSN == crSN
                                                select c).First().financingAmount;

                decimal quotePrice = financingMoneyAmount * quotePricePercent;

                return(string.Format("{{\"consultantBasicData\":{0},\"regDatetime\":{1},\"caseAmount\":\"{2}\",\"successCaseAmount\":\"{3}\",\"badLoanCaseAmount\":\"{4}\",\"currentBadLoanCaseAmount\":\"{5}\",\"quotePrice\":\"{6}\"}}", consultantBasicDataStr, regDatetimeStr, caseAmount, successCaseAmount, badLoanCaseAmount, currentBadLoanCaseAmount, quotePrice));
            }
        }
示例#22
0
        public void FP90110(string billNo, decimal amount, string ifSuc, string ipsBillNo, string bankBillNo, string userSN)
        {
            using (DBMA1DataContext dbma1 = new DBMA1DataContext())
            {
                //获得vip奖励比率
                //decimal rewardRate = 1;
                decimal rewardRate = C201.FC20152(dbma1, userSN);

                //充值记录表 F005
                F005 f005 = dbma1.F005s.Where(c => c.rechargeSN == billNo).First();
                f005.ifSuccess  = ifSuc == "Y" ? true : false;
                f005.ipsBillNo  = ipsBillNo;
                f005.bankBillNo = bankBillNo;

                if (ifSuc == "Y")
                {
                    //充值写入余额表 F000
                    F000 f000 = dbma1.F000s.Where(c => c.userSN == userSN).First();
                    f000.balance += amount;

                    //充值写入流水明细表 F003
                    F003 f003_1 = new F003();
                    f003_1.revenueExpenditureSN = C101.FC10102("F003", 8, "UA");
                    f003_1.generetorUserSN      = userSN;
                    f003_1.generateDate         = DateTime.Now;
                    f003_1.type    = "账户充值";
                    f003_1.revenue = amount;
                    f003_1.balance = f000.balance;
                    f003_1.referSN = f005.rechargeSN;
                    dbma1.F003s.InsertOnSubmit(f003_1);

                    if (rewardRate > 0)
                    {
                        //奖励表 F004
                        F004 f004 = new F004();
                        f004.rewardSN     = C101.FC10102("F004", 7, "UB");
                        f004.userSN       = userSN;
                        f004.rewardAmount = amount * rewardRate;
                        f004.rewardDate   = DateTime.Now;
                        f004.referSN      = billNo;
                        f004.rewardType   = "充值奖励";
                        dbma1.F004s.InsertOnSubmit(f004);

                        //奖励写入余额表 F000
                        f000.balance += Convert.ToDecimal(f004.rewardAmount);

                        //奖励写入流水明细表 F003
                        F003 f003_2 = new F003();
                        f003_2.revenueExpenditureSN = C101.FC10102("F003", 8, "UA");
                        f003_2.generetorUserSN      = userSN;
                        f003_2.generateDate         = DateTime.Now;
                        f003_2.type    = "充值奖励";
                        f003_2.revenue = f004.rewardAmount;
                        f003_2.balance = f000.balance;
                        f003_2.referSN = f004.rewardSN;

                        dbma1.F003s.InsertOnSubmit(f003_2);
                    }
                }

                dbma1.SubmitChanges();
            }
        }
示例#23
0
        public string FINIT(int pageSize)
        {
            using (DBBC1DataContext dbbc1 = new DBBC1DataContext())
            {
                //数据
                var dataList = dbbc1.B100s.Take(pageSize).ToList();

                //服务状态
                string serverStatusListStr = GetServerStatusList(dataList);

                return(string.Format("{{\"dataList\":{0},\"serverStatusList\":{1}}}", C101.FC10107(dataList), serverStatusListStr));
            }
        }
示例#24
0
        public string FM0204INIT(int pageSize)
        {
            using (DBBC1DataContext dbbc1 = new DBBC1DataContext())
            {
                //数据
                var dataList = dbbc1.B400s.Take(pageSize).ToList();

                using (DBBS1DataContext dbbs1 = new DBBS1DataContext())
                {
                    //服务状态
                    string serverStatusListStr = GetServerStatusList(dataList);

                    //申请状态
                    string applyStatusListStr = GetApplyStatusList(dbbs1, dataList);

                    return(string.Format("{{\"dataList\":{0},\"serverStatusList\":{1},\"applyStatusList\":{2}}}", C101.FC10107(dataList), serverStatusListStr, applyStatusListStr));
                }
            }
        }
示例#25
0
        /// <summary>
        /// 发布债权
        /// </summary>
        public string FP20103(string financingData, string pawnData, string enterpriseData, string pwd)
        {
            using (DBMA1DataContext dbma1 = new DBMA1DataContext())
            {
                string userSN = session["userSN"].ToString();

                //验证交易密码是否正确
                string transPwd = dbma1.U003s.Where(c => c.userSN == userSN).First().transactPwd;

                if (C101.FC10104(pwd, transPwd) == false)
                {
                    return("false");
                }

                //从余额中扣除服务费 F000
                A024    a024       = dbma1.A024s.First();
                decimal publishFee = Convert.ToDecimal(a024.financePublishCost);

                F000 f000 = dbma1.F000s.Where(c => c.userSN == userSN).First();
                if (f000.balance < publishFee)
                {
                    return("false");
                }
                f000.balance -= publishFee;

                //加入收支明细表中 F003
                string max33SN = C101.FC10102("F003", 8, "UA");
                F003   f003    = new F003();
                f003.revenueExpenditureSN = max33SN;
                f003.generetorUserSN      = userSN;
                f003.generateDate         = DateTime.Now;
                f003.type        = "债权发布";
                f003.expenditure = publishFee;
                f003.balance     = f000.balance;
                dbma1.F003s.InsertOnSubmit(f003);

                //债权
                P200 p200 = Comm.C101.FC10108(financingData, typeof(P200)) as P200;
                p200.creditRightSN   = C101.FC10102("P200", 6, "E");
                p200.publisherUserSN = userSN;
                //p200.publisherUserSN = "U00001";
                p200.publishDate = DateTime.Now;
                dbma1.P200s.InsertOnSubmit(p200);

                //抵押物
                if (pawnData != "null")
                {
                    P201 p201 = Comm.C101.FC10108(pawnData, typeof(P201)) as P201;
                    p201.assetsSN      = C101.FC10102("P201", 6, "FA");
                    p201.creditRightSN = p200.creditRightSN;
                    dbma1.P201s.InsertOnSubmit(p201);
                }

                //企业
                if (enterpriseData != "null")
                {
                    P202 p202 = Comm.C101.FC10108(enterpriseData, typeof(P202)) as P202;
                    p202.enterpriseSN  = C101.FC10102("P202", 6, "FB");
                    p202.creditRightSN = p200.creditRightSN;
                    dbma1.P202s.InsertOnSubmit(p202);
                }

                //加入成长值表 F006
                string F006Max33SN = C101.FC10102("F006", 7, "UD");
                F006   f006        = new F006();
                f006.groupUpSN              = F006Max33SN;
                f006.userSN                 = userSN;
                f006.businessSN             = p200.creditRightSN;
                f006.businessType           = "债权发布";
                f006.transactionMoneyAmount = publishFee;
                f006.groupUpValue           = publishFee;
                f006.acquireDate            = DateTime.Now;
                dbma1.F006s.InsertOnSubmit(f006);

                dbma1.SubmitChanges();

                var creditRight = dbma1.VP201001s.Where(c => c.creditRightSN == p200.creditRightSN).First();

                return(C101.FC10107(creditRight));
            }
        }