lyfz_repos/铂金版源码/LYFZ.WeixinServers/DZKJ/DZKJTaskStatisticsView.aspx.cs

using LYFZ.WeixinServiceDate.DAL;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using LYFZ.WeixinServers.WeiXinAPP;
namespace LYFZ.WeixinServers.DZKJ
{
    public partial class DZKJTaskStatisticsView : System.Web.UI.Page
    {
        public System.Text.StringBuilder TaskStatisticsViewListHtmlTb = new System.Text.StringBuilder();
        public string PagingInfoHtml = "";

        string Keyword = "";
        int viewtype = -1;
       public string TaskStatistics = "";
        DateTime ExecDate = DateTime.Now;
        DAL_DZKJ_TaskExecutionStatistics dzkjTaskDal = new DAL_DZKJ_TaskExecutionStatistics();
        protected void Page_Load(object sender, EventArgs e)
        {
            CommonHandler.CheckLoginJump(this);
           
            if (Request.QueryString["Keyword"] != null)
            {
                Keyword = Request.QueryString["Keyword"].ToString();
            }
            if (Request.QueryString["viewtype"] != null)
            {
                try
                {
                    viewtype = Convert.ToInt32(Request.QueryString["viewtype"].ToString());
                }
                catch { }
            }
            switch (viewtype)
            {
                case 0: TaskStatistics = "爆客系统使用分析   " + ExecDate.ToString("yyyy年") + "  使用情况统计"; break;
                case 1: TaskStatistics = "爆客系统使用分析   " + ExecDate.ToString("yyyy年MM月") + "  使用情况统计"; break;
                case 2: TaskStatistics = "爆客系统使用分析   " + ExecDate.ToString("yyyy年MM月dd日") + "  使用情况统计"; break;
            }
            try
            {
                if (Request.QueryString["ExecDate"] != null)
                {
                    ExecDate = Convert.ToDateTime(Request.QueryString["ExecDate"].ToString());
                }
            }
            catch { }

            System.Data.DataTable tb = dzkjTaskDal.GetTaskExecutionStatisticDataTable(viewtype, ExecDate, Keyword);
            if (tb != null)
            {
                if (tb.Rows.Count > 0)
                {
                    float maxExecutionCount = 0;
                    if (tb.Rows[0]["ExecutionCount"] != null && !string.IsNullOrEmpty(tb.Rows[0]["ExecutionCount"].ToString()))
                    {
                        maxExecutionCount = Convert.ToInt32(tb.Rows[0]["ExecutionCount"].ToString());
                    }
                    if (maxExecutionCount > 10000)
                    {
                        maxExecutionCount = maxExecutionCount + 1000;
                    }
                    else if (maxExecutionCount > 1000 && maxExecutionCount <= 10000)
                    {
                        maxExecutionCount = maxExecutionCount + 100;
                    }
                    else if (maxExecutionCount > 100 && maxExecutionCount <= 1000)
                    {
                        maxExecutionCount = maxExecutionCount + 10;
                    }
                    else if (maxExecutionCount <= 100)
                    {
                        maxExecutionCount = 100;
                    }

                    foreach (DataRow row in tb.Rows)
                    {
                       float ExecutionCount = 0;
                       if (row["ExecutionCount"] != null && !string.IsNullOrEmpty(row["ExecutionCount"].ToString()))
                       {
                           ExecutionCount = Convert.ToInt32(row["ExecutionCount"].ToString());
                       }
                       float percentage = Convert.ToSingle((ExecutionCount / maxExecutionCount) * 100);
                       /* if (ExecutionCount > 0 && percentage <= 0)
                        {
                            percentage = 1;
                        }*/
                        string ManagerProgramVersion="M_V1.8.3.1";
                        string SmallEifVersion="S_V1.3.3";
                        if (row["ManagerProgramVersion"] != null && row["ManagerProgramVersion"].ToString().Trim().Length>1)
                        {
                           ManagerProgramVersion="M_V"+row["ManagerProgramVersion"].ToString();
                        }
                        if (row["SmallEifVersion"] != null && row["SmallEifVersion"].ToString().Trim().Length > 1)
                        {
                           SmallEifVersion="S_"+row["SmallEifVersion"].ToString();
                        }
                        TaskStatisticsViewListHtmlTb.Append("<tr>"
                                             + " <td>" + row["CompanyName"].ToString() + "</td>"
                                             + " <td>" + row["Account"].ToString() + "</td>"
                                             + " <td><a  href=\"/DZKJ/DZKJTaskOneView.aspx?viewtype=" + viewtype + "&ExecDate=" + ExecDate.ToString("yyyy-MM-dd") + "&Account=" + row["Account"].ToString() + "\">爆客微信营销系统<br />" + ManagerProgramVersion + "/"+SmallEifVersion.ToUpper()+"</a></td>"
                                             + " <td><a  href=\"/DZKJ/DZKJTaskOneView.aspx?viewtype=" + viewtype + "&ExecDate=" + ExecDate.ToString("yyyy-MM-dd") + "&Account=" + row["Account"].ToString() + "\">" + ExecutionCount.ToString() + "</a></td>"
                                             + " <td><div style=\"width:100%;height:16px; background-color:rgba(189, 246, 189, 0.1)\"><div style=\"width:" + percentage.ToString("n6") + "%;height:16px; background-color:green;\"></div></div></td>"
                                             + " </tr>");
                    }
                }
            }
            else {
                TaskStatisticsViewListHtmlTb.Append("<tr>"
                                            + " <td>数据查询失败</td>"
                                            + " <td></td>"
                                            + " <td></td>"
                                            + " <td></td>"
                                            + " <td></td>"
                                            + " </tr>");
            }

        }


    }
}