public IEnumerable <TModel> GetList(Expression <Func <TModel, TForeignModel, bool> > whereSelector, int pageSize = 20, int pageNum = 1, string include = "", OrderByEntity orderBy = null)
{
var arr = MySQLUtility.ExecuteParm(whereSelector, include);
return(Fabricate.GetListByTable <TModel>(CommandType.Text, CreateSql(SqlType.GetPage_MySQL, arr.Item4, arr.Item1.Remove(arr.Item1.Length - 1), arr.Item2, orderBy, pageSize, pageNum), arr.Item5, include, arr.Item3.ToArray()));
}
public int Count(Expression <Func <TModel, TForeignModel, bool> > whereSelector, string include = "", bool isAll = true)
{
var arr = MySQLUtility.ExecuteParm(whereSelector, include);
return(Convert.ToInt32(Fabricate.GetTable(CommandType.Text, CreateSql(isAll ? SqlType.Count_MySQL : SqlType.CountDetail, arr.Item4, arr.Item1.Remove(arr.Item1.Length - 1), arr.Item2)).Rows[0][0]));
}
public TModel Get(Expression <Func <TModel, TForeignModel, bool> > whereSelector, string include = "", OrderByEntity orderBy = null)
{
var arr = MySQLUtility.ExecuteParm(whereSelector, include);
return(GetList(whereSelector, include, orderBy).FirstOrDefault());
}
public string ToString <TModel>() where TModel : IFoundationModel, new()
{
return(MySQLUtility.ExecuteParm(MySQLUtility.GetModelExpr <TViewModel, TModel>(Expr), "").Item2);
}
public int Count(Expression <Func <TModel, TForeignModel, bool> > whereSelector, string include = "", bool isAll = true)
{
var paramModel = MySQLUtility.ExecuteParm(whereSelector, include);
return(Convert.ToInt32(Fabricate.GetTable(CommandType.Text, CreateSql(isAll ? SqlType.Count_MySQL : SqlType.CountDetail, paramModel.TableName, paramModel.ColumnName, paramModel.WhereSQL)).Rows[0][0]));
}
public IEnumerable <TModel> GetList(Expression <Func <TModel, TForeignModel, bool> > whereSelector, int pageSize = 20, int pageNum = 1, string include = "", IEnumerable <OrderByEntity> orderBy = null)
{
var paramModel = MySQLUtility.ExecuteParm(whereSelector, include);
return(Fabricate.GetListByTable <TModel>(CommandType.Text, CreateSql(SqlType.GetPageOneToOne_MySQL, paramModel.TableName, paramModel.ColumnName, paramModel.WhereSQL, orderBy, pageSize, pageNum), paramModel.ListTableMap, include, paramModel.ListSqlParams.ToArray()));
}
public IEnumerable <TModel> GetList(Expression <Func <TModel, bool> > mainWhereSelector, Expression <Func <TForeignModel, bool> > joinWhereSelector, string include = "", IEnumerable <OrderByEntity> orderBy = null)
{
var paramModel = MySQLUtility.ExecuteParm(mainWhereSelector, joinWhereSelector, include);
return(Fabricate.GetListByTable <TModel>(CommandType.Text, CreateSql(SqlType.Get, paramModel.TableName, paramModel.ColumnName, paramModel.WhereSQL, orderBy), paramModel.ListTableMap, include, paramModel.ListSqlParams.ToArray()));
}
