/// <summary> 事务批量执行，不执行备份
/// </summary>
/// <param name="opName">操作名</param>
/// <param name="sqlStringList">批量sql</param>
/// <returns></returns>
public static bool BatchExeSQLStrMultiByTransNoLogNoBackup(string opName, IList<SysSQLString> sqlStringList)
{
try
{
ReqeFunStruct reqeFunStruct = new ReqeFunStruct();
reqeFunStruct.SubSysName = SubSysName.CommonBaseFuncCall;
reqeFunStruct.FunName = ComFunCallEnum.BatchExeSQLStrMultiByTransNoLogNoBackup;
reqeFunStruct.AccCode = GlobalStaticObj.CurrAccCode;
reqeFunStruct.userIDOP.UserID = GlobalStaticObj.UserID;
reqeFunStruct.userIDOP.OPName = opName;
reqeFunStruct.PCClientCookieStr = GlobalStaticObj.CookieStr;
BatchExeSQLStringMultiByTrans batchExeSQLStringByTrans = new BatchExeSQLStringMultiByTrans();
batchExeSQLStringByTrans.batSQLStringList = sqlStringList;
reqeFunStruct.FunObject = batchExeSQLStringByTrans;
string addStr = HXCCommon.DotNetEncrypt.DESEncrypt.Encrypt(Newtonsoft.Json.JsonConvert.SerializeObject(reqeFunStruct));
if (!WCFClientProxy.TestDataProxy())
{
throw new Exception("未能建立同服务器连接！");
}
string ResultStr = string.Empty;
try
{
ResultStr = GlobalStaticObj.proxy.JsonOperate(addStr);
}
catch (Exception e)
{
return false;
}
string Str = HXCCommon.DotNetEncrypt.DESEncrypt.Decrypt(ResultStr);
RespFunStruct respO = JsonConvert.DeserializeObject<RespFunStruct>(Str);
return respO.ReturnObject == "True";
}
catch (Exception ex)
{
JsonOperateLogService.WriteLog(ex);
return false;
}
}
/// <summary> 事务批量执行（List<string>）
/// 创建人：唐春奎
/// </summary>
/// <param name="opName">操作名</param>
/// <param name="sqlStringList">批量sql</param>
/// <returns></returns>
public static bool BatchExeSQLStringMultiByTrans(string opName, IList<SysSQLString> sqlStringList)
{
try
{
ReqeFunStruct reqeFunStruct = new ReqeFunStruct();
reqeFunStruct.SubSysName = SubSysName.CommonBaseFuncCall;
reqeFunStruct.FunName = ComFunCallEnum.BatchExeSQLStringMultiByTrans;
reqeFunStruct.AccCode = GlobalStaticObj.CurrAccCode;
reqeFunStruct.userIDOP.UserID = GlobalStaticObj.UserID;
reqeFunStruct.userIDOP.OPName = opName;
reqeFunStruct.PCClientCookieStr = GlobalStaticObj.CookieStr;
BatchExeSQLStringMultiByTrans batchExeSQLStringByTrans = new BatchExeSQLStringMultiByTrans();
batchExeSQLStringByTrans.batSQLStringList = sqlStringList;
reqeFunStruct.FunObject = batchExeSQLStringByTrans;
var addStr = HXCCommon.DotNetEncrypt.DESEncrypt.Encrypt(Newtonsoft.Json.JsonConvert.SerializeObject(reqeFunStruct));
var respO = JsonOperate(addStr);
return respO.ReturnObject == "True";
}
catch (Exception ex)
{
JsonOperateLogService.WriteLog(ex);
return false;
}
}
