private List <string> GetValues(string tableName, string propName)
{
DepotDbConnector depotDbConnector = DepotDbConnector.GetInstance();
DataSet ds = depotDbConnector.SelectQuerry("SELECT " + propName + " FROM " + tableName);
List <string> list = new List <string>();
object val;
List <object> listObj = new List <object>();
string s;
foreach (DataRow row in ds.Tables[0].Rows)
{
val = row[propName];
listObj.Add(val);
}
HashSet <object> list2 = new HashSet <object>(listObj);
listObj = new List <object>(list2);
listObj.Sort();
foreach (var it in listObj)
{
try
{
s = ((DateTime)it).ToString("d");
}
catch
{
s = it.ToString();
}
list.Add(s);
}
return(list);
}
private DataSet FindValues(string tableName, string condition)
{
DepotDbConnector depotDbConnector = DepotDbConnector.GetInstance();
DataSet ds = depotDbConnector.SelectQuerry(
"SELECT * FROM " + tableName + " where " + condition);
return(ds);
}
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;
}
}