Exemple #1
0
        public long CreateNew(InventoryDetailInfo InventoryDetail)
        {
            DataCommand command = new DataCommand(ConnectionString, GetDbCommand(InventoryDetailStatement.CreateNewInventoryDetail, "Text"));

            command.AddInputParameter("@InventoryID", DbType.Int32, InventoryDetail.InventoryID);
            command.AddInputParameter("@GoodsID", DbType.Int32, InventoryDetail.GoodsID);
            command.AddInputParameter("@StorageID", DbType.Int32, InventoryDetail.StorageID);
            command.AddInputParameter("@Quantity", DbType.Int32, InventoryDetail.Quantity);
            command.AddInputParameter("@CustomerID", DbType.Int32, InventoryDetail.CustomerID);
            command.AddInputParameter("@InventoryType", DbType.String, InventoryDetail.InventoryType);
            command.AddInputParameter("@BatchNumber", DbType.String, InventoryDetail.BatchNumber);
            command.AddInputParameter("@ProductDate", DbType.DateTime, InventoryDetail.ProductDate);
            command.AddInputParameter("@InventoryDate", DbType.DateTime, InventoryDetail.InventoryDate);
            command.AddInputParameter("@UnitPrice", DbType.Decimal, InventoryDetail.UnitPrice);
            command.AddInputParameter("@Remark", DbType.String, InventoryDetail.Remark);
            command.AddInputParameter("@OrderType", DbType.String, InventoryDetail.OrderType);
            command.AddInputParameter("@OrderNo", DbType.String, InventoryDetail.OrderNo);
            command.AddInputParameter("@OrderID", DbType.Int64, InventoryDetail.OrderID);
            command.AddInputParameter("@OperatorID", DbType.String, InventoryDetail.OperatorID);
            command.AddInputParameter("@CreateDate", DbType.DateTime, InventoryDetail.CreateDate);
            command.AddInputParameter("@ChangeDate", DbType.DateTime, InventoryDetail.ChangeDate);
            var o = command.ExecuteScalar <object>();

            return(Convert.ToInt64(o));
        }
Exemple #2
0
        private static InventoryDetailEntity TranslateInventoryDetailEntity(InventoryDetailInfo info)
        {
            InventoryDetailEntity entity = new InventoryDetailEntity();

            if (info != null)
            {
                entity.GoodsID       = info.GoodsID;
                entity.StorageID     = info.StorageID;
                entity.Quantity      = info.Quantity;
                entity.CustomerID    = info.CustomerID;
                entity.InventoryType = info.InventoryType;

                entity.BatchNumber   = info.BatchNumber;
                entity.ProductDate   = info.ProductDate;
                entity.InventoryDate = info.InventoryDate;
                entity.UnitPrice     = info.UnitPrice;
                entity.Remark        = info.Remark;

                entity.OrderNo           = info.OrderNo;
                entity.OrderType         = info.OrderType;
                entity.OrderTypeDesc     = StringHelper.getOrderType(info.OrderType);
                entity.OperatorID        = info.OperatorID;
                entity.CreateDate        = info.CreateDate;
                entity.ChangeDate        = info.ChangeDate;
                entity.InventoryDetailID = info.InventoryDetailID;
                entity.InventoryID       = info.InventoryID;
                entity.goods             = GoodsService.GetGoodsEntityById(info.GoodsID);
                entity.customer          = CustomerService.GetCustomerEntityById(info.CustomerID);
                entity.storages          = StorageService.GetStorageEntityById(info.StorageID);
            }

            return(entity);
        }
Exemple #3
0
        public static void CreateInventoryDetail(OrderEntity order, OrderDetailEntity orderDetail)
        {
            InventoryDetailRepository mrDetail   = new InventoryDetailRepository();
            InventoryDetailInfo       infoDetail = new InventoryDetailInfo();

            if (order != null)
            {
                infoDetail.InventoryID   = orderDetail.InventoryID;
                infoDetail.OrderID       = order.OrderID;
                infoDetail.OrderNo       = order.OrderNo;
                infoDetail.OrderType     = order.OrderType;
                infoDetail.GoodsID       = orderDetail.GoodsID;
                infoDetail.StorageID     = order.SendStorageID;
                infoDetail.Quantity      = orderDetail.Quantity;
                infoDetail.CustomerID    = order.CustomerID;
                infoDetail.InventoryType = Common.InventoryType.入库.ToString();
                infoDetail.BatchNumber   = orderDetail.BatchNumber;
                infoDetail.ProductDate   = orderDetail.ProductDate;
                infoDetail.InventoryDate = DateTime.Now;
                infoDetail.UnitPrice     = 0;
                infoDetail.Remark        = "订单删除-库存回位";
                infoDetail.OperatorID    = order.OperatorID;
                infoDetail.CreateDate    = DateTime.Now;
                infoDetail.ChangeDate    = DateTime.Now;
                mrDetail.CreateNew(infoDetail);
            }
        }
