/// <summary>
/// 切换厂商
/// </summary>
/// <param name="multiSupplySupplier"></param>
/// <returns></returns>
private bool SwitchSupplier(MultiSupplySupplier multiSupplySupplier)
{
var group = base.genericMgr.FindById<MultiSupplyGroup>(multiSupplySupplier.GroupNo);
var sameEffSupplier = group.EffSupplier == multiSupplySupplier.Supplier;
var sameKBEffSupplier = group.KBEffSupplier == multiSupplySupplier.Supplier;
if (sameEffSupplier || sameKBEffSupplier)
{
var samGroupSuppliers = base.genericMgr.FindAll<MultiSupplySupplier>("select mss from MultiSupplySupplier as mss where mss.GroupNo = ? and Id != ? and IsActive=true and AccumulateQty > CycleQty", new object[] { multiSupplySupplier.GroupNo, multiSupplySupplier.Id }).OrderBy(c => c.Seq);
var nextSupplier = samGroupSuppliers.FirstOrDefault(c => c.Seq > multiSupplySupplier.Seq);
if (nextSupplier == null)
{
nextSupplier = samGroupSuppliers.FirstOrDefault(c => c.AccumulateQty > c.CycleQty);
}
if (nextSupplier == null)
return false;
if (sameEffSupplier)
{
group.EffSupplier = nextSupplier.Supplier;
group.TargetCycleQty = Convert.ToInt32(Math.Abs(nextSupplier.CycleQty - nextSupplier.SpillQty));
}
if (sameKBEffSupplier)
{
group.KBEffSupplier = nextSupplier.Supplier;
group.KBTargetCycleQty = nextSupplier.CycleQty;
}
base.genericMgr.Update(group);
}
return true;
}
public ActionResult _SupplierInsert(MultiSupplySupplier multiSupplySupplier, string GroupNo)
{
ModelState.Remove("Id");
if (ModelState.IsValid)
{
var suppliers = base.genericMgr.FindAll<MultiSupplySupplier>(duiplicateSupplierVerifyStatement,
new object[] { multiSupplySupplier.GroupNo, multiSupplySupplier.Supplier });
if (multiSupplySupplier.CycleQty <= 0)
{
ModelState.AddModelError("CycleQty", "循环量必须大于0");
}
else if (suppliers.Count() > 0)
{
ModelState.AddModelError("Supplier", string.Format(Resources.PRD.MultiSupplySupplier.MultiSupplySupplier_Existing_Supplier, multiSupplySupplier.Supplier));
}
else
{
var dbbMaxSeq = base.genericMgr.FindAll(selectMaxSupplierSeq, multiSupplySupplier.GroupNo)[0];
int maxSeq = 0;
int.TryParse((dbbMaxSeq != null ? dbbMaxSeq.ToString() : "0"), out maxSeq);
multiSupplySupplier.Seq = maxSeq + 1;
multiSupplySupplier.IsActive = true;
base.genericMgr.Create(multiSupplySupplier);
}
}
IList<MultiSupplySupplier> supplierList = base.genericMgr.FindAll<MultiSupplySupplier>(selectSupplierByGroupNoStatement, GroupNo);
return PartialView(new GridModel(supplierList));
}
public ActionResult _SupplierUpdate(MultiSupplySupplier multiSupplySupplier, string GroupNo)
{
if (ModelState.IsValid)
{
var suppliers = base.genericMgr.FindAll<MultiSupplySupplier>(duiplicateSupplierVerifyStatement,
new object[] { multiSupplySupplier.GroupNo, multiSupplySupplier.Supplier });
var sameItem = suppliers.FirstOrDefault(c => c.Id != multiSupplySupplier.Id);
if (multiSupplySupplier.CycleQty <= 0)
{
ModelState.AddModelError("CycleQty", "循环量必须大于0");
}
else if (sameItem != null)
{
ModelState.AddModelError("Supplier", string.Format(Resources.PRD.MultiSupplySupplier.MultiSupplySupplier_Existing_Supplier, multiSupplySupplier.Supplier));
}
else
{
var supplier = base.genericMgr.FindById<MultiSupplySupplier>(multiSupplySupplier.Id);
#region 切换厂商
if (supplier.IsActive && !multiSupplySupplier.IsActive)
{
bool isValid = SwitchSupplier(multiSupplySupplier);
if (!isValid)
{
ModelState.AddModelError("Supplier", "没找到后续有效供应商");
IList<MultiSupplySupplier> supplierList = base.genericMgr.FindAll<MultiSupplySupplier>(selectSupplierByGroupNoStatement, GroupNo);
return View(new GridModel(supplierList));
}
}
#endregion
supplier.Supplier = multiSupplySupplier.Supplier;
supplier.CycleQty = multiSupplySupplier.CycleQty;
supplier.SpillQty = multiSupplySupplier.SpillQty;
supplier.IsActive = multiSupplySupplier.IsActive;
supplier.Proportion = multiSupplySupplier.Proportion;
base.genericMgr.Update(supplier);
}
}
IList<MultiSupplySupplier> supplierList1 = base.genericMgr.FindAll<MultiSupplySupplier>(selectSupplierByGroupNoStatement, GroupNo);
return View(new GridModel(supplierList1));
}
public string CreateMultiSupplyItemXlsx(Stream inputStream)
{
if (inputStream.Length == 0)
{
throw new BusinessException("Import.Stream.Empty");
}
HSSFWorkbook workbook = new HSSFWorkbook(inputStream);
ISheet sheet = workbook.GetSheetAt(0);
IEnumerator rows = sheet.GetRowEnumerator();
ImportHelper.JumpRows(rows, 10);
#region 列定义
int colGroupNo = 1; // 多轨组号
int colDescription = 2; // 供应商代码
int colSupplier = 3; // 供应商代码
int colCycleQty = 4; // 循环量
int colProportion = 5; //循环量比例
int colSubstituteGroup = 6; //SAP替代组
int colItem = 7; // 物料编号
#endregion
var errorMessage = new BusinessException();
int colCount = 0;
IList<MultiSupplyItem> exactMultiSupplyItem = new List<MultiSupplyItem>();
IList<MultiSupplySupplier> exactMultiSupplySupplier = new List<MultiSupplySupplier>();
IList<MultiSupplyGroup> exactMultiSupplyGroup = new List<MultiSupplyGroup>();
IList<Supplier> supplierList = new List<Supplier>();
IList<Item> itemList = new List<Item>();
while (rows.MoveNext())
{
HSSFRow row = (HSSFRow)rows.Current;
if (!ImportHelper.CheckValidDataRow(row, 1, 5))
{
break;//边界
}
colCount++;
var rowErrors = new List<Message>();
string GroupNo = string.Empty;
string description = string.Empty;
string Item = string.Empty;
string Supplier = string.Empty;
string CycleQty = string.Empty;
#region 读取数据
GroupNo = ImportHelper.GetCellStringValue(row.GetCell(colGroupNo));
if (GroupNo == null || GroupNo.Trim() == string.Empty)
{
rowErrors.Add(new Message(MessageType.Error, Resources.ErrorMessage.Errors_Import_LineFieldCanNotBeNull, colCount.ToString(), Resources.PRD.MultiSupplyGroup.MultiSupplyGroup_GroupNo));
}
else
{
GroupNo = GroupNo.ToUpper();
}
description = ImportHelper.GetCellStringValue(row.GetCell(colDescription));
Supplier = ImportHelper.GetCellStringValue(row.GetCell(colSupplier));
if (Supplier == null || Supplier.Trim() == string.Empty)
{
rowErrors.Add(new Message(MessageType.Error, Resources.ErrorMessage.Errors_Import_LineFieldCanNotBeNull, colCount.ToString(), Resources.PRD.MultiSupplySupplier.MultiSupplySupplier_Supplier));
}
else
{
Supplier = Supplier.ToUpper();
}
CycleQty = ImportHelper.GetCellStringValue(row.GetCell(colCycleQty));
int cy;
int.TryParse(CycleQty, out cy);
if (cy <= 0)
{
rowErrors.Add(new Message(MessageType.Error, Resources.ErrorMessage.Errors_Import_LineFieldCanNotBeZero, colCount.ToString(), Resources.PRD.MultiSupplySupplier.MultiSupplySupplier_CycleQty));
}
Item = ImportHelper.GetCellStringValue(row.GetCell(colItem));
if (Item == null || Item.Trim() == string.Empty)
{
rowErrors.Add(new Message(MessageType.Error, Resources.ErrorMessage.Errors_Import_LineFieldCanNotBeNull, colCount.ToString(), Resources.PRD.MultiSupplyItem.MultiSupplyItem_Item));
}
else
{
Item = Item.ToUpper();
}
string proportion = ImportHelper.GetCellStringValue(row.GetCell(colProportion));
string substituteGroup = ImportHelper.GetCellStringValue(row.GetCell(colSubstituteGroup));
//Excel重复性验证
Item ItemInstance = null;
if (!string.IsNullOrWhiteSpace(GroupNo) && !string.IsNullOrWhiteSpace(Supplier) && !string.IsNullOrWhiteSpace(Item))
{
MultiSupplyItem innerSameMultiSupplyItem = exactMultiSupplyItem.FirstOrDefault(m => m.Item.ToUpper() == Item);
if (innerSameMultiSupplyItem != null)
{
if (innerSameMultiSupplyItem.GroupNo.ToUpper() != GroupNo)
{
rowErrors.Add(new Message(MessageType.Error, Resources.PRD.MultiSupplyItem.MultiSupplyItem_Import_ItemOnlyBelongOneGroup, colCount.ToString(), Item, innerSameMultiSupplyItem.GroupNo));
}
else if (innerSameMultiSupplyItem.GroupNo.ToUpper() == GroupNo && innerSameMultiSupplyItem.Supplier.ToUpper() == Supplier)
{
rowErrors.Add(new Message(MessageType.Error, Resources.PRD.MultiSupplyItem.MultiSupplyItem_Import_ItemOnlyBelongOneGroupDiffSupplier, colCount.ToString(), Item, innerSameMultiSupplyItem.GroupNo, innerSameMultiSupplyItem.Supplier));
}
}
//循环量相同性验证
if (exactMultiSupplySupplier.FirstOrDefault(m => m.GroupNo.ToUpper() == GroupNo && m.Supplier.ToUpper() == Supplier && m.CycleQty != cy) != null)
{
rowErrors.Add(new Message(MessageType.Error, Resources.PRD.MultiSupplyItem.MultiSupplyItem_Import_GroupSupplierDiffCycleQty, colCount.ToString(), GroupNo, Supplier));
}
//供应商存在性验证
if (supplierList.FirstOrDefault(i => i.Code.ToUpper() == Supplier) == null)
{
IList<Supplier> SupplierCount = this.genericMgr.FindAll<Supplier>("from Supplier as s where s.Code = ?", Supplier);
if (SupplierCount == null || SupplierCount.Count() == 0)
{
rowErrors.Add(new Message(MessageType.Error, Resources.ErrorMessage.Errors_Import_LineFieldValueNotExist, colCount.ToString(), Resources.PRD.MultiSupplyGroup.MultiSupplyGroup_Supplier, Supplier));
}
else
{
supplierList.Add(SupplierCount[0]);
}
}
//零件存在性
ItemInstance = itemList.FirstOrDefault(i => i.Code.ToUpper() == Item);
if (ItemInstance == null)
{
IList<Item> ItemCount = this.genericMgr.FindAll<Item>("from Item as i where i.Code= ?", Item);
if (ItemCount == null || ItemCount.Count() == 0)
{
rowErrors.Add(new Message(MessageType.Error, Resources.ErrorMessage.Errors_Import_LineFieldValueNotExist, colCount.ToString(), colCount.ToString(), Resources.PRD.MultiSupplyItem.MultiSupplyItem_Item, Item));
}
else
{
ItemInstance = ItemCount[0];
itemList.Add(ItemCount[0]);
}
}
//数据库重复性验证
var items = this.genericMgr.FindAll<MultiSupplyItem>(duiplicateItemVerifyStatement, new object[] { Item });
var sameItemInDiffGroup = items.FirstOrDefault(c => c.GroupNo.ToUpper() != GroupNo);
if (sameItemInDiffGroup != null)
{
rowErrors.Add(new Message(MessageType.Error, Resources.PRD.MultiSupplyItem.MultiSupplyItem_Import_ItemOnlyBelongOneGroup, colCount.ToString(), Item, sameItemInDiffGroup.GroupNo));
}
var sameItemInSameGroupandSupplier = items.FirstOrDefault(c => c.GroupNo.ToUpper() == GroupNo && c.Supplier.ToUpper() == Supplier);
if (sameItemInSameGroupandSupplier != null)
{
rowErrors.Add(new Message(MessageType.Error, Resources.PRD.MultiSupplyItem.MultiSupplyItem_Import_ItemOnlyBelongOneGroupDiffSupplier, colCount.ToString(), Item, sameItemInSameGroupandSupplier.GroupNo, sameItemInSameGroupandSupplier.Supplier));
}
}
if (rowErrors.Count > 0)
{
errorMessage.AddMessages(rowErrors);
}
else
{
var msi = new MultiSupplyItem
{
GroupNo = GroupNo,
Supplier = Supplier,
Item = ItemInstance.Code,
ItemDescription = ItemInstance.Description,
SubstituteGroup = substituteGroup,
};
exactMultiSupplyItem.Add(msi);
if (exactMultiSupplySupplier.FirstOrDefault(m => m.GroupNo.ToUpper() == GroupNo && m.Supplier.ToUpper() == Supplier) == null)
{
var suppliers = this.genericMgr.FindAll<MultiSupplySupplier>(duiplicateSupplierVerifyStatement,
new object[] { GroupNo, Supplier });
if (suppliers == null || suppliers.Count() == 0)
{
var mss = new MultiSupplySupplier
{
GroupNo = GroupNo,
Supplier = Supplier,
CycleQty = cy,
IsActive = true,
Proportion = proportion
};
exactMultiSupplySupplier.Add(mss);
}
}
if (exactMultiSupplyGroup.FirstOrDefault(m => m.GroupNo.ToUpper() == GroupNo) == null)
{
var msgGroupNo = this.genericMgr.FindAll<MultiSupplyGroup>(duiplicateVerifyStatement, GroupNo);
if (msgGroupNo == null || msgGroupNo.Count() == 0)
{
var msg = new MultiSupplyGroup { GroupNo = GroupNo, Description = description };
exactMultiSupplyGroup.Add(msg);
}
}
}
#endregion
}
foreach (MultiSupplyGroup msGroup in exactMultiSupplyGroup)
{
IList<MultiSupplySupplier> msSupplierList = exactMultiSupplySupplier.Where(p => p.GroupNo.ToUpper() == msGroup.GroupNo.ToUpper()).ToList();
if (msSupplierList.Count <= 1)
{
errorMessage.AddMessage("导入的数据中，多轨组{0}，必须包含大于1个供应商才可以创建。", msGroup.GroupNo);
}
}
if (errorMessage.HasMessage)
{
throw errorMessage;
}
#region SaveData
foreach (MultiSupplyGroup msGroup in exactMultiSupplyGroup)
{
this.genericMgr.Create(msGroup);
IList<MultiSupplySupplier> msSupplierList = exactMultiSupplySupplier.Where(p => p.GroupNo.ToUpper() == msGroup.GroupNo.ToUpper()).ToList();
int count = 1;
foreach (MultiSupplySupplier msSupplier in msSupplierList)
{
msSupplier.Seq = count;
this.genericMgr.Create(msSupplier);
count++;
exactMultiSupplySupplier.Remove(msSupplier);
}
}
if (exactMultiSupplySupplier.Count > 0)
{
var groups = exactMultiSupplySupplier.Select(c => c.GroupNo.ToUpper()).Distinct();
foreach (var group in groups)
{
var dbbMaxSeq = this.genericMgr.FindAll(selectMaxSupplierSeq, group)[0];
int maxSeq;
int.TryParse((dbbMaxSeq != null ? dbbMaxSeq.ToString() : "0"), out maxSeq);
foreach (MultiSupplySupplier msSupplier in exactMultiSupplySupplier.Where(c => c.GroupNo.ToUpper() == group))
{
maxSeq++;
msSupplier.Seq = maxSeq;
this.genericMgr.Create(msSupplier);
}
}
}
foreach (MultiSupplyItem msItem in exactMultiSupplyItem)
{
this.genericMgr.Create(msItem);
}
#endregion
return Resources.Global.ImportSuccess_BatchImportSuccessful;
}
