/// <summary> /// 单位积分查询 /// </summary> /// <param name="filter"></param> /// <returns></returns> public static QueryResult <User_Plan_RankVO> SearchUserPlanRankPageList(User_Plan_RankFilter filter) { var cmd = new DataCommand("Plan.SearchUserPlanRankPageList"); SetCondition(cmd, filter); return(cmd.Query <User_Plan_RankVO>(filter, "tupr.create_time desc ", null, true)); }
/// <summary> /// 设置条件 /// </summary> /// <param name="command"></param> /// <param name="filter"></param> private static void SetCondition(DataCommand command, User_Plan_RankFilter filter) { if (filter.plan_id.HasValue) { command.QuerySetCondition("tupr.plan_id", ConditionOperation.Equal, DbType.Int32, filter.plan_id.Value); } command.CommandText = command.CommandText.Replace("#STRWHERE#", command.QueryConditionString); }
/// <summary> /// 处理人积分查询 /// </summary> /// <param name="filter"></param> /// <returns></returns> public QueryResult <User_Plan_RankVO> SearchUserPlanRankPageList(User_Plan_RankFilter filter) { return(PlanDA.SearchUserPlanRankPageList(filter)); }