10 2017 档案

摘要:源码: public async Task<ListApiResponse<UploadFileResponse>> uploadfile() { ListApiResponse<UploadFileResponse> info = new ListApiResponse<UploadFileRes 阅读全文
posted @ 2017-10-31 13:35 蜗牛行 阅读(422) 评论(0) 推荐(0)
摘要:统计不同身份角色,注册情况,列横向统计,列纵向统计两种; 一、横向统计 select count(*) as 总注册用户量, sum(case TypeId when 2 then 1 else 0 end) as 生产企业, sum(case TypeId when 3 then 1 else 0 阅读全文
posted @ 2017-10-26 13:15 蜗牛行 阅读(422) 评论(0) 推荐(0)