// not caching Command
public DataSet RunQuery(String strQueryCommand)
{
Database db = CurrentDatabase;
if (CurrentDatabase == null)
{
if (DataStructureProvider.IsQuerySystemDB(strQueryCommand))
{
db = DataQueryProvider.SystemDatabase;
}
else
{
db = DataQueryProvider.CompanyDatabase;
}
}
if (DataQueryProvider.IsSQLConnection(db) == false)
{
strQueryCommand = SQLiteDatabaseHelper.RepairSelectSQLite(strQueryCommand);
strQueryCommand = strQueryCommand.Replace("N'", "'");
}
DbCommand cmd = GetQuery(strQueryCommand);
if (cmd == null)
{
return(null);
}
return(RunCommand(cmd));
}
public object RunScript(string strScriptQuery, BusinessObject obj)
{
Database db = CurrentDatabase;
if (CurrentDatabase == null)
{
if (DataStructureProvider.IsQuerySystemDB(strScriptQuery))
{
db = DataQueryProvider.SystemDatabase;
}
else
{
db = DataQueryProvider.CompanyDatabase;
}
}
if (String.IsNullOrWhiteSpace(strScriptQuery))
{
return(null);
}
if (DataQueryProvider.IsSQLConnection(db) == false)
{
strScriptQuery = SQLiteDatabaseHelper.RepairSelectSQLite(strScriptQuery);
}
try
{
DbCommand cmd = GetScriptCommand(strScriptQuery);
AddParameterForObject(obj, cmd);
db.ExecuteNonQuery(cmd);
Guid ret = ABCHelper.DataConverter.ConvertToGuid(db.GetParameterValue(cmd, DataStructureProvider.GetPrimaryKeyColumn(obj.AATableName)));
return(ret);
}
catch (System.Exception ex)
{
ABCHelper.ABCMessageBox.Show(ex.Source + ex.Message, "Database Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return(0);
}
}
public string ExecuteScript(String strScript)
{
Database db = CurrentDatabase;
if (CurrentDatabase == null)
{
if (DataStructureProvider.IsQuerySystemDB(strScript))
{
db = DataQueryProvider.SystemDatabase;
}
else
{
db = DataQueryProvider.CompanyDatabase;
}
}
try
{
if (DataQueryProvider.IsSQLConnection(db) == false)
{
strScript = SQLiteDatabaseHelper.RepairSelectSQLite(strScript);
}
db.ExecuteNonQuery(CommandType.Text, strScript);
return("Command excute succesfully!");
}
catch (System.Exception ex)
{
if (ex is System.Data.SqlClient.SqlException)
{
if (((System.Data.SqlClient.SqlException)ex).ErrorCode == -2146232060 && ex.Message.Contains("TCP Provider"))
{
ShowDisconnectWaitingDialog();
}
}
return(ex.Message);
}
}
// caching Command
public DataSet RunScript(string strScriptQuery)
{
Database db = CurrentDatabase;
if (CurrentDatabase == null)
{
if (DataStructureProvider.IsQuerySystemDB(strScriptQuery))
{
db = DataQueryProvider.SystemDatabase;
}
else
{
db = DataQueryProvider.CompanyDatabase;
}
}
if (String.IsNullOrWhiteSpace(strScriptQuery))
{
return(null);
}
if (DataQueryProvider.IsSQLConnection(db) == false)
{
strScriptQuery = SQLiteDatabaseHelper.RepairSelectSQLite(strScriptQuery);
}
try
{
DbCommand cmd = GetScriptCommand(strScriptQuery);
return(db.ExecuteDataSet(cmd));
}
catch (System.Exception ex)
{
ABCHelper.ABCMessageBox.Show(ex.Message);
return(null);
}
}