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 ResponseUserRegister UserRegister(RequestUserRegister request)
{
ResponseUserRegister res = new ResponseUserRegister();
using (cnn = GetConnection())
{
var ts = cnn.BeginTransaction();
try
{
string sql = @"select * from TKS_FAS_User where userName=@UserName ";
var data = cnn.Query(sql, new { UserName = request.User.UserName }, ts);
if (data.Count() > 0)
{
throw new NormalException("用户名已存在");
}
sql = @"select * from TKS_FAS_User where mobile=@Mobile";
data = cnn.Query(sql, new { Mobile = request.User.Mobile }, ts);
if (data.Count() > 0)
{
throw new NormalException("手机号已存在");
}
if (request.Node.Type == 1 && string.IsNullOrEmpty(request.Node.Name))
{
request.Node.Name = request.User.UserName;
}
sql = @"select * from TKS_FAS_Node where name=@Name ";
data = cnn.Query(sql, new { Name = request.Node.Name }, ts);
if (data.Count() > 0)
{
throw new NormalException("企业名已存在");
}
string admin = string.Empty;
if (request.Node.Type == 0)
{
admin = ConfigHelper.Read("GZQY-ADMIN");//雇主企业管理员角色ID，注册默认
}
else
{
admin = ConfigHelper.Read("DZQY-ADMIN");//代帐企业管理员角色ID，注册默认
}
TKS_FAS_User user = new TKS_FAS_User();
user.Id = Guid.NewGuid().ToString("N");
user.UserName = request.User.UserName;
user.TrueName = request.User.UserName;
user.Sex = request.User.Sex;
user.Mobile = request.User.Mobile;
string pass = System.Web.Security.FormsAuthentication.
HashPasswordForStoringInConfigFile(request.User.Password, "MD5");
user.Province = request.User.Province;
user.City = request.User.City;
user.Town = request.User.Town;
user.ZCService = request.User.ZCService;
if (request.Node.Type == 0)
{
user.DZService = 1;
}
else
{
user.DZService = 0;
}
user.Password = pass;
user.Status = "1";//启用
user.CreateUser = "******";
user.CreateDate = DateTime.Now;
TKS_FAS_Node node = new TKS_FAS_Node();
node.Id = Guid.NewGuid().ToString("N");
node.Name = string.IsNullOrEmpty(request.Node.Name) ? user.UserName : request.Node.Name;
node.CreditCode = Guid.NewGuid().ToString("N");//用作唯一key
node.IsOutSource = request.Node.IsOutSource;
node.Type = request.Node.Type;
node.UCode = request.Node.UCode;
node.CreateUser = user.UserName;
node.CreateDate = DateTime.Now;
TKS_FAS_User2Node u2n = new TKS_FAS_User2Node();
u2n.Id = Guid.NewGuid().ToString("N");
u2n.NodeId = node.Id;
u2n.UserId = user.Id;
TKS_FAS_User2Role u2r = new TKS_FAS_User2Role();
u2r.Id = Guid.NewGuid().ToString();
u2r.UserId = user.Id;
u2r.RoleId = admin;
cnn.Insert <TKS_FAS_User>(user, ts);
cnn.Insert <TKS_FAS_Node>(node, ts);
cnn.Insert <TKS_FAS_User2Node>(u2n, ts);
cnn.Insert <TKS_FAS_User2Role>(u2r, ts);
ts.Commit();
res.IsSuccess = true;
res.Message = "注册成功";
return(res);
}
catch (Exception ex)
{
ts.Rollback();
return(this.DealException(res, ex) as ResponseUserRegister);
}
}
}
public ResponseUserLogin_WX WXLogin(RequestUserLogin request)
{
ResponseUserLogin_WX response = new ResponseUserLogin_WX();
using (cnn = GetConnection())
{
var ts = cnn.BeginTransaction();
try
{
var users = cnn.Query <TKS_FAS_MobileVerification>(@"select * from TKS_FAS_MobileVerification where Status='OP' and CodeType='WX_Regist' and Mobile=@Mobile and VerCode=@VerCode",
new { Mobile = request.Mobile, VerCode = request.VerCode }, ts).FirstOrDefault();
if (users == null)
{
response.IsSuccess = false;
response.Message = "验证码失效";
return(response);
}
else
{
string userid = "";
string role = ConfigurationManager.AppSettings["GZQY-ADMIN"];
cnn.Execute("update TKS_FAS_MobileVerification set Status='SE' where Id=@Id", new { Id = users.Id }, ts);
UserBLL bll = new UserBLL();
string sql = @"select * from TKS_FAS_User where mobile=@Mobile";
var user = cnn.Query <TKS_FAS_User>(sql, new { Mobile = request.Mobile }, ts).FirstOrDefault();
if (user != null)
{
userid = user.Id;
response.user = user;
//判断是否有企业主角色，没有则添加企业主角色权限
var QY = cnn.Query <TKS_FAS_User2Role>(@"select * from TKS_FAS_User2Role where UserId=@UserId and RoleId=@RoleId", new { UserId = user.Id, RoleId = role }, ts).FirstOrDefault();
if (QY == null)
{
TKS_FAS_User2Role u2r = new TKS_FAS_User2Role();
u2r.Id = Guid.NewGuid().ToString();
u2r.UserId = user.Id;
u2r.RoleId = role;//雇主企业管理员角色ID，注册默认;
cnn.Insert <TKS_FAS_User2Role>(u2r, ts);
}
response.IsSuccess = true;
//response.UserType = "0";//有关联的企业账套，直接登录进入主页面
response.Message = "登陆成功";
}
else
{
//创建企业主账号,赋予企业主角色权限
TKS_FAS_User newuser = new TKS_FAS_User();
newuser.Id = Guid.NewGuid().ToString("N");
newuser.UserName = request.Mobile;
newuser.TrueName = request.Mobile;
//newuser.Sex = request.User.Sex;
newuser.Mobile = request.Mobile;
string pass = System.Web.Security.FormsAuthentication.
HashPasswordForStoringInConfigFile("123456", "MD5");
newuser.Password = pass;
newuser.Status = "1";//启用
newuser.CreateUser = "******";
newuser.CreateDate = DateTime.Now;
cnn.Insert <TKS_FAS_User>(newuser, ts);
TKS_FAS_User2Role u2r = new TKS_FAS_User2Role();
u2r.Id = Guid.NewGuid().ToString();
u2r.UserId = newuser.Id;
u2r.RoleId = role;//雇主企业管理员角色ID，注册默认;
cnn.Insert <TKS_FAS_User2Role>(u2r, ts);
response.user = newuser;
response.IsSuccess = true;
response.Message = "登陆成功";
userid = newuser.Id;
}
//token
cnn.Execute("delete from tks_fas_token where userid=@UserId and source='WXAPP'", new { UserId = userid }, ts);
TKS_FAS_Token token = new TKS_FAS_Token();
token.Id = Guid.NewGuid().ToString("N");
token.UserId = userid;
token.Token = Guid.NewGuid().ToString("N");
token.ActiveTime = DateTime.Now;
token.Source = "WXAPP";
cnn.Insert <TKS_FAS_Token>(token, ts);
ts.Commit();
response.Token = token.Token;
return(response);
}
}
catch (Exception ex)
{
ts.Rollback();
return(this.DealException(response, ex) as ResponseUserLogin_WX);
}
}
}
