protected void Page_Load(object sender, EventArgs e) { int banid = _Request.Get <int>("banid", Method.Get, 0); if (banid > 0) { List <BanForumInfo> foruminfos = LogManager.GetBanForumInfos(banid); string jsonString = JsonBuilder.GetJson(foruminfos); Response.Write(jsonString); Response.End(); return; } if (_Request.IsClick("search")) { m_Filter = BanUserLogFilter.GetFromForm(); m_Filter.Apply("filter", "page"); } m_Filter = BanUserLogFilter.GetFromFilter("filter"); int page = _Request.Get <int>("page", 0); m_BanUserOperationList = LogManager.GetBanUserLogsBySearch(Filter, page); m_TotalCount = m_BanUserOperationList.TotalRecords; }
public static BanUserOperationCollection GetBanUserLogsBySearch(BanUserLogFilter filter, int pagenumber) { return(OperationLogDao.Instance.GetBanUserLogsBySearch(filter, pagenumber)); }
public override BanUserOperationCollection GetBanUserLogsBySearch(BanUserLogFilter filter, int pagenumber) { using (SqlQuery query = new SqlQuery()) { StringBuilder condition = new StringBuilder(); string SortField = "OperationTime"; if (filter.OrderBy != null) { switch (filter.OrderBy) { case BanUserLogSortOrder.LogID: SortField = "LogID"; break; case BanUserLogSortOrder.OperationType: SortField = "OperationType"; break; case BanUserLogSortOrder.UserID: SortField = "UserID"; break; case BanUserLogSortOrder.UserName: SortField = "UserName"; break; default: 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 (filter.ForumID != null) { condition.Append(" AND LogID IN( SELECT LogID FROM bx_BanUserLogForumInfos WHERE ForumID=@ForumID)"); query.CreateParameter<int>("@ForumID", filter.ForumID.Value, SqlDbType.Int); } if (filter.OperationType != null) { condition.Append(" AND OperationType=@OperationType"); query.CreateParameter<int>("@OperationType", (int)filter.OperationType.Value, SqlDbType.Int); } if (filter.BeginDate != null) { condition.Append(" AND OperationTime>=@BeginDate"); query.CreateParameter<DateTime>("@BeginDate", filter.BeginDate.Value, SqlDbType.DateTime); } if (filter.EndDate != null) { condition.Append(" AND OperationTime<=@EndDate"); query.CreateParameter<DateTime>("@EndDate", filter.EndDate.Value, SqlDbType.DateTime); } query.Pager.SortField = SortField; query.Pager.PageNumber = pagenumber; query.Pager.PageSize = filter.PageSize; query.Pager.TableName = "bx_BanUserLogs"; query.Pager.PrimaryKey = "LogID"; query.Pager.IsDesc = filter != null ? filter.IsDesc : true; query.Pager.SelectCount = true; if (condition.Length > 0) { query.Pager.Condition = condition.ToString().Substring(4); } using (XSqlDataReader reader = query.ExecuteReader()) { BanUserOperationCollection collection = new BanUserOperationCollection(reader); if (reader.NextResult()) { while(reader.Next) collection.TotalRecords = reader.Get<int>(0); } return collection; } } }
public static BanUserOperationCollection GetBanUserLogsBySearch(BanUserLogFilter filter, int pagenumber) { return OperationLogDao.Instance.GetBanUserLogsBySearch(filter, pagenumber); }
public abstract BanUserOperationCollection GetBanUserLogsBySearch(BanUserLogFilter filter, int pagenumber);
public override BanUserOperationCollection GetBanUserLogsBySearch(BanUserLogFilter filter, int pagenumber) { using (SqlQuery query = new SqlQuery()) { StringBuilder condition = new StringBuilder(); string SortField = "OperationTime"; if (filter.OrderBy != null) { switch (filter.OrderBy) { case BanUserLogSortOrder.LogID: SortField = "LogID"; break; case BanUserLogSortOrder.OperationType: SortField = "OperationType"; break; case BanUserLogSortOrder.UserID: SortField = "UserID"; break; case BanUserLogSortOrder.UserName: SortField = "UserName"; break; default: 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 (filter.ForumID != null) { condition.Append(" AND LogID IN( SELECT LogID FROM bx_BanUserLogForumInfos WHERE ForumID=@ForumID)"); query.CreateParameter <int>("@ForumID", filter.ForumID.Value, SqlDbType.Int); } if (filter.OperationType != null) { condition.Append(" AND OperationType=@OperationType"); query.CreateParameter <int>("@OperationType", (int)filter.OperationType.Value, SqlDbType.Int); } if (filter.BeginDate != null) { condition.Append(" AND OperationTime>=@BeginDate"); query.CreateParameter <DateTime>("@BeginDate", filter.BeginDate.Value, SqlDbType.DateTime); } if (filter.EndDate != null) { condition.Append(" AND OperationTime<=@EndDate"); query.CreateParameter <DateTime>("@EndDate", filter.EndDate.Value, SqlDbType.DateTime); } query.Pager.SortField = SortField; query.Pager.PageNumber = pagenumber; query.Pager.PageSize = filter.PageSize; query.Pager.TableName = "bx_BanUserLogs"; query.Pager.PrimaryKey = "LogID"; query.Pager.IsDesc = filter != null ? filter.IsDesc : true; query.Pager.SelectCount = true; if (condition.Length > 0) { query.Pager.Condition = condition.ToString().Substring(4); } using (XSqlDataReader reader = query.ExecuteReader()) { BanUserOperationCollection collection = new BanUserOperationCollection(reader); if (reader.NextResult()) { while (reader.Next) { collection.TotalRecords = reader.Get <int>(0); } } return(collection); } } }