Anyang_api/CallCenterApi/CallCenterAp.../CallCenterAp.../Controllers/workorder/APPSControll...

using System;
using System.Collections.Generic;
using System.Collections.Specialized;
using System.ComponentModel;
using System.Data;
using System.Linq;
using System.Reflection;
using System.Web;
using System.Web.Mvc;
using CallCenter.Utility;
using CallCenterApi.Common;
using CallCenterApi.DB;
using CallCenterApi.Interface.Controllers.Base;
using CallCenterApi.Interface.Models.Common;
using CallCenterApi.Model;
using Newtonsoft.Json;
using System.IO;
using Newtonsoft.Json.Linq;
using System.Transactions;
using System.Net.Http;
using System.Text;
using System.Net;

namespace CallCenterApi.Interface.Controllers.workorder
{
    public class APPSController : BaseController
    {
        private BLL.T_Bus_WorkOrder workorderBLL = new BLL.T_Bus_WorkOrder();
        private information.InternalMessagesController msg = new information.InternalMessagesController();
        private readonly static object _MyLock = new object();
        /// <summary>
        /// 获取工单列表
        /// </summary>
        /// <returns></returns>
        //[Authority]
        public ActionResult zmhd1000test(int isdc = 0)
        {
            string sql = "  F_IsDelete=0 ";
            sql += " and F_IsOpen=1 ";
            int source = RequestString.GetInt("strStm_Src_Dsc", 0);//1 市长热线 2 市长信箱 0 连线政府 3 人民网
            string strusercode = HttpUtility.UrlDecode(RequestString.GetQueryString("strCst_ID"));//创建员工编号
            string strtel = HttpUtility.UrlDecode(RequestString.GetQueryString("strRdial_Tel"));//市民电话
            string strkey = HttpUtility.UrlDecode(RequestString.GetQueryString("strWrkOrdr_Ttl_Dtl"));//关键字检索
            int state = RequestString.GetInt("strWrkOrdr_StCd", 0);//工单状态代码
            string InfoType = HttpUtility.UrlDecode(RequestString.GetQueryString("strWrkOrdr_Lv1_Bsn_TpCd"));//工单一级业务类型代码
            string strstarttime = HttpUtility.UrlDecode(RequestString.GetQueryString("strCrt_StDt"));//创建开始日期
            string strendtime = HttpUtility.UrlDecode(RequestString.GetQueryString("strCrt_EdDt"));//创建结束日期
            string Key = HttpUtility.UrlDecode(RequestString.GetQueryString("strWrkOrdr_Lv1_Bsn_TpCd"));//事项一级分类代码
            int isproresult = RequestString.GetInt("strRcrd_ID", 0);//营商标识
            string Title = HttpUtility.UrlDecode(RequestString.GetQueryString("strWrkOrdr_Ttl"));//工单标题


            if (Title.Trim() != "" && Title != "undefined")
            {
                sql += " and F_ComTitle in (" + Title + ") ";

            }
            if (InfoType.Trim() != "" && InfoType != "undefined")
            {
                sql += " and F_InfoType in (select F_ValueId from T_Sys_DictionaryValue where F_Value like'%" + InfoType.Trim() + "%'  ) ";

            }
            if (Key.Trim() != "" && Key != "undefined")
            {
                sql += " and F_Key in (select F_ValueId from T_Sys_DictionaryValue where F_Value like'%" + Key.Trim() + "%'  ) ";

            }

            if (state != 0)
            {
                if (state == 1)
                {
                    sql += " and F_WorkState in (" + (int)EnumWorkState.neworder + "," + (int)EnumWorkState.submit + "," + (int)EnumWorkState.receive + (int)EnumWorkState.resubmit + ") ";
                }
                else if (state == 2)
                {
                    sql += " and F_WorkState in (" + (int)EnumWorkState.auditreback + "," + (int)EnumWorkState.dealing + "," + (int)EnumWorkState.auditdelay + (int)EnumWorkState.reload + (int)EnumWorkState.audit + (int)EnumWorkState.rejload + ") ";
                }
                else if (state == 3)
                {
                    sql += " and F_WorkState in (" + (int)EnumWorkState.visit + "," + (int)EnumWorkState.finish +","+(int)EnumWorkState.dealed + ") ";
                }
                else if (state == 4)
                {
                    sql += " and F_WorkState in (" + (int)EnumWorkState.neworder + "," + (int)EnumWorkState.submit + "," + (int)EnumWorkState.receive + (int)EnumWorkState.resubmit + (int)EnumWorkState.auditreback + "," + (int)EnumWorkState.dealing + "," + (int)EnumWorkState.auditdelay + (int)EnumWorkState.reload + (int)EnumWorkState.audit + (int)EnumWorkState.rejload + ") ";
                }
               

            }
            // SELECT @Name = F_Value FROM T_Sys_DictionaryValue WHERE F_ValueId = @ID
            if (source != 0)
            {
                sql += " and F_InfoSource = '" + source + "' ";
            }
            if (strusercode.Trim() != "" && strusercode != "undefined")
            {//坐席
                sql += " and F_CreateUser in (" + strusercode + ") ";
            }
            if (strtel.Trim() != "" && strtel != "undefined")
            {
                sql += " and (F_CusPhone like '%" + strtel + "%' or F_ConPhone like '%" + strtel + "%') ";
            }
            if (strkey.Trim() != "" && strkey != "undefined")
            {
                sql += " and (F_ComTitle like '%" + strkey + "%' or F_ComContent like '%" + strkey + "%' or F_Content like '%" + strkey + "%') ";

            }
            if (strstarttime.Trim() != "" && strstarttime != "undefined")
            {
                sql += " and datediff(day,F_CreateTime,'" + strstarttime + "')<=0 ";
            }
            if (strendtime.Trim() != "" && strendtime != "undefined")
            {
                sql += " and datediff(day,F_CreateTime,'" + strendtime + "')>=0   ";
            }
            string cols = "F_Result,F_Unsuccessful,F_WorkOrderId,F_ComTitle,F_WorkState,F_MainDeptId,F_OtherDeptIds,F_DealTime,F_LeaveRecordId,F_CallRecordId,F_IsResult,F_IsProtect,F_IsReturn,F_CreateTime,dbo.GetUserName(F_CreateUser) as UserName,dbo.GetDictionaryName(F_InfoType) as TypeName,dbo.GetDictionaryName(F_InfoSource) as SourceName";
            //var dt = DbHelperSQL.Query(sql).Tables[0];
            var orderlist = workorderBLL.GetModelList(sql);
            #region 声音文件和交办超时
            #endregion
            var obj = new
            {
                state = "success",
                message = "成功",
                rows = orderlist,
            };
            return Content(obj.ToJson());

        }
        public ActionResult test()
        {
            WeiBoLog.WriteLog("error:判断类型错误");
            return Content("ok");

        }
        public ActionResult zmhdphoto()
        {
            HttpFileCollection files = RequestString.GetFiles();
            if (files.Count > 0)
            {
                string path = "/Upload/Files/" + DateTime.Now.ToString("yyyy") + "/" + DateTime.Now.ToString("MM") + "/" + DateTime.Now.ToString("dd") + "/";
                for (int i = 0; i < files.Count; i++)
                {
                    HttpPostedFile file = files[i];
                    FileUp fu = new FileUp();

                    string name = fu.Upload(file, path);
                }
            }
            var obj = new
            {
                state = "success",
                message = "成功",
            };
            return Content(obj.ToJson());

        }
        //政民互动详情查询
        public ActionResult zmhd10001test()
        {
            string sql = "  F_IsDelete=0 ";
            sql += " and F_IsOpen=1 ";
            // sql += " and F_Id<327";
            int source = RequestString.GetInt("strStm_Src_Dsc", 0);//1 市长热线 2 市长信箱 0 连线政府 3 人民网 
            string strworkorderid = HttpUtility.UrlDecode(RequestString.GetQueryString("strWrkOrdr_ID")); // 工单编号
                                                                                                          //  string strusercode = HttpUtility.UrlDecode(RequestString.GetQueryString("strCst_ID"));//创建员工编号

            if (strworkorderid.Trim() != "" && strworkorderid != "undefined")
            {
                sql += " and F_WorkOrderId like '%" + strworkorderid + "%' ";
            }
            //if (strusercode.Trim() != "" && strusercode != "undefined")
            //{//坐席
            //    sql += " and F_CreateUser in (" + strusercode + ") ";
            //}
            if (source != 0)
            {
                //1 市长热线 2 市长信箱 0 连线政府 3 人民网
                if (source == 0)
                {
                    source = 2458;
                }
                if (source == 3)
                {
                    source = 4;
                }
                sql += " and F_InfoSource = '" + source + "' ";
            }
            var orderlist = workorderBLL.GetModelList(sql);
            DataTable dt = new DataTable();

            DataColumn dc = null;

            //系统来源描述
            dc = dt.Columns.Add("strStm_Src_Dsc", Type.GetType("System.String"));
            //工单编号
            dc = dt.Columns.Add("strWrkOrdr_ID", Type.GetType("System.String"));
            //工单类型代码
            dc = dt.Columns.Add("strWrkOrdr_TpCd", Type.GetType("System.String"));
            //工单状态代码
            dc = dt.Columns.Add("strWrkOrdr_StCd", Type.GetType("System.String"));
            //工单状态描述
            dc = dt.Columns.Add("strWrkOrdr_StCd_DESC", Type.GetType("System.String"));
            //工单一级业务类型代码
            dc = dt.Columns.Add("strWrkOrdr_Lv1_Bsn_TpCd", Type.GetType("System.String"));
            //工单一级业务类型描述
            dc = dt.Columns.Add("strWrkOrdr_Lv1_Bsn_TpCd_DESC", Type.GetType("System.String"));
            //客户名称
            dc = dt.Columns.Add("strCst_Nm", Type.GetType("System.String"));
            //客户编号
            dc = dt.Columns.Add("strCst_ID", Type.GetType("System.String"));
            //工单标题
            dc = dt.Columns.Add("strWrkOrdr_Ttl", Type.GetType("System.String"));
            //工单详细情况描述
            dc = dt.Columns.Add("strWrkOrdr_Dtl_StnDsc", Type.GetType("System.String"));
            //屏蔽内容
            dc = dt.Columns.Add("strFst_SpInf", Type.GetType("System.String"));

            //管理中心回复(最新)
            dc = dt.Columns.Add("strWrkOrdr_Splmt_Cntnt", Type.GetType("System.String"));
            //创建日期时间
            dc = dt.Columns.Add("strCrt_Dt_Tm", Type.GetType("System.String"));
            //回复局委编号
            dc = dt.Columns.Add("strRltv_InsID", Type.GetType("System.String"));
            //回复局委名称
            dc = dt.Columns.Add("strInpt_Inst_Nm", Type.GetType("System.String"));
            //回复时间
            dc = dt.Columns.Add("strCnvrstn_No", Type.GetType("System.String"));
            //局委回复内容
            dc = dt.Columns.Add("strWrkOrdr_Pcsg_StnCm", Type.GetType("System.String"));
            //工单收藏次数
            dc = dt.Columns.Add("strRslt_Rcrd_Num", Type.GetType("System.String"));
            dc = dt.Columns.Add("strFrcst_Pcsg_CODt", Type.GetType("System.String"));

            //atchmList
            dc = dt.Columns.Add("atchmList", Type.GetType("System.String"));

            var person = new
            {
                Name = "张三",
                Age = 22,
                Sex = "男",
                Date = DateTime.Now
            };

            List<T_Sys_Accessories> listSys = new List<T_Sys_Accessories>();

            for (int i = 0; i < orderlist.Count; i++)
            {
                DataRow newRow;
                newRow = dt.NewRow();

                if (DbHelperSQL.GetSingle("select top 1 F_Value from  T_Sys_DictionaryValue where F_ValueId='" + orderlist[i].F_InfoSource.ToString() + "'") != null)
                {
                    newRow["strStm_Src_Dsc"] = DbHelperSQL.GetSingle("select top 1 F_Value from  T_Sys_DictionaryValue where F_ValueId='" + orderlist[i].F_InfoSource.ToString() + "'").ToString();
                }


                newRow["strWrkOrdr_ID"] = orderlist[i].F_WorkOrderId.ToString();
                newRow["strWrkOrdr_TpCd"] = orderlist[i].F_InfoSource.ToString();
                newRow["strWrkOrdr_StCd"] = orderlist[i].F_WorkState.ToString();
                if (!string.IsNullOrEmpty(orderlist[i].F_WorkState.ToString()))
                {
                    newRow["strWrkOrdr_StCd_DESC"] = Utils.ToEnumDescriptionString(Convert.ToInt32(orderlist[i].F_WorkState), typeof(EnumWorkState));
                }
                newRow["strWrkOrdr_Lv1_Bsn_TpCd"] = orderlist[i].F_InfoType.ToString();
                if (!string.IsNullOrEmpty(orderlist[i].F_InfoSource.ToString()))
                {
                    if (DbHelperSQL.GetSingle("select top 1 F_Value from  T_Sys_DictionaryValue where F_ValueId='" + orderlist[i].F_InfoType.ToString() + "'") != null)
                    {
                        newRow["strWrkOrdr_Lv1_Bsn_TpCd_DESC"] = DbHelperSQL.GetSingle("select top 1 F_Value from  T_Sys_DictionaryValue where F_ValueId='" + orderlist[i].F_InfoType.ToString() + "'").ToString();
                    }

                }
                if (!string.IsNullOrEmpty(orderlist[i].F_CloseTime.ToString()))
                    newRow["strFrcst_Pcsg_CODt"] = orderlist[i].F_CloseTime.ToString();
                if (!string.IsNullOrEmpty(orderlist[i].F_DealTime.ToString()))
                    newRow["strFrcst_Pcsg_CODt"] = orderlist[i].F_DealTime.ToString();
                else
                    newRow["strFrcst_Pcsg_CODt"] = orderlist[i].F_CreateTime.ToString();
                newRow["strCst_Nm"] = orderlist[i].F_CusName.ToString();
                newRow["strCst_ID"] = orderlist[i].F_Id.ToString();
                newRow["strWrkOrdr_Ttl"] = orderlist[i].F_ComTitle.ToString();
                if (!string .IsNullOrEmpty (orderlist[i].F_Content .ToString()))
                newRow["strWrkOrdr_Dtl_StnDsc"] = orderlist[i].F_Content.ToString();
                else
                newRow["strWrkOrdr_Dtl_StnDsc"] = orderlist[i].F_ComContent.ToString();

                newRow["strFst_SpInf"] = "";
                newRow["strWrkOrdr_Splmt_Cntnt"] = orderlist[i].F_Result.ToString();
                newRow["strCrt_Dt_Tm"] = orderlist[i].F_CreateTime.ToString();
                newRow["strRltv_InsID"] = orderlist[i].F_MainDeptId.ToString();
                if (!string.IsNullOrEmpty(orderlist[i].F_MainDeptId.ToString()))
                {
                    if (DbHelperSQL.GetSingle("select top 1 F_DeptName from  T_Sys_Department where F_DeptId='" + orderlist[i].F_MainDeptId.ToString() + "'") != null)
                    {
                        newRow["strInpt_Inst_Nm"] = DbHelperSQL.GetSingle("select top 1 F_DeptName from  T_Sys_Department where F_DeptId='" + orderlist[i].F_MainDeptId.ToString() + "'").ToString();
                    }

                }
                else
                {
                    newRow["strInpt_Inst_Nm"] = "管理中心";
                }
                newRow["strCnvrstn_No"] = orderlist[i].F_EnableTime.ToString();
                newRow["strWrkOrdr_Pcsg_StnCm"] = orderlist[i].F_FinalOpinion.ToString();
                newRow["strRslt_Rcrd_Num"] = "";
                if (!string.IsNullOrEmpty(orderlist[i].F_File))
                {
                    var dtfj = new DataTable();
                    if (!orderlist[i].F_File.Contains(','))
                    {
                        dtfj = DbHelperSQL.Query(" select *   from T_Sys_Accessories WITH(NOLOCK) where 1=1 and f_fileid='" + orderlist[i].F_File + "'").Tables[0];
                        var atchmList = new
                        {
                            strUdt_Psn_Nm = DbHelperSQL.GetSingle("select f_username from T_Sys_UserAccount where F_UserCode = '" + orderlist[i].F_CreateUser + "'"),
                            strUdt_Psn_ID = orderlist[i].F_CreateUser,
                            strWrkOrdStrm_Tfr_SN = orderlist[i].F_Id.ToString(),
                            strWrkOrdr_Atch_SbmTm = dtfj.Rows[0]["F_AddTime"],
                            strAtch_Chn_Nm = dtfj.Rows[0]["F_FileName"],
                            strCur_Atch_Rte_Dsc = dtfj.Rows[0]["F_FileUrl"],
                            strWrkOrdr_Atch_ID = dtfj.Rows[0]["F_FileId"]
                        };
                        newRow["atchmList"] = atchmList.ToJson();
                    }
                    else
                    {
                        string[] arrFileType = orderlist[i].F_File.Split(',');
                        List<atchmList> res = new List<atchmList>();
                        foreach (string str in arrFileType)
                        {
                            dtfj = DbHelperSQL.Query(" select *   from T_Sys_Accessories WITH(NOLOCK) where 1=1 and f_fileid='" + str + "'").Tables[0];
                            var atchmList = new atchmList();
                            if (DbHelperSQL.GetSingle("select f_username from T_Sys_UserAccount where F_UserCode = '" + orderlist[i].F_CreateUser + "'") != null)
                            {
                                atchmList.strUdt_Psn_Nm = DbHelperSQL.GetSingle("select f_username from T_Sys_UserAccount where F_UserCode = '" + orderlist[i].F_CreateUser + "'").ToString();
                            }

                            atchmList.strUdt_Psn_ID = orderlist[i].F_CreateUser;
                            atchmList.strWrkOrdStrm_Tfr_SN = orderlist[i].F_Id.ToString();
                            atchmList.strWrkOrdr_Atch_SbmTm = dtfj.Rows[0]["F_AddTime"].ToString();
                            atchmList.strCur_Atch_Rte_Dsc = dtfj.Rows[0]["F_FileName"].ToString();
                            atchmList.strUdt_Psn_ID = dtfj.Rows[0]["F_FileUrl"].ToString();
                            atchmList.strWrkOrdr_Atch_ID = dtfj.Rows[0]["F_FileId"].ToString();

                            res.Add(atchmList);
                        }
                        newRow["atchmList"] = res.ToJson();
                    }
                }
                dt.Rows.Add(newRow);
            }

            #region 声音文件和交办超时
            #endregion
            var obj = new
            {
                state = "success",
                message = "成功",
                returnList = dt,
            };
            return Content(obj.ToJson());

        }
        public class atchmList
        {
            public string strUdt_Psn_Nm { get; set; }
            public string strUdt_Psn_ID { get; set; }
            public string strWrkOrdStrm_Tfr_SN { get; set; }
            public string strWrkOrdr_Atch_SbmTm { get; set; }
            public string strAtch_Chn_Nm { get; set; }
            public string strCur_Atch_Rte_Dsc { get; set; }
            public string strWrkOrdr_Atch_ID { get; set; }
        }
        //市长热线列表查询
        public ActionResult zmhd10002old()
        {
            string sql = "  F_IsDelete=0 ";
            sql += " and F_IsOpen=1 ";
            // sql += " and F_Id<327";
            int source = RequestString.GetInt("strStm_Src_Dsc", 0);//1 市长热线 2 市长信箱 0 连线政府 3 人民网
            string strusercode = HttpUtility.UrlDecode(RequestString.GetQueryString("strCst_ID"));//创建员工编号
            string strtel = HttpUtility.UrlDecode(RequestString.GetQueryString("strRdial_Tel"));//市民电话
            string strkey = HttpUtility.UrlDecode(RequestString.GetQueryString("strWrkOrdr_Ttl_Dtl"));//关键字检索
            int state = RequestString.GetInt("strWrkOrdr_StCd", 0);//工单状态代码
            string InfoType = HttpUtility.UrlDecode(RequestString.GetQueryString("strWrkOrdr_Lv1_Bsn_TpCd"));//工单一级业务类型代码
            string strstarttime = HttpUtility.UrlDecode(RequestString.GetQueryString("strCrt_StDt"));//创建开始日期
            string strendtime = HttpUtility.UrlDecode(RequestString.GetQueryString("strCrt_EdDt"));//创建结束日期
            string Key = HttpUtility.UrlDecode(RequestString.GetQueryString("strWrkOrdr_Lv1_Bsn_TpCd"));//事项一级分类代码
            int isproresult = RequestString.GetInt("strRcrd_ID", 0);//营商标识
            string Title = HttpUtility.UrlDecode(RequestString.GetQueryString("strWrkOrdr_Ttl"));//工单标题


            if (Title.Trim() != "" && Title != "undefined")
            {
                sql += " and F_ComTitle in (" + Title + ") ";

            }
            if (InfoType.Trim() != "" && InfoType != "undefined")
            {
                sql += " and F_InfoType in (select F_ValueId from T_Sys_DictionaryValue where F_Value like'%" + InfoType.Trim() + "%'  ) ";

            }
            if (Key.Trim() != "" && Key != "undefined")
            {
                sql += " and F_Key in (select F_ValueId from T_Sys_DictionaryValue where F_Value like'%" + Key.Trim() + "%'  ) ";

            }

            if (state != 0)
            {
                if (state == 1)
                {
                    sql += " and F_WorkState in (" + (int)EnumWorkState.neworder + "," + (int)EnumWorkState.submit + "," + (int)EnumWorkState.receive + (int)EnumWorkState.resubmit + ") ";
                }
                else if (state == 2)
                {
                    sql += " and F_WorkState in (" + (int)EnumWorkState.auditreback + "," + (int)EnumWorkState.dealing + "," + (int)EnumWorkState.auditdelay + (int)EnumWorkState.reload + (int)EnumWorkState.audit + (int)EnumWorkState.rejload + ") ";
                }
                else if (state == 3)
                {
                    sql += " and F_WorkState in (" + (int)EnumWorkState.visit + "," + (int)EnumWorkState.finish + "," + (int)EnumWorkState.dealed + ") ";
                }
                else if (state == 4)
                {
                    sql += " and F_WorkState not in ( 6,7,9 ) ";

                }

            }
            // SELECT @Name = F_Value FROM T_Sys_DictionaryValue WHERE F_ValueId = @ID
            if (source != 0)
            {
                sql += " and F_InfoSource = '" + source + "' ";
            }
            if (strusercode.Trim() != "" && strusercode != "undefined")
            {//坐席
                sql += " and F_CreateUser in (" + strusercode + ") ";
            }
            if (strtel.Trim() != "" && strtel != "undefined")
            {
                sql += " and (F_CusPhone like '%" + strtel + "%' or F_ConPhone like '%" + strtel + "%') ";
            }
            if (strkey.Trim() != "" && strkey != "undefined")
            {
                sql += " and (F_ComTitle like '%" + strkey + "%' or F_ComContent like '%" + strkey + "%' or F_Content like '%" + strkey + "%') ";

            }
            if (strstarttime.Trim() != "" && strstarttime != "undefined")
            {
                sql += " and datediff(day,F_CreateTime,'" + strstarttime + "')<=0 ";
            }
            if (strendtime.Trim() != "" && strendtime != "undefined")
            {
                sql += " and datediff(day,F_CreateTime,'" + strendtime + "')>=0   ";
            }
            string cols = "F_Result,F_Unsuccessful,F_WorkOrderId,F_ComTitle,F_WorkState,F_MainDeptId,F_OtherDeptIds,F_DealTime,F_LeaveRecordId,F_CallRecordId,F_IsResult,F_IsProtect,F_IsReturn,F_CreateTime,dbo.GetUserName(F_CreateUser) as UserName,dbo.GetDictionaryName(F_InfoType) as TypeName,dbo.GetDictionaryName(F_InfoSource) as SourceName";
            //var dt = DbHelperSQL.Query(sql).Tables[0];
            var orderlist = workorderBLL.GetModelList(sql);


            DataTable dt = new DataTable();

            DataColumn dc = null;
            //工单编号
            dc = dt.Columns.Add("strWrkOrdr_ID", Type.GetType("System.String"));
            //工单类型代码
            dc = dt.Columns.Add("strWrkOrdr_TpCd", Type.GetType("System.String"));
            //工单状态代码
            dc = dt.Columns.Add("strWrkOrdr_StCd", Type.GetType("System.String"));
            //工单标题
            dc = dt.Columns.Add("strWrkOrdr_Ttl", Type.GetType("System.String"));
            //工单详细情况描述
            dc = dt.Columns.Add("strWrkOrdr_Dtl_StnDsc", Type.GetType("System.String"));
            //当前提交时间
            dc = dt.Columns.Add("strCrt_Dt_Tm", Type.GetType("System.String"));
            //客户名称
            dc = dt.Columns.Add("strCst_Nm", Type.GetType("System.String"));
            //客户编号
            dc = dt.Columns.Add("strCst_ID", Type.GetType("System.String"));
            //工单一级业务类型代码
            dc = dt.Columns.Add("strWrkOrdr_Lv1_Bsn_TpCd", Type.GetType("System.String"));
            //工单一级业务类型描述
            dc = dt.Columns.Add("strWrkOrdr_Lv1_Bsn_TpCd_DESC", Type.GetType("System.String"));




            //回复局委编号
            dc = dt.Columns.Add("strRltv_InsID", Type.GetType("System.String"));
            //回复局委名称
            dc = dt.Columns.Add("strInpt_Inst_Nm", Type.GetType("System.String"));
            //回复时间
            dc = dt.Columns.Add("strCnvrstn_No", Type.GetType("System.String"));


            for (int i = 0; i < orderlist.Count; i++)
            {


                DataRow newRow;
                newRow = dt.NewRow();
                newRow["strWrkOrdr_ID"] = orderlist[i].F_WorkOrderId.ToString();
                newRow["strWrkOrdr_TpCd"] = orderlist[i].F_InfoSource.ToString();
                newRow["strWrkOrdr_StCd"] = orderlist[i].F_WorkState.ToString();
                newRow["strWrkOrdr_Ttl"] = orderlist[i].F_ComTitle.ToString();
                if (!string .IsNullOrEmpty(orderlist[i].F_Content .ToString()))
                newRow["strWrkOrdr_Dtl_StnDsc"] = orderlist[i].F_Content.ToString();
                else
                    newRow["strWrkOrdr_Dtl_StnDsc"] = orderlist[i].F_ComContent.ToString();
                newRow["strCrt_Dt_Tm"] = orderlist[i].F_CreateTime.ToString();
                newRow["strCst_Nm"] = orderlist[i].F_CusName.ToString();
                newRow["strCst_ID"] = orderlist[i].F_Id.ToString();

                //  newRow["strWrkOrdr_Lv1_Bsn_TpCd"] = orderlist[i].F_InfoType.ToString();

                if (!string.IsNullOrEmpty(orderlist[i].F_InfoType.ToString()))
                {
                    if (DbHelperSQL.GetSingle("select top 1 F_Value from  T_Sys_DictionaryValue where F_ValueId='" + orderlist[i].F_InfoType.ToString() + "'") != null)
                    {
                        newRow["strWrkOrdr_Lv1_Bsn_TpCd_DESC"] = DbHelperSQL.GetSingle("select top 1 F_Value from  T_Sys_DictionaryValue where F_ValueId='" + orderlist[i].F_InfoType.ToString() + "'").ToString();
                    }

                }

                if (!string.IsNullOrEmpty(orderlist[i].F_MainDeptId.ToString()))
                {
                    if (DbHelperSQL.GetSingle("select top 1 F_DeptName from  T_Sys_Department where F_DeptId='" + orderlist[i].F_MainDeptId.ToString() + "'") != null)
                    {
                        newRow["strInpt_Inst_Nm"] = DbHelperSQL.GetSingle("select top 1 F_DeptName from  T_Sys_Department where F_DeptId='" + orderlist[i].F_MainDeptId.ToString() + "'").ToString();
                    }

                }

                newRow["strRltv_InsID"] = orderlist[i].F_MainDeptId.ToString();
                newRow["strCnvrstn_No"] = orderlist[i].F_EnableTime.ToString();


                dt.Rows.Add(newRow);
            }



            #region 声音文件和交办超时
            #endregion
            var obj = new
            {
                state = "success",
                message = "成功",
                returnList = dt,
            };
            return Content(obj.ToJson());

        }
        //提交诉求
        public ActionResult zmhd10003999()
        {
            string sql = "  F_IsDelete=0 ";
            sql += " and F_IsOpen=1 ";
            //工单类型代码 F_WorkState
            string F_WorkState = HttpUtility.UrlDecode(RequestString.GetQueryString("strWrkOrdr_StCd"));
            //客户编号
            string F_Id = HttpUtility.UrlDecode(RequestString.GetQueryString("strCst_ID"));
            //客户名称
            string F_CusName = HttpUtility.UrlDecode(RequestString.GetQueryString("strCst_Nm"));
            //工单一级业务类型代码
            string F_InfoType = HttpUtility.UrlDecode(RequestString.GetQueryString("strWrkOrdr_Lv1_Bsn_TpCd"));
            //工单标题
            string F_ComTitle = HttpUtility.UrlDecode(RequestString.GetQueryString("strWrkOrdr_Ttl"));
            //工单详细情况描述
            string F_ComContent = HttpUtility.UrlDecode(RequestString.GetQueryString("strWrkOrdr_Dtl_StnDsc"));
            //系统来源描述
            string F_InfoSource = HttpUtility.UrlDecode(RequestString.GetQueryString("strStm_Src_Dsc"));
            //手机号
            string F_CusPhone = HttpUtility.UrlDecode(RequestString.GetQueryString("strRdial_Tel"));



            //if (source != 0)
            //{
            //    sql += " and F_InfoSource = '" + source + "' ";
            //}
            //if (strworkorderid.Trim() != "" && strworkorderid != "undefined")
            //{
            //    sql += " and F_WorkOrderId=" + strworkorderid + " ";
            //}
            //if (strusercode.Trim() != "" && strusercode != "undefined")
            //{//坐席
            //    sql += " and F_CreateUser in (" + strusercode + ") ";
            //}

            var orderlist = workorderBLL.GetModelList(sql);
            DataTable dt = new DataTable();

            DataColumn dc = null;
            //系统来源描述
            dc = dt.Columns.Add("strStm_Src_Dsc", Type.GetType("System.String"));
            //工单编号
            dc = dt.Columns.Add("strWrkOrdr_ID", Type.GetType("System.String"));
            //工单类型代码
            dc = dt.Columns.Add("strWrkOrdr_TpCd", Type.GetType("System.String"));
            //工单状态代码
            dc = dt.Columns.Add("strWrkOrdr_StCd", Type.GetType("System.String"));
            //工单状态描述
            dc = dt.Columns.Add("strWrkOrdr_StCd_DESC", Type.GetType("System.String"));
            //工单一级业务类型代码
            dc = dt.Columns.Add("strWrkOrdr_Lv1_Bsn_TpCd", Type.GetType("System.String"));
            //工单一级业务类型描述
            dc = dt.Columns.Add("strWrkOrdr_Lv1_Bsn_TpCd_DESC", Type.GetType("System.String"));
            //客户名称
            dc = dt.Columns.Add("strCst_Nm", Type.GetType("System.String"));
            //客户编号
            dc = dt.Columns.Add("strCst_ID", Type.GetType("System.String"));
            //工单标题
            dc = dt.Columns.Add("strWrkOrdr_Ttl", Type.GetType("System.String"));
            //工单详细情况描述
            dc = dt.Columns.Add("strWrkOrdr_Dtl_StnDsc", Type.GetType("System.String"));
            //管理中心回复(最新)
            dc = dt.Columns.Add("strWrkOrdr_Splmt_Cntnt", Type.GetType("System.String"));
            //创建日期时间
            dc = dt.Columns.Add("strCrt_Dt_Tm", Type.GetType("System.String"));
            //回复局委编号
            dc = dt.Columns.Add("strRltv_InsID", Type.GetType("System.String"));
            //回复局委名称
            dc = dt.Columns.Add("strInpt_Inst_Nm", Type.GetType("System.String"));
            //回复时间
            dc = dt.Columns.Add("strCnvrstn_No", Type.GetType("System.String"));
            //局委回复内容
            dc = dt.Columns.Add("strWrkOrdr_Pcsg_StnCm", Type.GetType("System.String"));
            for (int i = 0; i < orderlist.Count; i++)
            {

                DataRow newRow;
                newRow = dt.NewRow();


                //if (!string.IsNullOrEmpty(source))
                //{
                //    newRow["strStm_Src_Dsc"] = DbHelperSQL.GetSingle("select top 1 F_Value from  T_Sys_DictionaryValue where F_ValueId='" + source + "'").ToString();
                //}
                newRow["strWrkOrdr_ID"] = orderlist[i].F_WorkOrderId.ToString();
                newRow["strWrkOrdr_TpCd"] = orderlist[i].F_InfoSource.ToString();
                newRow["strWrkOrdr_StCd"] = orderlist[i].F_WorkState.ToString();
                if (!string.IsNullOrEmpty(orderlist[i].F_WorkState.ToString()))
                {
                    newRow["strWrkOrdr_StCd_DESC"] = Utils.ToEnumDescriptionString(Convert.ToInt32(orderlist[i].F_WorkState), typeof(EnumWorkState));
                }
                newRow["strWrkOrdr_Lv1_Bsn_TpCd"] = orderlist[i].F_InfoType.ToString();
                if (!string.IsNullOrEmpty(orderlist[i].F_InfoSource.ToString()))
                {
                    newRow["strWrkOrdr_Lv1_Bsn_TpCd_DESC"] = DbHelperSQL.GetSingle("select top 1 F_Value from  T_Sys_DictionaryValue where F_ValueId='" + orderlist[i].F_InfoType.ToString() + "'").ToString();
                }
                newRow["strCst_Nm"] = orderlist[i].F_CusName.ToString();
                newRow["strCst_ID"] = orderlist[i].F_Id.ToString();
                newRow["strWrkOrdr_Ttl"] = orderlist[i].F_ComTitle.ToString();
                if (!string.IsNullOrEmpty(orderlist[i].F_Content.ToString()))
                    newRow["strWrkOrdr_Dtl_StnDsc"] = orderlist[i].F_Content.ToString();
                else
                    newRow["strWrkOrdr_Dtl_StnDsc"] = orderlist[i].F_ComContent.ToString();
              
                newRow["strWrkOrdr_Splmt_Cntnt"] = orderlist[i].F_Result.ToString();
                newRow["strCrt_Dt_Tm"] = orderlist[i].F_CreateTime.ToString();
                newRow["strRltv_InsID"] = orderlist[i].F_MainDeptId.ToString();
                if (!string.IsNullOrEmpty(orderlist[i].F_MainDeptId.ToString()))
                {
                    newRow["strInpt_Inst_Nm"] = DbHelperSQL.GetSingle("select top 1 F_DeptName from  T_Sys_Department where F_DeptId='" + orderlist[i].F_MainDeptId.ToString() + "'").ToString();
                }
                newRow["strCnvrstn_No"] = orderlist[i].F_EnableTime.ToString();
                newRow["strWrkOrdr_Pcsg_StnCm"] = orderlist[i].F_FinalOpinion.ToString();
                dt.Rows.Add(newRow);
            }



            #region 声音文件和交办超时
            #endregion
            var obj = new
            {
                state = "success",
                message = "成功",
                returnList = dt,
            };
            return Content(obj.ToJson());

        }
        //政民互动分类列表查询
        public ActionResult zmhd10007()
        {
            DataTable dt = new DataTable();

            //市民姓名
            StreamReader reader = new StreamReader(System.Web.HttpContext.Current.Request.InputStream);
            var postString = reader.ReadToEnd();
            JObject result = null;
            result = (JObject)Newtonsoft.Json.JsonConvert.DeserializeObject(postString);
            var txnBodyCom = result["txnBodyCom"].ToString();
            var txnBodyComresult = (JObject)Newtonsoft.Json.JsonConvert.DeserializeObject(txnBodyCom);
            var strParm_Cd = txnBodyComresult["strParm_Cd"] == null ? "" : txnBodyComresult["strParm_Cd"].ToString();
            var strParm_Cntnt = txnBodyComresult["strParm_Cntnt"] == null ? "" : txnBodyComresult["strParm_Cntnt"].ToString();
            DataColumn dc = null;
            //主类编码
            dc = dt.Columns.Add("strPrim_Cgy_ECD", Type.GetType("System.String"));
            //主类描述
            dc = dt.Columns.Add("strPrim_Cgy_Dsc", Type.GetType("System.String"));
            //子类编码
            dc = dt.Columns.Add("strSubcls_ECD", Type.GetType("System.String"));
            //子类描述
            dc = dt.Columns.Add("strSubcls_Dsc", Type.GetType("System.String"));
            //参数内容
            dc = dt.Columns.Add("strParm_Cntnt", Type.GetType("System.String"));
            //任务顺序号
            dc = dt.Columns.Add("strTsk_Seq_No", Type.GetType("System.String"));
            //参数代码
            dc = dt.Columns.Add("strParm_Cd", Type.GetType("System.String"));
            string sql = "";
            if (!string.IsNullOrEmpty(strParm_Cntnt))
            {
                sql += "F_PrentId='" + strParm_Cntnt + "'";
            }
            else
            {
                sql += " F_ItemId = 38 and F_Layer = 1";
            }

            var sysdt = DbHelperSQL.Query("  select (select F_Value from T_Sys_DictionaryValue where F_ValueId =a .F_PrentId   ) as F_Prent, * from T_Sys_DictionaryValue a where " + sql + " ").Tables[0];
            List<apps7returnList> res = new List<apps7returnList>();

            for (int i = 0; i < sysdt.Rows.Count; i++)
            {
                DataRow newRow;
                newRow = dt.NewRow();
                if (!string.IsNullOrEmpty(strParm_Cntnt))
                {
                    newRow["strPrim_Cgy_ECD"] = sysdt.Rows[i]["F_PrentId"].ToString();
                    newRow["strPrim_Cgy_Dsc"] = sysdt.Rows[i]["F_Prent"].ToString();

                }
                else
                {
                    newRow["strPrim_Cgy_ECD"] = "";
                    newRow["strPrim_Cgy_Dsc"] = "";
                }


                var twodata = DbHelperSQL.Query("  select *  from T_Sys_DictionaryValue where F_ItemId=38 and F_Layer=1 ").Tables[0];

                newRow["strSubcls_ECD"] = sysdt.Rows[i]["F_ValueId"].ToString();
                newRow["strSubcls_Dsc"] = sysdt.Rows[i]["F_Value"].ToString();
                newRow["strParm_Cntnt"] = "";
                newRow["strSubcls_Dsc"] = sysdt.Rows[i]["F_Value"].ToString();
                newRow["strTsk_Seq_No"] = "1";
                newRow["strParm_Cd"] = "04";
                dt.Rows.Add(newRow);
            }
            var obj = new
            {
                state = "success",
                message = "成功",
                returnList = dt,
            };
            return Content(obj.ToJson());
        }
        public class apps7returnList

