public static bool GetImageVoteTable(ImageVoteType imagevote_type, out List<List<string>> imagelib_table)
{
imagelib_table = null;
if (_DatabaseInUse == DatabaseType.MySql)
{
// 查询数据库
string select_all_data = "select * from `" + imagevote_type.ToString() + "`;";
DataSet dataset = MySql.MySqlHelper.ExecuteQuery(select_all_data);
if (dataset.Tables[0].Rows.Count == 0)
return false;
// 保存查询结果
imagelib_table = new List<List<string>>(dataset.Tables[0].Rows.Count);
for (int i = 0; i < dataset.Tables[0].Rows.Count; i++)
{
DataRow row = dataset.Tables[0].Rows[i];
DataColumnCollection colums = dataset.Tables[0].Columns;
List<string> data = new List<string>(dataset.Tables[0].Columns.Count);
for (int j = 0; j < data.Capacity; j++)
{
data.Add(row[colums[j]].ToString());
}
imagelib_table.Add(data);
}
return true;
}
else
{
return false;
}
}
public static bool SaveImageVote(ImageVoteType imagevote_type, int user_info_id, List<string> votes)
{
string save_vote = "insert into `" + imagevote_type.ToString() + "` (`UserInfoID`, `Date`";
// 图像库打分表属性为图像库文件名称
List<string> scene_file_names = ImageDirectory.GetUndefinedSceneNames();
foreach(string file in scene_file_names)
{
int last_index_dot = file.LastIndexOf(@".");
string scene_name = file.Substring(0, last_index_dot);
save_vote += @",`" + scene_name + "`";
}
save_vote += ") values('" + user_info_id.ToString() + "','" + DateTime.Now.ToString() + "'";
foreach (string vote in votes)
{
save_vote += ",'" + vote + "'";
}
save_vote += ");";
if (_DatabaseInUse == DatabaseType.MySql)
{
if (MySql.MySqlHelper.ExecuteCommand(save_vote) != 1)
return false;
return true;
}
else
{
return false;
}
}
