/// <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));
}
