寵物商店的設計與實現(xiàn)

1Aragor1AragorsFile第第1頁共74頁寵物商店系統(tǒng)的設計與實現(xiàn)外文名外文名表中文名代號Aragorn貢1142Aragorn’s2Aragorn’sFile第第2頁共74頁目 錄緒論 3項目開發(fā)的背景 3項目開發(fā)的意義 3系統(tǒng)分析與設計 4項目主要功能描述 4數(shù)據(jù)庫設計 5系統(tǒng)實現(xiàn) 8系統(tǒng)首頁 8增加寵物種類的功能實現(xiàn) 9查看購物車功能的實現(xiàn) 16注冊功能實現(xiàn) 44登錄功能實現(xiàn) 46查看寵物類別詳情功能實現(xiàn) 49刪除寵物種類功能實現(xiàn) 53添加寵物功能實現(xiàn) 55刪除訂單功能實現(xiàn) 58發(fā)送訂單功能實現(xiàn) 60修改密碼功能實現(xiàn) 61重新登錄功能實現(xiàn) 62在購物車中添加寵物功能實現(xiàn) 63刪除購物車中寵物功能實現(xiàn) 70結論 743Aragorn’s3Aragorn’sFile第第3頁共74頁項目開發(fā)的背景

1緒論網(wǎng)上購物，這個逐漸流行于21世紀的購物方式已經(jīng)為越來越多的人所接受。不論是腰纏萬貫的大富翁、時尚的白領麗人還是普通的工薪階層，其中大部分人可能都有過上網(wǎng)購物的經(jīng)歷。這其中有的也許僅僅想擁有這種體檢的感覺，有的可能將此作為一種“知識人士”的標志，有的則可能已經(jīng)將網(wǎng)上購物作為自己日常生活的重要組成部分而取代了傳統(tǒng)上街購物的方式。所以此時各種網(wǎng)購軟件也就應運而生了。隨著社會的發(fā)展，人們的生活也越來越好，更多的人愿意養(yǎng)一個寵物來陶冶一下情操了。而正在此時，我們做軟件的程序員應該發(fā)現(xiàn)時代的氣息、把我時代的走向，做出一款適合大眾網(wǎng)購寵物的軟件，所以我的寵物商店橫空出世了。項目開發(fā)的意義首先，對于消費者來說：第三，網(wǎng)上支付較傳統(tǒng)拿現(xiàn)金支付更加安全，可避免現(xiàn)金丟失或遭到搶劫；第四，從訂貨、買貨到貨物上門無需親臨現(xiàn)場，既省時又省力；第五，由于網(wǎng)上商品省去租店面、召雇員及儲存保管等一系列費用，總的來說其價格較一般商場的同類商品更便宜。其次，對于商家來說，由于網(wǎng)上銷售沒有庫存壓力、經(jīng)營成本低、經(jīng)營規(guī)模不受場地限制等。在將來會有更多的企業(yè)選擇網(wǎng)上銷售，通過互聯(lián)網(wǎng)對市場信息的及時反饋適時調整經(jīng)營戰(zhàn)略，以此提高企業(yè)的經(jīng)濟效益和參與國際競爭的能力。再次，對于整個市場經(jīng)濟來說，這種新型的購物模式可在更大的范圍內(nèi)、更廣的層面上以更高的效率實現(xiàn)資源配置。市場都有著巨大的吸引力和影響力，在新經(jīng)濟時期無疑是達到“多贏”效果的理想模式。4Aragorn’s4Aragorn’sFile第第4頁共74頁

