///// <summary>
///// 添加数据
///// </summary>
///// <param name="newData">数据</param>
//public void AddData(Pro_MaterialRequisition newData)
//{
// Insert(newData);
//}
/// <summary>
/// 修改申请单数据
/// </summary>
///
public string UpdateData(MaterialRequisitionModel theData, List <string> itemList)
{
Pro_MaterialRequisitionItemBusiness mrItemBus = new Pro_MaterialRequisitionItemBusiness();
try
{
mrItemBus.BeginTransaction();
if (itemList != null && itemList.Count > 0)
{
mrItemBus.Delete(itemList);
}
theData.MReqItemList.ForEach(item =>
{
mrItemBus.UpdateWhere(x => x.Id == item.Id, x =>
{
x.Quantity = item.Quantity;
});
});
}
catch
{
return("修改数据失败");
}
if (mrItemBus.EndTransaction())
{
return("");
}
else
{
return("修改数据失败");
}
}
/// <summary>
/// 根据申请单编码获取数申请单
/// </summary>
/// <param name="mrNo"></param>
/// <returns></returns>
public MaterialRequisitionModel GetMaterialRequistion(string mrNo)
{
MaterialRequisitionModel theData = null;// new MaterialRequisitionModel ();
if (!mrNo.Contains("PMR-"))
{
mrNo = "PMR-" + mrNo;
}
var query = this.GetIQueryable().Where(p => p.PMR_No == mrNo).ToList();
if (query.Count > 0)
{
theData = query[0].ToJson().ToObject <MaterialRequisitionModel>();
theData.MReqItemList = new Pro_MaterialRequisitionItemBusiness().GetIQueryable().Where(p => p.MR_Id == theData.Id).ToList();
}
return(theData);
}
/// <summary>
/// 获取指定的单条数据
/// </summary>
/// <param name="id">主键</param>
/// <returns></returns>
public MaterialRequisitionModel GetTheData(string id)
{
Pro_MaterialRequisition mrData = GetEntity(id);
MaterialRequisitionModel mrd = new MaterialRequisitionModel()
{
Id = mrData.Id,
CreateDate = mrData.CreateDate,
Creator = mrData.Creator,
Picker = mrData.Picker,
PMR_No = mrData.PMR_No,
ProCode = mrData.ProCode,
ProName = mrData.ProName,
Status = mrData.Status
};
Pro_MaterialRequisitionItemBusiness mrb = new Pro_MaterialRequisitionItemBusiness();
mrd.MReqItemList = mrb.GetDataList(id);
return(mrd);
}