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