protected void Page_Load(object sender, EventArgs e) { if (_Request.IsClick("search")) { m_Filter = OperationLogFilter.GetFromForm(); m_Filter.Apply("filter", "page"); } m_Filter = OperationLogFilter.GetFromFilter("filter"); int page = _Request.Get <int>("page", 0); m_OperationLogList = Logs.LogManager.GetOperationLogsBySearch(MyUserID, page, m_Filter); m_OperationLogTotalCount = m_OperationLogList.TotalRecords; }
/* [StoredProcedure(Name="bx_InsertBanUserLogs",Script= @" CREATE PROCEDURE {name} @OperationType varchar(50), @OperatorName nvarchar(50), @Cause nvarchar(1000), @ForumInfos varchar(1000), @TargetID int, @TargetName nvarchar(200), @TargetIP varchar(50) AS BEGIN SET NOCOUNT ON; INSERT INTO [bx_BanUserLogs]( OperationType, OperatorName, Cause, ForumID, BeginDate, EndDate, TargetID, TargetName, TargetIP ) Values( @OperationType, @OperatorName, @Cause, @ForumID, @BeginDate, @EndDate, @TargetID, @TargetName, @TargetIP ); END ")] public override void InsertBanUserOperationLog(BanUserOperation banuser) { using (SqlQuery query = new SqlQuery()) { query.CommandText = "bx_InsertBanUserLogs"; query.CommandType = CommandType.StoredProcedure; query.CreateParameter<string>("@OperationType", banuser.OperationType, SqlDbType.VarChar, 50); query.CreateParameter<string>("@OperationName", banuser.OperatorName, SqlDbType.NVarChar, 50); query.CreateParameter<string>("@Cause", banuser.Cause, SqlDbType.NVarChar, 200); // query.CreateParameter<int>("@ForumID", banuser.ForumID, SqlDbType.Int); query.CreateParameter<DateTime>("@BeginDate",banuser.BeginDate,SqlDbType.DateTime); query.CreateParameter<DateTime>("@EndDate", banuser.EndDate, SqlDbType.DateTime); query.CreateParameter<int>("@TargetID",banuser.UserID,SqlDbType.Int); query.CreateParameter<string>("@TargetName",banuser.UserName,SqlDbType.NVarChar,50); query.CreateParameter<string>("@TargetIP",banuser.UserIP,SqlDbType.VarChar,50); query.ExecuteNonQuery(); } } */ public override OperationLogCollection GetOperationLogsBySearch(int pageNumber, OperationLogFilter filter) { using (SqlQuery db = new SqlQuery()) { db.Pager.TableName = "bx_OperationLogs"; db.Pager.SortField = "LogID"; db.Pager.PageSize = filter.PageSize; SqlConditionBuilder sb = new SqlConditionBuilder(SqlConditionStart.None); if (filter.OperatorID != null) { sb.Append("OperatorID = @OperatorID"); db.CreateParameter<int>("@OperatorID", filter.OperatorID.Value, SqlDbType.Int); } else if (filter.OperatorName != null && filter.OperatorName != string.Empty) { sb.Append("OperatorID IN (SELECT UserID FROM bx_Users WHERE Username = @OperatorName)"); db.CreateParameter<string>("@OperatorName", filter.OperatorName, SqlDbType.NVarChar, 50); } if (filter.OperatorIP != null && filter.OperatorIP != string.Empty) { sb.Append("OperatorIP = @OperatorIP"); db.CreateParameter<string>("@OperatorIP", filter.OperatorIP, SqlDbType.VarChar, 50); } if (filter.OperationType != null && filter.OperationType != string.Empty) { sb.Append("OperationType = @OperationType"); db.CreateParameter<string>("@OperationType", filter.OperationType, SqlDbType.VarChar, 100); } if (filter.TargetID_1 != null) { sb.Append("TargetID_1 = @TargetID_1"); db.CreateParameter<int>("@TargetID_1", filter.TargetID_1.Value, SqlDbType.Int); } if (filter.TargetID_2 != null) { sb.Append("TargetID_2 = @TargetID_2"); db.CreateParameter<int>("@TargetID_2", filter.TargetID_2.Value, SqlDbType.Int); } if (filter.TargetID_3 != null) { sb.Append("TargetID_3 = @TargetID_3"); db.CreateParameter<int>("@TargetID_3", filter.TargetID_3.Value, SqlDbType.Int); } if (filter.BeginDate != null) { sb.Append("CreateTime >= @BeginDate"); db.CreateParameter<DateTime>("@BeginDate", filter.BeginDate.Value, SqlDbType.DateTime); } if (filter.EndDate != null) { sb.Append("CreateTime <= @EndDate"); db.CreateParameter<DateTime>("@EndDate", filter.EndDate.Value, SqlDbType.DateTime); } db.Pager.Condition = sb.ToString(); db.Pager.PageNumber = pageNumber; db.Pager.SelectCount = true; using (XSqlDataReader reader = db.ExecuteReader()) { OperationLogCollection result = new OperationLogCollection(reader); reader.NextResult(); reader.Read(); result.TotalRecords = reader.Get<int>(0); return result; } } }
public static OperationLogCollection GetOperationLogsBySearch(int searchOperatorID, int pageNumber, OperationLogFilter filter) { return OperationLogDao.Instance.GetOperationLogsBySearch(pageNumber, filter); }
/* [StoredProcedure(Name="bx_InsertBanUserLogs",Script= @" * CREATE PROCEDURE {name} * @OperationType varchar(50), * @OperatorName nvarchar(50), * @Cause nvarchar(1000), * @ForumInfos varchar(1000), * @TargetID int, * @TargetName nvarchar(200), * @TargetIP varchar(50) * AS * BEGIN * SET NOCOUNT ON; * INSERT INTO [bx_BanUserLogs]( * OperationType, * OperatorName, * Cause, * ForumID, * BeginDate, * EndDate, * TargetID, * TargetName, * TargetIP * ) Values( * @OperationType, * @OperatorName, * @Cause, * @ForumID, * @BeginDate, * @EndDate, * @TargetID, * @TargetName, * @TargetIP * ); * END * ")] * * public override void InsertBanUserOperationLog(BanUserOperation banuser) * { * using (SqlQuery query = new SqlQuery()) * { * query.CommandText = "bx_InsertBanUserLogs"; * query.CommandType = CommandType.StoredProcedure; * * query.CreateParameter<string>("@OperationType", banuser.OperationType, SqlDbType.VarChar, 50); * query.CreateParameter<string>("@OperationName", banuser.OperatorName, SqlDbType.NVarChar, 50); * query.CreateParameter<string>("@Cause", banuser.Cause, SqlDbType.NVarChar, 200); * // query.CreateParameter<int>("@ForumID", banuser.ForumID, SqlDbType.Int); * query.CreateParameter<DateTime>("@BeginDate",banuser.BeginDate,SqlDbType.DateTime); * query.CreateParameter<DateTime>("@EndDate", banuser.EndDate, SqlDbType.DateTime); * query.CreateParameter<int>("@TargetID",banuser.UserID,SqlDbType.Int); * query.CreateParameter<string>("@TargetName",banuser.UserName,SqlDbType.NVarChar,50); * query.CreateParameter<string>("@TargetIP",banuser.UserIP,SqlDbType.VarChar,50); * * query.ExecuteNonQuery(); * } * } */ public override OperationLogCollection GetOperationLogsBySearch(int pageNumber, OperationLogFilter filter) { using (SqlQuery db = new SqlQuery()) { db.Pager.TableName = "bx_OperationLogs"; db.Pager.SortField = "LogID"; db.Pager.PageSize = filter.PageSize; SqlConditionBuilder sb = new SqlConditionBuilder(SqlConditionStart.None); if (filter.OperatorID != null) { sb.Append("OperatorID = @OperatorID"); db.CreateParameter <int>("@OperatorID", filter.OperatorID.Value, SqlDbType.Int); } else if (filter.OperatorName != null && filter.OperatorName != string.Empty) { sb.Append("OperatorID IN (SELECT UserID FROM bx_Users WHERE Username = @OperatorName)"); db.CreateParameter <string>("@OperatorName", filter.OperatorName, SqlDbType.NVarChar, 50); } if (filter.OperatorIP != null && filter.OperatorIP != string.Empty) { sb.Append("OperatorIP = @OperatorIP"); db.CreateParameter <string>("@OperatorIP", filter.OperatorIP, SqlDbType.VarChar, 50); } if (filter.OperationType != null && filter.OperationType != string.Empty) { sb.Append("OperationType = @OperationType"); db.CreateParameter <string>("@OperationType", filter.OperationType, SqlDbType.VarChar, 100); } if (filter.TargetID_1 != null) { sb.Append("TargetID_1 = @TargetID_1"); db.CreateParameter <int>("@TargetID_1", filter.TargetID_1.Value, SqlDbType.Int); } if (filter.TargetID_2 != null) { sb.Append("TargetID_2 = @TargetID_2"); db.CreateParameter <int>("@TargetID_2", filter.TargetID_2.Value, SqlDbType.Int); } if (filter.TargetID_3 != null) { sb.Append("TargetID_3 = @TargetID_3"); db.CreateParameter <int>("@TargetID_3", filter.TargetID_3.Value, SqlDbType.Int); } if (filter.BeginDate != null) { sb.Append("CreateTime >= @BeginDate"); db.CreateParameter <DateTime>("@BeginDate", filter.BeginDate.Value, SqlDbType.DateTime); } if (filter.EndDate != null) { sb.Append("CreateTime <= @EndDate"); db.CreateParameter <DateTime>("@EndDate", filter.EndDate.Value, SqlDbType.DateTime); } db.Pager.Condition = sb.ToString(); db.Pager.PageNumber = pageNumber; db.Pager.SelectCount = true; using (XSqlDataReader reader = db.ExecuteReader()) { OperationLogCollection result = new OperationLogCollection(reader); reader.NextResult(); reader.Read(); result.TotalRecords = reader.Get <int>(0); return(result); } } }