public ActionResult Remove(string[] CheckGuids)
{
var result = _checkerContract.Remove(CheckGuids);
if (result.ResultType == OperationResultType.Success)
{
var CheckerItems = _checkerContract.Checkers.Where(x => CheckGuids.Contains(x.CheckGuid)).SelectMany(s => s.CheckerItems).Select(s => new
{
s.ProductBarcode,
s.Product.ProductNumber,
}).ToList();
List <ProductTrack> listpt = new List <ProductTrack>();
foreach (var checkitem in CheckerItems)
{
#region 商品追踪
ProductTrack pt = new ProductTrack();
if (!string.IsNullOrEmpty(checkitem.ProductBarcode))
{
pt.ProductNumber = checkitem.ProductNumber;
pt.ProductBarcode = checkitem.ProductBarcode;
pt.Describe = ProductOptDescTemplate.ON_PRODUCT_CHECKER_DELETE;
listpt.Add(pt);
#endregion
}
}
_productTrackContract.BulkInsert(listpt);
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
//da= [{ProduId:22,StorCou:120,StoreId:12,StorageId:2},{ProduId:22,StorCou:120,StoreId:12,StorageId:2}]
//yxk
public JsonResult AddInventory(string[] prCodes, int storageId, string notes, string recordOrderNumber, DateTime?CreatedTime)
{
if (!CreatedTime.HasValue)
{
CreatedTime = DateTime.Now;
}
OperationResult optresul = new OperationResult(OperationResultType.Error, "入库失败");
List <Inventory> inves = new List <Inventory>();
if (prCodes == null)
{
prCodes = new string[0];
}
string key = "ScanValid";
var productsModeList = Session[key] as List <Product_Model>;
int err = 0;
if (productsModeList == null || productsModeList.Count == 0)
{
optresul.Message = "在服务器中未查到相关的入库操作，可能是操作超时";
}
else
{
var instorageCode = prCodes.Any() ? productsModeList.Where(c => prCodes.Contains(c.ProductBarcode)).Select(c => c.ProductBarcode).ToList()
: productsModeList.Select(c => c.ProductBarcode).Distinct().ToList();
//检查是否有已经入库的条码
if (_inventoryContract.Inventorys.Any(i => instorageCode.Contains(i.ProductBarcode)))
{
return(Json(OperationResult.Error("检测到有已经入过库的流水号")));
}
int adminid = (int)AuthorityHelper.OperatorId;
var storage = CacheAccess.GetManagedStorage(_storageContract, _administratorContract).FirstOrDefault(f => f.Id == storageId);
if (storage.IsNull())
{
optresul.Message = "当前用户无权限操作该仓库，ID:" + storageId;
}
else
{
var barcodesFromDb = _productBarcodeDetailContract.productBarcodeDetails
.Where(c => instorageCode.Contains(c.ProductNumber + c.OnlyFlag))
.ToList();
var distinceBarcodes = new List <ProductBarcodeDetail>();
foreach (var code in barcodesFromDb)
{
if (distinceBarcodes.Any(i => i.ProductNumber == code.ProductNumber && i.OnlyFlag == code.OnlyFlag))
{
continue;
}
else
{
distinceBarcodes.Add(code);
}
}
var productNumbersFromBarcode = distinceBarcodes.Select(c => c.ProductNumber).ToList();
var products = _productContract.Products.Where(c => productNumbersFromBarcode.Contains(c.ProductNumber))
.Select(c => new
{
c.ProductNumber,
c.Id,
c.ProductOriginNumber.TagPrice,
c.ProductOriginNumber.WholesalePrice,
c.ProductOriginNumber.PurchasePrice
})
.ToList();
var productNumbersFromProduct = products.Select(c => c.ProductNumber).ToList();
var errproduct = distinceBarcodes.Where(c => !productNumbersFromProduct.Contains(c.ProductNumber));
List <string> errbarcode = new List <string>();
if (errproduct.Any())
{
//与该商品相关的商品档案不存在
//写日志 待完善
errbarcode = errproduct.Select(c => c.ProductNumber + c.OnlyFlag).ToList();
//inves = new List<Inventory>(); //清空需要入库的数据
var errst = "";
if (errbarcode.Count > 4)
{
errst = string.Join(",", errbarcode.Take(4).ToArray());
}
else
{
errst = string.Join(",", errbarcode);
}
_logContract.Insert(new LogDto()
{
Description = string.Join(",", errbarcode) + "未查找到商品档案",
});
optresul.Message = "部分商品未查找到商品档案：" + errst + "……,详情请查看日志";
}
else
{
inves = distinceBarcodes.Select(c => new Inventory()
{
ProductNumber = c.ProductNumber,
OnlyFlag = c.OnlyFlag,
ProductLogFlag = Guid.NewGuid().ToString().Replace("-", ""),
ProductBarcode = c.ProductNumber + c.OnlyFlag,
StoreId = storage.StoreId,
StorageId = storageId,
ProductId = products.FirstOrDefault(g => g.ProductNumber == c.ProductNumber).Id,
Description = notes,
}).ToList();
}
if (inves.Any())
{
// 计算本次入库总吊牌价
float totalTagPrice = 0;
foreach (var inventory in inves)
{
totalTagPrice += products.First(p => p.Id == inventory.ProductId).TagPrice;
}
// 根据生成的库存信息,插入入库记录
var record = new InventoryRecord()
{
Quantity = inves.Count,
OperatorId = adminid,
StorageId = storageId,
StoreId = storage.StoreId,
TagPrice = totalTagPrice,
RecordOrderNumber = recordOrderNumber,
CreatedTime = CreatedTime.Value
};
using (var tran = _inventoryContract.GetTransaction())
{
var res = _inventoryRecordContract.Insert(record);
if (res.ResultType != OperationResultType.Success)
{
tran.Rollback();
return(Json(OperationResult.Error("库存记录插入失败")));
}
// 将库存信息与入库记录进行关联
inves.Each(i => i.InventoryRecordId = record.Id);
// 保存库存信息
optresul = _inventoryContract.BulkInsert(inves);
if (optresul.ResultType != OperationResultType.Success)
{
tran.Rollback();
return(Json(OperationResult.Error("保存库存信息失败")));
}
List <ProductTrack> listpt = new List <ProductTrack>();
foreach (var item in inves)
{
#region 商品追踪
ProductTrack pt = new ProductTrack();
pt.ProductNumber = item.ProductNumber;
pt.ProductBarcode = item.ProductNumber + item.OnlyFlag;
pt.Describe = String.Format(ProductOptDescTemplate.ON_PRODUCT_INVENTORY, storage.StorageName);
listpt.Add(pt);
#endregion
}
var resPT = _productTrackContract.BulkInsert(listpt);
if (resPT.ResultType != OperationResultType.Success)
{
tran.Rollback();
return(Json(OperationResult.Error("商品追踪插入失败")));
}
List <string> proCodes = inves.Select(c => c.ProductBarcode).ToList();
var details = _productBarcodeDetailContract.productBarcodeDetails.Where(c => proCodes.Contains(c.ProductNumber + c.OnlyFlag));
details.Each(c => c.Status = 1);
var resPBD = _productBarcodeDetailContract.BulkUpdate(details);
if (resPBD.ResultType != OperationResultType.Success)
{
tran.Rollback();
return(Json(OperationResult.Error("商品条码信息更新失败")));
}
productsModeList.RemoveAll(c => proCodes.Contains(c.ProductBarcode));
SessionAccess.Set(key, productsModeList);
tran.Commit();
}
}
}
}
return(Json(optresul, JsonRequestBehavior.AllowGet));
}
