public static int ExecuteNonQuery(BaseQuery q, DatabaseProperty dp)
{
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);
DataAccess sqlDataAccess = new DataAccess(dp.Writer.ConnectionString, dp.Writer.DatabaseType);
sqlDataAccess.Open();
int result = sqlDataAccess.ExecuteNonQuery(q);
sqlDataAccess.Close();
return(result);
}
catch (Exception e)
{
LogService.Default.Fatal(e);
LogService.Default.Fatal((message + "\n" + Assembly.GetExecutingAssembly().Location.ToLower()));
throw e;
}
}
public static XmlReader ExecuteXmlReader(BaseQuery q, DatabaseProperty dp)
{
DataAccess sqlDataAccess = new DataAccess(dp.Reader.ConnectionString, dp.Reader.DatabaseType);
sqlDataAccess.Open();
return(sqlDataAccess.ExecuteXmlReader(q));
}
public static XmlDocument ExecuteXmlDoc(BaseQuery q, DatabaseProperty dp)
{
DataAccess sqlDataAccess = new DataAccess(dp.Reader.ConnectionString, dp.Reader.DatabaseType);
sqlDataAccess.Open();
XmlDocument result = sqlDataAccess.ExecuteXmlDoc(q);
sqlDataAccess.Close();
return(result);
}
public static object ExecuteScalar(BaseQuery q, DatabaseProperty dp, bool isWritable)
{
DataAccess da;
if (isWritable)
{
da = new DataAccess(dp.Writer.ConnectionString, dp.Writer.DatabaseType);
}
else
{
da = new DataAccess(dp.Reader.ConnectionString, dp.Reader.DatabaseType);
}
return(DataAccess.ExecuteScalar(q, da));
}
/// <summary>
/// 供新增的时候使用,新增并且取出Identity
/// </summary>
/// <param name="q"></param>
/// <param name="dp"></param>
/// <returns></returns>
internal static object ExecuteScalarToWriterOnlyForInsertRentrunIdentity(BaseQuery q, DatabaseProperty dp)
{
DataAccess da = new DataAccess(dp.Writer.ConnectionString, dp.Writer.DatabaseType);
return(DataAccess.ExecuteScalar(q, da));
}
public static object ExecuteScalar(BaseQuery q, DatabaseProperty dp)
{
DataAccess da = new DataAccess(dp.Reader.ConnectionString, dp.Reader.DatabaseType);
return(DataAccess.ExecuteScalar(q, da));
}
