/// <summary>
/// .ctor
/// </summary>
/// <param name="dbProperty">数据库属性信息</param>
/// <param name="isWrite">是否写连接（默认使用读连接）</param>
public BaseDataAccess(DatabaseProperty dbProperty, bool isWrite = false)
{
EnsureUtil.NotNull(dbProperty, "dbProperty不能为空!");
DatabaseConnection dbConnection = isWrite ? dbProperty.Writer : dbProperty.Reader;
_conn = CreateConnection(dbConnection);
}
public static PropertyBase PropertyBase(DatabaseProperty propertyMetadata)
{
return(new PropertyBase()
{
Name = propertyMetadata.Name,
Type = TypeBase(propertyMetadata.Type)
});
}
public string GetChildDeclareId(DatabaseProperty property, string parameterName)
{
StringBuilder stringbuilder = new StringBuilder();
stringbuilder.AppendLine($"DECLARE @{property.SelectSqlParameterNaam} as bigint;");
stringbuilder.AppendLine($"SELECT @{property.SelectSqlParameterNaam} = {property.SelectSqlParameterNaam}");
stringbuilder.AppendLine($" FROM [dbo].{Entity.Name}");
stringbuilder.AppendLine($" WHERE {Entity.Name}.Id = {parameterName};");
return(stringbuilder.ToString());
}
/// <summary>
/// .ctor
/// </summary>
/// <param name="dbProperty">数据库属性信息</param>
/// <param name="isWrite">是否写连接（默认使用读连接）</param>
public SqlDataAccess(DatabaseProperty dbProperty, bool isWrite = false)
: base(dbProperty, isWrite)
{
}
public DescriptionHistoryColumnBuilder(DatabaseProperty property, Entity entity) : base(property, entity)
{
}
/// <summary>
/// ִ���������XmlReader
/// </summary>
/// <param name="q">SqlQuery����</param>
/// <param name="dp">Sql��������</param>
/// <returns>XmlReader</returns>
public static XmlReader ExecuteXmlReader(SqlQuery q, DatabaseProperty dp)
{
SqlDataAccess da = new SqlDataAccess(dp.ConnectionString);
da.Open();
return da.ExecuteXmlReader(q);
}
/// <summary>
/// ִ���������Xml�ĵ�
/// </summary>
/// <param name="q">SqlQuery����</param>
/// <param name="dp">Sql��������</param>
/// <returns>Xml�ĵ�</returns>
public static XmlDocument ExecuteXmlDoc(SqlQuery q, DatabaseProperty dp)
{
SqlDataAccess da = new SqlDataAccess(dp.ConnectionString);
da.Open();
XmlDocument doc = da.ExecuteXmlDoc(q);
da.Close();
return doc;
}
/// <summary>
/// ִ����������������е�Object
/// </summary>
/// <param name="q">SqlQuery����</param>
/// <param name="dp">Sql��������</param>
/// <returns>�������е�Object</returns>
public static Object ExecuteScalar(SqlQuery q, DatabaseProperty dp)
{
SqlDataAccess da = new SqlDataAccess(dp.ConnectionString);
da.Open();
object scalar = da.ExecuteScalar(q);
da.Close();
return scalar;
}
/// <summary>
/// ִ���������Ӱ������
/// </summary>
/// <param name="q">SqlQuery����</param>
/// <param name="dp">Sql��������</param>
/// <returns>Ӱ������</returns>
public static int ExecuteNonQuery(SqlQuery q, DatabaseProperty dp)
{
SqlDataAccess da = new SqlDataAccess(dp.ConnectionString);
da.Open();
int affectRows = da.ExecuteNonQuery(q);
da.Close();
return affectRows;
}
/// <summary>
/// ִ���������Dataset
/// </summary>
/// <param name="q">SqlQuery����</param>
/// <param name="dp">Sql��������</param>
/// <returns>Dataset</returns>
public static DataSet ExecuteDataset(SqlQuery q, DatabaseProperty dp)
{
SqlDataAccess da = new SqlDataAccess(dp.ConnectionString);
da.Open();
DataSet ds = da.ExecuteDataset(q);
da.Close();
return ds;
}
public DescriptionColumnBuilder(DatabaseProperty property, Entity entity)
{
_property = property;
_entity = entity;
}
public static DataAccess CreateSqlDataAccess(DatabaseProperty dp)
{
return(new DataAccess(dp.Writer.ConnectionString));
}
public string GetProperty(DatabaseProperty property)
{
return(_properties[property]);
}
