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