public ActionResult AddAjax(SysAccountInfoEntity accountEntity)
{
try
{
if (!Request.IsAjaxRequest())
{
return Content("{\"result\":\"failure\",\"msg\":\"非法请求\"}");
}
string msg = "";
if (ModelState.IsValid)
{
ISysAccountInfoService accountService = ServiceContainer.Instance.Container.Resolve<ISysAccountInfoService>();
SysAccountInfoQuery queryEntity = new SysAccountInfoQuery();
queryEntity.LoginName = WKT.Common.Security.SecurityUtils.SafeSqlString(accountEntity.LoginName);
IList<SysAccountInfoEntity> list = accountService.GetSysAccountInfoList(queryEntity);
if (list.Count > 0)
{
msg = "{\"result\":\"failure\",\"msg\":\"该登录名已经存在\"}";
}
else
{
accountEntity.Pwd = WKT.Common.Security.DES.Encrypt(accountEntity.Pwd);
bool flag = accountService.AddSysAccountInfo(accountEntity);
if (flag)
{
msg = "{\"result\":\"success\"}";
}
else
{
msg = "{\"result\":\"failure\",\"msg\":\"添加失败，请检查\"}";
}
}
}
else
{
msg = "{\"result\":\"failure\",\"msg\":\"" + this.ExpendErrors() + "\"}";
}
return Content(msg);
}
catch(Exception ex)
{
LogProvider.Instance.Error("添加管理账户失败:" + ex.Message);
return Content("{\"result\":\"error\",\"msg\":\"" + ex.Message + "\"}");
}
}
/// <summary>
/// 分页获取符合查询条件的数据
/// </summary>
/// <param name="sysAccountInfoQuery">SysAccountInfoQuery查询实体对象</param>
/// <returns>Pager<SysAccountInfoEntity></returns>
public Pager<SysAccountInfoEntity> GetSysAccountInfoPageList(SysAccountInfoQuery sysAccountInfoQuery)
{
return SysAccountInfoBusiness.GetSysAccountInfoPageList(sysAccountInfoQuery);
}
/// <summary>
/// 获取所有符合查询条件的数据
/// </summary>
/// <param name="sysAccountInfoQuery">SysAccountInfoQuery查询实体对象</param>
/// <returns>List<SysAccountInfoEntity></returns>
public List<SysAccountInfoEntity> GetSysAccountInfoList(SysAccountInfoQuery sysAccountInfoQuery)
{
return SysAccountInfoBusiness.GetSysAccountInfoList(sysAccountInfoQuery);
}
public ActionResult LoginAjax(string LoginName, string Password, string VerifyCode)
{
string returnUrl = "/";
# region func define
Func<SysAccountInfoEntity, string, JsonResult> loginFunc = (accountEntity, pwd) =>
{
if (accountEntity == null)
return Json(new { result = "failure", msg = "用户名或密码错误！", url = returnUrl });
if (accountEntity.Status == 1)// 禁用
return Json(new { result = "failure", msg = "您的账号已经禁用！", url = returnUrl });
if (!accountEntity.Pwd.Equals(pwd))
return Json(new { result = "failure", msg = "用户名或密码错误！", url = returnUrl });
accountEntity.LogOnTimes = accountEntity.LogOnTimes + 1;
accountEntity.LastIP = WKT.Common.Utils.Utils.GetRealIP();
accountEntity.LoginDate = DateTime.Now;
# region 更新登录情况
ISysAccountInfoService accountService = ServiceContainer.Instance.Container.Resolve<ISysAccountInfoService>();
accountService.UpdateAccountLoginInfo(accountEntity.AdminID, accountEntity.LastIP, accountEntity.LoginDate.ToString("yyyy-MM-dd HH:mm:ss"));
# endregion
string jsonObject = JsonConvert.SerializeObject(accountEntity);
// 保存登录ticket
TicketTool.SetCookie(accountEntity.AdminID.ToString(), jsonObject);
return Json(new { result = "success", msg = "登录成功！", url = returnUrl });
};
# endregion
try
{
# region 得到验证码
string code = "";
HttpCookie cookie = Request.Cookies[VERFIYCODEKEY];
if (cookie != null)
{
code = cookie.Value.ToString();
}
# endregion
if (WKT.Common.Security.DES.Encrypt(VerifyCode.ToLower()) == code)
{
ISysAccountInfoService accountService = ServiceContainer.Instance.Container.Resolve<ISysAccountInfoService>();
SysAccountInfoQuery queryEntity = new SysAccountInfoQuery();
queryEntity.LoginName = SecurityUtils.SafeSqlString(LoginName);
IList<SysAccountInfoEntity> list = accountService.GetSysAccountInfoList(queryEntity);
if (list == null || list.Count == 0)
return Json(new { result = "failure", msg = "用户名或密码错误！"});
if (list.Count == 1)
{
Password = DES.Encrypt(Password);
return loginFunc(list[0], Password);
}
else
return Json(new { result = "failure", msg = "用户名重复，请确认是否输入正确"});
}
else
{
return Json(new { result = "failure", msg = "请输入正确的验证码！"});
}
}
/// <summary>
/// 获取所有符合查询条件的数据
/// </summary>
/// <param name="sysAccountInfoQuery">SysAccountInfoQuery查询实体对象</param>
/// <returns>List<SysAccountInfoEntity></returns>
public List<SysAccountInfoEntity> GetSysAccountInfoList(SysAccountInfoQuery sysAccountInfoQuery)
{
return SysAccountInfoDataAccess.Instance.GetSysAccountInfoList(sysAccountInfoQuery);
}
/// <summary>
/// 将查询实体转换为Where语句
/// <param name="query">查询实体</param>
/// <returns>获取Where语句，不包含Where</returns>
/// </summary>
public string SysAccountInfoQueryToSQLWhere(SysAccountInfoQuery query)
{
StringBuilder sbWhere = new StringBuilder(" 1=1 ");
if (query.Status != null)
{
sbWhere.Append(" AND Status= ").Append(query.Status.Value);
}
if (!string.IsNullOrEmpty(query.LoginName))
{
sbWhere.AppendFormat( " AND LoginName='{0}'",WKT.Common.Security.SecurityUtils.SafeSqlString(query.LoginName));
}
if (sbWhere.ToString() == " 1=1 ")
{
return string.Empty;
}
else
{
return sbWhere.ToString();
}
}
/// <summary>
/// 将查询实体转换为Order语句
/// <param name="query">查询实体</param>
/// <returns>获取Order语句，不包含Order</returns>
/// </summary>
public string SysAccountInfoQueryToSQLOrder(SysAccountInfoQuery query)
{
return " AdminID DESC";
}
public Pager<SysAccountInfoEntity> GetSysAccountInfoPageList(SysAccountInfoQuery query)
{
int recordCount = 0;
string whereSQL = SysAccountInfoQueryToSQLWhere(query);
string orderBy = SysAccountInfoQueryToSQLOrder(query);
DataSet ds = db.GetPagingData("SysAccountInfo", "AdminID,UserName,LoginName,Pwd,Gender,Email,Mobile,Status,LastIP,LoginDate,LogOnTimes,AddDate", orderBy, whereSQL, query.CurrentPage, query.PageSize, out recordCount);
Pager<SysAccountInfoEntity> pager = new Pager<SysAccountInfoEntity>();
if (ds != null && ds.Tables.Count > 0)
{
pager.ItemList = MakeSysAccountInfoList(ds.Tables[0]);
}
pager.CurrentPage = query.CurrentPage;
pager.PageSize = query.PageSize;
pager.TotalRecords = recordCount;
return pager;
}
public List<SysAccountInfoEntity> GetSysAccountInfoList(SysAccountInfoQuery query)
{
List<SysAccountInfoEntity> list = new List<SysAccountInfoEntity>();
StringBuilder sqlCommandText = new StringBuilder();
sqlCommandText.Append("SELECT AdminID,UserName,LoginName,Pwd,Gender,Email,Mobile,Status,LastIP,LoginDate,LogOnTimes,AddDate FROM dbo.SysAccountInfo WITH(NOLOCK)");
string whereSQL = SysAccountInfoQueryToSQLWhere(query);
string orderBy = SysAccountInfoQueryToSQLOrder(query);
if (!string.IsNullOrEmpty(whereSQL)) sqlCommandText.Append(" WHERE " + whereSQL);
if (!string.IsNullOrEmpty(orderBy)) sqlCommandText.Append(" ORDER BY " + orderBy);
DbCommand cmd = db.GetSqlStringCommand(sqlCommandText.ToString());
using (IDataReader dr = db.ExecuteReader(cmd))
{
list = MakeSysAccountInfoList(dr);
}
return list;
}
public ActionResult IndexAjax(SysAccountInfoQuery queryEntity)
{
if (!Request.IsAjaxRequest())
{
return Content("{\"result\":\"error\",\"msg\":\"非法访问\"}");
}
else
{
ISysAccountInfoService accountService = ServiceContainer.Instance.Container.Resolve<ISysAccountInfoService>();
queryEntity.CurrentPage = queryEntity.CurrentPage + 1;
WKT.Model.Pager<SysAccountInfoEntity> sysAccountList = accountService.GetSysAccountInfoPageList(queryEntity);
if (sysAccountList != null)
{
return Content("{\"result\":\"success\",\"msg\":\"成功\",\"data\":" + JsonConvert.SerializeObject(sysAccountList) + "}");
}
else
{
return Content("{\"result\":\"error\",\"msg\":\"系统出现异常，请稍后再试\"}");
}
}
}
/// <summary>
/// 列表
/// </summary>
/// <returns></returns>
public ActionResult Index()
{
ViewBag.TotalCount = 0;
ISysAccountInfoService accountService = ServiceContainer.Instance.Container.Resolve<ISysAccountInfoService>();
SysAccountInfoQuery queryEntity = new SysAccountInfoQuery();
queryEntity.CurrentPage = 1;
Pager<SysAccountInfoEntity> pagerAccountList = accountService.GetSysAccountInfoPageList(queryEntity);
IList<SysAccountInfoEntity> listAccount = new List<SysAccountInfoEntity>();
if (pagerAccountList != null)
{
listAccount = pagerAccountList.ItemList;
ViewBag.TotalCount = pagerAccountList.TotalRecords;
}
return View(listAccount);
}
