public void addTableSource(DITableSource table)
{
string strQuery = "INSERT INTO [DI].[TABLE_SOURCE]([TableID],[QueryID],[Type]) VALUES(@TableID,@QueryID,@Type)";
Dictionary<string, object> parameters = new Dictionary<string, object>();
parameters.Add("@TableID", table.TableID);
parameters.Add("@QueryID", table.QueryID);
parameters.Add("@Type", table.Type);
executeNonQuery(strQuery, parameters);
}
public List<DITableSource> getTableSource(string QueryID)
{
string strSelect = "SELECT [TableID],[QueryID],[Type] FROM [DI].[TABLE_SOURCE] WHERE [QueryID] = @QueryID";
Dictionary<string, object> parameters = new Dictionary<string, object>();
parameters.Add("@QueryID", QueryID);
SqlDataReader dr = executeReader(strSelect, parameters);
List<DITableSource> list = new List<DITableSource>();
while (dr.Read())
{
DITableSource obj = new DITableSource();
obj.TableID = dr.GetString(dr.GetOrdinal("TableID"));
obj.QueryID = dr.GetString(dr.GetOrdinal("QueryID"));
obj.Type = dr.GetString(dr.GetOrdinal("Type"));
list.Add(obj);
}
dr.Close();
return list;
}
