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));
}
