public ActionResult TeamPointsQuery(int userTag, string statisticsYear, int statisticsMode)
{
var filter = new TeamPointsFilter()
{
UserTag = userTag,
statisticsYear = statisticsYear,
statisticsMode = statisticsMode
};
var result = MockTestBasisService.SearchTeamPointsLists(filter);
return(Json(new AjaxResult()
{
Success = true, Data = result
}, JsonRequestBehavior.AllowGet));
}
public static List <TeamPointsVO> SearchTeamPointsLists(TeamPointsFilter filter)
{
switch (filter.statisticsMode)
{
case 1:
var cmd1 = new DataCommand("MockTest.TeamPoints1");
cmd1.SetParameter("@userTag", DbType.Int32, filter.UserTag);
cmd1.SetParameter("@year", DbType.String, filter.statisticsYear);
return(cmd1.ExecuteEntityList <TeamPointsVO>());
case 2:
var cmd2 = new DataCommand("MockTest.TeamPoints2");
cmd2.SetParameter("@userTag", DbType.Int32, filter.UserTag);
cmd2.SetParameter("@year", DbType.String, filter.statisticsYear);
return(cmd2.ExecuteEntityList <TeamPointsVO>());
default:
break;
}
return(new List <TeamPointsVO>());
}
public List <TeamPointsVO> SearchTeamPointsLists(TeamPointsFilter filter)
{
return(MockTestDA.SearchTeamPointsLists(filter));
}
