using LYFZ.WXLibrary;
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.SessionState;

namespace LYFZ.WeixinServers
{
    public class Global : System.Web.HttpApplication
    {
        #region 系统函数        
        protected void Application_Start(object sender, EventArgs e)
        {
            // 加载全局性的变量;
            GlobalCache.Refresh_AppType();
            GlobalCache.Refresh_Industry();
            GlobalCache.Refresh_Enterprise();
            GlobalCache.Refresh_MsgServer();
            GlobalCache.Refresh_kfParticulars();
            GlobalCache.Refresh_EntAppEntry();

#if IGNORE
            Global.RefreshLoadCustDaTable();
            try
            {
                RefreshLoadKeywordDaTable();
            }
            catch { }
            try
            {
                RefreshLoadAuthorizationInfoDaTable();
            }
            catch { }
            try
            {
                Global.InitializationMicroLetterEventList();
                LYFZ.WeixinServiceDate.Model.Model_SystemConfigure scModel = scDal.GetModel("NetIPUrl");
                if (scModel != null)
                {
                    NetIPUrl = scModel.Sconfig_Value;
                }

                LYFZ.WeixinServiceDate.Model.Model_SystemConfigure CloudSelectionUrlModel = scDal.GetModel("CloudSelectionUrl");
                if (CloudSelectionUrlModel != null)
                {
                    CloudSelectionUrl = CloudSelectionUrlModel.Sconfig_Value;
                }

            }
            catch { }
#endif
        }

        protected void Session_Start(object sender, EventArgs e)
        {

        }

        protected void Application_BeginRequest(object sender, EventArgs e)
        {

        }

        protected void Application_AuthenticateRequest(object sender, EventArgs e)
        {

        }

        protected void Application_Error(object sender, EventArgs e)
        {

        }

        protected void Session_End(object sender, EventArgs e)
        {

        }

        protected void Application_End(object sender, EventArgs e)
        {

        }
        #endregion

        #region 全局变量
        /// <summary>
        /// 用于程序内部的数据库连接串;
        /// </summary>
        public string AppDataConnectString { get; set; } = "Data Source=DESKTOP-5ILISFF;AttachDbFilename=|DataDirectory|kf_login.mdf;Integrated Security=True;User Instance=True";
        #endregion

        #region 全局函数
        public static string GuidString()
        {
            return Guid.NewGuid().ToString("N");
        }

        public static void GetGlobalCache()
        {
            // app_type;           
            GlobalCache.DT_AuthorizeApp = GlobalCache.DalAppAuthorize.GetAllList().Tables[0];
            GlobalCache.DT_IndustryInfo = GlobalCache.DalIndustry.GetAllList().Tables[0];
            GlobalCache.DT_EnterpriseInfo = GlobalCache.DalEnterprise.GetAllList().Tables[0];
            GlobalCache.DT_AppTypeInfo = GlobalCache.DalAppType.GetAllList().Tables[0];
            GlobalCache.DT_ServerInfo = GlobalCache.DalServer.GetAllList().Tables[0];
            GlobalCache.DT_EnterpriseAppEntry = GlobalCache.DalEnterpriseAppEntry.GetAllList().Tables[0];
            GlobalCache.DT_KfParticularsInfo = GlobalCache.DalKfParticulars.GetAllList().Tables[0];
        }

        public void SetDebugDatabaseDirectory()
        {
            using (System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(AppDataConnectString))
            {
                conn.Open();
                using (System.Data.SqlClient.SqlCommand cmd = conn.CreateCommand())
                {
                    cmd.CommandText = "select count(*) from app_type";
                    object obj = cmd.ExecuteScalar();
                    int count = Convert.ToInt32(obj);
                }
            }

            DataSet ds = GlobalCache.DalAppAuthorize.GetAllList();
            if (ds != null)
            {
                DataTable dt = ds.Tables[0];
                foreach (DataRow dr in dt.Rows)
                {

                }
            }

            for (int i = 0; i < 100; i++ )
            {
                System.Diagnostics.Debug.Write(GuidString() + "\r");
            }
        }
        #endregion

        #region 以前的函数,用于参考

