TrainSignManage/services/dashBoard.ashx.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Script.Serialization;
using Common;
using TindWit.Common;
using System.Text;
using TindWit.DBUtility;
using System.Data;

namespace witAdmin.services
{


    public class dashBoard : IHttpHandler
    {


        public void ProcessRequest(HttpContext context)
        {

            string callback = Units.GetStringQS("callback");
            string result = "";
            switch (Units.GetStringQS("type"))
            {
                case "GetRpCommon":
                    string activityMainCount = "0";
                    string UserCount = "0";
                    string MessageCount = "0";
                    string PurchaseListCount = "0";

                    activityMainCount = DbHelperSQL.GetSingle("SELECT count(*) FROM [dbo].[H_activityMain]") + "";
                    UserCount = DbHelperSQL.GetSingle("SELECT count(*) FROM [dbo].[H_userMain]") + "";
                    MessageCount = DbHelperSQL.GetSingle("SELECT count(*) FROM [dbo].[H_messageMain] ") + "";
                    PurchaseListCount = DbHelperSQL.GetSingle("SELECT count(*) FROM [dbo].[H_userPurchaseList] where SignUpStatus>0") + "";
                    result = new JavaScriptSerializer().Serialize(new { activityMainCount = activityMainCount, UserCount = UserCount, MessageCount = MessageCount, PurchaseListCount = PurchaseListCount });

                    break;

                case "GetRpCommonBAR":

                    // { y: '培训班1', a: 100, b: 90 },{ y: '培训班1', a: 100, b: 90 }

                    DataSet ds = DbHelperSQL.Query("SELECT top 5 activityID,activityTitle  FROM [dbo].[H_activityMain] order by createTime desc");

                    List<Maticsoft.Model.H_activityMain> listBAR = TindWit.Common.TBToList<Maticsoft.Model.H_activityMain>.ConvertToList(ds.Tables[0]).ToList();

                    List<tbGetRpCommonBARData> listJson = new List<tbGetRpCommonBARData>();
                    foreach (var item in listBAR)
                    {
                        tbGetRpCommonBARData m = new tbGetRpCommonBARData();
                        m.name = item.activityTitle;
                        m.a = DbHelperSQL.GetSingle("SELECT count(*) FROM [dbo].H_viewCount where viewProductID='" + item.activityID + "' AND  viewProduct='activity'") + "";
                        m.b = DbHelperSQL.GetSingle("SELECT count(*) FROM [dbo].H_userPurchaseList where SignUpStatus>0 AND  purchaseProductID='" + item.activityID + "'") + "";
                        listJson.Add(m);
                    }
                    result = new JavaScriptSerializer().Serialize(new { listJson = listJson });
                 
                    break;