/// <summary>
/// 根据用户名获取一个管理员信息实体
/// <param name="aname">用户名</param>
/// </summary>
public MR_Admin GetModel(string aname, string ip)
{
Safe.Base.Contract.IDbHelper dbHelper = SQLHelpers.TcAdmin();
try {
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 AID,AName,ANickName,IP,Email,R_Admin.GID ,R_Admin.ALastTime from R_Admin ");
strSql.Append(" where AName=@AName ");
SqlParameter[] parameters =
{
new SqlParameter("@AName", aname)
};
DataTable dtbl = dbHelper.ExecuteFillDataTable(strSql.ToString(), parameters);
if (dtbl.Rows.Count > 0)
{
MR_Admin result = Safe.Base.Utility.ModelConvertHelper <MR_Admin> .ToModel(dtbl.Rows[0]);
dbHelper.ExecuteNonQuery("UPDATE R_Admin SET ALastTime=getdate() , IP=@ip Where AID=@aid", new SqlParameter("@aid", result.AID), new SqlParameter("@ip", ip));
return(result);
}
else
{
return(null);
}
} finally {
dbHelper.EndConnection();
}
}
private void Delete(int PID, int AID, Safe.Base.Contract.IDbHelper dbhelper)
{
IList <MR_PageInfo> childs = GetChild(PID, AID, ref dbhelper);
if (childs != null)
{
foreach (MR_PageInfo tmp in childs)
{
Delete(tmp.PID, AID, dbhelper);
}
}
string cmdText = "delete from R_AdminRight where AID=@AID and PID=@PID";
SqlParameter[] parameters = { new SqlParameter("@AID", AID), new SqlParameter("@PID", PID) };
dbhelper.ExecuteNonQuery(cmdText, parameters);
}
/// <summary>
/// 登录后取得对应权限，不含隐藏菜单
/// </summary>
/// <param name="adminId">管理员ID</param>
/// <param name="parentID">父节点ID</param>
/// <param name="includeChild">是否同时取子节点</param>
public IList <MR_PageInfo> GetMenus(int adminId, int parentID, bool includeChild, bool updateClickTime)
{
IList <MR_PageInfo> result = new List <MR_PageInfo>();
Safe.Base.Contract.IDbHelper tqmn = SQLHelpers.TcAdmin();
tqmn.SetHandClose(false);
try {
GetChilds(adminId, parentID, includeChild, ref result, ref tqmn);
if (result != null && result.Count > 0 && updateClickTime)
{
string sql = "UPDATE R_AdminRight SET ClickTimes=ClickTimes+1 WHERE AID=@AID AND PID=@PID";
tqmn.ExecuteNonQuery(sql, new SqlParameter("@AID", adminId), new SqlParameter("@PID", parentID));
}
return(result);
} finally {
tqmn.EndConnection();
}
}
