/// <summary>
///
/// </summary>
/// <param name="parame"></param>
/// <param name="totalSize"></param>
/// <returns></returns>
public List <PublicUserModel> GetUserAccessStatList(UserAccessListReq parame, ref int totalSize)
{
DbCommand cmd = GetStoredProcCommand("P_ActionLog_UserAccessList");
AddInParameter(cmd, "@pi", DbType.Int32, parame.pi);
AddInParameter(cmd, "@ps", DbType.Int32, parame.ps);
AddInParameter(cmd, "@beginHour", DbType.Int32, parame.beginHour);
AddInParameter(cmd, "@endHour", DbType.Int32, parame.endHour);
AddInParameter(cmd, "@IpAddress", DbType.String, parame.IpAddress);
AddOutParameter(cmd, "@totalSize", DbType.Int32, totalSize);
DataSet ds = ExecuteDataSet(cmd);
int.TryParse(cmd.Parameters["@totalSize"].Value.ToString(), out totalSize);
List <PublicUserModel> statList = new List <PublicUserModel>();
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
return(BuildPublucUserList(ds.Tables[0].Select()));
}
return(statList);
}
public ActionResult UserAccessList(int ps = 100, int pi = 1, int bh = 0, int eh = 24, string IpAddress = "")
{
int totalSize = 0;
List <PublicUserModel> userList = new List <PublicUserModel>();
UserAccessListReq parame = new UserAccessListReq()
{
beginHour = bh,
endHour = eh,
IpAddress = IpAddress,
ps = ps,
pi = pi
};
userList = userBll.GetUserAccessStatList(parame, ref totalSize);
ViewBag.Count = totalSize;
ViewBag.PageIndex = pi;
ViewBag.PageSize = ps;
ViewBag.IpAddress = IpAddress;
ViewBag.BeginHour = bh;
ViewBag.EndHour = eh;
ViewBag.PageTotal = (int)Math.Ceiling((double)ViewBag.Count / ps);
return(View(userList));
}
/// <summary>
///
/// </summary>
/// <param name="parame"></param>
/// <param name="totalSize"></param>
/// <returns></returns>
public List <PublicUserModel> GetUserAccessStatList(UserAccessListReq parame, ref int totalSize)
{
return(userDal.GetUserAccessStatList(parame, ref totalSize));
}
