554 lines
18 KiB
C#
554 lines
18 KiB
C#
//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 [_日志_增加]
|
|
///@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;
|
|
}
|
|
|
|
}
|
|
}
|