public Response InsertMBom(InterfaceMBomModel interfacembom)
{
Response Response = new Response();
if (!CheckLogin())
{
Response.Code = 500;
Response.Status = false;
Response.Message = "请先登录！";
return(Response);
}
try
{
#region 保存生产MBOM接口主表
InterfaceMbomHeader headdata = _context.Set <InterfaceMbomHeader>().AsQueryable().Where(u => u.ProductCode.Equals(interfacembom.interfaceMbomHeader.ProductCode)).SingleOrDefault();
interfacembom.interfaceMbomHeader.Id = headdata?.Id;
if (_unitWork.IsExist <ProductHeader>(u => u.Code.Equals(interfacembom.interfaceMbomHeader.ProductCode)))
{
interfacembom.interfaceMbomHeader.ProductId = _unitWork.FindSingle <ProductHeader>(u => u.Code.Equals(interfacembom.interfaceMbomHeader.ProductCode)).Id;
}
else
{
interfacembom.interfaceMbomHeader.ProductId = 0;
}
if (interfacembom.interfaceMbomHeader.Id == null)
{
if (interfacembom.interfaceMbomHeader.CreateBy == null)
{
interfacembom.interfaceMbomHeader.CreateBy = "system";
interfacembom.interfaceMbomHeader.CreateTime = DateTime.Now;
}
_unitWork.Add(interfacembom.interfaceMbomHeader);
}
else
{
if (interfacembom.interfaceMbomHeader.UpdateBy == null)
{
interfacembom.interfaceMbomHeader.UpdateBy = "system";
interfacembom.interfaceMbomHeader.UpdateTime = DateTime.Now;
}
_unitWork.UpdateByTracking(interfacembom.interfaceMbomHeader);
}
#endregion
#region 保存生产MBOM主表
MbomHeader mbomHeader = _unitWork.FindSingle <MbomHeader>(u => u.ProductCode.Equals(interfacembom.interfaceMbomHeader.ProductCode));
if (mbomHeader == null)
{
mbomHeader = new MbomHeader();
}
mbomHeader.ProductCode = interfacembom.interfaceMbomHeader.ProductCode;
if (_unitWork.IsExist <ProductHeader>(u => u.Code.Equals(interfacembom.interfaceMbomHeader.ProductCode)))
{
mbomHeader.ProductId = _unitWork.FindSingle <ProductHeader>(u => u.Code.Equals(interfacembom.interfaceMbomHeader.ProductCode)).Id;
}
else
{
mbomHeader.ProductId = 0;
}
mbomHeader.DrawingNumber = interfacembom.interfaceMbomHeader.DrawingNumber;
mbomHeader.Version = interfacembom.interfaceMbomHeader.Version;
if (interfacembom.interfaceMbomHeader.LineId == null)
{
var workship = _unitWork.FindSingle <ProductHeader>(u => u.Code == interfacembom.interfaceMbomHeader.ProductCode).WorkShop;
mbomHeader.LineId = _unitWork.FindSingle <Line>(u => u.WorkshopCode.Equals(workship)).Id;
}
else
{
mbomHeader.LineId = interfacembom.interfaceMbomHeader.LineId;
}
mbomHeader.Verifyer = interfacembom.interfaceMbomHeader.Verifyer;
mbomHeader.CreateTime = interfacembom.interfaceMbomHeader.CreateTime;
mbomHeader.CreateBy = interfacembom.interfaceMbomHeader.CreateBy;
mbomHeader.UpdateTime = interfacembom.interfaceMbomHeader.UpdateTime;
mbomHeader.UpdateBy = interfacembom.interfaceMbomHeader.UpdateBy;
if (mbomHeader.Id == null)
{
if (mbomHeader.CreateBy == null)
{
mbomHeader.CreateBy = "system";
mbomHeader.CreateTime = DateTime.Now;
}
_unitWork.Add(mbomHeader);
}
else
{
if (mbomHeader.UpdateBy == null)
{
mbomHeader.UpdateBy = "system";
mbomHeader.UpdateTime = DateTime.Now;
}
_unitWork.UpdateByTracking(mbomHeader);
}
#endregion
foreach (var item in interfacembom.interfaceMbomDetails)
{
try
{
#region 保存生产MBOM接口子表
InterfaceMbomDetail data = _context.Set <InterfaceMbomDetail>().AsQueryable().Where(u => u.MbomHeaderId.Equals(interfacembom.interfaceMbomHeader.Id) && u.MaterialCode.Equals(item.MaterialCode)).SingleOrDefault();
item.Id = data?.Id;
if (item.Id == null)
{
item.ProductCode = interfacembom.interfaceMbomHeader.ProductCode;
item.MbomHeaderId = interfacembom.interfaceMbomHeader.Id;
if (item.CreateBy == null)
{
item.CreateBy = "system";
item.CreateTime = DateTime.Now;
}
_unitWork.Add(item);
}
else
{
if (item.UpdateBy == null)
{
item.UpdateBy = "system";
item.UpdateTime = DateTime.Now;
}
_unitWork.UpdateByTracking(item);
}
#endregion
#region 保存生产MBOM子表
MbomDetail mbomDetail = _context.Set <MbomDetail>().AsQueryable().Where(u => u.MbomHeaderId.Equals(mbomHeader.Id) && u.MaterialCode.Equals(item.MaterialCode)).SingleOrDefault();
if (mbomDetail == null)
{
mbomDetail = new MbomDetail();
}
mbomDetail.MbomHeaderId = mbomHeader.Id;
mbomDetail.ProductCode = interfacembom.interfaceMbomHeader.ProductCode;
mbomDetail.StepId = item.StepId;
mbomDetail.MaterialCode = item.MaterialCode;
mbomDetail.BaseQty = item.BaseQty;
if (item.IsCheck == null)
{
mbomDetail.IsCheck = false;
}
else
{
mbomDetail.IsCheck = item.IsCheck;
}
mbomDetail.DrawingNumber = item.DrawingNumber;
mbomDetail.CreateTime = item.CreateTime;
mbomDetail.CreateBy = item.CreateBy;
mbomDetail.UpdateTime = item.UpdateTime;
mbomDetail.UpdateBy = item.UpdateBy;
if (mbomDetail.Id == null)
{
if (mbomDetail.CreateBy == null)
{
mbomDetail.CreateBy = "system";
mbomDetail.CreateTime = DateTime.Now;
}
_unitWork.Add(mbomDetail);
}
else
{
if (mbomDetail.UpdateBy == null)
{
mbomDetail.UpdateBy = "system";
mbomDetail.UpdateTime = DateTime.Now;
}
_unitWork.UpdateByTracking(mbomDetail);
}
#endregion
}
catch (Exception ex)
{
#region 记录生产MBOM接口子表错误信息
InterfaceMbomDetail data = _context.Set <InterfaceMbomDetail>().AsQueryable().Where(u => u.MbomHeaderId.Equals(mbomHeader.Id) && u.MaterialCode.Equals(item.MaterialCode)).SingleOrDefault();
if (data != null)
{
data.ErrorMessage = ex.Message;
if (data.UpdateBy == null)
{
data.UpdateBy = "system";
data.UpdateTime = DateTime.Now;
}
_unitWork.Update(data);
}
#endregion
Response.Code = 500;
Response.Status = false;
Response.Message = (Response.Message == "操作成功" ? "" : Response.Message) + "\r\n" + "主表ID:" + item.MbomHeaderId + ",MaterialCode:" + item.MaterialCode + "同步失败:" + ex.Message;
}
}
}
catch (Exception ex)
{
#region 记录生产MBOM接口主表错误信息
try
{
InterfaceMbomHeader data = _unitWork.FindSingle <InterfaceMbomHeader>(u => u.ProductCode.Equals(interfacembom.interfaceMbomHeader.ProductCode));
if (data != null)
{
data.ErrorMessage = ex.Message;
if (data.UpdateBy == null)
{
data.UpdateBy = "system";
data.UpdateTime = DateTime.Now;
}
_unitWork.Update(data);
}
}
catch (Exception)
{
}
#endregion
Response.Code = 500;
Response.Status = false;
Response.Message = (Response.Message == "操作成功" ? "" : Response.Message) + "\r\n" + "同步失败:" + ex.Message;
}
return(Response);
}
public string TransmitMBom([FromBody] InterfaceMBomModel interfacembom)
{
return(JsonHelper.Instance.Serialize(_app.InsertMBom(interfacembom)));
}
