public DataTable Getdata()
{
string strSQL = "select InvtID,Descr,ShortDescr,ClassID,Status,DfltSite,DfltWhseLoc,StkUnit,UOM1,CnvFact1,UOM2,CnvFact2,Style,User1,StkBasePrc,PriceClassID,ListPrice,SalesTeam,Division,CAT,Brand,Brandy,Variant from Product";
DBAccess data = new DBAccess();
return data.RunSQL(strSQL);
}
public DataTable GetListSaleTeam()
{
DBAccess data = new DBAccess();
string select = "select lineid,description from xswhierarchy where htype='I' and HID='002' and levelid=1";
return data.RunSQL(select);
}
public void DeleteProduct(string strinput)
{
string strSQL = "delete product where invtid='" + strinput + "'";
DBAccess data = new DBAccess();
data.RunSQL(strSQL);
}