        internal static WeixinServiceDate.Model.Model_CustomerInterfaces GetCustomerModelByWxNumber(string myUserName)
        {
            LYFZ.WeixinServiceDate.Model.Model_CustomerInterfaces custModel = new LYFZ.WeixinServiceDate.Model.Model_CustomerInterfaces();
            DataRow row = Global.GetCustomerDataRowByWxNumber(myUserName);
            if (row != null)
            {
                custModel = CusDal.DataRowToModel(row);
            }
            return custModel;
        }

        private static DataRow GetCustomerDataRowByWxNumber(string myUserName)
        {
            DataRow row = null;

            lock (Global.custDaTable)
            {
                DataRow[] rows = Global.custDaTable.Select(" AppSecret = '" + myUserName + "' ");
                if (rows.Length > 0)
                {
                    row = rows[0];
                }
            }
            if (row == null)
            {
                RefreshLoadCustDaTable();
            }
            return row;
        }

        public static LYFZ.WeixinServiceDate.DAL.DAL_CustomerInterfaces CusDal = new WeixinServiceDate.DAL.DAL_CustomerInterfaces();
        LYFZ.WeixinServiceDate.DAL.DAL_SystemConfigure scDal = new WeixinServiceDate.DAL.DAL_SystemConfigure();

        public static LYFZ.WeixinServiceDate.DAL.DAL_Authorization_info Authorization_infoDal = new WeixinServiceDate.DAL.DAL_Authorization_info();
        private static int pageSize = 100;
        /// <summary>
        /// 每页记录条数
        /// </summary>
        public static int PageSize
        {
            get { return Global.pageSize; }
            set { Global.pageSize = value; }
        }
        static DataTable authorizationInfoDaTable = new DataTable();
        /// <summary>
        /// 公众号授权信息列表
        /// </summary>
        public static DataTable AuthorizationInfoDaTable
        {
            get { return Global.authorizationInfoDaTable; }
            set { Global.authorizationInfoDaTable = value; }
        }
        /// <summary>
        /// 刷新加载公众号授权信息列表
        /// </summary>
        public static void RefreshLoadAuthorizationInfoDaTable()
        {
            DataSet ds = Authorization_infoDal.GetAllList();
            lock (Global.authorizationInfoDaTable)
            {
                try
                {
                    Global.authorizationInfoDaTable.Rows.Clear();
                    Global.authorizationInfoDaTable.Dispose();
                    Global.authorizationInfoDaTable = null;
                }
                catch
                {
                }
                Global.authorizationInfoDaTable = ds.Tables[0];
                Global.authorizationInfoDaTable.PrimaryKey = new DataColumn[] { Global.authorizationInfoDaTable.Columns["authorizer_appid"] };
                Global.RefreshAuthorizedAPPIDHandleList(Global.authorizationInfoDaTable);
            }
        }
        /// <summary>
        /// 刷新已授权公众号的授权信息处理集合
        /// </summary>
        /// <param name="_AuthorizationInfoDaTable"></param>
        public static void RefreshAuthorizedAPPIDHandleList(DataTable _AuthorizationInfoDaTable)
        {
            foreach (DataRow row in _AuthorizationInfoDaTable.Rows)
            {
                LYFZ.WeixinServiceDate.Model.Model_Authorization_info Authorization_infoModel = Authorization_infoDal.DataRowToModel(row);
                AddAuthorizedAPPIDHand(Authorization_infoModel);
            }
        }
        /// <summary>
        /// 更新
        /// </summary>
        /// <param name="Authorization_infoModel"></param>
        public static void UpdateAuthorizedAPPIDHand(LYFZ.WeixinServiceDate.Model.Model_Authorization_info Authorization_infoModel)
        {
            LYFZ.WXLibrary.AuthorizedAPPIDHandle authAPPIDHandle = null;
            if (OpenPlatformConfig.AuthorizedAPPIDHandleList.ContainsKey(Authorization_infoModel.Authorizer_appid))
            {
                authAPPIDHandle = OpenPlatformConfig.AuthorizedAPPIDHandleList[Authorization_infoModel.Authorizer_appid];
                authAPPIDHandle.Authorizer_access_token = Authorization_infoModel.Authorizer_access_token;
                authAPPIDHandle.Expires_in = Authorization_infoModel.Expires_in;
                authAPPIDHandle.Authorizer_refresh_token = Authorization_infoModel.Authorizer_refresh_token;
                authAPPIDHandle.RefreshTokenTime = Authorization_infoModel.RefreshTokenTime;
                authAPPIDHandle.AuthorizeStatus = Authorization_infoModel.AuthorizeStatus;
            }
            else
            {
                AddAuthorizedAPPIDHand(Authorization_infoModel);
            }
        }

