一个临时表能不能拿出来做为实体类......
时间:2011-02-24
来源:互联网
在后台建立一个临时表,下面是具体代码:
public static sumCount countTax()
{
string sql=(
create table sumCount (Cont_count int ,ContSumMoney money,Cont_Tax_freeCount int ,FreeSum money,Decals money,Payment money,Consolidated money,Withholding money )
insert into
sumCount ( Cont_count,ContSumMoney,Cont_Tax_freeCount,FreeSum,Decals,Payment,Consolidated,Withholding)
select Count(*)as Cont_count ,
sum(Cont_Money) as ContSumMoney ,
count(Cont_Tax_freeNo) as Cont_Tax_freeCount,
sum(Cont_Tax_freeMoney) as FreeSum ,
sum(case when setTax_ID=1 then Cont_tax_sumMoney else 0 end ) as Decals ,
sum(case when setTax_ID=2 then Cont_tax_sumMoney else 0 end ) as Payment,
sum(case when setTax_ID=3 then Cont_tax_sumMoney else 0 end ) as Consolidated,
sum(case when setTax_ID=4 then Cont_tax_sumMoney else 0 end ) as Withholding
from OA_Doc_Cont
where Cont_tax_StateID=3
and left(CONVERT(varchar(8), Sign_Time, 112), 4)= '2004 '
and CONVERT(varchar(100), Sign_Time, 10) between '07-01 ' and '12-31 ' );
........
}
想把这个sumCount 表作为一个实体类,然后去调用里面的字段,怎么做啊 求各位大侠们帮忙,谢谢
public static sumCount countTax()
{
string sql=(
create table sumCount (Cont_count int ,ContSumMoney money,Cont_Tax_freeCount int ,FreeSum money,Decals money,Payment money,Consolidated money,Withholding money )
insert into
sumCount ( Cont_count,ContSumMoney,Cont_Tax_freeCount,FreeSum,Decals,Payment,Consolidated,Withholding)
select Count(*)as Cont_count ,
sum(Cont_Money) as ContSumMoney ,
count(Cont_Tax_freeNo) as Cont_Tax_freeCount,
sum(Cont_Tax_freeMoney) as FreeSum ,
sum(case when setTax_ID=1 then Cont_tax_sumMoney else 0 end ) as Decals ,
sum(case when setTax_ID=2 then Cont_tax_sumMoney else 0 end ) as Payment,
sum(case when setTax_ID=3 then Cont_tax_sumMoney else 0 end ) as Consolidated,
sum(case when setTax_ID=4 then Cont_tax_sumMoney else 0 end ) as Withholding
from OA_Doc_Cont
where Cont_tax_StateID=3
and left(CONVERT(varchar(8), Sign_Time, 112), 4)= '2004 '
and CONVERT(varchar(100), Sign_Time, 10) between '07-01 ' and '12-31 ' );
........
}
想把这个sumCount 表作为一个实体类,然后去调用里面的字段,怎么做啊 求各位大侠们帮忙,谢谢
作者: jlimin 发布时间: 2011-02-24
yeah, you are right
**********************************************
欢迎使用 CSDN 小秘书
http://blog.csdn.net/whowhen21
**********************************************
欢迎使用 CSDN 小秘书
http://blog.csdn.net/whowhen21
**********************************************
作者: yuying100 发布时间: 2011-03-23
自己 封装字段啊 MODEL
你杂学的 。net
你杂学的 。net
作者: fengyarongaa 发布时间: 2011-03-23
反正要变成table读到内存来处理的 和是不是临时表 没关系了
作者: KK3K2005 发布时间: 2011-03-23
相关阅读 更多
热门阅读
-
office 2019专业增强版最新2021版激活秘钥/序列号/激活码推荐 附激活工具
阅读:74
-
如何安装mysql8.0
阅读:31
-
Word快速设置标题样式步骤详解
阅读:28
-
20+道必知必会的Vue面试题(附答案解析)
阅读:37
-
HTML如何制作表单
阅读:22
-
百词斩可以改天数吗?当然可以,4个步骤轻松修改天数!
阅读:31
-
ET文件格式和XLS格式文件之间如何转化?
阅读:24
-
react和vue的区别及优缺点是什么
阅读:121
-
支付宝人脸识别如何关闭?
阅读:21
-
腾讯微云怎么修改照片或视频备份路径?
阅读:28