public void LoadDataList_TextBox(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();
#warning change inline sql to stored procedure
SqlCommand cmd = new SqlCommand("SELECT * FROM EditField_TextBox WHERE EditFieldID IN (" + ids + ")", conn);
using (SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection))
{
while (reader.Read())
{
TextBoxEditField.TextBoxData data = new TextBoxEditField.TextBoxData();
data.Text = reader["Value"].ToString();
map[Convert.ToInt64(reader["EditFieldID"])].Data = data;
}
reader.Close();
}
}
}
}
public void LoadDataList_TextBox(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_TextBox WHERE EditFieldID IN (" + ids + ")", conn);
using (SQLiteDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection))
{
while (reader.Read())
{
TextBoxEditField.TextBoxData data = new TextBoxEditField.TextBoxData();
data.Text = reader["Value"].ToString();
map[Convert.ToInt64(reader["EditFieldID"])].Data = data;
}
reader.Close();
}
}
}
}