        /// <summary>
        /// 移除
        /// </summary>
        /// <param name="Authorization_infoModel"></param>
        public static void RemoveAuthorizedAPPIDHand(LYFZ.WeixinServiceDate.Model.Model_Authorization_info Authorization_infoModel)
        {
            LYFZ.WXLibrary.AuthorizedAPPIDHandle authAPPIDHandle = null;
            lock (OpenPlatformConfig.AuthorizedAPPIDHandleList)
            {
                if (OpenPlatformConfig.AuthorizedAPPIDHandleList.ContainsKey(Authorization_infoModel.Authorizer_appid))
                {
                    authAPPIDHandle = OpenPlatformConfig.AuthorizedAPPIDHandleList[Authorization_infoModel.Authorizer_appid];
                    authAPPIDHandle.EventEvent_AuthorizerRefreshToken -= authAPPIDHandle_EventEvent_AuthorizerRefreshToken;
                    OpenPlatformConfig.AuthorizedAPPIDHandleList.Remove(Authorization_infoModel.Authorizer_appid);
                }
            }

        }
        /// <summary>
        /// 添加授权公众号处理对象到集合中（OpenPlatformConfig.AuthorizedAPPIDHandleList）
        /// </summary>
        /// <param name="Authorization_infoModel"></param>
        public static void AddAuthorizedAPPIDHand(LYFZ.WeixinServiceDate.Model.Model_Authorization_info Authorization_infoModel)
        {
            lock (OpenPlatformConfig.AuthorizedAPPIDHandleList)
            {
                if (!OpenPlatformConfig.AuthorizedAPPIDHandleList.ContainsKey(Authorization_infoModel.Authorizer_appid) && Authorization_infoModel.AuthorizeStatus == 1 && Authorization_infoModel.JMGDomainName.Trim().Length > 0)
                {
                    LYFZ.WXLibrary.AuthorizedAPPIDHandle authAPPIDHandle = new AuthorizedAPPIDHandle(Authorization_infoModel.Authorization_info, Authorization_infoModel.CompanyName, Authorization_infoModel.AuthorizeStatus, Authorization_infoModel.RefreshTokenTime);
                    authAPPIDHandle.EventEvent_AuthorizerRefreshToken += authAPPIDHandle_EventEvent_AuthorizerRefreshToken;
                    OpenPlatformConfig.AuthorizedAPPIDHandleList.Add(Authorization_infoModel.Authorizer_appid, authAPPIDHandle);
                }
            }
        }
        static void authAPPIDHandle_EventEvent_AuthorizerRefreshToken(EventAuthorizerRefreshToken e)
        {
            LYFZ.WeixinServiceDate.Model.Model_Authorization_info Authorization_infoModel =
                (LYFZ.WeixinServiceDate.Model.Model_Authorization_info)Authorization_infoDal.GetModelObject("authorizer_appid", e.Appid);
            if (Authorization_infoModel != null && Authorization_infoModel.ID > 0)
            {
                var authorizationObj = LYFZ.Weixin.SDK.BasicAPI.JsonToDynamic(Authorization_infoModel.Authorization_info);
                authorizationObj.authorization_info.authorizer_access_token = e.Authorizer_access_token;
                authorizationObj.authorization_info.expires_in = e.Expires_in;
                authorizationObj.authorization_info.authorizer_refresh_token = e.Authorizer_refresh_token;
                Authorization_infoModel.RefreshTokenTime = e.RefreshTokenTime;
                Authorization_infoModel.Authorizer_access_token = e.Authorizer_access_token;
                Authorization_infoModel.Expires_in = e.Expires_in;
                Authorization_infoModel.Authorizer_refresh_token = e.Authorizer_refresh_token;
                Authorization_infoModel.Authorization_info = authorizationObj.ToString();
                Authorization_infoDal.Update(Authorization_infoModel);
            }
        }
        /// <summary>
        /// 更新授权处理对象中的加密锁域名
        /// </summary>
        /// <param name="authorizer_Appid"></param>
        /// <param name="JMGDomainName"></param>
        /// <param name="CompanyName"></param>
        public static void UpdateAuthorizedAPPIDHandleJMGDomainName(string authorizer_Appid, string JMGDomainName, string CompanyName)
        {
            LYFZ.WXLibrary.AuthorizedAPPIDHandle authAPPIDHandle = null;
            if (OpenPlatformConfig.AuthorizedAPPIDHandleList.ContainsKey(authorizer_Appid))
            {
                authAPPIDHandle = OpenPlatformConfig.AuthorizedAPPIDHandleList[authorizer_Appid];
                authAPPIDHandle.JMGDomainName = JMGDomainName;
                authAPPIDHandle.CompanyName = CompanyName;
                LYFZ.WeixinServiceDate.Model.Model_Authorization_info Authorization_infoModel =
               (LYFZ.WeixinServiceDate.Model.Model_Authorization_info)Authorization_infoDal.GetModelObject("authorizer_appid", authorizer_Appid);
                if (Authorization_infoModel != null && Authorization_infoModel.ID > 0)
                {
                    Authorization_infoModel.JMGDomainName = authAPPIDHandle.JMGDomainName;
                    Authorization_infoModel.CompanyName = authAPPIDHandle.CompanyName;
                    LYFZ.WXLibrary.CommonHandleClass.WriteLog("更新授权处理对象中的加密锁域名:authorizer_Appid=" + authorizer_Appid + " & JMGDomainName=" + Authorization_infoModel.JMGDomainName, "-2", Global.LogsDongleDomainList);
                    Authorization_infoDal.Update(Authorization_infoModel);
                    UpdateAuthorizationInfoDaTable(authorizer_Appid, Authorization_infoModel);
                }
            }
        }

