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