public override InviteSerialStat GetStat(int userID) { UpdateExpiresSerialStatus(); using (SqlQuery query = new SqlQuery()) { query.CommandText = "bx_UserInviteSerialStatInfo"; query.CommandType = CommandType.StoredProcedure; query.CreateParameter <int>("@UserID", userID, SqlDbType.Int); using (XSqlDataReader reader = query.ExecuteReader()) { if (reader.Read()) { return(new InviteSerialStat(reader)); } } } InviteSerialStat stat = new InviteSerialStat(); stat.UserID = userID; return(stat); }
public override InviteSerialStat GetStat(int userID) { UpdateExpiresSerialStatus(); using (SqlQuery query = new SqlQuery()) { query.CommandText = "bx_UserInviteSerialStatInfo"; query.CommandType = CommandType.StoredProcedure; query.CreateParameter<int>("@UserID", userID, SqlDbType.Int); using (XSqlDataReader reader = query.ExecuteReader()) { if (reader.Read()) return new InviteSerialStat(reader); } } InviteSerialStat stat = new InviteSerialStat(); stat.UserID = userID; return stat; }