public void Test_34() { //结果 var result = new String(); result.AppendLine("Select [a].[Email] "); result.AppendLine("From [Sample] As [a] "); result.Append("Group By [a].[B],[c].[D]"); //执行 _builder.Select <Sample>(t => t.Email) .From <Sample>("a") .GroupBy("a.B,c.[D]"); //验证 Assert.Equal(result.ToString(), _builder.ToSql()); }
public void TestScrollHeight_Number() { var attributes = new TagHelperAttributeList { { UiConst.ScrollHeight, "100" } }; var result = new String(); result.Append("<nz-table-wrapper #m_id_wrapper=\"\">"); result.Append("<nz-table #m_id=\"\" (nzPageIndexChange)=\"m_id_wrapper.pageIndexChange($event)\" (nzPageSizeChange)=\"m_id_wrapper.pageSizeChange($event)\" "); result.Append("[(nzPageIndex)]=\"m_id_wrapper.queryParam.page\" [(nzPageSize)]=\"m_id_wrapper.queryParam.pageSize\" "); result.Append("[nzData]=\"m_id_wrapper.dataSource\" [nzFrontPagination]=\"false\" "); result.Append("[nzLoading]=\"m_id_wrapper.loading\" [nzScroll]=\"{'y':'100px'}\" [nzShowPagination]=\"m_id_wrapper.showPagination\" "); result.Append("[nzShowQuickJumper]=\"true\" [nzShowSizeChanger]=\"true\" "); result.Append("[nzShowTotal]=\"template_m_id\" [nzTotal]=\"m_id_wrapper.totalCount\">"); AppendTableBodyHtml(result); Assert.Equal(result.ToString(), GetResult(attributes)); }
public void Test_27() { //结果 var result = new String(); result.AppendLine("Select [a].[Email] "); result.AppendLine("From [Sample] As [a] "); result.Append("Where ([a].[Email] Is Null Or [a].[Email]='')"); //执行 _builder.Select <Sample>(t => t.Email) .From <Sample>("a") .IsEmpty("a.Email"); //验证 Assert.Equal(result.ToString(), _builder.ToSql()); }
public void Test_30() { //结果 var result = new String(); result.AppendLine("Select [a].[Email] "); result.AppendLine("From [Sample] As [a] "); result.Append("Where [a].[Email] Is Not Null And [a].[Email]<>''"); //执行 _builder.Select <Sample>(t => t.Email) .From <Sample>("a") .IsNotEmpty <Sample>(t => t.Email); //验证 Assert.Equal(result.ToString(), _builder.ToSql()); }
public void TestQueryParam() { var attributes = new TagHelperAttributeList { { UiConst.QueryParam, "a" } }; var result = new String(); result.Append("<nz-table-wrapper #m_id_wrapper=\"\" [(queryParam)]=\"a\">"); result.Append("<nz-table #m_id=\"\" [nzData]=\"m_id_wrapper.dataSource\" [nzTotal]=\"m_id_wrapper.totalCount\">"); result.Append("<tbody>"); result.Append("<tr *ngFor=\"let row of m_id.data\">"); result.Append("</tr>"); result.Append("</tbody>"); result.Append("</nz-table>"); result.Append("</nz-table-wrapper>"); Assert.Equal(result.ToString(), GetResult(attributes)); }
public void Test_1() { //结果 var result = new String(); result.AppendLine("Select [a3].[a],[a1].[b1],[a2].[b2] "); result.AppendLine("From [b] As [a2] "); result.Append("Join [c] As [a3] On [a2].[d]=[a3].[e]"); //执行 _builder.Select("a,a1.b1,[a2].[b2]", "a3") .From("b", "a2") .Join("c", "a3").On("a2.d", "a3.[e]"); //验证 Assert.Equal(result.ToString(), _builder.ToSql()); }
public void TestDefault() { var result = new String(); result.Append("<nz-tree-table-wrapper #m_id_wrapper=\"\">"); result.Append("<nz-table #m_id=\"\" (nzPageIndexChange)=\"m_id_wrapper.pageIndexChange($event)\" (nzPageSizeChange)=\"m_id_wrapper.pageSizeChange($event)\" "); result.Append("[nzData]=\"m_id_wrapper.dataSource\" [nzFrontPagination]=\"false\" [nzLoading]=\"m_id_wrapper.loading\" [nzShowPagination]=\"m_id_wrapper.showPagination\" "); result.Append("[nzShowSizeChanger]=\"true\" [nzTotal]=\"m_id_wrapper.totalCount\">"); result.Append("<tbody>"); result.Append("<ng-container *ngFor=\"let row of m_id.data\">"); result.Append("<tr *ngIf=\"m_id_wrapper.isShow(row)\">"); result.Append("</tr>"); result.Append("</ng-container>"); result.Append("</tbody>"); result.Append("</nz-table>"); result.Append("</nz-tree-table-wrapper>"); Assert.Equal(result.ToString(), GetResult()); }
public void TestSignType() { //结果 var result = new String(); result.Append("<xml>"); result.Append("<sign_type><![CDATA[a]]></sign_type>"); result.Append("</xml>"); //操作 _builder.SignType("a"); //验证 Assert.Equal(result.ToString(), _builder.ToXmlNoContainsSign()); //输出结果 _output.WriteLine(_builder.ToString()); }
public void TestMerchantId() { //结果 var result = new String(); result.Append("<xml>"); result.Append("<mch_id><![CDATA[a]]></mch_id>"); result.Append("</xml>"); //操作 _builder.MerchantId("a"); //验证 Assert.Equal(result.ToString(), _builder.ToXmlNoContainsSign()); //输出结果 _output.WriteLine(_builder.ToString()); }
public void TestBindDeleteUrl() { var attributes = new TagHelperAttributeList { { AngularConst.BindDeleteUrl, "a" } }; var result = new String(); result.Append("<nz-table-wrapper #m_id_wrapper=\"\" [deleteUrl]=\"a\">"); result.Append("<nz-table #m_id=\"\" [nzData]=\"m_id_wrapper.dataSource\" [nzShowPagination]=\"m_id_wrapper.showPagination\" "); result.Append("[nzTotal]=\"m_id_wrapper.totalCount\">"); result.Append("<tbody>"); result.Append("<tr *ngFor=\"let row of m_id.data\">"); result.Append("</tr>"); result.Append("</tbody>"); result.Append("</nz-table>"); result.Append("</nz-table-wrapper>"); Assert.Equal(result.ToString(), GetResult(attributes)); }
public void TestOutTradeNo() { //结果 var result = new String(); result.Append("<xml>"); result.Append("<out_trade_no><![CDATA[a]]></out_trade_no>"); result.Append("</xml>"); //操作 _builder.OutTradeNo("a"); //验证 Assert.Equal(result.ToString(), _builder.ToXmlNoContainsSign()); //输出结果 _output.WriteLine(_builder.ToString()); }
public void TestId() { var attributes = new TagHelperAttributeList { { UiConst.Id, "a" } }; var result = new String(); result.Append("<nz-table-wrapper #a_wrapper=\"\">"); result.Append("<nz-table #a=\"\" [nzData]=\"a_wrapper.dataSource\" [nzShowPagination]=\"a_wrapper.showPagination\" "); result.Append("[nzTotal]=\"a_wrapper.totalCount\">"); result.Append("<tbody>"); result.Append("<tr *ngFor=\"let row of a.data\">"); result.Append("</tr>"); result.Append("</tbody>"); result.Append("</nz-table>"); result.Append("</nz-table-wrapper>"); Assert.Equal(result.ToString(), GetResult(attributes)); }
public void TestWhere_19() { //结果 var result = new String(); result.AppendLine("Select * "); result.AppendLine("From [Sample] As [k] "); result.Append("Where [k].[Email]=@_p__0 And [k].[StringValue] Like @_p__1"); //执行 _builder.From <Sample>("k").Where <Sample>(t => t.Email == "a" && t.StringValue.Contains("b")); //验证 Assert.Equal(result.ToString(), _builder.ToSql()); Assert.Equal(2, _builder.GetParams().Count); Assert.Equal("a", _builder.GetParams()["@_p__0"]); Assert.Equal("%b%", _builder.GetParams()["@_p__1"]); }
public void TestWhere_21() { //结果 var result = new String(); result.AppendLine("Select * "); result.AppendLine("From [Sample] As [k] "); result.Append("Where ([o].[Email]=@_p__0 And [o].[StringValue] Like @_p__1 Or [o].[IntValue]=@_p__2) "); result.Append("And ([p].[Email]=@_p__3 Or [p].[IntValue]=@_p__4)"); //执行 _builder.From <Sample>("k") .Where <Sample>(t => t.Email == "a" && t.StringValue.Contains("b") || t.IntValue == 1, "o") .Where <Sample>(t => t.Email == "c" || t.IntValue == 2, "p"); //验证 Assert.Equal(result.ToString(), _builder.ToSql()); }
public void TestSpbillCreateIp() { //结果 var result = new String(); result.Append("<xml>"); result.Append("<spbill_create_ip><![CDATA[a]]></spbill_create_ip>"); result.Append("</xml>"); //操作 _builder.SpbillCreateIp("a"); //验证 Assert.Equal(result.ToString(), _builder.ToXmlNoContainsSign()); //输出结果 _output.WriteLine(_builder.ToString()); }
public void TestAutoLoad() { var attributes = new TagHelperAttributeList { { UiConst.AutoLoad, false } }; var result = new String(); result.Append("<nz-table-wrapper #m_id_wrapper=\"\" [autoLoad]=\"false\">"); result.Append("<nz-table #m_id=\"\" [nzData]=\"m_id_wrapper.dataSource\" [nzShowPagination]=\"m_id_wrapper.showPagination\" "); result.Append("[nzTotal]=\"m_id_wrapper.totalCount\">"); result.Append("<tbody>"); result.Append("<tr *ngFor=\"let row of m_id.data\">"); result.Append("</tr>"); result.Append("</tbody>"); result.Append("</nz-table>"); result.Append("</nz-table-wrapper>"); Assert.Equal(result.ToString(), GetResult(attributes)); }
public void TestTotalFee() { //结果 var result = new String(); result.Append("<xml>"); result.Append("<total_fee>123</total_fee>"); result.Append("</xml>"); //操作 _builder.TotalFee(1.23M); //验证 Assert.Equal(result.ToString(), _builder.ToXmlNoContainsSign()); //输出结果 _output.WriteLine(_builder.ToString()); }
public void Test_2() { //结果 var result = new String(); result.AppendLine("Select [a].[Email],[a].[BoolValue],[b].[Description],[b].[IntValue] "); result.AppendLine("From [Sample] As [a] "); result.Append("Left Join [Sample2] As [b] On [a].[Email]=[b].[StringValue] And [a].[IntValue]<>[b].[IntValue]"); //执行 _builder.Select <Sample>(t => new object[] { t.Email, t.BoolValue }) .Select <Sample2>(t => new object[] { t.Description, t.IntValue }) .From <Sample>("a") .LeftJoin <Sample2>("b").On <Sample, Sample2>((l, r) => l.Email == r.StringValue && l.IntValue != r.IntValue); //验证 Assert.Equal(result.ToString(), _builder.ToSql()); }
public void TestUrl() { var attributes = new TagHelperAttributeList { { UiConst.Url, "a" } }; var result = new String(); result.Append("<nz-upload-wrapper #m_id=\"\">"); result.Append("<nz-upload (nzChange)=\"m_id.handleChange($event)\" nzAction=\"a\" [(nzFileList)]=\"m_id.files\" [nzFilter]=\"m_id.filters\">"); result.Append("<x-button text=\"上传\">"); result.Append("<ng-template>"); result.Append("<i nz-icon=\"\" nzType=\"upload\"></i>"); result.Append("</ng-template>"); result.Append("</x-button>"); result.Append("</nz-upload>"); result.Append("</nz-upload-wrapper>"); Assert.Equal(result.ToString(), GetResult(attributes)); }
public void TestNotifyUrl() { //结果 var result = new String(); result.Append("<xml>"); result.Append("<notify_url><![CDATA[a]]></notify_url>"); result.Append("</xml>"); //操作 _builder.NotifyUrl("a"); //验证 Assert.Equal(result.ToString(), _builder.ToXmlNoContainsSign()); //输出结果 _output.WriteLine(_builder.ToString()); }
public void TestTotalLimit() { var attributes = new TagHelperAttributeList { { UiConst.TotalLimit, 2 } }; var result = new String(); result.Append("<nz-upload-wrapper #m_id=\"\">"); result.Append("<nz-upload (nzChange)=\"m_id.handleChange($event)\" [(nzFileList)]=\"m_id.files\" [nzFilter]=\"m_id.filters\" "); result.Append("[nzShowButton]=\"!m_id.files||(m_id.files&&m_id.files).length<2\">"); result.Append("<x-button text=\"上传\">"); result.Append("<ng-template>"); result.Append("<i nz-icon=\"\" nzType=\"upload\"></i>"); result.Append("</ng-template>"); result.Append("</x-button>"); result.Append("</nz-upload>"); result.Append("</nz-upload-wrapper>"); Assert.Equal(result.ToString(), GetResult(attributes)); }
public void Test_6() { //结果 var result = new String(); result.AppendLine("Select [a].[Email],[a].[BoolValue] "); result.AppendLine("From [Sample] As [a] "); result.Append("Where [a].[Email]=@_p__0"); //执行 _builder.Select <Sample>(t => new object[] { t.Email, t.BoolValue }) .From <Sample>("a") .Equal <Sample>(t => t.Email, "abc"); //验证 Assert.Equal(result.ToString(), _builder.ToSql()); Assert.Single(_builder.GetParams()); Assert.Equal("abc", _builder.GetParams()["@_p__0"]); }
public void TestId() { var attributes = new TagHelperAttributeList { { UiConst.Id, "a" } }; var result = new String(); result.Append("<nz-single-upload-wrapper #a_wrapper=\"\">"); result.Append("<nz-upload #a=\"\" (nzChange)=\"a_wrapper.handleChange($event)\" [(nzFileList)]=\"a_wrapper.files\" "); result.Append("[nzFilter]=\"a_wrapper.filters\" [nzShowButton]=\"!a_wrapper.files||(a_wrapper.files&&a_wrapper.files).length<1\">"); result.Append("<x-button text=\"上传\">"); result.Append("<ng-template>"); result.Append("<i nz-icon=\"\" nzType=\"upload\"></i>"); result.Append("</ng-template>"); result.Append("</x-button>"); result.Append("</nz-upload>"); result.Append("</nz-single-upload-wrapper>"); Assert.Equal(result.ToString(), GetResult(attributes)); }
public async Task TestPayAsync_1() { //设置 Id.SetId("nonce"); Web.SetIp("ip"); _service = new WechatpayAppPayService(new WechatpayConfigProvider(new WechatpayConfig { AppId = "a", MerchantId = "m", PrivateKey = "p", NotifyUrl = "n" })); //结果 String expected = new String(); expected.Append("<xml>"); expected.Append("<appid><![CDATA[a]]></appid>"); expected.Append("<body><![CDATA[b]]></body>"); expected.Append("<mch_id><![CDATA[m]]></mch_id>"); expected.Append("<nonce_str><![CDATA[nonce]]></nonce_str>"); expected.Append("<notify_url><![CDATA[n]]></notify_url>"); expected.Append("<out_trade_no><![CDATA[o]]></out_trade_no>"); expected.Append("<sign><![CDATA[1EA6032990E252DF1E0301E20B93950A]]></sign>"); expected.Append("<sign_type><![CDATA[MD5]]></sign_type>"); expected.Append("<spbill_create_ip><![CDATA[ip]]></spbill_create_ip>"); expected.Append("<total_fee>1023</total_fee>"); expected.Append("<trade_type><![CDATA[APP]]></trade_type>"); expected.Append("</xml>"); //执行 _service.IsSend = false; var result = await _service.PayAsync(new PayParam { Subject = "b", Money = 10.23M, OrderId = "o" }); //输出 _output.WriteLine($"Parameter:{result.Parameter}"); //验证 Assert.Equal(expected.ToString(), result.Parameter); }
public void TestQueryParam() { var attributes = new TagHelperAttributeList { { UiConst.QueryParam, "a" } }; var result = new String(); result.Append("<nz-table-wrapper #m_id_wrapper=\"\" [(queryParam)]=\"a\">"); result.Append("<nz-table #m_id=\"\" (nzPageIndexChange)=\"m_id_wrapper.pageIndexChange($event)\" (nzPageSizeChange)=\"m_id_wrapper.pageSizeChange($event)\" "); result.Append("[nzData]=\"m_id_wrapper.dataSource\" [nzFrontPagination]=\"false\" [nzLoading]=\"m_id_wrapper.loading\" [nzShowPagination]=\"m_id_wrapper.showPagination\" "); result.Append("[nzShowSizeChanger]=\"true\" [nzTotal]=\"m_id_wrapper.totalCount\">"); result.Append("<tbody>"); result.Append("<tr *ngFor=\"let row of m_id.data\">"); result.Append("</tr>"); result.Append("</tbody>"); result.Append("</nz-table>"); result.Append("</nz-table-wrapper>"); Assert.Equal(result.ToString(), GetResult(attributes)); }
public void Test_22() { //结果 var result = new String(); result.AppendLine("Select [a].[Email] "); result.AppendLine("From [Sample] As [a] "); result.Append("Where [a].[Email] Like @_p__0"); //执行 _builder.Select <Sample>(t => t.Email) .From <Sample>("a") .Ends <Sample>(t => t.Email, "abc"); //验证 Assert.Equal(result.ToString(), _builder.ToSql()); Assert.Single(_builder.GetParams()); Assert.Equal("%abc", _builder.GetParams()["@_p__0"]); }
public void TestImageTypes_Jpg_Png() { var attributes = new TagHelperAttributeList { { UiConst.ImageTypes, new List <ImageType> { ImageType.Jpg, ImageType.Png } } }; var result = new String(); result.Append("<nz-upload-wrapper #m_id=\"\">"); result.Append("<nz-upload (nzChange)=\"m_id.handleChange($event)\" nzAccept=\".jpg,.jpeg,.png\" nzFileType=\"image/jpeg,image/png\" [(nzFileList)]=\"m_id.files\" [nzFilter]=\"m_id.filters\">"); result.Append("<x-button text=\"上传\">"); result.Append("<ng-template>"); result.Append("<i nz-icon=\"\" nzType=\"upload\"></i>"); result.Append("</ng-template>"); result.Append("</x-button>"); result.Append("</nz-upload>"); result.Append("</nz-upload-wrapper>"); Assert.Equal(result.ToString(), GetResult(attributes)); }
public void TestDocumentTypes_Doc() { var attributes = new TagHelperAttributeList { { UiConst.DocumentTypes, new List <DocumentType> { DocumentType.Doc } } }; var result = new String(); result.Append("<nz-upload-wrapper #m_id=\"\">"); result.Append("<nz-upload (nzChange)=\"m_id.handleChange($event)\" nzAccept=\".doc,.docx\" nzFileType=\"application/msword\" [(nzFileList)]=\"m_id.files\" [nzFilter]=\"m_id.filters\">"); result.Append("<x-button text=\"上传\">"); result.Append("<ng-template>"); result.Append("<i nz-icon=\"\" nzType=\"upload\"></i>"); result.Append("</ng-template>"); result.Append("</x-button>"); result.Append("</nz-upload>"); result.Append("</nz-upload-wrapper>"); Assert.Equal(result.ToString(), GetResult(attributes)); }
public void TestAcceptImage() { var attributes = new TagHelperAttributeList { { UiConst.AcceptImage, true } }; var result = new String(); result.Append("<nz-upload-wrapper #m_id=\"\">"); result.Append("<nz-upload "); result.Append("(nzChange)=\"m_id.handleChange($event)\" nzAccept=\".jpg,.jpeg,.png,.gif,.bmp\" "); result.Append("[(nzFileList)]=\"m_id.files\" "); result.Append("[nzFilter]=\"m_id.filters\">"); result.Append("<x-button text=\"上传\">"); result.Append("<ng-template>"); result.Append("<i nz-icon=\"\" nzType=\"upload\"></i>"); result.Append("</ng-template>"); result.Append("</x-button>"); result.Append("</nz-upload>"); result.Append("</nz-upload-wrapper>"); Assert.Equal(result.ToString(), GetResult(attributes)); }
public void TestAcceptDocument() { var attributes = new TagHelperAttributeList { { UiConst.AcceptDocument, true } }; var result = new String(); result.Append("<nz-upload-wrapper #m_id=\"\">"); result.Append("<nz-upload "); result.Append("(nzChange)=\"m_id.handleChange($event)\" nzAccept=\".xls,.xlsx,.doc,.docx,.pdf,.txt\" "); result.Append("nzFileType=\"application/x-xls,application/msword,application/pdf,text/plain\" [(nzFileList)]=\"m_id.files\" "); result.Append("[nzFilter]=\"m_id.filters\">"); result.Append("<x-button text=\"上传\">"); result.Append("<ng-template>"); result.Append("<i nz-icon=\"\" nzType=\"upload\"></i>"); result.Append("</ng-template>"); result.Append("</x-button>"); result.Append("</nz-upload>"); result.Append("</nz-upload-wrapper>"); Assert.Equal(result.ToString(), GetResult(attributes)); }