public static int ExecuteCommand(SQLCommandInfo sqlCommand, SDTableType tableType)
{
var clientInfo = EFClientTools.ClientUtility.ClientInfo;
var sqlCommands = new List<SQLCommandInfo>();
sqlCommands.Add(sqlCommand);
return EFClientTools.ClientUtility.Client.SDExcuteCommands(clientInfo, sqlCommands, tableType);
}
public static DataSet ExecuteSql(SQLCommandInfo sqlCommand, PacketInfo packetInfo, SDTableType tableType)
{
var clientInfo = EFClientTools.ClientUtility.ClientInfo;
var xml = (string)EFClientTools.ClientUtility.Client.SDExcuteSql(clientInfo, sqlCommand, packetInfo, tableType);
return Deserialize(xml);
}
public static DataSet ExecuteSql(string commandText, PacketInfo packetInfo, SDTableType tableType)
{
return ExecuteSql(new SQLCommandInfo() { CommandText = commandText }, packetInfo, tableType);
}
public static DataSet ExecuteSql(SQLCommandInfo sqlCommand, SDTableType tableType)
{
return ExecuteSql(sqlCommand, new PacketInfo() { WhereParameters = new List<WhereParameter>(), OrderParameters = new List<OrderParameter>() }, tableType);
}
public static DataSet ExecuteSchema(string commandText, SDTableType tableType)
{
return ExecuteSql(new SQLCommandInfo() { CommandText = commandText }, new PacketInfo() { WhereParameters = new List<WhereParameter>(), OrderParameters = new List<OrderParameter>(), OnlySchema = true }, tableType);
}
public static int ExecuteCommands(List<SQLCommandInfo> sqlCommands, SDTableType tableType)
{
var clientInfo = EFClientTools.ClientUtility.ClientInfo;
return EFClientTools.ClientUtility.Client.SDExcuteCommands(clientInfo, sqlCommands, tableType);
}
public static int ExecuteCommand(string commandText, SDTableType tableType)
{
return ExecuteCommand(new SQLCommandInfo() { CommandText = commandText }, tableType);
}
public static void UpdateTable(string tableName, List<UpdateRow> updateRows, SDTableType tableType)
{
var clientInfo = EFClientTools.ClientUtility.ClientInfo;
EFClientTools.ClientUtility.Client.SDUpdateTable(clientInfo, tableName, updateRows, tableType);
}
private string GetSDDatabase(ClientInfo clientInfo, SDTableType tableType)
{
if (tableType == SDTableType.SDSystemTable)
{
return Database.GetSystemDatabase(null);
}
else
{
if (tableType == SDTableType.SystemTable && Database.GetSplitSystemTable(clientInfo.Database, clientInfo.SDDeveloperID))
{
return Database.GetSystemDatabase(clientInfo.SDDeveloperID);
}
return clientInfo.Database;
}
}
public string SDUpdateTable(ClientInfo clientInfo, string tableName, List<UpdateRow> updateRows, SDTableType tableType)
{
if (clientInfo == null)
{
throw new ArgumentNullException("clientInfo");
}
User.CheckUserLogoned(clientInfo);
var database = GetSDDatabase(clientInfo, tableType);
clientInfo.Database = database;
var developerID = tableType == SDTableType.SDSystemTable ? string.Empty : clientInfo.SDDeveloperID;
clientInfo.SDDeveloperID = developerID;
var timeStart = DateTime.Now;
Log.CallMethodLogBegin(clientInfo, timeStart, string.Empty, "ExecuteCommand");
try
{
if (tableName == "SYS_WEBPAGES" && tableType == SDTableType.SDSystemTable)
{
foreach (var updateRow in updateRows)
{
if ((string)updateRow.NewValues["PageType"] == "S")
{
if (updateRow.RowState == DataRowState.Added || updateRow.RowState == DataRowState.Modified)
{
var sComponentCS = (string)updateRow.NewValues["SERVERDLL"];
var resx = string.Empty;
if (updateRow.NewValues.ContainsKey("RESX"))
{
resx = (string)updateRow.NewValues["RESX"];
updateRow.NewValues.Remove("RESX");
}
var assemblyBytes = SDModuleProvider.CreateServerDllAssembly(sComponentCS, (string)updateRow.NewValues["PageName"], resx, clientInfo);
updateRow.NewValues["SERVERDLL"] = assemblyBytes;
if (!updateRow.NewValues.ContainsKey("Content"))
{
updateRow.NewValues["Content"] = System.Text.Encoding.UTF8.GetBytes(SDModuleProvider.GetServerContent(assemblyBytes, sComponentCS));
}
}
}
}
}
var returnObject = Database.UpdateTable(database, tableName, developerID, updateRows);
var timeEnd = DateTime.Now;
Log.CallMethodLogEnd(clientInfo, timeStart, string.Empty, "ExecuteCommand", timeEnd - timeStart);
return returnObject;
}
catch (Exception e)
{
var message = Log.CallMethodLogError(clientInfo, timeStart, string.Empty, "ExecuteCommand", e);
throw new Exception(message, e);
}
}
public string SDExcuteSql(ClientInfo clientInfo, SQLCommandInfo sqlCommand, PacketInfo packetInfo, SDTableType tableType)
{
if (clientInfo == null)
{
throw new ArgumentNullException("clientInfo");
}
User.CheckUserLogoned(clientInfo);
var database = GetSDDatabase(clientInfo, tableType);
clientInfo.Database = database;
var developerID = tableType == SDTableType.SDSystemTable ? string.Empty : clientInfo.SDDeveloperID;
clientInfo.SDDeveloperID = developerID;
var timeStart = DateTime.Now;
Log.CallMethodLogBegin(clientInfo, timeStart, string.Empty, "ExecuteSQL");
try
{
if (!string.IsNullOrEmpty(sqlCommand.CommandText) && sqlCommand.CommandText.IndexOf("SysDatabases", StringComparison.OrdinalIgnoreCase) >= 0)
{
throw new Exception("Invalid object name 'SysDatabases'.");
}
var returnObject = string.Empty;
if (packetInfo.OnlySchema)
{
returnObject = (string)Database.ExecuteSchema(database, developerID, sqlCommand.CommandText);
}
else
{
returnObject = (string)Database.ExecuteSQL(database, developerID, sqlCommand, null, packetInfo);
}
var timeEnd = DateTime.Now;
Log.CallMethodLogEnd(clientInfo, timeStart, string.Empty, "ExecuteSQL", timeEnd - timeStart);
return returnObject;
}
catch (Exception e)
{
var message = Log.CallMethodLogError(clientInfo, timeStart, string.Empty, "ExecuteSQL", e);
throw new Exception(message, e);
}
}
//public int SDExcuteCommand(ClientInfo clientInfo, string commandText, SDTableType tableType, Dictionary<string, object> parameters)
//{
// if (clientInfo == null)
// {
// throw new ArgumentNullException("clientInfo");
// }
// if (string.IsNullOrEmpty(commandText))
// {
// throw new ArgumentNullException("commandText");
// }
// var database = GetSDDatabase(clientInfo, tableType);
// clientInfo.Database = database;
// var developerID = tableType == SDTableType.SDSystemTable ? string.Empty : clientInfo.SDDeveloperID;
// clientInfo.SDDeveloperID = developerID;
// User.CheckUserLogoned(clientInfo);
// var timeStart = DateTime.Now;
// Log.CallMethodLogBegin(clientInfo, timeStart, string.Empty, "ExecuteCommand");
// try
// {
// var returnObject = Database.ExecuteCommand(database, developerID, commandText, parameters);
// var timeEnd = DateTime.Now;
// Log.CallMethodLogEnd(clientInfo, timeStart, string.Empty, "ExecuteCommand", timeEnd - timeStart);
// return returnObject;
// }
// catch (Exception e)
// {
// var message = Log.CallMethodLogError(clientInfo, timeStart, string.Empty, "ExecuteCommand", e);
// throw new Exception(message, e);
// }
//}
public int SDExcuteCommands(ClientInfo clientInfo, List<SQLCommandInfo> sqlCommands, SDTableType tableType)
{
if (clientInfo == null)
{
throw new ArgumentNullException("clientInfo");
}
User.CheckUserLogoned(clientInfo);
var database = GetSDDatabase(clientInfo, tableType);
clientInfo.Database = database;
var developerID = tableType == SDTableType.SDSystemTable ? string.Empty : clientInfo.SDDeveloperID;
clientInfo.SDDeveloperID = developerID;
var timeStart = DateTime.Now;
Log.CallMethodLogBegin(clientInfo, timeStart, string.Empty, "ExecuteCommand");
try
{
var returnObject = Database.ExecuteCommands(database, developerID, sqlCommands);
var timeEnd = DateTime.Now;
Log.CallMethodLogEnd(clientInfo, timeStart, string.Empty, "ExecuteCommand", timeEnd - timeStart);
return returnObject;
}
catch (Exception e)
{
var message = Log.CallMethodLogError(clientInfo, timeStart, string.Empty, "ExecuteCommand", e);
throw new Exception(message, e);
}
}
