UU_CallCenter/code/BaseCallCent.../reportmanage/callreports/checkinrepor...

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;

namespace HySoft.BaseCallCenter.Web.reportmanage.callreports
{
    public partial class checkinreport : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {

        }
        /// <summary>
        /// 生成表格的标题和统计字段
        /// </summary>
        /// <param name="TableTitle">表格的标题</param>
        /// <param name="TableHead">表格统计字段</param>
        /// <returns></returns>
        public StringBuilder CreateTableTitleAndHead(string TableTitle, string BeginTime, string EndTime, params object[] TableHead)
        {
            StringBuilder html = new StringBuilder();
            html.Append("<h1 style='font-size: 18px;font-weight: bold;color: #333333;text-align:center;width:100%;'><b>" + TableTitle + "</b></h1>");
            html.Append("<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\" align='center'>");
            html.Append("<tr style=\"text-align: center;\">");
            for (int i = 0; i < TableHead.Length; i++)
            {
                //标题第一行
                html.Append("<td class=\"formtabletitle1\"style=\"height: 25px;background-color: #D5EDFE;border-left: 1px solid #CCCCCC;border-right: 1px solid #CCCCCC;border-top: 1px solid #CCCCCC;border-bottom: 1px solid #CCCCCC;padding: 3px 3px 3px 3px;text-align:center;\">" + TableHead[i] + "</td>");
            }
            html.Append("</tr>");
            GetTabelData(html, BeginTime, EndTime);
            html.Append("</table>");
            return html;
        }
        /// <summary>
        /// 获取表格统计数据
        /// </summary>
        /// <param name="SB"></param>
        /// <param name="BeginTime"></param>
        /// <param name="EndTime"></param>
        public void GetTabelData(StringBuilder SB, string BeginTime, string EndTime)
        {
            string sql = " and F_Type=11 "; // 签入
            if (BeginTime != "")
            {
                sql += " and BeginTime>='" + BeginTime + "'";
            }
            if (EndTime != "")
            {
                sql += " and BeginTime<='" + EndTime + "'";
            }
            var userAccountList = new BLL.T_Sys_UserAccount().GetModelList(" F_SeatFlag=1");
            DataTable dt = DBUtility.DbHelperSQL.Query("select f_optby,f_optname,COUNT(1) as checkincount from T_Sys_CallOptLogs where 1=1 "+sql+" group by f_optby,f_optname").Tables[0];
            foreach (Model.T_Sys_UserAccount item in userAccountList)
            {
                string c = "0";
                DataRow drUser = dt.AsEnumerable().FirstOrDefault(dr => dr.Field<int>("f_optby") == item.F_UserId);
                if (drUser != null)
                {
                    c = drUser[2].ToString();
                }

                SB.Append("<tr style=\"text-align: center;\" onmouseover=\"this.style.backgroundColor='#F6F6F6'\" onmouseout=\"this.style.backgroundColor='#ffffff'\" >");
                SB.Append("<td class=\"formtabletitle1\"style=\"height: 25px;background-color: #fff;border-left: 1px solid #CCCCCC;border-right: 1px solid #CCCCCC;border-top: 1px solid #CCCCCC;border-bottom: 1px solid #CCCCCC;padding: 3px 3px 3px 3px;text-align:center;\">" + item.F_UserCode + "</td>");
                SB.Append("<td class=\"formtabletitle1\"style=\"height: 25px;background-color: #fff;border-left: 1px solid #CCCCCC;border-right: 1px solid #CCCCCC;border-top: 1px solid #CCCCCC;border-bottom: 1px solid #CCCCCC;padding: 3px 3px 3px 3px;text-align:center;\">" + item.F_UserName + "</td>");
                SB.Append("<td class=\"formtabletitle1\"style=\"height: 25px;background-color: #fff;border-left: 1px solid #CCCCCC;border-right: 1px solid #CCCCCC;border-top: 1px solid #CCCCCC;border-bottom: 1px solid #CCCCCC;padding: 3px 3px 3px 3px;text-align:center;\">" + c + "</td>");
                SB.Append("</tr>");

            }
        }
    }
}