コード例 #1
0
ファイル: CP803.cs プロジェクト: waterStone528/job
        //1:修改成功;0:操作失败 不返回结果:2:验证码不正确;
        public int FP80310(string IC, string newPwd)
        {
            string userSN = session["userSN"].ToString();

            //string userSN = "U00001";

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

                //检测验证码
                if (IfIdentifyingCodeCorrect(dbma1, phone, IC, "修改交易密码") == false)
                {
                    return(2);
                }

                //修改交易密码
                string newPwdMd5 = C101.FC10103(newPwd);
                U003   u003      = dbma1.U003s.Where(c => c.userSN == userSN).First();
                u003.transactPwd         = newPwdMd5;
                u003.ifChangeTransactPwd = true;

                dbma1.SubmitChanges();

                return(1);
            }
        }
コード例 #2
0
ファイル: CP402.cs プロジェクト: waterStone528/job
        public void FP40205(string reserveSN, decimal purcharsePrice)
        {
            string userSN = session["userSN"].ToString();

            using (DBMA1DataContext dbma1 = new DBMA1DataContext())
            {
                //有效性检查(1、已被取消或者拒绝。2、已被购买)
                var data1 = dbma1.P400s.Where(c => c.reserveSN == reserveSN && (c.senderCancelReserveDate != null || c.receiverRefuseReserveDate != null)).FirstOrDefault();
                var data2 = dbma1.P401s.Where(c => c.reserveSN == reserveSN).FirstOrDefault();
                if (data1 != null || data2 != null)
                {
                    return;
                }

                //加入资产购买表 P401
                string max33SN = C101.FC10102("P401", 6, "J");
                P400   p400    = dbma1.P400s.Where(c => c.reserveSN == reserveSN).First();
                P401   p401    = new P401();

                p401.purchaseSN      = max33SN;
                p401.reserveSN       = reserveSN;
                p401.purchaserUserSN = userSN;
                p401.sellerUserSN    = p400.receiverUserSN;
                p401.assetsSN        = p400.assetsSN;
                p401.purchasePrice   = purcharsePrice;
                p401.purchaseDate    = DateTime.Now;
                dbma1.P401s.InsertOnSubmit(p401);

                //加入账单表 F001
                decimal serviceRate = Convert.ToDecimal(dbma1.A027s.First().serviceRate);

                string F001max33SN = C101.FC10102("F001", 6, "L");
                F001   f001        = new F001();
                f001.billSN       = F001max33SN;
                f001.payerUserSN  = p400.receiverUserSN;
                f001.businessSN   = p400.assetsSN;
                f001.billType     = "资产出售";
                f001.MoneyAmount  = purcharsePrice * serviceRate * 10000;
                f001.generateDate = DateTime.Now;
                dbma1.F001s.InsertOnSubmit(f001);

                dbma1.SubmitChanges();

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

                //如有邮箱提醒
                if (u003.billGenerate_email == true)
                {
                    BillSendByEmail(dbma1, p400.receiverUserSN, p400.assetsSN);
                }
                //如有短信提醒
                if (u003.billGenerate_shortMessage == true)
                {
                    BillSendBySM(dbma1, p400.receiverUserSN, p400.assetsSN);
                }

                dbma1.SubmitChanges();
            }
        }
コード例 #3
0
ファイル: CP804.cs プロジェクト: waterStone528/job
        //插入安全管理表 U003
        private void InsertIntoU003(DBMA1DataContext dbma1, string max33SN, string pwd)
        {
            U003 u003 = new U003();

            u003.userSN      = max33SN;
            u003.transactPwd = IFL.Comm.C101.FC10103(pwd);

            dbma1.U003s.InsertOnSubmit(u003);
        }
コード例 #4
0
ファイル: CP803.cs プロジェクト: waterStone528/job
        public void FP80312(string name, string value)
        {
            string userSN = session["userSN"].ToString();

            //string userSN = "U00001";

            using (DBMA1DataContext dbma1 = new DBMA1DataContext())
            {
                U003 u003 = dbma1.U003s.Where(c => c.userSN == userSN).First();
                switch (name)
                {
                case "AccountSMS":
                    u003.billGenerate_shortMessage = value == "1" ? true : false;
                    break;

                case "AccountEmail":
                    u003.billGenerate_email = value == "1" ? true : false;
                    break;

                case "TimeOutSMS":
                    u003.overdue_shortMessage = value == "1" ? true : false;
                    break;

                case "TimeOutEmail":
                    u003.overdue_email = value == "1" ? true : false;
                    break;

                case "BookSMS":
                    u003.receiveReserve_shortMessage = value == "1" ? true : false;
                    break;

                case "BookEmail":
                    u003.receiveReserve_email = value == "1" ? true : false;
                    break;
                }

                dbma1.SubmitChanges();
            }
        }
コード例 #5
0
ファイル: CP402.cs プロジェクト: waterStone528/job
        //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");
            }
        }
コード例 #6
0
ファイル: CP101.cs プロジェクト: waterStone528/job
        /// <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");
            }
        }
コード例 #7
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();
            }
        }
コード例 #8
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();
            }
        }
コード例 #9
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");
            }
        }