private void BindScoreData()
{
QueryQS_ScoreStat query = new QueryQS_ScoreStat();
query.RequestUserID = RequestUserID;
query.RequestGroupID = RequestGroupID;
query.RequestRecordBeginTime = RequestRecordBeginTime;
query.RequestRecordEndTime = RequestRecordEndTime;
int totalCount = 0;
string tableEndName = "_QS";//查询质检话务冗余表
DataTable dt = BLL.QS_Result.Instance.GetQS_ResultScoreStat(query, "", BLL.PageCommon.Instance.PageIndex, pageSize, tableEndName, out totalCount);
repeaterTableList.DataSource = dt;
repeaterTableList.DataBind();
AjaxPager.PageSize = pageSize;
AjaxPager.InitPager(totalCount);
}
private string GetQS_ResultScoreStat_Where(QueryQS_ScoreStat query)
{
string where = "";
int userId = 0;
if (int.TryParse(query.RequestUserID, out userId) && userId > 0)
{
where += " And cri.CreateUserID=" + userId;
}
int groupId = 0;
if (int.TryParse(query.RequestGroupID, out groupId) && groupId > 0)
{
where += " AND cri.BGID=" + groupId;
}
DateTime recordBeginTime;
DateTime recordEndTime;
if (DateTime.TryParse(query.RequestRecordBeginTime, out recordBeginTime))
{
where += " And cri.CreateTime>='" + recordBeginTime.ToString() + "'";
}
if (DateTime.TryParse(query.RequestRecordEndTime, out recordEndTime))
{
where += " And cri.CreateTime<='" + recordEndTime.Add(new TimeSpan(23, 59, 59)).ToString() + "'";
}
// 数据权限判断
int loginUserId = BLL.Util.GetLoginUserID();
string whereDataRight = "";
whereDataRight = BLL.UserGroupDataRigth.Instance.GetSqlRightstr("cri", "BGID", "CreateUserID", loginUserId);
where += whereDataRight;
return(where);
}
/// 成绩统计查询
/// <summary>
/// 成绩统计查询
/// </summary>
/// <param name="where"></param>
/// <param name="order"></param>
/// <param name="currentPage"></param>
/// <param name="pageSize"></param>
/// <param name="tableEndName"></param>
/// <param name="totalCount"></param>
/// <returns></returns>
public DataTable GetQS_ResultScoreStat(QueryQS_ScoreStat query, string order, int currentPage, int pageSize, string tableEndName, out int totalCount)
{
string where = GetQS_ResultScoreStat_Where(query);
return(Dal.QS_Result.Instance.GetQS_ResultScoreStat(where, order, currentPage, pageSize, tableEndName, out totalCount));
}
private void BindScoreData()
{
QueryQS_ScoreStat query = new QueryQS_ScoreStat();
query.RequestUserID = RequestUserID;
query.RequestGroupID = RequestGroupID;
query.RequestRecordBeginTime = RequestRecordBeginTime;
query.RequestRecordEndTime = RequestRecordEndTime;
int totalCount = 0;
string tableEndName = "_QS";//查询质检话务冗余表
DataTable dt = BLL.QS_Result.Instance.GetQS_ResultScoreStat(query, "", 1, -1, tableEndName, out totalCount);
DataTable dtNew = new DataTable();
DataColumn dcEmployeeName = new DataColumn("坐席");
DataColumn dcRulesTable = new DataColumn("评分表");
DataColumn dcSumCount = new DataColumn("质检次数");
DataColumn dcStatCount = new DataColumn("合格量");
DataColumn dcRate = new DataColumn("合格率");
DataColumn dcAvg = new DataColumn("平均分");
dtNew.Columns.Add(dcEmployeeName);
dtNew.Columns.Add(dcRulesTable);
dtNew.Columns.Add(dcSumCount);
dtNew.Columns.Add(dcStatCount);
dtNew.Columns.Add(dcRate);
dtNew.Columns.Add(dcAvg);
if (dt != null)
{
foreach (DataRow dr in dt.Rows)
{
DataRow drNew = dtNew.NewRow();
//坐席名称
drNew[0] = dr["TrueName"].ToString();
//评分表名称
drNew[1] = dr["Name"].ToString();
//质检次数
drNew[2] = dr["SumCount"].ToString();
//质检评分
if (dr["ScoreType"].ToString() != "2")
{
//float result = float.Parse(dr["statCount"].ToString()) / float.Parse(dr["sumCount"].ToString());
drNew[3] = "-";
drNew[4] = "-";
if (dr["totScore"].ToString() != null && dr["totScore"] != null && dr["sumCount"].ToString() != "0")
{
drNew[5] = (float.Parse(dr["totScore"].ToString()) / float.Parse(dr["sumCount"].ToString())).ToString("0.00");
}
else
{
drNew[5] = "0.00";
}
}
else
{
drNew[3] = dr["statCount"].ToString();
float result = float.Parse(dr["statCount"].ToString()) * 100 / float.Parse(dr["sumCount"].ToString());
drNew[4] = result.ToString("0.00") + "%";
drNew[5] = "-";
}
dtNew.Rows.Add(drNew);
}
}
BLL.Util.ExportToCSV("坐席成绩统计", dtNew);
}