/// <summary>
/// 根据用户名查询用户信息
/// </summary>
/// <param name="username"></param>
/// <param name="msg"></param>
/// <returns></returns>
public SYS_USER_INFO QueryUsername(string username, ref string msg)
{
SYS_USER_INFO model = null;
try
{
DynamicParameters param = new DynamicParameters();
param.Add("UserName", username);
string querysql = @"SELECT * FROM SYS_USER_INFO WHERE UserName=@UserName";
model = idal.FindOne <SYS_USER_INFO>(querysql, param, false);
if (model == null)
{
msg = "用户名不存在";
}
}
catch (Exception ex)
{
Logger.Error(string.Format("根据用户名【{0}】查询用户异常，异常信息:{1}", username, ex.ToString()));
}
return(model);
}
public ResponseResult Add([FromBody] JObject data)
{
//返回实体
ResponseResult result = new ResponseResult();
try
{
string msg = "";
if (data["username"] != null && data["password"] != null)
{
var dtNow = DateTime.Now;
string username = data["username"].ToString();
string password = data["password"].ToString();
SYS_USER_INFO model = new SYS_USER_INFO();
model.UserName = username;
model.PassWord = password;
model.QQ = data["QQ"] == null ? null : data["QQ"].ToString();
model.Phone = data["Phone"] == null ? null : data["Phone"].ToString();
model.RealName = data["RealName"] == null ? null : data["RealName"].ToString();
model.State = 0;
model.CreateTime = dtNow;
//model.CreateUser = userid;
//model.QQ = data["QQ"] == null ? null : data["QQ"].ToString();
}
}
catch (Exception ex)
{
Logger.Error(string.Format("登录异常，异常信息:{0}", ex.ToString()));
}
return(result);
}
/// <summary>
/// 修改用户信息
/// </summary>
/// <param name="mUser"></param>
/// <param name="oCtrl"></param>
/// <returns></returns>
public int UpdateUserInfo(SysUserInfoModel mUser, ObjectControls oCtrl)
{
SYS_USER_INFO sui = new SYS_USER_INFO();
var query = Dc.SYS_USER_INFO.Where(c => c.USER_ID == mUser.UserId);
if (query.Count() > 0)
{
sui = query.First();
if (oCtrl.Exsit(MCtrl.SetPsw))
{
sui.PASSWORD = mUser.NewPsw;
}
if (oCtrl.Exsit(MCtrl.SetUserName))
{
sui.USER_NAME = mUser.UserName;
}
if (oCtrl.Exsit(MCtrl.SetUserNo))
{
sui.USER_NO = mUser.UserNo;
}
if (oCtrl.Exsit(MCtrl.SetRoleId))
{
sui.ROLE_ID = mUser.RoleInfo.RoleId;
}
if (oCtrl.Exsit(MCtrl.SetSkinId))
{
sui.SKIN_ID = mUser.SkinId;
}
sui.UPDATE_DATE = Cmn.DateBaseDate;
sui.UPDATE_USERID = mUser.UserId;
Dc.SubmitChanges();
return(sui.USER_ID);
}
return(-1);
}
/// <summary>
/// 初始化admin密码
/// </summary>
public void InitAdmin()
{
try
{
SYS_USER_INFO model = new SYS_USER_INFO();
model.UserName = "******";
//判断admin是否存在
DynamicParameters param = new DynamicParameters();
param.Add("UserName", model.UserName);
string querysql = @"SELECT * FROM SYS_USER_INFO WHERE UserName=@UserName";
if (idal.FindOne <SYS_USER_INFO>(querysql, param, false) == null)
{
model.CreateTime = DateTime.Now;
model.PassWord = SecureHelper.AESEncrypt("admin");
model.State = 1;
string insertsql = @"INSERT INTO [SYS_USER_INFO]
(
[UserName]
,[PassWord]
,[State]
,[CreateTime]
)
VALUES
(
@UserName
,@PassWord
,@State
,@CreateTime
) ";
idal.CreateEntity <SYS_USER_INFO>(insertsql, model);
}
else
{
model.UpdateTime = DateTime.Now;
model.PassWord = SecureHelper.AESEncrypt("admin");
model.State = 1;
param.Add("PassWord", model.PassWord);
param.Add("UpdateTime", model.UpdateTime);
param.Add("State", model.State);
string updatesql = @"UPDATE [SYS_USER_INFO] SET
[PassWord]=@PassWord
,[State]=@State
,[UpdateTime]=@UpdateTime
WHERE
UserName='******' ";
idal.ExcuteNonQuery <SYS_USER_INFO>(updatesql, param, false);
}
}
catch (Exception ex)
{
Logger.Error(string.Format("admin初始化异常，异常信息:{0}", ex.ToString()));
}
}
/// <summary>
/// 新增账户
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool AddUser(SYS_USER_INFO model, ref string msg)
{
bool success = false;
try
{
string tempmsg = "";
SYS_USER_INFO temp = QueryUsername(model.UserName, ref tempmsg);
if (temp == null)
{
string insertsql = @"INSERT INTO [SYS_USER_INFO]
(
[UserName]
,[PassWord]
,[RealName]
,[Phone]
,[QQ]
,[State]
,[CreateUser]
,[CreateTime]
)
VALUES
(
@UserName
,@PassWord
,@RealName
,@Phone
,@QQ
,@State
,@CreateUser
,@CreateTime
) ";
success = idal.CreateEntity <SYS_USER_INFO>(insertsql, model);
}
else
{
msg = "用户名已存在";
}
}
catch (Exception ex)
{
Logger.Error(string.Format("账户新增异常，异常信息:{0}", ex.ToString()));
}
return(success);
}
public ResponseResult SaveUser([FromBody] JObject data)
{
//定义
ResponseResult result = new ResponseResult();
string msg = "";
if (data["username"] != null && data["password"] != null)
{
SYS_USER_INFO model = new SYS_USER_INFO();
var dtNow = DateTime.Now;
string username = data["username"].ToString();
string password = data["password"].ToString();
//获取操作用户
GetByToken(data["Token"].ToString());
model.UserName = username;
model.PassWord = Common.Helper.SecureHelper.AESEncrypt(password);
model.QQ = data["qq"] == null ? null : data["qq"].ToString();
model.Phone = data["phone"] == null ? null : data["phone"].ToString();
model.RealName = data["realname"] == null ? null : data["realname"].ToString();
model.State = 0;
model.CreateTime = dtNow;
model.CreateUser = LoginedUserName;
//保存
if (SYS_USER_INFO_BLL.getInstance().AddUser(model, ref msg))
{
result.return_code = RETURN_CODE.SUCCESS.ToString();
result.return_msg = "新增成功";
}
else
{
result.return_code = RETURN_CODE.FAIL.ToString();
result.return_msg = msg;
}
}
else
{
msg = "用户名或密码不能为空";
}
return(result);
}
public int InsertUserInfo(SysUserInfoModel mUser)
{
SYS_USER_INFO sui = new SYS_USER_INFO
{
USER_NO = mUser.UserNo,
STATUS = 'E',
CREATE_DATE = Cmn.DateBaseDate,
CREATE_USERID = mUser.CommonInfo.CreateUserId,
UPDATE_DATE = Cmn.DateBaseDate,
ROLE_ID = mUser.RoleInfo.RoleId,
PASSWORD = mUser.UserPassWord,
USER_NAME = mUser.UserName,
SKIN_ID = mUser.SkinId,
UPDATE_USERID = mUser.CommonInfo.CreateUserId
};
Dc.SYS_USER_INFO.InsertOnSubmit(sui);
Dc.SubmitChanges();
return(sui.USER_ID);
}
/// <summary>
/// 查询账户根据id
/// </summary>
/// <param name="id"></param>
/// <param name="msg"></param>
/// <returns></returns>
public SYS_USER_INFO QueryUserById(string id, ref string msg)
{
SYS_USER_INFO model = null;
try
{
DynamicParameters param = new DynamicParameters();
param.Add("Id", id);
string querysql = @"SELECT * FROM SYS_USER_INFO WHERE Id=@Id";
model = idal.FindOne <SYS_USER_INFO>(querysql, param, false);
if (model == null)
{
msg = "用户不不存在";
}
}
catch (Exception ex)
{
Logger.Error(string.Format("根据id【{0}】查询用户异常，异常信息:{1}", id, ex.ToString()));
}
return(model);
}
/// <summary>
/// 根据用户名 密码 获取用户信息
/// </summary>
/// <param name="username"></param>
/// <param name="password"></param>
/// <param name="msg"></param>
/// <returns></returns>
public SYS_USER_INFO GetLoginModel(string username, string password, ref string msg)
{
SYS_USER_INFO model = null;
try
{
//判断admin是否存在
DynamicParameters param = new DynamicParameters();
param.Add("UserName", username);
string querysql = @"SELECT * FROM SYS_USER_INFO WHERE UserName=@UserName";
SYS_USER_INFO temp = idal.FindOne <SYS_USER_INFO>(querysql, param, false);
if (temp == null)
{
msg = "用户名不存在";
}
else
{
if (SecureHelper.AESDecrypt(temp.PassWord) == password)
{
msg = "登录成功";
model = temp;
}
else
{
msg = "密码错误";
}
}
}
catch (Exception ex)
{
Logger.Error(string.Format("【{0}】登录异常，异常信息:{1}", username, ex.ToString()));
}
return(model);
}
/// <summary>
/// 编辑账户
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool EditUser(SYS_USER_INFO model)
{
bool success = false;
try
{
DynamicParameters param = new DynamicParameters();
//条件
param.Add("Id", model.Id);
param.Add("PassWord", model.PassWord);
param.Add("RealName", model.RealName);
param.Add("Phone", model.Phone);
param.Add("QQ", model.QQ);
param.Add("State", model.State);
param.Add("UpdateUser", model.UpdateUser);
param.Add("UpdateTime", model.UpdateTime);
string updatesql = @"UPDATE [SYS_USER_INFO] SET
PassWord= @PassWord
,RealName=@RealName
,Phone=@Phone
,QQ=@QQ
,State=@State
,UpdateUser=@UpdateUser
,UpdateTime=@UpdateTime
WHERE
Id=@Id";
success = idal.ExcuteNonQuery <SYS_USER_INFO>(updatesql, param, false) > 0;
}
catch (Exception ex)
{
Logger.Error(string.Format("账户编辑异常，异常信息:{0}", ex.ToString()));
}
return(success);
}
/// <summary>
/// 注册方法
/// </summary>
/// <param name="userId">账号</param>
/// <param name="passWord">密码</param>
public RetJsonModel Register(string userId, string passWord)
{
var db = DBContext.GetInstance;
try
{
DateTime now = db.GetDate();
//返给前台的JSON实体
RetJsonModel jsonModel = new RetJsonModel();
int timestamp = FunctionHelper.GetTimestamp();
jsonModel.time = timestamp;
//查询账号是否已存在
var data = db.Queryable <SYS_USER_ACCOUNT>()
.Where(x => x.ACCOUNT_NUMBER == userId)
.First();
if (data == null)
{
db.Ado.BeginTran();
//账号表新增记录
SYS_USER_ACCOUNT model = new SYS_USER_ACCOUNT();
model.ID = System.Guid.NewGuid().ToString();
model.DATETIME_CREATED = now;
model.STATE = "A";
model.ACCOUNT_NUMBER = userId;
model.PASSWORD = passWord;
model.TIMESTAMP_INT = timestamp;
model.STATUS = 1;
db.Insertable(model).ExecuteCommand();
//先在用户注册时，默认在用户个人信息表插入一条记录
bool isExist = true;
string nickName = "";
do
{
nickName = FunctionHelper.GetRandomString(8, true, false, true, false, "");
int count = db.Queryable <SYS_USER_INFO>().Where(x => x.NICK_NAME == nickName && x.STATE == "A").Count();
isExist = count == 0;
} while (!isExist);
SYS_USER_INFO uInfoModel = new SYS_USER_INFO();
uInfoModel.ID = System.Guid.NewGuid().ToString();
uInfoModel.DATETIME_CREATED = now;
uInfoModel.STATE = "A";
uInfoModel.TIMESTAMP_INT = timestamp;
uInfoModel.USER_ID = model.ID;
uInfoModel.NICK_NAME = nickName;
db.Insertable(uInfoModel).ExecuteCommand();
LoginReturnModel lrm = new LoginReturnModel();
lrm.user_info = new UserInfoReturnModel
{
USER_ID = model.ID,
NiCK_NAME = uInfoModel.NICK_NAME
};
jsonModel.status = 1;
jsonModel.msg = "注册成功";
jsonModel.data = lrm;
db.Ado.CommitTran();
}
else
{
jsonModel.status = 0;
jsonModel.msg = "账号已存在，请重新输入";
}
return(jsonModel);
}
catch (Exception ex)
{
db.Ado.RollbackTran();
throw ex;
}
}
