public override InviteSerialCollection GetInviteSerials(int operatorUserID, InviteSerialStatus status, string filter, int pageNumber, out int totalCount) { using (SqlQuery query = new SqlQuery()) { StringBuffer Condition = new StringBuffer(); Condition += " AND UserID = @UserID"; query.CreateParameter <int>("@UserID", operatorUserID, SqlDbType.Int); if (status != InviteSerialStatus.All) { if (status != InviteSerialStatus.Expires) { Condition += " AND [Status] = @Status"; query.CreateParameter <byte>("@Status", (byte)status, SqlDbType.TinyInt); } else if (status == InviteSerialStatus.Expires) { Condition += " AND Status <> 1 AND ExpiresDate <= GETDATE()"; } } if (string.IsNullOrEmpty(filter) == false) { Condition += " AND (Serial LIKE '%'+ @word +'%' OR ToUserID IN( SELECT UserID FROM bx_Users WHERE Username LIKE '%'+ @word +'%' OR Realname LIKE '%'+ @word +'%' ))"; query.CreateParameter <string>("@word", filter, SqlDbType.NVarChar, 50); } if (Condition.Length > 0) { Condition.Remove(0, 5); } query.Pager.SortField = "CreateDate"; query.Pager.IsDesc = true; query.Pager.TableName = "[bx_InviteSerials]"; query.Pager.SelectCount = true; query.Pager.PageSize = 20; query.Pager.PageNumber = pageNumber > 0 ? pageNumber : 1; query.Pager.Condition = Condition.ToString(); query.Pager.PrimaryKey = "[ID]"; totalCount = 0; using (XSqlDataReader reader = query.ExecuteReader()) { InviteSerialCollection Serials = new InviteSerialCollection(reader); if (reader.NextResult()) { if (reader.Read()) { totalCount = reader.GetInt32(0); Serials.TotalRecords = totalCount; } } return(Serials); } } }
/// <summary> /// 获取邀请码列表 /// </summary> public InviteSerialCollection GetInviteSerials(AuthUser operatorUser, InviteSerialStatus status, string filter, int pageNumber, out int totalCount) { totalCount = 0; if (operatorUser == User.Guest) { ThrowError(new NotLoginError()); return(new InviteSerialCollection()); } return(InviteDao.Instance.GetInviteSerials(operatorUser.UserID, status, filter, pageNumber, out totalCount)); }
public void InviteSerialStatList( string sortBy , int pageSize , int PageNumber , GlobalTemplateMembers.CommonHeadFootTemplate head , GlobalTemplateMembers.CommonHeadFootTemplate foot , InviteSerialStatTemplate item) { if (pageSize <= 0) { pageSize = Consts.DefaultPageSize; } InviteSerialStatus orderType = InviteSerialStatus.All; InviteSerialStatCollection Stats; if (!string.IsNullOrEmpty(sortBy)) { sortBy = sortBy.Trim(); if (sortBy.Equals("used", StringComparison.OrdinalIgnoreCase)) { orderType = InviteSerialStatus.Used; } else if (sortBy.Equals("unused", StringComparison.OrdinalIgnoreCase)) { orderType = InviteSerialStatus.Unused; } else if (sortBy.Equals("noreg", StringComparison.OrdinalIgnoreCase)) { orderType = InviteSerialStatus.Unused; } else if (sortBy.Equals("expiress", StringComparison.OrdinalIgnoreCase)) { orderType = InviteSerialStatus.Expires; } } int rowCount; Stats = InviteBO.Instance.GetStatList(orderType, pageSize, PageNumber, out rowCount); head(new GlobalTemplateMembers.CommonHeadFootTemplateParams(rowCount, pageSize)); if (rowCount > 0) { UserBO.Instance.FillSimpleUsers(Stats); foreach (InviteSerialStat stat in Stats) { item.Invoke(stat); } } foot(new GlobalTemplateMembers.CommonHeadFootTemplateParams(rowCount, pageSize)); }
public static string InviteSerialStatus_Print(InviteSerialStatus status, string name) { switch (status) { case InviteSerialStatus.Used: return Lang.Common_Used; case InviteSerialStatus.Expires: return Lang.Common_Expires; case InviteSerialStatus.Unused: return Lang.Common_Unused; } return Lang.Common_Unused; }
public static string InviteSerialStatus_Print(InviteSerialStatus status, string name) { switch (status) { case InviteSerialStatus.Used: return(Lang.Common_Used); case InviteSerialStatus.Expires: return(Lang.Common_Expires); case InviteSerialStatus.Unused: return(Lang.Common_Unused); } return(Lang.Common_Unused); }
public override InviteSerialStatCollection GetStatList(InviteSerialStatus state, int pageSize, int pageNumber, out int rowCount) { UpdateExpiresSerialStatus(); using (SqlQuery query = new SqlQuery()) { string orderField = "[TotalSerial]"; switch (state) { case InviteSerialStatus.Used: orderField = "[Used]"; break; case InviteSerialStatus.Expires: orderField = "Expiress"; break; case InviteSerialStatus.Unused: orderField = "Unused"; break; } query.Pager.TableName = "bx_SerialCounter"; query.Pager.PageNumber = pageNumber > 0 ? pageNumber : 1; query.Pager.PageSize = pageSize > 0 ? pageSize : 20; query.Pager.SelectCount = true; query.Pager.SortField = orderField; query.Pager.PrimaryKey = "[UserID]"; rowCount = 0; using (XSqlDataReader reader = query.ExecuteReader()) { InviteSerialStatCollection stats = new InviteSerialStatCollection(reader); if (reader.NextResult()) { if (reader.Read()) { rowCount = reader.GetInt32(0); } } return(stats); } } }
public abstract InviteSerialCollection GetInviteSerials(int operatorUserID, InviteSerialStatus status, string filter, int pageNumber, out int totalCount);
public abstract InviteSerialStatCollection GetStatList(InviteSerialStatus state, int pageSize, int pageNumber, out int rowCount);
public override InviteSerialCollection GetInviteSerials(int operatorUserID, InviteSerialStatus status, string filter, int pageNumber, out int totalCount) { using (SqlQuery query = new SqlQuery()) { StringBuffer Condition = new StringBuffer(); Condition += " AND UserID = @UserID"; query.CreateParameter<int>("@UserID", operatorUserID, SqlDbType.Int); if (status != InviteSerialStatus.All) { if (status != InviteSerialStatus.Expires) { Condition += " AND [Status] = @Status"; query.CreateParameter<byte>("@Status", (byte)status, SqlDbType.TinyInt); } else if (status == InviteSerialStatus.Expires) { Condition += " AND Status <> 1 AND ExpiresDate <= GETDATE()"; } } if (string.IsNullOrEmpty(filter) == false) { Condition += " AND (Serial LIKE '%'+ @word +'%' OR ToUserID IN( SELECT UserID FROM bx_Users WHERE Username LIKE '%'+ @word +'%' OR Realname LIKE '%'+ @word +'%' ))"; query.CreateParameter<string>("@word", filter, SqlDbType.NVarChar, 50); } if (Condition.Length > 0) Condition.Remove(0, 5); query.Pager.SortField = "CreateDate"; query.Pager.IsDesc = true; query.Pager.TableName = "[bx_InviteSerials]"; query.Pager.SelectCount = true; query.Pager.PageSize = 20; query.Pager.PageNumber = pageNumber > 0 ? pageNumber : 1; query.Pager.Condition = Condition.ToString(); query.Pager.PrimaryKey = "[ID]"; totalCount = 0; using (XSqlDataReader reader = query.ExecuteReader()) { InviteSerialCollection Serials = new InviteSerialCollection(reader); if (reader.NextResult()) { if (reader.Read()) { totalCount = reader.GetInt32(0); Serials.TotalRecords = totalCount; } } return Serials; } } }
public override InviteSerialStatCollection GetStatList(InviteSerialStatus state, int pageSize, int pageNumber, out int rowCount) { UpdateExpiresSerialStatus(); using (SqlQuery query = new SqlQuery()) { string orderField = "[TotalSerial]"; switch (state) { case InviteSerialStatus.Used: orderField = "[Used]"; break; case InviteSerialStatus.Expires: orderField = "Expiress"; break; case InviteSerialStatus.Unused: orderField = "Unused"; break; } query.Pager.TableName = "bx_SerialCounter"; query.Pager.PageNumber = pageNumber > 0 ? pageNumber : 1; query.Pager.PageSize = pageSize > 0 ? pageSize : 20; query.Pager.SelectCount = true; query.Pager.SortField = orderField; query.Pager.PrimaryKey = "[UserID]"; rowCount = 0; using (XSqlDataReader reader = query.ExecuteReader()) { InviteSerialStatCollection stats = new InviteSerialStatCollection(reader); if (reader.NextResult()) { if (reader.Read()) rowCount = reader.GetInt32(0); } return stats; } } }
/// <summary> /// 邀请码统计列表 /// </summary> /// <returns></returns> public InviteSerialStatCollection GetStatList(InviteSerialStatus state, int pageSize, int pageNumber, out int rowCount) { return(InviteDao.Instance.GetStatList(state, pageSize, pageNumber, out rowCount)); }