ditie2.0_web/web/YTSoft.BaseC.../Controllers/Order/OrderControl...

using Newtonsoft.Json;
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using YTSoft.BaseCallCenter.Model;
using YTSoft.BaseCallCenter.MVCWeb.Models;
using YTSoft.Common;

namespace YTSoft.BaseCallCenter.MVCWeb.Controllers
{

    public class OrderController : BaseController
    {

        //工单信息
        BLL.T_Wo_WorkOrderBase orderBLL = new BLL.T_Wo_WorkOrderBase();
        //客户信息
        BLL.T_Cus_CustomerBase cusBLL = new BLL.T_Cus_CustomerBase();
        //部门表
        BLL.T_Sys_Department deptBll = new BLL.T_Sys_Department();
        //转单通知
        BLL.T_Wo_WorkOrderNotice noticeBLL = new BLL.T_Wo_WorkOrderNotice();
        //用户表
        BLL.T_Sys_UserAccount userBll = new BLL.T_Sys_UserAccount();
        //历史工单表
        BLL.T_Wo_WorkOrderHistory historyBll = new BLL.T_Wo_WorkOrderHistory();

        #region 待处理

        /// <summary>
        /// 获取待办工单  新
        /// </summary>
        /// <param name="dtype">工单类型 1、所有待办工单 2、代办结工单</param>
        /// <returns></returns>
        public ActionResult WorkOrderWaitList(int dtype)
        {
            WorkOrderMyModel model = new WorkOrderMyModel();
            model.DType = dtype;
            //业务类型字典表
            model.WorkOrderTypeModelList = GetWorkTypeModelList();
            //话务标志
            model.SeatFlag = F_SeatFlag;
            return View(model);
        }

        /// <summary>
        /// 我的待办工单
        /// </summary>
        /// <param name="page">当前页码</param>
        /// <param name="limit">每页数据量</param>
        /// <param name="sqlWhere">查询条件</param>
        /// <returns></returns>
        [ActionName("WorkOrderMyWaitData")]
        [HttpGet]
        public string WorkOrderMyWaitData(DateTime? NowDateTime, int page, int limit, int? types, string dateParty,
            string workorderNum, string cusName, string phoneNumber,
            string userInfo, int? bussType, int? detailType, string Content)
        {

            //数据结果集
            ResponseData dataModel = new ResponseData();

            //F_FILEFLAG 业务类型ID
            //F_WORKORDERSTATEID   0未处理 1处理中  2已办结 status
            //F_WORKORDERTYPEID 处理方式  1转单 3客服处理 GoType
            //F_REPAIRMANID 接入渠道 1语音 2留言  3微信 4微博 FromType
            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);



            //工单编号
            if (!string.IsNullOrEmpty(workorderNum))
            {
                sql += " and F_CODE like '%" + workorderNum.Trim() + "%'";
            }
            //客户姓名
            if (!string.IsNullOrEmpty(cusName))
            {
                sql += " and F_CUSTOMERNAME like '%" + cusName.Trim() + "%'";
            }
            //客户电话
            if (!string.IsNullOrEmpty(phoneNumber))
            {
                sql += " and F_CUSTOMERTELEPHONE like '%" + phoneNumber.Trim() + "%'";
            }
            //坐席工号
            if (!string.IsNullOrEmpty(userInfo))
            {
                sql += " and F_LINKMAN like '%" + userInfo.Trim() + "%'";
            }

            //业务类别
            if (bussType != null && bussType > 0)
            {
                sql += " and F_FILEFLAG =" + bussType;
            }
            //业务类型
            if (detailType != null && detailType > 0)
            {
                sql += " and F_REPAIRLEVEL =" + detailType;
            }
            //内容
            if (!string.IsNullOrEmpty(Content))
            {
                sql += " and F_CONTENT like '%" + Content.Trim() + "%'";
            }



            //查询按钮
            if (types == 0)
            {
                if (!string.IsNullOrEmpty(dateParty))
                {
                    string startDate = dateParty.Substring(0, 10);
                    string endDate = dateParty.Substring(12);
                    sql += " and F_CREATEDATE>= '" + startDate + " 00:00:00" + "'";
                    sql += " and F_CREATEDATE<= '" + endDate + " 23:59:59" + "'";

                }
            }//一周按钮
            else if (types == 1)
            {

                string endDate = DateTime.Now.ToString();
                string startDate = DateTime.Now.AddDays(-7).ToString();
                sql += " and F_CREATEDATE>= '" + startDate + "'";
                sql += " and F_CREATEDATE<= '" + endDate + "'";

            }//一月按钮
            else if (types == 2)
            {

                string endDate = DateTime.Now.ToString();
                string startDate = DateTime.Now.AddMonths(-1).ToString();
                sql += " and F_CREATEDATE>= '" + startDate + "'";
                sql += " and F_CREATEDATE<= '" + endDate + "'";

            }//一年按钮
            else if (types == 3)
            {

                string endDate = DateTime.Now.ToString();
                string startDate = DateTime.Now.AddYears(-1).ToString();
                sql += " and F_CREATEDATE>= '" + startDate + "'";
                sql += " and F_CREATEDATE<= '" + endDate + "'";

            }

            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",
              "*,CONVERT(varchar,F_CREATEDATE, 120 ) as F_CREATEDATENew"
              + string.Format(",(select top 1 F_HISTORYID from T_Wo_WorkOrderHistory where F_INSTANCEID=F_WORKORDERID and F_WORKORDERSTATEID=0 and F_OPTUSERID={0} Order by F_OPTDATE desc) AS F_HISTORYID", F_UserID)
              + @" , replace(replace(CASE F_WORKORDERFROM WHEN '留言工单' THEN (SELECT F_RecFileUrl FROM dbo.T_Call_LeaveRecord  WHERE F_CallId=F_KSHADDRESSCODE) WHEN '语音工单' THEN (SELECT FilePath FROM dbo.T_Call_CallRecords WHERE CallId=F_KSHADDRESSCODE AND FilePath!='') ELSE NULL END,'\','/'),'" + GetSysconfig("newFilePath") + "','" + GetSysconfig("newPlayPath") + "') as FilePath",
                //+ " ,(CASE F_WORKORDERFROM WHEN '留言工单' THEN (SELECT F_RecFileUrl FROM dbo.T_Call_LeaveRecord  WHERE F_CallId=F_KSHADDRESSCODE) WHEN '语音工单' THEN (SELECT FilePath FROM dbo.T_Call_CallRecords WHERE CallId=F_KSHADDRESSCODE AND FilePath!='') ELSE NULL END ) as FilePath",
                sql,
                "ORDER BY F_CREATEDATE desc",
                limit,
                page,
                true,
                out recordCount);


            dataModel.code = 0;
            dataModel.count = recordCount;
            dataModel.data = dt;

