//using BasicData;
//using BizDataAccess;
//using LitJson;
using BasicData;
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.IO;
using System.Linq;
using System.Runtime.Serialization.Json;
using System.Text;
using System.Text.RegularExpressions;
using System.Threading.Tasks;
using System.Web.Script.Serialization;

namespace DataLinkMesWork
{
    /// <summary>
    /// 
    /// </summary>
    
    public partial class DataLink
    {
      
        private static bool InitSystemReg(out string resultReg)
        {
            resultReg = "[{ \"result\":\"" + "请注册系统，注册号：" + "\"}]";

            if (!initSystemIsOk)
            {
                string SerialNumberStr;
                if (InitSystem(out SerialNumberStr))
                {
                    connectionString = System.Configuration.ConfigurationManager.AppSettings["ConnectionString"];
                    connectionStringBakup = System.Configuration.ConfigurationManager.AppSettings["ConnectionStringBakup"];
                    isBakup = System.Configuration.ConfigurationManager.AppSettings["IsBakup"];
                    initSystemIsOk = true;
                    return true;
                }
                else
                {
                    resultReg = "[{ \"result\":\"" + "请注册系统，注册号：" + SerialNumberStr + "\"}]";
                    return false;
                }
            }else
            {
                return true;
            }
        }
        /// <summary>
        /// 调数据库数据，并返回结果
        /// </summary>
        /// <param name="type"></param>
        /// <param name="jsonData"></param>
        /// <param name="dataobj"></param>
        /// <returns></returns>
        public static string SqlWebCall(int type, JsonData jsonData, jsonobj dataobj)
        {
            string result = "";
            string resultReg = "";
            if (!InitSystemReg(out resultReg))
            {
                return resultReg;
            }

            switch (type)
            {
                case 1001:
                    result = ExecuteInsertMesWork(jsonData);
                    break;
                case 1002:
                    result = ExecuteSelectMesWork(jsonData);
                    break;
                case 1:
                    result = ExePROCEDURE_Type1(dataobj);
                    break;
                case 2:
                    result = ExePROCEDURE_Type2(dataobj);
                    break;
                case 3:
                    result = ExePROCEDURE_Type3(dataobj);
                    break;
                case 4:
                    result = ExePROCEDURE_Type4(dataobj);
                    break;
                case 5:
                    result = ExePROCEDURE_Type5(dataobj);
                    break;
                case 6:
                    break;
                case 7:
                    result = ExePROCEDURE_Type7(jsonData);
                    break;
                case 8:
                    break;
                case 9:
                    break;
                case 10:
                    break;
                case 11:
                    result = ExePROCEDURE_Type11(jsonData);
                    break;
                case 12:
                    result = ExePROCEDURE_Type12(jsonData);
                    break;
                case 13://返回dataset json
                    result = ExePROCEDURE_Type13(jsonData);
                    break;
            }
            return result;
        }

