/// <summary> /// /// </summary> /// <param name="sql"></param> /// <param name="param"></param> /// <param name="totalRecord"></param> /// <returns></returns> public IEnumerable <dynamic> Query(string sql, DynamicParameters param, int totalRecord) { System.Data.IDbTransaction trans = null; IEnumerable <dynamic> result = null; using (System.Data.IDbConnection conn = this.GetOpenConnection()) { result = DMSDbAccess.Query(conn, string.Empty, sql, param, totalRecord, trans, true, 30); return(result); } }
/// <summary> /// /// </summary> /// <typeparam name="T"></typeparam> /// <param name="sql"></param> /// <param name="param"></param> /// <param name="totalRecord"></param> /// <returns></returns> public IEnumerable <T> Query <T>(string sql, DynamicParameters param, int totalRecord) { try { System.Data.IDbTransaction trans = null; IEnumerable <T> result = null; using (System.Data.IDbConnection conn = this.GetOpenConnection()) { result = DMSDbAccess.Query <T>(conn, typeof(T).FullName, sql, param, totalRecord, trans, true, 30); return(result); } } catch (Exception ex) { Log.Debug(ReflectionUtils.GetMethodBaseInfo(System.Reflection.MethodBase.GetCurrentMethod()), ex.Message, ex); throw ex; } }
/// <summary> /// /// </summary> /// <typeparam name="T"></typeparam> /// <param name="ExcuteType"></param> /// <param name="countsql"></param> /// <param name="sql"></param> /// <param name="param"></param> /// <param name="pageIndex"></param> /// <param name="pageSize"></param> /// <param name="totalRecord"></param> /// <returns></returns> public ConditionResult <T> GetConditionResult <T>(DMSExcuteType ExcuteType, string countsql, string sql, DynamicParameters param, int pageIndex, int pageSize, int totalRecord) where T : class { ConditionResult <T> resultList = new ConditionResult <T>() { PageIndex = pageIndex, PageSize = pageSize, TotalRecord = 0, AllowPaging = true, ResultList = new List <T>(), }; using (System.Data.IDbConnection conn = this.GetOpenConnection()) { if (ExcuteType == DMSExcuteType.SELECT) { if (totalRecord == 0) { totalRecord = (int)DMSDbAccess.ExecuteScalar(conn, typeof(T).FullName, countsql, param); } resultList.TotalRecord = totalRecord; resultList.ResultList = DMSDbAccess.Query <T>(conn, typeof(T).FullName, sql, param, totalRecord, null, false, 30).ToList(); if (resultList.PageSize > 0) { resultList.TotalPage = resultList.TotalRecord / resultList.PageSize + (resultList.TotalRecord % resultList.PageSize == 0 ? 0 : 1); } } else if (ExcuteType == DMSExcuteType.DELETE || ExcuteType == DMSExcuteType.INSERT || ExcuteType == DMSExcuteType.UPDATE) { resultList.TotalRecord = DMSDbAccess.Execute(conn, typeof(T).FullName, sql, param); } conn.Close(); } return(resultList); }