public bool Create(ProductDataViewModel productDataViewModel)
{
bool ret = false;
try
{
ProductData p = new ProductData();
p.Brand = productDataViewModel.Brand;
p.Cost = productDataViewModel.Cost;
p.EndMoney = productDataViewModel.EndMoney;
p.EndNum = productDataViewModel.EndNum;
p.Name = productDataViewModel.Name;
p.Note = productDataViewModel.Note;
p.Price = productDataViewModel.Price;
p.ProductClass = productDataViewModel.ProductClass;
p.ProductID = productDataViewModel.ProductID;
p.SecurityNum = productDataViewModel.SecurityNum;
p.Unit = productDataViewModel.Unit;
p.ProductClassID = productDataViewModel.ProductClassID;
p.Note2 = productDataViewModel.Note2;
p.SW = productDataViewModel.SW;
db.ProductData.Add(p);
db.SaveChanges();
ret = true;
}
catch
{
}
return ret;
}
public bool CheckedUsed(ProductDataViewModel p)
{
try
{
if (db.SugProduct.Where(x => x.ProductNum == p.Num).Count() != 0)
return false;
if (db.CustomerContract.Where(x=>x.ProductID ==p.ProductID).Count() != 0)
return false;
}
catch
{
//return false;
}
return true;
}
public bool CheckedUsedChgPID(ProductDataViewModel p)
{
try
{
ProductData o = db.ProductData.Find(p.Num);
if (db.CustomerContract.Where(x => x.ProductID == o.ProductID).Count() > 0){
if(o.ProductID != p.ProductID || o.ProductClassID != p.ProductClassID)
return false;
}
}
catch
{
//return false;
}
return true;
}
public bool Delete(ProductDataViewModel productDataViewModel)
{
bool ret = false;
try
{
ProductData p = db.ProductData.Find(productDataViewModel.Num);
db.ProductData.Remove(p);
db.SaveChanges();
ret = true;
}
catch
{
}
return ret;
}
public bool Update(ProductDataViewModel productDataViewModel)
{
bool ret = false;
try
{
ProductData p = db.ProductData.Find(productDataViewModel.Num);
p.Brand = productDataViewModel.Brand;
p.Cost = productDataViewModel.Cost;
p.EndMoney = productDataViewModel.EndMoney;
p.EndNum = productDataViewModel.EndNum;
p.Name = productDataViewModel.Name;
p.Note = productDataViewModel.Note;
p.Price = productDataViewModel.Price;
p.ProductClass = productDataViewModel.ProductClass;
p.ProductID = productDataViewModel.ProductID;
p.SecurityNum = productDataViewModel.SecurityNum;
p.Unit = productDataViewModel.Unit;
p.ProductClassID = productDataViewModel.ProductClassID;
p.Note2 = productDataViewModel.Note2;
p.SW = productDataViewModel.SW;
db.SaveChanges();
ret = true;
}
catch (DbUpdateConcurrencyException ex)
{
// Update the values of the entity that failed to save from the store
ex.Entries.Single().Reload();
}
catch (DbEntityValidationException ex)
{
var errorMessages = ex.EntityValidationErrors
.SelectMany(x => x.ValidationErrors)
.Select(x => x.ErrorMessage);
// Join the list to a single string.
var fullErrorMessage = string.Join("; ", errorMessages);
// Combine the original exception message with the new one.
var exceptionMessage = string.Concat(ex.Message, " The validation errors are: ", fullErrorMessage);
// Throw a new DbEntityValidationException with the improved exception message.
throw new DbEntityValidationException(exceptionMessage, ex.EntityValidationErrors);
}
return ret;
}
public IQueryable<ProductDataViewModel> Read()
{
List<ProductDataViewModel> ret = new List<ProductDataViewModel>();
var qry = db.ProductData;
foreach (ProductData o in qry)
{
ProductDataViewModel p = new ProductDataViewModel();
p.Num = o.ProductNum;
p.Name = o.Name;
p.Brand = o.Brand;
p.ProductClass = o.ProductClass;
p.Note = o.Note;
p.ProductID = o.ProductID;
p.Unit = o.Unit;
p.Note2 = o.Note2;
p.SW = o.SW;
p.SWNote = "否";
if (p.SW)
p.SWNote = "是";
if (o.ProductClassID != null)
{
p.ProductNote = o.ProductClass1.Note;
p.ProductClassID = o.ProductClassID.Value;
}
p.SecurityNum = o.SecurityNum;
p.Price = o.Price;
p.Cost = o.Cost;
p.EndNum = o.EndNum;
p.EndMoney = o.EndMoney;
ret.Add(p);
}
return ret.AsQueryable();
}