        {
            public string strPrim_Cgy_ECD;
            public string strPrim_Cgy_Dsc;
            public string strSubcls_ECD;
            public string strSubcls_Dsc;
            public string strParm_Cntnt;
            public string strTsk_Seq_No;
            public string strParm_Cd;
        }
        //市长热线公开热线
        public ActionResult zmhd10009test()
        {
            string sql = "  F_IsDelete=0 ";
            sql += " and F_IsOpen=1 ";
            // sql += " and F_Id<327";
            int source = RequestString.GetInt("strStm_Src_Dsc", 0);//1 市长热线 2 市长信箱 0 连线政府 3 人民网
            string strkey = HttpUtility.UrlDecode(RequestString.GetQueryString("strWrkOrdr_Ttl_Dtl"));//关键字检索
            int state = RequestString.GetInt("strWrkOrdr_StCd", 0);//工单状态代码
            //int workOrdr_StCd = RequestString.GetInt("strWrkOrdr_StCd",0 );//工单状态代码 1-待处理 2-办理中  3-已回复 4-未回复
            string InfoType = HttpUtility.UrlDecode(RequestString.GetQueryString("strWrkOrdr_Lv1_Bsn_TpCd"));//工单一级业务类型代码
            string strstarttime = HttpUtility.UrlDecode(RequestString.GetQueryString("strCrt_StDt"));//创建开始日期
            string strendtime = HttpUtility.UrlDecode(RequestString.GetQueryString("strCrt_EdDt"));//创建结束日期

            string strrepstarttime = HttpUtility.UrlDecode(RequestString.GetQueryString("strStReplyDt"));//回复开始日期
            string strrependtime = HttpUtility.UrlDecode(RequestString.GetQueryString("strEdReplyDt"));//回复结束日期

            string Title = HttpUtility.UrlDecode(RequestString.GetQueryString("strWrkOrdr_Ttl"));//工单标题

            string orderzd = HttpUtility.UrlDecode(RequestString.GetQueryString("strPgg_Seq_TpCd"));//排序方式

            //string strtel = HttpUtility.UrlDecode(RequestString.GetQueryString("strRdial_Tel"));//市民电话

            string Key = HttpUtility.UrlDecode(RequestString.GetQueryString("strWrkOrdr_Lv1_Bsn_TpCd"));//事项一级分类代码
            int isproresult = RequestString.GetInt("strRcrd_ID", 0);//营商标识



            if (Title.Trim() != "" && Title != "undefined")
            {
                sql += " and (F_ComTitle in (" + Title + ") or F_ComContent in (" + Title + ") " +
                    ")";

                //  sql += " and F_ComTitle in (" + Title + ") ";
            }
            if (InfoType.Trim() != "" && InfoType != "undefined")
            {
                sql += " and F_InfoType in (select F_ValueId from T_Sys_DictionaryValue where F_Value like'%" + InfoType.Trim() + "%'  ) ";

            }
            if (Key.Trim() != "" && Key != "undefined")
            {
                sql += " and F_Key in (select F_ValueId from T_Sys_DictionaryValue where F_Value like'%" + Key.Trim() + "%'  ) ";

            }

            if (state != 0)
            {
                if (state == 1)
                {
                    sql += " and F_WorkState in (" + (int)EnumWorkState.neworder + "," + (int)EnumWorkState.submit + "," + (int)EnumWorkState.receive + (int)EnumWorkState.resubmit + ") ";
                }
                else if (state == 2)
                {
                    sql += " and F_WorkState in (" + (int)EnumWorkState.auditreback + "," + (int)EnumWorkState.dealing + "," + (int)EnumWorkState.auditdelay + (int)EnumWorkState.reload + (int)EnumWorkState.audit + (int)EnumWorkState.rejload + ") ";
                }
                else if (state == 3)
                {
                    sql += " and F_WorkState in (" + (int)EnumWorkState.visit + "," + (int)EnumWorkState.finish + ") ";
                }
                else if (state == 4)
                {
                    sql += " and F_WorkState in (" + (int)EnumWorkState.dealed + ") ";
                }

            }
            // SELECT @Name = F_Value FROM T_Sys_DictionaryValue WHERE F_ValueId = @ID
            if (source != 0)
            {
                //1 市长热线 2 市长信箱 0 连线政府 3 人民网
                if (source == 0)
                {
                    source = 2458;
                }
                if (source == 3)
                {
                    source = 4;
                }
                sql += " and F_InfoSource = '" + source + "' ";
            }

            //if (strtel.Trim() != "" && strtel != "undefined")
            //{
            //    sql += " and (F_CusPhone like '%" + strtel + "%' or F_ConPhone like '%" + strtel + "%') ";
            //}
            if (strkey.Trim() != "" && strkey != "undefined")
            {
                sql += " and (F_ComTitle like '%" + strkey + "%' or F_ComContent like '%" + strkey + "%') ";

            }
            if (strstarttime.Trim() != "" && strstarttime != "undefined")
            {
                sql += " and datediff(day,F_CreateTime,'" + strstarttime + "')<=0 ";
            }
            if (strendtime.Trim() != "" && strendtime != "undefined")
            {
                sql += " and datediff(day,F_CreateTime,'" + strendtime + "')>=0   ";
            }


            if (strrepstarttime.Trim() != "" && strrepstarttime != "undefined")
            {
                sql += " and datediff(day,F_EnableTime,'" + strstarttime + "')<=0 ";
            }
            if (strrependtime.Trim() != "" && strrependtime != "undefined")
            {
                sql += " and datediff(day,F_EnableTime,'" + strstarttime + "')>=0 ";
            }

            if (orderzd.Trim() != "" && orderzd != "undefined")
            {
                if (orderzd == "ASC")
                {
                    sql += " order by F_EnableTime asc";
                }
                if (orderzd == "DESC")
                {
                    sql += " order by F_EnableTime desc";
                }
            }

            //var dt = DbHelperSQL.Query(sql).Tables[0];
            var orderlist = workorderBLL.GetModelList(sql);
            DataTable dt = new DataTable();

            DataColumn dc = null;
            //工单编号
            dc = dt.Columns.Add("strWrkOrdr_ID", Type.GetType("System.String"));
            //工单类型代码
            dc = dt.Columns.Add("strWrkOrdr_TpCd", Type.GetType("System.String"));
            //工单状态代码
            dc = dt.Columns.Add("strWrkOrdr_StCd", Type.GetType("System.String"));
            //工单标题
            dc = dt.Columns.Add("strWrkOrdr_Ttl", Type.GetType("System.String"));
            //工单详细情况描述
            dc = dt.Columns.Add("strWrkOrdr_Dtl_StnDsc", Type.GetType("System.String"));
            //当前提交时间
            dc = dt.Columns.Add("strCrt_Dt_Tm", Type.GetType("System.String"));
            //客户名称
            dc = dt.Columns.Add("strCst_Nm", Type.GetType("System.String"));
            //客户编号
            dc = dt.Columns.Add("strCst_ID", Type.GetType("System.String"));
            //工单一级业务类型代码
            dc = dt.Columns.Add("strWrkOrdr_Lv1_Bsn_TpCd", Type.GetType("System.String"));
            //工单一级业务类型描述
            dc = dt.Columns.Add("strWrkOrdr_Lv1_Bsn_TpCd_DESC", Type.GetType("System.String"));

            //工单处理机构编号
            dc = dt.Columns.Add("strWrkOrdr_Pcsg_InsID", Type.GetType("System.String"));
            //工单处理机构名称
            dc = dt.Columns.Add("strWrkOrdr_Pcsg_Inst_Nm", Type.GetType("System.String"));
            //工单处理时间
            dc = dt.Columns.Add("strCnvrstn_No", Type.GetType("System.String"));


            for (int i = 0; i < orderlist.Count; i++)
            {


                DataRow newRow;
                newRow = dt.NewRow();
                newRow["strWrkOrdr_ID"] = orderlist[i].F_WorkOrderId.ToString();
                newRow["strWrkOrdr_TpCd"] = orderlist[i].F_InfoSource.ToString();
                newRow["strWrkOrdr_StCd"] = orderlist[i].F_WorkState.ToString();
                newRow["strWrkOrdr_Ttl"] = orderlist[i].F_ComTitle.ToString();
                if (!string.IsNullOrEmpty(orderlist[i].F_Content.ToString()))
                    newRow["strWrkOrdr_Dtl_StnDsc"] = orderlist[i].F_Content.ToString();
                else
                    newRow["strWrkOrdr_Dtl_StnDsc"] = orderlist[i].F_ComContent.ToString();
               
                newRow["strCrt_Dt_Tm"] = orderlist[i].F_CreateTime.ToString();
                newRow["strCst_Nm"] = orderlist[i].F_CusName.ToString();
                newRow["strCst_ID"] = orderlist[i].F_Id.ToString();

                //  newRow["strWrkOrdr_Lv1_Bsn_TpCd"] = orderlist[i].F_InfoType.ToString();

                if (!string.IsNullOrEmpty(orderlist[i].F_InfoType.ToString()))
                {
                    if (DbHelperSQL.GetSingle("select top 1 F_Value from  T_Sys_DictionaryValue where F_ValueId='" + orderlist[i].F_InfoType.ToString() + "'") != null)
                    {
                        newRow["strWrkOrdr_Lv1_Bsn_TpCd_DESC"] = DbHelperSQL.GetSingle("select top 1 F_Value from  T_Sys_DictionaryValue where F_ValueId='" + orderlist[i].F_InfoType.ToString() + "'").ToString();
                    }

                }

                if (!string.IsNullOrEmpty(orderlist[i].F_MainDeptId.ToString()))
                {
                    newRow["strWrkOrdr_Pcsg_Inst_Nm"] = orderlist[i].F_MainDeptId.ToString();
                    if (DbHelperSQL.GetSingle("select top 1 F_DeptName from  T_Sys_Department where F_DeptId='" + orderlist[i].F_MainDeptId.ToString() + "'") != null)
                    {
                        newRow["strWrkOrdr_Pcsg_Inst_Nm"] = DbHelperSQL.GetSingle("select top 1 F_DeptName from  T_Sys_Department where F_DeptId='" + orderlist[i].F_MainDeptId.ToString() + "'").ToString();
                    }

                }

                newRow["strCnvrstn_No"] = orderlist[i].F_EnableTime.ToString();


                dt.Rows.Add(newRow);
            }



            #region 声音文件和交办超时
            #endregion
            var obj = new
            {
                state = "success",
                message = "成功",
                returnList = dt,
            };
            return Content(obj.ToJson());

        }
        //连线政府
        public ActionResult zmhd10014()
        {
            StreamReader reader = new StreamReader(System.Web.HttpContext.Current.Request.InputStream);
            string sql = "  F_IsDelete=0 ";
           // sql += " and F_IsOpen=1 ";
            var postString = reader.ReadToEnd();
            JObject result = null;
            result = (JObject)Newtonsoft.Json.JsonConvert.DeserializeObject(postString);
            var txnBodyCom = result["txnBodyCom"].ToString();      //市民姓名
            var txnBodyComresult = (JObject)Newtonsoft.Json.JsonConvert.DeserializeObject(txnBodyCom);
            var source = txnBodyComresult["strStm_Src_Dsc"] == null ? "" : txnBodyComresult["strStm_Src_Dsc"].ToString();//1 市长热线 2 市长信箱 0 连线政府 3 人民网 
            if (source != "-1")
            {
                //1 市长热线 2 市长信箱 0 连线政府 3 人民网
                if (source == "0")
                {
                    source = "2458";
                }
                if (source == "3")
                {
                    source = "4";
                }
                sql += " and F_InfoSource = '" + source + "' ";
            }
            if (RedisHelper.StringGet("zmhd10014" + sql) != null)
            {
                return Content(RedisHelper.StringGet("zmhd10014" + sql).ToString());
            }
            DataTable dt = new DataTable();

            DataColumn dc = null;

            //今日诉求数量
            dc = dt.Columns.Add("dayCompNums", Type.GetType("System.String"));
            //今日办结数量   
            dc = dt.Columns.Add("dayFinshNums", Type.GetType("System.String"));
            //本月诉求数量
            dc = dt.Columns.Add("monthCompNums", Type.GetType("System.String"));
            //本月办结数量 
            dc = dt.Columns.Add("monthFinshNums", Type.GetType("System.String"));

            DataRow newRow;
            newRow = dt.NewRow();
            string dayCompNums = "  select COUNT(*) from T_Bus_WorkOrder   where " + sql + " and datediff(day,F_CreateTime,getdate())=0  ";

            if (DbHelperSQL.GetSingle(dayCompNums) != null)
            {
                newRow["dayCompNums"] = DbHelperSQL.GetSingle(dayCompNums).ToString();
            }

            string dayFinshNums = "  select COUNT(*) from T_Bus_WorkOrder   where " + sql + " and  datediff(day,F_CreateTime,getdate())=0    and F_WorkState=9";
            if (DbHelperSQL.GetSingle(dayFinshNums) != null)
            {
                newRow["dayFinshNums"] = DbHelperSQL.GetSingle(dayFinshNums).ToString();
            }

            string monthCompNums = "  select COUNT(*) from T_Bus_WorkOrder   where " + sql + " and   datediff(MONTH,F_CreateTime,getdate())=0 ";
            if (DbHelperSQL.GetSingle(monthCompNums) != null)
            {
                newRow["monthCompNums"] = DbHelperSQL.GetSingle(monthCompNums).ToString();
            }

            string monthFinshNums = "  select COUNT(*) from T_Bus_WorkOrder   where " + sql + " and   datediff(MONTH,F_CreateTime,getdate())=0   and F_WorkState=9 ";
            if (DbHelperSQL.GetSingle(monthFinshNums) != null)
            {
                newRow["monthFinshNums"] = DbHelperSQL.GetSingle(monthFinshNums).ToString();
            }

            dt.Rows.Add(newRow);

            return014 re = new return014();
            if (DbHelperSQL.GetSingle(dayCompNums) != null)
            {
                re.dayCompNums = DbHelperSQL.GetSingle(dayCompNums).ToString();
            }

            if (DbHelperSQL.GetSingle(dayFinshNums) != null)
            {
                re.dayFinshNums = DbHelperSQL.GetSingle(dayFinshNums).ToString();
            }
            if (DbHelperSQL.GetSingle(monthCompNums) != null)
            {
                re.monthCompNums = DbHelperSQL.GetSingle(monthCompNums).ToString();
            }
            if (DbHelperSQL.GetSingle(monthFinshNums) != null)
            {
                re.monthFinshNums = DbHelperSQL.GetSingle(monthFinshNums).ToString();
            }
            string jsonData = "{\"dayCompNums\":" + re.dayCompNums + ",\"dayFinshNums\":" + re.dayFinshNums + ",\"monthCompNums\":\"" + re.monthCompNums + "\",\"monthFinshNums\":\"" + re.monthFinshNums + "\"}";

            var obj = new
            {
                state = "success",
                message = "00",

                returnList = jsonData,

                //   returnList = dt,
            };
            RedisHelper.StringSet("zmhd10014" + sql, obj.ToJson().Replace("state", "C-Response-Desc").Replace("message", "C-API-Status").Replace("returnList", "C-Response-Body"), new TimeSpan(0, 30, 0));
            return Content(obj.ToJson().Replace("state", "C-Response-Desc").Replace("message", "C-API-Status").Replace("returnList", "C-Response-Body"));
        }
        //市民评议
        public ActionResult zmhd10012()
        {
            StreamReader reader = new StreamReader(System.Web.HttpContext.Current.Request.InputStream);
            var postString = reader.ReadToEnd();
            JObject result = null;
            result = (JObject)Newtonsoft.Json.JsonConvert.DeserializeObject(postString);
            var txnBodyCom = result["txnBodyCom"].ToString();
            var txnBodyComresult = (JObject)Newtonsoft.Json.JsonConvert.DeserializeObject(txnBodyCom);
            var strWrkOrdr_ID = txnBodyComresult["strWrkOrdr_ID"] == null ? "" : txnBodyComresult["strWrkOrdr_ID"].ToString();//工单编号
            var strStm_Src_Dsc = txnBodyComresult["strStm_Src_Dsc"] == null ? "" : txnBodyComresult["strStm_Src_Dsc"].ToString();//系统来源描述
            var strWrkOrdr_Cst_Ssf_Cd = txnBodyComresult["strWrkOrdr_Cst_Ssf_Cd"] == null ? "" : txnBodyComresult["strWrkOrdr_Cst_Ssf_Cd"].ToString();//工单客户满意度代码
            var strUdt_Psn_ID = txnBodyComresult["strUdt_Psn_ID"] == null ? "" : txnBodyComresult["strUdt_Psn_ID"].ToString();//市民ID
            var strSsf_Cst_Ass_CntDsc = txnBodyComresult["strSsf_Cst_Ass_CntDsc"] == null ? "" : txnBodyComresult["strSsf_Cst_Ass_CntDsc"].ToString();//评议内容
            var strRltv_InsID = txnBodyComresult["strRltv_InsID"] == null ? "" : txnBodyComresult["strRltv_InsID"].ToString();//回复局委编号 局委编号(不满意必传)
            var strInpt_Inst_Nm = txnBodyComresult["strInpt_Inst_Nm"] == null ? "" : txnBodyComresult["strInpt_Inst_Nm"].ToString();//回复局委名称
            var strHpCnt = txnBodyComresult["strHpCnt"] == null ? "" : txnBodyComresult["strHpCnt"].ToString();//评议次数

            //1 市长热线 2 市长信箱 0 连线政府 3 人民网
            if (strStm_Src_Dsc != null)
            {
                if (strStm_Src_Dsc == "0")
                {
                    strStm_Src_Dsc = "连线政府";
                }
                if (strStm_Src_Dsc == "1")
                {
                    strStm_Src_Dsc = "市长热线";
                }
                if (strStm_Src_Dsc == "2")
                {
                    strStm_Src_Dsc = "市长信箱";
                }
                if (strStm_Src_Dsc == "3")
                {
                    strStm_Src_Dsc = "人民网";
                }
            }

            //1 满意 2 不满意
            if (strWrkOrdr_Cst_Ssf_Cd != null)
            {
                if (strWrkOrdr_Cst_Ssf_Cd == "1")
                {
                    strWrkOrdr_Cst_Ssf_Cd = "非常满意";
                }
               else if (strWrkOrdr_Cst_Ssf_Cd == "2")
                {
                    strWrkOrdr_Cst_Ssf_Cd = "满意";
                }
                else if (strWrkOrdr_Cst_Ssf_Cd == "3")
                {
                    strWrkOrdr_Cst_Ssf_Cd = "基本满意";
                }
                else if (strWrkOrdr_Cst_Ssf_Cd == "4")
                {
                    strWrkOrdr_Cst_Ssf_Cd = "不满意";
                }
                else if (strWrkOrdr_Cst_Ssf_Cd == "5")
                {
                    strWrkOrdr_Cst_Ssf_Cd = "非常不满意";
                }
            }
            var rescon = DbHelperSQL.GetSingle("select count(*) from T_Bus_WorkOrder where F_WorkOrderId='" + strWrkOrdr_ID + "'");
            if (rescon.ToString() == "0")
            {
                var objs = new
                {
                    data = "",
                };
                return Content(objs.ToJson());
            }
            string strSql = string.Format(@"INSERT INTO PublicComment ( [WorkOrderId], [strStm_Src_Dsc], [strWrkOrder_Cst_Ssf_Cd], [strUdt_Psn_ID], [strSsf_Cst_Ass_CntDsc], [strRltv_InsID], [strInpt_Inst_Nm], [strHpCnt], [CreateTime]) 
                   values   ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}') ;select @@IDENTITY ", strWrkOrdr_ID, strStm_Src_Dsc, strWrkOrdr_Cst_Ssf_Cd, strUdt_Psn_ID, strSsf_Cst_Ass_CntDsc, strRltv_InsID, strInpt_Inst_Nm, strHpCnt, DateTime.Now);
            object objres = DbHelperSQL.GetSingle(strSql);
            if (objres == null)
            {
                var objs = new
                {
                    state = "success",
                    message = "成功",
                    data = "",
                };
                return Content(objs.ToJson());
            }
            else
            {
                var objs = new
                {
                    state = "success",
                    message = "成功",
                    data = int.Parse(objres.ToString()),
                };
                return Content(objs.ToJson());
            }
        }
        public ActionResult zmhd10004()
        {
            StreamReader reader = new StreamReader(System.Web.HttpContext.Current.Request.InputStream);
            var postString = reader.ReadToEnd();
            JObject result = null;
            result = (JObject)Newtonsoft.Json.JsonConvert.DeserializeObject(postString);
            var txnBodyCom = result["txnBodyCom"].ToString();
            var txnBodyComresult = (JObject)Newtonsoft.Json.JsonConvert.DeserializeObject(txnBodyCom);
            var strMnplt_TpCd = txnBodyComresult["strMnplt_TpCd"] == null ? "" : txnBodyComresult["strMnplt_TpCd"].ToString();//操作标志
            var strCrt_EmpID = txnBodyComresult["strCrt_EmpID"] == null ? "" : txnBodyComresult["strCrt_EmpID"].ToString();//市民ID
            var strWrkOrdr_ID = txnBodyComresult["strWrkOrdr_ID"] == null ? "" : txnBodyComresult["strWrkOrdr_ID"].ToString();//工单编号
            var strStm_Src_Dsc = txnBodyComresult["strStm_Src_Dsc"] == null ? "" : txnBodyComresult["strStm_Src_Dsc"].ToString();//系统来源
                if (strMnplt_TpCd!="00")
                {
                    string strSql = string.Format(@"update  T_Sys_Collection   set strMnplt_TpCd='"+ strMnplt_TpCd + "' " +
                        "where F_WorkOrderId='"+ strWrkOrdr_ID + "'and " +
                        "strCrt_EmpID='"+ strCrt_EmpID + "'");
                    object objres = DbHelperSQL.GetSingle(strSql);
                    var objs = new
                    {
                        state = "success",
                        message = "成功",
                        data = ""
                    };
                    return Content(objs.ToJson());
                }
                else
                {
                    string strSql = string.Format(@"INSERT INTO T_Sys_Collection ( [F_WorkOrderId], [strCrt_EmpID], [strMnplt_TpCd], [strStm_Src_Dsc], [F_CreateTime]) 
                   values   ('{0}','{1}','{2}','{3}','{4}') ;select @@IDENTITY ", strWrkOrdr_ID, strCrt_EmpID, strMnplt_TpCd, strStm_Src_Dsc, DateTime.Now);
                    object objres = DbHelperSQL.GetSingle(strSql);
                    if (objres == null)
                    {
                        var objs = new
                        {
                            state = "success",
                            message = "成功",
                            data = "",
                        };
                        return Content(objs.ToJson());
                    }
                    else
                    {
                        var objs = new
                        {
                            state = "success",
                            message = "成功",
                            data = int.Parse(objres.ToString()),
                        };
                        return Content(objs.ToJson());
                    }
                }
            
          
           
         
        }
        public ActionResult zmhd10005()
        {
            string sql = "  F_IsDelete=0 ";


            StreamReader reader = new StreamReader(System.Web.HttpContext.Current.Request.InputStream);
            var postString = reader.ReadToEnd();
            JObject result = null;
            result = (JObject)Newtonsoft.Json.JsonConvert.DeserializeObject(postString);


            var txnCommCom = result["txnCommCom"].ToString();


            var txnBodyCom = result["txnBodyCom"].ToString();

            var txnBodyComresult = (JObject)Newtonsoft.Json.JsonConvert.DeserializeObject(txnBodyCom);

            var txnCommComresult = (JObject)Newtonsoft.Json.JsonConvert.DeserializeObject(txnCommCom);
            string strCrt_EmpID = txnBodyComresult["strCrt_EmpID"] == null ? "" : txnBodyComresult["strCrt_EmpID"].ToString(); //
            var source = txnBodyComresult["strStm_Src_Dsc"] == null ? "" : txnBodyComresult["strStm_Src_Dsc"].ToString();// 1 市长热线 2 市长信箱 0 连线政府 3 人民网
            var pageSize = txnCommComresult["tPageJump"] == null ? "1" : txnCommComresult["tPageJump"].ToString();
            var pageNumber = txnCommComresult["tRecInPage"] == null ? "10" : txnCommComresult["tRecInPage"].ToString();
            string sqlwhere = "";
            sql += " and isnull(F_IsResult,0) = '0' ";
            if (source.Trim() != "" && source != "undefined")
            {
                //1 市长热线 2 市长信箱 0 连线政府 3 人民网
                if (source == "0")
                {
                    source = "2458";
                }
                if (source == "3")
                {
                    source = "4";
                }
                sql += " and F_InfoSource = '" + source + "' ";
            }

            if (strCrt_EmpID.Trim() != "" && strCrt_EmpID != "undefined")
            {
                sql += " and F_WorkOrderId in (select F_WorkOrderId " +
                    "from T_Sys_Collection where strCrt_EmpID='"+ strCrt_EmpID + "' and strMnplt_TpCd='00') ";
            }
            else
                return Error("请选择收藏人");
           
          //  sql += "and F_Administrative='00'";
            string orderby = "ORDER BY F_CreateTime DESC";
            int recordCount = 0;
            var orderlist = BLL.PagerBLL.GetListPager(
                "T_Bus_WorkOrder a WITH(NOLOCK)" + sqlwhere,
                "F_WorkOrderId",
                "*",
                      " and " + sql,
                orderby,
                     Convert.ToInt32(pageNumber),
               Convert.ToInt32(pageSize),

                true,
                out recordCount);

            DataTable dt = new DataTable();

            DataColumn dc = null;
            //工单编号
            dc = dt.Columns.Add("strWrkOrdr_ID", Type.GetType("System.String"));
           
            //工单标题
            dc = dt.Columns.Add("strWrkOrdr_Ttl", Type.GetType("System.String"));
            //工单详细情况描述
            dc = dt.Columns.Add("strWrkOrdr_Dtl_StnDsc", Type.GetType("System.String"));
           
            //工单一级业务类型代码
            dc = dt.Columns.Add("strWrkOrdr_Lv1_Bsn_TpCd", Type.GetType("System.String"));
            //工单一级业务类型描述
            dc = dt.Columns.Add("strWrkOrdr_Lv1_Bsn_TpCd_DESC", Type.GetType("System.String"));
            dc = dt.Columns.Add("strWrkOrdr_Lvl2_Bsn_TpCd", Type.GetType("System.String"));
            //工单二级业务类型代码
            dc = dt.Columns.Add("strWrkOrdr_Lvl2_Bsn_TpCd_DESC", Type.GetType("System.String"));
            
            dc = dt.Columns.Add("strStm_Src_Dsc", Type.GetType("System.String"));
            
             //工单处理时间
             dc = dt.Columns.Add("strCnvrstn_No", Type.GetType("System.String"));
            //回复局委编号
            dc = dt.Columns.Add("strRltv_InsID", Type.GetType("System.String"));
            //回复局委名称
            dc = dt.Columns.Add("strInpt_Inst_Nm", Type.GetType("System.String"));
            dc = dt.Columns.Add("strCrt_Dt_Tm", Type.GetType("System.String"));
            
         

          
            for (int i = 0; i < orderlist.Rows.Count; i++)
            {
                DataRow newRow;
                newRow = dt.NewRow();
                //工单编号
                newRow["strWrkOrdr_ID"] = orderlist.Rows[i]["F_WorkOrderId"].ToString();

                newRow["strWrkOrdr_Ttl"] = orderlist.Rows[i]["F_ComTitle"].ToString();
                if (!string.IsNullOrEmpty(orderlist.Rows[i]["F_Content"].ToString()))
                    newRow["strWrkOrdr_Dtl_StnDsc"] = orderlist.Rows[i]["F_Content"].ToString();
                else
                    newRow["strWrkOrdr_Dtl_StnDsc"] = orderlist.Rows[i]["F_ComContent"].ToString();
                newRow["strCrt_Dt_Tm"] = orderlist.Rows[i]["F_CreateTime"].ToString();
                if (!string.IsNullOrEmpty(orderlist.Rows[i]["F_Key"].ToString()))
                {
                    try
                    {
                        var dicvalue = new BLL.T_Sys_DictionaryValue
                                               ().GetModel(int.Parse(orderlist.Rows[i]["F_Key"].ToString()));
                        if (dicvalue != null)
                        {
                            if (dicvalue.F_Layer == 4)
                            {
                                var dic = new BLL.T_Sys_DictionaryValue().GetModelList
                                    ("F_ValueId =(SELECT F_PrentId  FROM T_Sys_DictionaryValue WHERE F_ValueId = (SELECT F_PrentId  FROM T_Sys_DictionaryValue WHERE F_ValueId = (SELECT F_PrentId  FROM T_Sys_DictionaryValue WHERE  F_ValueId = '" + orderlist.Rows[i]["F_Key"].ToString() + "')) ) ");
                                if (dic != null && dic.Count > 0)
                                {
                                    newRow["strWrkOrdr_Lv1_Bsn_TpCd"] = dic[0].F_ValueId.ToString();
                                    newRow["strWrkOrdr_Lv1_Bsn_TpCd_DESC"] = dic[0].F_Value;
                                }
                                var dic1 = new BLL.T_Sys_DictionaryValue().GetModelList
                                 ("F_ValueId =(SELECT F_PrentId  FROM T_Sys_DictionaryValue WHERE F_ValueId = (SELECT F_PrentId  FROM T_Sys_DictionaryValue WHERE   F_ValueId = '" + orderlist.Rows[i]["F_Key"].ToString() + "')) ");
                                if (dic != null && dic.Count > 0)
                                {
                                    newRow["strWrkOrdr_Lvl2_Bsn_TpCd"] = dic1[0].F_ValueId.ToString();
                                    newRow["strWrkOrdr_Lvl2_Bsn_TpCd_DESC"] = dic1[0].F_Value;
                                }

                            }
                            else if (dicvalue.F_Layer == 3)
                            {
                                var dic = new BLL.T_Sys_DictionaryValue().GetModelList
                                      ("F_ValueId =(SELECT F_PrentId  FROM T_Sys_DictionaryValue WHERE F_ValueId = (SELECT F_PrentId  FROM T_Sys_DictionaryValue WHERE   F_ValueId = '" + orderlist.Rows[i]["F_Key"].ToString() + "')) ");
                                if (dic != null && dic.Count > 0)
                                {
                                    newRow["strWrkOrdr_Lv1_Bsn_TpCd"] = dic[0].F_ValueId.ToString();
                                    newRow["strWrkOrdr_Lv1_Bsn_TpCd_DESC"] = dic[0].F_Value;
                                }
                                var dic1 = new BLL.T_Sys_DictionaryValue().GetModelList
                                      ("F_ValueId =(SELECT F_PrentId  FROM T_Sys_DictionaryValue WHERE F_ValueId  = '" + orderlist.Rows[i]["F_Key"].ToString().ToString() + "') ");
                                if (dic != null && dic.Count > 0)
                                {
                                    newRow["strWrkOrdr_Lvl2_Bsn_TpCd"] = dic1[0].F_ValueId.ToString();
                                    newRow["strWrkOrdr_Lvl2_Bsn_TpCd_DESC"] = dic1[0].F_Value;
                                }

                            }
                            else if (dicvalue.F_Layer == 2)
                            {
                                var dic = new BLL.T_Sys_DictionaryValue().GetModelList
                                      ("F_ValueId =(SELECT F_PrentId  FROM T_Sys_DictionaryValue WHERE F_ValueId  = '" + orderlist.Rows[i]["F_Key"].ToString().ToString() + "') ");
                                if (dic != null && dic.Count > 0)
                                {
                                    newRow["strWrkOrdr_Lv1_Bsn_TpCd"] = dic[0].F_ValueId.ToString();
                                    newRow["strWrkOrdr_Lv1_Bsn_TpCd_DESC"] = dic[0].F_Value;
                                }
                                newRow["strWrkOrdr_Lvl2_Bsn_TpCd"] = dicvalue.F_ValueId.ToString();
                                newRow["strWrkOrdr_Lvl2_Bsn_TpCd_DESC"] = dicvalue.F_Value;

                            }
                            else
                            {
                                newRow["strWrkOrdr_Lv1_Bsn_TpCd"] = dicvalue.F_ValueId.ToString();
                                newRow["strWrkOrdr_Lv1_Bsn_TpCd_DESC"] = dicvalue.F_Value;
                                newRow["strWrkOrdr_Lvl2_Bsn_TpCd"] = dicvalue.F_ValueId.ToString();
                                newRow["strWrkOrdr_Lvl2_Bsn_TpCd_DESC"] = dicvalue.F_Value;
                            }
                        }

                    }
                    catch
                    {
                    }

                }
                if (!string.IsNullOrEmpty(orderlist.Rows[i]["F_MainDeptId"].ToString()))
                {
                 
                    if (DbHelperSQL.GetSingle("select top 1 F_DeptName from  T_Sys_Department where F_DeptId='" + orderlist.Rows[i]["F_MainDeptId"].ToString() + "'") != null)
                    {
                        newRow["strInpt_Inst_Nm"] = orderlist.Rows[i]["F_MainDeptId"].ToString();
                       newRow["strInpt_Inst_Nm"] = DbHelperSQL.GetSingle("select top 1 F_DeptName from  T_Sys_Department where F_DeptId='" + orderlist.Rows[i]["F_MainDeptId"].ToString() + "'").ToString();
                    }

                }
                newRow["strCnvrstn_No"] = orderlist.Rows[i]["F_DealTime"].ToString();
                if (DbHelperSQL.GetSingle("select top 1 F_Value from  T_Sys_DictionaryValue where F_ValueId='" + orderlist.Rows[i]["F_InfoSource"].ToString() + "'") != null)
                {
                    newRow["strStm_Src_Dsc"] = DbHelperSQL.GetSingle("select top 1 F_Value from  T_Sys_DictionaryValue where F_ValueId='" + orderlist.Rows[i]["F_InfoSource"].ToString() + "'").ToString();
                }

                dt.Rows.Add(newRow);
            }



            #region 声音文件和交办超时
            #endregion
            //var obj = new
            //{
            //    state = "success",
            //    message = "成功",
            //    returnList = dt,
            //};
            var cosum = DbHelperSQL.GetSingle("  select count(*)  from T_Bus_WorkOrder  where " + sql).ToString();
            //  var cosum = dt.Rows.Count;
            pagination pa = new pagination();
            pa.tCurrTotalPage = Convert.ToInt32(pageSize);
            pa.totalPage = Convert.ToInt32(Convert.ToInt32(cosum) / Convert.ToInt32(pageNumber));

            pa.total_rec = Convert.ToInt32(cosum);
            pa.tCurrTotalRec = Convert.ToInt32(pageNumber);

            var obj = new
            {
                state = "success",
                message = "成功",
                pagination = pa,
                returnList = dt
            };
            return Content(obj.ToJson());
        }
        public class return014
        {

            public string dayCompNums;
            public string dayFinshNums;
            public string monthCompNums;
            public string monthFinshNums;
        }
        public class return015
        {
            public string dayNums;
            public string monthNums;
            public string yestNums;
            public string histNums;
        }
        //市长信箱-数据公示
        public ActionResult zmhd10015()
        {
          
            StreamReader reader = new StreamReader(System.Web.HttpContext.Current.Request.InputStream);
            string sql = "  F_IsDelete=0 ";
           // sql += " and F_IsOpen=1 ";
            var postString = reader.ReadToEnd();
            JObject result = null;
            result = (JObject)Newtonsoft.Json.JsonConvert.DeserializeObject(postString);
            var txnBodyCom = result["txnBodyCom"].ToString();      //市民姓名 
            var txnBodyComresult = (JObject)Newtonsoft.Json.JsonConvert.DeserializeObject(txnBodyCom);
            var source = txnBodyComresult["strStm_Src_Dsc"] == null ? "" : txnBodyComresult["strStm_Src_Dsc"].ToString();//1 市长热线 2 市长信箱 0 连线政府 3 人民网 
            if (source != "-1")
            {
                //1 市长热线 2 市长信箱 0 连线政府 3 人民网
                if (source == "0")
                {
                    source = "2458";
                }
                if (source == "3")
                {
                    source = "4";
                }
                sql += " and F_InfoSource = '" + source + "' ";
            }
            // var orderlist = workorderBLL.GetModelList(sql);
            if (RedisHelper.StringGet("zmhd10015" + sql ) != null)
            {
                return Content(RedisHelper.StringGet("zmhd10015" + sql).ToString());
            }

            DataTable dt = new DataTable();

            DataColumn dc = null;

            //今日来信数量
            dc = dt.Columns.Add("dayNums", Type.GetType("System.String"));
            //本月来信数量   
            dc = dt.Columns.Add("monthNums", Type.GetType("System.String"));
            //昨日来信数量
            dc = dt.Columns.Add("yestNums", Type.GetType("System.String"));
            //历史来信数量   
            dc = dt.Columns.Add("histNums", Type.GetType("System.String"));

            DataRow newRow;
            newRow = dt.NewRow();
            string dayNums = "  select COUNT(*) from T_Bus_WorkOrder   where " + sql + " and datediff(day,F_CreateTime,getdate())=0  ";
            newRow["dayNums"] = DbHelperSQL.GetSingle(dayNums).ToString();

            string monthNums = "  select COUNT(*) from T_Bus_WorkOrder   where " + sql + " and   datediff(MONTH,F_CreateTime,getdate())=0 ";
            newRow["monthNums"] = DbHelperSQL.GetSingle(monthNums).ToString();

            string yestNums = "  select COUNT(*) from T_Bus_WorkOrder   where " + sql + " and  DATEDIFF(day,F_CreateTime,GETDATE()-1)=0 ";
            newRow["yestNums"] = DbHelperSQL.GetSingle(yestNums).ToString();

            string histNums = "  select COUNT(*) from T_Bus_WorkOrder   where " + sql;

            newRow["histNums"] = DbHelperSQL.GetSingle(histNums).ToString();
            dt.Rows.Add(newRow);
            //var obj = new
            //{
            //    state = "success",
            //    message = "成功",
            //    returnList = dt,
            //};
            //return Content(obj.ToJson());

            return015 re = new return015();
            re.dayNums = DbHelperSQL.GetSingle(dayNums).ToString();
            re.monthNums = DbHelperSQL.GetSingle(monthNums).ToString();
            re.yestNums = DbHelperSQL.GetSingle(yestNums).ToString();
            re.histNums = DbHelperSQL.GetSingle(histNums).ToString();

            string jsonData = "{\"dayNums\":" + re.dayNums + ",\"monthNums\":" + re.monthNums + ",\"yestNums\":\"" + re.yestNums + "\",\"histNums\":\"" + re.histNums + "\"}";

            //var obj = new
            //{
            //    state = "success",
            //    message = "00",
            //    returnList = re,
            //};


            var obj = new
            {
                state = "success",
                message = "00",
                returnList = jsonData,
            };
            RedisHelper.StringSet("zmhd10015" + sql, obj.ToJson().Replace("state", "C-Response-Desc").Replace("message", "C-API-Status").Replace("returnList", "C-Response-Body"), new TimeSpan(0, 30, 0));
            //  string jsonData = "{\"result\":true,\"receiver_id\":" + receiver_id + ",\"sender_id\":" + sender_id + ",\"type\":\"" + type + "\",\"data\":\"" + data + "\"}";
            return Content(obj.ToJson().Replace("state", "C-Response-Desc").Replace("message", "C-API-Status").Replace("returnList", "C-Response-Body"));
        }
        public class chmList
        {
            public string strAtch_Chn_Nm { set; get; }
            public string strCur_Atch_Rte_Dsc { set; get; }
        }
        public ActionResult HttpUploadFiles(string path)
        {

            string url = "http://125.45.12.146:9998/Web/UploadFile";
            // 设置参数
            HttpWebRequest request = WebRequest.Create(url) as HttpWebRequest;
            CookieContainer cookieContainer = new CookieContainer();
            request.CookieContainer = cookieContainer;
            request.AllowAutoRedirect = true;
            request.Method = "POST";
            string boundary = DateTime.Now.Ticks.ToString("X"); // 随机分隔线
            request.ContentType = "multipart/form-data;charset=utf-8;boundary=" + boundary;
            byte[] itemBoundaryBytes = Encoding.UTF8.GetBytes("\r\n--" + boundary + "\r\n");
            byte[] endBoundaryBytes = Encoding.UTF8.GetBytes("\r\n--" + boundary + "--\r\n");
            int pos = path.LastIndexOf("\\");
            string fileName = path.Substring(pos + 1);

            //请求头部信息
            StringBuilder sbHeader = new StringBuilder(string.Format("Content-Disposition:form-data;name=\"file\";filename=\"{0}\"\r\nContent-Type:application/octet-stream\r\n\r\n", fileName));
            byte[] postHeaderBytes = Encoding.UTF8.GetBytes(sbHeader.ToString());

            FileStream fs = new FileStream(path, FileMode.Open, FileAccess.Read);
            byte[] bArr = new byte[fs.Length];
            fs.Read(bArr, 0, bArr.Length);
            //fs.Flush();
            fs.Close();
            Stream postStream = request.GetRequestStream();
            postStream.Write(itemBoundaryBytes, 0, itemBoundaryBytes.Length);
            postStream.Write(postHeaderBytes, 0, postHeaderBytes.Length);
            postStream.Write(bArr, 0, bArr.Length);
            postStream.Write(endBoundaryBytes, 0, endBoundaryBytes.Length);
            postStream.Close();
            //发送请求并获取相应回应数据
            HttpWebResponse response = request.GetResponse() as HttpWebResponse;
            string result = "";
            //直到request.GetResponse()程序才开始向目标网页发送Post请求
            Stream instream = response.GetResponseStream();
            using (StreamReader reader = new StreamReader(instream, Encoding.UTF8))
            {
                result = reader.ReadToEnd();
            }
            goback workorders = JsonConvert.DeserializeObject<goback>(result);
            return Success("", workorders);
        }
        /// <summary>
        /// Http上传文件
        /// </summary>
        public goback HttpUploadFile(string path)
        {

            string url = "http://125.45.12.146:9998/Web/UploadFile";
            // 设置参数
            HttpWebRequest request = WebRequest.Create(url) as HttpWebRequest;
            CookieContainer cookieContainer = new CookieContainer();
            request.CookieContainer = cookieContainer;
            request.AllowAutoRedirect = true;
            request.Method = "POST";
            string boundary = DateTime.Now.Ticks.ToString("X"); // 随机分隔线
            request.ContentType = "multipart/form-data;charset=utf-8;boundary=" + boundary;
            byte[] itemBoundaryBytes = Encoding.UTF8.GetBytes("\r\n--" + boundary + "\r\n");
            byte[] endBoundaryBytes = Encoding.UTF8.GetBytes("\r\n--" + boundary + "--\r\n");
            int pos = path.LastIndexOf("\\");
            string fileName = path.Substring(pos + 1);

            //请求头部信息
            StringBuilder sbHeader = new StringBuilder(string.Format("Content-Disposition:form-data;name=\"file\";filename=\"{0}\"\r\nContent-Type:application/octet-stream\r\n\r\n", fileName));
            byte[] postHeaderBytes = Encoding.UTF8.GetBytes(sbHeader.ToString());

            FileStream fs = new FileStream(path, FileMode.Open, FileAccess.Read);
            byte[] bArr = new byte[fs.Length];
            fs.Read(bArr, 0, bArr.Length);
            fs.Flush();
            //   fs.Close();
            Stream postStream = request.GetRequestStream();
            postStream.Write(itemBoundaryBytes, 0, itemBoundaryBytes.Length);
            postStream.Write(postHeaderBytes, 0, postHeaderBytes.Length);
            postStream.Write(bArr, 0, bArr.Length);
            postStream.Write(endBoundaryBytes, 0, endBoundaryBytes.Length);
            postStream.Close();
            //发送请求并获取相应回应数据
            HttpWebResponse response = request.GetResponse() as HttpWebResponse;
            string result = "";
            //直到request.GetResponse()程序才开始向目标网页发送Post请求
            Stream instream = response.GetResponseStream();
            using (StreamReader reader = new StreamReader(instream, Encoding.UTF8))
            {
                result = reader.ReadToEnd();
            }
            goback workorders = JsonConvert.DeserializeObject<goback>(result);
            return workorders;
        }
        public class goback
        {
            public string state { set; get; }
            public string message { set; get; }
            public List<Model.T_Sys_Accessories> data { set; get; }
        }
        //提交诉求
        public ActionResult zmhd10003()
        {
            StreamReader reader = new StreamReader(System.Web.HttpContext.Current.Request.InputStream);
            //测试短信发送 测试

            var postString = reader.ReadToEnd();

            //     if (!string.IsNullOrWhiteSpace(postString))
            //      {
            JObject result = null;
            result = (JObject)Newtonsoft.Json.JsonConvert.DeserializeObject(postString);
            var txnBodyCom = result["txnBodyCom"].ToString();      //市民姓名 
            var txnBodyComresult = (JObject)Newtonsoft.Json.JsonConvert.DeserializeObject(txnBodyCom);
            var atchmList = txnBodyComresult["atchmList"].ToString();
           


            var replies = JsonConvert.DeserializeObject<List<chmList>>(atchmList);

            var strRcrd_ID = txnBodyComresult["strRcrd_ID"] == null ? "" : txnBodyComresult["strRcrd_ID"].ToString();     //营商标识



            var F_CusName = txnBodyComresult["strCst_Nm"] == null ? "" : txnBodyComresult["strCst_Nm"].ToString();     //市民姓名 
            var strSmsCode = txnBodyComresult["strSmsCode"] == null ? "" : txnBodyComresult["strSmsCode"].ToString();     //验证码

            string F_ComTitle = txnBodyComresult["strWrkOrdr_Ttl"] == null ? "" : txnBodyComresult["strWrkOrdr_Ttl"].ToString();//工单标题

            //工单详细情况描述
            string F_ComContent = txnBodyComresult["strWrkOrdr_Dtl_StnDsc"] == null ? "" : txnBodyComresult["strWrkOrdr_Dtl_StnDsc"].ToString();
            //工单详细情况描述
            string strWrkOrdr_Lv1_Bsn_TpCd = txnBodyComresult["strWrkOrdr_Lv1_Bsn_TpCd"] == null ? "" : txnBodyComresult["strWrkOrdr_Lv1_Bsn_TpCd"].ToString();


            //工单详细情况描述
            string strWrkOrdr_Lvl2_Bsn_TpCd = txnBodyComresult["strWrkOrdr_Lvl2_Bsn_TpCd"] == null ? "" : txnBodyComresult["strWrkOrdr_Lvl2_Bsn_TpCd"].ToString();
            //手机号
            string F_CusPhone = txnBodyComresult["strRdial_Tel"] == null ? "" : txnBodyComresult["strRdial_Tel"].ToString(); ;
            if (string.IsNullOrEmpty(F_CusPhone))
                return Error("请输入手机号码");
            string msgcount = "您的验证码是" + strSmsCode + "，10分钟内有效。";
            if (string .IsNullOrEmpty (strSmsCode))
                return Error("请输入验证码");
            var sms = new BLL.T_SMS_RecvSMS().GetModelList("Content='" + msgcount + "' and CallerNum='" + F_CusPhone + "'order by RecvTime desc");
            if (sms != null && sms.Count > 0)
            {
                var modelSms = sms.First();
                if ((DateTime.Now - modelSms.RecvTime).Minutes > 10)
                {
                    return Error("验证码已失效");
                }
            }
            else
                return Error("请输入正确验证码");
            //  var tes = result["atchmList"].ToString();
            List<atchmList> arli = new List<atchmList>();
            //系统来源描述
            string source = txnBodyComresult["strStm_Src_Dsc"] == null ? "" : txnBodyComresult["strStm_Src_Dsc"].ToString();
            if (source != "-1")
            {
                //1 市长热线 2 市长信箱 0 连线政府 3 人民网
                if (source == "连线政府")
                {
                    if (!string .IsNullOrEmpty (strRcrd_ID))
                    {
                        if (strRcrd_ID=="营商")
                        {
                            source = "2501";
                        }
                        else
                            source = "2458";
                    }
                    else
                        source = "2458";
                }
                if (source == "人民网")
                {
                    source = "4";
                }
                if (source == "市长热线")
                {
                    source = "1";
                }
                if (source == "市长信箱")
                {
                    source = "2";
                }
                if (source == "0")
                {
                    if (!string.IsNullOrEmpty(strRcrd_ID))
                    {
                        if (strRcrd_ID == "营商")
                        {
                            source = "2501";
                        }
                        else
                            source = "2458";
                    }
                    else
                        source = "2458";
                }
                if (source == "3")
                {
                    source = "4";
                }
            }

            Model.T_Bus_WorkOrder modelT_Bus_WorkOrder = new Model.T_Bus_WorkOrder();
            using (TransactionScope trans = new TransactionScope())
            {
                string creattime = DateTime.Now.ToString("yyyy-MM-dd") + " 00:00:00";
                string endtime = DateTime.Now.ToString("yyyy-MM-dd") + " 23:59:59";
                modelT_Bus_WorkOrder.F_WorkOrderId = workorderBLL.GetNewWorkOrderID(Convert.ToInt32(source), 0, creattime, endtime);

                modelT_Bus_WorkOrder.F_WorkState = 1;
                modelT_Bus_WorkOrder.F_InfoSource = Convert.ToInt32(source);//信息来源
//   modelT_Bus_WorkOrder.F_InfoType = type;//信息类别
                modelT_Bus_WorkOrder.F_CusName = F_CusName;//投诉人姓名
                modelT_Bus_WorkOrder.F_CusPhone = F_CusPhone;//来电号码
                modelT_Bus_WorkOrder.F_ComTitle = F_ComTitle;//标题
                modelT_Bus_WorkOrder.F_ComContent = F_ComContent;//情况摘要（投诉内容）
                if (!string.IsNullOrEmpty(strWrkOrdr_Lvl2_Bsn_TpCd))
                {
                    modelT_Bus_WorkOrder.F_Key = strWrkOrdr_Lvl2_Bsn_TpCd;
                }
                else if (!string.IsNullOrEmpty(strWrkOrdr_Lv1_Bsn_TpCd))
                {
                    modelT_Bus_WorkOrder.F_Key = strWrkOrdr_Lv1_Bsn_TpCd;
                }

                modelT_Bus_WorkOrder.F_CreateTime = DateTime.Now;

                modelT_Bus_WorkOrder.F_CreateUser = "jianhang";

                string ids = "";
                #region 多个上传



                if (replies != null && replies.Count > 0)
                {
                    foreach (var it in replies)
                    {
                        if (it!=null )
                        {
                            Model.T_Sys_Accessories model_T_Sys_Accessories = new Model.T_Sys_Accessories();
                            model_T_Sys_Accessories.F_AddTime = DateTime.Now;//上传时间
                            if (string.IsNullOrEmpty(it.strCur_Atch_Rte_Dsc))
                                continue;
                         
                            model_T_Sys_Accessories.F_FileType = "." +
                                it.strCur_Atch_Rte_Dsc.Split('.')[1];//附件类型
                            model_T_Sys_Accessories.F_FileName = it.strAtch_Chn_Nm + "."+it.strCur_Atch_Rte_Dsc.Split('.')[1];//附件名称
                          
                            model_T_Sys_Accessories.F_FileUrl = it.strCur_Atch_Rte_Dsc;//附件地址
                                                                                       // model_T_Sys_Accessories.F_Size = file.ContentLength;
                            model_T_Sys_Accessories.F_UserCode = "jianhang";//上传人  
                            int id = new BLL.T_Sys_Accessories().Add(model_T_Sys_Accessories);

                            if (ids == "")
                                ids = "" + id;
                            else
                                ids += "," + id;
                        }
                    }
                }
                #endregion
                if (!string.IsNullOrEmpty(ids))
                {
                    modelT_Bus_WorkOrder.F_File = ids.TrimEnd(',');//附件
                }
                int a = workorderBLL.Add(modelT_Bus_WorkOrder);
                #region 插入操作记录
                BLL.T_Bus_Operation operBLL = new BLL.T_Bus_Operation();
                Model.T_Bus_Operation oper = new Model.T_Bus_Operation();
                oper.F_WorkOrderId = modelT_Bus_WorkOrder.F_WorkOrderId;
                oper.F_State = modelT_Bus_WorkOrder.F_WorkState;
                oper.F_Message = "jianhang" + " 登记并提交了工单,工单编号：" + modelT_Bus_WorkOrder.F_WorkOrderId;
                oper.F_CreateUser = "jianhang";
                oper.F_CreateTime = DateTime.Now;
                oper.F_IsDelete = 0;
                oper.F_File = ids.TrimEnd(',');//附件
                operBLL.Add(oper);
                #endregion
                //   bool n = SMSController.AddSmS(0, count, modelT_Bus_WorkOrder.F_CusPhone, "4284", "{'name':'" + modelT_Bus_WorkOrder.F_ComTitle + "'}");

                //推送消息表
                msg.AddInternalMessagesInfo("工单消息", oper.F_Message + "，工单编号：" + oper.F_WorkOrderId, "jianhang", "", (int)EnumSmsType.workorder);

                string count = "您反映的事项已受理并转交相关部门处理，感谢您拨打市长热线！";
                bool n = SMSController.AddSmS(133, "", count, modelT_Bus_WorkOrder.F_CusPhone, "146926", "");

                trans.Complete();
            }
            var obj = new
            {
                state = "success",
                message = "成功",
                strWrkOrdr_ID = modelT_Bus_WorkOrder.F_WorkOrderId,
                strStm_Src_Dsc = source

            };
            return Content(obj.ToJson());
            //var orderlist = workorderBLL.GetModelList(sql);
            //DataTable dt = new DataTable();

            //DataColumn dc = null;
            ////系统来源描述
            //dc = dt.Columns.Add("strStm_Src_Dsc", Type.GetType("System.String"));
            ////工单编号
            //dc = dt.Columns.Add("strWrkOrdr_ID", Type.GetType("System.String"));
            ////工单类型代码
            //dc = dt.Columns.Add("strWrkOrdr_TpCd", Type.GetType("System.String"));
            ////工单状态代码
            //dc = dt.Columns.Add("strWrkOrdr_StCd", Type.GetType("System.String"));
            ////工单状态描述
            //dc = dt.Columns.Add("strWrkOrdr_StCd_DESC", Type.GetType("System.String"));
            ////工单一级业务类型代码
            //dc = dt.Columns.Add("strWrkOrdr_Lv1_Bsn_TpCd", Type.GetType("System.String"));
            ////工单一级业务类型描述
            //dc = dt.Columns.Add("strWrkOrdr_Lv1_Bsn_TpCd_DESC", Type.GetType("System.String"));
            ////客户名称
            //dc = dt.Columns.Add("strCst_Nm", Type.GetType("System.String"));
            ////客户编号
            //dc = dt.Columns.Add("strCst_ID", Type.GetType("System.String"));
            ////工单标题
            //dc = dt.Columns.Add("strWrkOrdr_Ttl", Type.GetType("System.String"));
            ////工单详细情况描述
            //dc = dt.Columns.Add("strWrkOrdr_Dtl_StnDsc", Type.GetType("System.String"));
            ////管理中心回复(最新)
            //dc = dt.Columns.Add("strWrkOrdr_Splmt_Cntnt", Type.GetType("System.String"));
            ////创建日期时间
            //dc = dt.Columns.Add("strCrt_Dt_Tm", Type.GetType("System.String"));
            ////回复局委编号
            //dc = dt.Columns.Add("strRltv_InsID", Type.GetType("System.String"));
            ////回复局委名称
            //dc = dt.Columns.Add("strInpt_Inst_Nm", Type.GetType("System.String"));
            ////回复时间
            //dc = dt.Columns.Add("strCnvrstn_No", Type.GetType("System.String"));
            ////局委回复内容
            //dc = dt.Columns.Add("strWrkOrdr_Pcsg_StnCm", Type.GetType("System.String"));
        }
        public ActionResult zmhd10002test()
        {

            //    bool hhfhfgg = SMSController.AddSmS(userId, "", "您反映的事项已受理并转交相关部门处理，感谢您拨打市长热线！", "18937188307", "146926", "");

            StreamReader reader = new StreamReader(System.Web.HttpContext.Current.Request.InputStream);
            string sql = "  F_IsDelete=0 ";
            sql += " and F_IsOpen=1 ";
            var postString = reader.ReadToEnd();
            JObject result = null;
            result = (JObject)Newtonsoft.Json.JsonConvert.DeserializeObject(postString);
            var txnBodyCom = result["txnBodyCom"].ToString();      //市民姓名 

            var txnBodyComresult = (JObject)Newtonsoft.Json.JsonConvert.DeserializeObject(txnBodyCom);

            var source = txnBodyComresult["strStm_Src_Dsc"] == null ? "" : txnBodyComresult["strStm_Src_Dsc"].ToString();
            var pageNumber = txnBodyComresult["pageNumber"] == null ? "1" : txnBodyComresult["pageNumber"].ToString();
            var pageSize = txnBodyComresult["pageSize"] == null ? "10" : txnBodyComresult["pageSize"].ToString();
            var state = txnBodyComresult["strWrkOrdr_StCd"] == null ? "" : txnBodyComresult["strWrkOrdr_StCd"].ToString(); //工单状态代码 1-待处理 2-办理中  3-已回复 4-未回复

            if (source != "-1")
            {
                //1 市长热线 2 市长信箱 0 连线政府 3 人民网
                if (source == "0")
                {
                    source = "2458";
                }
                if (source == "3")
                {
                    source = "4";
                }
                sql += " and F_InfoSource = '" + source + "' ";
            }

            if (state != "0")
            {
                if (state == "1")
                {
                    sql += " and F_WorkState in (" + (int)EnumWorkState.neworder + "," + (int)EnumWorkState.submit + "," + (int)EnumWorkState.receive + (int)EnumWorkState.resubmit + ") ";
                }
                else if (state == "2")
                {
                    sql += " and F_WorkState in (" + (int)EnumWorkState.auditreback + "," + (int)EnumWorkState.dealing + "," + (int)EnumWorkState.auditdelay + (int)EnumWorkState.reload + (int)EnumWorkState.audit + (int)EnumWorkState.rejload + ") ";
                }
                else if (state == "3")
                {
                    sql += " and F_WorkState in (" + (int)EnumWorkState.visit + "," + (int)EnumWorkState.finish + ") ";
                }
                else if (state == "4")
                {
                    sql += " and F_WorkState in (" + (int)EnumWorkState.dealed + ") ";
                }

            }


            string strusercode = txnBodyComresult["strCst_ID"] == null ? "" : txnBodyComresult["strCst_ID"].ToString();//创建员工编号
            string strtel = txnBodyComresult["strRdial_Tel"] == null ? "" : txnBodyComresult["strRdial_Tel"].ToString();//市民电话
            string strkey = txnBodyComresult["strWrkOrdr_Ttl_Dtl"] == null ? "" : txnBodyComresult["strWrkOrdr_Ttl_Dtl"].ToString();//关键字检索
            string InfoType = txnBodyComresult["strWrkOrdr_Lv1_Bsn_TpCd"] == null ? "" : txnBodyComresult["strWrkOrdr_Lv1_Bsn_TpCd"].ToString();//工单一级业务类型代码
            string strstarttime = txnBodyComresult["strCrt_StDt"] == null ? "" : txnBodyComresult["strCrt_StDt"].ToString();//创建开始日期
            string strendtime = txnBodyComresult["strCrt_EdDt"] == null ? "" : txnBodyComresult["strCrt_EdDt"].ToString(); ;//创建结束日期
            string Key = txnBodyComresult["strWrkOrdr_Lv1_Bsn_TpCd"] == null ? "" : txnBodyComresult["strWrkOrdr_Lv1_Bsn_TpCd"].ToString();//事项一级分类代码
            string isproresult = txnBodyComresult["strRcrd_ID"] == null ? "" : txnBodyComresult["strRcrd_ID"].ToString();//营商标识
            string Title = txnBodyComresult["strWrkOrdr_Ttl"] == null ? "" : txnBodyComresult["strWrkOrdr_Ttl"].ToString();//工单标题

            if (Title.Trim() != "" && Title != "undefined")
            {
                sql += " and F_ComTitle in (" + Title + ") ";

            }
            if (InfoType.Trim() != "" && InfoType != "undefined")
            {
                sql += " and F_InfoType in (select F_ValueId from T_Sys_DictionaryValue where F_Value like'%" + InfoType.Trim() + "%'  ) ";

            }
            if (Key.Trim() != "" && Key != "undefined")
            {
                sql += " and F_Key in (select F_ValueId from T_Sys_DictionaryValue where F_Value like'%" + Key.Trim() + "%'  ) ";

            }

            // SELECT @Name = F_Value FROM T_Sys_DictionaryValue WHERE F_ValueId = @ID
            if (!string.IsNullOrEmpty(source))
            {
                sql += " and F_InfoSource = '" + source + "' ";
            }
            if (strusercode.Trim() != "" && strusercode != "undefined")
            {//坐席
                sql += " and F_CreateUser in (" + strusercode + ") ";
            }
            if (strtel.Trim() != "" && strtel != "undefined")
            {
                sql += " and (F_CusPhone like '%" + strtel + "%' or F_ConPhone like '%" + strtel + "%') ";
            }
            if (strkey.Trim() != "" && strkey != "undefined")
            {
                sql += " and (F_ComTitle like '%" + strkey + "%' or F_ComContent like '%" + strkey + "%') ";

            }
            if (strstarttime.Trim() != "" && strstarttime != "undefined")
            {
                sql += " and datediff(day,F_CreateTime,'" + strstarttime + "')<=0 ";
            }
            if (strendtime.Trim() != "" && strendtime != "undefined")
            {
                sql += " and datediff(day,F_CreateTime,'" + strendtime + "')>=0   ";
            }

            var orderlist = workorderBLL.DataTableToList(workorderBLL.GetListByPage(sql, "F_Id", Convert.ToInt32(pageNumber), Convert.ToInt32(pageSize)).Tables[0]);

            DataTable dt = new DataTable();

            DataColumn dc = null;

            //系统来源描述
            dc = dt.Columns.Add("strStm_Src_Dsc", Type.GetType("System.String"));
            //工单编号
            dc = dt.Columns.Add("strWrkOrdr_ID", Type.GetType("System.String"));
            //工单类型代码
            dc = dt.Columns.Add("strWrkOrdr_TpCd", Type.GetType("System.String"));
            //工单状态代码
            dc = dt.Columns.Add("strWrkOrdr_StCd", Type.GetType("System.String"));
            //工单状态描述
            dc = dt.Columns.Add("strWrkOrdr_StCd_DESC", Type.GetType("System.String"));
            //工单一级业务类型代码
            dc = dt.Columns.Add("strWrkOrdr_Lv1_Bsn_TpCd", Type.GetType("System.String"));
            //工单一级业务类型描述
            dc = dt.Columns.Add("strWrkOrdr_Lv1_Bsn_TpCd_DESC", Type.GetType("System.String"));
            //客户名称
            dc = dt.Columns.Add("strCst_Nm", Type.GetType("System.String"));
            //客户编号
            dc = dt.Columns.Add("strCst_ID", Type.GetType("System.String"));
            //工单标题
            dc = dt.Columns.Add("strWrkOrdr_Ttl", Type.GetType("System.String"));
            //工单详细情况描述
            dc = dt.Columns.Add("strWrkOrdr_Dtl_StnDsc", Type.GetType("System.String"));
            //屏蔽内容
            //   dc = dt.Columns.Add("strFst_SpInf", Type.GetType("System.String"));

            //管理中心回复(最新)
            // dc = dt.Columns.Add("strWrkOrdr_Splmt_Cntnt", Type.GetType("System.String"));
            //创建日期时间
            dc = dt.Columns.Add("strCrt_Dt_Tm", Type.GetType("System.String"));
            //回复局委编号
            dc = dt.Columns.Add("strRltv_InsID", Type.GetType("System.String"));
            //回复局委名称
            dc = dt.Columns.Add("strInpt_Inst_Nm", Type.GetType("System.String"));
            //回复时间
            dc = dt.Columns.Add("strCnvrstn_No", Type.GetType("System.String"));
            //局委回复内容
            //   dc = dt.Columns.Add("strWrkOrdr_Pcsg_StnCm", Type.GetType("System.String"));
            //工单收藏次数
            //    dc = dt.Columns.Add("strRslt_Rcrd_Num", Type.GetType("System.String"));

            List<T_Sys_Accessories> listSys = new List<T_Sys_Accessories>();

            for (int i = 0; i < orderlist.Count; i++)
            {
                DataRow newRow;
                newRow = dt.NewRow();

                if (DbHelperSQL.GetSingle("select top 1 F_Value from  T_Sys_DictionaryValue where F_ValueId='" + orderlist[i].F_InfoSource.ToString() + "'") != null)
                {
                    newRow["strStm_Src_Dsc"] = DbHelperSQL.GetSingle("select top 1 F_Value from  T_Sys_DictionaryValue where F_ValueId='" + orderlist[i].F_InfoSource.ToString() + "'").ToString();
                }

                newRow["strWrkOrdr_ID"] = orderlist[i].F_WorkOrderId.ToString();
                newRow["strWrkOrdr_TpCd"] = orderlist[i].F_InfoSource.ToString();
                newRow["strWrkOrdr_StCd"] = orderlist[i].F_WorkState.ToString();
                if (!string.IsNullOrEmpty(orderlist[i].F_WorkState.ToString()))
                {
                    newRow["strWrkOrdr_StCd_DESC"] = Utils.ToEnumDescriptionString(Convert.ToInt32(orderlist[i].F_WorkState), typeof(EnumWorkState));
                }
                newRow["strWrkOrdr_Lv1_Bsn_TpCd"] = orderlist[i].F_InfoType.ToString();
                if (!string.IsNullOrEmpty(orderlist[i].F_InfoSource.ToString()))
                {
                    if (DbHelperSQL.GetSingle("select top 1 F_Value from  T_Sys_DictionaryValue where F_ValueId='" + orderlist[i].F_InfoType.ToString() + "'") != null)
                    {
                        newRow["strWrkOrdr_Lv1_Bsn_TpCd_DESC"] = DbHelperSQL.GetSingle("select top 1 F_Value from  T_Sys_DictionaryValue where F_ValueId='" + orderlist[i].F_InfoType.ToString() + "'").ToString();
                    }

                }
                newRow["strCst_Nm"] = orderlist[i].F_CusName.ToString();
                newRow["strCst_ID"] = orderlist[i].F_Id.ToString();
                newRow["strWrkOrdr_Ttl"] = orderlist[i].F_ComTitle.ToString();
                if (!string.IsNullOrEmpty(orderlist[i].F_Content.ToString()))
                    newRow["strWrkOrdr_Dtl_StnDsc"] = orderlist[i].F_Content.ToString();
                else
                    newRow["strWrkOrdr_Dtl_StnDsc"] = orderlist[i].F_ComContent.ToString();
            
                // newRow["strFst_SpInf"] = "";
                //newRow["strWrkOrdr_Splmt_Cntnt"] = orderlist[i].F_Result.ToString();
                newRow["strCrt_Dt_Tm"] = orderlist[i].F_CreateTime.ToString();
                newRow["strRltv_InsID"] = orderlist[i].F_MainDeptId.ToString();
                if (!string.IsNullOrEmpty(orderlist[i].F_MainDeptId.ToString()))
                {
                    if (DbHelperSQL.GetSingle("select top 1 F_DeptName from  T_Sys_Department where F_DeptId='" + orderlist[i].F_MainDeptId.ToString() + "'") != null)
                    {
                        newRow["strInpt_Inst_Nm"] = DbHelperSQL.GetSingle("select top 1 F_DeptName from  T_Sys_Department where F_DeptId='" + orderlist[i].F_MainDeptId.ToString() + "'").ToString();
                    }

                }
                newRow["strCnvrstn_No"] = orderlist[i].F_EnableTime.ToString();
                //   newRow["strWrkOrdr_Pcsg_StnCm"] = orderlist[i].F_FinalOpinion.ToString();
                //     newRow["strRslt_Rcrd_Num"] = "";

                dt.Rows.Add(newRow);
            }

            #region 声音文件和交办超时
            #endregion

            var cosum = DbHelperSQL.GetSingle("  select count(*)  from T_Bus_WorkOrder  where " + sql).ToString();
            //  var cosum = workorderBLL.GetModelList(sql);

            pagination pa = new pagination();
            pa.tCurrTotalPage = Convert.ToInt32(pageNumber);
            pa.tCurrTotalPage = Convert.ToInt32(Convert.ToInt32(cosum) / Convert.ToInt32(pageSize));
            pa.total_rec = Convert.ToInt32(cosum);
            pa.tCurrTotalRec = 0;

            var obj = new
            {
                pagination = pa,
                returnList = dt
            };
            return Content(obj.ToJson());

        }
        public ActionResult zmhd10002_old()
        {

            //    bool hhfhfgg = SMSController.AddSmS(userId, "", "您反映的事项已受理并转交相关部门处理，感谢您拨打市长热线！", "18937188307", "146926", "");
            StreamReader reader = new StreamReader(System.Web.HttpContext.Current.Request.InputStream);
            string sql = "  F_IsDelete=0 ";
            sql += " and F_IsOpen=1 ";
            var postString = reader.ReadToEnd();
            JObject result = null;
            result = (JObject)Newtonsoft.Json.JsonConvert.DeserializeObject(postString);

            var txnCommCom = result["txnCommCom"].ToString();      //市民姓名 


            var txnBodyCom = result["txnBodyCom"].ToString();


            var txnBodyComresult = (JObject)Newtonsoft.Json.JsonConvert.DeserializeObject(txnBodyCom);

            var txnCommComresult = (JObject)Newtonsoft.Json.JsonConvert.DeserializeObject(txnCommCom);


            var source = txnBodyComresult["strStm_Src_Dsc"] == null ? "" : txnBodyComresult["strStm_Src_Dsc"].ToString();


            var pageSize = txnCommComresult["tPageJump"] == null ? "1" : txnCommComresult["tPageJump"].ToString();
            var pageNumber = txnCommComresult["tRecInPage"] == null ? "10" : txnCommComresult["tRecInPage"].ToString();


            var state = txnBodyComresult["strWrkOrdr_StCd"] == null ? "" : txnBodyComresult["strWrkOrdr_StCd"].ToString(); //工单状态代码 1-待处理 2-办理中  3-已回复 4-未回复

            if (source != "-1")
            {
                //1 市长热线 2 市长信箱 0 连线政府 3 人民网
                if (source == "0")
                {
                    source = "2458";
                }
                if (source == "3")
                {
                    source = "4";
                }
                sql += " and F_InfoSource = '" + source + "' ";
            }

            if (state != "0")
            {
                if (state == "1")
                {
                    sql += " and F_WorkState in (" + (int)EnumWorkState.neworder + "," + (int)EnumWorkState.submit + "," + (int)EnumWorkState.receive + (int)EnumWorkState.resubmit + ") ";
                }
                else if (state == "2")
                {
                    sql += " and F_WorkState in (" + (int)EnumWorkState.auditreback + "," + (int)EnumWorkState.dealing + "," + (int)EnumWorkState.auditdelay + (int)EnumWorkState.reload + (int)EnumWorkState.audit + (int)EnumWorkState.rejload + ") ";
                }
                else if (state == "3")
                {
                    sql += " and F_WorkState in (" + (int)EnumWorkState.visit + "," + (int)EnumWorkState.finish + ") ";
                }
                else if (state == "4")
                {
                    sql += " and F_WorkState in (" + (int)EnumWorkState.dealed + ") ";
                }

            }

            string strusercode = txnBodyComresult["strCst_ID"] == null ? "" : txnBodyComresult["strCst_ID"].ToString();//创建员工编号
            string strtel = txnBodyComresult["strRdial_Tel"] == null ? "" : txnBodyComresult["strRdial_Tel"].ToString();//市民电话
            string strkey = txnBodyComresult["strWrkOrdr_Ttl_Dtl"] == null ? "" : txnBodyComresult["strWrkOrdr_Ttl_Dtl"].ToString();//关键字检索

            string strstarttime = txnBodyComresult["strCrt_StDt"] == null ? "" : txnBodyComresult["strCrt_StDt"].ToString();//创建开始日期
            string strendtime = txnBodyComresult["strCrt_EdDt"] == null ? "" : txnBodyComresult["strCrt_EdDt"].ToString(); ;//创建结束日期
            string Key = txnBodyComresult["strWrkOrdr_Lv1_Bsn_TpCd"] == null ? "" : txnBodyComresult["strWrkOrdr_Lv1_Bsn_TpCd"].ToString();//事项一级分类代码
            string isproresult = txnBodyComresult["strRcrd_ID"] == null ? "" : txnBodyComresult["strRcrd_ID"].ToString();//营商标识
            string Title = txnBodyComresult["strWrkOrdr_Ttl"] == null ? "" : txnBodyComresult["strWrkOrdr_Ttl"].ToString();//工单标题

            if (Title.Trim() != "" && Title != "undefined")
            {
                sql += " and F_ComTitle in (" + Title + ") ";

            }

            string InfoType = txnBodyComresult["strWrkOrdr_Lv1_Bsn_TpCd"] == null ? "" : txnBodyComresult["strWrkOrdr_Lv1_Bsn_TpCd"].ToString();//工单一级业务类型代码

            if (InfoType.Trim() != "" && InfoType != "undefined")
            {
                sql += "and (F_Key IN(  SELECT  F_ValueId from [GetValueId]('" + InfoType + "'))" +
                    " or F_Key='" + InfoType + "' )";

            }




            if (Key.Trim() != "" && Key != "undefined")
            {
                sql += " and F_Key in (select F_ValueId from T_Sys_DictionaryValue where F_Value like'%" + Key.Trim() + "%'  ) ";

            }

            // SELECT @Name = F_Value FROM T_Sys_DictionaryValue WHERE F_ValueId = @ID
            if (!string.IsNullOrEmpty(source))
            {
                sql += " and F_InfoSource = '" + source + "' ";
            }
            if (strusercode.Trim() != "" && strusercode != "undefined")
            {//坐席
                sql += " and F_CreateUser in (" + strusercode + ") ";
            }
            if (strtel.Trim() != "" && strtel != "undefined")
            {
                sql += " and (F_CusPhone like '%" + strtel + "%' or F_ConPhone like '%" + strtel + "%') ";
            }
            if (strkey.Trim() != "" && strkey != "undefined")
            {
                sql += " and (F_ComTitle like '%" + strkey + "%' or F_ComContent like '%" + strkey + "%') ";

            }
            if (strstarttime.Trim() != "" && strstarttime != "undefined")
            {
                sql += " and datediff(day,F_CreateTime,'" + strstarttime + "')<=0 ";
            }
            if (strendtime.Trim() != "" && strendtime != "undefined")
            {
                sql += " and datediff(day,F_CreateTime,'" + strendtime + "')>=0   ";
            }

            int recordCount = 0;
            var orderlist = BLL.PagerBLL.GetListPager(
                "T_Bus_WorkOrder WITH(NOLOCK)",
                "F_WorkOrderId",
                "*",
               " and " + sql,
                "ORDER BY F_CreateTime DESC",
                     Convert.ToInt32(pageNumber),
               Convert.ToInt32(pageSize),

                true,
                out recordCount);

            DataTable dt = new DataTable();

            DataColumn dc = null;

            //系统来源描述
            dc = dt.Columns.Add("strStm_Src_Dsc", Type.GetType("System.String"));
            //工单编号
            dc = dt.Columns.Add("strWrkOrdr_ID", Type.GetType("System.String"));
            //工单类型代码
            dc = dt.Columns.Add("strWrkOrdr_TpCd", Type.GetType("System.String"));
            //工单状态代码
            dc = dt.Columns.Add("strWrkOrdr_StCd", Type.GetType("System.String"));
            //工单状态描述
            dc = dt.Columns.Add("strWrkOrdr_StCd_DESC", Type.GetType("System.String"));
            //工单一级业务类型代码
            dc = dt.Columns.Add("strWrkOrdr_Lv1_Bsn_TpCd", Type.GetType("System.String"));
            //工单一级业务类型描述
            dc = dt.Columns.Add("strWrkOrdr_Lv1_Bsn_TpCd_DESC", Type.GetType("System.String"));
            //客户名称
            dc = dt.Columns.Add("strCst_Nm", Type.GetType("System.String"));
            //客户编号
            dc = dt.Columns.Add("strCst_ID", Type.GetType("System.String"));
            //工单标题
            dc = dt.Columns.Add("strWrkOrdr_Ttl", Type.GetType("System.String"));
            //工单详细情况描述
            dc = dt.Columns.Add("strWrkOrdr_Dtl_StnDsc", Type.GetType("System.String"));
            //屏蔽内容
            //   dc = dt.Columns.Add("strFst_SpInf", Type.GetType("System.String"));

            //管理中心回复(最新)
            // dc = dt.Columns.Add("strWrkOrdr_Splmt_Cntnt", Type.GetType("System.String"));
            //创建日期时间
            dc = dt.Columns.Add("strCrt_Dt_Tm", Type.GetType("System.String"));
            //回复局委编号
            dc = dt.Columns.Add("strRltv_InsID", Type.GetType("System.String"));
            //回复局委名称
            dc = dt.Columns.Add("strInpt_Inst_Nm", Type.GetType("System.String"));
            //回复时间
            dc = dt.Columns.Add("strCnvrstn_No", Type.GetType("System.String"));
            //局委回复内容
            //   dc = dt.Columns.Add("strWrkOrdr_Pcsg_StnCm", Type.GetType("System.String"));
            //工单收藏次数
            //    dc = dt.Columns.Add("strRslt_Rcrd_Num", Type.GetType("System.String"));

            List<T_Sys_Accessories> listSys = new List<T_Sys_Accessories>();

            for (int i = 0; i < orderlist.Rows.Count; i++)
            {
                DataRow newRow;
                newRow = dt.NewRow();

                if (DbHelperSQL.GetSingle("select top 1 F_Value from  T_Sys_DictionaryValue where F_ValueId='" + orderlist.Rows[i]["F_InfoSource"].ToString() + "'") != null)
                {
                    newRow["strStm_Src_Dsc"] = DbHelperSQL.GetSingle("select top 1 F_Value from  T_Sys_DictionaryValue where F_ValueId='" + orderlist.Rows[i]["F_InfoSource"].ToString() + "'").ToString();
                }

                newRow["strWrkOrdr_ID"] = orderlist.Rows[i]["F_WorkOrderId"].ToString();
                newRow["strWrkOrdr_TpCd"] = orderlist.Rows[i]["F_InfoSource"].ToString();
                newRow["strWrkOrdr_StCd"] = orderlist.Rows[i]["F_WorkState"].ToString();
                if (!string.IsNullOrEmpty(orderlist.Rows[i]["F_WorkState"].ToString()))
                {
                    newRow["strWrkOrdr_StCd_DESC"] = Utils.ToEnumDescriptionString(Convert.ToInt32(orderlist.Rows[i]["F_WorkState"]), typeof(EnumWorkState));
                }
                newRow["strWrkOrdr_Lv1_Bsn_TpCd"] = orderlist.Rows[i]["F_InfoType"].ToString();
                if (!string.IsNullOrEmpty(orderlist.Rows[i]["F_InfoSource"].ToString()))
                {
                    if (DbHelperSQL.GetSingle("select top 1 F_Value from  T_Sys_DictionaryValue where F_ValueId='" + orderlist.Rows[i]["F_InfoType"].ToString() + "'") != null)
                    {
                        newRow["strWrkOrdr_Lv1_Bsn_TpCd_DESC"] = DbHelperSQL.GetSingle("select top 1 F_Value from  T_Sys_DictionaryValue where F_ValueId='" + orderlist.Rows[i]["F_InfoType"].ToString() + "'").ToString();
                    }

                }
                newRow["strCst_Nm"] = orderlist.Rows[i]["F_CusName"].ToString();
                newRow["strCst_ID"] = orderlist.Rows[i]["F_Id"].ToString();
                newRow["strWrkOrdr_Ttl"] = orderlist.Rows[i]["F_ComTitle"].ToString();
                if (!string.IsNullOrEmpty(orderlist.Rows[i]["F_Content"].ToString()))
                    newRow["strWrkOrdr_Dtl_StnDsc"] = orderlist.Rows[i]["F_Content"].ToString();
                else
                    newRow["strWrkOrdr_Dtl_StnDsc"] = orderlist.Rows[i]["F_ComContent"].ToString();
                
                // newRow["strFst_SpInf"] = "";
                //newRow["strWrkOrdr_Splmt_Cntnt"] = orderlist[i].F_Result.ToString();
                newRow["strCrt_Dt_Tm"] = orderlist.Rows[i]["F_CreateTime"].ToString();
                newRow["strRltv_InsID"] = orderlist.Rows[i]["F_MainDeptId"].ToString();
                if (!string.IsNullOrEmpty(orderlist.Rows[i]["F_MainDeptId"].ToString()))
                {
                    if (DbHelperSQL.GetSingle("select top 1 F_DeptName from  T_Sys_Department where F_DeptId='" + orderlist.Rows[i]["F_MainDeptId"].ToString() + "'") != null)
                    {
                        newRow["strInpt_Inst_Nm"] = DbHelperSQL.GetSingle("select top 1 F_DeptName from  T_Sys_Department where F_DeptId='" + orderlist.Rows[i]["F_MainDeptId"].ToString() + "'").ToString();
                    }

                }
                newRow["strCnvrstn_No"] = orderlist.Rows[i]["F_EnableTime"].ToString();
                //   newRow["strWrkOrdr_Pcsg_StnCm"] = orderlist[i].F_FinalOpinion.ToString();
                //     newRow["strRslt_Rcrd_Num"] = "";

                dt.Rows.Add(newRow);
            }

            #region 声音文件和交办超时
            #endregion

            var cosum = DbHelperSQL.GetSingle("  select count(*)  from T_Bus_WorkOrder  where " + sql).ToString();
            //  var cosum = dt.Rows.Count;
            pagination pa = new pagination();
            pa.tCurrTotalPage = Convert.ToInt32(pageSize);
            pa.totalPage = Convert.ToInt32(Convert.ToInt32(cosum) / Convert.ToInt32(pageNumber));

            pa.total_rec = Convert.ToInt32(cosum);
            pa.tCurrTotalRec = Convert.ToInt32(pageNumber);

            var obj = new
            {
                state = "success",
                message = "成功",
                pagination = pa,
                returnList = dt
            };
            return Content(obj.ToJson());

        }
        public class pagination
        {

            public int tCurrTotalPage;
            public int totalPage;
            public int total_rec;
            public int tCurrTotalRec;
        }
        public ActionResult zmhd10001()
        {
            StreamReader reader = new StreamReader(System.Web.HttpContext.Current.Request.InputStream);
            string sql = "  F_IsDelete=0 ";
            // sql += " and F_IsOpen=1 ";
            var postString = reader.ReadToEnd();
            JObject result = null;
            result = (JObject)Newtonsoft.Json.JsonConvert.DeserializeObject(postString);
            var txnBodyCom = result["txnBodyCom"].ToString();      //市民姓名 

            var txnBodyComresult = (JObject)Newtonsoft.Json.JsonConvert.DeserializeObject(txnBodyCom);


            var source = txnBodyComresult["strStm_Src_Dsc"] == null ? "" : txnBodyComresult["strStm_Src_Dsc"].ToString();

            var pageNumber = txnBodyComresult["pageNumber"] == null ? "1" : txnBodyComresult["pageNumber"].ToString();
            var pageSize = txnBodyComresult["pageSize"] == null ? "10" : txnBodyComresult["pageSize"].ToString();
            string strworkorderid = txnBodyComresult["strWrkOrdr_ID"] == null ? "" : txnBodyComresult["strWrkOrdr_ID"].ToString(); // 工单编号

            string strusercode = txnBodyComresult["strCst_ID"] == null ? "" : txnBodyComresult["strCst_ID"].ToString();//创建员工编号
            if (strworkorderid.Trim() != "" && strworkorderid != "undefined")
            {
                sql += " and F_WorkOrderId = '" + strworkorderid + "' ";
            }
              
            //if (strusercode.Trim() != "" && strusercode != "undefined")
            //{//市民ID
            //    sql += " and F_CreateUser in ('" + strusercode + "') ";
            //}

            if (source.Trim() != "" && source != "undefined")
            {
                //1 市长热线 2 市长信箱 0 连线政府 3 人民网
                if (source == "0")
                {
                    source = "2458";
                }
                if (source == "3")
                {
                    source = "4";
                }
                sql += " and F_InfoSource = '" + source + "' ";
            }
            var orderlist = workorderBLL.DataTableToList(workorderBLL.GetListByPage(sql, " F_DealTime DESC", Convert.ToInt32(pageNumber), Convert.ToInt32(pageSize)).Tables[0]);
            DataTable dt = new DataTable();

            DataColumn dc = null;

            //系统来源描述
            dc = dt.Columns.Add("strStm_Src_Dsc", Type.GetType("System.String"));
            //工单编号
            dc = dt.Columns.Add("strWrkOrdr_ID", Type.GetType("System.String"));
            //工单类型代码
            dc = dt.Columns.Add("strWrkOrdr_TpCd", Type.GetType("System.String"));
            //工单状态代码
            dc = dt.Columns.Add("strWrkOrdr_StCd", Type.GetType("System.String"));
            //工单状态描述
            dc = dt.Columns.Add("strWrkOrdr_StCd_DESC", Type.GetType("System.String"));
            //工单一级业务类型代码
            dc = dt.Columns.Add("strWrkOrdr_Lv1_Bsn_TpCd", Type.GetType("System.String"));
            //工单一级业务类型描述
            dc = dt.Columns.Add("strWrkOrdr_Lv1_Bsn_TpCd_DESC", Type.GetType("System.String"));
            //客户名称
            dc = dt.Columns.Add("strCst_Nm", Type.GetType("System.String"));
            //客户编号
            dc = dt.Columns.Add("strCst_ID", Type.GetType("System.String"));
            //工单标题
            dc = dt.Columns.Add("strWrkOrdr_Ttl", Type.GetType("System.String"));
            //工单详细情况描述
            dc = dt.Columns.Add("strWrkOrdr_Dtl_StnDsc", Type.GetType("System.String"));
            //屏蔽内容
            dc = dt.Columns.Add("strFst_SpInf", Type.GetType("System.String"));

            //管理中心回复(最新)
            dc = dt.Columns.Add("strWrkOrdr_Splmt_Cntnt", Type.GetType("System.String"));
            //创建日期时间
            dc = dt.Columns.Add("strCrt_Dt_Tm", Type.GetType("System.String"));
            //回复局委编号
            dc = dt.Columns.Add("strRltv_InsID", Type.GetType("System.String"));
            //回复局委名称
            dc = dt.Columns.Add("strInpt_Inst_Nm", Type.GetType("System.String"));
            //回复时间
            dc = dt.Columns.Add("strCnvrstn_No", Type.GetType("System.String"));
            //局委回复内容
            dc = dt.Columns.Add("strWrkOrdr_Pcsg_StnCm", Type.GetType("System.String"));
            //工单收藏次数
            dc = dt.Columns.Add("strRslt_Rcrd_Num", Type.GetType("System.String"));
            dc = dt.Columns.Add("strWrkOrdr_Lvl2_Bsn_TpCd", Type.GetType("System.String"));
            //工单二级业务类型代码
            dc = dt.Columns.Add("strWrkOrdr_Lvl2_Bsn_TpCd_DESC", Type.GetType("System.String"));
            dc = dt.Columns.Add("strHpCnt", Type.GetType("System.String"));
            //评议结果
            dc = dt.Columns.Add("strWrkOrdr_Cst_Ssf_Cd", Type.GetType("System.String"));
            
            //评议内容
            dc = dt.Columns.Add("strSsf_Cst_Ass_CntDsc", Type.GetType("System.String"));
            //评议时间
            dc = dt.Columns.Add("strWrkOrdr_Cst_Ssf_Dt", Type.GetType("System.String"));
            //atchmList
            dc = dt.Columns.Add("atchmList", Type.GetType("System.String[]"));
            //replyFileList
            dc = dt.Columns.Add("replyFileList", Type.GetType("System.String[]"));
            var person = new
            {
                Name = "张三",
                Age = 22,
                Sex = "男",
                Date = DateTime.Now
            };

            List<T_Sys_Accessories> listSys = new List<T_Sys_Accessories>();

            for (int i = 0; i < orderlist.Count; i++)
            {
                DataRow newRow;
                newRow = dt.NewRow();

                if (DbHelperSQL.GetSingle("select top 1 F_Value from  T_Sys_DictionaryValue where F_ValueId='" + orderlist[i].F_InfoSource.ToString() + "'") != null)
                {
                    newRow["strStm_Src_Dsc"] = DbHelperSQL.GetSingle("select top 1 F_Value from  T_Sys_DictionaryValue where F_ValueId='" + orderlist[i].F_InfoSource.ToString() + "'").ToString();
                }
                ;
                if (DbHelperSQL.GetSingle("select top 1  WorkOrderId from  PublicComment where WorkOrderId='" + orderlist[i].F_WorkOrderId.ToString() + "'") != null)
                {
                    if (DbHelperSQL.GetSingle("select top 1  WorkOrderId from  PublicComment where WorkOrderId='" + orderlist[i].F_WorkOrderId.ToString() + "'").ToString() == orderlist[i].F_WorkOrderId.ToString())
                        newRow["strHpCnt"] = 3;
                }
                else
                {
                    newRow["strHpCnt"] = 2;
                }

                newRow["strWrkOrdr_ID"] = orderlist[i].F_WorkOrderId.ToString();
                newRow["strWrkOrdr_TpCd"] = orderlist[i].F_InfoSource.ToString();
                if (orderlist[i].F_WorkState.ToString() == "0"
                  || orderlist[i].F_WorkState.ToString() == "1" || orderlist[i].F_WorkState.ToString() == "2" || orderlist[i].F_WorkState.ToString() == "11")
                    newRow["strWrkOrdr_StCd"] = "1";
                else if (orderlist[i].F_WorkState.ToString() == "6"
                  || orderlist[i].F_WorkState.ToString() == "7" || orderlist[i].F_WorkState.ToString() == "9")
                    newRow["strWrkOrdr_StCd"] = "3";
                else
                    newRow["strWrkOrdr_StCd"] = "2";

                if (!string.IsNullOrEmpty(orderlist[i].F_WorkState.ToString()))
                {
                    newRow["strWrkOrdr_StCd_DESC"] = Utils.ToEnumDescriptionString(Convert.ToInt32(orderlist[i].F_WorkState), typeof(EnumWorkState));
                }

                if (!string.IsNullOrEmpty(orderlist[i].F_Key.ToString()))
                {
                    try
                    {
                        var dicvalue = new BLL.T_Sys_DictionaryValue
                                               ().GetModel(int.Parse(orderlist[i].F_Key.ToString()));
                        if (dicvalue != null)
                        {
                            if (dicvalue.F_Layer == 4)
                            {
                                var dic = new BLL.T_Sys_DictionaryValue().GetModelList
                                    ("F_ValueId =(SELECT F_PrentId  FROM T_Sys_DictionaryValue WHERE F_ValueId = (SELECT F_PrentId  FROM T_Sys_DictionaryValue WHERE F_ValueId = (SELECT F_PrentId  FROM T_Sys_DictionaryValue WHERE  F_ValueId = '" + orderlist[i].F_Key.ToString() + "')) ) ");
                                if (dic != null && dic.Count > 0)
                                {
                                    newRow["strWrkOrdr_Lv1_Bsn_TpCd"] = dic[0].F_ValueId.ToString();
                                    newRow["strWrkOrdr_Lv1_Bsn_TpCd_DESC"] = dic[0].F_Value;
                                }
                                var dic1 = new BLL.T_Sys_DictionaryValue().GetModelList
                                 ("F_ValueId =(SELECT F_PrentId  FROM T_Sys_DictionaryValue WHERE F_ValueId = (SELECT F_PrentId  FROM T_Sys_DictionaryValue WHERE   F_ValueId = '" + orderlist[i].F_Key.ToString() + "')) ");
                                if (dic != null && dic.Count > 0)
                                {
                                    newRow["strWrkOrdr_Lvl2_Bsn_TpCd"] = dic1[0].F_ValueId.ToString();
                                    newRow["strWrkOrdr_Lvl2_Bsn_TpCd_DESC"] = dic1[0].F_Value;
                                }

                            }
                            else if (dicvalue.F_Layer == 3)
                            {
                                var dic = new BLL.T_Sys_DictionaryValue().GetModelList
                                      ("F_ValueId =(SELECT F_PrentId  FROM T_Sys_DictionaryValue WHERE F_ValueId = (SELECT F_PrentId  FROM T_Sys_DictionaryValue WHERE   F_ValueId = '" + orderlist[i].F_Key.ToString() + "')) ");
                                if (dic != null && dic.Count > 0)
                                {
                                    newRow["strWrkOrdr_Lv1_Bsn_TpCd"] = dic[0].F_ValueId.ToString();
                                    newRow["strWrkOrdr_Lv1_Bsn_TpCd_DESC"] = dic[0].F_Value;
                                }
                                var dic1 = new BLL.T_Sys_DictionaryValue().GetModelList
                                      ("F_ValueId =(SELECT F_PrentId  FROM T_Sys_DictionaryValue WHERE F_ValueId  = '" + orderlist[i].F_Key.ToString().ToString() + "') ");
                                if (dic != null && dic.Count > 0)
                                {
                                    newRow["strWrkOrdr_Lvl2_Bsn_TpCd"] = dic1[0].F_ValueId.ToString();
                                    newRow["strWrkOrdr_Lvl2_Bsn_TpCd_DESC"] = dic1[0].F_Value;
                                }

                            }
                            else if (dicvalue.F_Layer == 2)
                            {
                                var dic = new BLL.T_Sys_DictionaryValue().GetModelList
                                      ("F_ValueId =(SELECT F_PrentId  FROM T_Sys_DictionaryValue WHERE F_ValueId  = '" + orderlist[i].F_Key.ToString().ToString() + "') ");
                                if (dic != null && dic.Count > 0)
                                {
                                    newRow["strWrkOrdr_Lv1_Bsn_TpCd"] = dic[0].F_ValueId.ToString();
                                    newRow["strWrkOrdr_Lv1_Bsn_TpCd_DESC"] = dic[0].F_Value;
                                }
                                newRow["strWrkOrdr_Lvl2_Bsn_TpCd"] = dicvalue.F_ValueId.ToString();
                                newRow["strWrkOrdr_Lvl2_Bsn_TpCd_DESC"] = dicvalue.F_Value;

                            }
                            else
                            {
                                newRow["strWrkOrdr_Lv1_Bsn_TpCd"] = dicvalue.F_ValueId.ToString();
                                newRow["strWrkOrdr_Lv1_Bsn_TpCd_DESC"] = dicvalue.F_Value;
                                newRow["strWrkOrdr_Lvl2_Bsn_TpCd"] = dicvalue.F_ValueId.ToString();
                                newRow["strWrkOrdr_Lvl2_Bsn_TpCd_DESC"] = dicvalue.F_Value;
                            }
                        }

                    }
                    catch
                    {
                    }

                }
                newRow["strCst_Nm"] = orderlist[i].F_CusName.ToString();
                newRow["strCst_ID"] = orderlist[i].F_Id.ToString();
                newRow["strWrkOrdr_Ttl"] = orderlist[i].F_ComTitle.ToString();

                if (!string.IsNullOrEmpty(orderlist[i].F_Content.ToString()))
                    newRow["strWrkOrdr_Dtl_StnDsc"] = orderlist[i].F_Content.ToString();
                else
                    newRow["strWrkOrdr_Dtl_StnDsc"] = orderlist[i].F_ComContent.ToString();
                
                newRow["strFst_SpInf"] = "";
                newRow["strWrkOrdr_Splmt_Cntnt"] = orderlist[i].F_Result.ToString();
                newRow["strCrt_Dt_Tm"] = orderlist[i].F_CreateTime.ToString();
                newRow["strRltv_InsID"] = orderlist[i].F_MainDeptId.ToString();
                if (!string.IsNullOrEmpty(orderlist[i].F_MainDeptId.ToString()))
                {
                    if (DbHelperSQL.GetSingle("select top 1 F_DeptName from  T_Sys_Department where F_DeptId='" + orderlist[i].F_MainDeptId.ToString() + "'") != null)
                    {
                        newRow["strInpt_Inst_Nm"] = DbHelperSQL.GetSingle("select top 1 F_DeptName from  T_Sys_Department where F_DeptId='" + orderlist[i].F_MainDeptId.ToString() + "'").ToString();
                    }

                }
                else
                    newRow["strInpt_Inst_Nm"] = "管理中心";
                if (!string.IsNullOrEmpty(orderlist[i].F_DealTime.ToString()))
                    newRow["strCnvrstn_No"] = orderlist[i].F_DealTime.ToString();
                else if (!string.IsNullOrEmpty(orderlist[i].F_CloseTime.ToString()))
                    newRow["strCnvrstn_No"] = orderlist[i].F_CloseTime.ToString();
                else
                    newRow["strCnvrstn_No"] = orderlist[i].F_CreateTime.ToString();
                if (DbHelperSQL.GetSingle("select top 1 strWrkOrder_Cst_Ssf_Cd  from  PublicComment where WorkOrderId='" + orderlist[i].F_WorkOrderId .ToString() + "' order by CreateTime desc") != null)
                {
                    newRow["strWrkOrdr_Cst_Ssf_Cd"] = DbHelperSQL.GetSingle("select top 1 strWrkOrder_Cst_Ssf_Cd  from  PublicComment where WorkOrderId='" + orderlist[i].F_WorkOrderId.ToString() + "' order by CreateTime desc").ToString();
                    newRow["strSsf_Cst_Ass_CntDsc"] = DbHelperSQL.GetSingle("select top 1 strSsf_Cst_Ass_CntDsc  from  PublicComment where WorkOrderId='" + orderlist[i].F_WorkOrderId.ToString() + "' order by CreateTime desc").ToString();
                    newRow["strWrkOrdr_Cst_Ssf_Dt"] = DbHelperSQL.GetSingle("select top 1 CreateTime  from  PublicComment where WorkOrderId='" + orderlist[i].F_WorkOrderId.ToString() + "' order by CreateTime desc").ToString();
                }
                newRow["strWrkOrdr_Pcsg_StnCm"] = orderlist[i].F_Result.ToString();

                
                if (Convert.ToInt32 (DbHelperSQL.GetSingle("select count(1)   from  T_Sys_Collection where F_WorkOrderId='" + orderlist[i].F_WorkOrderId.ToString() + "'and strCrt_EmpID='"+strusercode + "'and strMnplt_TpCd='00'")
                    .ToString ())>0)
                newRow["strRslt_Rcrd_Num"] = "1";
                else
                    newRow["strRslt_Rcrd_Num"] = "0";
                newRow["atchmList"] = new string[0]; newRow["replyFileList"] = new string[0];

                string blsql = "select F_File  from T_Bus_Feedback WITH(NOLOCK) where F_State=1 and F_Type!=3 and F_IsDelete=0 and  F_WorkOrderId ='" + strworkorderid + "' order by F_CreateTime";
                var bldt = DbHelperSQL.Query(blsql).Tables[0];
                List<atchmList> ress = new List<atchmList>();
                foreach (DataRow dr in bldt.Rows)
                {
                    var dtfj = new DataTable();
                    if (dr["F_File"] != null && dr["F_File"].ToString() != "")
                    {
                        string[] arrFileType = dr["F_File"].ToString().Split(',');
                        foreach (string str in arrFileType)
                        {
                            dtfj = DbHelperSQL.Query(" select *   from T_Sys_Accessories WITH(NOLOCK) where 1=1 and f_fileid='" + str + "'").Tables[0];
                            var atchmList = new atchmList();
                            if (DbHelperSQL.GetSingle("select f_username from T_Sys_UserAccount where F_UserCode = '" + orderlist[i].F_CreateUser + "'") != null)
                            {
                                atchmList.strUdt_Psn_Nm = DbHelperSQL.GetSingle("select f_username from T_Sys_UserAccount where F_UserCode = '" + orderlist[i].F_CreateUser + "'").ToString();
                            }
                            atchmList.strUdt_Psn_ID = orderlist[i].F_CreateUser;
                            atchmList.strWrkOrdStrm_Tfr_SN = orderlist[i].F_Id.ToString();
                            atchmList.strWrkOrdr_Atch_SbmTm = dtfj.Rows[0]["F_AddTime"].ToString();
                            atchmList.strAtch_Chn_Nm = dtfj.Rows[0]["F_FileName"].ToString();
                            atchmList.strCur_Atch_Rte_Dsc = dtfj.Rows[0]["F_FileUrl"].ToString();
                            atchmList.strWrkOrdr_Atch_ID = dtfj.Rows[0]["F_FileId"].ToString();

                            ress.Add(atchmList);
                        }
                    }
                }
                   dt.Columns.Remove("replyFileList");
                   dc = dt.Columns.Add("replyFileList", Type.GetType("System.String"));
                newRow["replyFileList"] = ress.ToJson();
                List<atchmList> res = new List<atchmList>();
                if (!string.IsNullOrEmpty(orderlist[i].F_File))
                {
                    var dtfj = new DataTable();
                    //if (!orderlist[i].F_File.Contains(','))
                    //{
                    //    WebClient web = new WebClient();
                    //    web.Encoding = Encoding.UTF8;
                    //    string seturl = "http://125.45.12.146:9998/WorkOrder/Uploads?ids=" + orderlist[i].F_File;
                    //    string Dataurl = web.DownloadString(seturl);//这一句话就能请求到数据了
                    //    dtfj = DbHelperSQL.Query(" select *   from T_Sys_Accessories WITH(NOLOCK) where 1=1 and f_fileid='" + orderlist[i].F_File + "'").Tables[0];
                    //    List<atchmList> res = new List<atchmList>();
                    //    var atchmList = new atchmList();
                    //    atchmList.strUdt_Psn_Nm = DbHelperSQL.GetSingle("select f_username from T_Sys_UserAccount where F_UserCode = '" + orderlist[i].F_CreateUser + "'");
                    //    atchmList.strUdt_Psn_ID = orderlist[i].F_CreateUser;
                    //       atchmList.strWrkOrdStrm_Tfr_SN = orderlist[i].F_Id.ToString(),
                    //       atchmList.strWrkOrdr_Atch_SbmTm = dtfj.Rows[0]["F_AddTime"],
                    //       atchmList.strAtch_Chn_Nm = dtfj.Rows[0]["F_FileName"],
                    //      atchmList.strCur_Atch_Rte_Dsc = dtfj.Rows[0]["F_FileUrl"],
                    //       atchmList.strWrkOrdr_Atch_ID = dtfj.Rows[0]["F_FileId"]
                       
                        
                    //    dt.Columns.Remove("atchmList");
                    //    dc = dt.Columns.Add("atchmList", Type.GetType("System.String"));
                    //    newRow["atchmList"] = "";



                    //    //   string json = JsonConvert.SerializeObject(atchmList.ToJson());
                    //    // var  new HttpResponseMessage { Content = new StringContent(json, Encoding.GetEncoding("UTF-8"), "application/json") };


                    //    newRow["atchmList"] = atchmList.ToJson();
                    //}
                  //  else
                   // {
                        string[] arrFileType = orderlist[i].F_File.Split(',');
                        WebClient web = new WebClient();
                        web.Encoding = Encoding.UTF8;
                        string seturl = "http://125.45.12.146:9998/WorkOrder/Uploads?ids=" + orderlist[i].F_File;
                        string Dataurl = web.DownloadString(seturl);//这一句话就能请求到数据了
                        
                        foreach (string str in arrFileType)
                        {
                            dtfj = DbHelperSQL.Query(" select *   from T_Sys_Accessories WITH(NOLOCK) where 1=1 and f_fileid='" + str + "'").Tables[0];
                            var atchmList = new atchmList();
                            if (DbHelperSQL.GetSingle("select f_username from T_Sys_UserAccount where F_UserCode = '" + orderlist[i].F_CreateUser + "'") != null)
                            {
                                atchmList.strUdt_Psn_Nm = DbHelperSQL.GetSingle("select f_username from T_Sys_UserAccount where F_UserCode = '" + orderlist[i].F_CreateUser + "'").ToString();
                            }
                            atchmList.strUdt_Psn_ID = orderlist[i].F_CreateUser;
                            atchmList.strWrkOrdStrm_Tfr_SN = orderlist[i].F_Id.ToString();
                            atchmList.strWrkOrdr_Atch_SbmTm = dtfj.Rows[0]["F_AddTime"].ToString();
                            atchmList.strAtch_Chn_Nm = dtfj.Rows[0]["F_FileName"].ToString();
                            atchmList.strCur_Atch_Rte_Dsc = dtfj.Rows[0]["F_FileUrl"].ToString();
                            atchmList.strWrkOrdr_Atch_ID = dtfj.Rows[0]["F_FileId"].ToString();
                           
                            res.Add(atchmList);
                        }
                       
                       
                   // }
                }
                dt.Columns.Remove("atchmList");
                dc = dt.Columns.Add("atchmList", Type.GetType("System.String"));
                newRow["atchmList"] = res.ToJson();
                dt.Rows.Add(newRow);
            }

            #region 声音文件和交办超时
            #endregion
            var obj = new
            {
                state = "success",
                message = "00",
                returnList = dt,
            };
            // obj.ToJson().Replace("returnList", "C-Response-Body").Replace("state", "C-Response-Desc").Replace("message", "C-API-Status");
            return Content(obj.ToJson().Replace("returnList", "C-Response-Body").Replace("state", "C-Response-Desc").Replace("message", "C-API-Status"));

        }
        public ActionResult zmhd10011()
        {
            StreamReader reader = new StreamReader(System.Web.HttpContext.Current.Request.InputStream);
            var postString = reader.ReadToEnd();
            JObject result = null;
            result = (JObject)Newtonsoft.Json.JsonConvert.DeserializeObject(postString);
            var txnBodyCom = result["txnBodyCom"].ToString();      //市民姓名 
            var txnBodyComresult = (JObject)Newtonsoft.Json.JsonConvert.DeserializeObject(txnBodyCom);
            var mobile = txnBodyComresult["mobile"] == null ? "" : txnBodyComresult["mobile"].ToString();
            //string count = "您反映的事项已受理并转交相关部门处理，感谢您拨打市长热线！";

            int codes = new Random().Next(1000, 9999);
            string msg = codes.ToString();
            string count = "您的验证码是" + "#123456#" + "，10分钟内有效。";
            bool n = SMSController.AddSmS(0, msg, "您的验证码是" + codes + "，10分钟内有效。", mobile, "168411", "");

            //     string count1 = "您反映的事项已受理并转交相关部门处理，感谢您拨打市长热线！";

            //    bool n1 = SMSController.AddSmS(133, "", count1, "18937188307", "146926", "");

            if (n)
            {
                var obj = new
                {
                    state = "success",
                    message = "00",
                    code = "000000",

                    //   returnList = dt,
                };

                return Content(obj.ToJson());
            }
            else
            {
                var obj = new
                {
                    state = "false",
                    message = "00",
                    code = "000000",

                    //   returnList = dt,
                };

                return Content(obj.ToJson());
            }
        }
        public ActionResult zmhd10010()
        {
            // string jsonData = "{\"dayNums\":" + re.dayNums + ",\"monthNums\":" + re.monthNums + ",\"yestNums\":\"" + re.yestNums + "\",\"histNums\":\"" + re.histNums + "\"}";

            string jsonData = "{\"serialVersionUID\":1,\"startIndex\":0,\"currPage\":1,\"data\":[{\"strDept_Cgy_Dsc\":\"<p>主持市政府全面工作。</p><p>领导简介</p><p>&nbsp; &nbsp; &nbsp; &nbsp; 袁家健，男，1971年3月生，汉族，安徽肥东人，研究生学历，法学硕士，1994年7月参加工作，1994年6月加入中国共产党。 现任河南省安阳市委副书记，市人民政府市长、党组书记</p><p>&nbsp; &nbsp; &nbsp; &nbsp; 1990.09--1994.07 南开大学哲学系逻辑学专业学习</p><p>&nbsp; &nbsp; &nbsp; &nbsp; 1994.07--1999.10 天津市河西区政府办公室资料科员、副科长、科长</p><p>&nbsp; &nbsp; &nbsp; &nbsp; 1999.10--2000.05 天津市河西区政府研究室副主任</p><p>&nbsp; &nbsp; &nbsp; &nbsp; 2000.05--2001.12 天津市河西区天塔街道办事处副主任 (1998.09--2001.12在天津市委党校马克思主义哲学专业研究生班学习)</p><p>&nbsp; &nbsp; &nbsp; &nbsp; 2001.12--2003.08 天津市河西区政府办公室副主任(2002.09--2003.07在天津师范大学科学社会主义与国际共产主义运动专业学习,获法学硕士学位)</p><p>&nbsp; &nbsp; &nbsp; &nbsp; 2003.08--2004.06 共青团天津市河西区委书记、党组书记</p><p>&nbsp; &nbsp; &nbsp; &nbsp; 2004.06--2009.07 天津市河西区委组织部副部长、区委党史研究室主任 (2004.02--2004.07在天津市委党校第26期培训班学习)</p><p>&nbsp; &nbsp; &nbsp; &nbsp; 2009.07--2010.04 天津市河西区委组织部副部长、区人事局局长</p><p>&nbsp; &nbsp; &nbsp; &nbsp; 2010.04--2010.11 天津市河西区委组织部副部长、区人力资源和社会保障局局长、党组书记，区公务员局局长</p><p>&nbsp; &nbsp; &nbsp; &nbsp; 2010.11--2016.12 天津市人力资源和社会保障局副局长(2011.09--2011.11在天津市委党校第83期进修班学习)</p><p>&nbsp; &nbsp; &nbsp; &nbsp; 2016.12--2017.11 天津市红桥区委副书记</p><p>&nbsp; &nbsp; &nbsp; &nbsp; 2017.11--2017.12 天津市红桥区委副书记、副区长、代区长</p><p>&nbsp; &nbsp; &nbsp; &nbsp; 2017.12—2019.12 天津市红桥区委副书记、区长</p><p>&nbsp; &nbsp; &nbsp; &nbsp; 2019.12—2020.05 河南省安阳市委副书记，市政府党组书记、副市长、代市长</p><p>&nbsp; &nbsp; &nbsp; &nbsp; 2020.05—&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;河南省安阳市委副书记，市人民政府市长、党组书记</p>\",\"strCrt_Empe_Nm\":\"袁家健\",\"strCrt_Pst_Nm\":\"市长\",\"strCur_Atch_Rte_Dsc\":\"Upload/szPhoto/szzp.jpg\",\"strCur_PK_ID\":\"2ef7eb3d3952418b8c25693d0fc49559\",\"strSeq_ID\":\"1\"}],\"currRec\":10,\"totalPage\":1,\"pageSize\":1,\"total_rec\":1,\"totalCount\":1,\"PAGESIZE\":1}";


            var obj = new
            {
                state = "success",
                message = "00",
                returnList = jsonData,
            };


            return Content(obj.ToJson().Replace("state", "C-Response-Desc").Replace("message", "C-API-Status").Replace("returnList", "C-Response-Body"));

        }
        public ActionResult zmhd10008()
        {

            string fileName = Request.Form["fileName"];
            string path = ""; string jsonData = "";
            HttpFileCollection files = RequestString.GetFiles();
            if (files.Count > 0)
            {
                path = "/Upload/Files/" + DateTime.Now.ToString("yyyy") + "/" + DateTime.Now.ToString("MM") + "/" + DateTime.Now.ToString("dd") + "/";
                for (int i = 0; i < files.Count; i++)
                {
                    HttpPostedFile file = files[i];
                    FileUp fu = new FileUp();

                    string name = fu.Upload(file, path);
                    name = name.Split('.')[0];
                    TimeSpan ts = DateTime.Now - new DateTime(1970, 1, 1, 0, 0, 0, 0);
                    string sjc = Convert.ToInt64(ts.TotalSeconds).ToString();

                    string filekzm = file.FileName.Substring(file.FileName.LastIndexOf(".") + 1, (file.FileName.Length - file.FileName.LastIndexOf(".") - 1));

                    //   jsonData = "{\"relativePath\":" + "\"" + path + "\"}";




                    //   jsonData = "{\"relativePath\":" + "\/" + path + ",\"originFileName\"}";
                    jsonData = "{\"relativePath\":" + "\"" + path + "\",\"originFileName\":" + "\"" + file.FileName + "\",\"uploadTimeStamp\":" + "\"" + sjc + "\",\"suffix\":" + "\"." + filekzm + "\",\"fileType\":" + "\"image/"
                                          + filekzm + "\",\"fileId\":" + "\"" + name + "\"}";
                }
            }

            //{ "C-Response-Desc":"success","C-API-Status":"00","C-Response-Body":"{\"relativePath\":\"file/fileserver/\",\"originFileName\":\"????1.jpg\",\"uploadTimeStamp\":\"20210204195738643\",\"suffix\":\".jpg\",\"fileType\":\"image/jpeg\",\"fileId\":\"20210204195738643eF3MJBMN\"}","C-Response-Code":"000000000000"
            //string jsonData = "{\"relativePath\":" + re.dayCompNums + ",\"originFileName\":" + re.dayFinshNums + ",\"uploadTimeStamp\":\"" + re.monthCompNums + "\",\"suffix\":\"" + re.monthFinshNums + "\"}";

            var obj = new
            {
                state = "success",
                message = "00",
                code = "000000",
                returnList = jsonData,

                //   returnList = dt,
            };

            return Content(obj.ToJson().Replace("state", "C-Response-Desc").Replace("message", "C-API-Status").Replace("returnList", "C-Response-Body").Replace("code", "C-Response-Code"));

        }
        public ActionResult zmhd10002()
        {
            string sql = "  F_IsDelete=0 ";
            StreamReader reader = new StreamReader(System.Web.HttpContext.Current.Request.InputStream);
            var postString = reader.ReadToEnd();
            JObject result = null;
            result = (JObject)Newtonsoft.Json.JsonConvert.DeserializeObject(postString);
            var txnCommCom = result["txnCommCom"].ToString();
            var txnBodyCom = result["txnBodyCom"].ToString();
            var txnBodyComresult = (JObject)Newtonsoft.Json.JsonConvert.DeserializeObject(txnBodyCom);
            var txnCommComresult = (JObject)Newtonsoft.Json.JsonConvert.DeserializeObject(txnCommCom);
            string strtel = txnBodyComresult["strRdial_Tel"] == null ? "" : txnBodyComresult["strRdial_Tel"].ToString(); //市民电话
            var source = txnBodyComresult["strStm_Src_Dsc"] == null ? "" : txnBodyComresult["strStm_Src_Dsc"].ToString();// 1 市长热线 2 市长信箱 0 连线政府 3 人民网
            string strkey = txnBodyComresult["strWrkOrdr_Ttl_Dtl"] == null ? "" : txnBodyComresult["strWrkOrdr_Ttl_Dtl"].ToString();//关键字检索
            var pageSize = txnCommComresult["tPageJump"] == null ? "1" : txnCommComresult["tPageJump"].ToString();
            var pageNumber = txnCommComresult["tRecInPage"] == null ? "10" : txnCommComresult["tRecInPage"].ToString();
            var state = txnBodyComresult["strWrkOrdr_StCd"] == null ? "" : txnBodyComresult["strWrkOrdr_StCd"].ToString(); //工单状态代码
            string strstarttime = txnBodyComresult["strCrt_StDt"] == null ? "" : txnBodyComresult["strCrt_StDt"].ToString();//创建开始日期
            string strendtime = txnBodyComresult["strCrt_EdDt"] == null ? "" : txnBodyComresult["strCrt_EdDt"].ToString(); //创建结束日期
            string strrepstarttime = txnBodyComresult["strStReplyDt"] == null ? "" : txnBodyComresult["strStReplyDt"].ToString(); //创建结束日期
            string strrependtime = txnBodyComresult["strEdReplyDt"] == null ? "" : txnBodyComresult["strEdReplyDt"].ToString(); //创建结束日期
            string Title = txnBodyComresult["strWrkOrdr_Ttl"] == null ? "" : txnBodyComresult["strWrkOrdr_Ttl"].ToString();//工单标题
            string orderzd = txnBodyComresult["strPgg_Seq_TpCd"] == null ? "" : txnBodyComresult["strPgg_Seq_TpCd"].ToString(); ;//排序方式
            string isproresult = txnBodyComresult["strRcrd_ID"] == null ? "" : txnBodyComresult["strRcrd_ID"].ToString();//营商标识 
            if (Title.Trim() != "" && Title != "undefined")
            {
                sql += " and (F_ComTitle like '%" + Title + "%' or F_ComContent like '%" + Title + "%') ";
            }
            string InfoType = txnBodyComresult["strWrkOrdr_Lv1_Bsn_TpCd"] == null ? "" : txnBodyComresult["strWrkOrdr_Lv1_Bsn_TpCd"].ToString();//工单一级业务类型代码
            string InfoType1 = txnBodyComresult["strWrkOrdr_Lvl2_Bsn_TpCd"] == null ? "" : txnBodyComresult["strWrkOrdr_Lvl2_Bsn_TpCd"].ToString();//工单一级业务类型代码
            string sqlwhere = "";
            if (InfoType1.Trim() != "" && InfoType1 != "undefined")
            {
                sqlwhere += "INNER JOIN[GetValueId]('" + InfoType1 + "') Value on a.F_Key = Value.F_ValueId";
            }
            else if (InfoType.Trim() != "" && InfoType != "undefined")
            {
                sqlwhere += "INNER JOIN[GetValueId]('" + InfoType + "') Value on a.F_Key = Value.F_ValueId";
            }
            sql += " and isnull(F_IsResult,0) = '0' ";
            if (state.Trim() != "" && state != "undefined")
            {
                if (state == "1")
                {
                    sql += " and F_WorkState in (" + (int)EnumWorkState.neworder + "," + (int)EnumWorkState.submit + "," + (int)EnumWorkState.receive + (int)EnumWorkState.resubmit + ") ";
                }
                else if (state == "2")
                {
                    sql += " and F_WorkState in (" + (int)EnumWorkState.auditreback + "," + (int)EnumWorkState.dealing + "," + (int)EnumWorkState.auditdelay + (int)EnumWorkState.reload + (int)EnumWorkState.audit + (int)EnumWorkState.rejload + ") ";
                }
                else if (state == "3")
                {
                    sql += " and F_WorkState in (" + (int)EnumWorkState.visit + "," + (int)EnumWorkState.finish + "," + (int)EnumWorkState.dealed + ") ";
                }
                else if (state == "4")
                {
                    sql += " and F_WorkState in (" + (int)EnumWorkState.neworder + "," + (int)EnumWorkState.submit + "," + (int)EnumWorkState.receive + (int)EnumWorkState.resubmit + (int)EnumWorkState.auditreback + "," + (int)EnumWorkState.dealing + "," + (int)EnumWorkState.auditdelay + (int)EnumWorkState.reload + (int)EnumWorkState.audit + (int)EnumWorkState.rejload  + ") ";
                }

            }
            if (source.Trim() != "" && source != "undefined")
            {
                //1 市长热线 2 市长信箱 0 连线政府 3 人民网
                if (source == "0")
                {
                    source = "2458";
                }
                if (source == "3")
                {
                    source = "4";
                }
                sql += " and F_InfoSource = '" + source + "' ";
            }

            if (strtel.Trim() != "" && strtel != "undefined")
            {
                sql += " and (F_CusPhone = '" + strtel + "' or F_ConPhone = '" + strtel + "') ";
            }
            else
            {
                sql += " and F_IsOpen=1 ";
            }
            if (strkey.Trim() != "" && strkey != "undefined")
            {
                sql += " and (F_ComTitle like '%" + strkey + "%' or F_ComContent like '%" + strkey + "%') ";
            }
            if (strstarttime.Trim() != "" && strstarttime != "undefined")
            {
                sql += " and datediff(day,F_CreateTime,'" + strstarttime + "')<=0 ";
            }
            if (strendtime.Trim() != "" && strendtime != "undefined")
            {
                sql += " and datediff(day,F_CreateTime,'" + strendtime + "')>=0   ";
            }
            if (strrepstarttime.Trim() != "" && strrepstarttime != "undefined")
            {
                sql += " and datediff(day,F_DealTime,'" + strrepstarttime + "')<=0 ";
            }
            if (strrependtime.Trim() != "" && strrependtime != "undefined")
            {
                sql += " and datediff(day,F_DealTime,'" + strrependtime + "')>=0 ";
            }
            string orderby = "ORDER BY F_CreateTime DESC";
            if (orderzd.Trim() != "" && orderzd != "undefined")
            {
                if (orderzd == "ASC")
                {
                    orderby = " ORDER by F_CreateTime ASC";
                }
                if (orderzd == "DESC")
                {
                    orderby = " ORDER by F_CreateTime DESC";
                }
            }
            int recordCount = 0;
            var orderlist = BLL.PagerBLL.GetListPager(
                "T_Bus_WorkOrder a WITH(NOLOCK) "+sqlwhere ,
                "F_WorkOrderId",
                "*",
                      //" and "+ sql+ " and F_WorkOrderId='GD210127090257571'",
                      " and " + sql,
                orderby,
                     Convert.ToInt32(pageNumber),
               Convert.ToInt32(pageSize),

                true,
                out recordCount);

            DataTable dt = new DataTable();

            DataColumn dc = null;
            //工单编号
            dc = dt.Columns.Add("strWrkOrdr_ID", Type.GetType("System.String"));
            //工单类型代码
            dc = dt.Columns.Add("strWrkOrdr_TpCd", Type.GetType("System.String"));
            //工单状态代码
            dc = dt.Columns.Add("strWrkOrdr_StCd", Type.GetType("System.String"));
            //工单标题
            dc = dt.Columns.Add("strWrkOrdr_Ttl", Type.GetType("System.String"));
            //工单详细情况描述
            dc = dt.Columns.Add("strWrkOrdr_Dtl_StnDsc", Type.GetType("System.String"));
            //当前提交时间
            dc = dt.Columns.Add("strCrt_Dt_Tm", Type.GetType("System.String"));
            //客户名称
            dc = dt.Columns.Add("strCst_Nm", Type.GetType("System.String"));
            //客户编号
            dc = dt.Columns.Add("strCst_ID", Type.GetType("System.String"));
            //工单一级业务类型代码
            dc = dt.Columns.Add("strWrkOrdr_Lv1_Bsn_TpCd", Type.GetType("System.String"));
            //工单一级业务类型描述
            dc = dt.Columns.Add("strWrkOrdr_Lv1_Bsn_TpCd_DESC", Type.GetType("System.String"));

            //工单处理机构编号
            dc = dt.Columns.Add("strWrkOrdr_Pcsg_InsID", Type.GetType("System.String"));
            //工单处理机构名称
            dc = dt.Columns.Add("strWrkOrdr_Pcsg_Inst_Nm", Type.GetType("System.String"));
            //工单处理时间
            dc = dt.Columns.Add("strCnvrstn_No", Type.GetType("System.String"));

            //回复局委名称
            dc = dt.Columns.Add("strInpt_Inst_Nm", Type.GetType("System.String"));

            //局委回复内容
            dc = dt.Columns.Add("strWrkOrdr_Pcsg_StnCm", Type.GetType("System.String"));

            //更新时间
            dc = dt.Columns.Add("strUdt_Dt_Tm", Type.GetType("System.String"));
            //事项所在区域的名称
            dc = dt.Columns.Add("strBlg_Br_Nm", Type.GetType("System.String"));
            dc = dt.Columns.Add("strFrcst_Pcsg_CODt", Type.GetType("System.String"));
            dc = dt.Columns.Add("strHpCnt", Type.GetType("System.String"));
            for (int i = 0; i < orderlist.Rows.Count; i++)
            {
                DataRow newRow;
                newRow = dt.NewRow();
                newRow["strWrkOrdr_ID"] = orderlist.Rows[i]["F_WorkOrderId"].ToString();
                newRow["strWrkOrdr_TpCd"] = orderlist.Rows[i]["F_InfoSource"].ToString();
                if (DbHelperSQL.GetSingle("select top 1  WorkOrderId from  PublicComment where WorkOrderId='" + orderlist.Rows[i]["F_WorkOrderId"].ToString() + "'") != null)
                {
                    if (DbHelperSQL.GetSingle("select top 1  WorkOrderId from  PublicComment where WorkOrderId='" + orderlist.Rows[i]["F_WorkOrderId"].ToString() + "'").ToString() == orderlist.Rows[i]["F_WorkOrderId"].ToString())
                        newRow["strHpCnt"] = 3;
                }
                else
                {
                    newRow["strHpCnt"] = 2;
                }


                if (orderlist.Rows[i]["F_WorkState"].ToString() == "0"
                    || orderlist.Rows[i]["F_WorkState"].ToString() == "1" || orderlist.Rows[i]["F_WorkState"].ToString() == "2" || orderlist.Rows[i]["F_WorkState"].ToString() == "11")
                    newRow["strWrkOrdr_StCd"] = "1";
                else if (orderlist.Rows[i]["F_WorkState"].ToString() == "6"
                  || orderlist.Rows[i]["F_WorkState"].ToString() == "7" || orderlist.Rows[i]["F_WorkState"].ToString() == "9")
                    newRow["strWrkOrdr_StCd"] = "3";
                else
                    newRow["strWrkOrdr_StCd"] = "2";
                newRow["strWrkOrdr_Ttl"] = orderlist.Rows[i]["F_ComTitle"].ToString();

                if (!string.IsNullOrEmpty(orderlist.Rows[i]["F_Content"].ToString()))
                    newRow["strWrkOrdr_Dtl_StnDsc"] = orderlist.Rows[i]["F_Content"].ToString();
                else
                    newRow["strWrkOrdr_Dtl_StnDsc"] = orderlist.Rows[i]["F_ComContent"].ToString();
              //  newRow["strWrkOrdr_Dtl_StnDsc"] = orderlist.Rows[i]["F_ComContent"].ToString();
                newRow["strCrt_Dt_Tm"] = orderlist.Rows[i]["F_CreateTime"].ToString();
                newRow["strCst_Nm"] = orderlist.Rows[i]["F_CusName"].ToString();
                newRow["strCst_ID"] = orderlist.Rows[i]["F_Id"].ToString();

                //  newRow["strWrkOrdr_Lv1_Bsn_TpCd"] = orderlist[i].F_InfoType.ToString();

                if (!string.IsNullOrEmpty(orderlist.Rows[i]["F_Key"].ToString()))
                {
                    try
                    {
                        var dicvalue = new BLL.T_Sys_DictionaryValue
                                               ().GetModel(int.Parse(orderlist.Rows[i]["F_Key"].ToString()));
                        if (dicvalue != null)
                        {
                            if (dicvalue.F_Layer == 4)
                            {
                                var dic = new BLL.T_Sys_DictionaryValue().GetModelList
                                    ("F_ValueId =(SELECT F_PrentId  FROM T_Sys_DictionaryValue WHERE F_ValueId = (SELECT F_PrentId  FROM T_Sys_DictionaryValue WHERE F_ValueId = (SELECT F_PrentId  FROM T_Sys_DictionaryValue WHERE  F_ValueId = '" + orderlist.Rows[i]["F_Key"].ToString() + "')) ) ");
                                if (dic != null && dic.Count > 0)
                                {
                                    newRow["strWrkOrdr_Lv1_Bsn_TpCd"] = dic[0].F_ValueId.ToString();
                                    newRow["strWrkOrdr_Lv1_Bsn_TpCd_DESC"] = dic[0].F_Value;
                                }
                            }
                            else if (dicvalue.F_Layer == 3)
                            {
                                var dic = new BLL.T_Sys_DictionaryValue().GetModelList
                                      ("F_ValueId =(SELECT F_PrentId  FROM T_Sys_DictionaryValue WHERE F_ValueId = (SELECT F_PrentId  FROM T_Sys_DictionaryValue WHERE   F_ValueId = '" + orderlist.Rows[i]["F_Key"].ToString() + "')) ");
                                if (dic != null && dic.Count > 0)
                                {
                                    newRow["strWrkOrdr_Lv1_Bsn_TpCd"] = dic[0].F_ValueId.ToString();
                                    newRow["strWrkOrdr_Lv1_Bsn_TpCd_DESC"] = dic[0].F_Value;
                                }


                            }
                            else if (dicvalue.F_Layer == 2)
                            {
                                var dic = new BLL.T_Sys_DictionaryValue().GetModelList
                                      ("F_ValueId =(SELECT F_PrentId  FROM T_Sys_DictionaryValue WHERE F_ValueId  = '" + orderlist.Rows[i]["F_Key"].ToString() + "') ");
                                if (dic != null && dic.Count > 0)
                                {
                                    newRow["strWrkOrdr_Lv1_Bsn_TpCd"] = dic[0].F_ValueId.ToString();
                                    newRow["strWrkOrdr_Lv1_Bsn_TpCd_DESC"] = dic[0].F_Value;
                                }


                            }
                            else
                            {
                                newRow["strWrkOrdr_Lv1_Bsn_TpCd"] = dicvalue.F_ValueId.ToString();
                                newRow["strWrkOrdr_Lv1_Bsn_TpCd_DESC"] = dicvalue.F_Value;
                            }
                        }

                    }
                    catch (Exception e)
                    {
                        newRow["strWrkOrdr_Lv1_Bsn_TpCd"] = orderlist.Rows[i]["F_Key"].ToString();
                        newRow["strWrkOrdr_Lv1_Bsn_TpCd_DESC"] = e.Message;
                    }

                }
                if (!string.IsNullOrEmpty(orderlist.Rows[i]["F_MainDeptId"].ToString()))
                {
                    //newRow["strWrkOrdr_Pcsg_Inst_Nm"] = orderlist.Rows[i]["F_MainDeptId"].ToString();
                    if (DbHelperSQL.GetSingle("select top 1 F_DeptName from  T_Sys_Department where F_DeptId='" + orderlist.Rows[i]["F_MainDeptId"].ToString() + "'") != null)
                    {
                        newRow["strWrkOrdr_Pcsg_Inst_Nm"] = DbHelperSQL.GetSingle("select top 1 F_DeptName from  T_Sys_Department where F_DeptId='" + orderlist.Rows[i]["F_MainDeptId"].ToString() + "'").ToString();
                    }
                    if (DbHelperSQL.GetSingle("select top 1 F_DeptName from  T_Sys_Department where F_DeptId='" + orderlist.Rows[i]["F_MainDeptId"].ToString() + "'") != null)
                    {
                        newRow["strInpt_Inst_Nm"] = DbHelperSQL.GetSingle("select top 1 F_DeptName from  T_Sys_Department where F_DeptId='" + orderlist.Rows[i]["F_MainDeptId"].ToString() + "'").ToString();
                    }

                }

                if (!string.IsNullOrEmpty(orderlist.Rows[i]["F_DealTime"].ToString()))
                    newRow["strFrcst_Pcsg_CODt"] = orderlist.Rows[i]["F_DealTime"].ToString();
                else if (!string.IsNullOrEmpty(orderlist.Rows[i]["F_CloseTime"].ToString()))
                    newRow["strFrcst_Pcsg_CODt"] = orderlist.Rows[i]["F_CloseTime"].ToString();
                else
                    newRow["strFrcst_Pcsg_CODt"] = orderlist.Rows[i]["F_CreateTime"].ToString();
                newRow["strCnvrstn_No"] = orderlist.Rows[i]["F_DealTime"].ToString();
                newRow["strWrkOrdr_Pcsg_StnCm"] = orderlist.Rows[i]["F_Result"].ToString();
                if (!string.IsNullOrEmpty(orderlist.Rows[i]["F_DealTime"].ToString()))
                    newRow["strUdt_Dt_Tm"] = orderlist.Rows[i]["F_DealTime"].ToString();
                else if (!string.IsNullOrEmpty(orderlist.Rows[i]["F_CloseTime"].ToString()))
                    newRow["strUdt_Dt_Tm"] = orderlist.Rows[i]["F_CloseTime"].ToString();
                else
                    newRow["strUdt_Dt_Tm"] = orderlist.Rows[i]["F_CreateTime"].ToString();
                if (!string.IsNullOrEmpty(orderlist.Rows[i]["F_SourceArea"].ToString()))
                {
                    if (DbHelperSQL.GetSingle("select top 1 F_AreaName from  T_Sys_Area where F_AreaId=" + orderlist.Rows[i]["F_SourceArea"]) != null)
                    {
                        newRow["strBlg_Br_Nm"] = DbHelperSQL.GetSingle("select top 1 F_AreaName from  T_Sys_Area where F_AreaId='" + orderlist.Rows[i]["F_SourceArea"].ToString() + "'").ToString();
                    }


                }

                dt.Rows.Add(newRow);
            }



            #region 声音文件和交办超时
            #endregion
            //var obj = new
            //{
            //    state = "success",
            //    message = "成功",
            //    returnList = dt,
            //};
            var cosum = DbHelperSQL.GetSingle("  select count(*)  from T_Bus_WorkOrder  where " + sql).ToString();
            //  var cosum = dt.Rows.Count;
            pagination pa = new pagination();
            pa.tCurrTotalPage = Convert.ToInt32(pageSize);
            pa.totalPage = Convert.ToInt32(Convert.ToInt32(cosum) / Convert.ToInt32(pageNumber));

            pa.total_rec = Convert.ToInt32(cosum);
            pa.tCurrTotalRec = Convert.ToInt32(pageNumber);

            var obj = new
            {
                state = "success",
                message = "成功",
                pagination = pa,
                returnList = dt
            };
            return Content(obj.ToJson());
        }
        public ActionResult zmhd10009()
        {
            string sql = "  F_IsDelete=0 ";


            StreamReader reader = new StreamReader(System.Web.HttpContext.Current.Request.InputStream);
            var postString = reader.ReadToEnd();
            JObject result = null;
            result = (JObject)Newtonsoft.Json.JsonConvert.DeserializeObject(postString);


            var txnCommCom = result["txnCommCom"].ToString();


            var txnBodyCom = result["txnBodyCom"].ToString();

            var txnBodyComresult = (JObject)Newtonsoft.Json.JsonConvert.DeserializeObject(txnBodyCom);

            var txnCommComresult = (JObject)Newtonsoft.Json.JsonConvert.DeserializeObject(txnCommCom);
            string strtel = txnBodyComresult["strRdial_Tel"] == null ? "" : txnBodyComresult["strRdial_Tel"].ToString(); //市民电话

            var source = txnBodyComresult["strStm_Src_Dsc"] == null ? "" : txnBodyComresult["strStm_Src_Dsc"].ToString();// 1 市长热线 2 市长信箱 0 连线政府 3 人民网
            string strkey = txnBodyComresult["strWrkOrdr_Ttl_Dtl"] == null ? "" : txnBodyComresult["strWrkOrdr_Ttl_Dtl"].ToString();//关键字检索

            //var pageNumber = txnCommComresult["tRecInPage"] == null ? "1" : txnCommComresult["tRecInPage"].ToString();
            //var pageSize = txnCommComresult["tPageJump"] == null ? "10" : txnCommComresult["tPageJump"].ToString();




            var pageSize = txnCommComresult["tPageJump"] == null ? "1" : txnCommComresult["tPageJump"].ToString();
            var pageNumber = txnCommComresult["tRecInPage"] == null ? "10" : txnCommComresult["tRecInPage"].ToString();



            var state = txnBodyComresult["strWrkOrdr_StCd"] == null ? "" : txnBodyComresult["strWrkOrdr_StCd"].ToString(); //工单状态代码
                                                                                                                           //int workOrdr_StCd = RequestString.GetInt("strWrkOrdr_StCd",0 );//工单状态代码 1-待处理 2-办理中  3-已回复 4-未回复
                                                                                                                           //工单一级业务类型代码
            string strstarttime = txnBodyComresult["strCrt_StDt"] == null ? "" : txnBodyComresult["strCrt_StDt"].ToString();//创建开始日期
            string strendtime = txnBodyComresult["strCrt_EdDt"] == null ? "" : txnBodyComresult["strCrt_EdDt"].ToString(); //创建结束日期

            string strrepstarttime = txnBodyComresult["strStReplyDt"] == null ? "" : txnBodyComresult["strStReplyDt"].ToString(); //创建结束日期

            string strrependtime = txnBodyComresult["strEdReplyDt"] == null ? "" : txnBodyComresult["strEdReplyDt"].ToString(); //创建结束日期

            string Title = txnBodyComresult["strWrkOrdr_Ttl"] == null ? "" : txnBodyComresult["strWrkOrdr_Ttl"].ToString();//工单标题

            string orderzd = txnBodyComresult["strPgg_Seq_TpCd"] == null ? "" : txnBodyComresult["strPgg_Seq_TpCd"].ToString(); ;//排序方式

            //string strtel = HttpUtility.UrlDecode(RequestString.GetQueryString("strRdial_Tel"));//市民电话


            string isproresult = txnBodyComresult["strRcrd_ID"] == null ? "" : txnBodyComresult["strRcrd_ID"].ToString();//营商标识 


            if (Title.Trim() != "" && Title != "undefined")
            {
                sql += " and (F_ComTitle like '%" + Title + "%' or F_ComContent like '%" + Title + "%') ";


                //  sql += " and F_ComTitle in (" + Title + ") ";
            }
            string InfoType = txnBodyComresult["strWrkOrdr_Lv1_Bsn_TpCd"] == null ? "" : txnBodyComresult["strWrkOrdr_Lv1_Bsn_TpCd"].ToString();//工单一级业务类型代码
            string InfoType1 = txnBodyComresult["strWrkOrdr_Lvl2_Bsn_TpCd"] == null ? "" : txnBodyComresult["strWrkOrdr_Lvl2_Bsn_TpCd"].ToString();//工单一级业务类型代码
            string sqlwhere = "";
            if (InfoType1.Trim() != "" && InfoType1 != "undefined")
            {
                sqlwhere += "INNER JOIN[GetValueId]('" + InfoType1 + "') Value on a.F_Key = Value.F_ValueId";

            }
            else if (InfoType.Trim() != "" && InfoType != "undefined")
            {
                sqlwhere += "INNER JOIN[GetValueId]('" + InfoType + "') Value on a.F_Key = Value.F_ValueId";
            }
            sql += " and isnull(F_IsResult,0) = '0' ";

            if (state.Trim() != "" && state != "undefined")
            {
                if (state == "1")
                {
                    sql += " and F_WorkState in (" + (int)EnumWorkState.neworder + "," + (int)EnumWorkState.submit + "," + (int)EnumWorkState.receive + (int)EnumWorkState.resubmit + ") ";
                }
                else if (state == "2")
                {
                    sql += " and F_WorkState in (" + (int)EnumWorkState.auditreback + "," + (int)EnumWorkState.dealing + "," + (int)EnumWorkState.auditdelay + (int)EnumWorkState.reload + (int)EnumWorkState.audit + (int)EnumWorkState.rejload + ") ";
                }
                else if (state == "3")
                {
                    sql += " and F_WorkState in (" + (int)EnumWorkState.visit + "," + (int)EnumWorkState.finish + ","+(int)EnumWorkState.dealed + ") ";
                }
                else if (state == "4")
                {
                   
                    sql += " and F_WorkState not in ( 6,7,9 ) ";
                }

            }
            if (source.Trim() != "" && source != "undefined")
            {
                //1 市长热线 2 市长信箱 0 连线政府 3 人民网
                if (source == "0")
                {
                    source = "2458";
                }
                if (source == "3")
                {
                    source = "4";
                }
                sql += " and F_InfoSource = '" + source + "' ";
            }

            if (strtel.Trim() != "" && strtel != "undefined")
            {
                sql += " and (F_CusPhone like '%" + strtel + "%' or F_ConPhone like '%" + strtel + "%') ";
            }
            else
            {
                sql += " and F_IsOpen=1 ";
            }
            if (strkey.Trim() != "" && strkey != "undefined")
            {
                sql += " and (F_ComTitle like '%" + strkey + "%' or F_ComContent like '%" + strkey + "%') ";

            }
            if (strstarttime.Trim() != "" && strstarttime != "undefined")
            {
                sql += " and datediff(day,F_CreateTime,'" + strstarttime + "')<=0 ";
            }
            if (strendtime.Trim() != "" && strendtime != "undefined")
            {
                sql += " and datediff(day,F_CreateTime,'" + strendtime + "')>=0   ";
            }


            if (strrepstarttime.Trim() != "" && strrepstarttime != "undefined")
            {
                sql += " and datediff(day,F_DealTime,'" + strrepstarttime + "')<=0 ";
            }
            if (strrependtime.Trim() != "" && strrependtime != "undefined")
            {
                sql += " and datediff(day,F_DealTime,'" + strrependtime + "')>=0 ";
            }

            string orderby = "ORDER BY F_CreateTime DESC";
            if (orderzd.Trim() != "" && orderzd != "undefined")
            {
                if (orderzd == "ASC")
                {
                    orderby = " ORDER by F_CreateTime ASC";
                }
                if (orderzd == "DESC")
                {
                    orderby = " ORDER by F_CreateTime DESC";
                }
            }

            //var dt = DbHelperSQL.Query(sql).Tables[0];


            //var orderlist = workorderBLL.DataTableToList(workorderBLL.GetListByPage(sql, "F_Id", Convert.ToInt32(pageNumber), Convert.ToInt32(pageSize)).Tables[0]);

            int recordCount = 0;
            var orderlist = BLL.PagerBLL.GetListPager(
                "T_Bus_WorkOrder a WITH(NOLOCK)"+sqlwhere ,
                "F_WorkOrderId",
                "*",
                      //" and "+ sql+ " and F_WorkOrderId='GD210127090257571'",
                      " and " + sql,
                orderby,
                     Convert.ToInt32(pageNumber),
               Convert.ToInt32(pageSize),

                true,
                out recordCount);

            DataTable dt = new DataTable();

            DataColumn dc = null;
            //工单编号
            dc = dt.Columns.Add("strWrkOrdr_ID", Type.GetType("System.String"));
            //工单类型代码
            dc = dt.Columns.Add("strWrkOrdr_TpCd", Type.GetType("System.String"));
            //工单状态代码
            dc = dt.Columns.Add("strWrkOrdr_StCd", Type.GetType("System.String"));
            //工单标题
            dc = dt.Columns.Add("strWrkOrdr_Ttl", Type.GetType("System.String"));
            //工单详细情况描述
            dc = dt.Columns.Add("strWrkOrdr_Dtl_StnDsc", Type.GetType("System.String"));
            //当前提交时间
            dc = dt.Columns.Add("strCrt_Dt_Tm", Type.GetType("System.String"));
            //客户名称
            dc = dt.Columns.Add("strCst_Nm", Type.GetType("System.String"));
            //客户编号
            dc = dt.Columns.Add("strCst_ID", Type.GetType("System.String"));
            //工单一级业务类型代码
            dc = dt.Columns.Add("strWrkOrdr_Lv1_Bsn_TpCd", Type.GetType("System.String"));
            //工单一级业务类型描述
            dc = dt.Columns.Add("strWrkOrdr_Lv1_Bsn_TpCd_DESC", Type.GetType("System.String"));

            //工单处理机构编号
            dc = dt.Columns.Add("strWrkOrdr_Pcsg_InsID", Type.GetType("System.String"));
            //工单处理机构名称
            dc = dt.Columns.Add("strWrkOrdr_Pcsg_Inst_Nm", Type.GetType("System.String"));
            //工单处理时间
            dc = dt.Columns.Add("strCnvrstn_No", Type.GetType("System.String"));

            //回复局委名称
            dc = dt.Columns.Add("strInpt_Inst_Nm", Type.GetType("System.String"));

            //局委回复内容
            dc = dt.Columns.Add("strWrkOrdr_Pcsg_StnCm", Type.GetType("System.String"));

            //更新时间
            dc = dt.Columns.Add("strUdt_Dt_Tm", Type.GetType("System.String"));
            //事项所在区域的名称
            dc = dt.Columns.Add("strBlg_Br_Nm", Type.GetType("System.String"));
            dc = dt.Columns.Add("strFrcst_Pcsg_CODt", Type.GetType("System.String"));
            dc = dt.Columns.Add("strHpCnt", Type.GetType("System.String"));
            for (int i = 0; i < orderlist.Rows.Count; i++)
            {
                DataRow newRow;
                newRow = dt.NewRow();
                newRow["strWrkOrdr_ID"] = orderlist.Rows[i]["F_WorkOrderId"].ToString();
                newRow["strWrkOrdr_TpCd"] = orderlist.Rows[i]["F_InfoSource"].ToString();
                if (Convert.ToInt32(DbHelperSQL.GetSingle("select count(1) from  PublicComment where WorkOrderId='" + orderlist.Rows[i]["F_WorkOrderId"].ToString() + "'")
                .ToString()) > 0)
                {
                    newRow["strHpCnt"] = 3;
                }
                else
                {
                    newRow["strHpCnt"] = 2;
                }
                if (orderlist.Rows[i]["F_WorkState"].ToString() == "0"
                    || orderlist.Rows[i]["F_WorkState"].ToString() == "1" || orderlist.Rows[i]["F_WorkState"].ToString() == "2" || orderlist.Rows[i]["F_WorkState"].ToString() == "11")
                    newRow["strWrkOrdr_StCd"] = "1";
                else if ( orderlist.Rows[i]["F_WorkState"].ToString() == "7" || orderlist.Rows[i]["F_WorkState"].ToString() == "9")
                    newRow["strWrkOrdr_StCd"] = "3";
                else
                    newRow["strWrkOrdr_StCd"] = "2";
                newRow["strWrkOrdr_Ttl"] = orderlist.Rows[i]["F_ComTitle"].ToString();
                if (!string .IsNullOrEmpty (orderlist.Rows[i]["F_Content"].ToString()))
                newRow["strWrkOrdr_Dtl_StnDsc"] = orderlist.Rows[i]["F_Content"].ToString();
                else
                    newRow["strWrkOrdr_Dtl_StnDsc"] = orderlist.Rows[i]["F_ComContent"].ToString();
                newRow["strCrt_Dt_Tm"] = orderlist.Rows[i]["F_CreateTime"].ToString();
                newRow["strCst_Nm"] = orderlist.Rows[i]["F_CusName"].ToString();
                newRow["strCst_ID"] = orderlist.Rows[i]["F_Id"].ToString();

                //  newRow["strWrkOrdr_Lv1_Bsn_TpCd"] = orderlist[i].F_InfoType.ToString();

                if (!string.IsNullOrEmpty(orderlist.Rows[i]["F_Key"].ToString()))
                {
                    try
                    {
                        var dicvalue = new BLL.T_Sys_DictionaryValue
                                               ().GetModel(int.Parse(orderlist.Rows[i]["F_Key"].ToString()));
                        if (dicvalue != null)
                        {
                            if (dicvalue.F_Layer == 4)
                            {
                                var dic = new BLL.T_Sys_DictionaryValue().GetModelList
                                    ("F_ValueId =(SELECT F_PrentId  FROM T_Sys_DictionaryValue WHERE F_ValueId = (SELECT F_PrentId  FROM T_Sys_DictionaryValue WHERE F_ValueId = (SELECT F_PrentId  FROM T_Sys_DictionaryValue WHERE  F_ValueId = '" + orderlist.Rows[i]["F_Key"].ToString() + "')) ) ");
                                if (dic != null && dic.Count > 0)
                                {
                                    newRow["strWrkOrdr_Lv1_Bsn_TpCd"] = dic[0].F_ValueId.ToString();
                                    newRow["strWrkOrdr_Lv1_Bsn_TpCd_DESC"] = dic[0].F_Value;
                                }
                            }
                            else if (dicvalue.F_Layer == 3)
                            {
                                var dic = new BLL.T_Sys_DictionaryValue().GetModelList
                                      ("F_ValueId =(SELECT F_PrentId  FROM T_Sys_DictionaryValue WHERE F_ValueId = (SELECT F_PrentId  FROM T_Sys_DictionaryValue WHERE   F_ValueId = '" + orderlist.Rows[i]["F_Key"].ToString() + "')) ");
                                if (dic != null && dic.Count > 0)
                                {
                                    newRow["strWrkOrdr_Lv1_Bsn_TpCd"] = dic[0].F_ValueId.ToString();
                                    newRow["strWrkOrdr_Lv1_Bsn_TpCd_DESC"] = dic[0].F_Value;
                                }


                            }
                            else if (dicvalue.F_Layer == 2)
                            {
                                var dic = new BLL.T_Sys_DictionaryValue().GetModelList
                                      ("F_ValueId =(SELECT F_PrentId  FROM T_Sys_DictionaryValue WHERE F_ValueId  = '" + orderlist.Rows[i]["F_Key"].ToString() + "') ");
                                if (dic != null && dic.Count > 0)
                                {
                                    newRow["strWrkOrdr_Lv1_Bsn_TpCd"] = dic[0].F_ValueId.ToString();
                                    newRow["strWrkOrdr_Lv1_Bsn_TpCd_DESC"] = dic[0].F_Value;
                                }


                            }
                            else
                            {
                                newRow["strWrkOrdr_Lv1_Bsn_TpCd"] = dicvalue.F_ValueId.ToString();
                                newRow["strWrkOrdr_Lv1_Bsn_TpCd_DESC"] = dicvalue.F_Value;
                            }
                        }

                    }
                    catch (Exception e)
                    {
                        newRow["strWrkOrdr_Lv1_Bsn_TpCd"] = orderlist.Rows[i]["F_Key"].ToString();
                        newRow["strWrkOrdr_Lv1_Bsn_TpCd_DESC"] = e.Message;
                    }

                }
                if (!string.IsNullOrEmpty(orderlist.Rows[i]["F_MainDeptId"].ToString()))
                {
                    //newRow["strWrkOrdr_Pcsg_Inst_Nm"] = orderlist.Rows[i]["F_MainDeptId"].ToString();
                    if (DbHelperSQL.GetSingle("select top 1 F_DeptName from  T_Sys_Department where F_DeptId='" + orderlist.Rows[i]["F_MainDeptId"].ToString() + "'") != null)
                    {
                        newRow["strWrkOrdr_Pcsg_Inst_Nm"] = DbHelperSQL.GetSingle("select top 1 F_DeptName from  T_Sys_Department where F_DeptId='" + orderlist.Rows[i]["F_MainDeptId"].ToString() + "'").ToString();
                    }
                    if (DbHelperSQL.GetSingle("select top 1 F_DeptName from  T_Sys_Department where F_DeptId='" + orderlist.Rows[i]["F_MainDeptId"].ToString() + "'") != null)
                    {
                        newRow["strInpt_Inst_Nm"] = DbHelperSQL.GetSingle("select top 1 F_DeptName from  T_Sys_Department where F_DeptId='" + orderlist.Rows[i]["F_MainDeptId"].ToString() + "'").ToString();
                    }

                }

                if (!string.IsNullOrEmpty(orderlist.Rows[i]["F_DealTime"].ToString()))
                    newRow["strFrcst_Pcsg_CODt"] = orderlist.Rows[i]["F_DealTime"].ToString();
                else if (!string.IsNullOrEmpty(orderlist.Rows[i]["F_CloseTime"].ToString()))
                    newRow["strFrcst_Pcsg_CODt"] = orderlist.Rows[i]["F_CloseTime"].ToString();
                else
                    newRow["strFrcst_Pcsg_CODt"] = orderlist.Rows[i]["F_CreateTime"].ToString();






                newRow["strCnvrstn_No"] = orderlist.Rows[i]["F_DealTime"].ToString();
                newRow["strWrkOrdr_Pcsg_StnCm"] = orderlist.Rows[i]["F_Result"].ToString();
                if (!string.IsNullOrEmpty(orderlist.Rows[i]["F_DealTime"].ToString()))
                    newRow["strUdt_Dt_Tm"] = orderlist.Rows[i]["F_DealTime"].ToString();
                else if (!string.IsNullOrEmpty(orderlist.Rows[i]["F_CloseTime"].ToString()))
                    newRow["strUdt_Dt_Tm"] = orderlist.Rows[i]["F_CloseTime"].ToString();
                else
                    newRow["strUdt_Dt_Tm"] = orderlist.Rows[i]["F_CreateTime"].ToString();
                if (!string.IsNullOrEmpty(orderlist.Rows[i]["F_SourceArea"].ToString()))
                {
                    if (DbHelperSQL.GetSingle("select top 1 F_AreaName from  T_Sys_Area where F_AreaId=" + orderlist.Rows[i]["F_SourceArea"]) != null)
                    {
                        newRow["strBlg_Br_Nm"] = DbHelperSQL.GetSingle("select top 1 F_AreaName from  T_Sys_Area where F_AreaId='" + orderlist.Rows[i]["F_SourceArea"].ToString() + "'").ToString();
                    }


                }

                dt.Rows.Add(newRow);
            }



            #region 声音文件和交办超时
            #endregion
            //var obj = new
            //{
            //    state = "success",
            //    message = "成功",
            //    returnList = dt,
            //};
            var cosum = DbHelperSQL.GetSingle("  select count(*)  from T_Bus_WorkOrder  where " + sql).ToString();
            //  var cosum = dt.Rows.Count;
            pagination pa = new pagination();
            pa.tCurrTotalPage = Convert.ToInt32(pageSize);
            pa.totalPage = Convert.ToInt32(Convert.ToInt32(cosum) / Convert.ToInt32(pageNumber));

            pa.total_rec = Convert.ToInt32(cosum);
            pa.tCurrTotalRec = Convert.ToInt32(pageNumber);

            var obj = new
            {
                state = "success",
                message = "成功",
                pagination = pa,
                returnList = dt
            };
            return Content(obj.ToJson());
        }
        public ActionResult zmhd1000399()
        {
            StreamReader reader = new StreamReader(System.Web.HttpContext.Current.Request.InputStream);
            string sql = "  F_IsDelete=0 ";
            sql += " and F_IsOpen=1 ";
            var postString = reader.ReadToEnd();
            JObject result = null;
            result = (JObject)Newtonsoft.Json.JsonConvert.DeserializeObject(postString);
            var txnBodyCom = result["txnBodyCom"].ToString();      //市民姓名 

            var txnBodyComresult = (JObject)Newtonsoft.Json.JsonConvert.DeserializeObject(txnBodyCom);



            var tes = txnBodyComresult["atchmList"] == null ? "" : txnBodyComresult["atchmList"].ToString();


            var request = System.Web.HttpContext.Current.Request;



            if (!string.IsNullOrEmpty(tes))
            {
                var itemd = JsonConvert.DeserializeObject<List<atchmList>>(tes);
                for (int i = 0; i < itemd.Count; i++)
                {

                }
            }

            var obj = new
            {
                state = "success",
                message = "成功",
            };
            return Content(obj.ToJson());
        }

    }
}