public override PropLogCollection GetPropLogs(int userID, PropLogType type, int pageNumber, int pageSize)
{
using(SqlQuery query = new SqlQuery())
{
query.Pager.TableName = "bx_PropLogs";
query.Pager.SortField = "PropLogID";
query.Pager.PageNumber = pageNumber;
query.Pager.PageSize = pageSize;
query.Pager.SelectCount = true;
query.Pager.Condition = "UserID = @UserID";
query.CreateParameter<int>("@UserID", userID, SqlDbType.Int);
if(type != PropLogType.All)
{
query.CreateParameter<PropLogType>("@Type", type, SqlDbType.TinyInt);
query.Pager.Condition += " AND Type = @Type";
}
using (XSqlDataReader reader = query.ExecuteReader())
{
PropLogCollection result = new PropLogCollection(reader);
if(reader.NextResult() && reader.Read())
result.TotalRecords = reader.Get<int>(0);
return result;
}
}
}
public override PropLogCollection GetPropLogs(int userID, PropLogType type, int pageNumber, int pageSize)
{
using (SqlQuery query = new SqlQuery())
{
query.Pager.TableName = "bx_PropLogs";
query.Pager.SortField = "PropLogID";
query.Pager.PageNumber = pageNumber;
query.Pager.PageSize = pageSize;
query.Pager.SelectCount = true;
query.Pager.Condition = "UserID = @UserID";
query.CreateParameter <int>("@UserID", userID, SqlDbType.Int);
if (type != PropLogType.All)
{
query.CreateParameter <PropLogType>("@Type", type, SqlDbType.TinyInt);
query.Pager.Condition += " AND Type = @Type";
}
using (XSqlDataReader reader = query.ExecuteReader())
{
PropLogCollection result = new PropLogCollection(reader);
if (reader.NextResult() && reader.Read())
{
result.TotalRecords = reader.Get <int>(0);
}
return(result);
}
}
}
public override void AddPropLog(int userID, PropLogType logType, string log)
{
using (SqlQuery query = new SqlQuery())
{
query.CommandText = "bx_Prop_AddPropLog";
query.CommandType = CommandType.StoredProcedure;
query.CreateParameter <int>("@UserID", userID, SqlDbType.Int);
query.CreateParameter <PropLogType>("@Type", logType, SqlDbType.TinyInt);
query.CreateParameter <string>("@Log", log, SqlDbType.NText);
query.ExecuteNonQuery();
}
}
public override void AddPropLog(int userID, PropLogType logType, string log)
{
using(SqlQuery query = new SqlQuery())
{
query.CommandText = "bx_Prop_AddPropLog";
query.CommandType = CommandType.StoredProcedure;
query.CreateParameter<int>("@UserID", userID, SqlDbType.Int);
query.CreateParameter<PropLogType>("@Type", logType, SqlDbType.TinyInt);
query.CreateParameter<string>("@Log", log, SqlDbType.NText);
query.ExecuteNonQuery();
}
}
public string IsSelected(PropLogType type, string output)
{
if (m_SelectedType == null)
{
m_SelectedType = _Request.Get <PropLogType>("type", MaxLabs.WebEngine.Method.Get);
if (m_SelectedType == null)
{
m_SelectedType = PropLogType.All;
}
}
return(m_SelectedType.Value == type ? output : string.Empty);
}
protected void Page_Load(object sender, EventArgs e)
{
PropBO.Instance.ReplenishProps();
int pageNumber = _Request.Get <int>("page", 1);
PropLogType type = _Request.Get <PropLogType>("type", PropLogType.All);
m_LogList = PropBO.Instance.GetPropLogs(MyUserID, type, pageNumber, LogListPageSize);
m_TotalLogCount = m_LogList.TotalRecords;
m_Status = PropBO.Instance.GetUserPropStatus(My);
SetPager("pager1", null, pageNumber, LogListPageSize, m_TotalLogCount);
AddNavigationItem("道具", BbsRouter.GetUrl("prop/index"));
AddNavigationItem("道具记录");
}
public string IsSelected(PropLogType type, string output)
{
if(m_SelectedType == null)
{
m_SelectedType = _Request.Get<PropLogType>("type", MaxLabs.WebEngine.Method.Get);
if(m_SelectedType == null)
m_SelectedType = PropLogType.All;
}
return m_SelectedType.Value == type ? output : string.Empty;
}
