ditie2.0_web/web/YTSoft.BaseC.../Controllers/OtherPageCon...

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
    {
        //
        // GET: /OtherPage/

        /// <summary>
        /// 微信页面
        /// </summary>
        /// <returns></returns>
        //public ActionResult WebChart(int pageType)
        //{
        //    if (pageType == 1)
        //    {
        //        return Redirect("http://rexian.zzmetro.com/customer/" + F_PId);
        //    }
        //    else
        //    {
        //        return Redirect("http://rexian.zzmetro.com/customer_weibo/" + F_PId);
        //    }





        //}










        /// <summary>
        /// 获取未读聊天消息个数
        /// </summary>
        /// <returns></returns>
        //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<ResponseResult>(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<ResponseResult>(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;
        }








        /// <summary>
        ///获取待办工单
        /// </summary>
        /// <returns></returns>
        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<Model.T_Wo_WorkOrderBase> pageModel = new Model.PageData<Model.T_Wo_WorkOrderBase>();
            dt = BLL.PagerBLL.GetListPager(
                "T_Wo_WorkOrderBase",
                "F_WORKORDERID",
              "*",
                sql,
                "ORDER BY F_CREATEDATE desc",
                10,
                1,
                true,
                out recordCount);

            return recordCount;

        }
        /// <summary>
        ///获取微博工单
        /// </summary>
        /// <returns></returns>
        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<Model.T_Wo_WorkOrderBase> pageModel = new Model.PageData<Model.T_Wo_WorkOrderBase>();
            dt = BLL.PagerBLL.GetListPager(
                "T_Wo_WorkOrderBase",
                "F_WORKORDERID",
              "*",
                sql,
                "ORDER BY F_CREATEDATE desc",
                10,
                1,
                true,
                out recordCount);

            return recordCount;

        }
        /// <summary>
        ///获取补录工单
        /// </summary>
        /// <returns></returns>
        public int GetMyOrderNeedCount()
        {

            //工单类型：转单 工单状态：处理中 处理人员：当前用户id
            string sql = " and F_WORKORDERSTATEID=0  and F_USERID=" + F_UserID;
            DataTable dt = new DataTable();
            int recordCount = 0;
            Model.PageData<Model.T_Wo_WorkOrderBase> pageModel = new Model.PageData<Model.T_Wo_WorkOrderBase>();
            dt = BLL.PagerBLL.GetListPager(
                "T_Wo_WorkOrderBase",
                "F_WORKORDERID",
              "*",
                sql,
                "ORDER BY F_CREATEDATE desc",
                10,
                1,
                true,
                out recordCount);

            return recordCount;

        }

    }


}