            return JsonConvert.SerializeObject(dataModel);
        }


        /// <summary>
        /// 二级单位处理完成提交处理信息
        /// </summary>
        /// <param name="workOrderBaseModel"></param>
        /// <returns></returns>
        [AcceptVerbs(HttpVerbs.Post)]
        public bool SubmitOrder(T_Wo_WorkOrderHistory workOrderBaseModel)
        {
            AddAction("t_wo_workorderhistory", workOrderBaseModel.F_HISTORYID.ToMyString(), "提交工单", "数据：" + JsonConvert.SerializeObject(workOrderBaseModel), "关键信息");
            AddAction("t_wo_workorderhistory", workOrderBaseModel.F_HISTORYID.ToMyString(), "部门提交工单", workOrderBaseModel.F_INSTANCEID.ToMyString());
            return orderBLL.SubmitOrder(workOrderBaseModel);
        }


        #endregion

        #region 待回访



        /// <summary>
        /// 获取待回访工单
        /// </summary>
        /// <param name="dtype">工单类型 1、所有待办工单 2、代办结工单</param>
        /// <returns></returns>
        public ActionResult WorkOrderMyListHF(int dtype)
        {
            WorkOrderMyModel model = new WorkOrderMyModel();
            model.DType = dtype;
            //业务类型字典表
            model.WorkOrderTypeModelList = GetWorkTypeModelList();
            //话务标志
            model.SeatFlag = F_SeatFlag;
            return View(model);
        }

        /// <summary>
        /// 全媒体客服处理回访
        /// </summary>
        /// <param name="workOrderBaseModel"></param>
        /// <returns></returns>
        [AcceptVerbs(HttpVerbs.Post)]
        public bool SubmitOrderHF(T_Wo_WorkOrderBase workOrderBaseModel)
        {
            AddAction("t_wo_workorderbase", workOrderBaseModel.F_WORKORDERID.ToMyString(), "回访提交工单", workOrderBaseModel.F_CODE);
            AddAction("t_wo_workorderbase", workOrderBaseModel.F_WORKORDERID.ToMyString(), "回访提交工单", "数据：" + JsonConvert.SerializeObject(workOrderBaseModel), "关键信息");
            return orderBLL.SubmitOrderHF(workOrderBaseModel);
        }


        /// <summary>
        /// 待回访工单
        /// </summary>
        /// <param name="page">当前页码</param>
        /// <param name="limit">每页数据量</param>
        /// <param name="sqlWhere">查询条件</param>
        /// <returns></returns>
        [ActionName("WorkOrderMyDataHF")]
        [HttpGet]
        public string WorkOrderMyDataHF(DateTime? NowDateTime, int page, int limit, int? types, string dateParty,
            string workorderNum, string cusName, string phoneNumber,
            string userInfo, int? bussType, int? detailType, string Content)
        {

            //数据结果集
            ResponseData dataModel = new ResponseData();

            //F_FILEFLAG 业务类型ID
            //F_WORKORDERSTATEID   0未处理 1处理中  2已办结 status
            //F_WORKORDERTYPEID 处理方式  1转单 3客服处理 GoType
            //F_REPAIRMANID 接入渠道 1语音 2留言  3微信 4微博 FromType
            //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);

            string sql = string.Format(" and F_WORKORDERTYPEID=3 and F_WORKORDERSTATEID=3 and F_UserId={0}", F_UserID);


            //工单编号
            if (!string.IsNullOrEmpty(workorderNum))
            {
                sql += " and F_CODE like '%" + workorderNum.Trim() + "%'";
            }
            //客户姓名
            if (!string.IsNullOrEmpty(cusName))
            {
                sql += " and F_CUSTOMERNAME like '%" + cusName.Trim() + "%'";
            }
            //客户电话
            if (!string.IsNullOrEmpty(phoneNumber))
            {
                sql += " and F_CUSTOMERTELEPHONE like '%" + phoneNumber.Trim() + "%'";
            }
            //坐席工号
            if (!string.IsNullOrEmpty(userInfo))
            {
                sql += " and F_LINKMAN like '%" + userInfo.Trim() + "%'";
            }

            //业务类别
            if (bussType != null && bussType > 0)
            {
                sql += " and F_FILEFLAG =" + bussType;
            }
            //业务类型
            if (detailType != null && detailType > 0)
            {
                sql += " and F_REPAIRLEVEL =" + detailType;
            }
            //内容
            if (!string.IsNullOrEmpty(Content))
            {
                sql += " and F_CONTENT like '%" + Content.Trim() + "%'";
            }



            //查询按钮
            if (types == 0)
            {
                if (!string.IsNullOrEmpty(dateParty))
                {
                    string startDate = dateParty.Substring(0, 10);
                    string endDate = dateParty.Substring(12);
                    sql += " and F_CREATEDATE>= '" + startDate + " 00:00:00" + "'";
                    sql += " and F_CREATEDATE<= '" + endDate + " 23:59:59" + "'";

                }
            }//一周按钮
            else if (types == 1)
            {

                string endDate = DateTime.Now.ToString();
                string startDate = DateTime.Now.AddDays(-7).ToString();
                sql += " and F_CREATEDATE>= '" + startDate + "'";
                sql += " and F_CREATEDATE<= '" + endDate + "'";

            }//一月按钮
            else if (types == 2)
            {

                string endDate = DateTime.Now.ToString();
                string startDate = DateTime.Now.AddMonths(-1).ToString();
                sql += " and F_CREATEDATE>= '" + startDate + "'";
                sql += " and F_CREATEDATE<= '" + endDate + "'";

            }//一年按钮
            else if (types == 3)
            {

                string endDate = DateTime.Now.ToString();
                string startDate = DateTime.Now.AddYears(-1).ToString();
                sql += " and F_CREATEDATE>= '" + startDate + "'";
                sql += " and F_CREATEDATE<= '" + endDate + "'";

            }

            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",
              "*,CONVERT(varchar,F_CREATEDATE, 120 ) as F_CREATEDATENew"
              + @" , replace(replace(CASE F_WORKORDERFROM WHEN '留言工单' THEN (SELECT F_RecFileUrl FROM dbo.T_Call_LeaveRecord  WHERE F_CallId=F_KSHADDRESSCODE) WHEN '语音工单' THEN (SELECT FilePath FROM dbo.T_Call_CallRecords WHERE CallId=F_KSHADDRESSCODE AND FilePath!='') ELSE NULL END,'\','/'),'" + GetSysconfig("newFilePath") + "','" + GetSysconfig("newPlayPath") + "') as FilePath",
                //+ " ,(CASE F_WORKORDERFROM WHEN '留言工单' THEN (SELECT F_RecFileUrl FROM dbo.T_Call_LeaveRecord  WHERE F_CallId=F_KSHADDRESSCODE) WHEN '语音工单' THEN (SELECT FilePath FROM dbo.T_Call_CallRecords WHERE CallId=F_KSHADDRESSCODE AND FilePath!='') ELSE NULL END ) as FilePath",
                sql,
                "ORDER BY F_CREATEDATE desc",
                limit,
                page,
                true,
                out recordCount);


            dataModel.code = 0;
            dataModel.count = recordCount;
            dataModel.data = dt;

            return JsonConvert.SerializeObject(dataModel);
        }


        #endregion

        #region 待定责

        public string DZDeptList(int workid)
        {
            DataTable dt = null;
            DataSet ds = historyBll.GetListDZ(string.Format(" F_INSTANCEID={0} ", workid));
            if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
            {
                dt = ds.Tables[0];
            }
            ResponseData dataModel = new ResponseData();
            dataModel.code = 0;
            dataModel.count = 0;
            dataModel.data = dt;

            return JsonConvert.SerializeObject(dataModel);
        }

        /// <summary>
        /// 定责视图
        /// </summary>
        /// <param name="dtype">工单类型 1、所有待办工单 2、代办结工单</param>
        /// <returns></returns>
        public ActionResult WorkOrderMyListDZ(int dtype)
        {
            WorkOrderMyModel model = new WorkOrderMyModel();
            model.DType = dtype;
            //业务类型字典表
            model.WorkOrderTypeModelList = GetWorkTypeModelList();
            //话务标志
            model.SeatFlag = F_SeatFlag;
            return View(model);
        }

        /// <summary>
        /// 录入定责结果
        /// </summary>
        /// <param name="workOrderBaseModel"></param>
        /// <returns></returns>
        [AcceptVerbs(HttpVerbs.Post)]
        public bool SubmitOrderDZ(T_Wo_WorkOrderNoticeInput modelinput)
        {
            if (modelinput.orderid == 0)
            {
                return false;
            }
            #region 处理工单事件分类
            Model.T_Wo_WorkOrderBase modelorder = new T_Wo_WorkOrderBase();
            modelorder.F_WORKORDERID = modelinput.orderid;
            modelorder.F_PROVINCE = modelinput.ClassName1;
            modelorder.F_CITY = modelinput.ClassName2;
            modelorder.F_AREA = modelinput.ClassName3;
            #endregion
            if (modelinput.Noticelist != null && modelinput.Noticelist.Count > 0)
            {
                noticeBLL.updatenum(modelinput.orderid);
                foreach (T_Wo_WorkOrderNotice model in modelinput.Noticelist)
                {
                    T_Wo_WorkOrderNotice modeladd = new T_Wo_WorkOrderNotice();

                    #region 前端传入参数
                    modeladd.OrderId = modelinput.orderid;
                    modeladd.DealAdvise = model.DealAdvise;
                    modeladd.DealResult = model.DealResult;
                    modeladd.NoticeDeptId = model.NoticeDeptId;
                    modeladd.NoticeDeptName = model.NoticeDeptName;
                    modeladd.Class1 = modelorder.F_PROVINCE;
                    modeladd.Class2 = modelorder.F_CITY;
                    modeladd.Class3 = modelorder.F_AREA;
                    #endregion

                    modeladd.NoticeState = 1;
                    modeladd.NoticeType = 1;
                    modeladd.Userid = F_UserID;
                    modeladd.Username = F_UserName;
                    List<T_Wo_WorkOrderHistory> modelhisList = historyBll.GetModelList(string.Format(" F_INSTANCEID={0} AND F_OPTBTNID={1}", modeladd.OrderId, model.NoticeDeptId));
                    foreach (T_Wo_WorkOrderHistory modelhis in modelhisList)
                    {
                        modeladd.NoticeDeptContent += modelhis.F_REMARK;
                        modeladd.NoticeDeptAdvise += modelhis.F_REMARK;
                        modeladd.NoticeUserid = modelhis.F_OPTUSERID.ToInt32();
                        modeladd.NoticeUsername = modelhis.F_UserName;
                    }
                    noticeBLL.Add(modeladd);

                }
            }
            AddAction("t_wo_workorderbase", modelorder.F_WORKORDERID.ToMyString(), "提交定责工单", modelorder.F_CODE);
            AddAction("t_wo_workorderbase", modelorder.F_WORKORDERID.ToMyString(), "提交定责工单", "数据：" + JsonConvert.SerializeObject(modelorder), "关键信息");
            return orderBLL.UpdateDZClass(modelorder);
        }


        /// <summary>
        /// 待定责列表
        /// </summary>
        /// <param name="page">当前页码</param>
        /// <param name="limit">每页数据量</param>
        /// <param name="sqlWhere">查询条件</param>
        /// <returns></returns>
        [ActionName("WorkOrderMyDataDZ")]
        [HttpGet]
        public string WorkOrderMyDataDZ(DateTime? NowDateTime, int page, int limit, int? types, string dateParty,
            string workorderNum, string cusName, string phoneNumber,
            string userInfo, int? bussType, int? detailType, string Content)
        {

            //数据结果集
            ResponseData dataModel = new ResponseData();

            //F_FILEFLAG 业务类型ID
            //F_WORKORDERSTATEID   0未处理 1处理中  2已办结 status
            //F_WORKORDERTYPEID 处理方式  1转单 3客服处理 GoType
            //F_REPAIRMANID 接入渠道 1语音 2留言  3微信 4微博 FromType
            //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);

            string sql = string.Format(" and F_WORKORDERTYPEID=3 and F_WORKORDERSTATEID=4 and (F_HASTENCOUNTS=0 OR F_HASTENCOUNTS IS NULL) and (F_ROAD='{0}' Or F_ROAD='' Or F_ROAD IS NULL)", F_UserID);


            //工单编号
            if (!string.IsNullOrEmpty(workorderNum))
            {
                sql += " and F_CODE like '%" + workorderNum.Trim() + "%'";
            }
            //客户姓名
            if (!string.IsNullOrEmpty(cusName))
            {
                sql += " and F_CUSTOMERNAME like '%" + cusName.Trim() + "%'";
            }
            //客户电话
            if (!string.IsNullOrEmpty(phoneNumber))
            {
                sql += " and F_CUSTOMERTELEPHONE like '%" + phoneNumber.Trim() + "%'";
            }
            //坐席工号
            if (!string.IsNullOrEmpty(userInfo))
            {
                sql += " and F_LINKMAN like '%" + userInfo.Trim() + "%'";
            }

            //业务类别
            if (bussType != null && bussType > 0)
            {
                sql += " and F_FILEFLAG =" + bussType;
            }
            //业务类型
            if (detailType != null && detailType > 0)
            {
                sql += " and F_REPAIRLEVEL =" + detailType;
            }
            //内容
            if (!string.IsNullOrEmpty(Content))
            {
                sql += " and F_CONTENT like '%" + Content.Trim() + "%'";
            }



            //查询按钮
            if (types == 0)
            {
                if (!string.IsNullOrEmpty(dateParty))
                {
                    string startDate = dateParty.Substring(0, 10);
                    string endDate = dateParty.Substring(12);
                    sql += " and F_CREATEDATE>= '" + startDate + " 00:00:00" + "'";
                    sql += " and F_CREATEDATE<= '" + endDate + " 23:59:59" + "'";

                }
            }//一周按钮
            else if (types == 1)
            {

                string endDate = DateTime.Now.ToString();
                string startDate = DateTime.Now.AddDays(-7).ToString();
                sql += " and F_CREATEDATE>= '" + startDate + "'";
                sql += " and F_CREATEDATE<= '" + endDate + "'";

            }//一月按钮
            else if (types == 2)
            {

                string endDate = DateTime.Now.ToString();
                string startDate = DateTime.Now.AddMonths(-1).ToString();
                sql += " and F_CREATEDATE>= '" + startDate + "'";
                sql += " and F_CREATEDATE<= '" + endDate + "'";

            }//一年按钮
            else if (types == 3)
            {

                string endDate = DateTime.Now.ToString();
                string startDate = DateTime.Now.AddYears(-1).ToString();
                sql += " and F_CREATEDATE>= '" + startDate + "'";
                sql += " and F_CREATEDATE<= '" + endDate + "'";

            }

            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",
              "*,CONVERT(varchar,F_CREATEDATE, 120 ) as F_CREATEDATENew"
              + @" , replace(replace(CASE F_WORKORDERFROM WHEN '留言工单' THEN (SELECT F_RecFileUrl FROM dbo.T_Call_LeaveRecord  WHERE F_CallId=F_KSHADDRESSCODE) WHEN '语音工单' THEN (SELECT FilePath FROM dbo.T_Call_CallRecords WHERE CallId=F_KSHADDRESSCODE AND FilePath!='') ELSE NULL END,'\','/'),'" + GetSysconfig("newFilePath") + "','" + GetSysconfig("newPlayPath") + "') as FilePath",
                //+ " ,(CASE F_WORKORDERFROM WHEN '留言工单' THEN (SELECT F_RecFileUrl FROM dbo.T_Call_LeaveRecord  WHERE F_CallId=F_KSHADDRESSCODE) WHEN '语音工单' THEN (SELECT FilePath FROM dbo.T_Call_CallRecords WHERE CallId=F_KSHADDRESSCODE AND FilePath!='') ELSE NULL END ) as FilePath",
                sql,
                "ORDER BY F_CREATEDATE desc",
                limit,
                page,
                true,
                out recordCount);


            dataModel.code = 0;
            dataModel.count = recordCount;
            dataModel.data = dt;

            return JsonConvert.SerializeObject(dataModel);
        }

        [AcceptVerbs(HttpVerbs.Post)]
        public bool canDZ(int workid)
        {
            int n = orderBLL.GetRecordCount(string.Format("F_ROAD='{0}' AND F_WORKORDERID={1}", F_UserID, workid));
            if (n > 0)
                return true;
            else
            {
                Model.T_Wo_WorkOrderBase model = new T_Wo_WorkOrderBase();
                model.F_WORKORDERID = workid;
                model.F_ROAD = F_UserID.ToMyString();
                return orderBLL.UpdateDZuser(model);
            }
        }



        #endregion

        #region 已定责

        /// <summary>
        /// 已定责视图
        /// </summary>
        /// <param name="dtype">工单类型 1、所有待办工单 2、代办结工单</param>
        /// <returns></returns>
        public ActionResult WorkOrderMyListDZ1(int dtype)
        {
            WorkOrderMyModel model = new WorkOrderMyModel();
            model.DType = dtype;
            //业务类型字典表
            model.WorkOrderTypeModelList = GetWorkTypeModelList();
            //话务标志
            model.SeatFlag = F_SeatFlag;
            return View(model);
        }

        /// <summary>
        /// 录入定责结果
        /// </summary>
        /// <param name="workOrderBaseModel"></param>
        /// <returns></returns>
        [AcceptVerbs(HttpVerbs.Post)]
        public bool SubmitOrderDZ1(T_Wo_WorkOrderNoticeInput modelinput)
        {
            if (modelinput.orderid == 0)
            {
                return false;
            }
            #region 处理工单事件分类
            Model.T_Wo_WorkOrderBase modelorder = new T_Wo_WorkOrderBase();
            modelorder.F_WORKORDERID = modelinput.orderid;
            modelorder.F_PROVINCE = modelinput.ClassName1;
            modelorder.F_CITY = modelinput.ClassName2;
            modelorder.F_AREA = modelinput.ClassName3;
            #endregion
            if (modelinput.Noticelist != null)
            {
                noticeBLL.updatenum(modelinput.orderid);
                foreach (T_Wo_WorkOrderNotice model in modelinput.Noticelist)
                {
                    T_Wo_WorkOrderNotice modeladd = new T_Wo_WorkOrderNotice();

                    #region 前端传入参数
                    modeladd.OrderId = modelinput.orderid;
                    modeladd.DealAdvise = model.DealAdvise;
                    modeladd.DealResult = model.DealResult;
                    modeladd.NoticeDeptId = model.NoticeDeptId;
                    modeladd.NoticeDeptName = model.NoticeDeptName;

                    #endregion

                    modeladd.NoticeState = 1;
                    modeladd.NoticeType = 1;
                    modeladd.Userid = F_UserID;
                    modeladd.Username = F_UserName;
                    List<T_Wo_WorkOrderHistory> modelhisList = historyBll.GetModelList(string.Format(" F_INSTANCEID={0} AND F_OPTBTNID={1}", model.OrderId, model.NoticeDeptId));
                    foreach (T_Wo_WorkOrderHistory modelhis in modelhisList)
                    {
                        modeladd.NoticeDeptContent += modelhis.F_REMARK;
                        modeladd.NoticeDeptAdvise += modelhis.F_REMARK;
                        modeladd.NoticeUserid = modelhis.F_OPTUSERID.ToInt32();
                        modeladd.NoticeUsername = modelhis.F_UserName;
                    }
                    noticeBLL.Add(modeladd);

                }
            }
            return orderBLL.UpdateDZClass(modelorder);
        }


        /// <summary>
        /// 已定责列表
        /// </summary>
        /// <param name="page">当前页码</param>
        /// <param name="limit">每页数据量</param>
        /// <param name="sqlWhere">查询条件</param>
        /// <returns></returns>
        [ActionName("WorkOrderMyDataDZ1")]
        [HttpGet]
        public string WorkOrderMyDataDZ1(DateTime? NowDateTime, int page, int limit, int? types, string dateParty,
            string workorderNum, string cusName, string phoneNumber,
            string userInfo, int? bussType, int? detailType, string Content)
        {

            //数据结果集
            ResponseData dataModel = new ResponseData();

            //F_FILEFLAG 业务类型ID
            //F_WORKORDERSTATEID   0未处理 1处理中  2已办结 status
            //F_WORKORDERTYPEID 处理方式  1转单 3客服处理 GoType
            //F_REPAIRMANID 接入渠道 1语音 2留言  3微信 4微博 FromType
            //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);

            string sql = string.Format(" and F_WORKORDERTYPEID=3 and F_WORKORDERSTATEID=5 and F_ROAD='{0}'", F_UserID);


            //工单编号
            if (!string.IsNullOrEmpty(workorderNum))
            {
                sql += " and F_CODE like '%" + workorderNum.Trim() + "%'";
            }
            //客户姓名
            if (!string.IsNullOrEmpty(cusName))
            {
                sql += " and F_CUSTOMERNAME like '%" + cusName.Trim() + "%'";
            }
            //客户电话
            if (!string.IsNullOrEmpty(phoneNumber))
            {
                sql += " and F_CUSTOMERTELEPHONE like '%" + phoneNumber.Trim() + "%'";
            }
            //坐席工号
            if (!string.IsNullOrEmpty(userInfo))
            {
                sql += " and F_LINKMAN like '%" + userInfo.Trim() + "%'";
            }

            //业务类别
            if (bussType != null && bussType > 0)
            {
                sql += " and F_FILEFLAG =" + bussType;
            }
            //业务类型
            if (detailType != null && detailType > 0)
            {
                sql += " and F_REPAIRLEVEL =" + detailType;
            }
            //内容
            if (!string.IsNullOrEmpty(Content))
            {
                sql += " and F_CONTENT like '%" + Content.Trim() + "%'";
            }



            //查询按钮
            if (types == 0)
            {
                if (!string.IsNullOrEmpty(dateParty))
                {
                    string startDate = dateParty.Substring(0, 10);
                    string endDate = dateParty.Substring(12);
                    sql += " and F_CREATEDATE>= '" + startDate + " 00:00:00" + "'";
                    sql += " and F_CREATEDATE<= '" + endDate + " 23:59:59" + "'";

                }
            }//一周按钮
            else if (types == 1)
            {

                string endDate = DateTime.Now.ToString();
                string startDate = DateTime.Now.AddDays(-7).ToString();
                sql += " and F_CREATEDATE>= '" + startDate + "'";
                sql += " and F_CREATEDATE<= '" + endDate + "'";

            }//一月按钮
            else if (types == 2)
            {

                string endDate = DateTime.Now.ToString();
                string startDate = DateTime.Now.AddMonths(-1).ToString();
                sql += " and F_CREATEDATE>= '" + startDate + "'";
                sql += " and F_CREATEDATE<= '" + endDate + "'";

            }//一年按钮
            else if (types == 3)
            {

                string endDate = DateTime.Now.ToString();
                string startDate = DateTime.Now.AddYears(-1).ToString();
                sql += " and F_CREATEDATE>= '" + startDate + "'";
                sql += " and F_CREATEDATE<= '" + endDate + "'";

            }

            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",
              "*,CONVERT(varchar,F_CREATEDATE, 120 ) as F_CREATEDATENew"
              + @" , replace(replace(CASE F_WORKORDERFROM WHEN '留言工单' THEN (SELECT F_RecFileUrl FROM dbo.T_Call_LeaveRecord  WHERE F_CallId=F_KSHADDRESSCODE) WHEN '语音工单' THEN (SELECT FilePath FROM dbo.T_Call_CallRecords WHERE CallId=F_KSHADDRESSCODE AND FilePath!='') ELSE NULL END,'\','/'),'" + GetSysconfig("newFilePath") + "','" + GetSysconfig("newPlayPath") + "') as FilePath",
                //+ " ,(CASE F_WORKORDERFROM WHEN '留言工单' THEN (SELECT F_RecFileUrl FROM dbo.T_Call_LeaveRecord  WHERE F_CallId=F_KSHADDRESSCODE) WHEN '语音工单' THEN (SELECT FilePath FROM dbo.T_Call_CallRecords WHERE CallId=F_KSHADDRESSCODE AND FilePath!='') ELSE NULL END ) as FilePath",
                sql,
                "ORDER BY F_CREATEDATE desc",
                limit,
                page,
                true,
                out recordCount);


            dataModel.code = 0;
            dataModel.count = recordCount;
            dataModel.data = dt;

            return JsonConvert.SerializeObject(dataModel);
        }

        #endregion 

        #region 相关通知

        /// <summary>
        /// 已定责视图
        /// </summary>
        /// <param name="dtype">工单类型 1、所有待办工单 2、代办结工单</param>
        /// <returns></returns>
        public ActionResult WorkOrderMyListNotice(int dtype)
        {
            WorkOrderMyModel model = new WorkOrderMyModel();
            model.DType = dtype;
            //业务类型字典表
            model.WorkOrderTypeModelList = GetWorkTypeModelList();
            //话务标志
            model.SeatFlag = F_SeatFlag;
            return View(model);
        }


        /// <summary>
        /// 相关表扬
        /// </summary>
        /// <param name="page">当前页码</param>
        /// <param name="limit">每页数据量</param>
        /// <param name="sqlWhere">查询条件</param>
        /// <returns></returns>
        [ActionName("WorkOrderMyDataNotice")]
        [HttpGet]
        public string WorkOrderMyDataNotice(DateTime? NowDateTime, int page, int limit, int? types, string dateParty,
            string workorderNum, string cusName, string phoneNumber,
            string userInfo, int? bussType, int? detailType, string Content, int NoticeType)
        {

            //数据结果集
            ResponseData dataModel = new ResponseData();

            //F_FILEFLAG 业务类型ID
            //F_WORKORDERSTATEID   0未处理 1处理中  2已办结 status
            //F_WORKORDERTYPEID 处理方式  1转单 3客服处理 GoType
            //F_REPAIRMANID 接入渠道 1语音 2留言  3微信 4微博 FromType
            //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);

            string sql = " and F_WORKORDERTYPEID=3 and F_WORKORDERSTATEID=5 ";
            if(NoticeType==0)
                sql= " and F_WORKORDERTYPEID=3 and F_WORKORDERSTATEID=2 ";

            //工单编号
            if (!string.IsNullOrEmpty(workorderNum))
            {
                sql += " and F_CODE like '%" + workorderNum.Trim() + "%'";
            }
            //客户姓名
            if (!string.IsNullOrEmpty(cusName))
            {
                sql += " and F_CUSTOMERNAME like '%" + cusName.Trim() + "%'";
            }
            //客户电话
            if (!string.IsNullOrEmpty(phoneNumber))
            {
                sql += " and F_CUSTOMERTELEPHONE like '%" + phoneNumber.Trim() + "%'";
            }
            //坐席工号
            if (!string.IsNullOrEmpty(userInfo))
            {
                sql += " and F_LINKMAN like '%" + userInfo.Trim() + "%'";
            }

            //业务类别
            if (bussType != null && bussType > 0)
            {
                sql += " and F_FILEFLAG =" + bussType;
            }
            //业务类型
            if (detailType != null && detailType > 0)
            {
                sql += " and F_REPAIRLEVEL =" + detailType;
            }
            //内容
            if (!string.IsNullOrEmpty(Content))
            {
                sql += " and F_CONTENT like '%" + Content.Trim() + "%'";
            }



            //查询按钮
            if (types == 0)
            {
                if (!string.IsNullOrEmpty(dateParty))
                {
                    string startDate = dateParty.Substring(0, 10);
                    string endDate = dateParty.Substring(12);
                    sql += " and F_CREATEDATE>= '" + startDate + " 00:00:00" + "'";
                    sql += " and F_CREATEDATE<= '" + endDate + " 23:59:59" + "'";

                }
            }//一周按钮
            else if (types == 1)
            {

                string endDate = DateTime.Now.ToString();
                string startDate = DateTime.Now.AddDays(-7).ToString();
                sql += " and F_CREATEDATE>= '" + startDate + "'";
                sql += " and F_CREATEDATE<= '" + endDate + "'";

            }//一月按钮
            else if (types == 2)
            {

                string endDate = DateTime.Now.ToString();
                string startDate = DateTime.Now.AddMonths(-1).ToString();
                sql += " and F_CREATEDATE>= '" + startDate + "'";
                sql += " and F_CREATEDATE<= '" + endDate + "'";

            }//一年按钮
            else if (types == 3)
            {

                string endDate = DateTime.Now.ToString();
                string startDate = DateTime.Now.AddYears(-1).ToString();
                sql += " and F_CREATEDATE>= '" + startDate + "'";
                sql += " and F_CREATEDATE<= '" + endDate + "'";

            }

            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(
                string.Format(" T_Wo_WorkOrderBase T1 Inner join T_Wo_WorkOrderNotice T2 On T1.F_WORKORDERID=T2.OrderId AND T2.NoticeDeptId={0} AND NoticeType={1} AND  NoticeState=1", F_DeptId, NoticeType),
                "F_WORKORDERID",
              "*,CONVERT(varchar,F_CREATEDATE, 120 ) as F_CREATEDATENew,NoticeDeptId,NoticeDeptName"
              + @" , replace(replace(CASE F_WORKORDERFROM WHEN '留言工单' THEN (SELECT F_RecFileUrl FROM dbo.T_Call_LeaveRecord  WHERE F_CallId=F_KSHADDRESSCODE) WHEN '语音工单' THEN (SELECT FilePath FROM dbo.T_Call_CallRecords WHERE CallId=F_KSHADDRESSCODE AND FilePath!='') ELSE NULL END,'\','/'),'" + GetSysconfig("newFilePath") + "','" + GetSysconfig("newPlayPath") + "') as FilePath",
                //+ " ,(CASE F_WORKORDERFROM WHEN '留言工单' THEN (SELECT F_RecFileUrl FROM dbo.T_Call_LeaveRecord  WHERE F_CallId=F_KSHADDRESSCODE) WHEN '语音工单' THEN (SELECT FilePath FROM dbo.T_Call_CallRecords WHERE CallId=F_KSHADDRESSCODE AND FilePath!='') ELSE NULL END ) as FilePath",
                sql,
                "ORDER BY F_CREATEDATE desc",
                limit,
                page,
                true,
                out recordCount);


            dataModel.code = 0;
            dataModel.count = recordCount;
            dataModel.data = dt;

            return JsonConvert.SerializeObject(dataModel);
        }

        #endregion

        #region 超时工单

        /// <summary>
        /// 视图
        /// </summary>
        /// <param name="dtype">工单类型 1、所有待办工单 2、代办结工单</param>
        /// <returns></returns>
        public ActionResult OverOrderView(int dtype=0)
        {
            CallScreenModel callScreenModel = new CallScreenModel();
            //业务类型字典表
            callScreenModel.WorkOrderTypeModelList = GetWorkTypeModelList();

            //业务类型字典表
            callScreenModel.GoTypeModelList = GetCodeType("CLFS");
            //话务标志
            callScreenModel.SeatFlag = F_SeatFlag;

            //1、所有工单页面2、工单编辑页面
              callScreenModel.OrderType = 1;



            return View(callScreenModel);
        }


        /// <summary>
        /// 获取工单信息
        /// </summary>
        /// <param name="page">当前页码</param>
        /// <param name="limit">每页数据量</param>
        /// <param name="sqlWhere">查询条件</param>
        /// <returns></returns>
        [ActionName("OverOrderData")]
        [HttpGet]
        public string OverOrderData(DateTime? NowDateTime, int page, int limit, int? types, string dateParty,
            string workorderNum, string cusName, string phoneNumber, string userInfo, int? status, int? bussType, int? detailType, string Content, int? GoType, int? FromType,int? overtime)
        {

            //数据结果集
            ResponseData dataModel = new ResponseData();

            string sql = "";

            //工单编号
            if (!string.IsNullOrEmpty(workorderNum))
            {
                sql += " and t.F_CODE like '%" + workorderNum.Trim() + "%'";
            }
            //客户姓名
            if (!string.IsNullOrEmpty(cusName))
            {
                sql += " and t.F_CUSTOMERNAME like '%" + cusName.Trim() + "%'";
            }

            //客户电话
            if (!string.IsNullOrEmpty(phoneNumber))
            {
                sql += " and t.F_CUSTOMERTELEPHONE like '%" + phoneNumber.Trim() + "%'";
            }
            //坐席工号
            if (!string.IsNullOrEmpty(userInfo))
            {
                sql += " and t.F_LINKMAN like '%" + userInfo.Trim() + "%'";
            }
            //状态  F_WORKORDERSTATEID   0未处理 1处理中  2已办结
            if (status != null)
            {
                sql += " and t.F_WORKORDERSTATEID =" + status;
            }
            //业务类别
            if (bussType != null && bussType > 0)
            {
                sql += " and t.F_FILEFLAG =" + bussType;
            }
            //业务类型
            if (detailType != null && detailType > 0)
            {
                sql += " and t.F_REPAIRLEVEL =" + detailType;
            }
            //定责次数
            //if (F_HASTENCOUNTS != null)
            //{
            //    if (F_HASTENCOUNTS == 0)
            //    {
            //        sql += " AND (t.F_HASTENCOUNTS is null OR  t.F_HASTENCOUNTS =0) ";
            //    }
            //    else
            //    {
            //        sql += " AND  t.F_HASTENCOUNTS >0 ";
            //    }
            //}
            //定责次数
            if (overtime != null)
            {
                if (overtime == 0)
                {
                    sql += " AND t.F_OVERTIMES<0 ";
                }
                else
                {
                    sql += " AND  t.F_OVERTIMES>0 ";
                }
            }
            //内容
            if (!string.IsNullOrEmpty(Content))
            {
                sql += " and t.F_CONTENT like '%" + Content.Trim() + "%'";
            }
            //处理方式  F_WORKORDERTYPEID  处理方式  1转单 3客服处理
            if (GoType != null && GoType > 0)
            {
                sql += " and t.F_WORKORDERTYPEID =" + GoType;
            }
            //接入渠道 1语音 2留言  3微信 4微博
            if (FromType != null && FromType > 0)
            {
                sql += " and t.F_REPAIRMANID =" + FromType;
            }


            //查询按钮
            if (types == 0 || types == null)
            {
                if (!string.IsNullOrEmpty(dateParty))
                {

                    string startDate = dateParty.Substring(0, 10);
                    string endDate = dateParty.Substring(12);
                    sql += " and t.F_CREATEDATE>= '" + startDate + " 00:00:00" + "'";
                    sql += " and t.F_CREATEDATE<= '" + endDate + " 23:59:59" + "'";
                }
                else
                {
                    string endDate = DateTime.Now.ToString("yyyy-MM-dd");
                    string startDate = DateTime.Now.ToString("yyyy-MM-dd");
                    sql += " and t.F_CREATEDATE>= '" + startDate + " 00:00:00" + "'";
                    sql += " and t.F_CREATEDATE<= '" + endDate + " 23:59:59" + "'";
                }
            }//一周按钮
            else if (types == 1)
            {

                string endDate = DateTime.Now.ToString("yyyy-MM-dd");
                string startDate = DateTime.Now.AddDays(-7).ToString("yyyy-MM-dd");
                sql += " and t.F_CREATEDATE>= '" + startDate + " 00:00:00" + "'";
                sql += " and t.F_CREATEDATE<= '" + endDate + " 23:59:59" + "'";

            }//一月按钮
            else if (types == 2)
            {

                string endDate = DateTime.Now.ToString("yyyy-MM-dd");
                string startDate = DateTime.Now.AddMonths(-1).ToString("yyyy-MM-dd");
                sql += " and t.F_CREATEDATE>= '" + startDate + " 00:00:00" + "'";
                sql += " and t.F_CREATEDATE<= '" + endDate + " 23:59:59" + "'";

            }//一年按钮
            else if (types == 3)
            {

                string endDate = DateTime.Now.ToString("yyyy-MM-dd");
                string startDate = DateTime.Now.AddYears(-1).ToString("yyyy-MM-dd");
                sql += " and t.F_CREATEDATE>= '" + startDate + " 00:00:00" + "'";
                sql += " and t.F_CREATEDATE<= '" + endDate + " 23:59:59" + "'";

            }
            //一天按钮
            else if (types == 4)
            {
                string endDate = DateTime.Now.ToString("yyyy-MM-dd");
                string startDate = DateTime.Now.ToString("yyyy-MM-dd");
                sql += " and t.F_CREATEDATE>= '" + startDate + " 00:00:00" + "'";
                sql += " and t.F_CREATEDATE<= '" + endDate + " 23:59:59" + "'";

            }
            string tableNew = string.Format("(select DISTINCT t.*  from T_Wo_WorkOrderBase t LEFT JOIN T_Wo_WorkOrderHistory h ON t.F_WORKORDERID=h.F_INSTANCEID LEFT JOIN T_Sys_UserAccount u ON  t.F_USERID= u.F_UserId  where  (u.F_DeptId={0} OR  h.F_OPTBTNID={0})) as t", F_DeptId);
            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(
                tableNew,
                "F_WORKORDERID",
                " t.*,CONVERT(varchar,t.F_CREATEDATE, 120 ) as F_CREATEDATENew,CONVERT(VARCHAR(10),F_OVERTIMES/3600)+'时'+CONVERT(VARCHAR(10),F_OVERTIMES%3600/60)+'分'+CONVERT(VARCHAR(10),F_OVERTIMES%3600%60)+'秒' AS F_OVERTIME"
                  + @" , replace(replace(CASE F_WORKORDERFROM WHEN '留言工单' THEN (SELECT top 1  F_RecFileUrl FROM dbo.T_Call_LeaveRecord  WHERE F_CallId=t.F_KSHADDRESSCODE) WHEN '语音工单' THEN (SELECT  top 1 FilePath FROM dbo.T_Call_CallRecords WHERE CallId=t.F_KSHADDRESSCODE) ELSE NULL END,'\','/'),'" + GetSysconfig("newFilePath") + "','" + GetSysconfig("newPlayPath") + "') as FilePath"
,
                sql,
                "ORDER BY t.F_CREATEDATE desc",
                limit,
                page,
                true,
                out recordCount);


            dataModel.code = 0;
            dataModel.count = recordCount;
            dataModel.data = dt;

            return JsonConvert.SerializeObject(dataModel);
        }

        #endregion

        #region 全部工单

        /// <summary>
        /// 获取所有工单信息
        /// </summary>
        /// <returns></returns>
        public ActionResult WorkOrderAllList(int? orderType)
        {
            CallScreenModel callScreenModel = new CallScreenModel();
            //业务类型字典表
            callScreenModel.WorkOrderTypeModelList = GetWorkTypeModelList();

            //业务类型字典表
            callScreenModel.GoTypeModelList = GetCodeType("CLFS");
            //话务标志
            callScreenModel.SeatFlag = F_SeatFlag;

            //1、所有工单页面2、工单编辑页面
            if (orderType != null && orderType > 0)
            {
                callScreenModel.OrderType = int.Parse(orderType.ToString());
            }
            else
            {
                callScreenModel.OrderType = 1;
            }


            return View(callScreenModel);
        }


        /// <summary>
        /// 获取工单信息
        /// </summary>
        /// <param name="page">当前页码</param>
        /// <param name="limit">每页数据量</param>
        /// <param name="sqlWhere">查询条件</param>
        /// <returns></returns>
        [ActionName("WorkOrderAllData")]
        [HttpGet]
        public string WorkOrderAllList(DateTime? NowDateTime, int page, int limit, int? types, string dateParty,
            string workorderNum, string cusName, string phoneNumber, string userInfo, int? status, int? bussType, int? detailType, string Content, int? GoType, int? FromType, int? F_HASTENCOUNTS )
        {

            //数据结果集
            ResponseData dataModel = new ResponseData();

            string sql = "";

            //工单编号
            if (!string.IsNullOrEmpty(workorderNum))
            {
                sql += " and t.F_CODE like '%" + workorderNum.Trim() + "%'";
            }
            //客户姓名
            if (!string.IsNullOrEmpty(cusName))
            {
                sql += " and t.F_CUSTOMERNAME like '%" + cusName.Trim() + "%'";
            }

            //客户电话
            if (!string.IsNullOrEmpty(phoneNumber))
            {
                sql += " and t.F_CUSTOMERTELEPHONE like '%" + phoneNumber.Trim() + "%'";
            }
            //坐席工号
            if (!string.IsNullOrEmpty(userInfo))
            {
                sql += " and t.F_LINKMAN like '%" + userInfo.Trim() + "%'";
            }
            //状态  F_WORKORDERSTATEID   0未处理 1处理中  2已办结（结束） 3待回访 4待定责 5已定责
            if (status != null)
            {
                sql += " and t.F_WORKORDERSTATEID =" + status;
            }
            //业务类别
            if (bussType != null && bussType > 0)
            {
                sql += " and t.F_FILEFLAG =" + bussType;
            }
            //业务类型
            if (detailType != null && detailType > 0)
            {
                sql += " and t.F_REPAIRLEVEL =" + detailType;
            }
            //定责次数
            //if (F_HASTENCOUNTS != null)
            //{
            //    if (F_HASTENCOUNTS == 0)
            //    { 
            //        sql += " AND (t.F_HASTENCOUNTS is null OR  t.F_HASTENCOUNTS =0) ";
            //    }
            //    else
            //    {
            //        sql += " AND  t.F_HASTENCOUNTS >0 ";
            //    }
            //}
            //内容
            if (!string.IsNullOrEmpty(Content))
            {
                sql += " and t.F_CONTENT like '%" + Content.Trim() + "%'";
            }
            //处理方式  F_WORKORDERTYPEID  处理方式  1转单 3客服处理
            if (GoType != null && GoType > 0)
            {
                sql += " and t.F_WORKORDERTYPEID =" + GoType;
            }
            //接入渠道 1语音 2留言  3微信 4微博
            if (FromType != null && FromType > 0)
            {
                sql += " and t.F_REPAIRMANID =" + FromType;
            }


            //查询按钮
            if (types == 0 || types == null)
            {
                if (!string.IsNullOrEmpty(dateParty))
                {

                    string startDate = dateParty.Substring(0, 10);
                    string endDate = dateParty.Substring(12);
                    sql += " and t.F_CREATEDATE>= '" + startDate + " 00:00:00" + "'";
                    sql += " and t.F_CREATEDATE<= '" + endDate + " 23:59:59" + "'";
                }
                else
                {
                    string endDate = DateTime.Now.ToString("yyyy-MM-dd");
                    string startDate = DateTime.Now.ToString("yyyy-MM-dd");
                    sql += " and t.F_CREATEDATE>= '" + startDate + " 00:00:00" + "'";
                    sql += " and t.F_CREATEDATE<= '" + endDate + " 23:59:59" + "'";
                }
            }//一周按钮
            else if (types == 1)
            {

                string endDate = DateTime.Now.ToString("yyyy-MM-dd");
                string startDate = DateTime.Now.AddDays(-7).ToString("yyyy-MM-dd");
                sql += " and t.F_CREATEDATE>= '" + startDate + " 00:00:00" + "'";
                sql += " and t.F_CREATEDATE<= '" + endDate + " 23:59:59" + "'";

            }//一月按钮
            else if (types == 2)
            {

                string endDate = DateTime.Now.ToString("yyyy-MM-dd");
                string startDate = DateTime.Now.AddMonths(-1).ToString("yyyy-MM-dd");
                sql += " and t.F_CREATEDATE>= '" + startDate + " 00:00:00" + "'";
                sql += " and t.F_CREATEDATE<= '" + endDate + " 23:59:59" + "'";

            }//一年按钮
            else if (types == 3)
            {

                string endDate = DateTime.Now.ToString("yyyy-MM-dd");
                string startDate = DateTime.Now.AddYears(-1).ToString("yyyy-MM-dd");
                sql += " and t.F_CREATEDATE>= '" + startDate + " 00:00:00" + "'";
                sql += " and t.F_CREATEDATE<= '" + endDate + " 23:59:59" + "'";

            }
            //一天按钮
            else if (types == 4)
            {
                string endDate = DateTime.Now.ToString("yyyy-MM-dd");
                string startDate = DateTime.Now.ToString("yyyy-MM-dd");
                sql += " and t.F_CREATEDATE>= '" + startDate + " 00:00:00" + "'";
                sql += " and t.F_CREATEDATE<= '" + endDate + " 23:59:59" + "'";

            }
            string tableNew = string.Format("(select DISTINCT t.*  from T_Wo_WorkOrderBase t LEFT JOIN T_Wo_WorkOrderHistory h ON t.F_WORKORDERID=h.F_INSTANCEID LEFT JOIN T_Sys_UserAccount u ON  t.F_USERID= u.F_UserId  where  (u.F_DeptId={0} OR  h.F_OPTBTNID={0})) as t", F_DeptId);
            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(
                tableNew,
                "F_WORKORDERID",
                " t.*,CONVERT(varchar,t.F_CREATEDATE, 120 ) as F_CREATEDATENew"
                  + @" , replace(replace(CASE F_WORKORDERFROM WHEN '留言工单' THEN (SELECT top 1  F_RecFileUrl FROM dbo.T_Call_LeaveRecord  WHERE F_CallId=t.F_KSHADDRESSCODE) WHEN '语音工单' THEN (SELECT  top 1 FilePath FROM dbo.T_Call_CallRecords WHERE CallId=t.F_KSHADDRESSCODE) ELSE NULL END,'\','/'),'" + GetSysconfig("newFilePath") + "','" + GetSysconfig("newPlayPath") + "') as FilePath"
,
                sql,
                "ORDER BY t.F_CREATEDATE desc",
                limit,
                page,
                true,
                out recordCount);


            dataModel.code = 0;
            dataModel.count = recordCount;
            dataModel.data = dt;

            return JsonConvert.SerializeObject(dataModel);
        }

        #endregion


        #region 公共

        /// <summary>
        /// 获取二级业务类型
        /// </summary>
        /// <param name="deptId">业务类别</param>
        /// <returns></returns>
        public string GetBussType(int? bussnessType)
        {

            try
            {
                if (bussnessType != null && bussnessType > 0)
                {
                    List<Model.T_Wo_WorkOrderType> modelList = GetWorkTypeModelList();
                    return JsonConvert.SerializeObject(modelList.Where(t => t.F_WorkOrderTypeId == bussnessType).ToList()[0].WorkTypeModelList);
                }
                else
                {
                    return null;
                }
            }
            catch (Exception ex)
            {

            }
            return null;

        }



        /// <summary>
        /// 导出数据
        /// </summary>
        /// <param name="page">当前页码</param>
        /// <param name="limit">每页数据量</param>
        /// <param name="sqlWhere">查询条件</param>
        /// <returns></returns>
        [AcceptVerbs(HttpVerbs.Post)]
        public string ExToExcel(ExToExcel paramModel)
        {

            //数据结果集
            ResponseData dataModel = new ResponseData();

            string sql = "";

            //工单编号
            if (!string.IsNullOrEmpty(paramModel.workorderNum))
            {
                sql += " and t.F_CODE like '%" + paramModel.workorderNum.Trim() + "%'";
            }
            //客户姓名
            if (!string.IsNullOrEmpty(paramModel.cusName))
            {
                sql += " and t.F_CUSTOMERNAME like '%" + paramModel.cusName.Trim() + "%'";
            }
            //客户电话
            if (!string.IsNullOrEmpty(paramModel.phoneNumber))
            {
                sql += " and t.F_CUSTOMERTELEPHONE like '%" + paramModel.phoneNumber.Trim() + "%'";
            }
            //坐席工号
            if (!string.IsNullOrEmpty(paramModel.userInfo))
            {
                sql += " and t.F_LINKMAN like '%" + paramModel.userInfo.Trim() + "%'";
            }
            //状态
            if (paramModel.status != null)
            {
                sql += " and t.F_WORKORDERSTATEID =" + paramModel.status;
            }
            //业务类别
            if (paramModel.bussType != null && paramModel.bussType > 0)
            {
                sql += " and t.F_FILEFLAG =" + paramModel.bussType;
            }
            //业务类型
            if (paramModel.detailType != null && paramModel.detailType > 0)
            {
                sql += " and t.F_REPAIRLEVEL =" + paramModel.detailType;
            }
            //内容
            if (!string.IsNullOrEmpty(paramModel.Content))
            {
                sql += " and t.F_CONTENT like '%" + paramModel.Content.Trim() + "%'";
            }
            //处理方式
            if (paramModel.GoType != null && paramModel.GoType > 0)
            {
                sql += " and t.F_WORKORDERTYPEID =" + paramModel.GoType;
            }
            //渠道
            if (paramModel.FromType != null && paramModel.FromType > 0)
            {
                sql += " and t.F_REPAIRMANID =" + paramModel.FromType;
            }



            //查询按钮

            if (!string.IsNullOrEmpty(paramModel.dateParty))
            {

                string startDate = paramModel.dateParty.Substring(0, 10);
                string endDate = paramModel.dateParty.Substring(12);
                sql += " and t.F_CREATEDATE>= '" + startDate + " 00:00:00" + "'";
                sql += " and t.F_CREATEDATE<= '" + endDate + " 23:59:59" + "'";

            }

            string tableNew = string.Format("(select DISTINCT t.*  from T_Wo_WorkOrderBase t LEFT JOIN T_Wo_WorkOrderHistory h ON t.F_WORKORDERID=h.F_INSTANCEID LEFT JOIN T_Sys_UserAccount u ON  t.F_USERID= u.F_UserId  where  (u.F_DeptId={0} OR  h.F_OPTBTNID={0})) as t", F_DeptId);
            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(
                tableNew,
                "F_WORKORDERID",
                " t.F_CODE as 工单编号"
                 + ",F_CUSTOMERNAME as 客户姓名"
                   + ",F_CUSTOMERTELEPHONE as 客户电话"
                     + ",F_LINKMAN as 坐席工号"
                          + ",F_REPAIRMANNAME as 坐席姓名"
                               + ",F_WORKORDERFROM as 接入渠道"
                                  + " , CONVERT(varchar, t.F_CREATEDATE, 120) as 受理时间"
                                    + ",F_REPAIRREQUEST as 业务状态"
                                         + ",F_CONTENT as 内容"
                                           + ",F_RETURNVISITCONTENT as 处理回复内容"
                                               + ",F_HOUSING as 业务类型"
                                                 + ",F_ADSLACCOUNT as 业务明细"

                ,
                sql,
                "ORDER BY t.F_CREATEDATE desc",
                100000,
                1,
                true,
                out recordCount);

            ResponseDataModel NewData = new ResponseDataModel();

            ExcelReadWrite erw = new ExcelReadWrite();
            byte[] Filebyte = erw.GetExcelByte(dt, "sheet1", true);

            int officeVersion = erw.OfficeType();

            if (officeVersion == 1 || officeVersion == 2)
            {
                NewData.Message = DateTime.Now.ToString("yyyy-MM-dd") + "工单数据.xls";
            }
            else
            {
                NewData.Message = DateTime.Now.ToString("yyyy-MM-dd") + "工单数据.xlsx";
            }
            NewData.Code = "0";
            NewData.Data = JsonConvert.SerializeObject(Filebyte);

            return JsonConvert.SerializeObject(NewData);
        }

        /// <summary>
        /// 导出数据
        /// </summary>
        /// <param name="page">当前页码</param>
        /// <param name="limit">每页数据量</param>
        /// <param name="sqlWhere">查询条件</param>
        /// <returns></returns>
        [AcceptVerbs(HttpVerbs.Post)]
        public string ExToExcelDZ(ExToExcel paramModel)
        {

            //数据结果集
            ResponseData dataModel = new ResponseData();

            string sql = " AND T2.NoticeState=1";

            //工单编号
            if (!string.IsNullOrEmpty(paramModel.workorderNum))
            {
                sql += " and t.F_CODE like '%" + paramModel.workorderNum.Trim() + "%'";
            }
            //客户姓名
            if (!string.IsNullOrEmpty(paramModel.cusName))
            {
                sql += " and t.F_CUSTOMERNAME like '%" + paramModel.cusName.Trim() + "%'";
            }
            //客户电话
            if (!string.IsNullOrEmpty(paramModel.phoneNumber))
            {
                sql += " and t.F_CUSTOMERTELEPHONE like '%" + paramModel.phoneNumber.Trim() + "%'";
            }
            
            //坐席工号
            if (!string.IsNullOrEmpty(paramModel.userInfo))
            {
                sql += " and t.F_LINKMAN like '%" + paramModel.userInfo.Trim() + "%'";
            }
            //状态
            if (paramModel.status != null)
            {
                sql += " and t.F_WORKORDERSTATEID =" + paramModel.status;
            }
            //业务类别
            if (paramModel.bussType != null && paramModel.bussType > 0)
            {
                sql += " and t.F_FILEFLAG =" + paramModel.bussType;
            }
            //业务类型
            if (paramModel.detailType != null && paramModel.detailType > 0)
            {
                sql += " and t.F_REPAIRLEVEL =" + paramModel.detailType;
            }
            //内容
            if (!string.IsNullOrEmpty(paramModel.Content))
            {
                sql += " and t.F_CONTENT like '%" + paramModel.Content.Trim() + "%'";
            }
            //处理方式
            if (paramModel.GoType != null && paramModel.GoType > 0)
            {
                sql += " and t.F_WORKORDERTYPEID =" + paramModel.GoType;
            }
            //渠道
            if (paramModel.FromType != null && paramModel.FromType > 0)
            {
                sql += " and t.F_REPAIRMANID =" + paramModel.FromType;
            }
            //处理方式
            if (paramModel.F_HASTENCOUNTS != null && paramModel.F_HASTENCOUNTS > -1)
            {
                if (paramModel.F_HASTENCOUNTS == 0)
                {
                    sql += " and t.F_HASTENCOUNTS =0";
                }
                else
                {
                    sql += " and t.F_HASTENCOUNTS >0";
                }

            }
            //else
            //{
            //    return "error(必须选择已定责)";
            //}




            //查询按钮

            if (!string.IsNullOrEmpty(paramModel.dateParty))
            {

                string startDate = paramModel.dateParty.Substring(0, 10);
                string endDate = paramModel.dateParty.Substring(12);
                sql += " and t.F_CREATEDATE>= '" + startDate + " 00:00:00" + "'";
                sql += " and t.F_CREATEDATE<= '" + endDate + " 23:59:59" + "'";

            }

            string tableNew = string.Format("(select DISTINCT t.F_AREA,t.F_CITY ,t.F_PROVINCE,t.F_WORKORDERID,t.F_CODE,u.F_UserName,t.F_CREATEDATE,t.F_RETURNVISITPROBLEM,t.F_WORKORDERFROM,t.F_REPAIRMANID,t.F_HASTENCOUNTS,t.F_WORKORDERTYPEID,t.F_CONTENT,t.F_REPAIRLEVEL,t.F_FILEFLAG,t.F_WORKORDERSTATEID,t.F_LINKMAN,t.F_CUSTOMERTELEPHONE,t.F_CUSTOMERNAME  from T_Wo_WorkOrderBase t LEFT JOIN T_Wo_WorkOrderHistory h ON t.F_WORKORDERID=h.F_INSTANCEID LEFT JOIN T_Sys_UserAccount u ON  t.F_USERID= u.F_UserId  where  (u.F_DeptId={0} OR  h.F_OPTBTNID={0})) as t LEFT join T_Wo_WorkOrderNotice T2 On t.F_WORKORDERID=T2.OrderId ", F_DeptId);
            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(
                tableNew,
                "t.F_WORKORDERID",
                " 0 as 序号"
                 + ",t.F_CODE as 工单编号"
                 + ",t.F_UserName as 受理人"
                   + ",CONVERT(varchar, t.F_CREATEDATE, 120) as 受理时间"
                     + ",t.F_WORKORDERFROM as 事件来源"
                          + ",t.F_RETURNVISITPROBLEM as 事件概况"
                               + ",t.F_PROVINCE as 一级内容分类"
                                  + " , t.F_CITY as 二级内容分类"
                                    + ", t.F_AREA as 三级内容分类"
                                         + ",T2.NoticeDeptName as 责任部门"
                                           + ",T2.NoticeDeptContent as 责任部门调查情况"
                                           + ",T2.NoticeDeptAdvise as 责任部门处理意见和整改措施"
                                            + ",T2.DealAdvise as 计划经营部处理意见"
                                             + ",T2.DealResult as 定性定责结果"
                                               + ",case when F_WORKORDERSTATEID=0 then '未处理' when F_WORKORDERSTATEID=1 then '处理中' else '已处理' END AS 办理状态"
                                                 + " ,'-' as 风险点"
                                                   + ",'-' as 风险等级"
                                                     + ",'-' as 风险概率"
                                                       + ",'-' as 风险评估 "

                ,
                sql,
                "ORDER BY t.F_CREATEDATE desc",
                100000,
                1,
                true,
                out recordCount);


            if (recordCount > 0)
            {
                string tempCode = "";
                int tempn = 0;
                foreach (DataRow dr in dt.Rows)
                {
                    if (tempCode != dr["工单编号"].ToMyString())
                    {
                        tempn += 1;
                    }
                    dr["序号"] = tempn;
                    tempCode = dr["工单编号"].ToMyString();
                }
            }

            ResponseDataModel NewData = new ResponseDataModel();

            ExcelReadWrite erw = new ExcelReadWrite();
            byte[] Filebyte = erw.GetExcelByte(dt, "sheet1", true);

            int officeVersion = erw.OfficeType();

            if (officeVersion == 1 || officeVersion == 2)
            {
                NewData.Message = DateTime.Now.ToString("yyyy-MM-dd") + "全媒体客服转办及化解投诉定性定责情况汇总表.xls";
            }
            else
            {
                NewData.Message = DateTime.Now.ToString("yyyy-MM-dd") + "全媒体客服转办及化解投诉定性定责情况汇总表.xlsx";
            }
            NewData.Code = "0";
            NewData.Data = JsonConvert.SerializeObject(Filebyte);

            return JsonConvert.SerializeObject(NewData);
        }


        #endregion

        #region 工单详情
        public ActionResult ViewMyOrder(int orderKeyId)
        {
            //实例化基础信息表
            CallScreenModel callScreenModel = new CallScreenModel();

            //获取业务工单信息
            if (orderKeyId > 0)
            {
                callScreenModel.WorkOrderBaseModel = orderBLL.GetModel(orderKeyId);
                //如果电话号码不为空
                if (callScreenModel.WorkOrderBaseModel != null && !string.IsNullOrEmpty(callScreenModel.WorkOrderBaseModel.F_CUSTOMERTELEPHONE))
                {
                    T_Cus_CustomerBase baseCusModel = cusBLL.GetCusInfoModel(callScreenModel.WorkOrderBaseModel.F_CUSTOMERTELEPHONE);


                    if (baseCusModel != null && baseCusModel.F_CustomerId > 0)
                    {
                        callScreenModel.WorkOrderBaseModel.CustomerBaseModel = baseCusModel;
                    }
                    else
                    {
                        callScreenModel.WorkOrderBaseModel.CustomerBaseModel = new T_Cus_CustomerBase();
                    }
                }
                else
                {
                    callScreenModel.WorkOrderBaseModel.CustomerBaseModel = new T_Cus_CustomerBase();
                }
                //获取客户基本信息
                if (!string.IsNullOrEmpty(callScreenModel.WorkOrderBaseModel.F_EMPCODE))
                {
                    T_Cus_CustomerBase baseCusModel = cusBLL.GetCusInfoModel(1, callScreenModel.WorkOrderBaseModel.F_EMPCODE);


                    if (baseCusModel != null && baseCusModel.F_CustomerId > 0)
                    {
                        callScreenModel.WorkOrderBaseModel.CustomerBaseModel = baseCusModel;
                    }
                    else
                    {
                        callScreenModel.WorkOrderBaseModel.CustomerBaseModel = new T_Cus_CustomerBase();
                    }
                }
            }
            //业务类型字典表
            callScreenModel.WorkOrderTypeModelList = GetWorkTypeModelList();
            //获取处理方式字典表
            callScreenModel.GoTypeModelList = GetCodeType("CLFS");
            //获取部门列表
            callScreenModel.DepartmentList = deptBll.GetModelList("F_ParentId=0");

            callScreenModel.HistoryOrderList = historyBll.GetModelList("F_INSTANCEID=" + orderKeyId);

            callScreenModel.Noticelist = noticeBLL.GetModelList(" Orderid=" + orderKeyId + " Order by DZNumber ASC");
            return View(callScreenModel);
        }


        /// <summary>
        /// 处理历史工单
        /// </summary>
        /// <param name="orderKeyId">主键</param>
        /// <returns></returns>
        public ActionResult EditMyOrder(int dtype = 0, int orderKeyId = 0)
        {
            //实例化基础信息表
            CallScreenModel callScreenModel = new CallScreenModel();
            //工单类型
            callScreenModel.DType = dtype;
            //话务标志
            callScreenModel.SeatFlag = F_SeatFlag;
            //获取业务工单信息
            if (orderKeyId > 0)
            {
                callScreenModel.WorkOrderBaseModel = orderBLL.GetModel(orderKeyId);
                //如果电话号码不为空
                if (callScreenModel.WorkOrderBaseModel != null && callScreenModel.WorkOrderBaseModel.F_CUSTOMERID > 1)
                {

                    T_Cus_CustomerBase baseCusModel = cusBLL.GetModel((int)callScreenModel.WorkOrderBaseModel.F_CUSTOMERID);
                    if (baseCusModel != null && baseCusModel.F_CustomerId > 1)
                    {
                        callScreenModel.WorkOrderBaseModel.CustomerBaseModel = baseCusModel;
                    }
                    else
                    {
                        callScreenModel.WorkOrderBaseModel.CustomerBaseModel = new T_Cus_CustomerBase();
                    }

                }
                else
                {
                    callScreenModel.WorkOrderBaseModel.CustomerBaseModel = new T_Cus_CustomerBase();
                }

            }
            //业务类型字典表
            callScreenModel.WorkOrderTypeModelList = GetWorkTypeModelList();
            //获取处理方式字典表
            callScreenModel.GoTypeModelList = GetCodeType("CLFS");
            //回访满意度
            callScreenModel.MYdModelList = GetCodeType("khyjfl");
            //获取部门列表
            callScreenModel.DepartmentList = deptBll.GetModelList("F_ParentId=0");

            callScreenModel.HistoryOrderList = historyBll.GetModelList("F_INSTANCEID=" + orderKeyId);

            callScreenModel.Noticelist = noticeBLL.GetModelList(" Orderid=" + orderKeyId + " Order by DZNumber ASC");
            return View(callScreenModel);
        }

        #endregion



    }
}