        /// <summary>
        /// 更新缓存中的授权信息
        /// </summary>
        /// <param name="authorizer_Appid"></param>
        /// <param name="cusModel"></param>
        public static void UpdateAuthorizationInfoDaTable(string authorizer_Appid, LYFZ.WeixinServiceDate.Model.Model_Authorization_info Authorization_infoModel)
        {

            try
            {
                //主键检索查询
                DataRow dr = Global.AuthorizationInfoDaTable.Rows.Find(authorizer_Appid);
                lock (Global.AuthorizationInfoDaTable)
                {
                    if (dr != null)
                    {
                        dr["JMGDomainName"] = Authorization_infoModel.JMGDomainName;
                        dr["CompanyName"] = Authorization_infoModel.CompanyName;
                        dr["authorizer_appid"] = Authorization_infoModel.Authorizer_appid;
                        dr["authorization_info"] = Authorization_infoModel.Authorization_info;
                        dr["AuthorizeStatus"] = Authorization_infoModel.AuthorizeStatus;
                        dr["authorizer_access_token"] = Authorization_infoModel.Authorizer_access_token;
                        dr["expires_in"] = Authorization_infoModel.Expires_in;
                        dr["authorizer_refresh_token"] = Authorization_infoModel.Authorizer_refresh_token;
                        dr["AccountBasicInfo"] = Authorization_infoModel.AccountBasicInfo;
                        dr["CreateTime"] = Authorization_infoModel.CreateTime;
                        dr["UpdateTime"] = Authorization_infoModel.UpdateTime;
                        dr["RefreshTokenTime"] = Authorization_infoModel.RefreshTokenTime;
                    }
                    else
                    {
                        dr = Global.AuthorizationInfoDaTable.NewRow();
                        dr["ID"] = Authorization_infoModel.ID;
                        dr["JMGDomainName"] = Authorization_infoModel.JMGDomainName;
                        dr["CompanyName"] = Authorization_infoModel.CompanyName;
                        dr["authorizer_appid"] = Authorization_infoModel.Authorizer_appid;
                        dr["authorization_info"] = Authorization_infoModel.Authorization_info;
                        dr["AuthorizeStatus"] = Authorization_infoModel.AuthorizeStatus;
                        dr["authorizer_access_token"] = Authorization_infoModel.Authorizer_access_token;
                        dr["expires_in"] = Authorization_infoModel.Expires_in;
                        dr["authorizer_refresh_token"] = Authorization_infoModel.Authorizer_refresh_token;
                        dr["AccountBasicInfo"] = Authorization_infoModel.AccountBasicInfo;
                        dr["CreateTime"] = Authorization_infoModel.CreateTime;
                        dr["UpdateTime"] = Authorization_infoModel.UpdateTime;
                        dr["RefreshTokenTime"] = Authorization_infoModel.RefreshTokenTime;


                        Global.AuthorizationInfoDaTable.Rows.Add(dr);
                    }
                }

            }
            catch
            {
                RefreshLoadAuthorizationInfoDaTable();
            }
        }
        /// <summary>
        /// 删除缓存中的指定的授权公众号信息
        /// </summary>
        /// <param name="authorizer_Appid"></param>
        public static void DeleteAuthorizationInfoDaTable(string authorizer_Appid)
        {
            try
            {
                //主键检索查询
                DataRow dr = Global.AuthorizationInfoDaTable.Rows.Find(authorizer_Appid);
                lock (Global.AuthorizationInfoDaTable)
                {

                    if (dr != null)
                    {
                        Global.AuthorizationInfoDaTable.Rows.Remove(dr);
                    }
                }
            }
            catch { }
        }
        static DataTable custDaTable = new DataTable();
        /// <summary>
        /// 利亚方舟中转服务器的Token
        /// </summary>
        public const string lyfzToken = "lyfz.net";
        public static string NetIPUrl = "http://1111.ip138.com/ic.asp";
        public static string CloudSelectionUrl = "121.42.170.207";
        /// <summary>
        /// 客户列表
        /// </summary>
        public static DataTable CustDaTable
        {
            get { return Global.custDaTable; }
            set { Global.custDaTable = value; }
        }
        /// <summary>
        /// 刷新加载客户信息
        /// </summary>
        public static void RefreshLoadCustDaTable()
        {
            try
            {
                RefreshLoadKeywordDaTable();
            }
            catch { }

            Global.InitializationMicroLetterEventList();
            DataSet ds = CusDal.GetAllList();
            lock (Global.custDaTable)
            {
                try
                {
                    Global.custDaTable.Rows.Clear();
                    Global.custDaTable.Dispose();

                }
                catch
                {
                }
                Global.custDaTable = ds.Tables[0];
                Global.custDaTable.PrimaryKey = new DataColumn[] { Global.custDaTable.Columns["JMGDomainName"] };
            }
        }

