//插入图片微博
public static void InsertImageWebos(List <ImageWeibo> imageWeibos, string userName)
{
SQLiteConnection connection = DataBaseConnection(userName);
if (connection.State != System.Data.ConnectionState.Open)
{
connection.Open();
SQLiteCommand command = new SQLiteCommand();
command.Connection = connection;
SQLiteDataReader reader = null;
foreach (ImageWeibo weibo in imageWeibos)
{
try
{
string weiboText = weibo.WeiboMessage;
string[] pics = weibo.Pictures;
string picsString = "";
if (pics.Length != 0)
{
picsString += pics[0];
for (int i = 1; i < (pics.Length < 9 ? pics.Length : 9); i++)
{
//字符串间以“#”间隔
picsString += ("#" + pics[i]);
}
}
command.CommandText = String.Format("SELECT COUNT(*) FROM imageweibos WHERE imageids = '{0}'", picsString);
command.ExecuteNonQuery();
reader = command.ExecuteReader();
reader.Read();
int count = reader.GetInt32(0);
reader.Close();
if (count == 0)
{
command.CommandText = String.Format("INSERT INTO imageweibos VALUES('{0}','{1}',false)", picsString, weiboText);
command.ExecuteNonQuery();
}
else
{
command.CommandText = String.Format("SELECT rowid,* From imageweibos WHERE imageids = '{0}'", picsString);
command.ExecuteNonQuery();
reader = command.ExecuteReader();
reader.Read();
int rowid = reader.GetInt32(0);
string dbText = reader.GetString(2);
reader.Close();
if (dbText.Length < weiboText.Length)
{
command.CommandText = String.Format("UPDATE imageweibos SET weibotext = '{0}' WHERE rowid = {1}", weiboText, rowid.ToString());
command.ExecuteNonQuery();
}
}
}
catch (Exception ex)
{
UserLog.WriteNormalLog(userName, "插入图片微博失败", ex.Message);
}
}
connection.Close();
}
}