2系統(tǒng)分析與設計這是一個網(wǎng)上寵物商店系統(tǒng)，網(wǎng)店里提供了和實體店一樣的寵物來供用戶觀看、購買，具體功能如下：系統(tǒng)的注冊功能：在歡迎頁可以實現(xiàn)用戶的注冊，注冊之后可以登錄。登錄功能：注冊完成后就可以使用剛才注冊的賬號進行登錄，如果是管理員，登錄后實現(xiàn)管理員的功能，如果是普通用戶，可以購買寵物。下面來介紹管理員登陸后的功能：寵物類別的添加功能：使用該功能可以添加寵物種類和寵物種類的編號。寵物類別的刪除功能：使用該功能可以刪除某些寵物種類及其編號。寵物類別的查看功能：使用該功能可以查看所有的寵物種類和他們對應的編號。寵物數(shù)量的添加功能：使用該功能可以在一個寵物種類下添加一個具體的寵物，包括此寵物的價格、壽命、重量等等寵物的具體屬性。訂單發(fā)送功能：該功能可以發(fā)送顧客已經(jīng)購買的寵物的訂單。訂單刪除功能：使用該功能可以刪除任何顧客的購物車中的訂單，不管顧客有沒有購買，都可以刪除。重新登錄功能：使用該功能可以回到登錄頁面?，F(xiàn)在介紹普通用戶的功能：添加寵物的功能：使用該功能可以將任何寵物添加到購物車。刪除寵物的功能：該功能可以刪除購物車中的寵物。購買寵物功能：使用該功能可以購買購物車中選定的寵物。修改密碼功能：使用該功能可以修改用戶的密碼。重新登錄功能：使用該動能可以回到登錄頁面。5Aragorn’s5Aragorn’sFile第第5頁共74頁數(shù)據(jù)庫設計E-R用戶表用戶表管理供應商表存儲戶管理員訂單表訂單表查看添加管理訂單項表訂單項表寵物寵物類別數(shù)據(jù)庫表設計用戶表（Customer）編號 字段名 數(shù)據(jù)類型 是否主見userId int 是userName nvarchar(50) 否userPassword nvarchar(50) 否寵物表（Pets）

字段意義用戶名稱用戶密碼6Aragorn’s6Aragorn’sFile第第6頁共74頁編號字段名數(shù)據(jù)類型是否主見字段意義1PetsIdnvarchar(50)是寵物的編號2PetsNamenvarchar(50)否寵物名稱3Weightnvarchar(50)否寵物重量4PetsLifeint否寵物壽命5PurchasePricesmallmoney否寵物價格6RetailPricesmallmoney否寵物零售價7ActualSalePricesmallmoney否寵物售出的實際價格8PetsGenreIdnvarchar(50)否寵物所屬種類的編號寵物種類表（PetsGenre）編號 字段名 數(shù)據(jù)類型 是否主見PetsGenreId nvarchar(50) 是編號字段名數(shù)據(jù)類型是否主見字段意義1PurchaseOrderId編號字段名數(shù)據(jù)類型是否主見字段意義1PurchaseOrderIdint是訂單的編號2TotalMoneymoney否訂單價格3PurchaseDateDatetime否訂單產(chǎn)生日期4Demonvarchar(50)否顧客評價5SupplierIdint否供應商編號6CustomerIdInt否用戶編號7PurchaseOrderItemIdint否訂單項編號8Markint否用戶是否購買的標記2-5訂單項表（PurchaseOrderItem）編號字段名數(shù)據(jù)類型是否主見字段意義1PurchaseOrderItemIdint是訂單項的編號2PetsQuanlityInt否寵物數(shù)量3TotalPerchaseItemPricemoney否訂單項價格4PetsIdnvarchar(50)否寵物編號5PurchaseOrderIdint否訂單編號