Exemple #4
0
        /// <summary>
        /// 库存明细入库
        /// </summary>
        /// <param name="entity">库存明细</param>
        /// <param name="StorageID"></param>
        /// <param name="inventoryDate"></param>
        /// <param name="OperatorID"></param>
        public static void CreateInventoryDetail(InventoryInfo entity, InventoryExecOrder orderExec, int StorageID, DateTime inventoryDate, long OperatorID)
        {
            InventoryDetailRepository mrDetail   = new InventoryDetailRepository();
            InventoryDetailInfo       infoDetail = new InventoryDetailInfo();

            if (entity != null)
            {
                infoDetail.InventoryID   = entity.InventoryID;
                infoDetail.OrderType     = OrderType.RKD.ToString();
                infoDetail.OrderNo       = orderExec.OrderNo;
                infoDetail.OrderID       = orderExec.OrderID;
                infoDetail.GoodsID       = entity.GoodsID;
                infoDetail.StorageID     = StorageID;
                infoDetail.Quantity      = entity.Quantity;
                infoDetail.CustomerID    = entity.CustomerID;
                infoDetail.InventoryType = entity.InventoryType;
                infoDetail.BatchNumber   = entity.BatchNumber;
                infoDetail.ProductDate   = entity.ProductDate;
                infoDetail.InventoryDate = inventoryDate;
                infoDetail.UnitPrice     = entity.UnitPrice;
                infoDetail.Remark        = entity.Remark;
                infoDetail.OperatorID    = OperatorID;
                infoDetail.CreateDate    = DateTime.Now;
                infoDetail.ChangeDate    = DateTime.Now;
                mrDetail.CreateNew(infoDetail);
            }
        }
Exemple #5
0
        public InventoryDetailInfo GetInventoryDetailByKey(long gid)
        {
            InventoryDetailInfo result  = new InventoryDetailInfo();
            DataCommand         command = new DataCommand(ConnectionString, GetDbCommand(InventoryDetailStatement.GetInventoryDetailByKey, "Text"));

            command.AddInputParameter("@InventoryDetailID", DbType.String, gid);
            result = command.ExecuteEntity <InventoryDetailInfo>();
            return(result);
        }
Exemple #6
0
        /// <summary>
        /// 库存明细更新
        /// </summary>
        /// <param name="detail"></param>
        /// <param name="orderEntity"></param>
        /// <param name="inventory"></param>
        private static void createInventoryDetail(OrderDetailEntity detail, OrderEntity orderEntity, int storageID, int Quantity)
        {
            InventoryDetailRepository mrDetail   = new InventoryDetailRepository();
            InventoryDetailInfo       infoDetail = new InventoryDetailInfo();

            infoDetail.InventoryID   = detail.InventoryID;
            infoDetail.OrderID       = orderEntity.OrderID;
            infoDetail.OrderNo       = orderEntity.OrderNo;
            infoDetail.OrderType     = orderEntity.OrderType;//订单类型
            infoDetail.GoodsID       = detail.GoodsID;
            infoDetail.StorageID     = storageID;
            infoDetail.Quantity      = Quantity;
            infoDetail.CustomerID    = orderEntity.CustomerID;
            infoDetail.InventoryType = InventoryType.出库.ToString();//出库/入库
            infoDetail.BatchNumber   = detail.BatchNumber;
            infoDetail.ProductDate   = detail.ProductDate;
            infoDetail.InventoryDate = DateTime.Now;
            infoDetail.UnitPrice     = 0;
            infoDetail.Remark        = orderEntity.OrderType;
            infoDetail.OperatorID    = orderEntity.OperatorID;
            infoDetail.CreateDate    = DateTime.Now;
            infoDetail.ChangeDate    = DateTime.Now;
            mrDetail.CreateNew(infoDetail);
        }
Exemple #7
0
        /// <summary>
        /// 库存明细更新
        /// </summary>
        /// <param name="detail"></param>
        /// <param name="orderEntity"></param>
        /// <param name="inventory"></param>
        private static void createInventoryDetail(InventoryEntity entity, GoodsEntity orderEntity, long UserID)
        {
            InventoryDetailRepository mrDetail   = new InventoryDetailRepository();
            InventoryDetailInfo       infoDetail = new InventoryDetailInfo();

            infoDetail.InventoryID   = entity.InventoryID;
            infoDetail.OrderID       = 0;
            infoDetail.OrderNo       = "";
            infoDetail.OrderType     = "";//订单类型
            infoDetail.GoodsID       = entity.GoodsID;
            infoDetail.StorageID     = entity.StorageID;
            infoDetail.Quantity      = entity.Quantity;
            infoDetail.CustomerID    = orderEntity.CustomerID;
            infoDetail.InventoryType = InventoryType.出库.ToString();//出库/入库
            infoDetail.BatchNumber   = entity.BatchNumber;
            infoDetail.ProductDate   = entity.ProductDate;
            infoDetail.InventoryDate = DateTime.Now;
            infoDetail.UnitPrice     = 0;
            infoDetail.Remark        = "PDA出库操作";
            infoDetail.OperatorID    = UserID;
            infoDetail.CreateDate    = DateTime.Now;
            infoDetail.ChangeDate    = DateTime.Now;
            mrDetail.CreateNew(infoDetail);
        }