コード例 #1
0
        /// <summary>
        /// 收货取消
        /// </summary>
        /// <param name="warehouseId"></param>
        /// <param name="productId"></param>
        /// <param name="merchantId"></param>
        /// <param name="qtyReceipt"></param>
        /// <param name="isOpenTrans"></param>
        /// <returns></returns>
        public bool UpdateInventoryByUnReceive(string sourceNo, InventoryTransactionType type, string warehouseId, string productId, string merchantId, int qtyReceipt,
                                               DbTransaction isOpenTrans)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append(
                @"UPDATE [Inventory] SET QtyOnHand = QtyOnHand - @QtyReceipt, QtyAllocated = QtyAllocated - @QtyReceipt");
            strSql.Append(" WHERE ProductId = @ProductId");
            strSql.Append(" AND WarehouseId = @WarehouseId");
            strSql.Append(" AND MerchantId = @MerchantId ");
            strSql.Append(" AND QtyOnHand - @QtyReceipt >= 0");

            var updateParameters = new List <DbParameter>
            {
                DbFactory.CreateDbParameter("@WarehouseId", warehouseId),
                DbFactory.CreateDbParameter("@ProductId", productId),
                DbFactory.CreateDbParameter("@MerchantId", merchantId),
                DbFactory.CreateDbParameter("@QtyReceipt", qtyReceipt)
            };

            InventoryTransactionEntity transaction = new InventoryTransactionEntity();

            transaction.Create();
            transaction.Type         = (int)type;
            transaction.WarehouseId  = warehouseId;
            transaction.ProductId    = productId;
            transaction.MerchantFrom = merchantId;
            transaction.MerchantTo   = merchantId;
            transaction.Qty          = -1 * qtyReceipt;
            transaction.SourceNo     = sourceNo;

            var isOK = new InventoryTransactionBLL().InsertTransaction(transaction, isOpenTrans);

            if (isOK)
            {
                return(Repository().ExecuteBySql(strSql, updateParameters.ToArray(), isOpenTrans) > 0);
            }
            else
            {
                return(false);
            }
        }
コード例 #2
0
        /// <summary>
        /// 更新商户在库库存(收货、拣货移入)
        /// </summary>
        /// <param name="sourceNo"></param>
        /// <param name="warehouseId"></param>
        /// <param name="productId"></param>
        /// <param name="merchantId"></param>
        /// <param name="moveInQty"></param>
        /// <param name="isOpenTrans"></param>
        public bool UpdateInventoryByReceive(string sourceNo, InventoryTransactionType type, string warehouseId, string productId, string merchantId, int moveInQty,
                                             DbTransaction isOpenTrans)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append(@"SELECT * FROM dbo.Inventory WHERE WarehouseId = @WarehouseId");
            strSql.Append(" AND ProductId = @ProductId");
            strSql.Append(" AND MerchantId = @MerchantId");

            var parameter = new List <DbParameter>
            {
                DbFactory.CreateDbParameter("@WarehouseId", warehouseId),
                DbFactory.CreateDbParameter("@ProductId", productId),
                DbFactory.CreateDbParameter("@MerchantId", merchantId)
            };

            InventoryTransactionEntity transaction = new InventoryTransactionEntity();

            transaction.Create();
            transaction.Type         = (int)type;
            transaction.WarehouseId  = warehouseId;
            transaction.ProductId    = productId;
            transaction.MerchantFrom = merchantId;
            transaction.MerchantTo   = merchantId;
            transaction.Qty          = moveInQty;
            transaction.SourceNo     = sourceNo;

            var isOK = new InventoryTransactionBLL().InsertTransaction(transaction, isOpenTrans);

            if (isOK)
            {
                var inventory = Repository().FindEntityBySql(strSql.ToString(), parameter.ToArray());
                if (string.IsNullOrEmpty(inventory?.InventoryId))
                {
                    inventory = new InventoryEntity();
                    inventory.Create();
                    inventory.WarehouseId = warehouseId;
                    inventory.ProductId   = productId;
                    inventory.QtyOnHand   = moveInQty;
                    inventory.MerchantId  = merchantId;
                    return(Repository().Insert(inventory, isOpenTrans) > 0);
                }
                else
                {
                    StringBuilder strUpdateSql = new StringBuilder();
                    strUpdateSql.Append(
                        @"UPDATE [Inventory] SET QtyOnHand = QtyOnHand + @QtyOnHand WHERE InventoryId = @InventoryId ");

                    List <DbParameter> updateParameters = new List <DbParameter>
                    {
                        DbFactory.CreateDbParameter("@QtyOnHand", moveInQty),
                        DbFactory.CreateDbParameter("@InventoryId", inventory.InventoryId)
                    };
                    return(Repository().ExecuteBySql(strUpdateSql, updateParameters.ToArray(), isOpenTrans) > 0);
                }
            }
            else
            {
                return(false);
            }
        }