/// <summary> /// 设置查询列和分页参数执行查询,并且将结果集转成dynamic /// </summary> /// <param name="sqlable"></param> /// <param name="fileds">查询列</param> /// <param name="orderByFiled">Order By字段,可以多个</param> /// <param name="pageIndex">页码</param> /// <param name="pageSize">每页显示数量</param> /// <param name="whereObj">SQL参数,例如:new{id=1,name="张三"}</param> /// <returns></returns> public static dynamic SelectToPageDynamic(this Sqlable.Sqlable sqlable, string fileds, string orderByFiled, int pageIndex, int pageSize, object whereObj = null) { return (JsonConverter.ConvertJson(SelectToPageJson(sqlable, fileds, orderByFiled, pageIndex, pageSize, whereObj))); }
/// <summary> /// 设置查询列执行查询,并且将结果集转成json /// </summary> /// <param name="sqlable"></param> /// <param name="fileds">查询列</param> /// <param name="whereObj">SQL参数,例如:new{id=1,name="张三"}</param> /// <returns></returns> public static string SelectToJson(this Sqlable.Sqlable sqlable, string fileds, object whereObj = null) { return(JsonConverter.DataTableToJson(SelectToDataTable(sqlable, fileds, whereObj), sqlable.DB.SerializerDateFormat)); }
/// <summary> /// 设置查询列执行查询,并且将结果集转成dynamic /// </summary> /// <param name="sqlable"></param> /// <param name="fileds">查询列</param> /// <param name="whereObj">SQL参数,例如:new{id=1,name="张三"}</param> /// <returns></returns> public static dynamic SelectToDynamic(this Sqlable.Sqlable sqlable, string fileds, object whereObj = null) { return(JsonConverter.ConvertJson(SelectToJson(sqlable, fileds, whereObj))); }
/// <summary> /// 设置查询列和分页参数执行查询,并且将结果集转成json /// </summary> /// <param name="sqlable"></param> /// <param name="fileds">查询列</param> /// <param name="orderByFiled">Order By字段,可以多个</param> /// <param name="pageIndex">页码</param> /// <param name="pageSize">每页显示数量</param> /// <param name="whereObj">SQL参数,例如:new{id=1,name="张三"}</param> /// <returns></returns> public static string SelectToPageJson(this Sqlable sqlable, string fileds, string orderByFiled, int pageIndex, int pageSize, object whereObj = null) { return(JsonConverter.DataTableToJson(SelectToPageTable(sqlable, fileds, orderByFiled, pageIndex, pageSize, whereObj), sqlable.DB.SerializerDateFormat)); }
/// <summary> /// 根据SQL语句将结果集映射到json /// </summary> /// <param name="sql">sql语句</param> /// <param name="whereObj">匿名参数(例如:new{id=1,name="张三"})</param> /// <returns>JSON数据</returns> public string SqlQueryJson(string sql, object whereObj = null) { return(JsonConverter.DataTableToJson(GetDataTable(sql, whereObj), SerializerDateFormat)); }
/// <summary> /// 根据SQL语句将结果集映射到dynamic /// </summary> /// <param name="sql">sql语句</param> /// <param name="whereObj">匿名参数(例如:new{id=1,name="张三"})</param> /// <returns>动态集合</returns> public dynamic SqlQueryDynamic(string sql, object whereObj = null) { return(JsonConverter.ConvertJson(SqlQueryJson(sql, whereObj))); }
/// <summary> /// 将Queryable转换为Dynamic /// </summary> /// <typeparam name="T">实体类型</typeparam> /// <param name="queryable">查询对象</param> /// <returns>dynamic</returns> public static dynamic ToDynamic <T>(this Queryable <T> queryable) { return(JsonConverter.ConvertJson(ToJson <T>(queryable))); }
/// <summary> /// 将Queryable转换为Json /// </summary> /// <typeparam name="T">实体类型</typeparam> /// <param name="queryable">查询对象</param> /// <returns>json字符串</returns> public static string ToJson <T>(this Queryable <T> queryable) { return(JsonConverter.DataTableToJson(ToDataTable <T>(queryable), queryable.DB.SerializerDateFormat)); }