/// <summary>
/// 查询统计
/// </summary>
/// <param name="filter"></param>
/// <returns></returns>
public static List <VoteStatisticsView> StatisticsVoteItem(VoteFilter filter)
{
var cmd = new DataCommand("VotingEvents.StatisticsVoteItem");
SetCondition(cmd, filter);
return(cmd.ExecuteEntityList <VoteStatisticsView>());
}
/// <summary>
/// 设置条件
/// </summary>
/// <param name="command"></param>
/// <param name="filter"></param>
private static void SetCondition(DataCommand command, VoteFilter filter)
{
//测验类型
if (filter.voteid.HasValue)
{
command.QuerySetCondition("tvi.vote_id", ConditionOperation.Equal, DbType.Int32, filter.voteid.Value);
}
command.CommandText = command.CommandText.Replace("#STRWHERE#", command.QueryConditionString);
}
public ActionResult VoteStatisticsQuery(int?voteid)
{
//VoteFilter filter = BuildQueryFilterEntity<VoteFilter>();
VoteFilter filter = new VoteFilter()
{
voteid = voteid
};
var result = _basisService.StatisticsVoteItem(filter);
return(Json(new AjaxResult()
{
Success = true, Data = result
}, JsonRequestBehavior.AllowGet));
}
public IActionResult VoteCount([FromRoute] int touristSpotId)
{
try
{
var filter = new VoteFilter {
TouristSpotId = touristSpotId
};
var results = this.voteAppService.Count(filter);
return(this.Response(results));
}
catch (SnowmanLabsChallengeException slcex)
{
return(this.Response(slcex));
}
catch (Exception ex)
{
return(this.Response(ex));
}
}
/// <summary>
/// 查询
/// </summary>
/// <param name="filter">id</param>
/// <returns></returns>
public static QueryResult <VoteVO> SearchVotePageLists(VoteFilter filter)
{
var cmd = new DataCommand("VotingEvents.SearchVoteLists");
return(cmd.Query <VoteVO>(filter, "t.start_time", null, true));
}
/// <summary>
/// 查询统计
/// </summary>
/// <param name="filter"></param>
/// <returns></returns>
public List <VoteStatisticsView> StatisticsVoteItem(VoteFilter filter)
{
return(VotingEventsDA.StatisticsVoteItem(filter));
}
/// <summary>
/// 查询
/// </summary>
/// <param name="filter">id</param>
/// <returns></returns>
public QueryResult <VoteVO> SearchVotePageLists(VoteFilter filter)
{
return(VotingEventsDA.SearchVotePageLists(filter));
}
public ActionResult VoteQuery()
{
VoteFilter filter = BuildQueryFilterEntity <VoteFilter>();
return(AjaxGridJson(_basisService.SearchVotePageLists(filter)));
}
