public List <T> FindListTop <T>(int top) where T : new() { StringBuilder strSql = DatabaseCommon.SelectTopSql <T>(top); IDataReader dr = DatabaseCommon.ExecuteDataReader(this.dbConnection, strSql.ToString()); return(ConvertExtension.IDataReaderToList <T>(dr)); }
public DataTable FindTable(string strSql, DbParameter[] dbParameter, string orderField, bool isAsc, int pageSize, int pageIndex, out int total) { StringBuilder sb = new StringBuilder(); if (pageIndex == 0) { pageIndex = 1; } int num = (pageIndex - 1) * pageSize; int num1 = (pageIndex) * pageSize; string OrderBy = ""; if (!string.IsNullOrEmpty(orderField)) { if (orderField.ToUpper().IndexOf("ASC") + orderField.ToUpper().IndexOf("DESC") > 0) { OrderBy = " Order By " + orderField; } else { OrderBy = " Order By " + orderField + " " + (isAsc ? "ASC" : "DESC"); } } else { OrderBy = " order by (select 0 )"; } sb.Append(strSql + OrderBy); sb.Append(" limit " + num + "," + pageSize + ""); total = Convert.ToInt32(ExecuteScalar("Select Count(1) From (" + strSql + ") As ttt", dbParameter)); var IDataReader = DatabaseCommon.ExecuteDataReader(this.dbConnection, sb.ToString(), dbParameter); DataTable resultTable = ConvertExtension.IDataReaderToDataTable(IDataReader); return(resultTable); }
public IEnumerable <T> FindList <T>(Expression <Func <T, bool> > condition, string orderField, bool isAsc, int pageSize, int pageIndex, out int total) where T : class, new() { StringBuilder sb = new StringBuilder(); string strSql = string.Format("SELECT * From {0} Where {1} ", typeof(T).GetMappingAttributeName(), ExpressionToSql.GetWhereByLambda(condition));//test1 sb.AppendFormat(strSql); if (pageIndex == 0) { pageIndex = 1; } int num = (pageIndex - 1) * pageSize; int num1 = (pageIndex) * pageSize; string OrderBy = ""; if (!string.IsNullOrEmpty(orderField)) { if (orderField.ToUpper().IndexOf("ASC") + orderField.ToUpper().IndexOf("DESC") > 0) { OrderBy = " Order By " + orderField; } else { OrderBy = " Order By " + orderField + " " + (isAsc ? "ASC" : "DESC"); } } else { OrderBy = " order by (select 0 )"; } sb.Append(OrderBy); sb.Append(" limit " + num + "," + pageSize + ""); total = Convert.ToInt32(this.FindObject("Select Count(1) From (" + strSql + ") As ttt")); return(ConvertExtension.IDataReaderToList <T>(DatabaseCommon.ExecuteDataReader(this.dbConnection, sb.ToString()))); }
//分页List查询 public IEnumerable <T> FindList <T>(int pageIndex, int pageSize, string orderField, bool isAsc, out int totalCount) where T : class, new() { StringBuilder sb = new StringBuilder(); string strSql = string.Format("SELECT * From {0} ", typeof(T).GetMappingAttributeName()); sb.AppendFormat(strSql); pageIndex = pageIndex == 0 ? 1 : pageIndex; int startNum = (pageIndex - 1) * pageSize; string OrderBy = ""; if (!orderField.IsNullEmpty()) { if (orderField.ToUpper().IndexOf("ASC") + orderField.ToUpper().IndexOf("DESC") > 0) { OrderBy = " Order By " + orderField; } else { OrderBy = " Order By " + orderField + " " + (isAsc ? "ASC" : "DESC"); } } else { OrderBy = " order by (select 0 )"; } sb.Append(OrderBy); sb.AppendFormat(" limit {0},{1} ", startNum, pageSize); totalCount = this.FindObject("Select Count(1) From (" + strSql + ") As ttt").ToInt(); return(ConvertExtension.IDataReaderToList <T>(DatabaseCommon.ExecuteDataReader(this.dbConnection, sb.ToString()))); }
public List <T> FindListTop <T>(int top, string WhereOrderSql, params DbParameter[] parameters) where T : new() { StringBuilder strSql = new StringBuilder(); strSql.AppendFormat("SELECT * FROM {0} ", typeof(T).GetMappingAttributeName()); strSql.Append("WHERE True " + WhereOrderSql); strSql.Append(" limit " + top); IDataReader dr = DatabaseCommon.ExecuteDataReader(this.dbConnection, strSql.ToString(), parameters); return(ConvertExtension.IDataReaderToList <T>(dr)); }
public List <T> FindListTop <T>(int top, string propertyName, object propertyValue) where T : new() { StringBuilder strSql = new StringBuilder(); strSql.AppendFormat("SELECT * FROM {0} WHERE 1=1", typeof(T).GetMappingAttributeName()); strSql.Append(" AND " + propertyName + " = " + DatabaseCommon.DbParmCharacter + propertyName); strSql.Append(" limit " + top); IDataReader dr = DatabaseCommon.ExecuteDataReader(this.dbConnection, strSql.ToString(), DbParameters.CreateDbParameter(propertyName, propertyValue)); return(ConvertExtension.IDataReaderToList <T>(dr)); }
//查询where条件的列表数据 public IEnumerable <T> FindList <T>(string where, string colNameSort) where T : class, new() { Type type = typeof(T); StringBuilder strSql = new StringBuilder(); strSql.AppendFormat("SELECT * FROM {0} WHERE 1=1 ", type.GetMappingAttributeName()); if (!string.IsNullOrEmpty(where)) { strSql.Append(where); } if (!string.IsNullOrEmpty(colNameSort)) { strSql.AppendFormat(" Order BY {0}", colNameSort); } return(ConvertExtension.IDataReaderToList <T>(DatabaseCommon.ExecuteDataReader(this.dbConnection, strSql.ToString(), null))); }
public DataTable FindTable(string strSql, params DbParameter[] dbParameter) { var IDataReader = DatabaseCommon.ExecuteDataReader(this.dbConnection, strSql, dbParameter); return(ConvertExtension.IDataReaderToDataTable(IDataReader)); }
/// <summary> /// Sql语句查询 /// </summary> public IEnumerable <T> FindList <T>(string strSql, params DbParameter[] dbParameter) where T : class { return(ConvertExtension.IDataReaderToList <T>(DatabaseCommon.ExecuteDataReader(this.dbConnection, strSql, dbParameter))); }