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); }