102 lines
3.1 KiB
C#
102 lines
3.1 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
|
|
{
|
|
|
|
/// <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;
|
|
}
|
|
}
|
|
}
|