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

        public VotePerViewModel GetVotePerBackViewById(string id)
        {
            const string sql =
                @"SELECT innerid, activityid, num, fullname, mobile, introduction, picture, files, ip,isaudit, remark, openid, createrid, createdtime, modifierid, modifiedtime,
                    (select count(1) from activity_vote_log where perid=a.innerid and invalid=0) as votenum,
                    (select count(1) from activity_vote_log where perid=a.innerid and openid='') as fakevotenum ,
                    (select count(1) from activity_vote_log where perid=a.innerid and invalid=1) as invalidvotenum ,
                    FROM activity_vote_per as a where innerid=@innerid";
            var model = Helper.Query<VotePerViewModel>(sql, new { innerid = id }).FirstOrDefault();
            return model;
        }