public object ExecuteScalar(BaseQuery q)
{
string message = "SQL语句:" + q.CommandText + ";Parameters:{";
if (q.Parameters != null)
{
for (int i = 0; i < q.Parameters.Count; i++)
{
message += "\"" + q.Parameters[i].ParameterName + "\"" + ":";
message += "\"" + q.Parameters[i].Value + "\"" + ";";
}
}
message += "}";
try
{
LogService.Default.Info(message);
IDbCommand sqlCommand = DbProvider.GetDbCommand(this.dbtype);
this.PrepareCommand(sqlCommand, q);
object result = sqlCommand.ExecuteScalar();
this.SyncParameter(sqlCommand, q);
sqlCommand.Parameters.Clear();
return(result);
}
catch (Exception e)
{
LogService.Default.Fatal(e);
LogService.Default.Fatal((message + "\n" + Assembly.GetExecutingAssembly().Location.ToLower()));
throw e;
}
}
public DataSet ExecuteDataset(BaseQuery q)
{
string message = "SQL语句:" + q.CommandText + ";Parameters:{";
if (q.Parameters != null)
{
for (int i = 0; i < q.Parameters.Count; i++)
{
message += "\"" + q.Parameters[i].ParameterName + "\"" + ":";
message += "\"" + q.Parameters[i].Value + "\"" + ";";
}
}
message += "}";
try
{
LogService.Default.Info(message);
DataSet dataSet = new DataSet();
IDbCommand sqlCommand = DbProvider.GetDbCommand(this.dbtype);
this.PrepareCommand(sqlCommand, q);
IDbDataAdapter sqlDataAdapter = DbProvider.GetDbDataAdapter(dbtype, sqlCommand);
sqlDataAdapter.Fill(dataSet);
this.SyncParameter(sqlCommand, q);
sqlCommand.Parameters.Clear();
return(dataSet);
}
catch (Exception e)
{
LogService.Default.Fatal(message + "\n" + Assembly.GetExecutingAssembly().Location.ToLower());
LogService.Default.Fatal(e);
throw e;
}
}
public XmlReader ExecuteXmlReader(BaseQuery q)
{
SqlCommand sqlCommand = (SqlCommand)DbProvider.GetDbCommand(this.dbtype);
this.PrepareCommand(sqlCommand, q);
XmlReader result = sqlCommand.ExecuteXmlReader();
this.SyncParameter(sqlCommand, q);
sqlCommand.Parameters.Clear();
return(result);
}
