public static List <IndividualPointsVO> SearchIndividualPointsLists(IndividualPointsFilter filter) { switch (filter.statisticsMode) { case 1: var cmd1 = new DataCommand("MockTest.IndividualPoints1"); cmd1.SetParameter("@userTag", DbType.Int32, filter.UserTag); return(cmd1.ExecuteEntityList <IndividualPointsVO>()); case 2: var cmd2 = new DataCommand("MockTest.IndividualPoints2"); cmd2.SetParameter("@userTag", DbType.Int32, filter.UserTag); cmd2.SetParameter("@year", DbType.String, filter.statisticsYear); return(cmd2.ExecuteEntityList <IndividualPointsVO>()); case 3: var cmd3 = new DataCommand("MockTest.IndividualPoints3"); cmd3.SetParameter("@userTag", DbType.Int32, filter.UserTag); cmd3.SetParameter("@year", DbType.String, filter.statisticsYear); return(cmd3.ExecuteEntityList <IndividualPointsVO>()); default: break; } return(new List <IndividualPointsVO>()); }
public ActionResult IndividualPointsQuery(int userTag, string statisticsYear, int statisticsMode) { var filter = new IndividualPointsFilter() { UserTag = userTag, statisticsYear = statisticsYear, statisticsMode = statisticsMode }; var result = MockTestBasisService.SearchIndividualPointsLists(filter); return(Json(new AjaxResult() { Data = result, Success = true }, JsonRequestBehavior.AllowGet)); }
public List <IndividualPointsVO> SearchIndividualPointsLists(IndividualPointsFilter filter) { return(MockTestDA.SearchIndividualPointsLists(filter)); }