public User Login(Model.Table.User u)
{
String pw = u.userPassword;
u.userId = "admin";
// u.userPassword = "******";
using (DbClinet db = new DbClinet())
{
db.AddParameter("@userId", u.userId);
List <Dictionary <string, object> > mv = db.Select("select * from SYS_User where userId=@userId");
if (mv.Count > 0)
{
string userPasswordTemp = mv.FirstOrDefault()["userPassword"] as string;
if (userPasswordTemp.Equals(u.userPassword, StringComparison.OrdinalIgnoreCase))
{
//u.lastLoginIp = mv.FirstOrDefault()["lastLoginIp"] as string;
u.State = 1;
db.AddParameter("@userId", u.userId);
db.AddParameter("@ip", u.lastLoginIp);
db.ExecuteNonQuery("update SYS_User set lastLoginTime=GETDATE(),lastLoginIp=@ip where userId=@userId");
}
else
{
//密码错误
u.State = -1;
}
}
else
{
u.State = -2; //不存在用户
}
}
return(u);
}
public bool UpdatePassword(Model.Table.User u)
{
using (DbClinet db = new DbClinet())
{
db.AddParameter("@userPassword", u.userPassword);
db.AddParameter("@userId", u.userId);
db.ExecuteNonQuery("update SYS_User set userPassword=@userPassword where userId=@userId");
return(true);
}
}