CCN.Modules.Activity.DataAccess.ActivityDataAccess.GetVoteViewById C# (CSharp) Метод

        public VoteViewModel GetVoteViewById(string id)
        {
            const string sql =
                @"SELECT innerid, title, subtitle, enrollstarttime, enrollendtime, votestarttime, voteendtime,awardstime,votemode,voteflow,prizedeac, awardstime, attention, createrid, createdtime, modifierid, modifiedtime,
                (select count(1) from activity_vote_per where activityid=a.innerid and isaudit=1) as numper,
                (select count(1) from activity_vote_log where activityid=a.innerid and invalid=0) as numvote FROM activity_vote_info as a where innerid=@innerid";
            var model = Helper.Query<VoteViewModel>(sql, new {innerid = id}).FirstOrDefault();
            return model;
        }