public void insertProduct(Inventory it)
{
string strSQL = "p_Product";
DBAccess data = new DBAccess();
data.Store_RnSQL(strSQL, it);
}
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 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 GetHierarchy(int iHierarchy)
{
string strSQL = "p_GetHierarchy";
DBAccess data = new DBAccess();
return data.Store_GetHierarchy(strSQL, iHierarchy);
}
public void DeleteProduct(string strinput)
{
string strSQL = "delete product where invtid='" + strinput + "'";
DBAccess data = new DBAccess();
data.RunSQL(strSQL);
}