        public static string SqlWebCall(string connType,int type, JsonData jsonData, jsonobj dataobj)
        {
            string result = "";
            string resultReg = "";
            if (!InitSystemReg(out resultReg))
            {
                return resultReg;
            }

            switch (type)
            {
                case 1001:
                    result = ExecuteInsertMesWork(connType,jsonData);
                    break;
                case 1002:
                    result = ExecuteSelectMesWork(connType,jsonData);
                    break;
                case 1:
                    result = ExePROCEDURE_Type1(connType,dataobj);
                    break;
                case 2:
                    result = ExePROCEDURE_Type2(connType,dataobj);
                    break;
                case 3:
                    result = ExePROCEDURE_Type3(connType,dataobj);
                    break;
                case 4:
                    result = ExePROCEDURE_Type4(connType,dataobj);
                    break;
                case 5:
                    result = ExePROCEDURE_Type5(connType,dataobj);
                    break;
                case 6:
                    break;
                case 7:
                    result = ExePROCEDURE_Type7(connType,jsonData);
                    break;
                case 8:
                    break;
                case 9:
                    break;
                case 10:
                    break;
                case 11:
                    result = ExePROCEDURE_Type11(connType,jsonData);
                    break;
                case 12:
                    result = ExePROCEDURE_Type12(connType,jsonData);
                    break;
                case 13://返回dataset json
                    result = ExePROCEDURE_Type13(connType,jsonData);
                    break;
            }
            return result;
        }
        /// <summary>
        ///   "UserID": $("#UserID").val(),
        ///    "Type": $("#TYPE").val(),
        ///    "ModularID": $("#ModularID").val(),
        ///    "Name": $("#NAME").val(),
        ///    "Param": $("#PARAM1value").val(),
        ///    "Pagination": $("#Pagination").val(),
        ///    HasReturn: $("#HASRETURN").get(0).checked
        /// </summary>
        /// <param name="json"></param>
        public static void LogJsonData(JsonData json)
        {
            string type=null;
            string name = null;
            string param = null;
            string userID = null;
            string pagination = null;
            bool   hasReturn = false;
            string modularID = "";
            GetString_JsonData( json, out  type, out  name, out  param, out  userID,out pagination,out hasReturn,out  modularID);

            LogInsert(type, name, param, userID, modularID);
        }
        /// <summary>
        ///    "UserID": $("#UserID").val(),
        ///    "ModularID": $("#ModularID").val(), 子组件
        ///    "Type": $("#TYPE").val(),
        ///    "Name": $("#NAME").val(),
        ///    "Param": $("#PARAM1value").val(),
        ///    "Pagination": $("#Pagination").val(),
        ///    HasReturn: $("#HASRETURN").get(0).checked
        /// </summary>
        /// <param name="json"></param>
        /// <param name="type"></param>
        /// <param name="name"></param>
        /// <param name="param"></param>
        /// <param name="userID"></param>
        /// <param name="pagination"></param>
        /// <param name="hasReturn"></param>
        /// <param name="modularID">子组件</param>
        public static void GetString_JsonData(JsonData json, out string type,out string name,out string param,out string userID,out string pagination,out bool hasReturn,out string modularID)
        {
            type = null;
            name = null;
            param = "";
            userID = null;
            pagination=null;
            hasReturn=false;
            modularID = "";
            if (json == null) return;
            if (json.Keys.Contains("Type"))
            {
                if (json["Type"] != null)
                    type = json["Type"].ToString();
            }
            else if (json.Keys.Contains("type"))
            {
                if (json["type"] != null)
                    type = json["type"].ToString();
            }

            if (json.Keys.Contains("Name"))
            {
                if (json["Name"] != null)
                    name = json["Name"].ToString();
            }
            else if (json.Keys.Contains("name"))
            {
                if (json["name"] != null)
                    name = json["name"].ToString();
            }


            if (json.Keys.Contains("Param"))
            {
                if (json["Param"] != null)
                    param = json["Param"].ToString();
            }
            else if (json.Keys.Contains("param"))
            {
                if (json["param"] != null)
                    param = json["param"].ToString();
            }


            if (json.Keys.Contains("UserID"))
            {
                if (json["UserID"] != null)
                    userID = json["UserID"].ToString();
            }
            else if (json.Keys.Contains("userID"))
            {
                if (json["userID"] != null)
                    userID = json["userID"].ToString();
            }

            if (json.Keys.Contains("Pagination"))
            {
                if (json["Pagination"] != null)
                    pagination = json["Pagination"].ToString();
            }
            else if (json.Keys.Contains("pagination"))
            {
                if (json["pagination"] != null)
                    pagination = json["pagination"].ToString();
            }

            if (json.Keys.Contains("HasReturn"))
            {
                try
                {
                    if (json["HasReturn"] != null)
                        hasReturn = Convert.ToBoolean(json["HasReturn"].ToString());
                }
                catch
                {

                }
            }
            else if (json.Keys.Contains("hasReturn"))
            {
                try
                {
                    if (json["hasReturn"] != null)
                        hasReturn = Convert.ToBoolean(json["hasReturn"].ToString());
                }
                catch
                {

                }
            }


            if (json.Keys.Contains("ModularID"))
            {
                try
                {
                    if (json["ModularID"] != null)
                        modularID = json["ModularID"].ToString();
                }
                catch
                {

                }
            } 
            else if (json.Keys.Contains("modularID"))
            {
                try
                {
                    if (json["modularID"] != null)
                        modularID = json["modularID"].ToString();
                }
                catch
                {

                }
            }
            //ModularID
        }

