/// <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));
}
