/// <summary>
/// 修改绑定
/// </summary>
/// <param name="UserLoginDetailID"></param>
/// <returns></returns>
public ActionResult Userfrombiangding(int UserLoginDetailID)
{
try
{
B_UserLoginDetailTable notict = (from tbUserLoginDetail in myDYXTEntities.B_UserLoginDetailTable
join tbAccount in myDYXTEntities.B_AccountTable on tbUserLoginDetail.AccountID equals tbAccount.AccountID
join tbuser in myDYXTEntities.B_UserTable on tbAccount.AccountID equals tbuser.AccountID
where tbUserLoginDetail.UserLoginDetailID == UserLoginDetailID
select new B_UserLoginDetailVo
{
UserLoginDetailID = tbUserLoginDetail.UserLoginDetailID,
UserName = tbuser.UserName,
PostBox = tbUserLoginDetail.PostBox,
LoginFrequency = tbUserLoginDetail.LoginFrequency,
StrRegisterTime = tbUserLoginDetail.RegisterTime.ToString(),
StrlastLoginTime = tbUserLoginDetail.lastLoginTime.ToString(),
StrEndLoginTime = tbUserLoginDetail.EndLoginTime.ToString()
}).Single();
return(Json(notict, JsonRequestBehavior.AllowGet));
}
catch (Exception e)
{
throw;
}
}
/// <summary>
/// 修改用户信息保存
/// </summary>
/// <param name="UserLoginDetail"></param>
/// <param name="StrRegisterTime"></param>
/// <param name="StrlastLoginTime"></param>
/// <param name="StrEndLoginTime"></param>
/// <returns></returns>
public ActionResult UpdataUSerxinxi(B_UserLoginDetailTable UserLoginDetail, string StrRegisterTime, string StrlastLoginTime, string StrEndLoginTime)
{
string strMsg = "fali";
try
{
B_UserLoginDetailTable varUserLoginDetail = (from tbB_UserLoginDetail in myDYXTEntities.B_UserLoginDetailTable
where tbB_UserLoginDetail.UserLoginDetailID == UserLoginDetail.UserLoginDetailID
select tbB_UserLoginDetail).Single();
varUserLoginDetail.PostBox = UserLoginDetail.PostBox;
varUserLoginDetail.LoginFrequency = UserLoginDetail.LoginFrequency;
varUserLoginDetail.RegisterTime = Convert.ToDateTime(StrRegisterTime);
varUserLoginDetail.lastLoginTime = Convert.ToDateTime(StrlastLoginTime);
varUserLoginDetail.EndLoginTime = Convert.ToDateTime(StrEndLoginTime);
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 UserLogin(B_AccountTable Account)
{
string str = ""; //
string strUser = Request["username"]; //用户名
string strPassword = Request["password"]; //密码
string strvalidCode = Request["validCode"]; //验证码
string strSession = "";
if (Session["vildeCode"] != null)
{
strSession = Session["vildeCode"].ToString();
if (strSession.Equals(strvalidCode, StringComparison.CurrentCultureIgnoreCase))
{
try
{
var list = (from tbUser in myModels.B_AccountTable
where tbUser.User == strUser.Trim()
select new
{
tbUser.User,
tbUser.Password,
tbUser.AccountID
}).Single();
string strpassword = AESEncryptHelper.AESEncrypt(strPassword);
if (strpassword == list.Password.Trim())
{
Session["AccountID"] = list.AccountID; // 传递 UserID
Session["Password"] = list.Password;
var BLoginDetai = (from tblo in myModels.B_UserLoginDetailTable
select new
{
tblo.AccountID,
}).ToList();
for (int i = 0; i < BLoginDetai.Count; i++)
{
if (BLoginDetai[i].AccountID == list.AccountID)
{
B_UserLoginDetailTable BLoginss = (from tblogin in myModels.B_UserLoginDetailTable
where tblogin.AccountID == list.AccountID
select tblogin).Single();
if (BLoginss.lastLoginTime == null || BLoginss.LoginFrequency == null)
{
BLoginss.RegisterTime = DateTime.Now;
BLoginss.lastLoginTime = DateTime.Now;
BLoginss.LoginFrequency = 1;
BLoginss.EndLoginTime = DateTime.Now;
myModels.Entry(BLoginss).State = System.Data.Entity.EntityState.Modified;
myModels.SaveChanges();
}
else
{
BLoginss.lastLoginTime = BLoginss.EndLoginTime;
BLoginss.LoginFrequency = BLoginss.LoginFrequency + 1;
BLoginss.EndLoginTime = DateTime.Now;
myModels.Entry(BLoginss).State = System.Data.Entity.EntityState.Modified;
myModels.SaveChanges();
}
break;
}
}
str = "success";
}
else
{
str = "fail";
}
}
catch (Exception e)
{
Console.WriteLine(e);
return(Json(null, JsonRequestBehavior.AllowGet));
}
}
else
{
str = "validCodeFail";
}
}
else
{
str = "writevalidCode";
}
return(Json(str, JsonRequestBehavior.AllowGet));
}
