private bool GetEquivalentItem(clsScSalesHistory proBase, int productEquiID)
{
string sql = "SELECT [ScSalesHistoryID],[ScenarioID],[SeasonID],[CollectionID],SH.[ProductID],SH.[ProductColorID],[ProductDimID]," +
"[ProductCatID],[SizeOrder],SH.[ColorID],[DimID],[CatID],[ProductGroupID],[ProductSubGroupID],[CollectionName],[CollectionCode]," +
"[ProductCode],[ShortProductCode],[ProductDesc_eng],[GroupName],[SubGroupName],[ColorCode],[ColorName_eng],[DimCode],[SizeDesc]," +
"[CatCode],[ProductStatusDesc],[ProductColorStatusDesc],[BarcodeSKU],[QtyVI1],[QtyCI1a],[QtyCI1b],[QtyCI1ToInvoice],[QtyVOOpen1]," +
"[QtyCO1],[QtyVI2],[QtyCI2a],[QtyCI2b],[QtyCI2ToInvoice],[QtyVOOpen2],[QtyCO2],[QtyStock],[QtyStock2],[QtyPick],[QtyPack]," +
"[DefEstPrice],[DefFOBPrice],[SalesPrice],[RetailPrice],[AmountCI1],[AmountCI2],[QtyInvBF],[QtyInvAF],[QtyAchat],[VOStatus] " +
"FROM [sxUnimageDevGI].[dbo].[tblGIScSalesHistory] AS SH " +
"INNER JOIN [sxUnimageDevGI].[dbo].[tblGIProduct] AS GIP " +
"ON GIP.ProductColorID=SH.ProductColorID " +
"WHERE[GIProductID]= " + productEquiID + " " +
"AND [CatCode]= '" + proBase.CatCode + "' " +
"AND [ScenarioID]= " + clsGlobals.GIPar.ScenarioID + " " +
"AND [DimID]= " + proBase.DimID + " " +
"AND [SizeDesc]= '" + proBase.SizeDesc + "'";
//Conexion.StartSession();
DataTable myTb = Conexion.GDatos.GetDataTableSql(sql);
Conexion.EndSession();
if (myTb.Rows.Count > 0)
{
this.CopyDataRow(myTb.Rows[0]);
return(true);
}
else
{
return(false);
}
}
internal void CalculateStatisticsBooking(clsScSalesHistory ele, int v)
{
clsGIParameter myPa = new clsGIParameter();
//General parameters
myPa = clsGlobals.GIPar;
//Product Information
ProductID = ele.ProductID;
ProductColorID = ele.ProductColorID;
ProductDimID = ele.ProductDimID;
ProductCatID = ele.ProductCatID;
SizeOrder = ele.SizeOrder;
ColorID = ele.ColorID;
DimID = ele.DimID;
CatID = ele.CatID;
ProductGroupID = ele.ProductGroupID;
ProductSubGroupID = ele.ProductSubGroupID;
this.Dim = ele.DimCode;
this.Size = ele.SizeDesc;
this.RP1 = ele.QtyVI1;
this.VP1 = ele.QtyCI1a + ele.QtyCI1ToInvoice;
this.RP2 = ele.QtyVI2;
this.VP2 = ele.QtyCI2a + ele.QtyCI2ToInvoice;
this.ACH = ele.QtyVOOpen1 + ele.QtyVOOpen2;
this.CMD = ele.QtyCO1 + ele.QtyCO2;
this.VTOT = ele.QtyCI2a + ele.QtyCI2ToInvoice + ele.QtyCO2;
this.CSS = ele.QtyCO2 - ele.QtyPack;
this.Var = this.VTOT - this.VP1;
this.VTEM = (this.VTOT + this.VP1) / 2;
if (v == 1)
{
this.IBF = ele.GetInvBF();
this.IAF = ele.GetInvAF();
}
if (v == 2)
{
this.IBF = ele.GetInvBF();
this.IAF = 0;
}
if (v == 3)
{
this.IBF = 0;
this.IAF = ele.GetInvAF();
}
if (v == 4)
{
this.IBF = 0;
this.IAF = 0;
}
this.IC = ele.QtyStock;
//Calcul des besoins.
Besoin = Math.Floor(((ele.QtyCO1 + ele.QtyCI2a + ele.QtyCI2ToInvoice + ele.QtyCO2) * (1 + clsGlobals.ActiveRatio / 100))
- ele.QtyVOOpen1 - ele.QtyCI2a - ele.QtyCI2ToInvoice - ele.QtyVOOpen2 - ele.QtyStock);
this.QVO = ele.QtyAchat;
//compras + IC - cmd
this.Available = this.ACH + this.IC - this.CMD;
}
internal void UpdateOneItems(int productEquiID)
{
clsScSalesHistory myItemEqui = new clsScSalesHistory();
if (myItemEqui.GetEquivalentItem(this, productEquiID))
{
this.QtyVI1 = myItemEqui.QtyVI1;
this.QtyCI1a = myItemEqui.QtyCI1a;
this.QtyCI1b = myItemEqui.QtyCI1b;
this.QtyCI1ToInvoice = myItemEqui.QtyCI1ToInvoice;
this.QtyVOOpen1 = myItemEqui.QtyVOOpen1;
this.QtyCO1 = myItemEqui.QtyCO1;
this.UpdateQuantities();
}
}
public clsProductAvailableOS(clsScSalesHistory ele, double available)
{
this.CatID = ele.CatID;
this.CollectionID = ele.CollectionID;
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.SizeDesc;
this.QtyAvailable = available;
}