        /// <summary>
        /// 更新缓存中的客户CallFrequency
        /// </summary>
        /// <param name="JMGDomainName"></param>
        public static void UpdateCustCallFrequency(string JMGDomainName)
        {


            try
            {
                lock (Global.custDaTable)
                {
                    //主键检索查询
                    DataRow dr = Global.custDaTable.Rows.Find(JMGDomainName);
                    if (dr != null)
                    {
                        long newCallFrequency = Convert.ToInt64(dr["CallFrequency"].ToString()) + 1;
                        dr["CallFrequency"] = newCallFrequency;
                        if (newCallFrequency % 30 == 0 || newCallFrequency <= 20)
                        {
                            CusDal.UpdateCustCallFrequency(JMGDomainName, newCallFrequency);
                        }
                    }
                }

            }
            catch { RefreshLoadCustDaTable(); }
        }

        /// <summary>
        /// 更新缓存中的客户信息
        /// </summary>
        /// <param name="JMGDomainName"></param>
        /// <param name="cusModel"></param>
        public static void UpdateCustInfo(string JMGDomainName, LYFZ.WeixinServiceDate.Model.Model_CustomerInterfaces cusModel)
        {

            try
            {

                //主键检索查询
                DataRow dr = Global.custDaTable.Rows.Find(JMGDomainName);
                lock (Global.custDaTable)
                {
                    if (dr != null)
                    {
                        dr["ShellDomainName"] = cusModel.ShellDomainName;
                        dr["IPAddress"] = cusModel.IPAddress;
                        dr["PortNumber"] = cusModel.PortNumber;
                        dr["UseType"] = cusModel.UseType;
                        dr["RefreshTime"] = cusModel.RefreshTime;
                        dr["ISEnabled"] = cusModel.ISEnabled;
                        dr["CompanyName"] = cusModel.CompanyName;
                        dr["ThirdPartyPlatformURL"] = cusModel.ThirdPartyPlatformURL;
                        dr["Token"] = cusModel.Token;
                        dr["AppID"] = cusModel.AppID;
                        dr["AppSecret"] = cusModel.AppSecret;
                        dr["AppSecret"] = cusModel.AppSecret;
                        dr["EncodingAESKey"] = cusModel.EncodingAESKey;
                    }
                    else
                    {
                        dr = Global.custDaTable.NewRow();
                        dr["ID"] = cusModel.ID;
                        dr["JMGDomainName"] = cusModel.JMGDomainName;
                        dr["ShellDomainName"] = cusModel.ShellDomainName;
                        dr["IPAddress"] = cusModel.IPAddress;
                        dr["PortNumber"] = cusModel.PortNumber;
                        dr["UseType"] = cusModel.UseType;
                        dr["RefreshTime"] = cusModel.RefreshTime;
                        dr["CreateTime"] = cusModel.CreateTime;
                        dr["ISEnabled"] = cusModel.ISEnabled;
                        dr["CompanyName"] = cusModel.CompanyName;
                        dr["CallFrequency"] = cusModel.CallFrequency;
                        dr["ThirdPartyPlatformURL"] = cusModel.ThirdPartyPlatformURL;
                        dr["Token"] = cusModel.Token;
                        dr["AppID"] = cusModel.AppID;
                        dr["AppSecret"] = cusModel.AppSecret;
                        dr["AppSecret"] = cusModel.AppSecret;
                        dr["EncodingAESKey"] = cusModel.EncodingAESKey;

                        Global.custDaTable.Rows.Add(dr);
                    }
                }

            }
            catch
            {
                RefreshLoadCustDaTable();
            }
        }
        /// <summary>
        /// 删除缓存中的指定的客户信息
        /// </summary>
        /// <param name="JMGDomainName"></param>
        public static void DeleteCustInfo(string JMGDomainName)
        {
            try
            {
                //主键检索查询
                DataRow dr = Global.custDaTable.Rows.Find(JMGDomainName);
                lock (Global.custDaTable)
                {

                    if (dr != null)
                    {
                        Global.custDaTable.Rows.Remove(dr);
                    }
                }
            }
            catch { }
        }

