public BizEntity.PO.BasketItemsInfo UpdateBasketItemForGift(BizEntity.PO.BasketItemsInfo basketItemInfo)
{
DataCommand command = DataCommandManager.GetDataCommand("UpdateBasketForGift");
command.SetParameterValue("@SysNo", basketItemInfo.ItemSysNo);
command.SetParameterValue("@Quantity", basketItemInfo.Quantity);
command.ExecuteNonQuery();
return(basketItemInfo);
}
public BizEntity.PO.BasketItemsInfo DeleteBasketItem(BizEntity.PO.BasketItemsInfo basketItemInfo)
{
DataCommand command = DataCommandManager.GetDataCommand("DeleteBasket");
command.SetParameterValue("@SysNo", basketItemInfo.ItemSysNo);
command.ExecuteNonQuery();
return(basketItemInfo);
}
public bool CheckProductHasExistInBasket(BizEntity.PO.BasketItemsInfo basketItemInfo)
{
DataCommand command = DataCommandManager.GetDataCommand("GetProductFormBasketCount");
command.SetParameterValue("@ProductSysoNo", basketItemInfo.ProductSysNo);
command.SetParameterValueAsCurrentUserSysNo("@UserSysNo");
command.SetParameterValue("@StockSysNo", basketItemInfo.StockSysNo);
command.SetParameterValue("@LastVendorSysNo", basketItemInfo.LastVendorSysNo);
object result = command.ExecuteScalar();
return(Convert.ToInt32(result) > 0);
}
public BizEntity.PO.BasketItemsInfo UpdateBasketItem(BizEntity.PO.BasketItemsInfo basketItemInfo)
{
DataCommand command = DataCommandManager.GetDataCommand("UpdateBasket");
command.SetParameterValue("@SysNo", basketItemInfo.ItemSysNo);
command.SetParameterValue("@OrderPrice", basketItemInfo.OrderPrice);
command.SetParameterValue("@Quantity", basketItemInfo.Quantity);
command.SetParameterValue("@LastVendorSysNo", basketItemInfo.VendorSysNo);
command.SetParameterValue("@StockSysNo", basketItemInfo.StockSysNo);
command.SetParameterValue("@IsTransfer", basketItemInfo.IsTransfer);
command.ExecuteNonQuery();
return(basketItemInfo);
}
public BizEntity.PO.BasketItemsInfo CreateBasketItem(BizEntity.PO.BasketItemsInfo basketItemInfo)
{
DataCommand command = DataCommandManager.GetDataCommand("CreateBasket");
command.SetParameterValue("@CreateTime", DateTime.Now);
command.SetParameterValueAsCurrentUserSysNo("@CreateUserSysNo");
command.SetParameterValue("@OrderPrice", basketItemInfo.OrderPrice);
command.SetParameterValue("@ProductSysNo", basketItemInfo.ProductSysNo);
command.SetParameterValue("@Quantity", basketItemInfo.Quantity);
command.SetParameterValue("@ReadyQuantity", basketItemInfo.ReadyQuantity);
command.SetParameterValue("@CompanyCode", basketItemInfo.CompanyCode);
basketItemInfo.ItemSysNo = System.Convert.ToInt32(command.ExecuteScalar());
return(basketItemInfo);
}
public BizEntity.PO.BasketItemsInfo CreateBasketItemForPrepare(BizEntity.PO.BasketItemsInfo prepareInfo)
{
DataCommand command = DataCommandManager.GetDataCommand("CreateBasketForPrepare");
command.SetParameterValue("@CreateTime", DateTime.Now);
command.SetParameterValueAsCurrentUserSysNo("@CreateUserSysNo");
command.SetParameterValue("@OrderPrice", prepareInfo.OrderPrice);
command.SetParameterValue("@ProductSysNo", prepareInfo.ProductSysNo);
command.SetParameterValue("@Quantity", prepareInfo.Quantity);
command.SetParameterValue("@StockSysNo", prepareInfo.StockSysNo);
command.SetParameterValue("@IsTransfer", prepareInfo.IsTransfer);
command.SetParameterValue("@LastVendorSysNo", prepareInfo.LastVendorSysNo);
command.SetParameterValue("@ReadyQuantity", prepareInfo.ReadyQuantity);
command.SetParameterValue("@CompanyCode", prepareInfo.CompanyCode);
prepareInfo.ItemSysNo = System.Convert.ToInt32(command.ExecuteScalar());
return(prepareInfo);
}
