protected void Page_Load(object sender, EventArgs e) { if (_Request.IsClick("search")) { m_Filter = UserIPSearchFilter.GetFromForm(); m_Filter.Apply("filter", "page"); } m_Filter = UserIPSearchFilter.GetFromFilter("filter"); int page = _Request.Get <int>("page", 0); m_UserIPLogList = LogManager.GetUserIPLogsBySearch(Filter, page); m_UserIPLogListCount = m_UserIPLogList.TotalRecords; }
public static UserIPLogCollection GetUserIPLogsBySearch(UserIPSearchFilter filter, int pagenumber) { return(OperationLogDao.Instance.GetUserIPLogsBySearch(filter, pagenumber)); }
public override UserIPLogCollection GetUserIPLogsBySearch(UserIPSearchFilter filter, int pagenumber) { using (SqlQuery query = new SqlQuery()) { StringBuilder condition = new StringBuilder(); string SortField = "CreateDate"; if (filter != null) { switch (filter.OrderBy) { case UserIPLogSortOrder.Username: SortField = "Username"; break; case UserIPLogSortOrder.NewIP: SortField = "NewIP"; break; } if (!string.IsNullOrEmpty(filter.Username)) { condition.Append(" AND Username = @Username"); query.CreateParameter<string>("@Username", filter.Username, SqlDbType.NVarChar, 50); } if (filter.UserID != null) { condition.Append(" AND UserID=@UserID"); query.CreateParameter<int>("@UserID", filter.UserID.Value, SqlDbType.Int); } if (!string.IsNullOrEmpty(filter.NewIP)) { condition.Append(" AND NewIP=@NewIP"); query.CreateParameter<string>("@NewIP", filter.NewIP, SqlDbType.VarChar, 50); } if (filter.BeginDate != null) { condition.Append(" AND CreateDate>=@BeginDate"); query.CreateParameter<DateTime>("@BeginDate", filter.BeginDate.Value, SqlDbType.DateTime); } if (filter.EndDate != null) { condition.Append(" AND CreateDate<=@EndDate"); query.CreateParameter<DateTime>("@EndDate", filter.EndDate.Value, SqlDbType.DateTime); } } query.Pager.SortField = SortField; query.Pager.TableName = "bx_IPLogs"; query.Pager.PageSize = filter.PageSize; query.Pager.PageNumber = pagenumber; query.Pager.PrimaryKey = "LogID"; query.Pager.IsDesc = filter != null ? filter.IsDesc : true; if (condition.Length > 0) query.Pager.Condition = condition.ToString().Substring(4); query.Pager.SelectCount = true; using (XSqlDataReader reader = query.ExecuteReader()) { UserIPLogCollection iploglist = new UserIPLogCollection(reader); if (reader.NextResult()) { while (reader.Next) iploglist.TotalRecords = reader.Get<int>(0); } return iploglist; } } }
public static UserIPLogCollection GetUserIPLogsBySearch(UserIPSearchFilter filter, int pagenumber) { return OperationLogDao.Instance.GetUserIPLogsBySearch(filter, pagenumber); }
public abstract UserIPLogCollection GetUserIPLogsBySearch(UserIPSearchFilter filter, int pagenumber);
public override UserIPLogCollection GetUserIPLogsBySearch(UserIPSearchFilter filter, int pagenumber) { using (SqlQuery query = new SqlQuery()) { StringBuilder condition = new StringBuilder(); string SortField = "CreateDate"; if (filter != null) { switch (filter.OrderBy) { case UserIPLogSortOrder.Username: SortField = "Username"; break; case UserIPLogSortOrder.NewIP: SortField = "NewIP"; break; } if (!string.IsNullOrEmpty(filter.Username)) { condition.Append(" AND Username = @Username"); query.CreateParameter <string>("@Username", filter.Username, SqlDbType.NVarChar, 50); } if (filter.UserID != null) { condition.Append(" AND UserID=@UserID"); query.CreateParameter <int>("@UserID", filter.UserID.Value, SqlDbType.Int); } if (!string.IsNullOrEmpty(filter.NewIP)) { condition.Append(" AND NewIP=@NewIP"); query.CreateParameter <string>("@NewIP", filter.NewIP, SqlDbType.VarChar, 50); } if (filter.BeginDate != null) { condition.Append(" AND CreateDate>=@BeginDate"); query.CreateParameter <DateTime>("@BeginDate", filter.BeginDate.Value, SqlDbType.DateTime); } if (filter.EndDate != null) { condition.Append(" AND CreateDate<=@EndDate"); query.CreateParameter <DateTime>("@EndDate", filter.EndDate.Value, SqlDbType.DateTime); } } query.Pager.SortField = SortField; query.Pager.TableName = "bx_IPLogs"; query.Pager.PageSize = filter.PageSize; query.Pager.PageNumber = pagenumber; query.Pager.PrimaryKey = "LogID"; query.Pager.IsDesc = filter != null ? filter.IsDesc : true; if (condition.Length > 0) { query.Pager.Condition = condition.ToString().Substring(4); } query.Pager.SelectCount = true; using (XSqlDataReader reader = query.ExecuteReader()) { UserIPLogCollection iploglist = new UserIPLogCollection(reader); if (reader.NextResult()) { while (reader.Next) { iploglist.TotalRecords = reader.Get <int>(0); } } return(iploglist); } } }