寵物商店的設(shè)計(jì)實(shí)現(xiàn)分析

-.z.寵物商店系統(tǒng)的設(shè)計(jì)與實(shí)現(xiàn)作者詳情一覽表外文名中文名代號Aragorn阿拉貢114-.z.目錄TOC\o"1-2"\h\u98151緒論 1114741.1工程開發(fā)的背景 1116311.2工程開發(fā)的意義120762系統(tǒng)分析與設(shè)計(jì) 2226492.1工程主要功能描述 293242.2數(shù)據(jù)庫設(shè)計(jì) 2120033系統(tǒng)實(shí)現(xiàn) 551823.1系統(tǒng)首頁 599503.2增加寵物種類的功能實(shí)現(xiàn) 6297203.3查看購物車功能的實(shí)現(xiàn) 14218963.4注冊功能實(shí)現(xiàn) 4232143.5登錄功能實(shí)現(xiàn) 44290333.6查看寵物類別詳情功能實(shí)現(xiàn) 4744173.7刪除寵物種類功能實(shí)現(xiàn) 51168823.8添加寵物功能實(shí)現(xiàn) 53196873.9刪除訂單功能實(shí)現(xiàn) 56112293.10發(fā)送訂單功能實(shí)現(xiàn) 58191153.11修改密碼功能實(shí)現(xiàn) 59188453.12重新登錄功能實(shí)現(xiàn) 60203193.13在購物車中添加寵物功能實(shí)現(xiàn) 61144023.14刪除購物車中寵物功能實(shí)現(xiàn) 6818767結(jié)論72-.z.1緒論1.1工程開發(fā)的背景網(wǎng)上購物，這個(gè)逐漸流行于21世紀(jì)的購物方式已經(jīng)為越來越多的人所承受。不管是腰纏萬貫的大富翁、時(shí)尚的白領(lǐng)麗人還是普通的工薪階層，其局部人可能都有過上網(wǎng)購物的經(jīng)歷。這其中有的也許僅僅想擁有這種體檢的感覺，有的可能將此作為一種“知識人士〞的標(biāo)志，有的則可能已經(jīng)將網(wǎng)上購物作為自己日常生活的重要組成局部而取代了傳統(tǒng)上街購物的方式。所以此時(shí)各種網(wǎng)購軟件也就應(yīng)運(yùn)而生了。隨著社會的開展，人們的生活也越來越好，更多的人愿意養(yǎng)一個(gè)寵物來冶一下情操了。而正在此時(shí)，我們做軟件的程序員應(yīng)該發(fā)現(xiàn)時(shí)代的氣息、把我時(shí)代的走向，做出一款適合群眾網(wǎng)購寵物的軟件，所以我的寵物商店橫空出世了。1.2工程開發(fā)的意義首先，對于消費(fèi)者來說：第一，可以在家“逛商店〞，訂貨不受時(shí)間、地點(diǎn)的限制；第二，獲得較大量的商品信息，可以買到當(dāng)?shù)貨]有的商品；第三，網(wǎng)上支付較傳統(tǒng)拿現(xiàn)金支付更加平安，可防止現(xiàn)金喪失或遭到搶劫；第四，從訂貨、買貨到貨物上門無需親臨現(xiàn)場，既省時(shí)又省力；第五，由于網(wǎng)上商品省去租店面、召雇員及儲存保管等一系列費(fèi)用，總的來說其價(jià)格較一般商場的同類商品更廉價(jià)。其次，對于商家來說，由于網(wǎng)上銷售沒有庫存壓力、經(jīng)營本錢低、經(jīng)營規(guī)模不受場地限制等。在將來會有更多的企業(yè)選擇網(wǎng)上銷售，通過互聯(lián)網(wǎng)對市場信息的及時(shí)反應(yīng)適時(shí)調(diào)整經(jīng)營戰(zhàn)略，以此提高企業(yè)的經(jīng)濟(jì)效益和參與國際競爭的能力。再次，對于整個(gè)市場經(jīng)濟(jì)來說，這種新型的購物模式可在更大的圍、更廣的層面上以更高的效率實(shí)現(xiàn)資源配置。綜上可以看出，網(wǎng)上購物突破了傳統(tǒng)商務(wù)的障礙，無論對消費(fèi)者、企業(yè)還是市場都有著巨大的吸引力和影響力，在新經(jīng)濟(jì)時(shí)期無疑是到達(dá)“多贏〞效果的理想模式。2系統(tǒng)分析與設(shè)計(jì)2.1工程主要功能描述這是一個(gè)網(wǎng)上寵物商店系統(tǒng)，網(wǎng)店里提供了和實(shí)體店一樣的寵物來供用戶觀看、購置，具體功能如下：系統(tǒng)的注冊功能：在歡送頁可以實(shí)現(xiàn)用戶的注冊，注冊之后可以登錄。登錄功能：注冊完成后就可以使用剛剛注冊的賬號進(jìn)展登錄，如果是管理員，登錄后實(shí)現(xiàn)管理員的功能，如果是普通用戶，可以購置寵物。下面來介紹管理員登陸后的功能：寵物類別的添加功能：使用該功能可以添加寵物種類和寵物種類的編號。寵物類別的刪除功能：使用該功能可以刪除*些寵物種類及其編號。寵物類別的查看功能：使用該功能可以查看所有的寵物種類和他們對應(yīng)的編號。寵物數(shù)量的添加功能：使用該功能可以在一個(gè)寵物種類下添加一個(gè)具體的寵物，包括此寵物的價(jià)格、壽命、重量等等寵物的具體屬性。訂單發(fā)送功能：該功能可以發(fā)送顧客已經(jīng)購置的寵物的訂單。訂單刪除功能：使用該功能可以刪除任何顧客的購物車中的訂單，不管顧客有沒有購置，都可以刪除。重新登錄功能：使用該功能可以回到登錄頁面。密碼修改功能：該功能可以實(shí)現(xiàn)用戶密碼的修改?，F(xiàn)在介紹普通用戶的功能：添加寵物的功能：使用該功能可以將任何寵物添加到購物車。刪除寵物的功能：該功能可以刪除購物車中的寵物。查看購物車功能：該功能可以看見自己目前選定了多少寵物。購置寵物功能：使用該功能可以購置購物車中選定的寵物。修改密碼功能：使用該功能可以修改用戶的密碼。重新登錄功能：使用該動能可以回到登錄頁面。2.2數(shù)據(jù)庫設(shè)計(jì)1.繪制E-R圖進(jìn)展概念建模。用戶表用戶表管理寵物類別寵物訂單項(xiàng)表訂單表訂單項(xiàng)表存儲訂單表供給商表管理管理員普通用戶查看添加管理寵物類別寵物訂單項(xiàng)表訂單表訂單項(xiàng)表存儲訂單表供給商表管理管理員普通用戶查看添加2.數(shù)據(jù)庫表設(shè)計(jì)2-1用戶表〔Customer〕編號字段名數(shù)據(jù)類型是否主見字段意義1userIdint是用戶的編號2userNamenvarchar(50)否用戶名稱3userPasswordnvarchar(50)否用戶密碼2-2寵物表〔Pets〕編號字段名數(shù)據(jù)類型是否主見字段意義1PetsIdnvarchar(50)是寵物的編號2PetsNamenvarchar(50)否寵物名稱3Weightnvarchar(50)否寵物重量4PetsLifeint否寵物壽命5PurchasePricesmallmoney否寵物價(jià)格6RetailPricesmallmoney否寵物零售價(jià)7ActualSalePricesmallmoney否寵物售出的實(shí)際價(jià)格8PetsGenreIdnvarchar(50)否寵物所屬種類的編號2-3寵物種類表〔PetsGenre〕編號字段名數(shù)據(jù)類型是否主見字段意義1PetsGenreIdnvarchar(50)是寵物類別的編號2PetsGenreNamenvarchar(50)否寵物種類名稱2-4訂單表〔Pets〕編號字段名數(shù)據(jù)類型是否主見字段意義1PurchaseOrderIdint是訂單的編號2TotalMoneymoney否訂單價(jià)格3PurchaseDateDatetime否訂單產(chǎn)生日期4Demonvarchar(50)否顧客評價(jià)5SupplierIdint否供給商編號6CustomerIdInt否用戶編號7PurchaseOrderItemIdint否訂單項(xiàng)編號8Markint否用戶是否購置的標(biāo)記2-5訂單項(xiàng)表〔PurchaseOrderItem〕編號字段名數(shù)據(jù)類型是否主見字段意義1PurchaseOrderItemIdint是訂單項(xiàng)的編號2PetsQuanlityInt否寵物數(shù)量3TotalPerchaseItemPricemoney否訂單項(xiàng)價(jià)格4PetsIdnvarchar(50)否寵物編號5PurchaseOrderIdint否訂單編號2-6供給商表〔Supplier〕編號字段名數(shù)據(jù)類型是否主見字段意義1SupplierIdint是供給商的編號2SupplierNamenvarchar(50)否供給商名稱3Telephonenvarchar(50)否供給商4Addressnvarchar(50)否供給商地址5Fa*Codenvarchar(50)否供給商6Memonvarchar(50)否供給商備注3系統(tǒng)實(shí)現(xiàn)3.1系統(tǒng)首頁3.1.1管理員角色首頁3.1.2普通用戶角色首頁3.2增加寵物種類的功能實(shí)現(xiàn)3.2.1Model.Models層publicclassPetsGenre{publicstringPetsGenreId{get;set;}publicstringPetsGenreName{get;set;}}3.2.2Model.IRepository層publicinterfaceIPetsGenreRepository{voidAdd(PetsGenrePetsGenre);//addvoidSave(PetsGenrePetsGenre);//savevoidRemove(PetsGenrePetsGenre);//deletePetsGenreFindBy(stringid);//findaccordingtoidList<PetsGenre>FindAll();//findall}3.2.3Repository.Linq層publicclassPetsGenreRepository:IPetsGenreRepository{PetsShopSolutionDataConte*tdb=newPetsShopSolutionDataConte*t();publicvoidAdd(PetsGenrePetsGenre){//將一個(gè)類中的信息傳到那一個(gè)類中R_PetsGenrer_goodGenre=newR_PetsGenre();r_goodGenre.PetsGenreId=PetsGenre.PetsGenreId;r_goodGenre.PetsGenreName=PetsGenre.PetsGenreName;db.R_PetsGenre.InsertOnSubmit(r_goodGenre);db.SubmitChanges();}publicvoidSave(PetsGenrePetsGenre){varr_petsGenre=db.R_PetsGenre.SingleOrDefault<R_PetsGenre>(u=>u.PetsGenreId==PetsGenre.PetsGenreId);r_petsGenre.PetsGenreId=PetsGenre.PetsGenreId;r_petsGenre.PetsGenreName=PetsGenre.PetsGenreName;db.SubmitChanges();}publicvoidRemove(PetsGenrePetsGenre){varr_petsGenre=db.R_PetsGenre.SingleOrDefault<R_PetsGenre>(u=>u.PetsGenreId==PetsGenre.PetsGenreId);db.R_PetsGenre.DeleteOnSubmit(r_petsGenre);db.SubmitChanges();}publicPetsGenreFindBy(stringid){PetsGenrepetsGenre=newPetsGenre();varr_petsGenre=db.R_PetsGenre.SingleOrDefault<R_PetsGenre>(u=>u.PetsGenreId==id);if(r_petsGenre!=null){petsGenre.PetsGenreId=r_petsGenre.PetsGenreId;petsGenre.PetsGenreName=r_petsGenre.PetsGenreName;returnpetsGenre;}else{returnnull;}}publicList<PetsGenre>FindAll(){List<PetsGenre>petsGenres=newList<PetsGenre>();varr_petsGenres=db.R_PetsGenre.ToList();foreach(R_PetsGenrer_petsGenreinr_petsGenres){PetsGenrepetsGenre=newPetsGenre();petsGenre.PetsGenreId=r_petsGenre.PetsGenreId;petsGenre.PetsGenreName=r_petsGenre.PetsGenreName;petsGenres.Add(petsGenre);}returnpetsGenres;}}3.2.4Model.Services層publicclassPetsGenreService{privateIPetsGenreRepository_petsGenreRepository;publicPetsGenreService(IPetsGenreRepositorypetsGenreRepository){_petsGenreRepository=petsGenreRepository;}publicPetsGenreFindBy(stringpetsGenreId){return_petsGenreRepository.FindBy(petsGenreId);}publicboolIsE*isted(stringpetsGenreId){varresult=FindBy(petsGenreId);if(result!=null){returntrue;}else{returnfalse;}}publicList<PetsGenre>FindAll(){return_petsGenreRepository.FindAll();}publicboolIsE*istedName(stringpetsGenreName){varresult=FindAll().Where(u=>u.PetsGenreName==petsGenreName).ToList();if(result.Count>0){returntrue;}else{returnfalse;}}publicintAdd(PetsGenrepetsGenre){if(IsE*isted(petsGenre.PetsGenreId)){return4;}else{_petsGenreRepository.Add(petsGenre);return1;}}publicintSave(PetsGenrepetsGenre){if(IsE*isted(petsGenre.PetsGenreId)){_petsGenreRepository.Save(petsGenre);return2;}else{return5;}}publicintRemove(PetsGenrepetsGenre){if(IsE*isted(petsGenre.PetsGenreId)){_petsGenreRepository.Remove(petsGenre);return3;}else{return6;}}}3.2.5Service.ServiceFactory層publicstaticPetsGenreServiceCreatePetsGenreService(){IPetsGenreRepositorypetsGenreRepoitory=newPetsGenreRepository();returnnewPetsGenreService(petsGenreRepoitory);}3.2.6Infrastructure層publicclassStringHelper{publicstaticboolStringIsNull(stringtest){if(test.Trim()==""){returntrue;}else{returnfalse;}}publicstaticboolStringIsNotNull(stringtest){if(test.Trim()!=""){returntrue;}else{returnfalse;}}3.2.7WebUI.ASPNET層{PetsGenreServicepetsGenreService=ServiceFactory.CreatePetsGenreService();protectedvoidPage_Load(objectsender,EventArgse){}protectedvoidClearData()//此函數(shù)可清te*tbo*中的數(shù)據(jù){t*tPetsGenreId.Te*t="";t*tPetsGenreName.Te*t="";}protectedboolValidatePage()//此函數(shù)可判斷te*tbo*中的值是否為空{(diào)if(StringHelper.StringIsNull(t*tPetsGenreId.Te*t)){Response.Write("<script>alert('請?zhí)顚憣櫸镱悇e號！');</script>");returnfalse;}if(StringHelper.StringIsNull(t*tPetsGenreName.Te*t)){Response.Write("<script>alert('請?zhí)顚憣櫸锩Q！');</script>");returnfalse;}returntrue;}protectedvoidButton1_Click(objectsender,EventArgse)//觸發(fā)button按鈕事件{if(ValidatePage()){Model.Models.PetsGenrepetsGenre=newModel.Models.PetsGenre();petsGenre.PetsGenreId=t*tPetsGenreId.Te*t;petsGenre.PetsGenreName=t*tPetsGenreName.Te*t;intrel=petsGenreService.Add(petsGenre);Response.Write("<script>alert('寵物類別資料已經(jīng)創(chuàng)立成功！');</script>");ClearData();Response.Redirect("Inde*.asp*");}else{}}}3.3查看購物車功能的實(shí)現(xiàn)3.3.1Model.Models層publicclassPurchaseOrderItem{publicintPurchaseOrderItemId{set;get;}publicintPetsQuanlity{set;get;}//publicdecimalPetsPrice{set;get;}publicdecimal"TotalPerchaseItemPrice{set;get;}publicPetsPets{set;get;}//publicList<Pets>PetList{set;get;}publicintPurchaseOrderId{set;get;}publicPurchaseOrderItem(){Pets=newModel.Models.Pets();//PetList=newList<Pets>;//PurchaseOrder=newPurchaseOrder();}}publicclassPurchaseOrder{publicintPurchaseOrderId{set;get;}publicdecimal"TotalMoney{set;get;}publicDateTime"PurchaseDate{set;get;}publicstringDemo{set;get;}publicint"Mark{set;get;}publicSupplierSupplier{set;get;}publicCustomerCustomer{set;get;}//publicList<PurchaseOrderItem>PurchaseOrderItemList{set;get;}publicPurchaseOrderItemPurchaseOrderItem{set;get;}publicPurchaseOrder(){Supplier=newSupplier();Customer=newCustomer();//PurchaseOrderItemList=newList<PurchaseOrderItem>();PurchaseOrderItem=newPurchaseOrderItem();}}publicclassPets{publicstringPetsId{get;set;}publicstringPetsName{get;set;}publicstringWeight{get;set;}publicint"PetsLife{get;set;}publicPetsGenrePetsGenre{get;set;}publicPetsPricePetsPrice{get;set;}publicPets(){PetsGenre=newPetsGenre();PetsPrice=newPetsPrice();}}publicclassCustomer{publicintuserId{set;get;}publicstringuserName{set;get;}publicstringuserPassword{set;get;}}3.3.2Model.IRepository層publicinterfaceIPurchaseOrderRepository{voidAdd(PurchaseOrderpurchaseOrder);voidSave(PurchaseOrderpurchaseOrder);voidRemove(PurchaseOrderpurchaseOrder);PurchaseOrderFindBy(intid);//PurchaseOrderfindby(stringstr);List<PurchaseOrder>FindAll();}publicinterfaceIPurchaseOrderItemRepository{voidAdd(PurchaseOrderItemPurchaseOrderItem);voidRemove(PurchaseOrderItemPurchaseOrderItem);voidSave(PurchaseOrderItemPurchaseOrderItem);PurchaseOrderItemFindBy(intid);List<PurchaseOrderItem>Findall();}publicinterfaceIPetsRepository{voidAdd(Petspets);//addvoidSave(Petspets);//savevoidRemove(Petspets);//deletePetsFindBy(stringid);//findaccordingtoidList<Pets>FindAll();//findall}publicinterfaceICustomerRepository{voidAdd(Customercustomer);voidRemove(Customercustomer);voidSave(Customercustomer);CustomerFindBy(stringusername);List<Customer>FindAll();}3.3.3Repository.Linq層publicclassPurchaseOrderRepository:IPurchaseOrderRepository{PetsShopSolutionDataConte*tdb=newPetsShopSolutionDataConte*t();publicvoidAdd(PurchaseOrderpurchaseOrder){R_PurchaseOrderr_pets=newR_PurchaseOrder();r_pets.CustomerId=purchaseOrder.Customer.userId;r_pets.Demo=purchaseOrder.Demo;r_pets.PurchaseDate=purchaseOrder.PurchaseDate;r_pets.PurchaseOrderId=purchaseOrder.PurchaseOrderId;r_pets.PurchaseOrderItemId=purchaseOrder.PurchaseOrderItem.PurchaseOrderItemId;r_pets.SupplierId=purchaseOrder.Supplier.SupplierId;r_pets.TotalMoney=purchaseOrder.TotalMoney;r_pets.Mark=purchaseOrder.Mark;db.R_PurchaseOrder.InsertOnSubmit(r_pets);db.SubmitChanges();}publicvoidSave(PurchaseOrderpurchaseOrder){varr_purchaseOrder=db.R_PurchaseOrder.SingleOrDefault<R_PurchaseOrder>(u=>u.PurchaseOrderId==purchaseOrder.PurchaseOrderId);r_purchaseOrder.CustomerId=purchaseOrder.Customer.userId;r_purchaseOrder.Demo=purchaseOrder.Demo;r_purchaseOrder.PurchaseDate=purchaseOrder.PurchaseDate;r_purchaseOrder.PurchaseOrderId=purchaseOrder.PurchaseOrderId;r_purchaseOrder.PurchaseOrderItemId=purchaseOrder.PurchaseOrderItem.PurchaseOrderItemId;r_purchaseOrder.SupplierId=purchaseOrder.Supplier.SupplierId;r_purchaseOrder.TotalMoney=purchaseOrder.TotalMoney;r_purchaseOrder.Mark=purchaseOrder.Mark;db.SubmitChanges();}publicvoidRemove(PurchaseOrderpurchaseOrder){varr_purchasseOrder=db.R_PurchaseOrder.SingleOrDefault<R_PurchaseOrder>(u=>u.PurchaseOrderId==purchaseOrder.PurchaseOrderId);db.R_PurchaseOrder.DeleteOnSubmit(r_purchasseOrder);db.SubmitChanges();}publicPurchaseOrderFindBy(intid){PurchaseOrderpurchaseOrder=newPurchaseOrder();varr_purchaseOrder=(fromrindb.R_PurchaseOrder//joinpindb.R_Supplieronr.SupplierIdequalsp.SupplierIdjoinqindb.R_Customeronr.CustomerIdequalsq.userIdjoinsindb.R_PurchaseOrderItemonr.PurchaseOrderItemIdequalss.PurchaseOrderItemIdjoinpindb.R_Petsons.PetsIdequalsp.PetsIdwherer.PurchaseOrderId==idselectnew{id=r.PurchaseOrderId,customerid=r.CustomerId,customername=q.userName,demo=r.Demo,date=r.PurchaseDate,itemid=r.PurchaseOrderItemId,quality=s.PetsQuanlity,supplierid=r.SupplierId,totalmoney=r.TotalMoney,mark=r.Mark,petsid=p.PetsId,petsname=p.PetsName}).FirstOrDefault();//r).FirstOrDefault();if(r_purchaseOrder!=null){//purchaseOrder.Customer.userId=r_purchaseOrder.CustomerId;purchaseOrder.Customer.userId=r_purchaseOrder.customerid;purchaseOrder.Demo=r_purchaseOrder.demo;purchaseOrder.PurchaseDate=r_purchaseOrder.date;purchaseOrder.PurchaseOrderId=r_purchaseOrder.id;purchaseOrder.PurchaseOrderItem.PurchaseOrderItemId=r_purchaseOrder.itemid;purchaseOrder.PurchaseOrderItem.PetsQuanlity=r_purchaseOrder.quality;purchaseOrder.Supplier.SupplierId=r_purchaseOrder.supplierid;purchaseOrder.TotalMoney=r_purchaseOrder.totalmoney;purchaseOrder.Mark=r_purchaseOrder.mark;purchaseOrder.Customer.userName=r_purchaseOrder.customername;purchaseOrder.PurchaseOrderItem.Pets.PetsName=r_purchaseOrder.petsname;purchaseOrder.PurchaseOrderItem.Pets.PetsId=r_purchaseOrder.petsid;returnpurchaseOrder;}else{returnnull;}}publicList<PurchaseOrder>FindAll(){List<PurchaseOrder>purchaseOrders=newList<PurchaseOrder>();varr_purchaseOrders=db.R_PurchaseOrder.ToList();PurchaseOrderItemRepositorypoir=newPurchaseOrderItemRepository();PetsRepositorypr=newPetsRepository();CustomerRepositorycr=newCustomerRepository();PurchaseOrderRepositorypop=newPurchaseOrderRepository();Customercustomer;PurchaseOrderpo;PurchaseOrderItempurchaseOrderItem;Petspets;foreach(R_PurchaseOrderr_PurchaseOrderinr_purchaseOrders){stringstr=pop.FindBy(r_PurchaseOrder.PurchaseOrderId).Customer.userName;//customer=cr.FindBy(r_PurchaseOrder.);purchaseOrderItem=poir.FindBy(r_PurchaseOrder.PurchaseOrderItemId);pets=pr.FindBy(purchaseOrderItem.Pets.PetsId);PurchaseOrderpurchaseOrder=newPurchaseOrder();purchaseOrder.Customer.userId=r_PurchaseOrder.CustomerId;purchaseOrder.Customer.userName=str;purchaseOrder.Demo=r_PurchaseOrder.Demo;purchaseOrder.PurchaseDate=r_PurchaseOrder.PurchaseDate;purchaseOrder.PurchaseOrderId=r_PurchaseOrder.PurchaseOrderId;purchaseOrder.PurchaseOrderItem.PurchaseOrderItemId=r_PurchaseOrder.PurchaseOrderItemId;purchaseOrder.PurchaseOrderItem.PetsQuanlity=purchaseOrderItem.PetsQuanlity;purchaseOrder.PurchaseOrderItem.Pets.PetsId=pets.PetsId;purchaseOrder.PurchaseOrderItem.Pets.PetsName=pets.PetsName;purchaseOrder.Supplier.SupplierId=r_PurchaseOrder.SupplierId;purchaseOrder.TotalMoney=r_PurchaseOrder.TotalMoney;purchaseOrder.Mark=r_PurchaseOrder.Mark;purchaseOrders.Add(purchaseOrder);}returnpurchaseOrders;}}publicclassPetsRepository:IPetsRepository{PetsShopSolutionDataConte*tdb=newPetsShopSolutionDataConte*t();publicvoidAdd(Petspets){R_Petsr_pets=newR_Pets();r_pets.PetsId=pets.PetsId;r_pets.PetsName=pets.PetsName;r_pets.Weight=pets.Weight;r_pets.PetsLife=pets.PetsLife;r_pets.PurchasePrice=pets.PetsPrice.PurchasePrice;r_pets.RetailPrice=pets.PetsPrice.RetailPrice;r_pets.ActualSalePrice=pets.PetsPrice.ActualSalePrice;r_pets.PetsGenreId=pets.PetsGenre.PetsGenreId;db.R_Pets.InsertOnSubmit(r_pets);db.SubmitChanges();}publicvoidSave(Petspets){varr_pets=db.R_Pets.SingleOrDefault<R_Pets>(u=>u.PetsId==pets.PetsId);r_pets.PetsId=pets.PetsId;r_pets.ActualSalePrice=pets.PetsPrice.ActualSalePrice;r_pets.PetsGenreId=pets.PetsGenre.PetsGenreId;r_pets.PetsLife=pets.PetsLife;r_pets.PetsName=pets.PetsName;r_pets.PurchasePrice=pets.PetsPrice.PurchasePrice;r_pets.RetailPrice=pets.PetsPrice.RetailPrice;r_pets.Weight=pets.Weight;db.SubmitChanges();}publicvoidRemove(Petspets){varr_pets=db.R_Pets.SingleOrDefault<R_Pets>(u=>u.PetsId==pets.PetsId);db.R_Pets.DeleteOnSubmit(r_pets);db.SubmitChanges();}publicPetsFindBy(stringid){Petspets=newPets();varr_pets=(fromrindb.R_Petsjoinpindb.R_PetsGenreonr.PetsGenreIdequalsp.PetsGenreIdwherer.PetsId==idselectnew{PetsId=r.PetsId,PetsName=r.PetsName,Weight=r.Weight,PetsLife=r.PetsLife,PurchasePrice=r.PurchasePrice,RetailPrice=r.RetailPrice,ActualSalePrice=r.ActualSalePrice,PetsGenreId=p.PetsGenreId,etsGenreName=p.PetsGenreName}).FirstOrDefault();if(r_pets!=null){pets.PetsId=r_pets.PetsId;pets.PetsName=r_pets.PetsName;pets.Weight=r_pets.Weight;pets.PetsLife=r_pets.PetsLife;pets.PetsPrice.PurchasePrice=r_pets.PurchasePrice;pets.PetsPrice.ActualSalePrice=r_pets.ActualSalePrice;pets.PetsPrice.RetailPrice=r_pets.RetailPrice;pets.PetsGenre.PetsGenreId=r_pets.PetsGenreId;pets.PetsGenre.PetsGenreName=r_pets.etsGenreName;returnpets;}else{returnnull;}}publicList<Pets>FindAll(){List<Pets>petss=newList<Pets>();varr_pets=db.R_Pets.ToList();foreach(R_Petsrpetsinr_pets){Model.Models.PetsGenrepetsGenre;PetsGenreRepositorypetsGenreRepository=newPetsGenreRepository();Petspets=newPets();petsGenre=petsGenreRepository.FindBy(rpets.PetsGenreId);pets.PetsGenre.PetsGenreId=rpets.PetsGenreId;pets.PetsGenre.PetsGenreName=petsGenre.PetsGenreName;pets.PetsId=rpets.PetsId;pets.PetsLife=rpets.PetsLife;pets.PetsName=rpets.PetsName;pets.PetsPrice.ActualSalePrice=rpets.ActualSalePrice;pets.PetsPrice.PurchasePrice=rpets.PurchasePrice;pets.PetsPrice.RetailPrice=rpets.RetailPrice;pets.Weight=rpets.Weight;petss.Add(pets);}returnpetss;}}publicclassPurchaseOrderItemRepository:IPurchaseOrderItemRepository{PetsShopSolutionDataConte*tdb=newPetsShopSolutionDataConte*t();publicvoidAdd(PurchaseOrderItemPurchaseOrderItem){R_PurchaseOrderItemr_purchaseOrderItem=newR_PurchaseOrderItem();r_purchaseOrderItem.PetsId=PurchaseOrderItem.Pets.PetsId;r_purchaseOrderItem.PetsQuanlity=PurchaseOrderItem.PetsQuanlity;r_purchaseOrderItem.PurchaseOrderId=PurchaseOrderItem.PurchaseOrderId;r_purchaseOrderItem.PurchaseOrderItemId=PurchaseOrderItem.PurchaseOrderItemId;r_purchaseOrderItem.TotalPerchaseItemPrice=PurchaseOrderItem.TotalPerchaseItemPrice;db.R_PurchaseOrderItem.InsertOnSubmit(r_purchaseOrderItem);db.SubmitChanges();}publicvoidRemove(PurchaseOrderItemPurchaseOrderItem){varr_purchaseOrderItem=db.R_PurchaseOrderItem.FirstOrDefault<R_PurchaseOrderItem>(u=>u.PurchaseOrderItemId==PurchaseOrderItem.PurchaseOrderItemId);db.R_PurchaseOrderItem.DeleteOnSubmit(r_purchaseOrderItem);db.SubmitChanges();}publicvoidSave(PurchaseOrderItemPurchaseOrderItem){varr_purchaseOrderItem=db.R_PurchaseOrderItem.SingleOrDefault<R_PurchaseOrderItem>(u=>u.PurchaseOrderItemId==PurchaseOrderItem.PurchaseOrderItemId);r_purchaseOrderItem.PetsId=PurchaseOrderItem.Pets.PetsId;r_purchaseOrderItem.PetsQuanlity=PurchaseOrderItem.PetsQuanlity;db.SubmitChanges();}publicPurchaseOrderItemFindBy(intid){PurchaseOrderItempurchaseOrderItem=newPurchaseOrderItem();//varr_purchaseOrderItem=db.R_PurchaseOrderItem.SingleOrDefault<R_PurchaseOrderItem>//(u=>u.PurchaseOrderItemId==id);//if(r_purchaseOrderItem!=null)//{//purchaseOrderItem.Pets.PetsId=r_purchaseOrderItem.PetsId;//purchaseOrderItem.PetsQuanlity=r_purchaseOrderItem.PetsQuanlity;//purchaseOrderItem.PurchaseOrderId=r_purchaseOrderItem.PurchaseOrderId;//purchaseOrderItem.PurchaseOrderItemId=r_purchaseOrderItem.PurchaseOrderItemId;//purchaseOrderItem.TotalPerchaseItemPrice=r_purchaseOrderItem.TotalPerchaseItemPrice;//returnpurchaseOrderItem;//}varr_purchaseOrderItem=(fromrindb.R_PurchaseOrderItemjoinsindb.R_Petsonr.PetsIdequalss.PetsIdwherer.PurchaseOrderItemId==idselectnew