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));
}
