public TableData UpdateDetailApp(MaterialDistributeTaskDetail materialDistributeTaskDetail)
{
using (var tran = _context.Database.BeginTransaction())
{
TableData tab = new TableData();
tab.code = 200;
try
{
_appd.Update(materialDistributeTaskDetail);
MaterialDemand materialDemand = _unitWork.Find <MaterialDemand>(u => u.OrderCode == materialDistributeTaskDetail.OrderCode && u.MaterialCode == materialDistributeTaskDetail.MaterialCode).FirstOrDefault();
materialDemand.DistributeQty = materialDistributeTaskDetail.Qty;
materialDemand.UpdateBy = "MaterialConfirm";
materialDemand.UpdateTime = DateTime.Now;
_unitWork.Update(materialDemand);
tab.msg = "备料信息变更成功！";
tran.Commit();
}
catch (Exception ex)
{
tran.Rollback();
tab.code = 300;
tab.msg += ex.Message;
}
return(tab);
}
}
public MaterialDemand CreateHospitalMedicalSupply(string hospitalId, MaterialDemand entity)
{
var hospital = GetHospital(hospitalId);
hospital.MaterialDemands.Add(entity);
_repoHospital.UpdateHospital(hospital);
return(entity);
}
public IActionResult CreateHospitalMedicalSupplies(
[FromRoute] string hospitalId,
[FromBody] MaterialDemand materialDemand
)
{
var data = _hospitalService.CreateHospitalMedicalSupply(hospitalId, materialDemand);
return(Created($"api/hospitals/{hospitalId}/medical-supplies", data));
}
public TableData Query(MaterialDemand entity)
{
var result = new TableData();
var data = _app.Find(EntityToExpression <MaterialDemand> .GetExpressions(entity));
GetData(data, result);
result.count = data.Count();
return(result);
}
public IActionResult UpdateHospitalMedicalSupplies(
[FromRoute] string hospitalId,
[FromRoute] string materialDemandId,
[FromBody] MaterialDemand materialDemand
)
{
var data = _hospitalService.UpdateHospitalMedicalSupply(hospitalId, materialDemandId, materialDemand);
return(NoContent());
}
public Response StockConfirmApp(MaterialDemandConfirmModel mdConfirmList)
{
Response Response = new Response();
string sErrorMsg = "";
//if (!CheckLogin())
//{
// Response.Code = 500;
// Response.Status = false;
// Response.Message = "请先登录！";
// return Response;
//}
foreach (MaterialDemandConfirm mdConfirm in mdConfirmList.Data)
{
try
{
MaterialDemand materialDemand = _unitWork.FindSingle <MaterialDemand>(u => u.Id.Equals(mdConfirm.Id));
if (materialDemand != null)
{
materialDemand.DistributeQty = mdConfirm.DistributeQty;
materialDemand.UpdateBy = "ConfirmAPI";
materialDemand.UpdateTime = DateTime.Now;
_unitWork.Update(materialDemand);
}
MaterialDistributeTaskDetail materialDistributeTaskDetail = _unitWork.FindSingle <MaterialDistributeTaskDetail>(u => u.OrderCode == mdConfirm.OrderCode && u.MaterialCode == mdConfirm.MaterialCode);
if (materialDistributeTaskDetail != null)
{
materialDistributeTaskDetail.Qty = mdConfirm.DistributeQty;
materialDistributeTaskDetail.ContainerCode = mdConfirm.ContainerCode;
materialDistributeTaskDetail.UpdateBy = "ConfirmAPI";
materialDistributeTaskDetail.UpdateTime = DateTime.Now;
_unitWork.Update(materialDistributeTaskDetail);
MaterialDistributeTaskHeader materialDistributeTaskHeader = _unitWork.FindSingle <MaterialDistributeTaskHeader>(u => u.Id == materialDistributeTaskDetail.MaterialDistributeTaskHeaderId);
if (materialDistributeTaskHeader.MaterialConfirm != MaterialConfirm.已确认)
{
materialDistributeTaskHeader.ContainerCode = mdConfirm.ContainerCode;
materialDistributeTaskHeader.StartPlace = mdConfirm.ContainerPlace;
materialDistributeTaskHeader.MaterialConfirm = MaterialConfirm.已确认;
materialDistributeTaskHeader.UpdateBy = "ConfirmAPI";
materialDistributeTaskHeader.UpdateTime = DateTime.Now;
_unitWork.Update(materialDistributeTaskHeader);
}
}
}
catch (Exception ex)
{
Response.Code = 500;
Response.Status = false;
Response.Message = (Response.Message == "操作成功" ? "" : Response.Message) + "\r\n" + "OrderCode:" + mdConfirm.OrderCode + "确认失败！" + ex.Message;
}
}
return(Response);
}
public string Upd(MaterialDemand Table_entity)
{
try
{
_app.Upd(Table_entity);
}
catch (Exception ex)
{
Result.Status = false;
Result.Message = ex.Message;
}
return(JsonHelper.Instance.Serialize(Result));
}
public MaterialDemand UpdateHospitalMedicalSupply(string hospitalId, string materialDemandId, MaterialDemand entity)
{
var hospital = GetHospital(hospitalId);
MaterialDemand materialDemand = null;
for (var i = 0; i < hospital.MaterialDemands.Count; i++)
{
materialDemand = hospital.MaterialDemands[i];
if (materialDemand.Id.ToString() == materialDemandId)
{
hospital.MaterialDemands[i] = entity;
break;
}
}
_repoHospital.UpdateHospital(hospital);
return(materialDemand);
}
public string GetTemplate()
{
var result = new TableData();
List <MaterialDemand> listMaterialDemand = new List <MaterialDemand>();
MaterialDemand entity = _app.FindSingle(u => u.Id > 0);
if (entity != null)
{
listMaterialDemand.Add(entity);
}
else
{
listMaterialDemand.Add(new MaterialDemand());
}
result.data = listMaterialDemand;
result.count = listMaterialDemand.Count;
return(JsonHelper.Instance.Serialize(result));
}
public Response ImportIn(IFormFile excelfile)
{
Response result = new Infrastructure.Response();
List <MaterialDemand> exp = imp.ConvertToModel <MaterialDemand>(excelfile);
string sErrorMsg = "";
for (int i = 0; i < exp.Count; i++)
{
try
{
MaterialDemand e = exp[i];
e.Id = null;
_app.Add(e);
}
catch (Exception ex)
{
sErrorMsg += "第" + (i + 2) + "行:" + ex.Message + "<br>";
result.Message = sErrorMsg;
break;
}
}
if (sErrorMsg.Equals(string.Empty))
{
if (exp.Count == 0)
{
sErrorMsg += "没有发现有效数据, 请确定模板是否正确， 或是否有填充数据！";
result.Message = sErrorMsg;
}
else
{
result.Message = "导入完成";
}
}
else
{
result.Status = false;
result.Message = result.Message;
}
return(result);
}
public void Upd(MaterialDemand entity)
{
_app.Update(entity);
}
public void Ins(MaterialDemand entity)
{
_app.Add(entity);
}
public TableData Load(PageReq pageRequest, MaterialDemand entity)
{
return(_app.Load(pageRequest, entity));
}
public TableData ExportData(MaterialDemand entity)
{
return(_app.ExportData(entity));
}
public TableData CreateMaterialListApp(List <OrderHeader> ohlist)
{
TableData tab = new TableData
{
code = 200
};
int hcount = 0;
int listcount = 0;
string sErrorMsg = "";
try
{
listcount = ohlist.Count;
foreach (OrderHeader orderhearder in ohlist)
{
OrderHeader oh = _unitWork.Find <OrderHeader>(u => u.Code == orderhearder.Code).FirstOrDefault();
//判断此工单的物料需求数据是否已经建立
if (!_unitWork.IsExist <MaterialDemand>(u => u.OrderCode == orderhearder.Code))
{
if (oh.PartMaterialCode == null)
{
oh.PartMaterialCode = oh.ProductCode;
}
//判断此产品的生产MBOM主表数据是否建立
if (_unitWork.IsExist <MbomHeader>(n => n.ProductCode == oh.PartMaterialCode))
{
var mhid = _unitWork.FindSingle <MbomHeader>(n => n.ProductCode == oh.PartMaterialCode).Id;
List <MbomDetail> mbomDetails = _unitWork.Find <MbomDetail>(u => u.MbomHeaderId.Equals(mhid)).ToList();
//判断此产品的生产MBOM明细数据是否建立
if (mbomDetails.Count > 0)
{
//根据生产工单和生产MBOM信息生成工单物料需求数据
foreach (MbomDetail mbomdt in mbomDetails)
{
var abctype = _unitWork.Find <Material>(u => u.Code == mbomdt.MaterialCode).Select(a => a.ClassABC).FirstOrDefault();
MaterialDemand md = new MaterialDemand();
md.OrderCode = oh.Code;
md.ProductCode = oh.ProductCode;
md.PartMaterialCode = oh.PartMaterialCode;
md.ClassABC = abctype;
md.DamandQty = oh.PlanQty * mbomdt.BaseQty;
md.DistributeQty = mbomdt.BaseQty;
md.MaterialCode = mbomdt.MaterialCode;
md.OnlineQty = 0;
md.OfflineQty = 0;
md.Status = "ready";
_appmd.Add(md);
}
hcount = hcount + 1;
}
else
{
sErrorMsg += "工单号为：" + oh.Code + "的生产MBOM明细资料未建立，请先去创建此工单的生产MBOM明细！<br>";
tab.msg = sErrorMsg;
}
}
else
{
sErrorMsg += "工单号为：" + oh.Code + "的生产MBOM未建立，请先去创建此工单的生产MBOM！<br>";
tab.msg = sErrorMsg;
}
}
else
{
sErrorMsg += "工单号为：" + oh.Code + "已经生成过物料需求清单，不可再生成！<br>";
tab.msg = sErrorMsg;
}
}
if (listcount <= hcount)
{
tab.code = 200;
tab.msg = "已按工单全部成功生成物料需求清单！";
}
else
{
tab.code = 200;
tab.msg = "执行完成！部分未成功生成的信息如下：<br>" + tab.msg;
}
}
catch (Exception ex)
{
tab.code = 300;
tab.msg += ex.Message;
}
return(tab);
}
public string Load(PageReq pageRequest, MaterialDemand entity)
{
return(JsonHelper.Instance.Serialize(_app.Load(pageRequest, entity)));
}
public string Export(MaterialDemand entity)
{
return(JsonHelper.Instance.Serialize(_app.ExportData(entity)));
}
