//插入图片微博 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(); } }