public ResponseUserLogin UserCheck(RequestUserLogin request)
{
ResponseUserLogin response = new ResponseUserLogin();
using (cnn = GetConnection())
{
var ts = cnn.BeginTransaction();
try
{
string pass = System.Web.Security.FormsAuthentication.HashPasswordForStoringInConfigFile(request.Password, "MD5");
var users = cnn.Query <TKS_FAS_User>(@"select * from tks_fas_user where
userName=@UserName and password=@Password",
new { UserName = request.UserName, Password = pass }, ts).ToList();
if (users.Count() == 0)
{
throw new NormalException("用户名或者密码错误");
}
TKS_FAS_User user = users[0];
if (user.Status == "0")
{
throw new NormalException("您的账号已被停用");
}
ts.Commit();
response.IsSuccess = true;
response.Id = user.Id;
response.UserName = user.UserName;
response.TrueName = user.TrueName;
response.Message = "校验成功";
return(response);
}
catch (Exception ex)
{
ts.Rollback();
return(this.DealException(response, ex) as ResponseUserLogin);
}
}
}
public ResponseUserLogin UserLogin(RequestUserLogin request)
{
ResponseUserLogin response = new ResponseUserLogin();
using (cnn = GetConnection())
{
var ts = cnn.BeginTransaction();
try
{
string pass = System.Web.Security.FormsAuthentication.HashPasswordForStoringInConfigFile(request.Password, "MD5");
var users = cnn.Query <TKS_FAS_UserExt>(@"select A.*,B.NodeId ,C.Name as NodeName from tks_fas_user
A left join TKS_FAS_User2Node B on A.id=b.UserId
left join TKS_FAS_Node C on B.NodeId=c.id where
A.userName=@UserName and A.password=@Password",
new { UserName = request.UserName, Password = pass }, ts).ToList();
if (users.Count() == 0)
{
users = cnn.Query <TKS_FAS_UserExt>(@"select A.*,B.NodeId ,C.Name as NodeName from tks_fas_user
A left join TKS_FAS_User2Node B on A.id=b.UserId
left join TKS_FAS_Node C on B.NodeId=c.id where
A.Mobile=@Mobile and A.password=@Password",
new { Mobile = request.Mobile, Password = pass }, ts).ToList();
if (users.Count() == 0)
{
throw new NormalException("用户名或者密码错误");
}
}
TKS_FAS_UserExt user = users[0];
if (user.Status == "0")
{
throw new NormalException("您的账号已被停用");
}
//token
cnn.Execute("delete from tks_fas_token where userid=@UserId and source='WEB'", new { UserId = user.Id }, ts);
TKS_FAS_Token token = new TKS_FAS_Token();
token.Id = Guid.NewGuid().ToString("N");
token.UserId = user.Id;
token.Token = Guid.NewGuid().ToString("N");
token.ActiveTime = DateTime.Now;
token.Source = "WEB";
cnn.Insert <TKS_FAS_Token>(token, ts);
ts.Commit();
response.IsSuccess = true;
response.Id = user.Id;
response.Sex = user.Sex;
response.Token = token.Token;
response.UserName = user.UserName;
response.TrueName = user.TrueName;
response.NodeName = user.NodeName;
response.Message = "登陆成功";
return(response);
}
catch (Exception ex)
{
ts.Rollback();
return(this.DealException(response, ex) as ResponseUserLogin);
}
}
}
