/// <summary>
/// 通过xml文件--执行数据库操作
/// </summary>
/// <param name="xmlId"></param>
/// <param name="sqlId"></param>
/// <param name="parameters"></param>
/// <returns></returns>
public int ExecuteNonQuery(string xmlId, string sqlId, params object[] parameters)
{
var resloveResult = ResolveSqlTextExtension.GetResolveXmlResult(xmlId, sqlId, parameters);
return(ExecuteNonQuery(resloveResult.sqlText, resloveResult.parameters));
}
/// <summary>
/// 通过xml文件--读取单条动态记录
/// </summary>
/// <param name="xmlId"></param>
/// <param name="sqlId"></param>
/// <param name="parameters"></param>
/// <returns></returns>
public dynamic QuerySingleDynamic(string xmlId, string sqlId, params object[] parameters)
{
var resloveResult = ResolveSqlTextExtension.GetResolveXmlResult(xmlId, sqlId, parameters);
return(QuerySingleDynamic(resloveResult.sqlText, resloveResult.parameters));
}
/// <summary>
/// 通过xml文件--读取单条记录（泛型）
/// </summary>
/// <typeparam name="TEntity"></typeparam>
/// <param name="xmlId"></param>
/// <param name="sqlId"></param>
/// <param name="parameters"></param>
/// <returns></returns>
public TEntity QuerySingleEntity <TEntity>(string xmlId, string sqlId, params object[] parameters) where TEntity : class, new()
{
var resloveResult = ResolveSqlTextExtension.GetResolveXmlResult(xmlId, sqlId, parameters);
return(QuerySingleEntity <TEntity>(resloveResult.sqlText, resloveResult.parameters));
}
/// <summary>
/// 通过xml文件--读取详细记录,值通过key,value提供
/// </summary>
/// <param name="xmlId"></param>
/// <param name="sqlId"></param>
/// <param name="parameters"></param>
/// <returns></returns>
public IDictionary <string, object> QuerySingleDictionary(string xmlId, string sqlId, params object[] parameters)
{
var resloveResult = ResolveSqlTextExtension.GetResolveXmlResult(xmlId, sqlId, parameters);
return(QuerySingleDictionary(resloveResult.sqlText, resloveResult.parameters));
}
/// <summary>
/// 通过xml文件--读取datatable
/// </summary>
/// <param name="xmlId"></param>
/// <param name="sqlId"></param>
/// <param name="parameters"></param>
/// <returns></returns>
public DataTable QueryDataTable(string xmlId, string sqlId, params object[] parameters)
{
var resloveResult = ResolveSqlTextExtension.GetResolveXmlResult(xmlId, sqlId, parameters);
return(QueryDataTable(resloveResult.sqlText, resloveResult.parameters));
}