如何仅显示问题的确切数量

在Question set中，我得到了与特定(topicID,Marks)有关的所有问题。我为totqsn随机显示问题，即显示10个问题的总问题数，我将特定标记的问题数（1,2,3,4）的计数分别存储在此int变量mark1Qsn,mark2Qsn,mark3Qsn,mark4Qsn中，使用下面的代码，我可以为totqsn显示问题集中的问题（比如包含34个带有（TopicID，marks）的问题）（比如从问题集中随机显示10个问题）。我的问题是我如何显示总共10个问题，其中3个问题1分，3个问题2分，1个问题3分，3问题4分，即。totqsn(10 questions= 3 qsn_of_mark1 + 3 qsn_of_mark2 + 1 qsn_of_mark3 + 3 qsn_of_mark3)

public partial class GroupExmStart : Form
{        
    DBHandling db = new DBHandling();
    string GrpID = "";
    string TopiID = "";
    int totQsn = 0;
    int mark1qsn = 0;
    int mark2Qsn = 0;
    int mark3Qsn = 0;
    int mark4Qsn = 0;
    int tik = 0;
    string QuestionSet = "";
    static Random _r = new Random();
    string[] randomQsn = null;
    string[] QAndA = null;
    public GroupExmStart(string GroupName, string DurationID)
    {
        InitializeComponent();
        totQsn = Convert.ToInt16(conf[0]);    
        mark1qsn = Convert.ToInt16(conf[3]);//this variable contains number of question to be display of mark 1
        mark2Qsn = Convert.ToInt16(conf[4]);
        mark3Qsn = Convert.ToInt16(conf[5]);
        mark4Qsn = Convert.ToInt16(conf[6]); 
        QuestionSet = db.GetQuestions(TopiID, "1");
        QuestionSet = QuestionSet + db.GetQuestions(TopiID, "2");
        QuestionSet = QuestionSet + db.GetQuestions(TopiID, "3");
        QuestionSet = QuestionSet + db.GetQuestions(TopiID, "4");
        int z = Quiz(QuestionSet);
        foreach (string qa in QAndA.OrderBy(i => _random.Next()))
        {
            if (qa != null)
                if (qa.IndexOf('~') != -1)
                {
                    randomQsn[count] = qa;
                    count++;
                    if (count == totQsn)
                        break;
                }
        }
        int Quiz(string data)
        {
            string[] words = data.Split('$');
            randomQsn = new string[totQsn + 1];
            QAndA = new string[words.Length + 1];
            for (int i = 0; i < words.Length; i++)
            {
                QAndA[i] = words[i];
            }
            return 0;
        }
    }
}

从DBHandling类访问GetQuestions方法

public string GetQuestions(string TopicID, string Marks)
{
    string data = "";
    try
    {
        string sql = "select QID,Question,Opt1,Opt2,Opt3,Opt4,AnsOp,Marks from Questions where TopicID IN(" + TopicID + ") and Marks=" + Marks;
        cmd = new OleDbCommand(sql, acccon);
        rs = cmd.ExecuteReader();
        while (rs.Read())
        {
            data = data + rs[0].ToString() + "~" + rs[1].ToString() + "~" + rs[2].ToString() + "~" + rs[3].ToString() + "~" + rs[4].ToString() + "~" + rs[5].ToString() + "~" + rs[6].ToString() + "~" + rs[7].ToString() + "$";
        }
    }
    catch (Exception err)
    {
        MessageBox.Show(err.Message.ToString());
    }
    return data;
}

提前感谢的任何帮助

 public class Question
    {
        public string Id { get; set; }
        public string Text { get; set; }
        public string Option1 { get; set; }
        public string Option2 { get; set; }
        public string Option3 { get; set; }
        public string Option4 { get; set; }
        public string AnswerOption { get; set; }
        public int Marks { get; set; }
    }
    public IEnumerable<Question> GetQuestions(string topicId, int marks)
    {
        string sql = "select QID,Question,Opt1,Opt2,Opt3,Opt4,AnsOp,Marks from Questions where TopicID IN(" +
                     topicId + ") and Marks=" + marks.ToString();
        var cmd = new OleDbCommand(sql, new OleDbConnection(""));
        var rs = cmd.ExecuteReader();
        if (rs != null)
        {
            while (rs.Read())
            {
                yield return
                    new Question
                        {
                            Id = rs[0].ToString(),
                            Text = rs[1].ToString(),
                            Option1 = rs[2].ToString(),
                            Option2 = rs[3].ToString(),
                            Option3 = rs[4].ToString(),
                            Option4 = rs[5].ToString(),
                            AnswerOption = rs[6].ToString(),
                            Marks = marks
                        };
            }
        }
    }
    public void Foo()
    {
        var totQsn = Convert.ToInt16(conf[0]); // isn't this just the sum of everything else?
        var mark1qsn = Convert.ToInt16(conf[3]); //this variable contains number of question to be display of mark 1
        var mark2qsn = Convert.ToInt16(conf[4]);
        var mark3Qsn = Convert.ToInt16(conf[5]);
        var mark4Qsn = Convert.ToInt16(conf[6]);
        var mark1questionSet = GetQuestions(topicId, 1).ToList();
        var mark2questionSet = GetQuestions(topicId, 2).ToList();
        // etc
        var finalQuestions = new List<Question>();
        for (int i = 0; i < mark1qsn; i++)
        {
            var setIndex = _random.Next(mark1questionSet.Count);
            finalQuestions.Add(mark1questionSet[setIndex]);
            mark1questionSet.RemoveAt(setIndex);
        }
        for (int i = 0; i < mark2qsn; i++)
        {
            var setIndex = _random.Next(mark2questionSet.Count);
            finalQuestions.Add(mark2questionSet[setIndex]);
            mark2questionSet.RemoveAt(setIndex);
        }
        // etc - put this into a method or something
    }