        /// <summary>
        /// 获取客户信息
        /// </summary>
        /// <param name="JMGDomainName"></param>
        /// <returns></returns>
        public static DataRow GetCustomerDataRow(string JMGDomainName)
        {
            //主键检索查询
            DataRow row = null;

            try
            {
                lock (Global.custDaTable)
                {
                    row = Global.custDaTable.Rows.Find(JMGDomainName);
                }
            }
            catch { RefreshLoadCustDaTable(); }
            return row;
        }
        /// <summary>
        /// 获取客户信息
        /// </summary>
        /// <param name="JMGDomainName"></param>
        /// <returns></returns>
        public static LYFZ.WeixinServiceDate.Model.Model_CustomerInterfaces GetCustomerModel(string JMGDomainName)
        {
            LYFZ.WeixinServiceDate.Model.Model_CustomerInterfaces custModel = new LYFZ.WeixinServiceDate.Model.Model_CustomerInterfaces();
            DataRow row = Global.GetCustomerDataRow(JMGDomainName);
            if (row != null)
            {
                custModel = CusDal.DataRowToModel(row);
            }
            return custModel;
        }

        /// <summary>
        /// 获取客户信息
        /// </summary>
        /// <param name="JMGDomainName"></param>
        /// <returns></returns>
        public static LYFZ.WeixinServiceDate.Model.Model_CustomerInterfaces GetCustomerModelByWxAppId(string wxAppid)
        {
            LYFZ.WeixinServiceDate.Model.Model_CustomerInterfaces custModel = new LYFZ.WeixinServiceDate.Model.Model_CustomerInterfaces();
            DataRow row = Global.GetCustomerDataRowByWxAppId(wxAppid);
            if (row != null)
            {
                custModel = CusDal.DataRowToModel(row);
            }
            return custModel;
        }

