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