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