字段意義寵物類別的編號寵物種類名稱7Aragorn’s7Aragorn’sFile第第7頁共74頁2-6供應商表（Supplier）編號字段名數(shù)據(jù)類型是否主見字段意義1SupplierIdint是供應商的編號2SupplierNamenvarchar(50)否供應商名稱3Telephonenvarchar(50)否供應商電話4Addressnvarchar(50)否供應商地址5FaxCodenvarchar(50)否供應商傳真6Memonvarchar(50)否供應商備注8Aragorn’s8Aragorn’sFile第第8頁共74頁系統(tǒng)實現(xiàn)系統(tǒng)首頁的噢覺是很發(fā)飛勹勹患倫力非常強的器官．這使它院在聽.呂..."..“七"..".."+凸..."...-·.."..". 覺或其他感知器官沒有察覺的情況擊襯登陸布．．．．宜 下很容易接收外來的樣信息，并能迅速地做出反應．發(fā)達的嗅覺與靈敏的聽覺以及快速而敏捷的動歸隨掃婦，婦 旺I!!

i作完芙結合是千萬年來馬進化成.白...＂..""..""..＂功之處，也是馬為人類貢獻的主----'－「 `石蛇是無造的席行勃物的總稱，層于爬行窮育貊巨宛巫啟灰祜壞祝藎亮類全身布滿鱗片心房有蛇類都是肉貪付勃物．g3多井究類口芽佑紛 r 屈退化 無可活幼肪頸筵無耳孔，無西程，無莉租帶，身依麗湮恙有鯨匕 艇分有莘，世大多數(shù)無幸掃外心十二生岸“中世有心覺“這一層招屯管理員角色首頁普通用戶角色首頁9Aragorn’s9Aragorn’sFile第第9頁共74頁增加寵物種類的功能實現(xiàn)Model.ModelspublicclassPetsGenre{publicstringPetsGenreId{get;set;}publicstringPetsGenreName{get;set;}}Model.IRepositorypublicinterfaceIPetsGenreRepository{voidAdd(PetsGenrePetsGenre);//addvoidSave(PetsGenrePetsGenre);//savevoidRemove(PetsGenrePetsGenre);//deletePetsGenreFindBy(stringid);//findaccordingtoidList<PetsGenre>FindAll();//findall}Repository.LinqpublicclassPetsGenreRepository:IPetsGenreRepository{PetsShopSolutionDataContextdb=newPetsShopSolutionDataContext();publicvoidAdd(PetsGenrePetsGenre){將一個類中的信息傳到那一個類中R_PetsGenrer_goodGenre=newR_PetsGenre();r_goodGenre.PetsGenreId=PetsGenre.PetsGenreId;r_goodGenre.PetsGenreName=PetsGenre.PetsGenreName;db.R_PetsGenre.InsertOnSubmit(r_goodGenre);db.SubmitChanges();}Aragorn’sAragorn’sFilePAGE1074頁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{1Aragorn’s1Aragorn’sFilePAGE1174頁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;}}Model.ServicespublicclassPetsGenreService{privateIPetsGenreRepository_petsGenreRepository;publicPetsGenreService(IPetsGenreRepositorypetsGenreRepository){_petsGenreRepository=petsGenreRepository;}publicPetsGenreFindBy(stringpetsGenreId){return_petsGenreRepository.FindBy(petsGenreId);}Aragorn’sAragorn’sFilePAGE1274頁publicboolIsExisted(stringpetsGenreId){varresult=FindBy(petsGenreId);if(result!=null){returntrue;}else{returnfalse;}}publicList<PetsGenre>FindAll(){return_petsGenreRepository.FindAll();}publicboolIsExistedName(stringpetsGenreName){varresult=FindAll().Where(u=>u.PetsGenreName==petsGenreName).ToList();if(result.Count>0){returntrue;}else{returnfalse;}}publicintAdd(PetsGenrepetsGenre){Aragorn’sAragorn’sFilePAGE1374頁if(IsExisted(petsGenre.PetsGenreId)){return4;}else{_petsGenreRepository.Add(petsGenre);return1;}}publicintSave(PetsGenrepetsGenre){if(IsExisted(petsGenre.PetsGenreId)){_petsGenreRepository.Save(petsGenre);return2;}else{return5;}}publicintRemove(PetsGenrepetsGenre){if(IsExisted(petsGenre.PetsGenreId)){_petsGenreRepository.Remove(petsGenre);return3;}else{return6;}}}Aragorn’sAragorn’sFilePAGE1474頁Service.ServiceFactorypublicstaticPetsGenreServiceCreatePetsGenreService(){IPetsGenreRepositorypetsGenreRepoitory=newPetsGenreRepository();returnnewPetsGenreService(petsGenreRepoitory);}InfrastructurepublicclassStringHelper{publicstaticboolStringIsNull(stringtest){if(test.Trim()==""){returntrue;}else{returnfalse;}}publicstaticboolStringIsNotNull(stringtest){if(test.Trim()!=""){returntrue;}else{returnfalse;}Aragorn’sFile}WebUI.ASPNET層publicpartialclassCreate:System.Web.UI.Page{PetsGenreService petsGenreService ServiceFactory.CreatePetsGenreService();protectedvoidPage_Load(objectsender,EventArgse){}protectedvoidClearData()//此函數(shù)可清textbox中的數(shù)據(jù){txtPetsGenreId.Text="";txtPetsGenreName.Text="";}protectedboolValidatePage()//此函數(shù)可判斷textbox中的值是否為空{if(StringHelper.StringIsNull(txtPetsGenreId.Text)){第15頁共74頁Aragorn’sAragorn’sFilePAGE1674頁');</script>");}

