/// <summary> /// 修改保存 /// </summary> /// <param name="strUser"></param> /// <returns></returns> public ActionResult UpdataUser(B_UserTable strUser) { //定义返回 string strMsg = "fail"; //查询除了自身外查询是否已经存在 int oldCount = (from tbUSer in myDYXTEntities.B_UserTable where tbUSer.UserID != strUser.UserID && tbUSer.UserName.Trim() == strUser.UserName.Trim() select tbUSer).Count(); if (oldCount == 0) { try { //修改公告类型 myDYXTEntities.Entry(strUser).State = System.Data.Entity.EntityState.Modified; if (myDYXTEntities.SaveChanges() > 0) { strMsg = "success"; } } catch (Exception e) { Console.WriteLine(e); } } else { strMsg = "exist";//已经存在 } return(Json(strMsg, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 编辑保存 /// </summary> /// <param name="UserDetai"></param> /// <param name="BornDates"></param> /// <returns></returns> public ActionResult UpdataUserdetailed(B_UserTable UserDetai, string BornDates) { string strMsg = "fali"; try { B_UserTable varUserLoginDetail = (from tbB_UserLoginDetail in myDYXTEntities.B_UserTable where tbB_UserLoginDetail.UserID == UserDetai.UserID select tbB_UserLoginDetail).Single(); varUserLoginDetail.TrueName = UserDetai.TrueName; varUserLoginDetail.Sex = UserDetai.Sex; varUserLoginDetail.BornDate = Convert.ToDateTime(BornDates); varUserLoginDetail.IDCardNo = UserDetai.IDCardNo; varUserLoginDetail.PhoneNumber = UserDetai.PhoneNumber; varUserLoginDetail.NativePlace = UserDetai.NativePlace; varUserLoginDetail.PostBox = UserDetai.PostBox; varUserLoginDetail.EducationalBackground = UserDetai.EducationalBackground; varUserLoginDetail.MarriageState = UserDetai.MarriageState; varUserLoginDetail.Issue = UserDetai.Issue; varUserLoginDetail.SocialSecurity = UserDetai.SocialSecurity; varUserLoginDetail.housingCondition = UserDetai.housingCondition; varUserLoginDetail.WhetherBuyCar = UserDetai.WhetherBuyCar; myDYXTEntities.Entry(varUserLoginDetail).State = System.Data.Entity.EntityState.Modified; myDYXTEntities.SaveChanges(); strMsg = "success"; } catch (Exception e) { Console.WriteLine(e); } return(Json(strMsg, JsonRequestBehavior.AllowGet)); }
public ActionResult UpdataSperadtypeBiao(B_SpreadUserTable SpreadUser, string SpreadRen) { //定义返回 string strMsg = "fail"; try { B_SpreadUserTable spuser = (from tbspuser in myDYXTEntities.B_SpreadUserTable where tbspuser.SpreadUserID == SpreadUser.SpreadUserID select tbspuser).Single(); B_UserTable inruser = (from tbUser in myDYXTEntities.B_UserTable where tbUser.UserName == SpreadRen select tbUser).Single(); spuser.SpreadRenID = inruser.UserID; spuser.RelevanceTime = DateTime.Now; spuser.StatusID = 19; //修改公告类型 myDYXTEntities.Entry(spuser).State = System.Data.Entity.EntityState.Modified; if (myDYXTEntities.SaveChanges() > 0) { int varPersonalSpreadMessage = (from tbPersonalSpreadMessage in myDYXTEntities.B_PersonalSpreadMessage where tbPersonalSpreadMessage.SpreadUserID == inruser.UserID select tbPersonalSpreadMessage).Count(); if (varPersonalSpreadMessage == 0) { B_PersonalSpreadMessage PersonalSpreadMessage = new B_PersonalSpreadMessage(); PersonalSpreadMessage.SpreadUserID = inruser.UserID; PersonalSpreadMessage.SpreadPeople = 1; PersonalSpreadMessage.InvestTime = 0; PersonalSpreadMessage.InvestAmount = 0; PersonalSpreadMessage.InvestTiCheng = 0; PersonalSpreadMessage.RepaymentTime = 0; PersonalSpreadMessage.RepaymentAmount = 0; PersonalSpreadMessage.RepaymentTiCheng = 0; myDYXTEntities.B_PersonalSpreadMessage.Add(PersonalSpreadMessage); myDYXTEntities.SaveChanges(); } else { B_PersonalSpreadMessage strPersonalSpreadMessage = (from tbPersonalSpreadMessage in myDYXTEntities.B_PersonalSpreadMessage where tbPersonalSpreadMessage.SpreadUserID == inruser.UserID select tbPersonalSpreadMessage).Single(); strPersonalSpreadMessage.SpreadPeople = strPersonalSpreadMessage.SpreadPeople + 1; myDYXTEntities.Entry(strPersonalSpreadMessage).State = System.Data.Entity.EntityState.Modified; myDYXTEntities.SaveChanges(); } strMsg = "success"; } } catch (Exception e) { Console.WriteLine(e); } return(Json(strMsg, JsonRequestBehavior.AllowGet)); }
public ActionResult insertUserPwP(B_AccountTable Account, B_UserTable User) { string strMed = "fail"; string password = AESEncryptHelper.AESEncrypt(Account.Password); string Paypassword = AESEncryptHelper.AESEncrypt(User.PayPassword); int intaccon = (from tbaccounnt in myDYXTEntities.B_AccountTable where tbaccounnt.User == User.UserName select tbaccounnt).Count(); if (intaccon == 0) { Account.User = User.UserName; Account.Password = password; Account.Cancel = false; myDYXTEntities.B_AccountTable.Add(Account); myDYXTEntities.SaveChanges(); int varuser = (from tbUSer in myDYXTEntities.B_UserTable where tbUSer.UserName == User.UserName select tbUSer).Count(); if (varuser == 0) { var varaccon = (from tbaccounnt in myDYXTEntities.B_AccountTable where tbaccounnt.User == User.UserName select tbaccounnt).Single(); User.AccountID = varaccon.AccountID; User.PayPassword = Paypassword; User.UserTypeID = 2; User.Time = DateTime.Now; User.PropertyAmounts = 0; User.UsableMoney = 0; User.FreezeMoney = 0; User.WaitMoney = 0; User.CompensatoryMoney = 0; myDYXTEntities.B_UserTable.Add(User); myDYXTEntities.SaveChanges(); strMed = "success"; } else { strMed = "UserNamefail";//用户名已存在 } } else { strMed = "AccountUserfail";//账号名已存在 } return(Json(strMed, JsonRequestBehavior.AllowGet)); }
public ActionResult JudgeUser() { try { string str = ""; int accountID = Convert.ToInt32(Session["AccountID"].ToString()); int B_uer = (from tbuser in myModels.B_UserTable where tbuser.AccountID == accountID select tbuser).Count(); if (B_uer > 0) { B_UserTable B_User = (from tbuser in myModels.B_UserTable where tbuser.AccountID == accountID select tbuser).Single(); if (B_User.StatusID == 24) { int B_limit = (from tblimit in myModels.B_LimitApplicationTable where tblimit.UserID == B_User.UserID select tblimit.UserID).Count(); if (B_limit > 0) { str = "GoLoan"; } else { str = "fail"; } } else { str = "IDCardNoFail"; } } else { str = "Nowrite"; } return(Json(str, JsonRequestBehavior.AllowGet)); } catch (Exception e) { Console.WriteLine(e); return(Json(null, JsonRequestBehavior.AllowGet)); } }
/// <summary> /// 删除管理员 /// </summary> /// <param name="UserID"></param> /// <returns></returns> public ActionResult Deleteuser(int UserID) { string strMsg = "fail"; try { B_UserTable varFundCost = (from tModuleTable in myDYXTEntities.B_UserTable where tModuleTable.UserID == UserID select tModuleTable).Single(); //删除数据 myDYXTEntities.B_UserTable.Remove(varFundCost); myDYXTEntities.SaveChanges(); strMsg = "success"; } catch (Exception e) { } return(Json(strMsg, JsonRequestBehavior.AllowGet)); }
/// <summary> ///用户编辑 /// </summary> /// <param name="UserID"></param> /// <returns></returns> public ActionResult selectfromUSerdetailed(int UserID) { try { B_UserTable varUser = (from tbUser in myDYXTEntities.B_UserTable join tbUsertype in myDYXTEntities.S_UserTypeTable on tbUser.UserTypeID equals tbUsertype.UserTypeID where tbUser.UserID == UserID select new USerbankVo { UserID = tbUser.UserID, UserName = tbUser.UserName.Trim(), UserTypeName = tbUsertype.UserTypeName.Trim(), TrueName = tbUser.TrueName.Trim(), Sex = tbUser.Sex.Trim(), BornDates = tbUser.BornDate.ToString(), IDCardNo = tbUser.IDCardNo.Trim(), PhoneNumber = tbUser.PhoneNumber.Trim(), NativePlace = tbUser.NativePlace.Trim(), PostBox = tbUser.PostBox.Trim(), EducationalBackground = tbUser.EducationalBackground.Trim(), MarriageState = tbUser.MarriageState.Trim(), Issue = tbUser.Issue.Trim(), SocialSecurity = tbUser.SocialSecurity.Trim(), housingCondition = tbUser.housingCondition.Trim(), WhetherBuyCar = tbUser.WhetherBuyCar.Trim(), PropertyAmounts = tbUser.PropertyAmounts, UsableMoney = tbUser.UsableMoney, FreezeMoney = tbUser.FreezeMoney, WaitMoney = tbUser.WaitMoney, CompensatoryMoney = tbUser.CompensatoryMoney }).Single(); return(Json(varUser, JsonRequestBehavior.AllowGet)); } catch (Exception e) { throw; } }
/// <summary> ///基本信息 /// </summary> /// <param name="UserID"></param> /// <returns></returns> public ActionResult selectfrombiangding(int UserID) { try { B_UserTable varUser = (from tbUser in myDYXTEntities.B_UserTable where tbUser.UserID == UserID select new USerbankVo { UserID = tbUser.UserID, UserName = tbUser.UserName, TrueName = tbUser.TrueName, Sex = tbUser.Sex, BornDates = tbUser.BornDate.ToString(), NativePlace = tbUser.NativePlace, IDCardNo = tbUser.IDCardNo, PhoneNumber = tbUser.PhoneNumber }).Single(); return(Json(varUser, JsonRequestBehavior.AllowGet)); } catch (Exception e) { throw; } }
public ActionResult selectjiekuanfullscale() { try { //判断VIP用户是否到期 var vipUser = (from tbVIPuser in myDYXTEntities.B_VIPUserTable select tbVIPuser).ToList(); for (int i = 0; i < vipUser.Count; i++) { DateTime nowTime = DateTime.Now; //当前时间 DateTime dtTime = Convert.ToDateTime(vipUser[i].EndTime); //结束时间 if (nowTime > dtTime) { int intuserID = Convert.ToInt32(vipUser[i].UserID); B_UserTable varsuer = (from tbUser in myDYXTEntities.B_UserTable where tbUser.UserID == intuserID select tbUser).Single(); varsuer.UserTypeID = 2; myDYXTEntities.Entry(varsuer).State = System.Data.Entity.EntityState.Modified; myDYXTEntities.SaveChanges(); } } var varstrloan = (from tbLoan in myDYXTEntities.B_LoanTable where tbLoan.StatusID == 7 || tbLoan.StatusID == 8 || tbLoan.StatusID == 9 select tbLoan).ToList(); try { for (int i = 0; i < varstrloan.Count(); i++) { int intloanID = varstrloan[i].LoanID; B_LoanTable varloanll = (from tbloan in myDYXTEntities.B_LoanTable where tbloan.LoanID == intloanID select tbloan).Single(); DateTime loantime = DateTime.Now; //获取当前时间 DateTime valtiem = Convert.ToDateTime(varstrloan[i].Endtime); //获取到期是时间 DateTime Raistime = Convert.ToDateTime(varstrloan[i].Raisestandard); //获取筹标时间 DateTime varsichuantime = Convert.ToDateTime(varstrloan[i].sichuantime); //过期时间 if (Raistime >= loantime && varstrloan[i].Scheduleinvestment == Convert.ToDecimal("100")) { varloanll.StatusID = 28;//满标待审 myDYXTEntities.Entry(varloanll).State = System.Data.Entity.EntityState.Modified; myDYXTEntities.SaveChanges(); } else if (loantime > Raistime) { varloanll.StatusID = 9;//已过期 varloanll.sichuantime = varloanll.Raisestandard.Value.AddDays(3); myDYXTEntities.Entry(varloanll).State = System.Data.Entity.EntityState.Modified; myDYXTEntities.SaveChanges(); } if (varloanll.StatusID == 9 && loantime > varsichuantime && varstrloan[i].Scheduleinvestment < Convert.ToDecimal("100")) { varloanll.StatusID = 26;//流标 varloanll.RemoveTreetopTime = DateTime.Now; myDYXTEntities.Entry(varloanll).State = System.Data.Entity.EntityState.Modified; myDYXTEntities.SaveChanges(); var varinves = (from tbinvest in myDYXTEntities.B_InvestTable where tbinvest.LoanID == varloanll.LoanID select tbinvest).ToList(); for (int j = 0; j < varinves.Count; j++) { int VarUserID = Convert.ToInt32(varinves[j].UserID); B_UserTable varsuer = (from tbUser in myDYXTEntities.B_UserTable where tbUser.UserID == VarUserID select tbUser).Single(); varsuer.PropertyAmounts = varsuer.PropertyAmounts + varinves[j].InvestMoney; varsuer.UsableMoney = varsuer.UsableMoney + varinves[j].InvestMoney; myDYXTEntities.Entry(varsuer).State = System.Data.Entity.EntityState.Modified; myDYXTEntities.SaveChanges(); } } } } catch (Exception e) { } //判断借款标是否逾期 var varloan = (from tbLoan in myDYXTEntities.B_LoanTable where tbLoan.StatusID == 10 || tbLoan.StatusID == 8 || tbLoan.StatusID == 11 || tbLoan.StatusID == 34 select tbLoan).ToList(); for (int i = 0; i < varloan.Count; i++) { DateTime nowTime = DateTime.Now; //当前时间 DateTime dtTime = Convert.ToDateTime(varloan[i].Endtime); //结束时间 if (nowTime > dtTime && varloan[i].StatusID != 34) { TimeSpan YuQitianshu = nowTime - dtTime; double YQTS = YuQitianshu.TotalDays; int yqts = Convert.ToInt32(YQTS); //逾期天数 decimal varrete = Convert.ToDecimal(varloan[i].Rate) * Convert.ToDecimal(0.01); decimal demoney = Convert.ToDecimal(varloan[i].LoanMoney) * varrete; //利息 decimal strfx = Convert.ToDecimal(varloan[i].LoanMoney) * Convert.ToDecimal(0.008) * yqts; //罚息 B_OverdueLoanTable strOverdueLoan = new B_OverdueLoanTable(); strOverdueLoan.LoanID = varloan[i].LoanID; strOverdueLoan.PayableTime = varloan[i].Endtime; strOverdueLoan.OverdueDay = yqts; strOverdueLoan.PayablePrincipal = varloan[i].LoanMoney + demoney + strfx; strOverdueLoan.WebsiteWhetherPayStatusID = 33; strOverdueLoan.StatusID = 31; strOverdueLoan.RealityRepaymentTime = varloan[i].Endtime; myDYXTEntities.B_OverdueLoanTable.Add(strOverdueLoan); myDYXTEntities.SaveChanges(); int intloan = Convert.ToInt32(varloan[i].LoanID); var varloanID = (from tbLoan in myDYXTEntities.B_LoanTable where tbLoan.LoanID == intloan select tbLoan).Single(); varloanID.StatusID = 34; varloanID.RepayPrincipal = strOverdueLoan.PayablePrincipal; varloanID.ArrearagePrincipal = strOverdueLoan.PayablePrincipal; myDYXTEntities.Entry(varloanID).State = System.Data.Entity.EntityState.Modified; myDYXTEntities.SaveChanges(); } else if (nowTime > dtTime && varloan[i].StatusID == 34) { int intloan = Convert.ToInt32(varloan[i].LoanID); B_OverdueLoanTable strOverdueLoan = (from tbOverdueLoan in myDYXTEntities.B_OverdueLoanTable where tbOverdueLoan.LoanID == intloan select tbOverdueLoan).Single(); TimeSpan YuQitianshu = nowTime - dtTime; double YQTS = YuQitianshu.TotalDays; int yqts = Convert.ToInt32(YQTS);//逾期天数 if (strOverdueLoan.OverdueDay != yqts) { decimal varrete = Convert.ToDecimal(varloan[i].Rate) * Convert.ToDecimal(0.01); decimal demoney = Convert.ToDecimal(varloan[i].LoanMoney) * varrete; //利息 decimal strfx = Convert.ToDecimal(varloan[i].LoanMoney) * Convert.ToDecimal(0.008) * yqts; //罚息 strOverdueLoan.OverdueDay = yqts; strOverdueLoan.PayablePrincipal = strOverdueLoan.PayablePrincipal + demoney + strfx; myDYXTEntities.Entry(strOverdueLoan).State = System.Data.Entity.EntityState.Modified; myDYXTEntities.SaveChanges(); int intloans = Convert.ToInt32(varloan[i].LoanID); var varloanID = (from tbLoan in myDYXTEntities.B_LoanTable where tbLoan.LoanID == intloans select tbLoan).Single(); varloanID.RepayPrincipal = strOverdueLoan.PayablePrincipal; varloanID.ArrearagePrincipal = strOverdueLoan.PayablePrincipal; myDYXTEntities.Entry(varloanID).State = System.Data.Entity.EntityState.Modified; myDYXTEntities.SaveChanges(); try { B_WebsiteReceivableDetail varWebsiteReceivableDetail = (from tbWebsiteReceivableDetail in myDYXTEntities.B_WebsiteReceivableDetail where tbWebsiteReceivableDetail.OverdueLoanID == strOverdueLoan.OverdueLoanID select tbWebsiteReceivableDetail).Single(); varWebsiteReceivableDetail.ReceivableAccrual = demoney + strfx; varWebsiteReceivableDetail.OverdueDays = yqts; myDYXTEntities.Entry(varWebsiteReceivableDetail).State = System.Data.Entity.EntityState.Modified; myDYXTEntities.SaveChanges(); } catch (Exception e) { } } } } } catch (Exception e) { } return(Json(null, JsonRequestBehavior.AllowGet)); }
public ActionResult UserLogin(B_AccountTable B_Account) { string strMed = "fail"; string struser = Request["User"];; //用户 string strPassword = Request["password"]; string strvalidCode = Request["validCode"]; //验证码 string strSessionValidCode = ""; //获取 session中的验证码 try { strSessionValidCode = Session["ValidCode"].ToString(); } catch (Exception) { return(Json("loginerror", JsonRequestBehavior.AllowGet)); } //判断验证码 if (strSessionValidCode.Equals(strvalidCode.Trim(), StringComparison.InvariantCultureIgnoreCase)) { try { //根据 UserNuber 查询用户 var dbUser = (from tbUser in myDYXTEntities.B_AccountTable where tbUser.User == struser.Trim() select new { tbUser.AccountID, tbUser.User, tbUser.Password }).Single(); //将用户输入的密码进行AES265后与数据库中的密码对比 string password = AESEncryptHelper.AESEncrypt(strPassword); if (dbUser.Password.Trim().Equals(password)) { B_UserTable dbuser = (from tbuser in myDYXTEntities.B_UserTable where tbuser.AccountID == dbUser.AccountID select tbuser).Single(); if (dbuser.UserTypeID == 1 || dbuser.UserTypeID == 4 || dbuser.UserTypeID == 12) { Session["AccountID"] = dbUser.AccountID; B_UserTable varFundCost = (from tbuser in myDYXTEntities.B_UserTable where tbuser.AccountID == dbUser.AccountID select tbuser).Single(); B_ManagerRecord ManagerRecord = new B_ManagerRecord(); ManagerRecord.UserID = varFundCost.UserID; ManagerRecord.BearFruit = "成功".Trim(); ManagerRecord.Content = "用户" + varFundCost.UserName.Trim() + "在“" + DateTime.Now + "”登录后台"; ManagerRecord.LoginTime = DateTime.Now; string IP = ""; try { string pHostName = Dns.GetHostName();//Dns类 IPHostEntry myAddress = Dns.GetHostEntry(pHostName); //myAddress.Aliases IPAddress[] myIPAddress = myAddress.AddressList; foreach (IPAddress add in myIPAddress) { if (add.AddressFamily == AddressFamily.InterNetwork) { IP = add.ToString(); } } } catch (Exception e) { } ManagerRecord.LoginIP = IP; myDYXTEntities.B_ManagerRecord.Add(ManagerRecord); myDYXTEntities.SaveChanges(); strMed = "strsuccess";//登录成功 } else { strMed = "strfail";//登录成功 } } else { strMed = "strpassword";//密码错误 } } catch (Exception e) { strMed = "usernoexsit";//没有此用户 } } else { strMed = "ValidCodeErro";//验证码错误 } return(Json(strMed, JsonRequestBehavior.AllowGet)); }
//认购页面 public ActionResult SubscribeIndex(int LoanID, BsgridPage bsgridPage) { try { string strUserId = Session["AccountID"].ToString(); int intUserId = Convert.ToInt32(strUserId); B_AccountTable accouunt = (from tbAccountTable in myModels.B_AccountTable where tbAccountTable.AccountID == intUserId select tbAccountTable).Single(); ViewBag.User = accouunt.User; B_LoanTable notice = (from tbloan in myModels.B_LoanTable join tbuser in myModels.B_UserTable on tbloan.UserID equals tbuser.UserID join tbLoanDeadline in myModels.S_LoanDeadlineTable on tbloan.LoanDeadlineID equals tbLoanDeadline.LoanDeadlineID join tbtree in myModels.S_Treetoptypetalbe on tbloan.TreetoptypeID equals tbtree.TreetoptypeID join tbRepaymentWayTable in myModels.S_RepaymentWayTable on tbloan.RepaymentWayID equals tbRepaymentWayTable.RepaymentWayID where tbloan.LoanID == LoanID select new LoanVo { LoanID = tbloan.LoanID, UserID = tbloan.UserID, UserName = tbuser.UserName, Loantitle = tbloan.Loantitle, PaymentNumber = tbloan.PaymentNumber, LoanMoney = tbloan.LoanMoney, Rate = tbloan.Rate, LoanDeadlineName = tbLoanDeadline.LoanDeadlineName, RepaymentWayName = tbRepaymentWayTable.RepaymentWayName, LowestTenderMoney = tbloan.LowestTenderMoney, AlreadyLoan = tbloan.AlreadyLoan, SurplusLoan = tbloan.SurplusLoan, Scheduleinvestment = tbloan.Scheduleinvestment }).Single(); ViewBag.notice = notice; B_LoanTable Loanxinix = (from tbloan in myModels.B_LoanTable where tbloan.LoanID == LoanID select tbloan).Single(); int userid = Convert.ToInt32(Loanxinix.UserID); B_UserTable userxinxi = (from tbuser in myModels.B_UserTable where tbuser.UserID == userid select new UserVo { UserName = tbuser.UserName, Sex = tbuser.Sex, MonthIncome = tbuser.MonthIncome, ReleaseTimeStr = tbuser.BornDate.ToString(), MarriageState = tbuser.MarriageState, EducationalBackground = tbuser.EducationalBackground, WhetherBuyCar = tbuser.WhetherBuyCar, housingCondition = tbuser.housingCondition, Issue = tbuser.Issue, PropertyAmounts = tbuser.PropertyAmounts, CompensatoryMoney = tbuser.CompensatoryMoney, }).Single(); ViewBag.userxinxi = userxinxi; var vraloan = (from tbloan in myModels.B_LoanTable where tbloan.UserID == userid select tbloan).ToList(); decimal rowloan = vraloan.Count; ViewBag.rowloan = rowloan;//发布借款 var vraloanStatusID = (from tbloan in myModels.B_LoanTable where tbloan.UserID == userid && tbloan.StatusID == 10 select tbloan).ToList(); decimal varvraloanStatusID = vraloanStatusID.Count; ViewBag.varvraloanStatusID = varvraloanStatusID;//成功借款 var vrastrloan = (from tbloanid in myModels.B_LoanTable where tbloanid.UserID == userid && (tbloanid.StatusID == 12 || tbloanid.StatusID == 13) select tbloanid).ToList(); decimal rowvrastrloan = vrastrloan.Count; ViewBag.rowvrastrloan = rowvrastrloan;//还请笔数 } catch (Exception e) { } return(View()); }
/// <summary> /// 确定认购 /// </summary> /// <param name="bInvest"></param> /// <param name="Loantitle"></param> /// <param name="fenshu"></param> /// <param name="LowestTenderMoney"></param> /// <param name="Rate"></param> /// <param name="PayPassword"></param> /// <returns></returns> public ActionResult InsertLoan(B_InvestTable bInvest, string Loantitle, int fenshu, string LowestTenderMoney, string Rate, string PayPassword) { string str = ""; int loanid = Convert.ToInt32(bInvest.LoanID); B_LoanTable varB_LoanTable = (from tbtbB_Loan in myModels.B_LoanTable where tbtbB_Loan.LoanID == loanid select tbtbB_Loan).Single(); int userid = Convert.ToInt32(varB_LoanTable.UserID); B_UserTable varuser = (from tbuser in myModels.B_UserTable where tbuser.UserID == userid select tbuser).Single(); string password = AESEncryptHelper.AESEncrypt(PayPassword); if (varuser.PayPassword.Trim().Equals(password)) { int accountID = Convert.ToInt32(Session["AccountID"].ToString()); var list = (from tbuser in myModels.B_UserTable where tbuser.AccountID == accountID select tbuser).Single(); bInvest.LoanTreetop = Loantitle; decimal intLowestTenderMoney = Convert.ToDecimal(LowestTenderMoney); bInvest.InvestMoney = fenshu * intLowestTenderMoney; //份数*最低投标金额 decimal rate = Convert.ToDecimal(Rate.ToString().Trim()); //年利率 bInvest.ReceivableInterest = (bInvest.InvestMoney * rate) / 100; //应收利息 bInvest.ReceivablePrincipal = bInvest.InvestMoney + bInvest.ReceivableInterest; //应收本息 bInvest.CountermandPrincipal = Convert.ToDecimal(0.00); //已收本息 bInvest.NotRetrievePrincipal = bInvest.ReceivablePrincipal; //未收本息 if (list.PropertyAmounts > bInvest.InvestMoney) { if (bInvest.LoanID != null) { bInvest.InvestTime = DateTime.Now; bInvest.UserID = list.UserID; bInvest.StatusID = 16; bInvest.WhetherAttorn = false; myModels.B_InvestTable.Add(bInvest); myModels.SaveChanges(); //修改借款标表 B_LoanTable B_Loan = (from tbloan in myModels.B_LoanTable where tbloan.LoanID == bInvest.LoanID select tbloan).Single(); //B_Loan.LoanMoney = B_Loan.LoanMoney - bInvest.InvestMoney;//借款金额 int investTime; investTime = Convert.ToInt32(B_Loan.InvestTime.ToString());//投资次数 investTime = investTime + 1; B_Loan.InvestTime = Convert.ToInt32(investTime).ToString(); int grossscore; grossscore = Convert.ToInt32(B_Loan.Grossscore); //总份数; double scheduleinvestment; //进度 scheduleinvestment = Convert.ToDouble(B_Loan.Scheduleinvestment); scheduleinvestment = Convert.ToDouble(Convert.ToDouble(fenshu) / Convert.ToDouble(grossscore)) * 100; B_Loan.Scheduleinvestment = Convert.ToDecimal(scheduleinvestment + Convert.ToDouble(B_Loan.Scheduleinvestment)); int surplusLoan;//剩余份数 surplusLoan = Convert.ToInt32(B_Loan.SurplusLoan); surplusLoan = (surplusLoan - fenshu); B_Loan.SurplusLoan = Convert.ToDecimal(surplusLoan); int alreadyLoan;//已被购买份数 alreadyLoan = Convert.ToInt32(B_Loan.AlreadyLoan); B_Loan.AlreadyLoan = Convert.ToInt32(alreadyLoan + fenshu); myModels.Entry(B_Loan).State = System.Data.Entity.EntityState.Modified; myModels.SaveChanges(); if (B_Loan.SurplusLoan == 0) { B_LoanTable bloan = (from tbloa in myModels.B_LoanTable where tbloa.LoanID == bInvest.LoanID select tbloa).Single(); bloan.StatusID = 28; myModels.Entry(bloan).State = System.Data.Entity.EntityState.Modified; myModels.SaveChanges(); } //修改用户表的金额 B_UserTable listS = (from tbuser in myModels.B_UserTable where tbuser.AccountID == accountID select tbuser).Single(); //listS.PropertyAmounts = listS.PropertyAmounts - bInvest.InvestMoney; listS.UsableMoney = listS.UsableMoney - bInvest.InvestMoney; listS.FreezeMoney = listS.FreezeMoney + bInvest.InvestMoney; myModels.Entry(listS).State = System.Data.Entity.EntityState.Modified; myModels.SaveChanges(); B_CapitalrecordTable Capitalrecord = new B_CapitalrecordTable(); Capitalrecord.UserID = list.UserID; Capitalrecord.OperateTypeID = 4; Capitalrecord.OpFare = Convert.ToDecimal(bInvest.InvestMoney); Capitalrecord.Income = Convert.ToDecimal(0); Capitalrecord.Expend = Convert.ToDecimal(bInvest.InvestMoney); Capitalrecord.PropertyAmounts = list.PropertyAmounts; Capitalrecord.Remarks = "用户" + "[" + list.UserName.Trim() + "]" + ",投资成功,可用余额减少" + bInvest.InvestMoney + "元"; Capitalrecord.operatetime = DateTime.Now; myModels.B_CapitalrecordTable.Add(Capitalrecord); myModels.SaveChanges(); str = "success"; } else { str = "fail"; } } } else { str = "failPayPassword"; } return(Json(str, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 审核保存 /// </summary> /// <param name="User"></param> /// <param name="optionsRadios"></param> /// <param name="validCode"></param> /// <returns></returns> public ActionResult updatashenheVIP(B_VIPUserTable VIPUser, string optionsRadios, string validCode) { //定义返回 string strMsg = "fail"; string strSessionValidCode = ""; //获取 session中的验证码 try { strSessionValidCode = Session["ValidCode"].ToString(); } catch (Exception) { return(Json("loginerror", JsonRequestBehavior.AllowGet)); } //判断验证码 if (strSessionValidCode.Equals(validCode.Trim(), StringComparison.InvariantCultureIgnoreCase)) { if (optionsRadios == "option1") { B_VIPUserTable varVipUser = (from tbVIPUser in myDYXTEntities.B_VIPUserTable where tbVIPUser.VIPUserID == VIPUser.VIPUserID select tbVIPUser).Single(); varVipUser.StatusID = 2; varVipUser.ExamineRemarks = VIPUser.ExamineRemarks; varVipUser.ExamineTime = DateTime.Now; myDYXTEntities.Entry(varVipUser).State = System.Data.Entity.EntityState.Modified; if (myDYXTEntities.SaveChanges() > 0) { strMsg = "success"; } } else if (optionsRadios == "option2") { B_VIPUserTable varVipUser = (from tbVIPUser in myDYXTEntities.B_VIPUserTable where tbVIPUser.VIPUserID == VIPUser.VIPUserID select tbVIPUser).Single(); int intuserID = Convert.ToInt32(varVipUser.UserID); B_UserTable varsuer = (from tbUser in myDYXTEntities.B_UserTable where tbUser.UserID == intuserID select tbUser).Single(); varsuer.UserTypeID = 3; myDYXTEntities.Entry(varsuer).State = System.Data.Entity.EntityState.Modified; myDYXTEntities.SaveChanges(); varVipUser.StatusID = 18; varVipUser.ExamineRemarks = VIPUser.ExamineRemarks; varVipUser.ExamineTime = DateTime.Now; DateTime date = DateTime.Now; varVipUser.StartTime = date; if (varVipUser.VipDeadline.Trim() == "1") { var usermoney = (from tbuser in myDYXTEntities.B_UserTable where tbuser.UserID == VIPUser.UserID select tbuser).Single(); if (usermoney.PropertyAmounts >= 10 && usermoney.UsableMoney >= 10 && usermoney.PropertyAmounts != null && usermoney.UsableMoney != null) { usermoney.PropertyAmounts = usermoney.PropertyAmounts - 10; usermoney.UsableMoney = usermoney.UsableMoney - 10; B_WebsiteExpensesTable WebsiteExpenses = new B_WebsiteExpensesTable(); WebsiteExpenses.AccountID = Convert.ToInt32(Session["AccountID"]); WebsiteExpenses.OperateTypeID = 9; WebsiteExpenses.OperateMoney = Convert.ToDecimal(10); WebsiteExpenses.Earning = Convert.ToDecimal(10); WebsiteExpenses.Expenses = Convert.ToDecimal(0); WebsiteExpenses.Remark = "用户申请VIP一个月," + "扣除" + "[" + usermoney.UserName.Trim() + "]10元会员费"; WebsiteExpenses.OperateTime = DateTime.Now; myDYXTEntities.B_WebsiteExpensesTable.Add(WebsiteExpenses); myDYXTEntities.SaveChanges(); B_UserExpensesTable UserExpense = new B_UserExpensesTable(); UserExpense.UserID = usermoney.UserID; UserExpense.OperateTypeID = 9; UserExpense.OperateMoney = Convert.ToDecimal(10); UserExpense.Balance = usermoney.PropertyAmounts; UserExpense.Earning = Convert.ToDecimal(0); UserExpense.Expenses = Convert.ToDecimal(10); UserExpense.Remark = "用户申请VIP一个月," + "扣除" + "[" + usermoney.UserName.Trim() + "]10元会员费"; UserExpense.OperateTime = DateTime.Now; myDYXTEntities.B_UserExpensesTable.Add(UserExpense); myDYXTEntities.SaveChanges(); B_CapitalrecordTable Capitalrecord = new B_CapitalrecordTable(); Capitalrecord.UserID = usermoney.UserID; Capitalrecord.OperateTypeID = 9; Capitalrecord.OpFare = Convert.ToDecimal(10); Capitalrecord.Income = Convert.ToDecimal(0); Capitalrecord.Expend = Convert.ToDecimal(10); Capitalrecord.PropertyAmounts = usermoney.PropertyAmounts; Capitalrecord.Remarks = "用户申请VIP一个月," + "扣除" + "[" + usermoney.UserName.Trim() + "]10元会员费"; Capitalrecord.operatetime = DateTime.Now; myDYXTEntities.B_CapitalrecordTable.Add(Capitalrecord); myDYXTEntities.SaveChanges(); varVipUser.EndTime = date.AddMonths(1); myDYXTEntities.Entry(varVipUser).State = System.Data.Entity.EntityState.Modified; if (myDYXTEntities.SaveChanges() > 0) { strMsg = "success"; } } else { strMsg = "failmoney";//余额不足 } } if (varVipUser.VipDeadline.Trim() == "3") { var usermoney = (from tbuser in myDYXTEntities.B_UserTable where tbuser.UserID == VIPUser.UserID select tbuser).Single(); if (usermoney.PropertyAmounts >= 30 && usermoney.UsableMoney >= 30 && usermoney.PropertyAmounts != null && usermoney.UsableMoney != null) { usermoney.PropertyAmounts = usermoney.PropertyAmounts - 30; usermoney.UsableMoney = usermoney.UsableMoney - 30; B_WebsiteExpensesTable WebsiteExpenses = new B_WebsiteExpensesTable(); WebsiteExpenses.AccountID = Convert.ToInt32(Session["AccountID"]); WebsiteExpenses.OperateTypeID = 9; WebsiteExpenses.OperateMoney = Convert.ToDecimal(30); WebsiteExpenses.Earning = Convert.ToDecimal(30); WebsiteExpenses.Expenses = Convert.ToDecimal(0); WebsiteExpenses.Remark = "用户申请VIP三个月," + "扣除" + "[" + usermoney.UserName.Trim() + "]30元会员费"; WebsiteExpenses.OperateTime = DateTime.Now; myDYXTEntities.B_WebsiteExpensesTable.Add(WebsiteExpenses); myDYXTEntities.SaveChanges(); B_UserExpensesTable UserExpense = new B_UserExpensesTable(); UserExpense.UserID = usermoney.UserID; UserExpense.OperateTypeID = 9; UserExpense.OperateMoney = Convert.ToDecimal(30); UserExpense.Balance = usermoney.PropertyAmounts; UserExpense.Earning = Convert.ToDecimal(0); UserExpense.Expenses = Convert.ToDecimal(30); UserExpense.Remark = "用户申请VIP三个月," + "扣除" + "[" + usermoney.UserName.Trim() + "]30元会员费"; UserExpense.OperateTime = DateTime.Now; myDYXTEntities.B_UserExpensesTable.Add(UserExpense); myDYXTEntities.SaveChanges(); B_CapitalrecordTable Capitalrecord = new B_CapitalrecordTable(); Capitalrecord.UserID = usermoney.UserID; Capitalrecord.OperateTypeID = 9; Capitalrecord.OpFare = Convert.ToDecimal(30); Capitalrecord.Income = Convert.ToDecimal(0); Capitalrecord.Expend = Convert.ToDecimal(30); Capitalrecord.PropertyAmounts = usermoney.PropertyAmounts; Capitalrecord.Remarks = "用户申请VIP三个月," + "扣除" + "[" + usermoney.UserName.Trim() + "]30元会员费"; Capitalrecord.operatetime = DateTime.Now; myDYXTEntities.B_CapitalrecordTable.Add(Capitalrecord); myDYXTEntities.SaveChanges(); varVipUser.EndTime = date.AddMonths(3); myDYXTEntities.Entry(varVipUser).State = System.Data.Entity.EntityState.Modified; if (myDYXTEntities.SaveChanges() > 0) { strMsg = "success"; } } else { strMsg = "failmoney";//余额不足 } } if (varVipUser.VipDeadline.Trim() == "6") { var usermoney = (from tbuser in myDYXTEntities.B_UserTable where tbuser.UserID == VIPUser.UserID select tbuser).Single(); if (usermoney.PropertyAmounts >= 60 && usermoney.UsableMoney >= 60 && usermoney.PropertyAmounts != null && usermoney.UsableMoney != null) { usermoney.PropertyAmounts = usermoney.PropertyAmounts - 60; usermoney.UsableMoney = usermoney.UsableMoney - 60; B_WebsiteExpensesTable WebsiteExpenses = new B_WebsiteExpensesTable(); WebsiteExpenses.AccountID = Convert.ToInt32(Session["AccountID"]); WebsiteExpenses.OperateTypeID = 9; WebsiteExpenses.OperateMoney = Convert.ToDecimal(60); WebsiteExpenses.Earning = Convert.ToDecimal(60); WebsiteExpenses.Expenses = Convert.ToDecimal(0); WebsiteExpenses.Remark = "用户申请VIP六个月," + "扣除" + "[" + usermoney.UserName.Trim() + "]60元会员费"; WebsiteExpenses.OperateTime = DateTime.Now; myDYXTEntities.B_WebsiteExpensesTable.Add(WebsiteExpenses); myDYXTEntities.SaveChanges(); B_UserExpensesTable UserExpense = new B_UserExpensesTable(); UserExpense.UserID = usermoney.UserID; UserExpense.OperateTypeID = 9; UserExpense.OperateMoney = Convert.ToDecimal(60); UserExpense.Balance = usermoney.PropertyAmounts; UserExpense.Earning = Convert.ToDecimal(0); UserExpense.Expenses = Convert.ToDecimal(60); UserExpense.Remark = "用户申请VIP六个月," + "扣除" + "[" + usermoney.UserName.Trim() + "]60元会员费"; UserExpense.OperateTime = DateTime.Now; myDYXTEntities.B_UserExpensesTable.Add(UserExpense); myDYXTEntities.SaveChanges(); B_CapitalrecordTable Capitalrecord = new B_CapitalrecordTable(); Capitalrecord.UserID = usermoney.UserID; Capitalrecord.OperateTypeID = 9; Capitalrecord.OpFare = Convert.ToDecimal(60); Capitalrecord.Income = Convert.ToDecimal(0); Capitalrecord.Expend = Convert.ToDecimal(60); Capitalrecord.PropertyAmounts = usermoney.PropertyAmounts; Capitalrecord.Remarks = "用户申请VIP六个月," + "扣除" + "[" + usermoney.UserName.Trim() + "]60元会员费"; Capitalrecord.operatetime = DateTime.Now; myDYXTEntities.B_CapitalrecordTable.Add(Capitalrecord); myDYXTEntities.SaveChanges(); varVipUser.EndTime = date.AddMonths(6); myDYXTEntities.Entry(varVipUser).State = System.Data.Entity.EntityState.Modified; if (myDYXTEntities.SaveChanges() > 0) { strMsg = "success"; } } else { strMsg = "failmoney";//余额不足 } } if (varVipUser.VipDeadline.Trim() == "12") { var usermoney = (from tbuser in myDYXTEntities.B_UserTable where tbuser.UserID == VIPUser.UserID select tbuser).Single(); if (usermoney.PropertyAmounts >= 120 && usermoney.UsableMoney >= 120 && usermoney.PropertyAmounts != null && usermoney.UsableMoney != null) { usermoney.PropertyAmounts = usermoney.PropertyAmounts - 120; usermoney.UsableMoney = usermoney.UsableMoney - 120; B_WebsiteExpensesTable WebsiteExpenses = new B_WebsiteExpensesTable(); WebsiteExpenses.AccountID = Convert.ToInt32(Session["AccountID"]); WebsiteExpenses.OperateTypeID = 9; WebsiteExpenses.OperateMoney = Convert.ToDecimal(120); WebsiteExpenses.Earning = Convert.ToDecimal(120); WebsiteExpenses.Expenses = Convert.ToDecimal(0); WebsiteExpenses.Remark = "用户申请VIP一年," + "扣除" + "[" + usermoney.UserName.Trim() + "]120元会员费"; WebsiteExpenses.OperateTime = DateTime.Now; myDYXTEntities.B_WebsiteExpensesTable.Add(WebsiteExpenses); myDYXTEntities.SaveChanges(); B_UserExpensesTable UserExpense = new B_UserExpensesTable(); UserExpense.UserID = usermoney.UserID; UserExpense.OperateTypeID = 9; UserExpense.OperateMoney = Convert.ToDecimal(120); UserExpense.Balance = usermoney.PropertyAmounts; UserExpense.Earning = Convert.ToDecimal(0); UserExpense.Expenses = Convert.ToDecimal(120); UserExpense.Remark = "用户申请VIP一年," + "扣除" + "[" + usermoney.UserName.Trim() + "]120元会员费"; UserExpense.OperateTime = DateTime.Now; myDYXTEntities.B_UserExpensesTable.Add(UserExpense); myDYXTEntities.SaveChanges(); B_CapitalrecordTable Capitalrecord = new B_CapitalrecordTable(); Capitalrecord.UserID = usermoney.UserID; Capitalrecord.OperateTypeID = 9; Capitalrecord.OpFare = Convert.ToDecimal(120); Capitalrecord.Income = Convert.ToDecimal(0); Capitalrecord.Expend = Convert.ToDecimal(120); Capitalrecord.PropertyAmounts = usermoney.PropertyAmounts; Capitalrecord.Remarks = "用户申请VIP一年," + "扣除" + "[" + usermoney.UserName.Trim() + "]120元会员费"; Capitalrecord.operatetime = DateTime.Now; myDYXTEntities.B_CapitalrecordTable.Add(Capitalrecord); myDYXTEntities.SaveChanges(); varVipUser.EndTime = date.AddMonths(12); myDYXTEntities.Entry(varVipUser).State = System.Data.Entity.EntityState.Modified; if (myDYXTEntities.SaveChanges() > 0) { strMsg = "success"; } } else { strMsg = "failmoney";//余额不足 } } } else { B_VIPUserTable varVipUser = (from tbVIPUser in myDYXTEntities.B_VIPUserTable where tbVIPUser.VIPUserID == VIPUser.VIPUserID select tbVIPUser).Single(); varVipUser.StatusID = 25; varVipUser.ExamineRemarks = VIPUser.ExamineRemarks; varVipUser.ExamineTime = DateTime.Now; myDYXTEntities.Entry(varVipUser).State = System.Data.Entity.EntityState.Modified; if (myDYXTEntities.SaveChanges() > 0) { strMsg = "success"; } } } else { strMsg = "ValidCodeErro";//验证码错误 } return(Json(strMsg, JsonRequestBehavior.AllowGet)); }