private Dictionary <string, RTDVField> CreateRTDVFieldDictionary() { Dictionary <string, RTDVField> dictionary; RTDVField field; // create a new dictionary dictionary = new Dictionary <string, RTDVField>(); //OrderID field = new RTDVField("OrderID", TypeCode.Int32); field.DisplayName = "OrderID"; field.Size = 4; field.MinOccurs = 0; field.MaxOccurs = 1; dictionary.Add("OrderID", field); //ProductID field = new RTDVField("ProductID", TypeCode.Int32); field.DisplayName = "ProductID"; field.Size = 4; field.MinOccurs = 0; field.MaxOccurs = 1; dictionary.Add("ProductID", field); //UnitPrice field = new RTDVField("UnitPrice", TypeCode.Decimal); field.DisplayName = "UnitPrice"; field.Size = 8; field.MinOccurs = 0; field.MaxOccurs = 1; dictionary.Add("UnitPrice", field); //Discount field = new RTDVField("Discount", TypeCode.Decimal); field.DisplayName = "Discount"; field.Size = 4; field.MinOccurs = 0; field.MaxOccurs = 1; dictionary.Add("Discount", field); //Quantity field = new RTDVField("Quantity", TypeCode.Int16); field.DisplayName = "Quantity"; field.Size = 2; field.MinOccurs = 0; field.MaxOccurs = 1; dictionary.Add("Quantity", field); return(dictionary); }
private Dictionary <string, RTDVField> CreateRTDVFieldDictionary() { Dictionary <string, RTDVField> dictionary; RTDVField field; // create a new dictionary dictionary = new Dictionary <string, RTDVField>(); //BirthDate field = new RTDVField("BirthDate", TypeCode.DateTime); field.DisplayName = "BirthDate"; field.Size = 8; field.MinOccurs = 0; field.MaxOccurs = 1; dictionary.Add("BirthDate", field); //HireDate field = new RTDVField("HireDate", TypeCode.DateTime); field.DisplayName = "HireDate"; field.Size = 8; field.MinOccurs = 0; field.MaxOccurs = 1; dictionary.Add("HireDate", field); //EmployeeID field = new RTDVField("EmployeeID", TypeCode.Int16); field.DisplayName = "EmployeeID"; field.Size = 4; field.MinOccurs = 0; field.MaxOccurs = 1; dictionary.Add("EmployeeID", field); //ReportsTo field = new RTDVField("ReportsTo", TypeCode.Int16); field.DisplayName = "ReportsTo"; field.Size = 4; field.MinOccurs = 0; field.MaxOccurs = 1; dictionary.Add("ReportsTo", field); //Notes field = new RTDVField("Notes", TypeCode.String); //ntext field.DisplayName = "Notes"; field.Size = 2000; field.MinOccurs = 0; field.MaxOccurs = 1; dictionary.Add("Notes", field); //HomePhone field = new RTDVField("HomePhone", TypeCode.String); field.DisplayName = "HomePhone"; field.Size = 48; field.MinOccurs = 0; field.MaxOccurs = 1; dictionary.Add("HomePhone", field); //Extension field = new RTDVField("Extension", TypeCode.String); field.DisplayName = "Extension"; field.Size = 8; field.MinOccurs = 0; field.MaxOccurs = 1; dictionary.Add("Extension", field); //Region field = new RTDVField("Region", TypeCode.String); field.DisplayName = "Region"; field.Size = 30; field.MinOccurs = 0; field.MaxOccurs = 1; dictionary.Add("Region", field); //PostalCode field = new RTDVField("PostalCode", TypeCode.String); field.DisplayName = "PostalCode"; field.Size = 20; field.MinOccurs = 0; field.MaxOccurs = 1; dictionary.Add("PostalCode", field); //Country field = new RTDVField("Country", TypeCode.String); field.DisplayName = "Country"; field.Size = 30; field.MinOccurs = 0; field.MaxOccurs = 1; dictionary.Add("Country", field); //TitleOfCourtesy field = new RTDVField("TitleOfCourtesy", TypeCode.String); field.DisplayName = "TitleOfCourtesy"; field.Size = 50; field.MinOccurs = 0; field.MaxOccurs = 1; dictionary.Add("TitleOfCourtesy", field); //Address field = new RTDVField("Address", TypeCode.String); field.DisplayName = "Address"; field.Size = 120; field.MinOccurs = 0; field.MaxOccurs = 1; dictionary.Add("Address", field); //City field = new RTDVField("City", TypeCode.String); field.DisplayName = "City"; field.Size = 30; field.MinOccurs = 0; field.MaxOccurs = 1; dictionary.Add("City", field); //LastName field = new RTDVField("LastName", TypeCode.String); field.DisplayName = "LastName"; field.Size = 40; field.MinOccurs = 0; field.MaxOccurs = 1; dictionary.Add("LastName", field); //FirstName field = new RTDVField("FirstName", TypeCode.String); field.DisplayName = "FirstName"; field.Size = 20; field.MinOccurs = 0; field.MaxOccurs = 1; dictionary.Add("FirstName", field); //Title field = new RTDVField("Title", TypeCode.String); field.DisplayName = "Title"; field.Size = 60; field.MinOccurs = 0; field.MaxOccurs = 1; dictionary.Add("Title", field); //ReportsToName field = new RTDVField("ReportsToName", TypeCode.String); field.DisplayName = "ReportsToName"; field.Size = 40; field.MinOccurs = 0; field.MaxOccurs = 1; dictionary.Add("ReportsToName", field); return(dictionary); }
private Dictionary <string, RTDVField> CreateRTDVFieldDictionary() { Dictionary <string, RTDVField> dictionary; RTDVField field; // create a new dictionary dictionary = new Dictionary <string, RTDVField>(); //AccountID field = new RTDVField("AccountID", TypeCode.String); field.DisplayName = "Account ID"; field.Size = 1024; field.MinOccurs = 0; field.MaxOccurs = 1; dictionary.Add("AccountID", field); //Type field = new RTDVField("Type", TypeCode.String); field.DisplayName = "Type"; field.Size = 1024; field.MinOccurs = 0; field.MaxOccurs = 1; dictionary.Add("Type", field); //CreatedBy field = new RTDVField("CreatedBy", TypeCode.String); field.DisplayName = "Created By"; field.Size = 1024; field.MinOccurs = 0; field.MaxOccurs = 1; dictionary.Add("CreatedBy", field); //DatePaymentDue field = new RTDVField("DatePaymentDue", TypeCode.Int32); field.DisplayName = "Date Payment Due"; field.MinOccurs = 0; field.MaxOccurs = 1; dictionary.Add("DatePaymentDue", field); //OrderID field = new RTDVField("OrderID", TypeCode.Int32); field.DisplayName = "Order ID"; field.MinOccurs = 0; field.MaxOccurs = 1; dictionary.Add("OrderID", field); //Value field = new RTDVField("Value", TypeCode.Decimal); field.DisplayName = "Value"; field.MinOccurs = 0; field.MaxOccurs = 1; dictionary.Add("Value", field); //Value field = new RTDVField("OrderDate", TypeCode.DateTime); field.DisplayName = "Order Date"; field.MinOccurs = 0; field.MaxOccurs = 1; dictionary.Add("OrderDate", field); return(dictionary); }
private Dictionary <string, RTDVField> CreateRTDVFieldDictionary() { Dictionary <string, RTDVField> dictionary; RTDVField field; // create a new dictionary dictionary = new Dictionary <string, RTDVField>(); //ProductID field = new RTDVField("ProductID", TypeCode.Int32); field.DisplayName = "Product ID"; field.MinOccurs = 0; field.MaxOccurs = 1; dictionary.Add("ProductID", field); //ProductName field = new RTDVField("ProductName", TypeCode.String); field.DisplayName = "Product Name"; field.Size = 40; field.MinOccurs = 0; field.MaxOccurs = 1; dictionary.Add("ProductName", field); //UnitsInStock field = new RTDVField("UnitsInStock", TypeCode.Int16); field.DisplayName = "Units In Stock"; field.MinOccurs = 0; field.MaxOccurs = 1; dictionary.Add("UnitsInStock", field); //UnitsOnStockAfterOrder field = new RTDVField("UnitsOnStockAfterOrder", TypeCode.Int32); field.DisplayName = "Units On Stock After Order"; field.MinOccurs = 0; field.MaxOccurs = 1; dictionary.Add("UnitsOnStockAfterOrder", field); //ReorderLevel field = new RTDVField("ReorderLevel", TypeCode.Int16); field.DisplayName = "Reorder Level"; field.MinOccurs = 0; field.MaxOccurs = 1; dictionary.Add("ReorderLevel", field); //CompanyName field = new RTDVField("CompanyName", TypeCode.String); field.DisplayName = "Company Name"; field.Size = 40; field.MinOccurs = 0; field.MaxOccurs = 1; dictionary.Add("CompanyName", field); //CompanyName field = new RTDVField("ContactName", TypeCode.String); field.DisplayName = "Contact Name"; field.Size = 30; field.MinOccurs = 0; field.MaxOccurs = 1; dictionary.Add("ContactName", field); //CompanyName field = new RTDVField("Address", TypeCode.String); field.DisplayName = "Address"; field.Size = 60; field.MinOccurs = 0; field.MaxOccurs = 1; dictionary.Add("Address", field); //City field = new RTDVField("City", TypeCode.String); field.DisplayName = "City"; field.Size = 15; field.MinOccurs = 0; field.MaxOccurs = 1; dictionary.Add("City", field); //City field = new RTDVField("Region", TypeCode.String); field.DisplayName = "Region"; field.Size = 15; field.MinOccurs = 0; field.MaxOccurs = 1; dictionary.Add("Region", field); //PostalCode field = new RTDVField("PostalCode", TypeCode.String); field.DisplayName = "Postal Code"; field.Size = 10; field.MinOccurs = 0; field.MaxOccurs = 1; dictionary.Add("PostalCode", field); //Country field = new RTDVField("Country", TypeCode.String); field.DisplayName = "Country"; field.Size = 15; field.MinOccurs = 0; field.MaxOccurs = 1; dictionary.Add("Country", field); //Phone field = new RTDVField("Phone", TypeCode.String); field.DisplayName = "Phone"; field.Size = 24; field.MinOccurs = 0; field.MaxOccurs = 1; dictionary.Add("Phone", field); //Fax field = new RTDVField("Fax", TypeCode.String); field.DisplayName = "Fax"; field.Size = 24; field.MinOccurs = 0; field.MaxOccurs = 1; dictionary.Add("Fax", field); return(dictionary); }
private Dictionary <string, RTDVField> CreateRTDVFieldDictionary() { Dictionary <string, RTDVField> dictionary; RTDVField field; // create a new dictionary dictionary = new Dictionary <string, RTDVField>(); //ID field = new RTDVField("ID", TypeCode.String); field.DisplayName = "ID"; field.Size = 1024; field.MinOccurs = 0; field.MaxOccurs = 1; dictionary.Add("ID", field); //AccountID field = new RTDVField("AccountID", TypeCode.String); field.DisplayName = "Account ID"; field.Size = 1024; field.MinOccurs = 0; field.MaxOccurs = 1; dictionary.Add("AccountID", field); //ItemCode field = new RTDVField("ItemCode", TypeCode.Int32); field.DisplayName = "Item Code"; field.MinOccurs = 0; field.MaxOccurs = 1; dictionary.Add("ItemCode", field); //ItemName field = new RTDVField("ItemName", TypeCode.String); field.DisplayName = "Item Name"; field.Size = 40; field.MinOccurs = 0; field.MaxOccurs = 1; dictionary.Add("ItemName", field); //Quantity field = new RTDVField("Quantity", TypeCode.Decimal); field.DisplayName = "Quantity"; field.MinOccurs = 0; field.MaxOccurs = 1; dictionary.Add("Quantity", field); //UnitPrice field = new RTDVField("UnitPrice", TypeCode.Decimal); field.DisplayName = "Unit Price"; field.MinOccurs = 0; field.MaxOccurs = 1; dictionary.Add("UnitPrice", field); //Value field = new RTDVField("Value", TypeCode.Decimal); field.DisplayName = "Value"; field.MinOccurs = 0; field.MaxOccurs = 1; dictionary.Add("Value", field); //LastPurchaseDate field = new RTDVField("LastPurchaseDate", TypeCode.DateTime); field.DisplayName = "Last Purchase Date"; field.MinOccurs = 0; field.MaxOccurs = 1; dictionary.Add("LastPurchaseDate", field); //Description field = new RTDVField("Description", TypeCode.String); field.DisplayName = "Description"; field.Size = 1024; field.MinOccurs = 0; field.MaxOccurs = 1; dictionary.Add("Description", field); //Discount field = new RTDVField("Discount", TypeCode.Decimal); field.DisplayName = "Discount"; field.MinOccurs = 0; field.MaxOccurs = 1; dictionary.Add("Discount", field); return(dictionary); }