public void TestBreedMethod() { BreedFilter filter = new BreedFilter() { }; List <Breed> list = Helper.GetService().GetBreed(filter); Assert.IsNotNull(list); }
public List <Breed> GetBreed(BreedFilter filter, int rowsCount) { string sql = "SELECT \"row_number\"() OVER(ORDER BY e.\"Name\") \"rownum\",b.\"Id\",b.\"Name\",b.\"Description\",b.\"PrincipalId\",b.\"OperatorId\",b.\"CreateTime\",b.\"Remark\",u.\"UserName\" AS \"OperatorName\", e.\"Name\" AS \"PrincipalName\" FROM \"T_Breed\" b join \"T_User\" u ON u.\"Id\" = b.\"OperatorId\" join \"T_Employee\" e ON e.\"Id\" = b.\"PrincipalId\""; return(GetRuledRowsData <Breed, BreedFilter>(rowsCount, sql, filter)); }
public List <Breed> GetBreed(BreedFilter filter) { string sql = "SELECT b.\"Id\",b.\"Name\",b.\"Description\",b.\"PrincipalId\",b.\"OperatorId\",b.\"CreateTime\",b.\"Remark\",u.\"UserName\" AS \"OperatorName\", e.\"Name\" AS \"PrincipalName\" FROM \"T_Breed\" b join \"T_User\" u ON u.\"Id\" = b.\"OperatorId\" join \"T_Employee\" e ON e.\"Id\" = b.\"PrincipalId\""; return(GetData <Breed, BreedFilter>(sql, filter)); }