//创建一个查询对象构造器 private ISelectBuilder CreateBuilder(DbContext db, ExecuteModel executeModel) { //获取当前类名 var tableName = GetTableName(executeModel.Entity.GetType()); //查询器 ISelectBuilder selectBuilder = db.Select(tableName); //获取条件sql var whereSql = GetConitionsql(executeModel.Conditions); //添加SQL条件 selectBuilder.Where(whereSql); executeModel.Conditions?.ForEach(p => { //先设置参数,组装SQL if (p.Oper == Operational.In || p.Oper == Operational.NotIn) { //In 或 not in 通过设置参数方式 GetParams(p.Key, p.Value, selectBuilder); } else { selectBuilder.Parameters(p.Key, p.Value); } }); if (executeModel.OrderColumn.IsNotNullOrEmpty()) {//如果包括了排序字段,则使用排序 selectBuilder.OrderBy(executeModel.OrderColumn); }//end if //返回组装的对象 return(selectBuilder); }
/// <summary> /// 构造数据查询条件 /// </summary> private static void BuildSelectRow <T>(ISelectBuilder <T> selector, RoleQueryRequeest requeest) { if (requeest.Status.HasValue) { selector.AndWhere("br.Status=@Status").Parameter("Status", requeest.Status); } if (!string.IsNullOrEmpty(requeest.OrderBy)) { selector.OrderBy(requeest.OrderBy); } if (requeest.CurrentPageIndex.HasValue && requeest.PageSize.HasValue) { selector.Paging(requeest.CurrentPageIndex.Value, requeest.PageSize.Value); } }
public void SqlBuilderSample(FeiniuBus.DynamicQuery dynamicQuery, ISelectBuilder selectBuilder) { var sb = new StringBuilder(); var mappings = new SqlFieldMappings(); mappings.Map("Guest", "t1.Guest") .Map("Address", "t1.Address") .Map("Disabled", "t1.Disabled") .Map("Amout", "t1.Amout") .Map("Price", "t1.Price") .Map("Drink", "t1.Drink") .Map("Count", "t1.Count") .Map("Total", "t1.Total") .Map("Url", "t1.Url"); selectBuilder.Mapping(mappings); selectBuilder.Where(dynamicQuery.ParamGroup); var whereClause = selectBuilder.BuildWhere(); var orderbyClause = selectBuilder.OrderBy(dynamicQuery.Order); System.Console.WriteLine(whereClause); System.Console.WriteLine(orderbyClause); }