public void Delete(int PRContentID)
{
PRContent content = QueryByID(PRContentID);
if (content != null)
{
content.Enabled = false;
}
_context.SaveChanges();
}
public PRQuotationGridRowModel(PRContent PRContent, string[] Quotations)
{
cell = new string[3 + Quotations.Length];
cell[0] = PRContent.PartID.ToString();
cell[1] = PRContent.PartName;
cell[2] = PRContent.PartNumber;
for (int i = 0; i < Quotations.Length; i++)
{
cell[2 + i] = Quotations[i];
}
}
public QRContentGridViewModel(IEnumerable <PurchaseItem> PurchaseItems, IPRContentRepository PRContentRepo)
{
rows = new List <QRContentGridRowModel>();
foreach (PurchaseItem _item in PurchaseItems)
{
PRContent _prcontent = PRContentRepo.PRContents.Where(p => p.PurchaseItemID == _item.PurchaseItemID).FirstOrDefault();
rows.Add(new QRContentGridRowModel(_item, _prcontent));
}
Page = 1;
Total = PurchaseItems.Count();
Records = 500;
}
public int Save(PRContent PRContent)
{
if (PRContent.PRContentID == 0)
{
PRContent.RequireTime = PRContent.RequireTime == new DateTime() ? new DateTime(1900, 1, 1) : PRContent.RequireTime;
PRContent.MoldNumber = PRContent.MoldNumber == null ? "其他采购" : PRContent.MoldNumber;
PRContent.ERPPartID = PRContent.ERPPartID ?? "";
_context.PRContents.Add(PRContent);
}
else
{
PRContent _dbEntry = _context.PRContents.Find(PRContent.PRContentID);
if (_dbEntry != null)
{
_dbEntry.PartID = PRContent.PartID;
_dbEntry.TaskID = PRContent.TaskID;
_dbEntry.PartName = PRContent.PartName;
_dbEntry.PartNumber = PRContent.PartNumber;
_dbEntry.PartSpecification = PRContent.PartSpecification;
_dbEntry.Quantity = PRContent.Quantity;
_dbEntry.PartTypeID = PRContent.PartTypeID;
_dbEntry.PurchaseRequestID = PRContent.PurchaseRequestID;
_dbEntry.UnitPrice = PRContent.UnitPrice;
_dbEntry.SubTotal = PRContent.SubTotal;
_dbEntry.MaterialName = PRContent.MaterialName;
_dbEntry.Hardness = PRContent.Hardness;
_dbEntry.JobNo = PRContent.JobNo;
_dbEntry.BrandName = PRContent.BrandName;
_dbEntry.PurchaseDrawing = PRContent.PurchaseDrawing;
_dbEntry.Memo = PRContent.Memo;
_dbEntry.EstimatePrice = PRContent.EstimatePrice;
//_dbEntry.Enabled = true ;
_dbEntry.SupplierName = PRContent.SupplierName;
_dbEntry.WarehouseStockID = PRContent.WarehouseStockID;
_dbEntry.MoldNumber = PRContent.MoldNumber == null?"其他采购":PRContent.MoldNumber;
_dbEntry.RequireTime = PRContent.RequireTime == new DateTime(1900, 1, 1) ? new DateTime(1900, 1, 1) : PRContent.RequireTime;
_dbEntry.CostCenterID = PRContent.CostCenterID;
_dbEntry.ERPPartID = PRContent.ERPPartID ?? "";
_dbEntry.Enabled = PRContent.Enabled;
_dbEntry.PurchaseTypeID = PRContent.PurchaseTypeID;
_dbEntry.unit = PRContent.unit ?? "件";
}
}
_context.SaveChanges();
return(PRContent.PRContentID);
}
public QRContentGridRowModel(PurchaseItem Item, PRContent PRContent)
{
cell = new string[14];
cell[0] = "";
cell[1] = Item.Name;
cell[2] = Item.PartNumber;
cell[3] = Item.Specification;
cell[4] = Item.Material;
cell[5] = PRContent == null?"":PRContent.Hardness;
cell[6] = Item.Quantity.ToString();
cell[7] = Item.unit ?? "件";
cell[8] = PRContent == null ? "" : PRContent.PurchaseDrawing.ToString();
cell[9] = PRContent.PRContentID.ToString();
cell[10] = Item.PurchaseItemID.ToString();
cell[11] = PRContent.Memo;
cell[12] = "";
//cell[13] = Item.RequireTime == new DateTime(1900, 1, 1) ? "-" : Item.RequireTime.ToString("yyyy-MM-dd");
}
//编辑PR单
public PurchaseContentGridRowModel(PRContent PRContent, string State, string CostCenter, string ERPNo, SetupTaskStart _setupTask)
{
cell = new string[27];
cell[0] = PRContent.PRContentID.ToString();
cell[1] = PRContent.PartID.ToString();
cell[2] = PRContent.TaskID.ToString();
cell[3] = PRContent.WarehouseStockID.ToString();
//获取零件短名
string name = PRContent.PartName ?? "";
//name = name.Substring(name.IndexOf('_') + 1, name.LastIndexOf('_') - name.IndexOf('_') - 1);
//name = name.Substring(0, name.LastIndexOf('_') - 1);
//
cell[4] = string.IsNullOrEmpty(name) ? PRContent.PartName : name;
cell[5] = PRContent.Quantity.ToString();
cell[6] = PRContent.PartNumber;
cell[7] = PRContent.PartSpecification;
cell[8] = PRContent.MaterialName;
cell[9] = PRContent.Hardness ?? "";
cell[10] = PRContent.JobNo;
cell[11] = PRContent.BrandName;
cell[12] = PRContent.SupplierName;
cell[13] = PRContent.PurchaseDrawing.ToString();
cell[14] = State;
cell[15] = PRContent.PurchaseItemID.ToString();
cell[16] = PRContent.RequireTime == new DateTime(1900, 1, 1) ? "-" : PRContent.RequireTime.ToString("yyyy-MM-dd");
cell[17] = PRContent.MoldNumber;
cell[18] = PRContent.CostCenterID.ToString();
cell[19] = CostCenter;
cell[20] = ERPNo;
cell[21] = PRContent.Memo;
cell[22] = _setupTask.UserName ?? "";
cell[23] = _setupTask.MachinesName ?? "";
cell[24] = _setupTask.MachinesCode ?? "";
cell[25] = PRContent.Quantity.ToString();
cell[26] = PRContent.PurchaseTypeID.ToString();
}
