.NET企业级开发(卓越计划)第21课

•
var r_goods = (from r in db.R_Goods
•
join p in db.R_GoodsGenre
•
r_goods.Weight = goods.Weight;
•
r_goods.Size = goods.Size;
•
r_goods.DateOfProduction = goods.DateOfProduction;
•
r_goods.ShelfLife = goods.ShelfLife;
•
r_goods.DateOfOverdue = goods.DateOfOverdue;
•
r_goods.PurchaseCostPrice = goods.GoodsPrice.PurchaseCostPrice;
•
r_goods.RetailPrice = goods.GoodsPrice.RetailPrice;
•
r_goods.ActualSalePrice = goods.GoodsPrice.ActualSalePrice;
•
Hale Waihona Puke db.R_Goods.InsertOnSubmit(r_goods);
•
db.SubmitChanges();
1. GoodsRepository类设计
• （3）修改方法
• public void Save(Goods goods)
•
{
•
var r_goods = db.R_Goods.SingleOrDefault<R_Goods>(u =>
•
r_goods.Memo = goods.Memo;
•
r_goods.GoodsGenreId = goods.GoodsGenre.GoodsGenreId;
•
r_goods.PurchasePrice = goods.GoodsPrice.PurchasePrice;
•
r_goods.PurchaseTaxPrice = goods.GoodsPrice.PurchaseTaxPrice;
•
r_goods.PurchaseCostPrice = goods.GoodsPrice.PurchaseCostPrice;
•
r_goods.RetailPrice = goods.GoodsPrice.RetailPrice;
•
r_goods.ActualSalePrice = goods.GoodsPrice.ActualSalePrice;
•
{
•
R_Goods r_goods = new R_Goods();
•
r_goods.GoodsId = goods.GoodsId;
•
r_goods.GoodsName = goods.GoodsName;
•
r_goods.Brand = goods.Brand;
•
r_goods.Capacity = goods.Capacity;
主讲教师：孔磊
.NET企业级开发
L/O/G/O

上节回顾
• 上次课学习了Repository层的概念 • Repository层的模式 • Repository层的设计方法 • 本次课程将通过学习Repository层的实例
加深对Repository层的理解
第21课 Repository层实例
•
db.SubmitChanges();
•
}
1. GoodsRepository类设计
• （4）删除方法
• public void Remove(Goods goods)
•
{
•
var r_goods = db.R_Goods.SingleOrDefault<R_Goods>
•
(u => u.GoodsId == goods.GoodsId);
•
r_goods.Weight = goods.Weight;
•
r_goods.Size = goods.Size;
•
r_goods.DateOfProduction = goods.DateOfProduction;
•
r_goods.ShelfLife = goods.ShelfLife;
•
r_goods.DateOfOverdue = goods.DateOfOverdue;
•
r_goods.Memo = goods.Memo;
•
r_goods.GoodsGenreId = goods.GoodsGenre.GoodsGenreId;
•
r_goods.PurchasePrice = goods.GoodsPrice.PurchasePrice;
•
r_goods.PurchaseTaxPrice = goods.GoodsPrice.PurchaseTaxPrice;
u.GoodsId==goods.GoodsId);
•
r_goods.GoodsId = goods.GoodsId;
•
r_goods.GoodsName = goods.GoodsName;
•
r_goods.Brand = goods.Brand;
•
r_goods.Capacity = goods.Capacity;
1 GoodsRepository类设计 2 EmployeeRepository类设计 3 SupplierRepository类设计
1. GoodsRepository类设计
• （1）定义类 • using Model.Models; • using Model.IRepository;
• namespace Repository.Linq
•{
• public class GoodsRepository:IGoodsRepository
•{
•
WBADataContext db = new WBADataContext();
•}
•}
1. GoodsRepository类设计
• （2）添加方法
• public void Add(Goods goods)
•
db.R_Goods.DeleteOnSubmit(r_goods);
•
db.SubmitChanges();
•
}
1. GoodsRepository类设计
• （5）查询方法
• public Goods FindBy(string id)
•
{
•
Goods goods = new Goods();