"景先生毕设|www.jxszl.com

C# DatabaseWrapper类代码示例

2023-12-29 17:48编辑: www.jxszl.com景先生毕设
本文整理汇总了C#中DatabaseWrapper类的典型用法代码示例。如果您正苦于以下问题:C#DatabaseWrapper类的具体用法?C#DatabaseWrapper怎么用?C#DatabaseWrapper使用的例子?这里精选的类代码示例或许可以为您提供帮助。 示例1:Execute_HappyPath_ReturnsProducerEeeDataHistory publicasyncTaskExecute_HappyPath_ReturnsProducerEeeDataHistory() { using(DatabaseWrapperdb=newDatabaseWrapper()) { //Arrange ModelHelperhelper=newModelHelper(db.Model); varscheme1=helper.CreateScheme(); scheme1.ApprovalNumber="WEE/TE0000ST/SCH"; varmemberUpload1=helper.CreateSubmittedMemberUpload(scheme1); memberUpload1.ComplianceYear=2000; varproducer1=helper.CreateProducerAsCompany(memberUpload1,"PRN123"); producer1.ObligationType="B2B"; vardataReturnVersion1=helper.CreateDataReturnVersion(scheme1,2000,1); dataReturnVersion1.SubmittedDate=newDateTime(2015,1,6); vardataReturnVersion2=helper.CreateDataReturnVersion(scheme1,2000,2); dataReturnVersion2.SubmittedDate=newDateTime(2015,1,8); helper.CreateEeeOutputAmount(dataReturnVersion1,producer1.RegisteredProducer,"B2B",1,100); helper.CreateEeeOutputAmount(dataReturnVersion2,producer1.RegisteredProducer,"B2B",2,200); varscheme2=helper.CreateScheme(); scheme2.ApprovalNumber="WEE/TE0000S1/SCH"; varmemberUpload2=helper.CreateSubmittedMemberUpload(scheme2); memberUpload2.ComplianceYear=2000; varproducer2=helper.CreateProducerAsCompany(memberUpload2,"PRN123"); producer2.ObligationType="B2C"; vardataReturnVersion3=helper.CreateDataReturnVersion(scheme2,2000,1); dataReturnVersion1.SubmittedDate=newDateTime(2015,1,9); vardataReturnVersion4=helper.CreateDataReturnVersion(scheme2,2000,2); dataReturnVersion4.SubmittedDate=newDateTime(2015,1,10); helper.CreateEeeOutputAmount(dataReturnVersion3,producer2.RegisteredProducer,"B2C",1,40); helper.CreateEeeOutputAmount(dataReturnVersion4,producer2.RegisteredProducer,"B2C",2,1000); db.Model.SaveChanges(); //Act varresults=awaitdb.StoredProcedures.SpgProducerEeeHistoryCsvData("PRN123"); //Assert Assert.NotNull(results); ProducerEeeHistoryCsvData.ProducerInReturnsResultb2cProducer=results.ProducerReturnsHistoryData.Find(x=>(x.ApprovalNumber=="WEE/TE0000S1/SCH")); Assert.NotNull(b2cProducer); Assert.Equal(2000,b2cProducer.ComplianceYear); Assert.Equal(1000,b2cProducer.Cat2B2C); Assert.Equal("Yes",b2cProducer.LatestData); ProducerEeeHistoryCsvData.ProducerInReturnsResultb2bProducer=results.ProducerReturnsHistoryData.Find(x=>(x.ApprovalNumber=="WEE/TE0000ST/SCH")); Assert.NotNull(b2bProducer); Assert.Equal(2000,b2bProducer.ComplianceYear); Assert.Equal(200,b2bProducer.Cat2B2B); Assert.Null(b2bProducer.Cat2B2C); Assert.Equal("Yes",b2bProducer.LatestData); Assert.Equal(4,results.ProducerReturnsHistoryData.Count); } }
原文链接:http://www.jxszl.com/biancheng/C/556846.html