//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
    {

        /// <summary>
        /// 执行增、删、改存储过程
        /// </summary>
        /// <param name="procedureName"></param>
        /// <param name="paramData"></param>
        /// <param name="errorMessage"></param>
        /// <returns></returns>
        public static bool ExecuteStoredProcedure_Bakup(string procedureName, ref SqlParameter[] thisParms, out string errorMessage)
        {
            return SQLCommon.ExecuteStoredProcedure(procedureName, connectionStringBakup, ref thisParms, out errorMessage);
        }

        /// <summary>
        /// 调数据库数据，并返回结果
        /// </summary>
        /// <param name="type"></param>
        /// <param name="jsonData"></param>
        /// <param name="dataobj"></param>
        /// <returns></returns>
        public static string SqlWebCall_Bakup(int type, JsonData jsonData, jsonobj dataobj)
        {
            string result = "";
            string resultReg = "";
            if (!InitSystemReg(out resultReg))
            {
                return resultReg;
            }

            switch (type)
            {
                case 1001:
                    result = ExecuteInsertMesWork_Bakup(jsonData);
                    break;
                case 1002:
                    result = ExecuteSelectMesWork_Bakup(jsonData);
                    break;
                case 1:
                    result = ExePROCEDURE_Type1_Bakup(dataobj);
                    break;
                case 2:
                    result = ExePROCEDURE_Type2_Bakup(dataobj);
                    break;
                case 3:
                    result = ExePROCEDURE_Type3_Bakup(dataobj);
                    break;
                case 4:
                    result = ExePROCEDURE_Type4_Bakup(dataobj);
                    break;
                case 5:
                    result = ExePROCEDURE_Type5_Bakup(dataobj);
                    break;
                case 6:
                    break;
                case 7:
                    result = ExePROCEDURE_Type7_Bakup(jsonData);
                    break;
                case 8:
                    break;
                case 9:
                    break;
                case 10:
                    break;
                case 11:
                    result = ExePROCEDURE_Type11_Bakup(jsonData);
                    break;
                case 12:
                    result = ExePROCEDURE_Type12_Bakup(jsonData);
                    break;
                case 13://返回dataset json
                    result = ExePROCEDURE_Type13_Bakup(jsonData);
                    break;
            }
            return result;
        }
    }
}