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