/// <summary>
/// GetListAndFileds
/// </summary>
/// <param name="Top">条数</param>
/// <param name="func">Lambda形式条件和参数</param>
/// <param name="funcFields">Lambda形式返回字段</param>
/// <returns></returns>
public static System.Data.DataSet GetListAndFileds(int Top, System.Linq.Expressions.Expression <Func <T, bool> > func, System.Linq.Expressions.Expression <Func <T, bool> > funcFields)
{
SQLAndParameter _SP = LambdaToSQL.GetWhere <T>(func).CheckSQLSort(SQLSort.SQLWhere);
SQLAndParameter _SPFields = LambdaToSQL.GetWhere <T>(funcFields).CheckSQLSort(SQLSort.SQLFields);
return(Orm.EntityCore <T> .GetListAndFileds(Top, _SP.SQL, _SP.Parameter.Re_SqlParameter(), _SPFields.SQL));
}
/// <summary>
///
/// </summary>
/// <param name="_pageindex">当前页数, 1为第一页</param>
/// <param name="func">Lambda形式条件和参数</param>
public Pager(int _pageindex, System.Linq.Expressions.Expression <Func <table, bool> > func)
{
this._pageindex = _pageindex;
SQLAndParameter _SP = LambdaToSQL.GetWhere <table>(func).CheckSQLSort(SQLSort.SQLWhere);
this._sqlwhere = _SP.SQL;
this._sqlparms = _SP.Parameter.Re_SqlParameter();
}
/// <summary>
/// GetModelList
/// </summary>
/// <param name="Top">条数</param>
/// <param name="func">Lambda形式条件和参数</param>
/// <param name="funcOrder">Lambda形式排序</param>
/// <returns></returns>
public static List2 <T> GetModelList(int Top, System.Linq.Expressions.Expression <Func <T, bool> > func, System.Linq.Expressions.Expression <Func <T, bool> > funcOrder)
{
SQLAndParameter _SP = LambdaToSQL.GetWhere <T>(func).CheckSQLSort(SQLSort.SQLWhere);
SQLAndParameter _SPOrder = LambdaToSQL.GetWhere <T>(funcOrder).CheckSQLSort(SQLSort.SQLOrder);
_SP.Parameter.CanShu.AddAsNvarchar(_SPOrder.Parameter.Re_SqlParameter());
return(Orm.EntityCore <T> .GetModelList(Top, _SP.SQL, _SP.Parameter.Re_SqlParameter(), _SPOrder.SQL));
}
/// <summary>
/// 条件查询
/// </summary>
/// <returns></returns>
public T GM <T>(System.Linq.Expressions.Expression <Func <T, bool> > func, ref T m) where T : EntityBase <T>, new()
{
if (m == null || DealMvc.WebCache.WebCache.IsUseWebCache)
{
SQLAndParameter _SP = LambdaToSQL.GetWhere <T>(func).CheckSQLSort(SQLSort.SQLWhere);
m = Orm.EntityCore <T> .GetModel(_SP.SQL, _SP.Parameter.Re_SqlParameter(), false);
}
return(m);
}
/// <summary>
///
/// </summary>
/// <param name="_pageindex">当前页数, 1为第一页</param>
/// <param name="func">Lambda形式条件和参数</param>
/// <param name="_pagesize">每页记录数</param>
///<param name="funcOrder">Lambda形式排序</param>
///<param name="funcFields">Lambda形式字段</param>
public Pager(int _pageindex, System.Linq.Expressions.Expression <Func <table, bool> > func, int _pagesize, System.Linq.Expressions.Expression <Func <table, bool> > funcOrder, System.Linq.Expressions.Expression <Func <table, bool> > funcFields)
{
this._pageindex = _pageindex;
SQLAndParameter _SP = LambdaToSQL.GetWhere <table>(func).CheckSQLSort(SQLSort.SQLWhere);
SQLAndParameter _SPOrder = LambdaToSQL.GetWhere <table>(funcOrder).CheckSQLSort(SQLSort.SQLOrder);
SQLAndParameter _SPFields = LambdaToSQL.GetWhere <table>(funcFields).CheckSQLSort(SQLSort.SQLFields);
this._sqlwhere = _SP.SQL;
this._sqlparms = _SP.Parameter.Re_SqlParameter();
this._pagesize = _pagesize;
this._orderstring = _SPOrder.SQL;
this._columns = _SPFields.SQL;
}
/// <summary>
/// GetModelList
/// </summary>
/// <param name="func">Lambda形式条件和参数</param>
/// <returns></returns>
public static List2 <T> GetModelList(System.Linq.Expressions.Expression <Func <T, bool> > func)
{
SQLAndParameter _SP = LambdaToSQL.GetWhere <T>(func).CheckSQLSort(SQLSort.SQLWhere);
return(Orm.EntityCore <T> .GetModelList(_SP.SQL, _SP.Parameter.Re_SqlParameter()));
}
/// <summary>
/// DeleteWhere
/// </summary>
/// <param name="func">Lambda形式条件和参数</param>
/// <param name="_SqlTranExtensions">事务对象</param>
public static void DeleteWhere(System.Linq.Expressions.Expression <Func <T, bool> > func, DealMvc.SqlTranEx.SqlTranExtensions _SqlTranExtensions)
{
SQLAndParameter _SP = LambdaToSQL.GetWhere <T>(func).CheckSQLSort(SQLSort.SQLWhere);
Orm.EntityCore <T> .DeleteWhere(_SP.SQL, _SP.Parameter.Re_SqlParameter(), _SqlTranExtensions);
}