/// <summary> /// /// </summary> /// <param name="parame"></param> /// <param name="totalSize"></param> /// <returns></returns> public List <StatModel> GetIpStatList(IpStatListReq parame, ref int totalSize) { DbCommand cmd = GetStoredProcCommand("P_ActionLog_IpStatList"); 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, "@keyword", DbType.String, parame.keyword); AddOutParameter(cmd, "@totalSize", DbType.Int32, totalSize); DataSet ds = ExecuteDataSet(cmd); int.TryParse(cmd.Parameters["@totalSize"].Value.ToString(), out totalSize); List <StatModel> statList = new List <StatModel>(); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { foreach (DataRow dr in ds.Tables[0].Rows) { statList.Add(new StatModel() { StatName = To <string>(dr, "IpAddress"), Count = To <Int32>(dr, "Counts") }); } } return(statList); }
public ActionResult IpAccessList(int ps = 20, int pi = 1, int bh = 0, int eh = 24, string keyWord = "") { int totalSize = 0; List <StatModel> IpList = new List <StatModel>(); IpStatListReq parame = new IpStatListReq() { beginHour = bh, endHour = eh, keyword = keyWord, ps = ps, pi = pi }; IpList = actionLogBll.GetIpStatList(parame, ref totalSize); ViewBag.Count = totalSize; ViewBag.PageIndex = pi; ViewBag.PageSize = ps; ViewBag.KeyWord = keyWord; ViewBag.BeginHour = bh; ViewBag.EndHour = eh; ViewBag.PageTotal = (int)Math.Ceiling((double)ViewBag.Count / ps); return(View(IpList)); }
/// <summary> /// /// </summary> /// <param name="parame"></param> /// <param name="totalSize"></param> /// <returns></returns> public List <StatModel> GetIpStatList(IpStatListReq parame, ref int totalSize) { return(actionLogDal.GetIpStatList(parame, ref totalSize)); }