        private static DataRow GetCustomerDataRowByWxAppId(string wxAppid)
        {
            DataRow row = null;

            lock (Global.custDaTable)
            {
                DataRow[] rows = Global.custDaTable.Select(" AppID = '" + wxAppid + "' ");
                if (rows.Length > 0)
                {
                    row = rows[0];
                }
            }
            if (row == null)
            {
                RefreshLoadCustDaTable();
            }
            return row;
        }

        /// <summary>
        /// 获取客户信息
        /// </summary>
        /// <param name="JMGDomainName"></param>
        /// <returns></returns>
        public static LYFZ.WeixinServiceDate.Model.Model_CustomerInterfaces GetCustomerModelById(string id)
        {
            LYFZ.WeixinServiceDate.Model.Model_CustomerInterfaces custModel = new LYFZ.WeixinServiceDate.Model.Model_CustomerInterfaces();
            DataRow row = Global.GetCustomerDataRowById(id);
            if (row != null)
            {
                custModel = CusDal.DataRowToModel(row);
            }
            return custModel;
        }

        private static DataRow GetCustomerDataRowById(string id)
        {
            DataRow row = null;

            lock (Global.custDaTable)
            {
                DataRow[] rows = Global.custDaTable.Select(" ID = '" + id + "' ");
                if (rows.Length > 0)
                {
                    row = rows[0];
                }
            }
            if (row == null)
            {
                RefreshLoadCustDaTable();
            }
            return row;
        }

        static DataTable _FunctionListDaTable = new DataTable();
        /// <summary>
        /// 功能模块列表
        /// </summary>
        public static DataTable FunctionListDaTable
        {
            get { return Global._FunctionListDaTable; }
            set { Global._FunctionListDaTable = value; }
        }

        /// <summary>
        /// 更新缓存中的功能模块列表
        /// </summary>
        /// <param name="FunctionCode"></param>
        /// <param name="fModel"></param>
        public static void UpdateFunctionList(string FunctionCode, LYFZ.WeixinServiceDate.Model.Model_FunctionList fModel)
        {

            try
            {
                lock (Global._FunctionListDaTable)
                {
                    //主键检索查询
                    DataRow dr = Global._FunctionListDaTable.Rows.Find(FunctionCode);
                    if (dr != null)
                    {
                        dr["FunctionName"] = fModel.FunctionName;
                        dr["FunctionCode"] = fModel.FunctionCode;

                    }
                    else
                    {
                        dr = Global._FunctionListDaTable.NewRow();
                        dr["ID"] = fModel.ID;
                        dr["FunctionName"] = fModel.FunctionName;
                        dr["FunctionCode"] = fModel.FunctionCode;
                        dr["CreateTime"] = fModel.CreateTime;
                        Global._FunctionListDaTable.Rows.Add(dr);
                    }
                }

            }
            catch { }
        }
        public static void delFunctionList(string FunctionCode)
        {
            lock (Global._FunctionListDaTable)
            {
                DataRow dr = Global._FunctionListDaTable.Rows.Find(FunctionCode);
                if (dr != null)
                {
                    Global._FunctionListDaTable.Rows.Remove(dr);
                }
            }
        }

        static DataTable _KeywordDaTable = new DataTable();
        /// <summary>
        /// 关键字集合
        /// </summary>
        public static DataTable KeywordDaTable
        {
            get { return Global._KeywordDaTable; }
            set { Global._KeywordDaTable = value; }
        }

