internal void UpdateScProduct()
{
string sql = "UPDATE " + clsGlobals.Gesin + "[tblGIScProduct] SET " +
"[GIProductID] = " + GIProductID +
",[ScProductStatus]= " + ScProductStatus +
",[ScProductComment]= '" + ScProductComment +
"',[ProductID]= " + ProductID +
",[ColorID]= " + ColorID +
",[GIProductStatus]= " + GIProductStatus +
",[ProductComment]= '" + ProductComment +
"',[SurplusRate]= " + SurplusRate +
",[ReferenceNo1]= '" + ReferenceNo1 +
"',[ReferenceNo2]= '" + ReferenceNo2 +
"',[ExpShippingDate]= '" + ExpShippingDate.ToString("yyyy-MM-dd") +
"',[ExpArrivalDate]= '" + ExpArrivalDate.ToString("yyyy-MM-dd") +
"',[VendorID]= " + VendorID +
",[VendorSiteID]= " + VendorSiteID +
",[PurchaseTypeID]= " + PurchaseTypeID +
",[DefaultWarehouseID]= " + DefaultWarehouseID +
",[DivisionID]= " + DivisionID +
",[CollectionID]= " + CollectionID +
",[VOSeasonID]= " + VOSeasonID +
",[VONote]= '" + VONote +
"',[VOMessage]= '" + VOMessage +
"',[VOStatus]= " + VOStatus +
",[VOID]= " + VOID +
",[VOCode]= '" + VOCode +
"',[VoPdfStatus]= " + VoPdfStatus +
",[ModifiedByUserID]= " + clsGlobals.GIPar.UserID +
",[ModifiedDate]= GETDATE() WHERE[ScenarioID]= " + ScenarioID + " AND[ProductColorID]= " + ProductColorID;
//Conexion.StartSession();
Conexion.GDatos.RunSql(sql);
Conexion.EndSession();
}
internal void UpdateVOParameter()
{
string sql = "UPDATE " + clsGlobals.Gesin + "[tblGIParameter] SET " +
"[ReferenceNo1] ='" + ReferenceNo1 +
"',[ReferenceNo2] = '" + ReferenceNo2 +
"',[ExpShippingDate] = '" + ExpShippingDate.ToString("yyyy-MM-dd") +
"',[ExpArrivalDate] = '" + ExpArrivalDate.ToString("yyyy-MM-dd") +
"',[VendorID] = " + VendorID +
",[VendorSiteID] = " + VendorSiteID +
",[PurchaseTypeID] = " + PurchaseTypeID +
",[DefaultWarehouseID] = " + DefaultWarehouseID +
",[DivisionID] = " + DivisionID +
",[CollectionID] = " + CollectionID +
",[SeasonID] = " + SeasonID +
",[VONote] = '" + VONote +
"',[VOMessage] = '" + VOMessage +
"',[ModifiedByUserID] = " + clsGlobals.GIPar.UserID +
",[ModifiedDate] = GETDATE()" +
"WHERE[GIParameterID]=100";
//Conexion.StartSession();
Conexion.GDatos.RunSql(sql);
Conexion.EndSession();
}
internal void UpdateScenario()
{
string sql = "UPDATE " + clsGlobals.Gesin + "[tblGIScenario] SET [ScenarioDesc] = '" + ScenarioDesc + "', [ScenarioStatus] = " + ScenarioStatus +
", [ReferenceNo1] = '" + ReferenceNo1 + "', [ReferenceNo2] = '" + ReferenceNo2 + "', [ExpShippingDate] = '" +
ExpShippingDate.ToString("yyyy-MM-dd") + "', [ExpArrivalDate] = '" + ExpArrivalDate.ToString("yyyy-MM-dd") + "', [VendorID] = " +
VendorID + ", [VendorSiteID] = " + VendorSiteID + ", [PurchaseTypeID] = " + PurchaseTypeID + ", [DivisionID] = " + DivisionID +
", [CollectionID] = " + CollectionID + ", [VOSeasonID] = " + VOSeasonID + ", [VONote] = '" + VONote + "', [VOMessage] = '" + VOMessage +
"', [ModifiedByUserID] = " + clsGlobals.GIPar.UserID + ", [ModifiedDate] = GETDATE() WHERE [GIScenarioID]=" + clsGlobals.GIPar.ScenarioID;
//Conexion.StartSession();
Conexion.GDatos.RunSql(sql);
Conexion.EndSession();
}