        /// <summary>
        ///    "UserID": $("#UserID").val(),
        ///    "ModularID": $("#ModularID").val(), 子组件
        ///    "Type": $("#TYPE").val(),
        ///    "Name": $("#NAME").val(),
        ///    "Param": $("#PARAM1value").val(),
        ///    "Pagination": $("#Pagination").val(),
        ///    HasReturn: $("#HASRETURN").get(0).checked
        /// </summary>
        /// <param name="json"></param>
        /// <param name="type"></param>
        /// <param name="name"></param>
        /// <param name="param"></param>
        /// <param name="userID"></param>
        /// <param name="pagination"></param>
        /// <param name="hasReturn"></param>
        /// <param name="modularID">子组件</param>
        public static void GetString_JsonData_Type7(JsonData json, out string type, out string name, out JsonData param, out string userID, out string pagination, out bool hasReturn, out string modularID)
        {
            type = null;
            name = null;
            param = null;
            userID = null;
            pagination = null;
            hasReturn = false;
            modularID = "";
            if (json.Keys.Contains("Type"))
            {
                if (json["Type"] != null)
                    type = json["Type"].ToString();
            }
            else if (json.Keys.Contains("type"))
            {
                if (json["type"] != null)
                    type = json["type"].ToString();
            }

            if (json.Keys.Contains("Name"))
            {
                if (json["Name"] != null)
                    name = json["Name"].ToString();
            }
            else if (json.Keys.Contains("name"))
            {
                if (json["name"] != null)
                    name = json["name"].ToString();
            }


            if (json.Keys.Contains("Param"))
            {
                if (json["Param"] != null)
                    param = json["Param"];
            }
            else if (json.Keys.Contains("param"))
            {
                if (json["param"] != null)
                    param = json["param"];
            }


            if (json.Keys.Contains("UserID"))
            {
                if (json["UserID"] != null)
                    userID = json["UserID"].ToString();
            }
            else if (json.Keys.Contains("userID"))
            {
                if (json["userID"] != null)
                    userID = json["userID"].ToString();
            }

            if (json.Keys.Contains("Pagination"))
            {
                if (json["Pagination"] != null)
                    pagination = json["Pagination"].ToString();
            }
            else if (json.Keys.Contains("pagination"))
            {
                if (json["pagination"] != null)
                    pagination = json["pagination"].ToString();
            }

            if (json.Keys.Contains("HasReturn"))
            {
                try
                {
                    if (json["HasReturn"] != null)
                        hasReturn = Convert.ToBoolean(json["HasReturn"].ToString());
                }
                catch
                {

                }
            }
            else if (json.Keys.Contains("hasReturn"))
            {
                try
                {
                    if (json["hasReturn"] != null)
                        hasReturn = Convert.ToBoolean(json["hasReturn"].ToString());
                }
                catch
                {

                }
            }


            if (json.Keys.Contains("ModularID"))
            {
                try
                {
                    if (json["ModularID"] != null)
                        modularID = json["ModularID"].ToString();
                }
                catch
                {

                }
            }
            else if (json.Keys.Contains("modularID"))
            {
                try
                {
                    if (json["modularID"] != null)
                        modularID = json["modularID"].ToString();
                }
                catch
                {

                }
            }
            //ModularID
        }


        /// <summary>
        /// ALTER   PROCEDURE [dbo].[_日志_增加]
        ///@UserID nvarchar(50)=null,
        ///@子组件 nvarchar(50)=null,--vue 变量 ModularID
        ///@TypeID nvarchar(50)=null,
        ///@名称 nvarchar(200)=null,
        ///@参数 nvarchar(max)=null
        /// </summary>
        /// <param name="type">TypeID</param>
        /// <param name="name">名称</param>
        /// <param name="param">参数</param>
        /// <param name="userID">UserID</param>
        /// <param name="modularID">子组件</param>
        public static void LogInsert(string type,string name,string param,string userID,string modularID)
        {

            string errorMessage;
            string procedureName;
            ParamData[] paramData;
            paramData = new ParamData[5];
            procedureName = "_日志_增加";
            paramData[0].name = "UserID";
            paramData[0].value = userID;
            paramData[1].name = "TypeID";
            paramData[1].value = type;
            paramData[2].name = "名称";
            paramData[2].value = name;
            paramData[3].name = "参数";
            paramData[3].value = param;
            paramData[4].name = "子组件";
            paramData[4].value = modularID;
            if (InitSystem())
            {
                ExecuteStoredProcedure(procedureName, ref paramData, out errorMessage);
            }
            else
            {
                LogInsertErr(type, name, param, userID, modularID);
            }
        }


        private static void LogInsertErr(string type, string name, string param, string userID, string modularID)
        {
            
            string errorMessage;
            string procedureName;
            ParamData[] paramData;
            paramData = new ParamData[5];
            procedureName = "_日志_增加";
            paramData[0].name = "UserID";
            paramData[0].value = userID;
            paramData[1].name = "TypeID";
            paramData[1].value = type;
            paramData[2].name = "名称";
            paramData[2].value = name;
            paramData[3].name = "参数";
            paramData[3].value = param+"----登录失败";
            paramData[4].name = "子组件";
            paramData[4].value = modularID;

            string connectionStringTemp = System.Configuration.ConfigurationManager.AppSettings["ConnectionString"];
            ExecuteStoredProcedureWithConnectionString(procedureName, ref paramData, out errorMessage, connectionStringTemp);

            //procedureName = "_日志_增加";
            //paramData[0].name = "UserID";
            //paramData[0].value = userID;
            //paramData[1].name = "TypeID";
            //paramData[1].value = type;
            //paramData[2].name = "名称";
            //paramData[2].value = name;
            //paramData[3].name = "参数";
            //paramData[3].value = param + "--登录失败";
            //ExecuteStoredProcedureWithConnectionString(procedureName, ref paramData, out errorMessage, connectionStringTemp);
        }

        public  static bool InitSystem()
        {
            if (!InitSystemIsOk)
            {
                string linkMessage;
                InitSystem(out linkMessage);
            }
            return InitSystemIsOk;
        }

    }
}