public List<Adi_Brand> GetData(String Value) { String Query = "SELECT * FROM AdiBrand WHERE Value = @Value"; OleDbDataManager oDm = new OleDbDataManager(ConnectionString, Query, true); oDm.AddVarcharPara("Value", 4000, Value); return DataParser.ToList<Adi_Brand>(oDm.GetTable()); }
public List<ADI_InventoryDetails> GetData(String AdiNumber) { String Query = "SELECT * FROM AdiInventoryDetails WHERE AdiNumber = \"" + AdiNumber + "\""; OleDbDataManager oDm = new OleDbDataManager(ConnectionString, Query, true); //oDm.AddVarcharPara("AdiNumber", 4000, AdiNumber); return DataParser.ToList<ADI_InventoryDetails>(oDm.GetTable()); }
public List<ADI_Child> GetData(String AID_PART) { String Query = "SELECT * FROM ADIChild WHERE PART_NUM = \"" + AID_PART + "\""; OleDbDataManager oDm = new OleDbDataManager(ConnectionString, Query, true); //oDm.AddVarcharPara("AID_PART", 4000, AID_PART); return DataParser.ToList<ADI_Child>(oDm.GetTable()); }
public List<ADI_Inventory> GetData(String PART_NUM) { String Query = "SELECT * FROM ADIInventory WHERE PART_NUM = \"" + PART_NUM + "\""; OleDbDataManager oDm = new OleDbDataManager(ConnectionString, Query, true); //oDm.AddVarcharPara("PART_NUM", 4000, PART_NUM); return DataParser.ToList<ADI_Inventory>(oDm.GetTable()); }
public List<Final_Table> GetDataByAdiPart(String AID_PART) { String Query = "SELECT * FROM Final_Table WHERE AID_PART = \"" + AID_PART + "\""; OleDbDataManager oDm = new OleDbDataManager(ConnectionString, Query, true); //oDm.AddVarcharPara("AID_PART", 4000, AID_PART); return DataParser.ToList<Final_Table>(oDm.GetTable()); }
public List<ADI_InventoryDetails> GetData(String AdiNumber, String id, String dc, String region, String storeName) { String Query = "SELECT * FROM AdiInventoryDetails WHERE AdiNumber = \"" + AdiNumber + "\" and id = \"" + id + "\" and dc = \"" + dc + "\" and region = \"" + region + "\" and storeName = \"" + storeName + "\""; OleDbDataManager oDm = new OleDbDataManager(ConnectionString, Query, true); //oDm.AddVarcharPara("AdiNumber", 4000, AdiNumber); //oDm.AddVarcharPara("id", 4000, id); //oDm.AddVarcharPara("dc", 4000, dc); //oDm.AddVarcharPara("region", 4000, region); //oDm.AddVarcharPara("storename", 4000, storeName); return DataParser.ToList<ADI_InventoryDetails>(oDm.GetTable()); }
public List<InManufacturer> GetData(InManufacturer manufacturer) { String Query = "SELECT * FROM SecLockManufacturer WHERE Code = '" + manufacturer.Code +"' ORDER BY Name"; OleDbDataManager oDm = new OleDbDataManager(this.ConnectionString, Query, true); return DataParser.ToList<InManufacturer>(oDm.GetTable()); }
public int Count() { String Query = "SELECT COUNT(1) FROM SecLockManufacturer WITH (NOLOCK)"; OleDbDataManager oDm = new OleDbDataManager(this.ConnectionString, Query, true); return (int)oDm.GetTable().Rows[0][0]; }
public List<ADI_Inventory> GetData() { String Query = "SELECT * FROM ADIInventory"; OleDbDataManager oDm = new OleDbDataManager(ConnectionString, Query, true); return DataParser.ToList<ADI_Inventory>(oDm.GetTable()); }
public List<InManufacturerSeries> GetData(InManufacturerSeries manufacturer) { String Query = "SELECT * FROM SecLockManufacturerSeries WHERE ID = " + manufacturer.ID +" ORDER BY Name"; OleDbDataManager oDm = new OleDbDataManager(this.ConnectionString, Query, true); return DataParser.ToList<InManufacturerSeries>(oDm.GetTable()); }
public int Count(InManufacturer manufacturer) { String Query = "SELECT COUNT(1) FROM SecLockManufacturerSeries WITH (NOLOCK) WHERE ManufacturerCode = '" + manufacturer.Code + "'"; OleDbDataManager oDm = new OleDbDataManager(this.ConnectionString, Query, true); return (int)oDm.GetTable().Rows[0][0]; }
public int Count() { String Query = "SELECT * FROM Final_Table WHERE SLD_PART IS NOT NULL"; OleDbDataManager oDm = new OleDbDataManager(ConnectionString, Query, true); return (int)oDm.GetTable().Rows[0][0]; }
public int ValidADIProduct(string VDR_PART) { String Query = "SELECT COUNT(1) FROM Final_Table WHERE VDR_PART = @VDR_PART"; OleDbDataManager oDm = new OleDbDataManager(ConnectionString, Query, true); oDm.AddVarcharPara("VDR_PART", 4000, VDR_PART); return (int) oDm.GetTable().Rows[0][0]; }
public List<FinalTable> GetProductByPARTNO(String VDR_PART) { String Query = "SELECT * FROM Final_Table WHERE VDR_PART = @VDR_PART"; OleDbDataManager oDm = new OleDbDataManager(ConnectionString, Query, true); oDm.AddVarcharPara("VDR_PART", 4000, VDR_PART); return DataParser.ToList<FinalTable>(oDm.GetTable()); }
public List<Final_Table> GetData() { String Query = "SELECT * FROM Final_Table"; OleDbDataManager oDm = new OleDbDataManager(ConnectionString, Query, true); return DataParser.ToList<Final_Table>(oDm.GetTable()); }
public List<Adi_Brand> GetData() { String Query = "SELECT * FROM AdiBrand"; OleDbDataManager oDm = new OleDbDataManager(ConnectionString, Query, true); return DataParser.ToList<Adi_Brand>(oDm.GetTable()); }
public List<FinalTable> GetPriorityData(Boolean AID_Priority) { String Query = "SELECT * FROM Final_Table WHERE AID_Priority = \"" + AID_Priority + "\""; OleDbDataManager oDm = new OleDbDataManager(ConnectionString, Query, true); oDm.AddBoolPara("AID_Priority", AID_Priority); return DataParser.ToList<FinalTable>(oDm.GetTable()); }
public List<FinalTable> GetData() { String Query = "SELECT * FROM Final_Table WHERE AID_PART IS NOT NULL AND AID_PART <> ''"; OleDbDataManager oDm = new OleDbDataManager(ConnectionString, Query, true); return DataParser.ToList<FinalTable>(oDm.GetTable()); }
public List<InCategory> GetData(InCategory category) { String Query = "SELECT * FROM SecLockCategory WHERE Code = '" + category.Code+ "' ORDER BY Name"; OleDbDataManager oDm = new OleDbDataManager(this.ConnectionString, Query, true); return DataParser.ToList<InCategory>(oDm.GetTable()); }