internal IEnumerable GetTable(string tableName, DataSet ds) { switch (tableName) { case "state": return(StateTable.DataSetToList(ds)); case "destination": return(DestinationTable.DataSetToList(ds)); case "fashion": return(FashionTable.DataSetToList(ds)); case "manufacturer": return(ManufacturerTable.DataSetToList(ds)); case "material": return(MaterialTable.DataSetToList(ds)); case "material_type": return(MaterialTypeTable.DataSetToList(ds)); case "orders": return(OrdersTable.DataSetToList(ds)); case "received_material": return(ReceivedMaterialTable.DataSetToList(ds)); case "issued_materials": return(IssuedMaterialsTable.DataSetToList(ds)); case "materialview": return(MaterialViewTable.DataSetToList(ds)); case "issuedview": return(IssuedViewTable.DataSetToList(ds)); case "receivedview": return(ReceivedViewTable.DataSetToList(ds)); case "ordersview": return(OrdersViewTable.DataSetToList(ds)); } throw new Exception(); }
public void OpenTable(string tableName) { DepotDbConnector depotDbConnector = DepotDbConnector.GetInstance(); DataSet ds = depotDbConnector.SelectQuerry("SELECT * FROM " + tableName); //MessageBox.Show(tableName); switch (tableName) { case "state": StateTable.DataSetToList(ds); break; case "destination": DestinationTable.DataSetToList(ds); break; case "fashion": FashionTable.DataSetToList(ds); break; case "manufacturer": ManufacturerTable.DataSetToList(ds); break; case "material": MaterialTable.DataSetToList(ds); break; case "material_type": MaterialTypeTable.DataSetToList(ds); break; case "orders": OrdersTable.DataSetToList(ds); break; case "received_material": ReceivedMaterialTable.DataSetToList(ds); break; case "issued_materials": IssuedMaterialsTable.DataSetToList(ds); break; case "materialview": MaterialViewTable.DataSetToList(ds); break; case "issuedview": IssuedViewTable.DataSetToList(ds); break; case "receivedview": ReceivedViewTable.DataSetToList(ds); break; case "ordersview": OrdersViewTable.DataSetToList(ds); break; } }