LYGJJ_4.0/Web/Report/TotalCount_R...

using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

public partial class Report_TotalCount_Report : System.Web.UI.Page
{
    XYFDRQ.BLL.T_Report bll_T_Report = new XYFDRQ.BLL.T_Report();
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!this.IsPostBack)
        {
            txtBeginDate.Value = DateTime.Now.ToString("yyyy-MM-01");
            txtEndDate.Value = DateTime.Now.ToString("yyyy-MM-dd");
        }
        AjaxPro.Utility.RegisterTypeForAjax(typeof(Report_TotalCount_Report));
    }
    protected void btnExtWord_Click(object sender, EventArgs e)
    {
        HttpResponse resp = Page.Response;
        resp.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
        //下面这行很重要， attachment 参数表示作为附件下载，您可以改成 online在线打开
        //filename=FileFlow.xls 指定输出文件的名称，注意其扩展名和指定文件类型相符，可以为：.doc 　　 .xls 　　 .txt 　　.htm
        resp.AppendHeader("Content-Disposition", "attachment;filename=ZXHWFX" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".xls");
        //Response.ContentType指定文件类型 可以为application/ms-excel、application/ms-word、application/ms-txt、application/ms-html 或其他浏览器可直接支持文档
        resp.ContentType = "application/ms-excel";

        //向http输出流中写入取得的数据信息
        resp.Write(this.txtHideItems.Value);
        //处理行数据


        resp.End();
    }

    [AjaxPro.AjaxMethod()]
    public string GetReportTable(AjaxPro.JavaScriptArray searchItems)
    {
        StringBuilder html = new StringBuilder();
        DataTable dt = new DataTable();
        string[] _operations = GetSearchItems(searchItems);
        html.Append("<h1 style='font-size: 18px;font-weight: bold;color: #333333;text-align:center;width:100%;'><b>话务量统计表</b></h1>");
        html.Append("<div style='width:100%; text-align:right; height:25px;'>统计截止日期： " + _operations[0] + "—" + _operations[1] + " &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</div>");
        html.Append("<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\" >");
        try
        {
            #region 标题第一行
            html.Append("<tr style=\"text-align: center;\"><td class=\"formtabletitle\" style=\"height: 35px;background-color: #D5EDFE;border:1px solid #CCCCCC;padding: 3px 3px 3px 3px;text-align:center;\">小时/时间</td>");
            html.Append("<td class=\"formtabletitle1\"style=\"height: 25px;background-color: #D5EDFE;border-left: 0px solid #FFFFFF;border-right: 1px solid #CCCCCC;border-top: 1px solid #CCCCCC;border-bottom: 1px solid #CCCCCC;padding: 3px 3px 3px 3px;text-align:center;\">00时-01时 呼出量</td>");
            html.Append("<td class=\"formtabletitle1\"style=\"height: 25px;background-color: #D5EDFE;border-left: 0px solid #FFFFFF;border-right: 1px solid #CCCCCC;border-top: 1px solid #CCCCCC;border-bottom: 1px solid #CCCCCC;padding: 3px 3px 3px 3px;text-align:center;\">00时-01时 呼入量</td>");
            html.Append("<td class=\"formtabletitle1\"style=\"height: 25px;background-color: #D5EDFE;border-left: 0px solid #FFFFFF;border-right: 1px solid #CCCCCC;border-top: 1px solid #CCCCCC;border-bottom: 1px solid #CCCCCC;padding: 3px 3px 3px 3px;text-align:center;\">01时-02时 呼出量</td>");
            html.Append("<td class=\"formtabletitle1\"style=\"height: 25px;background-color: #D5EDFE;border-left: 0px solid #FFFFFF;border-right: 1px solid #CCCCCC;border-top: 1px solid #CCCCCC;border-bottom: 1px solid #CCCCCC;padding: 3px 3px 3px 3px;text-align:center;\">01时-02时 呼入量</td>");
            html.Append("<td class=\"formtabletitle1\"style=\"height: 25px;background-color: #D5EDFE;border-left: 0px solid #FFFFFF;border-right: 1px solid #CCCCCC;border-top: 1px solid #CCCCCC;border-bottom: 1px solid #CCCCCC;padding: 3px 3px 3px 3px;text-align:center;\">02时-03时 呼出量</td>");
            html.Append("<td class=\"formtabletitle1\"style=\"height: 25px;background-color: #D5EDFE;border-left: 0px solid #FFFFFF;border-right: 1px solid #CCCCCC;border-top: 1px solid #CCCCCC;border-bottom: 1px solid #CCCCCC;padding: 3px 3px 3px 3px;text-align:center;\">02时-03时 呼入量</td>");
            html.Append("<td class=\"formtabletitle1\"style=\"height: 25px;background-color: #D5EDFE;border-left: 0px solid #FFFFFF;border-right: 1px solid #CCCCCC;border-top: 1px solid #CCCCCC;border-bottom: 1px solid #CCCCCC;padding: 3px 3px 3px 3px;text-align:center;\">03时-04时 呼出量</td>");
            html.Append("<td class=\"formtabletitle1\"style=\"height: 25px;background-color: #D5EDFE;border-left: 0px solid #FFFFFF;border-right: 1px solid #CCCCCC;border-top: 1px solid #CCCCCC;border-bottom: 1px solid #CCCCCC;padding: 3px 3px 3px 3px;text-align:center;\">03时-04时 呼入量</td>");
            html.Append("<td class=\"formtabletitle1\"style=\"height: 25px;background-color: #D5EDFE;border-left: 0px solid #FFFFFF;border-right: 1px solid #CCCCCC;border-top: 1px solid #CCCCCC;border-bottom: 1px solid #CCCCCC;padding: 3px 3px 3px 3px;text-align:center;\">04时-05时 呼出量</td>");
            html.Append("<td class=\"formtabletitle1\"style=\"height: 25px;background-color: #D5EDFE;border-left: 0px solid #FFFFFF;border-right: 1px solid #CCCCCC;border-top: 1px solid #CCCCCC;border-bottom: 1px solid #CCCCCC;padding: 3px 3px 3px 3px;text-align:center;\">04时-05时 呼入量</td>");
            html.Append("<td class=\"formtabletitle1\"style=\"height: 25px;background-color: #D5EDFE;border-left: 0px solid #FFFFFF;border-right: 1px solid #CCCCCC;border-top: 1px solid #CCCCCC;border-bottom: 1px solid #CCCCCC;padding: 3px 3px 3px 3px;text-align:center;\">05时-06时 呼出量</td>");
            html.Append("<td class=\"formtabletitle1\"style=\"height: 25px;background-color: #D5EDFE;border-left: 0px solid #FFFFFF;border-right: 1px solid #CCCCCC;border-top: 1px solid #CCCCCC;border-bottom: 1px solid #CCCCCC;padding: 3px 3px 3px 3px;text-align:center;\">05时-05时 呼入量</td>");
            html.Append("<td class=\"formtabletitle1\"style=\"height: 25px;background-color: #D5EDFE;border-left: 0px solid #FFFFFF;border-right: 1px solid #CCCCCC;border-top: 1px solid #CCCCCC;border-bottom: 1px solid #CCCCCC;padding: 3px 3px 3px 3px;text-align:center;\">06时-07时 呼出量</td>");
            html.Append("<td class=\"formtabletitle1\"style=\"height: 25px;background-color: #D5EDFE;border-left: 0px solid #FFFFFF;border-right: 1px solid #CCCCCC;border-top: 1px solid #CCCCCC;border-bottom: 1px solid #CCCCCC;padding: 3px 3px 3px 3px;text-align:center;\">06时-07时 呼入量</td>");
            html.Append("<td class=\"formtabletitle1\"style=\"height: 25px;background-color: #D5EDFE;border-left: 0px solid #FFFFFF;border-right: 1px solid #CCCCCC;border-top: 1px solid #CCCCCC;border-bottom: 1px solid #CCCCCC;padding: 3px 3px 3px 3px;text-align:center;\">07时-08时 呼出量</td>");
            html.Append("<td class=\"formtabletitle1\"style=\"height: 25px;background-color: #D5EDFE;border-left: 0px solid #FFFFFF;border-right: 1px solid #CCCCCC;border-top: 1px solid #CCCCCC;border-bottom: 1px solid #CCCCCC;padding: 3px 3px 3px 3px;text-align:center;\">07时-08时 呼入量</td>");
            html.Append("<td class=\"formtabletitle1\"style=\"height: 25px;background-color: #D5EDFE;border-left: 0px solid #FFFFFF;border-right: 1px solid #CCCCCC;border-top: 1px solid #CCCCCC;border-bottom: 1px solid #CCCCCC;padding: 3px 3px 3px 3px;text-align:center;\">08时-09时 呼出量</td>");
            html.Append("<td class=\"formtabletitle1\"style=\"height: 25px;background-color: #D5EDFE;border-left: 0px solid #FFFFFF;border-right: 1px solid #CCCCCC;border-top: 1px solid #CCCCCC;border-bottom: 1px solid #CCCCCC;padding: 3px 3px 3px 3px;text-align:center;\">08时-09时 呼入量</td>");
            html.Append("<td class=\"formtabletitle1\"style=\"height: 25px;background-color: #D5EDFE;border-left: 0px solid #FFFFFF;border-right: 1px solid #CCCCCC;border-top: 1px solid #CCCCCC;border-bottom: 1px solid #CCCCCC;padding: 3px 3px 3px 3px;text-align:center;\">09时-10时 呼出量</td>");
            html.Append("<td class=\"formtabletitle1\"style=\"height: 25px;background-color: #D5EDFE;border-left: 0px solid #FFFFFF;border-right: 1px solid #CCCCCC;border-top: 1px solid #CCCCCC;border-bottom: 1px solid #CCCCCC;padding: 3px 3px 3px 3px;text-align:center;\">09时-10时 呼入量</td>");
            html.Append("<td class=\"formtabletitle1\"style=\"height: 25px;background-color: #D5EDFE;border-left: 0px solid #FFFFFF;border-right: 1px solid #CCCCCC;border-top: 1px solid #CCCCCC;border-bottom: 1px solid #CCCCCC;padding: 3px 3px 3px 3px;text-align:center;\">10时-11时 呼出量</td>");
            html.Append("<td class=\"formtabletitle1\"style=\"height: 25px;background-color: #D5EDFE;border-left: 0px solid #FFFFFF;border-right: 1px solid #CCCCCC;border-top: 1px solid #CCCCCC;border-bottom: 1px solid #CCCCCC;padding: 3px 3px 3px 3px;text-align:center;\">10时-11时 呼入量</td>");
            html.Append("<td class=\"formtabletitle1\"style=\"height: 25px;background-color: #D5EDFE;border-left: 0px solid #FFFFFF;border-right: 1px solid #CCCCCC;border-top: 1px solid #CCCCCC;border-bottom: 1px solid #CCCCCC;padding: 3px 3px 3px 3px;text-align:center;\">11时-12时 呼出量</td>");
            html.Append("<td class=\"formtabletitle1\"style=\"height: 25px;background-color: #D5EDFE;border-left: 0px solid #FFFFFF;border-right: 1px solid #CCCCCC;border-top: 1px solid #CCCCCC;border-bottom: 1px solid #CCCCCC;padding: 3px 3px 3px 3px;text-align:center;\">11时-12时 呼入量</td>");
            html.Append("<td class=\"formtabletitle1\"style=\"height: 25px;background-color: #D5EDFE;border-left: 0px solid #FFFFFF;border-right: 1px solid #CCCCCC;border-top: 1px solid #CCCCCC;border-bottom: 1px solid #CCCCCC;padding: 3px 3px 3px 3px;text-align:center;\">12时-13时 呼出量</td>");
            html.Append("<td class=\"formtabletitle1\"style=\"height: 25px;background-color: #D5EDFE;border-left: 0px solid #FFFFFF;border-right: 1px solid #CCCCCC;border-top: 1px solid #CCCCCC;border-bottom: 1px solid #CCCCCC;padding: 3px 3px 3px 3px;text-align:center;\">12时-13时 呼入量</td>");
            html.Append("<td class=\"formtabletitle1\"style=\"height: 25px;background-color: #D5EDFE;border-left: 0px solid #FFFFFF;border-right: 1px solid #CCCCCC;border-top: 1px solid #CCCCCC;border-bottom: 1px solid #CCCCCC;padding: 3px 3px 3px 3px;text-align:center;\">13时-14时 呼出量</td>");
            html.Append("<td class=\"formtabletitle1\"style=\"height: 25px;background-color: #D5EDFE;border-left: 0px solid #FFFFFF;border-right: 1px solid #CCCCCC;border-top: 1px solid #CCCCCC;border-bottom: 1px solid #CCCCCC;padding: 3px 3px 3px 3px;text-align:center;\">13时-14时 呼入量</td>");
            html.Append("<td class=\"formtabletitle1\"style=\"height: 25px;background-color: #D5EDFE;border-left: 0px solid #FFFFFF;border-right: 1px solid #CCCCCC;border-top: 1px solid #CCCCCC;border-bottom: 1px solid #CCCCCC;padding: 3px 3px 3px 3px;text-align:center;\">14时-15时 呼出量</td>");
            html.Append("<td class=\"formtabletitle1\"style=\"height: 25px;background-color: #D5EDFE;border-left: 0px solid #FFFFFF;border-right: 1px solid #CCCCCC;border-top: 1px solid #CCCCCC;border-bottom: 1px solid #CCCCCC;padding: 3px 3px 3px 3px;text-align:center;\">14时-15时 呼入量</td>");
            html.Append("<td class=\"formtabletitle1\"style=\"height: 25px;background-color: #D5EDFE;border-left: 0px solid #FFFFFF;border-right: 1px solid #CCCCCC;border-top: 1px solid #CCCCCC;border-bottom: 1px solid #CCCCCC;padding: 3px 3px 3px 3px;text-align:center;\">15时-16时 呼出量</td>");
            html.Append("<td class=\"formtabletitle1\"style=\"height: 25px;background-color: #D5EDFE;border-left: 0px solid #FFFFFF;border-right: 1px solid #CCCCCC;border-top: 1px solid #CCCCCC;border-bottom: 1px solid #CCCCCC;padding: 3px 3px 3px 3px;text-align:center;\">15时-16时 呼入量</td>");
            html.Append("<td class=\"formtabletitle1\"style=\"height: 25px;background-color: #D5EDFE;border-left: 0px solid #FFFFFF;border-right: 1px solid #CCCCCC;border-top: 1px solid #CCCCCC;border-bottom: 1px solid #CCCCCC;padding: 3px 3px 3px 3px;text-align:center;\">16时-17时 呼出量</td>");
            html.Append("<td class=\"formtabletitle1\"style=\"height: 25px;background-color: #D5EDFE;border-left: 0px solid #FFFFFF;border-right: 1px solid #CCCCCC;border-top: 1px solid #CCCCCC;border-bottom: 1px solid #CCCCCC;padding: 3px 3px 3px 3px;text-align:center;\">16时-17时 呼入量</td>");
            html.Append("<td class=\"formtabletitle1\"style=\"height: 25px;background-color: #D5EDFE;border-left: 0px solid #FFFFFF;border-right: 1px solid #CCCCCC;border-top: 1px solid #CCCCCC;border-bottom: 1px solid #CCCCCC;padding: 3px 3px 3px 3px;text-align:center;\">17时-18时 呼出量</td>");
            html.Append("<td class=\"formtabletitle1\"style=\"height: 25px;background-color: #D5EDFE;border-left: 0px solid #FFFFFF;border-right: 1px solid #CCCCCC;border-top: 1px solid #CCCCCC;border-bottom: 1px solid #CCCCCC;padding: 3px 3px 3px 3px;text-align:center;\">17时-18时 呼入量</td>");
            html.Append("<td class=\"formtabletitle1\"style=\"height: 25px;background-color: #D5EDFE;border-left: 0px solid #FFFFFF;border-right: 1px solid #CCCCCC;border-top: 1px solid #CCCCCC;border-bottom: 1px solid #CCCCCC;padding: 3px 3px 3px 3px;text-align:center;\">18时-19时 呼出量</td>");
            html.Append("<td class=\"formtabletitle1\"style=\"height: 25px;background-color: #D5EDFE;border-left: 0px solid #FFFFFF;border-right: 1px solid #CCCCCC;border-top: 1px solid #CCCCCC;border-bottom: 1px solid #CCCCCC;padding: 3px 3px 3px 3px;text-align:center;\">18时-19时 呼入量</td>");
            html.Append("<td class=\"formtabletitle1\"style=\"height: 25px;background-color: #D5EDFE;border-left: 0px solid #FFFFFF;border-right: 1px solid #CCCCCC;border-top: 1px solid #CCCCCC;border-bottom: 1px solid #CCCCCC;padding: 3px 3px 3px 3px;text-align:center;\">19时-20时 呼出量</td>");
            html.Append("<td class=\"formtabletitle1\"style=\"height: 25px;background-color: #D5EDFE;border-left: 0px solid #FFFFFF;border-right: 1px solid #CCCCCC;border-top: 1px solid #CCCCCC;border-bottom: 1px solid #CCCCCC;padding: 3px 3px 3px 3px;text-align:center;\">19时-20时 呼入量</td>");
            html.Append("<td class=\"formtabletitle1\"style=\"height: 25px;background-color: #D5EDFE;border-left: 0px solid #FFFFFF;border-right: 1px solid #CCCCCC;border-top: 1px solid #CCCCCC;border-bottom: 1px solid #CCCCCC;padding: 3px 3px 3px 3px;text-align:center;\">20时-21时 呼出量</td>");
            html.Append("<td class=\"formtabletitle1\"style=\"height: 25px;background-color: #D5EDFE;border-left: 0px solid #FFFFFF;border-right: 1px solid #CCCCCC;border-top: 1px solid #CCCCCC;border-bottom: 1px solid #CCCCCC;padding: 3px 3px 3px 3px;text-align:center;\">20时-21时 呼入量</td>");
            html.Append("<td class=\"formtabletitle1\"style=\"height: 25px;background-color: #D5EDFE;border-left: 0px solid #FFFFFF;border-right: 1px solid #CCCCCC;border-top: 1px solid #CCCCCC;border-bottom: 1px solid #CCCCCC;padding: 3px 3px 3px 3px;text-align:center;\">21时-22时 呼出量</td>");
            html.Append("<td class=\"formtabletitle1\"style=\"height: 25px;background-color: #D5EDFE;border-left: 0px solid #FFFFFF;border-right: 1px solid #CCCCCC;border-top: 1px solid #CCCCCC;border-bottom: 1px solid #CCCCCC;padding: 3px 3px 3px 3px;text-align:center;\">21时-22时 呼入量</td>");
            html.Append("<td class=\"formtabletitle1\"style=\"height: 25px;background-color: #D5EDFE;border-left: 0px solid #FFFFFF;border-right: 1px solid #CCCCCC;border-top: 1px solid #CCCCCC;border-bottom: 1px solid #CCCCCC;padding: 3px 3px 3px 3px;text-align:center;\">22时-23时 呼出量</td>");
            html.Append("<td class=\"formtabletitle1\"style=\"height: 25px;background-color: #D5EDFE;border-left: 0px solid #FFFFFF;border-right: 1px solid #CCCCCC;border-top: 1px solid #CCCCCC;border-bottom: 1px solid #CCCCCC;padding: 3px 3px 3px 3px;text-align:center;\">22时-23时 呼入量</td>");
            html.Append("<td class=\"formtabletitle1\"style=\"height: 25px;background-color: #D5EDFE;border-left: 0px solid #FFFFFF;border-right: 1px solid #CCCCCC;border-top: 1px solid #CCCCCC;border-bottom: 1px solid #CCCCCC;padding: 3px 3px 3px 3px;text-align:center;\">23时-24时 呼出量</td>");
            html.Append("<td class=\"formtabletitle1\"style=\"height: 25px;background-color: #D5EDFE;border-left: 0px solid #FFFFFF;border-right: 1px solid #CCCCCC;border-top: 1px solid #CCCCCC;border-bottom: 1px solid #CCCCCC;padding: 3px 3px 3px 3px;text-align:center;\">23时-24时 呼入量</td>");
            html.Append("</tr>");
            #endregion

            string sql = "";
            #region 筛选
            if (string.IsNullOrEmpty(_operations[0]))
                sql += " and BeginTime>'" + Convert.ToDateTime(_operations[0]).ToString("yyyy-MM-dd") + " 00:00:00' ";
            if (string.IsNullOrEmpty(_operations[1]))
                sql += " and BeginTime<'" + Convert.ToDateTime(_operations[1]).ToString("yyyy-MM-dd") + " 23:59:59' ";
            #endregion

            DataTable dtnew = bll_T_Report.GetCallCountReport3(sql);
            //SimpleDateFormat sim = new SimpleDateFormat("yyyy-MM-dd");
            //DateTime ssss = sim.parse(_operations[0]);
            for (DateTime dttime = Convert.ToDateTime(_operations[0]); dttime < Convert.ToDateTime(_operations[1]).AddDays(1);dttime= dttime.AddDays(1))
            {
            
                html.Append("<tr align=\"center\" valign=\"middle\" onmouseover=\"this.style.backgroundColor='#F6F6F6'\" onmouseout=\"this.style.backgroundColor='#ffffff'\" bgcolor=\"#ffffff\">");
                //日期
                string dttime1 = dttime.ToString("yyyy-MM-dd");
                html.Append("<td class=\"formtable_td\" style=\"vertical-align: middle;border-top: 0px solid #CCCCCC;border-bottom: 1px solid #CCCCCC;border-left: 1px solid #CCCCCC;border-right: 1px solid #CCCCCC;padding-left: 2px;height: 25px;padding-top: 3px;padding-bottom: 3px;\">" + dttime.ToString().Substring(0,dttime.ToString().Length-7) + "&nbsp;</td>");
                for (int i = 0; i < 24;i++ )
                {
                    var drIn = dtnew.Select("dates='" + dttime.ToString("yyyyMMdd") + "' and hh='" + i + "' and calltype=0");
                    int conIn = (from DataRow dr in drIn select dr.Field<int>("con")).FirstOrDefault();

                    var drOut = dtnew.Select("dates='" + dttime.ToString("yyyyMMdd") + "' and hh='" + i + "' and calltype=1");
                    int conOut = (from DataRow dr in drOut select dr.Field<int>("con")).FirstOrDefault();

                    html.Append("<td class=\"formtable_td\" style=\"vertical-align: middle;border-top: 0px solid #CCCCCC;border-bottom: 1px solid #CCCCCC;border-left: 1px solid #CCCCCC;border-right: 1px solid #CCCCCC;padding-left: 2px;height: 25px;padding-top: 3px;padding-bottom: 3px;\">" + conOut.ToString() + "&nbsp;</td>");
                    html.Append("<td class=\"formtable_td\" style=\"vertical-align: middle;border-top: 0px solid #CCCCCC;border-bottom: 1px solid #CCCCCC;border-left: 1px solid #CCCCCC;border-right: 1px solid #CCCCCC;padding-left: 2px;height: 25px;padding-top: 3px;padding-bottom: 3px;\">" + conIn.ToString() + "&nbsp;</td>");


                    #region 优化 20190730
                    //if (i == 23)
                    //{
                    //    dt = bll_T_Report.GetCallCountReport2("and CallType=1  and BeginTime>'" + dttime1 + " " + i + ":00:00' and BeginTime<'" + dttime1 + " 23:59:59'");
                    //    //dt = bll_T_Report.GetCallCountReport1("and CallType=1  and BeginTime>'" + dttime1 + " " + i + ":00:00' and BeginTime<'" + dttime1 + " 23:59:59'");
                    //}
                    //else
                    //{
                    //    int j = i + 1;
                    //    dt = bll_T_Report.GetCallCountReport2("and CallType=1  and BeginTime>'" + dttime1 + " " + i + ":00:00' and BeginTime<'" + dttime1 + " " + j + ":00:00'");
                    //    //dt = bll_T_Report.GetCallCountReport1("and CallType=1  and BeginTime>'" + dttime1 + " " + i + ":00:00' and BeginTime<'" + dttime1 + " " + j + ":00:00'");
                    //}
                    //html.Append("<td class=\"formtable_td\" style=\"vertical-align: middle;border-top: 0px solid #CCCCCC;border-bottom: 1px solid #CCCCCC;border-left: 1px solid #CCCCCC;border-right: 1px solid #CCCCCC;padding-left: 2px;height: 25px;padding-top: 3px;padding-bottom: 3px;\">"+dt.Rows[0][0].ToString()+"&nbsp;</td>");
                    //if (i == 23)
                    //{
                    //    dt = bll_T_Report.GetCallCountReport2("and CallType=0  and BeginTime>'" + dttime1 + " " + i + ":00:00' and BeginTime<'" + dttime1 + " 23:59:59'");
                    //    //dt = bll_T_Report.GetCallCountReport1("and CallType=0  and BeginTime>'" + dttime1 + " " + i + ":00:00' and BeginTime<'" + dttime1 + " 23:59:59'");
                    //}
                    //else
                    //{
                    //    int j = i + 1;
                    //    dt = bll_T_Report.GetCallCountReport2("and CallType=0  and BeginTime>'" + dttime1 + " " + i + ":00:00' and BeginTime<'" + dttime1 + " " + j + ":00:00'");
                    //    //dt = bll_T_Report.GetCallCountReport1("and CallType=0  and BeginTime>'" + dttime1 + " " + i + ":00:00' and BeginTime<'" + dttime1 + " " + j + ":00:00'");
                    //}
                    //html.Append("<td class=\"formtable_td\" style=\"vertical-align: middle;border-top: 0px solid #CCCCCC;border-bottom: 1px solid #CCCCCC;border-left: 1px solid #CCCCCC;border-right: 1px solid #CCCCCC;padding-left: 2px;height: 25px;padding-top: 3px;padding-bottom: 3px;\">"+dt.Rows[0][0].ToString()+"&nbsp;</td>");
                    #endregion
                }
                html.Append("</tr>");
            
            }
            ////合计
            //html.Append("<tr style=\"text-align: center;\"><td colspan=\"2\" class=\"formtabletitle3\" style=\"height: 35px;background-color: #D5EDFE;border-left: 1px solid #CCCCCC;border-right: 1px solid #CCCCCC;border-top: 0px solid #CCCCCC;border-bottom: 1px solid #CCCCCC;padding: 3px 10px 3px 2px;text-align:center;\">总计:</td>");
            //html.Append("<td class=\"formtabletitle2\" style=\"height: 25px;background-color: #D5EDFE;border-left: 0px solid #FFFFFF;border-right: 1px solid #CCCCCC;border-top: 0px solid #FFFFFF;border-bottom: 1px solid #CCCCCC;padding: 3px 3px 3px 3px;text-align:center;\">" + allCount + "&nbsp;</td>");
            //html.Append("<td class=\"formtabletitle2\" style=\"height: 25px;background-color: #D5EDFE;border-left: 0px solid #FFFFFF;border-right: 1px solid #CCCCCC;border-top: 0px solid #FFFFFF;border-bottom: 1px solid #CCCCCC;padding: 3px 3px 3px 3px;text-align:center;\">" + allInCount + "&nbsp;</td>");
            //html.Append("<td class=\"formtabletitle2\" style=\"height: 25px;background-color: #D5EDFE;border-left: 0px solid #FFFFFF;border-right: 1px solid #CCCCCC;border-top: 0px solid #FFFFFF;border-bottom: 1px solid #CCCCCC;padding: 3px 3px 3px 3px;text-align:center;\">" + allOutCount + "&nbsp;</td>");
            //html.Append("<td class=\"formtabletitle2\" style=\"height: 25px;background-color: #D5EDFE;border-left: 0px solid #FFFFFF;border-right: 1px solid #CCCCCC;border-top: 0px solid #FFFFFF;border-bottom: 1px solid #CCCCCC;padding: 3px 3px 3px 3px;text-align:center;\">" + allSecond + "秒&nbsp;</td>");
            //html.Append("<td class=\"formtabletitle2\" style=\"height: 25px;background-color: #D5EDFE;border-left: 0px solid #FFFFFF;border-right: 1px solid #CCCCCC;border-top: 0px solid #FFFFFF;border-bottom: 1px solid #CCCCCC;padding: 3px 3px 3px 3px;text-align:center;\">" + allAvgSecond / allCount + "秒&nbsp;</td>");
            //html.Append("</tr>");
        }
        catch
        { }
        finally
        {
            dt.Clear();
            dt.Dispose();

        }
        html.Append("</table>");
        return html.ToString();
    }

    private string[] GetSearchItems(AjaxPro.JavaScriptArray searchItems)
    {
        string[] operations = new string[searchItems.Count];
        int i = 0;
        foreach (Object obj in searchItems)
        {
            operations[i] = obj.ToString();
            i++;
        }
        return operations;
    }

    public string ChangeValue(int times)
    {
        try
        {
            string strhh = "";
            string strmm = "";
            string strss = "";
            int hh;
            int mm;
            int ss;
            //传入的时间为空或小于0
            if (times < 0)
            {
                return "";
            }
            //得到小时
            hh = times / 3600 | 0;
            times = times - hh * 3600;
            strhh = hh.ToString();
            //if (hh < 10)
            //{
            //    strhh = "0" + hh.ToString();
            //}
            //得到分
            mm = times / 60 | 0;
            //得到秒
            ss = times - mm * 60;
            strmm = mm.ToString();
            strss = ss.ToString();
            //if (mm < 10)
            //{
            //    strmm = "0" + mm.ToString();
            //}
            //if (ss < 10)
            //{
            //    strss = "0" + ss.ToString();
            //}

            if (strhh == "0")
            {
                if (strmm == "0")
                {
                    return strss + "秒";
                }
                else
                {
                    return strmm + "分" + strss + "秒";
                }
            }
            else
            {
                return strhh + "时" + strmm + "分" + strss + "秒";
            }

            //if (times < 60)
            //{
            //    return "" + times + "秒";
            //}
            //else if (times < 3600)
            //{
            //    return "" + Convert.ToInt32(times / 60).ToString() + "分钟" + (times - Convert.ToInt32(times / 60) * 60).ToString() + "秒";
            //}
            //else if (times < 86400)
            //{
            //    return "" + Convert.ToInt32(times / 3600) + "小时" + (times - Convert.ToInt32(times / 3600) * 3600).ToString() + "分钟" + (times - Convert.ToInt32(times / 60) * 60).ToString() + "秒";
            //}
            //else
            //{
            //    return "" + Convert.ToInt32(times / 86400) + "天" + (times - Convert.ToInt32(times / 86400) * 86400).ToString() + "小时" + (times - Convert.ToInt32(times / 3600) * 3600).ToString() + "分钟" + (times - Convert.ToInt32(times / 60) * 60).ToString() + "秒";
            //}
        }
        catch
        {
            return "";
        }
    }
}