public List <Sheep> GetAllSheep(SheepFilter filter, int pageIndex, int pageSize, out int totalCounts) { string querySql = "SELECT \"row_number\"() OVER(ORDER BY s.\"CreateTime\" desc) \"rownum\",s.\"Id\", s.\"SerialNumber\",s.\"Gender\", s.\"GrowthStage\",s.\"BirthWeight\", s.\"CompatriotNumber\", s.\"Birthday\", s.\"AblactationWeight\", s.\"AblactationDate\", s.\"Origin\",s.\"Status\",s.\"CreateTime\", s.\"Remark\", sf.\"SerialNumber\" AS \"FatherSerialNumber\", sm.\"SerialNumber\" AS \"MotherSerialNumber\", b.\"Name\" AS \"BreedName\", f.\"Name\" AS \"SheepfoldName\", u.\"UserName\" AS \"OperatorName\", e.\"Name\" AS \"PrincipalName\" FROM \"T_Sheep\" s left join \"T_Sheep\" sf ON sf.\"Id\" = s.\"FatherId\" left join \"T_Sheep\" sm ON sm.\"Id\" = s.\"MotherId\" join \"T_Breed\" b ON b.\"Id\" = s.\"BreedId\" join \"T_Sheepfold\" f ON f.\"Id\" = s.\"SheepfoldId\" join \"T_User\" u ON u.\"Id\" = s.\"OperatorId\" join \"T_Employee\" e ON e.\"Id\" = s.\"PrincipalId\""; string countSql = "SELECT COUNT (s.\"Id\") FROM \"T_Sheep\" s left JOIN \"T_Sheep\" sf ON sf.\"Id\" = s.\"FatherId\" left JOIN \"T_Sheep\" sm ON sm.\"Id\" = s.\"MotherId\" JOIN \"T_Breed\" b ON b.\"Id\" = s.\"BreedId\" JOIN \"T_Sheepfold\" f ON f.\"Id\" = s.\"SheepfoldId\" JOIN \"T_User\" u ON u.\"Id\" = s.\"OperatorId\" JOIN \"T_Employee\" e ON e.\"Id\" = s.\"PrincipalId\""; return(GetPagedData <Sheep, SheepFilter>(pageIndex, pageSize, out totalCounts, countSql, querySql, filter)); }
public void SheepMethod() { SheepFilter filter = new SheepFilter() { EndAblactationDate = DateTime.Now }; int totalCount; int pageIndex = 2; int pageSize = 5; List <Sheep> list = Helper.GetService().GetSheep(filter, pageIndex, pageSize, out totalCount); var list2 = Helper.Service.GetSheep(filter, 30); Assert.IsNotNull(list); }
public List <Sheep> GetSheep(SheepFilter filter, int rowsCount) { string sql = "SELECT \"row_number\"() OVER(ORDER BY s.\"CreateTime\" desc) \"rownum\",s.\"Id\", s.\"SerialNumber\",s.\"Gender\", s.\"GrowthStage\",s.\"BirthWeight\", s.\"CompatriotNumber\", s.\"Birthday\", s.\"AblactationWeight\", s.\"AblactationDate\", s.\"Origin\",s.\"Status\",s.\"CreateTime\", s.\"Remark\", sf.\"SerialNumber\" AS \"FatherSerialNumber\", sm.\"SerialNumber\" AS \"MotherSerialNumber\", b.\"Name\" AS \"BreedName\", f.\"Name\" AS \"SheepfoldName\", u.\"UserName\" AS \"OperatorName\", e.\"Name\" AS \"PrincipalName\" FROM \"T_Sheep\" s left join \"T_Sheep\" sf ON sf.\"Id\" = s.\"FatherId\" left join \"T_Sheep\" sm ON sm.\"Id\" = s.\"MotherId\" join \"T_Breed\" b ON b.\"Id\" = s.\"BreedId\" join \"T_Sheepfold\" f ON f.\"Id\" = s.\"SheepfoldId\" and f.\"SysFlag\"=FALSE join \"T_User\" u ON u.\"Id\" = s.\"OperatorId\" join \"T_Employee\" e ON e.\"Id\" = s.\"PrincipalId\""; return(GetRuledRowsData <Sheep, SheepFilter>(rowsCount, sql, filter)); }