//绑定数据 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 }