dapper读取数据库后获取DataTable

最新推荐文章于 2024-08-07 02:15:43 发布

kingwebo'sZone

最新推荐文章于 2024-08-07 02:15:43 发布

阅读量2.3k

点赞数 2

分类专栏：关于程序 sql

本文链接：https://blog.csdn.net/weixin_40029679/article/details/111246169

版权

关于程序同时被 2 个专栏收录

422 篇文章 12 订阅

订阅专栏

sql

41 篇文章 1 订阅

订阅专栏

 string Sql = @"declare @AllCount int;---总人数
select  @AllCount =  COUNT(*) from HumanMainInfo where  DATALENGTH(LizhiDate) <1
select  Bumen as '部门' , COUNT(*) as '人数',CAST(COUNT(*) as decimal(10,2))/CAST(@AllCount as decimal(10,2))*100 as '百分比'  from HumanMainInfo  group by Bumen";
            DataTable dt = new DataTable("Bumen");
            using (IDbConnection con = DapperConnFactory.Instance.GetOpenConn())//获取con 执行Dapper查询
            {
                var reader = con.ExecuteReader(Sql);
                dt.Load(reader);
                return dt;
            }