using Newtonsoft.Json; using System; using System.Collections.Generic; using System.Data; using System.Linq; using System.Text; using System.Web; using System.Web.Mvc; using System.Web.UI; using YTSoft.BaseCallCenter.MVCWeb.Commons; namespace YTSoft.BaseCallCenter.MVCWeb.Controllers { public class OtherPageController : BaseController { /// /// 获取未读聊天消息个数 /// /// //public int GetWebChartCount(int pageType) // { // int messageCount = 0; // #region 调用接口插入用户信息 // try // { // StringBuilder returnStr = new StringBuilder(); // string wxAddUrl = ""; // if (pageType == 1) // { // wxAddUrl = "http://rexian.zzmetro.com/api/customer/unread/" + F_PId; // } // else // { // wxAddUrl = "http://rexian.zzmetro.com/api/customer_weibo/unread/" + F_PId; // } // //if (pageType == 1) // //{ // // wxAddUrl = "http://rexian.zzmetro.com/api/customer/unread/" + F_PId; // // //"http://rexian.zzmetro.com/customer_weibo/" + F_PId // // //"http://rexian.zzmetro.com/ // //} // //else // //{ // // wxAddUrl = "http://rexian.zzmetro.com/api/customer_weibo/unread/" + F_PId; // //} // string addWxResult = HttpHelper.HttpGet(wxAddUrl); // ResponseResult ResultModel = JsonConvert.DeserializeObject(addWxResult); // messageCount = ResultModel.data; // } // catch (Exception ex) // { // } // #endregion // return messageCount; // } public ActionResult WebChart(int pageType) { if (pageType == 1) return (ActionResult)this.Redirect("http://rexian.zzmetro.com/customer/" + (object)this.F_PId); return (ActionResult)this.Redirect("http://rexian.zzmetro.com/customer_weibo/" + (object)this.F_PId); } public int GetWebChartCount(int pageType) { int num = 0; try { StringBuilder stringBuilder = new StringBuilder(); num = JsonConvert.DeserializeObject(HttpHelper.HttpGet(pageType != 1 ? "http://rexian.zzmetro.com/api/customer_weibo/unread/" + (object)this.F_PId : "http://rexian.zzmetro.com/api/customer/unread/" + (object)this.F_PId)).data; } catch (Exception ex) { } return num; } /// ///获取待办工单 /// /// public int GetMyOrderCount() { //待办工单and F_WORKORDERTYPEID=1 and F_WORKORDERSTATEID=1 and F_WORKORDERID in (select F_INSTANCEID from T_Wo_WorkOrderHistory where F_WORKORDERSTATEID=0 and F_OPTUSERID={0}) //string sql = " and F_WORKORDERTYPEID=1 and F_WORKORDERSTATEID=1 and F_CREATEBY=" + F_UserID; string sql = string.Format(" and F_WORKORDERTYPEID=1 and F_WORKORDERSTATEID=1 and F_WORKORDERID in (select F_INSTANCEID from T_Wo_WorkOrderHistory where F_WORKORDERSTATEID=0 and F_OPTUSERID={0})", F_UserID); DataTable dt = new DataTable(); int recordCount = 0; Model.PageData pageModel = new Model.PageData(); dt = BLL.PagerBLL.GetListPager( "T_Wo_WorkOrderBase", "F_WORKORDERID", "*", sql, "ORDER BY F_CREATEDATE desc", 10, 1, true, out recordCount); return recordCount; } /// ///获取微博工单 /// /// public int GetMyOrderCountWb() { //微博工单 string sql = " and F_WORKORDERSTATEID=0 and F_REPAIRMANID=4 and F_USERID=" + F_UserID; DataTable dt = new DataTable(); int recordCount = 0; Model.PageData pageModel = new Model.PageData(); dt = BLL.PagerBLL.GetListPager( "T_Wo_WorkOrderBase", "F_WORKORDERID", "*", sql, "ORDER BY F_CREATEDATE desc", 10, 1, true, out recordCount); return recordCount; } /// ///获取补录工单 /// /// public int GetMyOrderNeedCount() { //工单类型:转单 工单状态:处理中 处理人员:当前用户id string sql = " and F_WORKORDERSTATEID=0 and F_USERID=" + F_UserID; DataTable dt = new DataTable(); int recordCount = 0; Model.PageData pageModel = new Model.PageData(); dt = BLL.PagerBLL.GetListPager( "T_Wo_WorkOrderBase", "F_WORKORDERID", "*", sql, "ORDER BY F_CREATEDATE desc", 10, 1, true, out recordCount); return recordCount; } } }