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)); }
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); }
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); } }
/// <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); } }
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); }
/// <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); }
/// <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); }