/// <summary> /// 删除隐藏页和父页的关联 /// </summary> /// <param name="pid"></param> /// <param name="parentID"></param> /// <returns></returns> public int Delete(int pid, int parentID) { string cmdText = "DELETE FROM R_PageParent WHERE PID=@PID AND PARENTID=@ParentID"; SqlParameter[] sqlparams = new SqlParameter[] { new SqlParameter("@PID", pid), new SqlParameter("@ParentID", parentID) }; object obj = SQLHelpers.TcAdmin().ExecuteNonQuery(cmdText, sqlparams); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 增加权限组, 返回新增加的标识列 /// 增加失败返回0 /// <param name="gname">用户组名</param> /// </summary> public int Add(string gname) { string cmdText = "insert into R_Group(GName) values (@GName);select @@IDENTITY"; SqlParameter[] parameters = { new SqlParameter("@GName", gname) }; object obj = SQLHelpers.TcAdmin().ExecuteNonQuery(cmdText, parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 修改管理员最后登录时间 /// </summary> /// <param name="aid">管理员ID</param> /// <param name="ip">最后登录时间</param> /// <returns></returns> public int ModifyLastTime(int aid, DateTime time) { string cmdText = "UPDATE [R_Admin] SET [ALastTime] = @ALastTime WHERE AID=@AID"; SqlParameter[] sqlparams = new SqlParameter[] { new SqlParameter("@ALastTime", time), new SqlParameter("@AID", aid) }; object obj = SQLHelpers.TcAdmin().ExecuteNonQuery(cmdText, sqlparams); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 修改管理员IP /// </summary> /// <param name="aid">管理员ID</param> /// <param name="ip">IP地址</param> /// <returns></returns> public int ModifyIp(int aid, string ip) { string cmdText = "UPDATE [R_Admin] SET [IP] = @IP WHERE AID=@AID"; SqlParameter[] sqlparams = new SqlParameter[] { new SqlParameter("@IP", ip), new SqlParameter("@AID", aid) }; object obj = SQLHelpers.TcAdmin().ExecuteNonQuery(cmdText, sqlparams); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 删除权限组 /// 返回受影响的行数,删除失败返回0 /// <param name="GID">用户组ID</param> /// </summary> public int Delete(int GID) { string cmdText = "delete from R_Group where GID=@GID "; SqlParameter[] parameters = { new SqlParameter("@GID", GID) }; object obj = SQLHelpers.TcAdmin().ExecuteNonQuery(cmdText, parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 增加一条删除隐藏页和父页的关联, 返回新增加的标识列 /// 增加失败返回0 /// <param name="pid">页面ID</param> /// <param name="parentid">父页面ID</param> /// </summary> public int Add(int pid, int parentid) { string cmdText = "insert into R_PageParent(PID,ParentID) values(@PID,@ParentID)"; SqlParameter[] parameters = { new SqlParameter("@PID", pid), new SqlParameter("@ParentID", parentid) }; object obj = SQLHelpers.TcAdmin().ExecuteNonQuery(cmdText, parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 重置管理员密码 /// </summary> /// <param name="adminId">管理员ID</param> /// <param name="newPwd">MD5加密过的新密码</param> /// <returns></returns> public int ResetPwd(int adminId, string newPwd) { string cmdText = "update R_Admin set APwd=@APwd where AID=@AID"; SqlParameter[] parameters = { new SqlParameter("@AID", adminId), new SqlParameter("@APwd", newPwd) }; object obj = SQLHelpers.TcAdmin().ExecuteNonQuery(cmdText, parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 根据url完整匹配得到model /// <param name="urlPath">页面URL完整匹配</param> /// </summary> public MR_PageInfo GetModel(string urlPath) { string cmdText = "select top 1 p.PID," + SELECT_ALL_COL_NOPK + " from R_PageInfo p where PUrl=@url"; SqlParameter[] parameters = { new SqlParameter("@url", urlPath) }; DataTable dtbl = SQLHelpers.TcAdmin().ExecuteFillDataTable(cmdText, parameters); if (dtbl.Rows.Count > 0) { return(Safe.Base.Utility.ModelConvertHelper <MR_PageInfo> .ToModel(dtbl.Rows[0])); } else { return(null); } }
/// <summary> /// 更新用户组名称 /// 返回受影响的行数,更新失败返回0 /// <param name="gname">用户组名</param> /// </summary> public int Update(int gid, string gname) { string cmdText = "update R_Group set GName=@GName where GID=@GID"; SqlParameter[] parameters = { new SqlParameter("@GID", gid), new SqlParameter("@GName", gname) }; object obj = SQLHelpers.TcAdmin().ExecuteNonQuery(cmdText, parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个权限记录实体 /// </summary> /// <param name="AID">管理员ID</param> /// <param name="PID">页面ID</param> public MR_AdminRight GetModel(int AID, int PID) { string cmdText = "select top 1 AID,PID,BtnRightExp,ClickTimes from R_AdminRight where AID=@AID and PID=@PID "; SqlParameter[] parameters = { new SqlParameter("@AID", AID), new SqlParameter("@PID", PID) }; DataTable dtbl = SQLHelpers.TcAdmin().ExecuteFillDataTable(cmdText, parameters); if (dtbl.Rows.Count > 0) { return(Safe.Base.Utility.ModelConvertHelper <MR_AdminRight> .ToModel(dtbl.Rows[0])); } else { return(null); } }
/// <summary> /// 更新点击数,返回受影响的行数 /// 更新失败返回0 /// <param name="aid">管理员ID</param> /// <param name="pid">页面ID</param> /// </summary> public int UpdateClick(int aid, int pid) { string cmdText = "update R_AdminRight set ClickTimes=ClickTimes+1 where AID=@AID and PID=@PID"; SqlParameter[] parameters = { new SqlParameter("@AID", aid), new SqlParameter("@PID", pid) }; object obj = SQLHelpers.TcAdmin().ExecuteNonQuery(cmdText, parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个管理员信息实体 /// <param name="AName">管理员登录名</param> /// </summary> public MR_Admin GetModelForSign(string AName) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 AID,AName,ANickName,IP,Email,R_Admin.GID,R_Admin.ALastTime ,case when R_Admin.GID=-1 then '超级管理员' else R_Group.GName end as GName from R_Admin "); strSql.Append("left join R_Group on R_Admin.GID = R_Group.GID"); strSql.Append(" where R_Admin.AName=@AName "); SqlParameter[] parameters = { new SqlParameter("@AName", AName) }; DataTable dtbl = SQLHelpers.TcAdmin().ExecuteFillDataTable(strSql.ToString(), parameters); if (dtbl.Rows.Count > 0) { return(Safe.Base.Utility.ModelConvertHelper <MR_Admin> .ToModel(dtbl.Rows[0])); } else { return(null); } }
/// <summary> /// 更新节点,返回受影响的行数 /// 更新失败返回0 /// </summary> public int Update(string text, string url, int queue, int nodeId, bool defShowChild) { string cmdtext = "update R_PageInfo set PName=@PName,Queue=@Queue,PUrl=@PUrl,DefShowChild=@DefShowChild where PID=@PID "; SqlParameter[] parameters = { new SqlParameter("@PID", nodeId), new SqlParameter("@PName", text), new SqlParameter("@Queue", queue), new SqlParameter("@PUrl", url), new SqlParameter("@DefShowChild", defShowChild) }; object obj = SQLHelpers.TcAdmin().ExecuteNonQuery(cmdtext, parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
private void GetChilds(int adminId, int parentID, bool incluedChild, ref IList <MR_PageInfo> result, ref Safe.Base.Contract.IDbHelper dbhelper) { StringBuilder sb = new StringBuilder(); sb.Append("select a.*,b.btnrightexp from r_pageinfo as a left join r_adminright as b on a.pid=b.pid where b.aid=@aid and a.parentID=@parentID order by a.Queue asc, b.ClickTimes desc"); SqlParameter[] sqlparams = new SqlParameter[] { new SqlParameter("@aid", adminId), new SqlParameter("@parentID", parentID) }; DataTable tbl = SQLHelpers.TcAdmin().ExecuteFillDataTable(sb.ToString(), sqlparams); result = Safe.Base.Utility.ModelConvertHelper <MR_PageInfo> .ToModels(tbl); //该结点的子节点 if (incluedChild && result != null) { foreach (MR_PageInfo tmpc in result) { IList <MR_PageInfo> childs = null; GetChilds(adminId, tmpc.PID, incluedChild, ref childs, ref dbhelper); tmpc.Childs = childs.ToList(); } } }
/// <summary> /// 增加管理员信息 /// 返回新增加的标识列,如果增加失败返回0 /// </summary> public int Add(MR_Admin model) { string pname = "p_AddAdmin"; SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@AName", model.AName), new SqlParameter("@APwd", model.APwd), new SqlParameter("@ANickName", model.ANickName), new SqlParameter("@Email", model.Email), new SqlParameter("@GID", model.GID) }; object obj = SQLHelpers.TcAdmin().ExecuteNonQuery(pname, CommandType.StoredProcedure, parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 检测一批URL是否都存在库中,返回不存在的列表 /// </summary> /// <param name="urls"></param> /// <returns></returns> public List <string> CheckPageURLs(IEnumerable <string> urls) { if (urls == null) { return(new List <string>()); } string sql = @"select u as 'PUrl' from("; string sp = ""; foreach (var f in urls) { var path = f.TrimEx(); if (path.IsEmpty()) { continue; } sql += sp; sql += " select '" + path.Replace("'", "''") + "' u "; sp = " union "; } sql += @")pu left join R_PageInfo p on p.PUrl=pu.u where p.PId is NULL"; return(SQLHelpers.TcAdmin().ExecuteFillDataTable(sql).ToModels <MR_PageInfo>().Select(p => p.PUrl).ToList()); }
/// <summary> /// 根据管理员登录名取得昵称 /// </summary> /// <param name="adminName"></param> /// <returns></returns> public string GetNickNameByName(string adminName) { string sql = "select top 1 ANickName from R_Admin where AName=@AName"; return(SQLHelpers.TcAdmin().ExecuteScalar(sql, new SqlParameter("@AName", adminName)).GetString(adminName)); }