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; }