public JsonResult LoginIn(LoginUser loginUser)
{
var userResult = new CommonResult<CyUserEntity>();
try
{
var user = new CyUserEntity()
{
UserName = loginUser.UserName,
UserPwd = loginUser.UserPwd,
ValideCode = loginUser.ValideCode
};
//验证用户信息
userResult = CyUserService.Login(user);
//验证成功
if (userResult.Success)
{
var cyUser = userResult.ResultObj;
var model = new UserModel()
{
UserNo = cyUser.UserNo,
UserName = cyUser.UserName,
NickName = cyUser.NickName,
TrueName = cyUser.TrueName,
MemberType = cyUser.MemberType,
Role = cyUser.Role
};
UserContext.SetAuthCookie(model, true);
var loginLog = new CyUserLoginLogEntity()
{
UserNo = cyUser.UserNo,
LoginIp = IpHelper.GetUserIpAddress(),
LoginTime = DateTime.Now
};
CyUserService.AddCyUserLoginLog(loginLog);
}
}
catch (Exception ex)
{
userResult.Success = false;
userResult.Message = ex.Message;
}
return Json(userResult, JsonRequestBehavior.AllowGet);
}
public void TestAddUser()
{
try
{
var userPwd = StringUtil.ToHashString("123");
var userNo = new CySequenceCounterProvider().GetNextCounterId("UserNo");
var entity = new CyUserEntity()
{
UserNo = userNo.ToString(),
UserName = "******",
UserPwd = userPwd,
Birthday = "1987-09-14",
BirthPlace = "四川岳池",
CreateTime = DateTime.Now,
CreateUserNo = "Admin",
DataStatus = DataStatus.Valid,
Email = "",
Gender = Gender.Male,
MemberType = MemberType.Normal,
MobilePhone = "",
NickName = "潇刚",
QQ = "",
Residence = "北京",
Role = Role.Admin,
TrueName = "成刚",
UpdateTime = DateTime.Now,
UpdateUserNo = "Admin"
};
var userId = new CyUserService().AddCyUser(entity, null);
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// 添加用户信息
/// </summary>
/// <param name="entity">实体</param>
/// <param name="trans">事务</param>
/// <returns>执行结果</returns>
public CommonResult<string> AddCyUser(CyUserEntity entity, IDbTransaction trans = null)
{
try
{
//生成会员编号
var userNo = CySequenceCounterProvider.GetNextCounterId("UserNo");
entity.UserNo = "CYHY" + userNo.ToString("000000");
//登录密码加密
var userPwd = StringUtil.ToHashString(entity.UserPwd);
entity.UserPwd = userPwd;
return CyUserProvider.AddCyUser(entity, trans);
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// 修改用户信息
/// </summary>
/// <param name="entity">实体</param>
/// <param name="trans">事务</param>
/// <returns>执行结果</returns>
public CommonResult<string> ModifyCyUser(CyUserEntity entity, IDbTransaction trans = null)
{
try
{
return CyUserProvider.ModifyCyUser(entity, trans);
}
catch (Exception)
{
throw;
}
}
public CommonResult<CyUserEntity> Login(CyUserEntity user)
{
try
{
var commonResult = new CommonResult<CyUserEntity>();
if (string.IsNullOrEmpty(user.UserName))
{
commonResult.Success = false;
commonResult.Message = "用户名为空";
return commonResult;
}
if (string.IsNullOrEmpty(user.UserPwd))
{
commonResult.Success = false;
commonResult.Message = "密码为空";
return commonResult;
}
var userResult = CyUserProvider.GetCyUserByUserName(user.UserName);
if (userResult.Success)
{
var userModel = userResult.ResultObjList;
if (userModel.Count == 0)
{
commonResult.Success = false;
commonResult.Message = "用户名不存在";
return commonResult;
}
//如果同一用户名出现重复记录
if (userModel.Count > 1)
{
commonResult.Success = false;
commonResult.Message = "用户信息异常请联系管理员";
return commonResult;
}
if (userModel[0].UserPwd != StringUtil.ToHashString(user.UserPwd))
{
commonResult.Success = false;
commonResult.Message = "密码错误";
return commonResult;
}
if (!string.Equals(HttpContext.Current.Session["vcode"].ToString(), user.ValideCode, StringComparison.CurrentCultureIgnoreCase))
{
commonResult.Success = false;
commonResult.Message = "验证码填写错误";
return commonResult;
}
commonResult.Success = true;
commonResult.Message = "验证成功";
commonResult.ResultObj = userModel[0];
}
else
{
commonResult = userResult;
return commonResult;
}
return commonResult;
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// 修改用户信息
/// </summary>
/// <param name="entity">实体</param>
/// <param name="trans">事务</param>
/// <returns>执行结果</returns>
public CommonResult<string> ModifyCyUser(CyUserEntity entity, IDbTransaction trans = null)
{
var commonResult = new CommonResult<string>();
const string sql = @"UPDATE [dbo].[CyUser]
SET [NickName] =@NickName
,[TrueName] =@TrueName
,[Gender] =@Gender
,[MobilePhone] =@MobilePhone
,[Email] =@Email
,[QQ] =@QQ
,[Birthday] =@Birthday
,[BirthPlace] =@BirthPlace
,[Residence] =@Residence
,[UpdateUserNo] =@UpdateUserNo
,[UpdateTime] =@UpdateTime
WHERE UserNo=@UserNo";
if (trans == null)
{
using (var conn = DbHelper.CreateOpenConnection(DbConnectionStringConfig.CyMainDbConnectionStringName))
{
try
{
var rows = conn.Execute(sql, entity);
commonResult.Success = true;
commonResult.Message = "执行成功";
commonResult.EffectRows = rows;
}
catch (Exception ex)
{
commonResult.Success = false;
commonResult.IsHappenEx = true;
commonResult.Message = "执行失败";
commonResult.ExMessage = ex.Message;
commonResult.ExData = ex;
}
}
}
else
{
try
{
var rows = trans.Connection.Execute(sql, entity, transaction: trans);
commonResult.Success = true;
commonResult.Message = "执行成功";
commonResult.EffectRows = rows;
}
catch (Exception ex)
{
commonResult.Success = false;
commonResult.IsHappenEx = true;
commonResult.Message = "执行失败";
commonResult.ExMessage = ex.Message;
commonResult.ExData = ex;
}
}
return commonResult;
}
/// <summary>
/// 添加用户信息
/// </summary>
/// <param name="entity">实体</param>
/// <param name="trans">事务</param>
/// <returns>执行结果</returns>
public CommonResult<string> AddCyUser(CyUserEntity entity, IDbTransaction trans = null)
{
var commonResult = new CommonResult<string>();
const string sql = @"INSERT INTO [dbo].[CyUser]
([UserNo]
,[UserName]
,[UserPwd]
,[NickName]
,[TrueName]
,[Gender]
,[MobilePhone]
,[Email]
,[QQ]
,[Industry]
,[Position]
,[Birthday]
,[BirthPlace]
,[Residence]
,[MemberType]
,[Role]
,[CreateUserNo]
,[CreateTime]
,[UpdateUserNo]
,[UpdateTime]
,[DataStatus])
VALUES
(@UserNo
,@UserName
,@UserPwd
,@NickName
,@TrueName
,@Gender
,@MobilePhone
,@Email
,@QQ
,@Industry
,@Position
,@Birthday
,@BirthPlace
,@Residence
,@MemberType
,@Role
,@CreateUserNo
,@CreateTime
,@UpdateUserNo
,@UpdateTime
,@DataStatus)";
if (trans == null)
{
using (var conn = DbHelper.CreateOpenConnection(DbConnectionStringConfig.CyMainDbConnectionStringName))
{
try
{
var rows = conn.Execute(sql, entity);
commonResult.Success = true;
commonResult.Message = "执行成功";
commonResult.EffectRows = rows;
}
catch (Exception ex)
{
commonResult.Success = false;
commonResult.IsHappenEx = true;
commonResult.Message = "执行失败";
commonResult.ExMessage = ex.Message;
commonResult.ExData = ex;
}
}
}
else
{
try
{
var rows = trans.Connection.Execute(sql, entity, transaction: trans);
commonResult.Success = true;
commonResult.Message = "执行成功";
commonResult.EffectRows = rows;
}
catch (Exception ex)
{
commonResult.Success = false;
commonResult.IsHappenEx = true;
commonResult.Message = "执行失败";
commonResult.ExMessage = ex.Message;
commonResult.ExData = ex;
}
}
return commonResult;
}