Response.Write("<script>alert('請?zhí)顚憣櫸镱悇e號！returnfalse;if(StringHelper.StringIsNull(txtPetsGenreName.Text)){Response.Write("<script>alert('請?zhí)顚憣櫸锩Q！');</script>");returnfalse;}returntrue;}protectedvoidButton1_Click(objectsender,EventArgse)//觸發(fā)button按鈕事件{if(ValidatePage()){Model.Models.PetsGenreModel.Models.PetsGenre();

petsGenre = new');</script>");}

petsGenre.PetsGenreId=txtPetsGenreId.Text;petsGenre.PetsGenreName=txtPetsGenreName.Text;intrel=petsGenreService.Add(petsGenre);Response.Write("<script>alert('寵物類別資料已經(jīng)創(chuàng)建成功！ClearData();Response.Redirect("Index.aspx");else{}}}查看購物車功能的實現(xiàn)Aragorn’sAragorn’sFilePAGE1774頁Model.ModelspublicclassPurchaseOrderItem{publicint PurchaseOrderItemId{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{publicint PurchaseOrderId{set;get;}publicdecimal?TotalMoney{set;get;}publicDateTime?PurchaseDate{set;get;publicstringDemo{set;get;}publicint?Mark{set;get;}get;}

publicSupplierSupplier{set;get;}publicCustomerCustomer{set;get;}//public List<PurchaseOrderItem> PurchaseOrderItemList publicPurchaseOrderItemPurchaseOrderItem{set;get;}

set;Aragorn’sAragorn’sFilePAGE1874頁publicPurchaseOrder(){Supplier=newSupplier();Customer=newCustomer();//PurchaseOrderItemList=newList<PurchaseOrderItem>();PurchaseOrderItem=newPurchaseOrderItem();}}publicclassPets{publicstring PetsId{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;}}Aragorn’sAragorn’sFilePAGE1974頁Model.IRepositorypublicinterfaceIPurchaseOrderRepository{voidAdd(PurchaseOrderpurchaseOrder);voidSave(PurchaseOrderpurchaseOrder);voidRemove(PurchaseOrderpurchaseOrder);PurchaseOrderFindBy(intid);//PurchaseOrderfindby(stringList<PurchaseOrder>FindAll();}publicinterfaceIPurchaseOrderItemRepository{voidAdd(PurchaseOrderItemPurchaseOrderItem);voidRemove(PurchaseOrderItemPurchaseOrderItem);voidSave(PurchaseOrderItemPurchaseOrderItem);PurchaseOrderItemFindBy(intid);List<PurchaseOrderItem>Findall();}publicinterfaceIPetsRepository{voidAdd(Petspets);//addvoidSave(Petspets);//savevoidRemove(Petspets);//deletePetsFindBy(stringid);//findaccordingtoList<Pets>FindAll();//findall}Aragorn’sAragorn’sFilePAGE2074頁publicinterfaceICustomerRepository{voidAdd(Customercustomer);voidRemove(Customercustomer);voidSave(Customercustomer);CustomerFindBy(stringusername);List<Customer>FindAll();}Repository.LinqpublicclassPurchaseOrderRepository:IPurchaseOrderRepository{PetsShopSolutionDataContextdb=newPetsShopSolutionDataContext();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();Aragorn’sAragorn’sFilePAGE2174頁}publicvoidSave(PurchaseOrderpurchaseOrder){var r_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){var r_purchasseOrder db.R_PurchaseOrder.SingleOrDefault<R_PurchaseOrder>(u=>u.PurchaseOrderId==purchaseOrder.PurchaseOrderId);db.R_PurchaseOrder.DeleteOnSubmit(r_purchasseOrder);db.SubmitChanges();}publicPurchaseOrderFindBy(intid)2Aragorn’s2Aragorn’sFilePAGE2274頁{PurchaseOrderpurchaseOrder=newPurchaseOrder();varr_purchaseOrder=(fromrindb.R_PurchaseOrder//joinpindb.R_Supplieronr.SupplierIdequalsp.SupplierIdequalsq.userId

joinqindb.R_Customeronjoin s in db.R_PurchaseOrderItem r.PurchaseOrderItemIdequalss.PurchaseOrderItemIdjoinpindb.R_Petsons.PetsIdequalsp.PetsId

wherer.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;Aragorn’sAragorn’sFilePAGE2374頁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();PurchaseOrderItemRepositoryPurchaseOrderItemRepository();

poir = newPetsRepositorypr=newPetsRepository();Aragorn’sAragorn’sFilePAGE2474頁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;Aragorn’sAragorn’sFilePAGE2574頁purchaseOrder.Supplier.SupplierId=r_PurchaseOrder.SupplierId;purchaseOrder.TotalMoney=r_PurchaseOrder.TotalMoney;purchaseOrder.Mark=r_PurchaseOrder.Mark;purchaseOrders.Add(purchaseOrder);}returnpurchaseOrders;}}publicclassPetsRepository:IPetsRepository{PetsShopSolutionDataContextdb=newPetsShopSolutionDataContext();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>Aragorn’sAragorn’sFilePAGE2674頁(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){p.PetsGenreId

Petspets=newPets();varr_pets=(fromrindb.R_Petsjoinpindb.R_PetsGenreonr.PetsGenreIdequalswherer.PetsId==idselectnew{PetsId=r.PetsId,PetsName=r.PetsName,Weight=r.Weight,Aragorn’sAragorn’sFilePAGE2774頁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();Aragorn’sAragorn’sFilePAGE2874頁foreach(R_Petsrpetsinr_pets){Model.Models.PetsGenrepetsGenre;PetsGenreRepositoryPetsGenreRepository();Petspets=newPets();

petsGenreRepository=newpetsGenre=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;}}public classPurchaseOrderItemRepository:IPurchaseOrderItemRepository{PetsShopSolutionDataContextPetsShopSolutionDataContext();

db = newpublicvoidAdd(PurchaseOrderItemPurchaseOrderItem){R_PurchaseOrderItemR_PurchaseOrderItem();

r_purchaseOrderItem = newr_purchaseOrderItem.PetsId=PurchaseOrderItem.Pets.PetsId;Aragorn’sAragorn’sFilePAGE2974頁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){var r_purchaseOrderItem db.R_PurchaseOrderItem.FirstOrDefault<R_PurchaseOrderItem>(u=>u.PurchaseOrderItemId==PurchaseOrderItem.PurchaseOrderItemId);db.R_PurchaseOrderItem.DeleteOnSubmit(r_purchaseOrderItem);db.SubmitChanges();}publicvoidSave(PurchaseOrderItemPurchaseOrderItem){var r_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();Aragorn’sAragorn’sFilePAGE3074頁}publicPurchaseOrderItemFindBy(intid){PurchaseOrderItempurchaseOrderItem=newPurchaseOrderItem();//var r_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{itemId=r.PurchaseOrderItemId,petsId=r.PetsId,petsname=s.PetsName,quanlity=r.PetsQuanlity,Aragorn’sAragorn’sFilePAGE3174頁purchaseOrderid=r.PurchaseOrderId,price=r.TotalPerchaseItemPrice}).SingleOrDefault();if(r_purchaseOrderItem!=null){purchaseOrderItem.Pets.PetsId r_purchaseOrderItem.petsId;purchaseOrderItem.Pets.PetsName r_purchaseOrderItem.petsname;purchaseOrderItem.PetsQuanlity r_purchaseOrderItem.quanlity;purchaseOrderItem.PurchaseOrderId r_purchaseOrderItem.purchaseOrderid;purchaseOrderItem.PurchaseOrderItemId r_purchaseOrderItem.itemId;purchaseOrderItem.TotalPerchaseItemPrice r_purchaseOrderItem.price;returnpurchaseOrderItem;}else{returnnull;}}publicList<PurchaseOrderItem>Findall(){List<PurchaseOrderItem>List<PurchaseOrderItem>();

purchaseOrderItems = newvarr_purchaseOrderItems=db.R_PurchaseOrderItem.ToList();PurchaseOrderItemRepositoryPurchaseOrderItemRepository();

poir = newAragorn’sAragorn’sFilePAGE3274頁Model.Models.Petspets;PetsRepositorypr=newPetsRepository();foreachr_purchaseOrderItems){

(R_PurchaseOrderItem r_purchaseOrderItem inpets=pr.FindBy(r_purchaseOrderItem.PetsId);PurchaseOrderItemPurchaseOrderItem();purchaseOrderItem.Pets.PetsIdr_purchaseOrderItem.PetsId;

purchaseOrderItem=new=purchaseOrderItem.Pets.PetsName=pets.PetsName;purchaseOrderItem.PetsQuanlity r_purchaseOrderItem.PetsQuanlity;purchaseOrderItem.PurchaseOrderId r_purchaseOrderItem.PurchaseOrderId;purchaseOrderItem.PurchaseOrderItemId r_purchaseOrderItem.PurchaseOrderItemId;purchaseOrderItem.TotalPerchaseItemPrice r_purchaseOrderItem.TotalPerchaseItemPrice;purchaseOrderItems.Add(purchaseOrderItem);}returnpurchaseOrderItems;}}Model.ServicespublicclassPurchaseOrderService{privateIPurchaseOrderRepository_purchaseOrderRepository;publicpurchaseOrderRepository){

PurchaseOrderService(IPurchaseOrderRepository_purchaseOrderRepository=purchaseOrderRepository;}3Aragorn’s3Aragorn’sFilePAGE3374頁publicPurchaseOrderFindBy(intid){return_purchaseOrderRepository.FindBy(id);}publicList<PurchaseOrder>FindAll(){return_purchaseOrderRepository.FindAll();}publicboolIsExisted(intid){varresult=FindBy(id);if(result!=null){returntrue;}else{returnfalse;}}publicintAdd(PurchaseOrderpurchaseOrder){if(IsExisted(purchaseOrder.PurchaseOrderId)){return4;}else{_purchaseOrderRepository.Add(purchaseOrder);return1;}}Aragorn’sAragorn’sFilePAGE3474頁publicintSave(PurchaseOrderpurchaseOrder){if(IsExisted(purchaseOrder.PurchaseOrderId)){_purchaseOrderRepository.Save(purchaseOrder);return2;}else{return5;}}publicintRemove(PurchaseOrderpurchaseOrder){if(IsExisted(purchaseOrder.PurchaseOrderId)){_purchaseOrderRepository.Remove(purchaseOrder);return3;}else{return6;}}}public classPurchaseOrderItemService{private_purchaseOrderItemRepository;

IPurchaseOrderItemRepositorypublic PurchaseOrderItemService purchaseOrderItemRepository){_purchaseOrderItemRepository=purchaseOrderItemRepository;}Aragorn’sAragorn’sFilePAGE3574頁publicPurchaseOrderItemFindBy(intpurchaseOrderItemId){return_purchaseOrderItemRepository.FindBy(purchaseOrderItemId);}publicboolIsExited(intpurchaseOrderItemId){varresult=FindBy(purchaseOrderItemId);if(result!=null){returntrue;}else{returnfalse;}}publicList<PurchaseOrderItem>FindAll(){return_purchaseOrderItemRepository.Findall();}publicboolIsExistedPetName(stringpetsName){varresult=FindAll().Where(u=>u.Pets.PetsName==petsName).ToList();if(result.Count>0){returntrue;}else{returnfalse;}}publicintAdd(PurchaseOrderItempurchaseOrderItem){if(IsExited(purchaseOrderItem.PurchaseOrderItemId))Aragorn’sAragorn’sFilePAGE3674頁{return4;}else{_purchaseOrderItemRepository.Add(purchaseOrderItem);return1;}}publicintSave(PurchaseOrderItempurchaseOrderItem){if(IsExited(purchaseOrderItem.PurchaseOrderItemId)){_purchaseOrderItemRepository.Save(purchaseOrderItem);return2;}else{return5;}}publicintRemove(PurchaseOrderItempurchaseOrderItem){if(IsExited(purchaseOrderItem.PurchaseOrderItemId)){_purchaseOrderItemRepository.Remove(purchaseOrderItem);return2;}else{return6;}}}publicclassPetsService{Aragorn’sAragorn’sFilePAGE3774頁privateIPetsRepository_petsRepository;publicPetsService(IPetsRepositorypetsRepository){_petsRepository=petsRepository;}publicPetsFindBy(stringid){return_petsRepository.FindBy(id);}publicboolIsExisted(stringid){varresult=FindBy(id);if(result!=null){returntrue;}else{returnfalse;}}publicList<Pets>FindAll(){return_petsRepository.FindAll();}publicintAdd(Petspets){if(IsExisted(pets.PetsId)){return4;Aragorn’sAragorn’sFilePAGE3874頁}else{_petsRepository.Add(pets);return1;}}publicintSave(Petspets){if(IsExisted(pets.PetsId)){_petsRepository.Save(pets);return2;}else{return5;}}publicintRemove(Petspets){if(IsExisted(pets.PetsId)){_petsRepository.Remove(pets);return3;}else{return6;}}}publicclassCustomerRepository:ICustomerRepository{PetsShopSolutionDataContextdb=newPetsShopSolutionDataContext();Aragorn’sAragorn’sFilePAGE3974頁publicvoidAdd(Customercustomer){R_Customerr_customer=newR_Customer();r_customer.userId=customer.userId;r_customer.userName=customer.userName;r_customer.userPassword=customer.userPassword;db.R_Customer.InsertOnSubmit(r_customer);db.SubmitChanges();}publicvoidRemove(Customercustomer){varr_customer=db.R_Customer.SingleOrDefault<R_Customer>(u=>u.userId==customer.userId);db.R_Customer.DeleteOnSubmit(r_customer);db.SubmitChanges();}publicvoidSave(Customercustomer){varr_customer=db.R_Customer.SingleOrDefault<R_Customer>(u=>u.userId==customer.userId);r_customer.userId=customer.userId;r_customer.userName=customer.userName;r_customer.userPassword=customer.userPassword;db.Submit