TResult 数据库结果类型

构造方法：

  1. declare @TResult TResult='';  --空对象
属性/方法 类型 说明/调用示例
CreateModel function(name,TSqls) declare @TSqls TSqls=’select id,name from table where id=@id’
set @TSqls= @TSqls.AppendParams(1);
@TResult.CreateModel(‘model’,@TSqls)
CreateArray function(name,TSqls) @TResult.CreateModel(‘array’,’select top 10 id from table’)
CreateList function(name,TSqls) @TResult.CreateList(‘list’,’select top 10 id,name from table’)
CreateOperate function(name,TSqls) @TResult.CreateOperate(‘operate’,0,’操作成功’)
CreatePager function(string name, TSqls data_sql, TSqls total_sql, int page_size) @TResult.CreatePager(‘pager’,’select top 10 id from table’,’select count(1) from table’,20);
CreateJson function(name,TJson) declare @TJson TJson=’{“name”:”tresult”}’
@TResult.CreateModel(‘model’,@TJson )
CreateResult function(name,TResult) declare @TResult2 TResult=’’
set @TResult2=@TResult2.CreateModel(‘array’,’select top 10 id from table’)
@TResult.CreateResult(‘result’,@TResult2 )
SetValue function(name,object) 同TJson SetValue一致
SetJson function(name,TJson) 同TJson SetJson一致
Sqls function @TResult.Sqls() 获取TResult中所有脚本
ToFormatValue function @TResult.ToFormatValue() 预览TResult结构化格式
ToString() function @TResult.ToString() —获取完整序列化数据

代码演示：

----------声明--------------------------
declare @TResultTResult TResult='';
----------设置值-----------------------
---创建一个员工实体类型
set @TResultTResult=@TResult.CreateModel('model','select id,name,sex from e_Employee where id=1');  
---创建一个id数组
set @TResultTResult=@TResult.CreateArray('ids','select top 10 id from e_Employee ');  
---创建一个实体数组
set @TResultTResult=@TResult.CreateList('list','select top 10 id,name,sex from e_Employee '); 
---创建一个操作消息体
set @TResultTResult=@TResult.CreateOperate('operate',0,'操作成功');
---创建一个操作消息体
set @TResultTResult=@TResult.CreatePager('pager','分页数据脚本','总数脚本','每条多少条');
--创建一个自定义的json数据
set @TResultTResult=@TResult.CreateJson('json',TJson类型);
--创建一个TResult类型
set @TResult=@TResult.CreateResult('result',TResult类型);
--------------应用于结果展示----
------------单个对象-----------------
declare @TResult TResult=''
declare @TSqls TSqls='';
set @TSqls=@TSqls.AppendSql('select id,name,sex from e_Employee where id=@id').AppendParams(1);
set @TResult=@TResult.CreateModel('model',@TSqls);
select dbo.TResultToJson(@TResult);
结果：{id:1,name:"ted",sex:"男"}
-------------多个对象--------
declare @TResult TResult=''
set @TResult=@TResult.CreateModel('model','select id,name,sex from e_Employee where id=1');
set @TResult=@TResult.CreateArray('ids','select top 10 id from e_Employee ');  
结果：{model:{id:1,name:"ted",sex:"男"},ids:[1,2,3,4,5,6,7,8]}
------------TResult嵌套-------
declare @TResult TResult=''
set @TResult=@TResult.CreateModel('model','select id,name,sex from e_Employee where id=1');
set @TResult=@TResult.CreateArray('ids','select top 10 id from e_Employee '); 

set @TResult=@TResult.CreateArray('ids','select top 10 id from e_Employee '); 

结果：{model:{id:1,name:"ted",sex:"男"},ids:[1,2,3,4,5,6,7,8]}