public bool AddSysAccountInfo(SysAccountInfoEntity sysAccountInfoEntity) { bool flag = false; StringBuilder sqlCommandText = new StringBuilder(); sqlCommandText.Append("@UserName"); sqlCommandText.Append(", @LoginName"); sqlCommandText.Append(", @Pwd"); sqlCommandText.Append(", @Gender"); sqlCommandText.Append(", @Email"); sqlCommandText.Append(", @Mobile"); sqlCommandText.Append(", @Status"); DbCommand cmd = db.GetSqlStringCommand(String.Format("INSERT INTO dbo.SysAccountInfo ({0}) VALUES ({1})", sqlCommandText.ToString().Replace("@", ""), sqlCommandText.ToString())); db.AddInParameter(cmd, "@UserName", DbType.AnsiString, sysAccountInfoEntity.UserName); db.AddInParameter(cmd, "@LoginName", DbType.AnsiString, sysAccountInfoEntity.LoginName); db.AddInParameter(cmd, "@Pwd", DbType.AnsiString, sysAccountInfoEntity.Pwd); db.AddInParameter(cmd, "@Gender", DbType.Byte, sysAccountInfoEntity.Gender); db.AddInParameter(cmd, "@Email", DbType.AnsiString, sysAccountInfoEntity.Email); db.AddInParameter(cmd, "@Mobile", DbType.AnsiString, sysAccountInfoEntity.Mobile); db.AddInParameter(cmd, "@Status", DbType.Byte, sysAccountInfoEntity.Status);; try { db.ExecuteNonQuery(cmd); flag = true; } catch (SqlException sqlEx) { throw sqlEx; } return flag; }
protected override void OnActionExecuting(ActionExecutingContext filterContext) { if (TicketTool.IsLogin()) { AccountEntity = JsonConvert.DeserializeObject<SysAccountInfoEntity>(TicketTool.GetUserData()); } else { filterContext.HttpContext.Response.Redirect("/login/", true); } base.OnActionExecuting(filterContext); }
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="sysAccountInfo">SysAccountInfoEntity实体对象</param> /// <returns>true:删除成功 false:删除失败</returns> public bool DeleteSysAccountInfo(SysAccountInfoEntity sysAccountInfo) { return SysAccountInfoBusiness.DeleteSysAccountInfo(sysAccountInfo); }
/// <summary> /// 将实体数据存入存储媒介(持久化一个对象) /// </summary> /// <param name="sysAccountInfo">SysAccountInfoEntity实体对象</param> /// <returns>true:存储成功 false:存储失败</returns> public bool AddSysAccountInfo(SysAccountInfoEntity sysAccountInfo) { return SysAccountInfoBusiness.AddSysAccountInfo(sysAccountInfo); }
/// <summary> /// 更新存储媒介中的实体数据 /// </summary> /// <param name="sysAccountInfo">SysAccountInfoEntity实体对象</param> /// <returns>true:更新成功 false:更新失败</returns> public bool UpdateSysAccountInfo(SysAccountInfoEntity sysAccountInfo) { return SysAccountInfoBusiness.UpdateSysAccountInfo(sysAccountInfo); }
/// <summary> /// 从存储媒介删除实体数据 /// </summary> /// <param name="sysAccountInfo">SysAccountInfoEntity实体对象</param> /// <returns>true:删除成功 false:删除失败</returns> public bool DeleteSysAccountInfo(SysAccountInfoEntity sysAccountInfo) { return SysAccountInfoDataAccess.Instance.DeleteSysAccountInfo(sysAccountInfo); }
/// <summary> /// 将实体数据存入存储媒介(持久化一个对象) /// </summary> /// <param name="sysAccountInfo">SysAccountInfoEntity实体对象</param> /// <returns>true:存储成功 false:存储失败</returns> public bool AddSysAccountInfo(SysAccountInfoEntity sysAccountInfo) { return SysAccountInfoDataAccess.Instance.AddSysAccountInfo(sysAccountInfo); }
public bool UpdateSysAccountInfo(SysAccountInfoEntity sysAccountInfoEntity) { bool flag = false; StringBuilder whereCommandText = new StringBuilder(); whereCommandText.Append(" AdminID=@AdminID"); StringBuilder sqlCommandText = new StringBuilder(); sqlCommandText.Append(" UserName=@UserName"); sqlCommandText.Append(", LoginName=@LoginName"); sqlCommandText.Append(", Gender=@Gender"); sqlCommandText.Append(", Email=@Email"); sqlCommandText.Append(", Mobile=@Mobile"); sqlCommandText.Append(", Status=@Status"); DbCommand cmd = db.GetSqlStringCommand(String.Format("UPDATE dbo.SysAccountInfo SET {0} WHERE {1}", sqlCommandText.ToString(), whereCommandText.ToString())); db.AddInParameter(cmd, "@AdminID", DbType.Int32, sysAccountInfoEntity.AdminID); db.AddInParameter(cmd, "@UserName", DbType.AnsiString, sysAccountInfoEntity.UserName); db.AddInParameter(cmd, "@LoginName", DbType.AnsiString, sysAccountInfoEntity.LoginName); db.AddInParameter(cmd, "@Gender", DbType.Byte, sysAccountInfoEntity.Gender); db.AddInParameter(cmd, "@Email", DbType.AnsiString, sysAccountInfoEntity.Email); db.AddInParameter(cmd, "@Mobile", DbType.AnsiString, sysAccountInfoEntity.Mobile); db.AddInParameter(cmd, "@Status", DbType.Byte, sysAccountInfoEntity.Status); try { db.ExecuteNonQuery(cmd); flag = true; } catch (SqlException sqlEx) { throw sqlEx; } return flag; }
public List<SysAccountInfoEntity> MakeSysAccountInfoList(IDataReader dr) { List<SysAccountInfoEntity> list = new List<SysAccountInfoEntity>(); while (dr.Read()) { SysAccountInfoEntity sysAccountInfoEntity = new SysAccountInfoEntity(); sysAccountInfoEntity.AdminID = (Int32)dr["AdminID"]; sysAccountInfoEntity.UserName = (String)dr["UserName"]; sysAccountInfoEntity.LoginName = (String)dr["LoginName"]; sysAccountInfoEntity.Pwd = (String)dr["Pwd"]; sysAccountInfoEntity.Gender = (Byte)dr["Gender"]; sysAccountInfoEntity.Email = (String)dr["Email"]; sysAccountInfoEntity.Mobile = (String)dr["Mobile"]; sysAccountInfoEntity.Status = (Byte)dr["Status"]; sysAccountInfoEntity.LastIP = (String)dr["LastIP"]; sysAccountInfoEntity.LoginDate = (DateTime)dr["LoginDate"]; sysAccountInfoEntity.LogOnTimes = (Int32)dr["LogOnTimes"]; sysAccountInfoEntity.AddDate = (DateTime)dr["AddDate"]; list.Add(sysAccountInfoEntity); } dr.Close(); return list; }
public SysAccountInfoEntity MakeSysAccountInfo(DataRow dr) { SysAccountInfoEntity sysAccountInfoEntity = null; if (dr != null) { sysAccountInfoEntity = new SysAccountInfoEntity(); sysAccountInfoEntity.AdminID = (Int32)dr["AdminID"]; sysAccountInfoEntity.UserName = (String)dr["UserName"]; sysAccountInfoEntity.LoginName = (String)dr["LoginName"]; sysAccountInfoEntity.Pwd = (String)dr["Pwd"]; sysAccountInfoEntity.Gender = (Byte)dr["Gender"]; sysAccountInfoEntity.Email = (String)dr["Email"]; sysAccountInfoEntity.Mobile = (String)dr["Mobile"]; sysAccountInfoEntity.Status = (Byte)dr["Status"]; sysAccountInfoEntity.LastIP = (String)dr["LastIP"]; sysAccountInfoEntity.LoginDate = (DateTime)dr["LoginDate"]; sysAccountInfoEntity.LogOnTimes = (Int32)dr["LogOnTimes"]; sysAccountInfoEntity.AddDate = (DateTime)dr["AddDate"]; } return sysAccountInfoEntity; }
public bool DeleteSysAccountInfo(SysAccountInfoEntity sysAccountInfoEntity) { bool flag = false; StringBuilder sqlCommandText = new StringBuilder(); sqlCommandText.Append("DELETE FROM dbo.SysAccountInfo"); sqlCommandText.Append(" WHERE AdminID=@AdminID"); DbCommand cmd = db.GetSqlStringCommand(sqlCommandText.ToString()); db.AddInParameter(cmd, "@AdminID", DbType.Int32, sysAccountInfoEntity.AdminID); try { db.ExecuteNonQuery(cmd); flag = true; } catch (SqlException sqlEx) { throw sqlEx; } return flag; }
public ActionResult EditAjax(SysAccountInfoEntity accountEntity) { try { if (!Request.IsAjaxRequest()) { return Content("{\"result\":\"failure\",\"msg\":\"非法请求\"}"); } string msg = ""; if (ModelState.IsValid) { ISysAccountInfoService accountService = ServiceContainer.Instance.Container.Resolve<ISysAccountInfoService>(); accountEntity.Pwd = WKT.Common.Security.DES.Encrypt(accountEntity.Pwd); bool flag = accountService.UpdateSysAccountInfo(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 + "\"}"); } }