/// <summary> /// 获取数据列表(分页) /// </summary> public PageModel GetDataListForPage(PageSearchRequest pt, string PhysicalTable, string keyword) { string sqlStr = @"select * from TbFormWindowsShowFields"; string whereStr = " where 1=1 and FormWindowsTableName is not null and (ISNULL('" + PhysicalTable + "','')='' or PhysicalTableName='" + PhysicalTable + "')"; #region 模糊搜索条件 var wherep = new List <Dos.ORM.Parameter>(); if (!string.IsNullOrWhiteSpace(keyword)) { whereStr += " and (PhysicalTableName like '%'+@keyword+'%' or FieldName like '%'+@keyword+'%' or FieldCode like '%'+@keyword+'%')"; var p = new Dos.ORM.Parameter("@keyword", keyword, DbType.String, null); wherep.Add(p); } #endregion try { //取总数,以计算共多少页。 var count = Repository <TbFormWindowsShowFields> .FromSql(sqlStr + whereStr, wherep).Count(); var model = Repository <TbFormWindowsShowFields> .FromSql(sqlStr + whereStr, wherep, "PhysicalTableName,FieldShowOrder", pt.sord, pt.rows, pt.page).ToList(); var model1 = new PageModel(pt.page, pt.rows, count, model); return(model1); } catch (Exception) { throw; } }
/// <summary> /// 构造函数 /// </summary> /// <param name="field"></param> /// <param name="value"></param> /// <param name="oper"></param> /// <param name="isFieldBefore"></param> public Expression(Field field, object value, QueryOperator oper, bool isFieldBefore) { if (!Field.IsNullOrEmpty(field)) { string valuestring = null; if (value is Expression) { Expression expression = (Expression)value; valuestring = expression.ToString(); parameters.AddRange(expression.Parameters); } else if (value is Field) { Field fieldValue = (Field)value; valuestring = fieldValue.TableFieldName; } else { valuestring = DataUtils.MakeUniqueKey(field); //valuestring = field.tableName + field.Name; Parameter p = new Parameter(valuestring, value, field.ParameterDbType, field.ParameterSize); parameters.Add(p); } if (isFieldBefore) { this.expressionString = string.Concat(field.TableFieldName, DataUtils.ToString(oper), valuestring); } else { this.expressionString = string.Concat(valuestring, DataUtils.ToString(oper), field.TableFieldName); } } }