public List <AntiepidemicPlan> GetAntiepidemicPlan(AntiepidemicPlanFilter filter, int pageIndex, int pageSize, out int totalCount)
{
string querySql = "select \"row_number\"() OVER(ORDER BY a.\"CreateTime\" desc) as \"rownum\" ,a.\"Id\",a.\"Name\",a.\"Vaccine\",a.\"PlanExecuteDate\",a.\"SheepFlock\",a.\"IsExcuted\",e.\"Name\" as \"PrincipalName\",u.\"UserName\" as\"OperatorName\",a.\"CreateTime\",a.\"Remark\" from \"T_AntiepidemicPlan\" a join \"T_Employee\" e on e.\"Id\"=a.\"PrincipalId\" join \"T_User\" u on u.\"Id\"=a.\"OperatorId\"";
string countSql = "select count(a.\"Id\") from \"T_AntiepidemicPlan\" a join \"T_Employee\" e on e.\"Id\"=a.\"PrincipalId\" join \"T_User\" u on u.\"Id\"=a.\"OperatorId\"";
return(GetPagedData <AntiepidemicPlan, AntiepidemicPlanFilter>(pageIndex, pageSize, out totalCount, countSql, querySql, filter));
}
public List <AntiepidemicPlan> GetAntiepidemicPlan(AntiepidemicPlanFilter filter, int rowsCount)
{
string querySql = "select \"row_number\"() OVER(ORDER BY a.\"CreateTime\" desc) as \"rownum\" ,a.\"Id\",a.\"Name\",a.\"Vaccine\",a.\"PlanExecuteDate\",a.\"SheepFlock\",a.\"IsExcuted\",e.\"Name\" as \"PrincipalName\",u.\"UserName\" as\"OperatorName\",a.\"CreateTime\",a.\"Remark\" from \"T_AntiepidemicPlan\" a join \"T_Employee\" e on e.\"Id\"=a.\"PrincipalId\" join \"T_User\" u on u.\"Id\"=a.\"OperatorId\"";
return(GetRuledRowsData <AntiepidemicPlan, AntiepidemicPlanFilter>(rowsCount, querySql, filter));
}
