public override List <string> AdminDeleteUserAllEmoticon(int userID) { using (SqlQuery query = new SqlQuery()) { query.CommandType = CommandType.StoredProcedure; query.CommandText = "bx_Emoticon_DeleteUserAllEmoticons"; query.CreateParameter <int>("@UserID", userID, SqlDbType.Int); List <string> filenames = new List <string>(); using (XSqlDataReader reader = query.ExecuteReader()) { while (reader.Read()) { filenames.Add(reader.GetString(0)); } } return(filenames); } }
public override List <string> AdminiDeleteEmoticons(int userID, IEnumerable <int> emoticonIds) { using (SqlQuery query = new SqlQuery()) { query.CommandType = CommandType.StoredProcedure; query.CommandText = "bx_Emoticon_AdminDeleteEmoticons"; query.CreateParameter <int>("@UserID", userID, SqlDbType.Int); query.CreateParameter <string>("@EmoticonIDs", StringUtil.Join(emoticonIds), SqlDbType.VarChar, 8000); List <string> filenames = new List <string>(); using (XSqlDataReader reader = query.ExecuteReader()) { while (reader.Read()) { filenames.Add(reader.GetString(0)); } } return(filenames); } }
public override List <string> DeleteGroup(int userID, int groupID) { List <string> canDeleteFiles = new List <string>(); using (SqlQuery query = new SqlQuery()) { query.CommandType = CommandType.StoredProcedure; query.CommandText = "bx_Emoticon_DeleteEmoticonGroup"; query.CreateParameter <int>("@GroupID", groupID, SqlDbType.Int); query.CreateParameter <int>("@UserID", userID, SqlDbType.Int); using (XSqlDataReader reader = query.ExecuteReader()) { while (reader.Read()) { canDeleteFiles.Add(reader.GetString(0)); } } } return(canDeleteFiles); }
public override DataBaseInfo GetDataBaseInfo() { string version = ""; using (SqlQuery query = new SqlQuery()) { query.CommandText = "SELECT size*8,(status & 0x40) as type FROM sysfiles;SELECT @@VERSION"; DataBaseInfo dataBaseInfo = new DataBaseInfo(); using (XSqlDataReader reader = query.ExecuteReader()) { int dataSize = 0; int logoSize = 0; while (reader.Read()) { if (reader.GetInt32(1) == 0) { dataSize += reader.GetInt32(0); } else { logoSize += reader.GetInt32(0); } } if (reader.NextResult()) { while (reader.Read()) { version += "(" + reader.GetString(0) + ")"; } } dataBaseInfo.DataSize = dataSize * 1024; dataBaseInfo.LogSize = logoSize * 1024; dataBaseInfo.Version = version; } return(dataBaseInfo); } }