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