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