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