|
Server : Microsoft-IIS/10.0 System : Windows NT EBS-6136 10.0 build 17763 (Windows Server 2016) i586 User : jxgj ( 0) PHP Version : 7.0.33 Disable Function : passthru,exec,system,shell_exec,proc_open,popen,pcntl_exec,socket_bind,stream_socket_server Directory : D:/tmp_aspnet/root/dc15253c/377bd30d/ |
?#pragma checksum "D:\wwwroot\jmxbaogao\wwwroot\Counter\NewUsersCounter.ashx" "{406ea660-64cf-4c82-b6f0-42d48172a799}" "22090E007552F67E5E2C354787DD19E6"
#line 1 "D:\wwwroot\jmxbaogao\wwwroot\Counter\NewUsersCounter.ashx"
/****************************************
* 版权所有：南昌金启软件有限公司
* 网 址：www.21it.com
****************************************/
using System;
using System.Data;
using System.Data.SqlClient;
using System.Net;
using System.Reflection;
using System.Text.RegularExpressions;
using System.Threading;
using System.Web;
using System.Web.Script.Serialization;
using Com.Huji.DataBase;
using Com.Huji.DataBll;
using Com.Huji.DataModel;
using Com.Huji.DataTools;
using Com.Huji.Web.Pager;
namespace Com.Huji.Web.Counter
{
public class NewUsersCounter : BaseHandler
{
public override void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
if (!ProcessRequestError()) return;
context.Response.Write("document.write('<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\">');");
context.Response.Write("document.write('<tr><td></td><td>投稿数</td><td>用稿数</td></tr>');");
try
{
using (DatabaseForSqlServer db = new DatabaseForSqlServer())
{
SqlDataReader dr;
string sql = "select REPLACE(u.cname,'治理员','') cname, case when t.counts is null then 0 else t.counts end counts ,case when t.sumstatus is null then 0 else t.sumstatus end sumstatus from " +
" dbo.jinqi_sys_users u inner join dbo.jinqi_sys_user_model m on (u.user_id=m.user_id and m.role_id_s=3) " +
" left outer join (select t.user_id,COUNT(*) counts,sum(t.status) sumstatus from dbo.jinqi_new_article_view t where t.flag=1 and t.language_id=1 group by t.user_id) t on (u.user_id=t.user_id ) ";
db.RunSql(sql, out dr);
//增长数据
while (dr.Read())
{
context.Response.Write("document.write('<tr><td>" + dr["cname"] + "</td><td>" + dr["counts"] + "</td><td>" + dr["sumstatus"] + "</td></tr>');");
}
}
}
catch (Exception ex)
{
context.Response.Write("document.write('<tr><td>一中队</td><td>100</td><td>100</td></tr>');");
context.Response.Write("document.write('<tr><td>二中队</td><td>100</td><td>100</td></tr>');");
context.Response.Write("document.write('<tr><td>三中队</td><td>100</td><td>100</td></tr>');");
context.Response.Write("document.write('<tr><td>四中队</td><td>100</td><td>100</td></tr>');");
}
context.Response.Write("document.write('</table>');");
}
}
}
#line default
#line hidden