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