public void LoadDataList_Image(List <EditFieldInfo> fields) { if (fields.Count == 0) { return; } StringBuilder ids = new StringBuilder(); Dictionary <long, EditFieldInfo> map = new Dictionary <long, EditFieldInfo>(); foreach (EditFieldInfo info in fields) { if (info.DataID > 0) { map.Add(info.DataID, info); if (ids.Length > 0) { ids.Append(","); } ids.Append(info.DataID); } } using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Suppress)) { using (SqlConnection conn = new SqlConnection(DatabaseManager.DatabaseEngine.ConnectionString)) { conn.Open(); SqlCommand cmd = new SqlCommand("SELECT * FROM EditField_Image WHERE EditFieldID IN (" + ids + ")", conn); using (SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection)) { while (reader.Read()) { ImageEditField.ImageEditFieldData data = new ImageEditField.ImageEditFieldData(); data.SprocketFileID = Convert.ToInt64(reader["SprocketFileID"]); map[Convert.ToInt64(reader["EditFieldID"])].Data = data; } reader.Close(); } } } }
public void LoadDataList_Image(List<EditFieldInfo> fields) { if (fields.Count == 0) return; StringBuilder ids = new StringBuilder(); Dictionary<long, EditFieldInfo> map = new Dictionary<long, EditFieldInfo>(); foreach (EditFieldInfo info in fields) if (info.DataID > 0) { map.Add(info.DataID, info); if (ids.Length > 0) ids.Append(","); ids.Append(info.DataID); } using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Suppress)) { using (SQLiteConnection conn = new SQLiteConnection(DatabaseManager.DatabaseEngine.ConnectionString)) { conn.Open(); SQLiteCommand cmd = new SQLiteCommand("SELECT * FROM EditField_Image WHERE EditFieldID IN (" + ids + ")", conn); using (SQLiteDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection)) { while (reader.Read()) { ImageEditField.ImageEditFieldData data = new ImageEditField.ImageEditFieldData(); data.SprocketFileID = Convert.ToInt64(reader["SprocketFileID"]); map[Convert.ToInt64(reader["EditFieldID"])].Data = data; } reader.Close(); } } } }