private static int GetIdByVendorOrder(int scenarioID, clsScVorderDetail ele) { string sql = "SELECT [ScSalesHistoryID] " + "FROM " + clsGlobals.Gesin + "[tblGIScSalesHistory] " + "WHERE[ScenarioID] = " + scenarioID + " " + "AND[ProductColorID] = " + ele.ProductColorID + " " + "AND[ProductCatID] = " + ele.ProductCatID + " " + "AND[SizeDesc] = '" + ele.Size + "'"; //Conexion.StartSession(); int tmpID = (int)Conexion.GDatos.GetScalarValueSql(sql); Conexion.EndSession(); return(tmpID); }
public clsProductAvailableOS(clsScVorderDetail ele, double orderQty) { this.CatID = ele.CatID; this.ColorID = ele.ColorID; this.DimID = ele.DimID; this.ProductCatID = ele.ProductCatID; this.ProductColorID = ele.ProductColorID; this.ProductDimID = ele.ProductDimID; this.ProductGroupID = ele.ProductGroupID; this.ProductID = ele.ProductID; this.ProductSubGroupID = ele.ProductSubGroupID; this.ScenarioID = clsGlobals.GIPar.ScenarioID; this.SizeOrder = ele.SizeOrder; this.SizeDesc = ele.Size; this.QtyOrdered = orderQty; }
internal static int UpdateVOStatus(clsScVorderDetail tmp) { string sql = "UPDATE " + clsGlobals.Gesin + "[tblGIScProduct] " + "SET [VOStatus] = 1 " + "WHERE [ScenarioID]=" + clsGlobals.GIPar.ScenarioID + " " + "AND [ProductID]=" + tmp.ProductID + " " + "AND [ProductColorID]=" + tmp.ProductColorID + " " + "AND [ColorID]=" + tmp.ColorID; //Conexion.StartSession(); Conexion.GDatos.RunSql(sql); sql = "SELECT [ScProductID] " + "FROM " + clsGlobals.Gesin + "[tblGIScProduct]" + "WHERE [ScenarioID]=" + clsGlobals.GIPar.ScenarioID + " " + "AND [ProductID]=" + tmp.ProductID + " " + "AND [ProductColorID]=" + tmp.ProductColorID + " " + "AND [ColorID]=" + tmp.ColorID; int pdtID = (int)Conexion.GDatos.GetScalarValueSql(sql); Conexion.EndSession(); return(pdtID); }