public DataTable RunSqlScript(ref Dictionary <string, string> parms, SqlScriptEnum sqlScriptEnum, ref OperationResult op)
{
if (this.DataStore == null)
{
op.AddError("DataStore not set!");
return(null);
}
DataStore ds = this.DataStore;
DataTable dt = ds.ExecuteSql(sqlScriptEnum, parms, ref op);
return(dt);
}
public DataTable ExecuteSql(OleDbConnection conn, SqlScriptEnum sqlScript, Dictionary <string, string> sqlPrmNameValueList,
ref OperationResult op)
{
if (string.IsNullOrEmpty(ConnectionString))
{
op.AddError("The connection string is not set.");
return(null);
}
DataTable dt = new DataTable();
SqlScriptMembers sqlScrptMem = SqlScripts.SqlScriptDict[sqlScript.ToString()];
Dictionary <string, SqlScriptParameter> paramList = sqlScrptMem.Parameters;
string sql = ValidateAndInsertParamList(sqlScrptMem.Sql, ref paramList, ref sqlPrmNameValueList, ref op);
if (!op.Success)
{
return(null);
}
try
{
if (conn.State != ConnectionState.Open)
{
conn.Open();
}
using (OleDbCommand cmd = conn.CreateCommand())
{
cmd.CommandText = sql;
cmd.CommandType = this.CommandType;
dt = new DataTable();
new OleDbDataAdapter(cmd).Fill(dt);
}
return(dt);
}
catch (Exception ex)
{
op.AddException(ex);
}
return(null);
}
public List <T> ExecuteSql <T>(SqlScriptEnum sqlScript, Dictionary <string, string> sqlPrmNameValueList, ref OperationResult op)
{
try
{
DataTable table = ExecuteSql(sqlScript, sqlPrmNameValueList, ref op);
if (!op.Success)
{
return(null);
}
List <T> ts = DataSchemaDataTableUtilities.ConvertTo <T>(table).ToList();
return(ts);
}
catch (Exception ex)
{
op.AddException(ex);
}
return(null);
}
public DataTable ExecuteSql(SqlScriptEnum sqlScript, Dictionary <string, string> sqlPrmNameValueList, ref OperationResult op)
{
DataTable dt = new DataTable();
SqlScriptMembers sqlScrptMem = SqlScripts.SqlScriptDict[sqlScript.ToString()];
Dictionary <string, SqlScriptParameter> paramList = sqlScrptMem.Parameters;
string sql = ValidateAndInsertParamList(sqlScrptMem.Sql, ref paramList, ref sqlPrmNameValueList, ref op);
if (!op.Success)
{
return(null);
}
dt = ExecSql(sql, ref op);
if (!op.Success)
{
return(null);
}
return(dt ?? new DataTable());
}
