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