        /// <summary>
        /// 更新缓存中的关键字
        /// </summary>
        /// <param name="Keyword"></param>
        /// <param name="kModel"></param>
        public static void UpdateKeyword(string Keyword, LYFZ.WeixinServiceDate.Model.Model_KeywordManagement kModel, string modatype = "")
        {

            try
            {
                lock (Global._KeywordDaTable)
                {
                    //主键检索查询
                    DataRow dr = Global._KeywordDaTable.Rows.Find(Keyword);

                    if (dr != null || modatype == "edit")
                    {
                        if (dr == null)
                        {
                            foreach (DataRow row in Global._KeywordDaTable.Rows)
                            {
                                if (row["id"].ToString() == kModel.ID.ToString())
                                {
                                    dr = row;
                                    break;
                                }
                            }
                        }
                        if (dr != null)
                        {
                            dr["Keyword"] = kModel.Keyword;
                            dr["FunctionCode"] = kModel.FunctionCode;
                            dr["IsEnabled"] = kModel.IsEnabled;
                            dr["CreateTime"] = kModel.CreateTime;
                        }
                    }
                    else
                    {
                        dr = Global._KeywordDaTable.NewRow();
                        dr["ID"] = kModel.ID;
                        dr["Keyword"] = kModel.Keyword;
                        dr["FunctionCode"] = kModel.FunctionCode;
                        dr["IsEnabled"] = kModel.IsEnabled;
                        dr["CreateTime"] = kModel.CreateTime;
                        Global._KeywordDaTable.Rows.Add(dr);
                    }
                    Global.InitializationMicroLetterEventList();
                }
            }
            catch { }
        }

        public static void delKeyword(string Keyword)
        {
            lock (Global._KeywordDaTable)
            {
                DataRow dr = Global._KeywordDaTable.Rows.Find(Keyword);
                if (dr != null)
                {
                    Global._KeywordDaTable.Rows.Remove(dr);
                }
            }
        }

        static LYFZ.WeixinServiceDate.DAL.DAL_FunctionList funDal = new WeixinServiceDate.DAL.DAL_FunctionList();
        static LYFZ.WeixinServiceDate.DAL.DAL_KeywordManagement keyDal = new WeixinServiceDate.DAL.DAL_KeywordManagement();
        /// <summary>
        /// 刷新加载关键字
        /// </summary>
        public static void RefreshLoadKeywordDaTable()
        {
            lock (Global._FunctionListDaTable)
            {
                DataSet fds = funDal.GetAllList();
                Global._FunctionListDaTable.Rows.Clear();
                Global._FunctionListDaTable.Dispose();
                Global._FunctionListDaTable = fds.Tables[0];
                Global._FunctionListDaTable.PrimaryKey = new DataColumn[] { Global._FunctionListDaTable.Columns["FunctionCode"] };
                DataSet kds = keyDal.GetAllList(" FunctionCode,id");
                Global._KeywordDaTable.Rows.Clear();
                Global._KeywordDaTable.Dispose();
                Global._KeywordDaTable = null;
                Global._KeywordDaTable = kds.Tables[0];
                Global._KeywordDaTable.PrimaryKey = new DataColumn[] { Global._KeywordDaTable.Columns["Keyword"] };
            }
        }

        private static List<string> _LogsDongleDomainList = new List<string>();
        /// <summary>
        /// 调试日志加密锁域名列表
        /// </summary>
        public static List<string> LogsDongleDomainList
        {
            get { return Global._LogsDongleDomainList; }
            set { Global._LogsDongleDomainList = value; }
        }

        LYFZ.WeixinServiceDate.DAL.DAL_FunctionList functionDAL = new WeixinServiceDate.DAL.DAL_FunctionList();
        LYFZ.WeixinServiceDate.DAL.DAL_KeywordManagement keywordDAL = new WeixinServiceDate.DAL.DAL_KeywordManagement();

        /// <summary>
        /// 初始化微信事件列表
        /// </summary>
        public static void InitializationMicroLetterEventList()
        {
            lock (LYFZ.WXLibrary.CommonHandleClass.MicroLetterEventList)
            {
                LYFZ.WXLibrary.CommonHandleClass.MicroLetterEventList.Clear();
                LYFZ.WXLibrary.CommonHandleClass.KeywordObjectsList.Clear();
                foreach (DataRow row in Global._KeywordDaTable.Rows)
                {
                    LYFZ.WXLibrary.CommonHandleClass.MicroLetterEventList.Add(row["Keyword"].ToString().ToLower());
                    LYFZ.WXLibrary.CommonHandleClass.KeywordObjectsList.Add(new KeywordObjects(row));
                }
            }
        }

        static LYFZ.WeixinServiceDate.DAL.DAL_DZKJ_CustomerAccount DZKJ_Dal = new WeixinServiceDate.DAL.DAL_DZKJ_CustomerAccount();

        static DataTable _DZKJ_CustomerAccountDataTable = new DataTable();


        #endregion
    }
}