/// <summary>
/// 验证登录信息
/// </summary>
/// <param name="query"></param>
/// <param name="rm"></param>
/// <returns></returns>
public bool CheckLoginInfo(SysUsrMstrQuery query, ref ReturnMsg rm)
{
if (string.IsNullOrEmpty(query.USR_NAME))
{
rm.msg = "请输入用户名";
return(false);
}
if (string.IsNullOrEmpty(query.USR_PWD))
{
rm.msg = "请输入密码";
return(false);
}
if (string.IsNullOrEmpty(query.code))
{
rm.msg = "请输入验证码";
return(false);
}
var vch = new CaptchaHelper();
if (!vch.VerifyCode(query.cookie, query.code))
{
rm.msg = "验证码错误";
return(false);
}
return(true);
}
public ActionResult GetSysUsrPageList(SysUsrMstrQuery query)
{
try
{
var result = _sysUsrMstrRepository.GetSysUsrPageList(query);
return(Page(result.Data, result.Page));
}
catch (Exception ex)
{
return(Fail(ex.Message));
}
}
/// <summary>
/// web登录验证
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public ReturnMsg Login(SysUsrMstrQuery query)
{
var rm = new ReturnMsg();
try
{
query.USR_NAME.Trim();
query.USR_PWD.Trim();
var isCheck = CheckLoginInfo(query, ref rm);
if (!isCheck)
{
rm.code = 28600;
rm.IsSuccess = false;
return(rm);
}
query.USR_PWD = Encrypt.Md5Hash(query.USR_PWD);
var userInfo = _sysUsrMstrRepository.FirstOrDefault(c => c.USR_NAME == query.USR_NAME && c.USR_PWD == query.USR_PWD && c.USR_STATUS == 1 && c.DEL_FLAG == 1);
if (userInfo != null && userInfo.Id > 0)
{
var tree = _sysNavTreeRepository.GetSysUsrMstrNavTree(userInfo.Id);
var dic = new Dictionary <string, object>();
dic.Add("UserInfo", userInfo);
dic.Add("NavTree", tree);
rm.code = 28000;
rm.IsSuccess = true;
rm.msg = "登录成功";
rm.result = JsonConvert.SerializeObject(dic);
return(rm);
}
else
{
rm.code = 28600;
rm.IsSuccess = false;
rm.msg = "用户名或密码错误";
return(rm);
}
}
catch (Exception ex)
{
rm.code = 28600;
rm.IsSuccess = false;
rm.msg = ex.Message;
return(rm);
}
}
public ActionResult Login(SysUsrMstrQuery query)
{
try
{
var result = _sysUsrMstrService.Login(query);
if (!result.IsSuccess)
{
return(Fail(result.msg));
}
return(Success(result.msg, result.result));
}
catch (Exception ex)
{
return(Fail(ex.Message));
}
}
/// <summary>
/// 获取用户分页列表
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public PagerList <dynamic> GetSysUsrPageList(SysUsrMstrQuery query)
{
var perssion = _permissionHelper.GetCondition(AbpSession.USR_TYPE, AbpSession.USR_SCOPE, "usr.ORG_NO", AbpSession.ORG_NO, AbpSession.BG_NO);
return(_sqlQuery.Select(@"
usr.USR_ID,
usr.USR_AVATAR_PATH,
usr.USR_NAME,
usr.USR_REAL_NAME,
usr.USR_EMAIL,
usr.UDF1 WeiXin,
(
CASE usr.USR_STATUS
WHEN 1 THEN
'启用'
ELSE
'禁用'
END
) AS USR_STATUS,
usr.USR_DESC,
dept.DEPT_NAME,
duty.DUTY_NAME,
bu.BU_SHORT_NAME,
usr.CREATE_DATE")
.Filter("usr.USR_NAME", query.USR_NAME, Operator.Contains)
.Filter("usr.USR_REAL_NAME", query.USR_REAL_NAME, Operator.Contains)
.Filter("usr.USR_TYPE", query.USR_TYPE)
.Filter("duty.DUTY_NAME", query.DUTY_NAME, Operator.Contains)
.Filter("usr.DEL_FLAG", "1")
.And("USR_TYPE!='0'")
.And(perssion)
.OrderBy("usr.CREATE_DATE desc")
.GetPageList <dynamic>(@"SYS_USR_MSTR usr
LEFT JOIN MDM_BU_MSTR bu ON usr.ORG_NO=bu.BU_NO
LEFT JOIN MDM_DEPT_MSTR dept ON usr.DEPT_ID=dept.DEPT_ID
LEFT JOIN MDM_DUTY_MSTR duty ON usr.DUTY_ID=duty.DUTY_ID", Context.Database.GetDbConnection(), query));
}