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