/// <summary>
/// 获取指定的单条数据
/// </summary>
/// <param name="id">主键</param>
/// <returns></returns>
public StockInModel GetTheData(string id)
{
StockInModel model = new StockInModel(GetEntity(id));
model.StockInItems = this._StockInItemBusiness.GetDataList(model.InNo);
return(model);
}
/// <summary>
/// 添加数据
/// </summary>
/// <param name="newData">数据</param>
public void AddData(StockInModel newData)
{
Sto_StockBusiness _stockBus = new Sto_StockBusiness();
if (newData.Id.IsNullOrEmpty())
{
newData.Id = Guid.NewGuid().ToSequentialGuid();
//生成入库单编号
this.BeginTransaction();
this._StockInItemBusiness.BeginTransaction();
_stockBus.BeginTransaction();
foreach (Sto_StockInItem item in newData.StockInItems)
{
item.Id = Guid.NewGuid().ToSequentialGuid();
item.InNo = newData.InNo;
//检查是否存在期初库存，如没有期初库存记录，默认添加期初为0的期初库存
var count = _stockBus.GetIQueryable().Where(p => p.MatNo == item.MatNo).Count();
if (count == 0)
{
Sto_Stock stock = new Sto_Stock()
{
Id = Guid.NewGuid().ToSequentialGuid(),
MatNo = item.MatNo,
GuiGe = item.GuiGe,
MatName = item.MatName,
Quantity = 0,
StoreId = newData.StoreId,
UnitNo = item.UnitNo,
StoreUnitId = "",
Price = item.Price,
UpToTime = DateTime.Now.AddDays(-1),
BigClass = item.BigClass
};
_stockBus.Insert(stock);
}
}
this._StockInItemBusiness.BulkInsert(newData.StockInItems);
Sto_StockIn stockIn = new Sto_StockIn()
{
Id = newData.Id,
InNo = newData.InNo,
InDate = newData.InDate,
InOperID = newData.InOperID,
State = newData.State,
StoreId = newData.StoreId,
AuditDate = newData.AuditDate,
Auditor = newData.Auditor,
Context = newData.Context,
InType = newData.InType
};
Insert(stockIn);
if (this._StockInItemBusiness.EndTransaction())
{
if (!this.EndTransaction())
{
foreach (Sto_StockInItem item in newData.StockInItems)
{
this._StockInItemBusiness.Delete(item);
}
throw new Exception("保存数据失败");
}
_stockBus.EndTransaction();
}
}
else
{
UpdateData(newData);
}
}
/// <summary>
/// 更新数据
/// </summary>
public void UpdateData(StockInModel theData)
{
Sto_StockBusiness _stockBus = new Sto_StockBusiness();
var oldStockInItems = this._StockInItemBusiness.GetIQueryable().Where(p => p.InNo == theData.InNo).ToList();
var itemIds = (from p in oldStockInItems select p.Id).ToList <string>();
List <string> thisItemIds = new List <string>();
var stockIn = this.GetEntity(theData.Id);
var copyIn = stockIn.DeepClone();
if (stockIn == null)
{
throw new Exception("要修改的入库单不存在，可能已被删除");
}
if (stockIn.State != 0)
{
throw new Exception("非录入状态不能修改");
}
this.BeginTransaction();
this._StockInItemBusiness.BeginTransaction();
_stockBus.BeginTransaction();
foreach (Sto_StockInItem item in theData.StockInItems)
{
if (item.Id.IsNullOrEmpty())
{
item.Id = Guid.NewGuid().ToSequentialGuid();
item.InNo = theData.InNo;
this._StockInItemBusiness.Insert(item);
//检查是否存在期初库存，如没有期初库存记录，默认添加期初为0的期初库存
var count = _stockBus.GetIQueryable().Where(p => p.MatNo == item.MatNo).Count();
if (count == 0)
{
Sto_Stock stock = new Sto_Stock()
{
Id = Guid.NewGuid().ToSequentialGuid(),
MatNo = item.MatNo,
GuiGe = item.GuiGe,
MatName = item.MatName,
Quantity = 0,
StoreId = theData.StoreId,
UnitNo = item.UnitNo,
StoreUnitId = "",
Price = item.Price,
UpToTime = DateTime.Now.AddDays(-1),
BigClass = item.BigClass
};
_stockBus.Insert(stock);
}
}
else
{
thisItemIds.Add(item.Id);
item.InNo = theData.InNo;
this._StockInItemBusiness.Update(item);
}
}
var exceptList = itemIds.Except(thisItemIds).ToList();
this._StockInItemBusiness.Delete(exceptList);
stockIn.InNo = theData.InNo;
stockIn.InDate = theData.InDate;
stockIn.InOperID = theData.InOperID;
stockIn.State = theData.State;
stockIn.StoreId = theData.StoreId;
stockIn.AuditDate = theData.AuditDate;
stockIn.Auditor = theData.Auditor;
stockIn.Context = theData.Context;
Update(stockIn);
if (this.EndTransaction())
{
if (!this._StockInItemBusiness.EndTransaction())
{
stockIn.InNo = copyIn.InNo;
stockIn.InDate = copyIn.InDate;
stockIn.InOperID = copyIn.InOperID;
stockIn.State = copyIn.State;
stockIn.StoreId = copyIn.StoreId;
stockIn.AuditDate = copyIn.AuditDate;
stockIn.Auditor = copyIn.Auditor;
stockIn.Context = copyIn.Context;
this.Update(stockIn);
throw new Exception("修改入库单失败。");
}
_stockBus.EndTransaction();
}
}