public List <Quit> GetQuit(QuitFilter filter, int pageIndex, int pageSize, out int totalCount)
{
string sql = "SELECT \"row_number\" () OVER (ORDER BY q.\"CreateTime\" DESC) \"rownum\", q.\"Id\", q.\"EmployeeId\", eq.\"Name\" AS \"EmployeeName\", q.\"QuitDate\", q.\"Reason\", e.\"Name\" AS \"PrincipalName\", u.\"UserName\" AS \"OperatorName\", q.\"CreateTime\", q.\"Remark\" FROM \"T_Quit\" q JOIN \"T_Employee\" eq ON eq.\"Id\" = q.\"EmployeeId\" JOIN \"T_Employee\" e ON e.\"Id\" = q.\"PrincipalId\" JOIN \"T_User\" u ON u.\"Id\" = q.\"OperatorId\" ";
string countSql = "select count(q.\"Id\") FROM \"T_Quit\" q JOIN \"T_Employee\" eq ON eq.\"Id\" = q.\"EmployeeId\" JOIN \"T_Employee\" e ON e.\"Id\" = q.\"PrincipalId\" JOIN \"T_User\" u ON u.\"Id\" = q.\"OperatorId\"";
return(GetPagedData <Quit, QuitFilter>(pageIndex, pageSize, out totalCount, countSql, sql, filter));
}
public List <Quit> GetQuit(QuitFilter filter, int rowsCount)
{
string sql = "SELECT \"row_number\" () OVER (ORDER BY q.\"CreateTime\" DESC) \"rownum\", q.\"Id\", q.\"EmployeeId\", eq.\"Name\" AS \"EmployeeName\", q.\"QuitDate\", q.\"Reason\", e.\"Name\" AS \"PrincipalName\", u.\"UserName\" AS \"OperatorName\", q.\"CreateTime\", q.\"Remark\" FROM \"T_Quit\" q JOIN \"T_Employee\" eq ON eq.\"Id\" = q.\"EmployeeId\" JOIN \"T_Employee\" e ON e.\"Id\" = q.\"PrincipalId\" JOIN \"T_User\" u ON u.\"Id\" = q.\"OperatorId\"";
return(GetRuledRowsData <Quit, QuitFilter>(rowsCount, sql, filter));
}
