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