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