/// <summary>
/// 首页汇总数量
/// </summary>
/// <returns></returns>
public virtual async Task <object> GetSummary()
{
//待审核实物订单
var count1 = await FlowSheetManager.GetAll().Where(o => o.FormKey == "SDR" && o.OrderStatus == "待审核").CountAsync();
//待审核报损报溢单
var count2 = await FlowSheetManager.GetAll().Where(o => o.FormKey == "ICH" && o.OrderStatus == "待审核").CountAsync();
//待审核发票
var count3 = await InvoiceManager.GetAll().Where(o => o.InvoiceStatus == InvoiceStatus.待审核).CountAsync();
return(new
{
count1, count2, count3
});
}
public override async Task Action(FlowSheet flowSheet, string action, DateTime?lastModifyTime)
{
//数据处理
var formObj = Newtonsoft.Json.JsonConvert.DeserializeObject <JObject>(flowSheet.FlowInstance.FormData);
var sheetData = formObj["sheetData"];
var sheetHeader = sheetData["header"];
var unitId = sheetHeader["unitId"].ToObject <int>();//代理商id
if (action == "backToCart")
{
foreach (var sheetItem in sheetData["body"])
{
var materialId = Convert.ToInt32(sheetItem["id"]); //对应的物料Id
var number = sheetItem["number"].ToObjectWithDefault <int>(); //订购数量
//销售记录取消
var materialSell = await MaterialSellManager.GetAll()
.Where(o => o.MaterialId == materialId && o.FlowSheetId == flowSheet.RelSheetId && o.SellNumber == number && o.UnitId == unitId).FirstOrDefaultAsync();
if (materialSell != null)
{
await MaterialSellManager.DeleteAsync(materialSell);
}
var materialCart = await CartRepository.GetAll().Where(o => o.UnitId == unitId && o.CreatorUserId == AbpSession.UserId && o.MaterialId == materialId).FirstOrDefaultAsync();
if (materialCart != null)
{
materialCart.Number += number;
await CartRepository.UpdateAsync(materialCart);
}
else
{
materialCart = new MaterialSellCart()
{
MaterialId = materialId,
Number = number,
UnitId = unitId
};
await CartRepository.InsertAsync(materialCart);
}
}
//删除订单
await FlowSheetManager.DeleteAsync(flowSheet);
}
}
/// <summary>
/// 流程实例的表单查看
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
public async Task <IActionResult> InstanceView(int data, string mode)
{
var user = await UserManager.GetByIdAsync(AbpSession.UserId.Value);
ViewBag.IsCenter = user.IsCenterUser;
var instance = await FlowInstanceManager.GetAll().Include(o => o.FlowForm).IgnoreQueryFilters().Where(o => o.Id == data).FirstOrDefaultAsync();
if (instance == null)
{
return(Error(L("此单据已不存在")));
}
var flowSheet = await FlowSheetManager.GetByInstanceId(data);
var defaultForms = Configuration.Modules.Core().DefaultForms;
var defaultForm = defaultForms.FirstOrDefault(o => o.FormKey == instance.FlowForm.FormKey);
switch (instance.FormType)
{
case FormType.Html:
//ViewBag.FormContent = instance.FormContent;
ViewBag.FormContent = string.IsNullOrEmpty(instance.FlowForm.FormContent) ? defaultForm?.FormContent : instance.FlowForm.FormContent;
ViewBag.FormData = instance.FormData;
ViewBag.Mode = mode;
ViewBag.SheetId = flowSheet.Id;
ViewBag.UpdateTime = instance.LastModificationTime?.ToString("yyyy-MM-dd HH:mm:ss");
ViewBag.OrderStatus = flowSheet?.OrderStatus;
return(View("HtmlView"));
case FormType.Designer:
return(View("DesignerView"));
case FormType.Spread:
return(View("SpreadView"));
}
return(View());
}
public override async Task Action(FlowSheet flowSheet, string action, DateTime?lastModifyTime)
{
//数据处理
var formObj = Newtonsoft.Json.JsonConvert.DeserializeObject <JObject>(flowSheet.FlowInstance.FormData);
var sheetData = formObj["sheetData"];
var sheetHeader = sheetData["header"];
flowSheet.Fee = sheetHeader["totalFee"].ToObjectWithDefault <decimal>();
var unitId = sheetHeader["unitId"].ToObject <int>();//代理商id
if (action == "backToCart")
{
foreach (var sheetItem in sheetData["body"])
{
var materialId = Convert.ToInt32(sheetItem["id"]); //对应的物料Id
var number = sheetItem["number"].ToObjectWithDefault <int>(); //订购数量
var materialCart = await CartRepository.GetAll().Where(o => o.UnitId == unitId && o.CreatorUserId == AbpSession.UserId && o.MaterialId == materialId).FirstOrDefaultAsync();
if (materialCart != null)
{
materialCart.Number += number;
await CartRepository.UpdateAsync(materialCart);
}
else
{
materialCart = new MaterialSellCart()
{
MaterialId = materialId,
Number = number,
UnitId = unitId
};
await CartRepository.InsertAsync(materialCart);
}
}
//删除订单
await FlowSheetManager.DeleteAsync(flowSheet);
}
else if (action == "modify")
{
if (flowSheet.OrderStatus != "待审核")
{
throw new UserFriendlyException("本单据已被审核，当前操作无效，请重新查看");
}
}
else if (action == "verify")
{
if (flowSheet.FlowInstance.LastModificationTime != null && (!lastModifyTime.HasValue || (flowSheet.FlowInstance.LastModificationTime.Value - lastModifyTime.Value).TotalSeconds > 1))
{
throw new UserFriendlyException($"本单据已在{flowSheet.FlowInstance.LastModificationTime?.ToString("yyyy-MM-dd HH:mm:ss")}被{flowSheet.FlowInstance.LastModifierUser?.Name}修改，当前操作无效，请重新查看后再提交");
}
flowSheet.OrderStatus = "待发货";
}
else if (action == "cancel")
{
flowSheet.OrderStatus = "已取消";
}
else if (action == "send")
{
flowSheet.OrderStatus = "已发货";
//‘收货时间’‘收货人姓名’‘联系方式’‘收货地址’
flowSheet.SetPropertyValue("Receiver", sheetHeader["receiver"].ToObjectWithDefault <string>());
flowSheet.SetPropertyValue("DeliverDate", sheetHeader["deliverDate"].ToObjectWithDefault <DateTime>());
flowSheet.SetPropertyValue("ReceiverMobile", sheetHeader["receiverMobile"].ToObjectWithDefault <string>());
flowSheet.SetPropertyValue("ReceiverAddress", sheetHeader["receiverAddress"].ToObjectWithDefault <string>());
var totalFee = sheetHeader["totalFee"].ToObjectWithDefault <decimal>();
//更改往来单位金额
await UnitManager.ChangeFee(unitId, null, -totalFee, flowSheet);
var materialSellIds = new List <int>();
var toOutMaterials = new Dictionary <int, int>();
var outStoreId = sheetHeader["storeId"].ToObjectWithDefault <int?>();
if (outStoreId == null)
{
throw new UserFriendlyException("请选择发货仓库");
}
var logs = new List <string>();
foreach (var sheetItem in sheetData["body"])
{
var materialId = sheetItem["materialId"].ToObjectWithDefault <int>(); //商品Id
var number = sheetItem["number"].ToObjectWithDefault <int>(); //出货数量
var materialSell = await MaterialSellManager.GetAll().Include(o => o.Material)
.Where(o => o.FlowSheetId == flowSheet.Id && o.MaterialId == materialId).FirstOrDefaultAsync();
if (materialSell != null)
{
if (materialSell.SellNumber != number)
{
//发生订购数量更改需要进行记录
logs.Add($"商品\"{materialSell.Material.Name}\"订购数量从{materialSell.SellNumber}调整为{number}");
}
materialSell.SellNumber = number;
materialSell.OutNumber = materialSell.SellNumber;//设置销售记录的出货数量等于订货数量
}
//建立销售出库记录
var materialSellOut = new MaterialSellOut()
{
UnitId = unitId,
FlowSheetId = flowSheet.Id,
MaterialId = materialId,
OutNumber = number,
Price = sheetItem["price"].ToObjectWithDefault <decimal>(),
Discount = sheetItem["discount"].ToObjectWithDefault <decimal>()
};
await MaterialSellOutManager.InsertAsync(materialSellOut);
//检测库存是否足够
if (!StoreMaterialManager.IsSatisfied(materialId, outStoreId.Value, unitId, number, out var message))
{
throw new UserFriendlyException(message);
}
//库存变化
await StoreMaterialManager.CountMaterial(outStoreId.Value, materialId, -number, flowSheet);
}
if (logs.Count > 0)
{
flowSheet.SetPropertyValue("Log", $"{AbpSession.Name()}于{DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")}将{string.Join(';', logs)}");
}
}
else if (action == "back")
{
var totalFee = sheetHeader["totalFee"].ToObjectWithDefault <decimal>();
flowSheet.OrderStatus = "已退货";
//更改往来单位金额
await UnitManager.ChangeFee(unitId, null, totalFee, flowSheet);
var materialSellIds = new List <int>();
var toOutMaterials = new Dictionary <int, int>();
var backStoreId = sheetHeader["backStoreId"].ToObjectWithDefault <int?>();
if (backStoreId == null)
{
throw new UserFriendlyException("请选择退入仓库");
}
foreach (var sheetItem in sheetData["body"])
{
var materialId = sheetItem["materialId"].ToObjectWithDefault <int>(); //商品Id
var number = sheetItem["number"].ToObjectWithDefault <int>(); //出货数量
//库存变化
await StoreMaterialManager.CountMaterial(backStoreId.Value, materialId, number, flowSheet);
//产生退货数据
var materialSellBack = new MaterialSellBack()
{
UnitId = unitId,
MaterialId = materialId,
BackNumber = number,
FlowSheetId = flowSheet.Id,
Discount = sheetItem["discount"].ToObjectWithDefault <decimal>(),
Price = sheetItem["price"].ToObjectWithDefault <decimal>(),
};
await MaterialSellBackManager.InsertAsync(materialSellBack);
}
}
}
public override async Task Handle(FlowSheet flowSheet)
{
await base.Handle(flowSheet);
//数据处理
var formObj = Newtonsoft.Json.JsonConvert.DeserializeObject <JObject>(flowSheet.FlowInstance.FormData);
var sheetData = formObj["sheetData"];
var sheetHeader = sheetData["header"];
flowSheet.SheetDate = sheetHeader["sheetDate"].ToObjectWithDefault <DateTime>();
flowSheet.Remarks = sheetHeader["remarks"].ToObjectWithDefault <string>();
var storeId = sheetHeader["storeId"].ToObject <int>(); //调出仓库id;
var unitId = sheetHeader["unitId"].ToObject <int>(); //供货商id
var totalFee = sheetHeader["totalFee"].ToObjectWithDefault <decimal>();
flowSheet.UnitId = unitId;
flowSheet.SetPropertyValue("StoreName", sheetHeader["storeName"].ToObjectWithDefault <string>());
flowSheet.SetPropertyValue("Fee", totalFee);
//是否从实物订货过来
var fromSDR = sheetHeader["fromSDR"].ToObjectWithDefault <string>();
if (!fromSDR.IsNullOrEmpty())
{
var SDRSheet = await FlowSheetManager.GetAll().Where(o => o.SheetSN == fromSDR).FirstOrDefaultAsync();
if (SDRSheet != null)
{
//SDRSheet.SetPropertyValue("PRHSheetSN", flowSheet.SheetSN);
SDRSheet.SetPropertyValue("PRHSheetId", flowSheet.Id);
await FlowSheetManager.UpdateAsync(SDRSheet);
}
}
//更改往来单位金额
await UnitManager.ChangeFee(unitId, null, totalFee, flowSheet);
foreach (var sheetItem in sheetData["body"])
{
var materialId = Convert.ToInt32(sheetItem["id"]); //对应的物料Id
var number = sheetItem["number"].ToObjectWithDefault <int>(); //入库数量
//记录采购
var materialBuy = new MaterialBuy()
{
UnitId = unitId,
MaterialId = materialId,
FlowSheetId = flowSheet.Id,
BuyNumber = number,
Price = sheetItem["price"].ToObjectWithDefault <decimal>(),
Discount = sheetItem["discount"].ToObjectWithDefault <decimal>(),
FeatureCode = sheetItem["featureCode"].ToObjectWithDefault <string>(),
MaterialBuyCodes = new List <MaterialBuyCode>()
//CodeStartNumber= sheetItem["codeStartNumber"].ToObjectWithDefault<string>(),
//CodeEndNumber = sheetItem["codeEndNumber"].ToObjectWithDefault<string>(),
};
//code记录
var codeNumber = sheetItem["codeNumber"].ToObjectWithDefault <string>();
if (!string.IsNullOrWhiteSpace(codeNumber))
{
var codeArr = codeNumber.Split(new char[] { ';', '；' });
codeArr.ToList().ForEach(o =>
{
var startNumber = 0M;
var endNumber = 0M;
if (o.IndexOf('~') < 0)
{
startNumber = decimal.Parse(o);
endNumber = decimal.Parse(o);
}
else
{
startNumber = decimal.Parse(o.Split('~')[0]);
endNumber = decimal.Parse(o.Split('~')[1]);
}
materialBuy.MaterialBuyCodes.Add(new MaterialBuyCode()
{
CodeStartNumber = startNumber,
CodeEndNumber = endNumber
});
});
}
await MaterialBuyManager.InsertAsync(materialBuy);
//库存变化
await StoreMaterialManager.CountMaterial(storeId, materialId, number, flowSheet);
}
}
