public List <Cooperater> GetCooperater(CooperaterFilter filter, int pageIndex, int pageSize, out int totalCount)
{
string querySql = "SELECT \"row_number\" () OVER (ORDER BY C .\"Id\") AS \"rownum\", C .\"Id\", C .\"Name\", C .\"Department\", C .\"ContactInfo\", C .\"CreateTime\", C .\"Remark\", e.\"Name\" AS \"PrincipalName\", u.\"UserName\" AS \"OperatorName\" FROM \"T_Cooperater\" C JOIN \"T_Employee\" e ON e.\"Id\" = C .\"PrincipalId\" JOIN \"T_User\" u ON u.\"Id\" = C .\"OperatorId\"";
string countSql = "select count(c.\"Id\") from \"T_Cooperater\" C JOIN \"T_Employee\" e ON e.\"Id\" = C .\"PrincipalId\" JOIN \"T_User\" u ON u.\"Id\" = C .\"OperatorId\"";
return(GetPagedData <Cooperater, CooperaterFilter>(pageIndex, pageSize, out totalCount, countSql, querySql, filter));
}
public List <Cooperater> GetCooperater(CooperaterFilter filter, int rowsCount)
{
string querySql = "SELECT \"row_number\" () OVER (ORDER BY C .\"Id\") AS \"rownum\", C .\"Id\", C .\"Name\", C .\"Department\", C .\"ContactInfo\", C .\"CreateTime\", C .\"Remark\", e.\"Name\" AS \"PrincipalName\", u.\"UserName\" AS \"OperatorName\" FROM \"T_Cooperater\" C JOIN \"T_Employee\" e ON e.\"Id\" = C .\"PrincipalId\" JOIN \"T_User\" u ON u.\"Id\" = C .\"OperatorId\"";
return(GetRuledRowsData <Cooperater, CooperaterFilter>(rowsCount, querySql, filter));
}
