/// <summary>
/// 查询
/// </summary>
/// <typeparam name="R"></typeparam>
/// <returns></returns>
public IList <R> Query <R>(QueryParam model, string tableName)
{
MySqlParameter[] parameters =
{
new MySqlParameter("_fields", model.Fields),
new MySqlParameter("_tableName", tableName),
new MySqlParameter("_where", model.StrWhere),
new MySqlParameter("_orderby", model.OrderBy),
};
return(DBHelperMySql.RunProceReturnDataSet("Query", parameters)
.Tables[0].ToList <R>());
}
/// <summary>
/// 根据条件查询分页订单列表--条件不含子表信息--只查询一张主表
/// </summary>
/// <param name="condition">查询条件</param>
/// <returns>返回需要的订单列表(不含订单子表信息)</returns>
public virtual PageModel <R> PageQuery <R>(PageParam model) where R : class, new()
{
StringBuilder strSql = new StringBuilder();
MySqlParameter[] parameters = new MySqlParameter[7];
parameters[0] = new MySqlParameter("_fields", model.Fields);
parameters[1] = new MySqlParameter("_tableName", model.TableName ?? TableName);
parameters[2] = new MySqlParameter("_where", model.StrWhere);
parameters[3] = new MySqlParameter("_orderby", model.OrderBy);
parameters[4] = new MySqlParameter("_pageindex", model.PageIndex);
parameters[5] = new MySqlParameter("_pagesize", model.PageSize);
parameters[6] = new MySqlParameter("_totalcount", MySqlDbType.Int32);
parameters[6].Direction = ParameterDirection.Output;
DataSet ds = DBHelperMySql.RunProceReturnDataSet("PageQuery", parameters);
PageModel <R> respQuery = new PageModel <R>()
{
List = ds.Tables[0].ToList <R>(),
TotalCount = int.Parse(parameters[6].Value.ToString()),
PageIndex = model.PageIndex,
PageSize = model.PageSize
};
return(respQuery);
}