/// <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();
}
}
/// <summary>
/// 取得管理员在某个页面下是否有子项
/// </summary>
/// <param name="pid"></param>
/// <param name="aid"></param>
/// <returns></returns>
private IList <MR_PageInfo> GetChild(int pid, int aid, ref Safe.Base.Contract.IDbHelper dbhelper)
{
StringBuilder sb = new StringBuilder();
sb.Append("SELECT R_PageInfo.* FROM R_PageInfo LEFT JOIN R_AdminRight on R_AdminRight.PID = R_PageInfo.PID WHERE R_AdminRight.AID=@aid and R_PageInfo.ParentID=@pid ");
DataTable dt = dbhelper.ExecuteFillDataTable(sb.ToString(), new SqlParameter("@aid", aid), new SqlParameter("@pid", pid));
if (dt == null)
{
return(null);
}
if (dt.Rows.Count == 0)
{
return(null);
}
return(Safe.Base.Utility.ModelConvertHelper <MR_PageInfo> .ToModels(dt));
}
