//绑定数据
public void BindData()
{
Entities.QueryStopCustApply query = new Entities.QueryStopCustApply();
string errMsg = string.Empty;
BLL.ConverToEntitie <Entities.QueryStopCustApply> conver = new BLL.ConverToEntitie <Entities.QueryStopCustApply>(query);
errMsg = conver.Conver(JsonStr);
if (errMsg != "")
{
return;
}
query.LoginID = userID;
int RecordCount = 0;
DataTable dt = BLL.StopCustApply.Instance.GetStopCustApply(query, " sca.ApplyTime desc ", BLL.PageCommon.Instance.PageIndex, PageSize, out RecordCount);
repeaterTableList.DataSource = dt;
repeaterTableList.DataBind();
AjaxPager.PageSize = 20;
AjaxPager.InitPager(RecordCount);
}
//绑定工单表信息
private Entities.WorkOrderInfo bindWorkOrderInfo(out string msg)
{
msg = string.Empty;
Entities.WorkOrderInfo model_WorkOrderInfo = new Entities.WorkOrderInfo();
string errMsg = string.Empty;
BLL.ConverToEntitie <Entities.WorkOrderInfo> conver = new BLL.ConverToEntitie <Entities.WorkOrderInfo>(model_WorkOrderInfo);
errMsg = conver.Conver(OperData);
if (errMsg != "")
{
msg = "{'result':'false','msg':'给对应实体赋值时出错，操作失败！'}";
return(model_WorkOrderInfo);
}
//生成工单ID放在数据库Insert存储过程中 update lxw 13.10.23
//int maxCount = BLL.WorkOrderInfo.Instance.GetMax();
//model_WorkOrderInfo.OrderID = "WO" + DateTime.Now.Year.ToString() + (++maxCount).ToString().PadLeft(10, '0');
model_WorkOrderInfo.CreateUserID = model_WorkOrderInfo.ModifyUserID = operUserID;
model_WorkOrderInfo.CreateTime = model_WorkOrderInfo.ModifyTime = operTime;
model_WorkOrderInfo.Status = 0;
return(model_WorkOrderInfo);
}
private void BindData()
{
//解析参数
string errMsg = string.Empty;
QueryQS_IM_Result query = new QueryQS_IM_Result();
BLL.ConverToEntitie <QueryQS_IM_Result> conver = new BLL.ConverToEntitie <QueryQS_IM_Result>(query);
errMsg = conver.Conver(JsonStr);
if (errMsg != "")
{
return;
}
//参数校验处理（必须）
query.LoginUerID = BLL.Util.GetLoginUserID();
query.InitCheck();
switch (query.BeginCount)
{
case "-1":
query.BeginCount = "1";
query.EndCount = "";
break;
case "1":
query.BeginCount = "1";
query.EndCount = "30";
break;
case "2":
query.BeginCount = "31";
query.EndCount = "59";
break;
case "3":
query.BeginCount = "60";
query.EndCount = "99";
break;
case "4":
query.BeginCount = "100";
query.EndCount = "";
break;
default: break;
}
//查询数据
DataTable dt = BLL.QS_IM_Result.Instance.GetQS_IM_Result(query, "", BLL.PageCommon.Instance.PageIndex, PageSize, out RecordCount);
repeaterTableList.DataSource = dt;
repeaterTableList.DataBind();
AjaxPager.PageSize = 20;
AjaxPager.InitPager(RecordCount);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
int userID = BLL.Util.GetLoginUserID();
if (!BLL.Util.CheckRight(userID, "SYS024BUT600401"))
{
Response.Write(BLL.Util.GetNotAccessMsgPage("您没有访问该页面的权限"));
Response.End();
}
//解析参数
string errMsg = string.Empty;
BLL.ConverToEntitie <QueryQS_IM_Result> conver = new BLL.ConverToEntitie <QueryQS_IM_Result>(query);
errMsg = conver.Conver(Params);
if (errMsg != "")
{
return;
}
//参数校验处理（必须）
query.LoginUerID = BLL.Util.GetLoginUserID();
query.InitCheck();
//浏览器
bool isIE = false;
if (RequestBrowser == "IE")
{
isIE = true;
}
//校验
if (!string.IsNullOrEmpty(query.ScoreTable) && query.ScoreTable != "-1")
{
int _qs_rtid = CommonFunction.ObjectToInteger(query.ScoreTable);
//1-评分型；2-合格型;3.五级质检
scoretype = getTableType(_qs_rtid, out nums);
string resultStr = string.Empty;
switch (scoretype)
{
case "1":
case "3":
resultStr = ExportByRatingType(_qs_rtid);
break;
case "2":
resultStr = ExportByQualifiedType(_qs_rtid);
break;
}
ExportAnswerDetail(resultStr, "对话质检结果", isIE);
}
}
}
//绑定数据
public void BindData()
{
Entities.QueryCallRecordInfo query = new Entities.QueryCallRecordInfo();
string errMsg = string.Empty;
BLL.ConverToEntitie <Entities.QueryCallRecordInfo> conver = new BLL.ConverToEntitie <Entities.QueryCallRecordInfo>(query);
errMsg = conver.Conver(JsonStr);
#region 从JSONSTR中解析出通话时间
string begintime = "";
string endtime = "";
string[] array1 = JsonStr.Split('&');
if (array1.Length >= 3)
{
begintime = array1[1].Split('=')[1];
if (!string.IsNullOrEmpty(begintime))
{
begintime = begintime.Insert(10, " ");
query.BeginTime = DateTime.Parse(begintime);
}
endtime = array1[2].Split('=')[1];
if (!string.IsNullOrEmpty(endtime))
{
endtime = endtime.Insert(10, " ");
query.EndTime = DateTime.Parse(endtime);
}
}
#endregion
if (errMsg != "")
{
return;
}
query.LoginID = userID;
query.IsFilterNull = 1;
int RecordCount = 0;
tableEndName = BLL.Util.CalcTableNameByMonth(3, query.BeginTime.Value);
DataTable dt = BLL.QS_Result.Instance.GetQS_ResultList(query, " cob.CreateTime desc ", BLL.PageCommon.Instance.PageIndex, PageSize, tableEndName, out RecordCount);
repeaterTableList.DataSource = dt;
repeaterTableList.DataBind();
AjaxPager.PageSize = 20;
AjaxPager.InitPager(RecordCount);
}
//绑定工单回复表信息
private Entities.WorkOrderRevert bindWorkOrderRevert(out string msg)
{
msg = string.Empty;
string errMsg = string.Empty;
Entities.WorkOrderRevert model_Revert = new Entities.WorkOrderRevert();
BLL.ConverToEntitie <Entities.WorkOrderRevert> converRevert = new BLL.ConverToEntitie <Entities.WorkOrderRevert>(model_Revert);
errMsg = converRevert.Conver(RevertData);
if (errMsg != "")
{
msg = "{'result':'false','msg':'给对应实体赋值时出错，操作失败！'}";
return(model_Revert);
}
model_Revert.CreateTime = operTime;
model_Revert.CreateUserID = operUserID;
return(model_Revert);
}
//绑定数据
public void BindData()
{
Stopwatch sw = new Stopwatch();
sw.Start();
Entities.QueryCallRecord_ORIG query = new Entities.QueryCallRecord_ORIG();
string errMsg = string.Empty;
BLL.ConverToEntitie <Entities.QueryCallRecord_ORIG> conver = new BLL.ConverToEntitie <Entities.QueryCallRecord_ORIG>(query);
errMsg = conver.Conver(JsonStr);
if (errMsg != "")
{
return;
}
int RecordCount = 0;
int _loginID = -2;
string _ownGroup = string.Empty;
string _oneSelf = string.Empty;
_loginID = userID;
query.LoginID = _loginID;
query.BeginTime = Request["tfBeginTime"];
query.EndTime = Request["tfEndTime"];
string tableEndName = BLL.Util.CalcTableNameByMonth(3, CommonFunction.ObjectToDateTime(query.BeginTime));
DataTable dt = BLL.CallRecord_ORIG.Instance.GetCallRecord_ORIGByList(query, " c.CreateTime desc ", BLL.PageCommon.Instance.PageIndex, PageSize, tableEndName, out RecordCount);
string a = sw.Elapsed.ToString();
repeaterTableList.DataSource = dt;
repeaterTableList.DataBind();
sw.Stop();
string b = sw.Elapsed.ToString();
AjaxPager.PageSize = 20;
AjaxPager.InitPager(RecordCount);
}
//绑定回复时工单表信息
private Entities.WorkOrderInfo bindWorkOrderInfo(Entities.WorkOrderInfo oldModel, out string msg)
{
msg = string.Empty;
Entities.WorkOrderInfo model_WorkOrderInfo = oldModel;
int?oldReceiverID = model_WorkOrderInfo.ReceiverID;
string errMsg = string.Empty;
BLL.ConverToEntitie <Entities.WorkOrderInfo> conver = new BLL.ConverToEntitie <Entities.WorkOrderInfo>(model_WorkOrderInfo);
errMsg = conver.Conver(OperData);
if (errMsg != "")
{
msg = "{'result':'false','msg':'给对应实体赋值时出错，操作失败！'}";
return(null);
}
if (model_WorkOrderInfo.ReceiverID == -2)
{
//在没有选择接收人 且 状态为已处理，不清空工单当前处理人 add lxw 13.9.10
if (model_WorkOrderInfo.WorkOrderStatus == (int)Entities.WorkOrderStatus.Processed)
{
model_WorkOrderInfo.ReceiverID = oldReceiverID;
}
else
{
model_WorkOrderInfo.ReceiverName = "";
model_WorkOrderInfo.ReceiverDepartName = "";
}
}
else
{
//存在接收人，赋值接收人的所在部门
model_WorkOrderInfo.ReceiverDepartName = BitAuto.YanFa.SysRightManager.Common.UserInfo.Instance.GetDistrictNameByUserID((int)model_WorkOrderInfo.ReceiverID);
}
return(model_WorkOrderInfo);
}
//绑定个人用户库信息表信息 add lxw 13.11.25
private Web.AjaxServers.CustBaseInfo.CustBasicInfo bindCustBasicInfo(out string msg)
{
msg = string.Empty;
Web.AjaxServers.CustBaseInfo.CustBasicInfo model = new Web.AjaxServers.CustBaseInfo.CustBasicInfo();
string errMsg = string.Empty;
BLL.ConverToEntitie <Web.AjaxServers.CustBaseInfo.CustBasicInfo> conver = new BLL.ConverToEntitie <Web.AjaxServers.CustBaseInfo.CustBasicInfo>(model);
errMsg = conver.Conver(CustBasicInfo);
if (errMsg != "")
{
msg = "{'result':'false','msg':'给对应实体赋值时出错，操作失败！'}";
return(model);
}
model.OperID = operUserID;
model.OperTime = operTime;
return(model);
}
private void BindData()
{
Entities.QueryQS_RulesTable query = new Entities.QueryQS_RulesTable();
string errMsg = string.Empty;
BLL.ConverToEntitie <Entities.QueryQS_RulesTable> conver = new BLL.ConverToEntitie <Entities.QueryQS_RulesTable>(query);
errMsg = conver.Conver(JsonStr);
if (errMsg != "")
{
return;
}
query.LoginID = userID;
int RecordCount = 0;
DataTable dt = BLL.QS_RulesTable.Instance.GetQS_RulesTable(query, " QS_RulesTable.CreateTime desc ", BLL.PageCommon.Instance.PageIndex, PageSize, out RecordCount);
repeaterTableList.DataSource = dt;
repeaterTableList.DataBind();
AjaxPager.PageSize = 20;
AjaxPager.InitPager(RecordCount);
}
//绑定数据
public void BindData()
{
Entities.QueryCallRecord_ORIG query = new Entities.QueryCallRecord_ORIG();
string errMsg = string.Empty;
BLL.ConverToEntitie <Entities.QueryCallRecord_ORIG> conver = new BLL.ConverToEntitie <Entities.QueryCallRecord_ORIG>(query);
errMsg = conver.Conver(JsonStr);
if (errMsg != "")
{
return;
}
int RecordCount = 0;
int _loginID = -2;
string _ownGroup = string.Empty;
string _oneSelf = string.Empty;
query.BeginTime = Request["tfBeginTime"];
query.EndTime = Request["tfEndTime"];
_loginID = userID;
query.LoginID = _loginID;
string tableEndName = BLL.Util.CalcTableNameByMonth(3, CommonFunction.ObjectToDateTime(query.BeginTime));
DataTable dt = BLL.CallRecord_ORIG.Instance.GetCallRecord_ORIGByList(query, " c.CreateTime desc ", 1, -1, tableEndName, out RecordCount);
#region 导出
dt.Columns.Add("OutBoundTypeName");
dt.Columns.Add("CallStatusName");
dt.Columns.Add("CallTimeLong", typeof(int));
dt.Columns.Add("CallTimeTitleLong", typeof(int));
dt.Columns.Add("CallIDStr");
foreach (DataRow dr in dt.Rows)
{
dr["CallStatusName"] = GetCallStatus(dr["CallStatus"].ToString());
dr["OutBoundTypeName"] = GetOutBoundType(dr["CallStatus"].ToString(), dr["OutBoundType"].ToString());
dr["CallTimeLong"] = dr["TallTime"];//修改通话时长导出
dr["CallTimeTitleLong"] = GetTotalTime(CommonFunction.ObjectToInteger(dr["TallTime"]), CommonFunction.ObjectToInteger(dr["AfterWorkTime"]));
dr["CallIDStr"] = dr["CallID"].ToString();
}
//要导出的字段
Dictionary <string, string> ExportColums = new Dictionary <string, string>();
ExportColums.Add("callidstr", "话务ID");
ExportColums.Add("taskid", "任务ID");
ExportColums.Add("agentnum", "工号");
ExportColums.Add("phonenum", "主叫");
ExportColums.Add("ani", "被叫");
ExportColums.Add("callstatusname", "话务类型");
ExportColums.Add("outboundtypename", "呼叫类型");
ExportColums.Add("establishedtime", "接通时间");
ExportColums.Add("releasetime", "挂断时间");
ExportColums.Add("ringingspantime", "振铃时长");
ExportColums.Add("calltimelong", "通话时长");
ExportColums.Add("afterworktime", "话后时长");
ExportColums.Add("calltimetitlelong", "话务总时长");
dt.Columns["CallIDStr"].SetOrdinal(0);
dt.Columns["TaskID"].SetOrdinal(1);
dt.Columns["AgentNum"].SetOrdinal(2);
dt.Columns["PhoneNum"].SetOrdinal(3);
dt.Columns["ANI"].SetOrdinal(4);
dt.Columns["CallStatusName"].SetOrdinal(5);
dt.Columns["SwitchINNum"].SetOrdinal(6);
dt.Columns["OutBoundTypeName"].SetOrdinal(7);
dt.Columns["RingingTime"].SetOrdinal(8);
dt.Columns["EstablishedTime"].SetOrdinal(9);
dt.Columns["ReleaseTime"].SetOrdinal(10);
dt.Columns["RingingSpanTime"].SetOrdinal(11);
dt.Columns["CallTimeLong"].SetOrdinal(12);
dt.Columns["AfterWorkTime"].SetOrdinal(13);
dt.Columns["CallTimeTitleLong"].SetOrdinal(14);
dt.Columns["ConsultTime"].SetOrdinal(15);
dt.Columns["ReleaseType"].SetOrdinal(16);
for (int i = dt.Columns.Count - 1; i >= 0; i--)
{
if (ExportColums.ContainsKey(dt.Columns[i].ColumnName.ToLower()))
{
//字段时要导出的字段，改名
dt.Columns[i].ColumnName = ExportColums[dt.Columns[i].ColumnName.ToLower()];
}
else
{
//不是要导出的字段，删除
dt.Columns.RemoveAt(i);
}
}
BLL.Util.ExportToCSV("话务总表", dt);
#endregion
}
