/// <summary>
        /// 获取支持的章节类型列表
        /// </summary>
        /// <param name="chapterTypeList"></param>
        /// <returns></returns>
        public bool GetChapterTypeList(out List <ChapterType> chapterTypeList, bool isFilter = false)
        {
            chapterTypeList = new List <ChapterType>();
            try
            {
                string            sql = @"select * from group_type where id<@data";
                SQLiteParameter[] sqlPara;
                if (isFilter)
                {
                    sqlPara = new SQLiteParameter[] { new SQLiteParameter("@data", 3) }
                }
                ;
                else
                {
                    sqlPara = new SQLiteParameter[] { new SQLiteParameter("@data", 10) }
                };

                DataTable data = SQLiteHelper.SQLiteHelper.GetDataTable(sql, sqlPara);
                foreach (DataRow row in data.Rows)
                {
                    ChapterType typeData = new ChapterType();
                    typeData.ID   = Convert.ToInt32(row["id"].ToString());
                    typeData.Name = row["name"].ToString();
                    chapterTypeList.Add(typeData);
                }

                return(true);
            }
            catch (Exception ex)
            {
                return(false);
            }
        }
        private void cboxSkill_SelectedIndexChanged(object sender, EventArgs e)
        {
            if (cboxSkill.SelectedItem == null)
            {
                return;
            }

            ChapterType chapterType = (ChapterType)cboxSkill.SelectedItem;

            _Type = chapterType.ID;

            RefreshGroups();
        }
Beispiel #3
0
        private void cboxChaperType_SelectedIndexChanged(object sender, EventArgs e)
        {
            if (cboxChaperType.SelectedIndex < 0)
            {
                return;
            }

            isLoadSuccess = false;
            ChapterType chapterType = (ChapterType)cboxChaperType.SelectedItem;

            ChapterManager.GetChapterList(chapterType.ID, out List <ChapterInfo> chapterInfoList);

            comboBoxChapter.Items.Clear();
            ChapterInfo modelNull = new ChapterInfo();

            modelNull.ID   = 0;
            modelNull.Name = "全部";
            comboBoxChapter.Items.Add(modelNull);

            ChapterInfo modelNotSplit = new ChapterInfo();

            modelNotSplit.ID   = -1;
            modelNotSplit.Name = "未分类";
            comboBoxChapter.Items.Add(modelNotSplit);

            foreach (ChapterInfo chapterInfo in chapterInfoList)
            {
                comboBoxChapter.Items.Add(chapterInfo);
            }

            comboBoxChapter.SelectedIndex = 0;

            cboxClassification.SelectedIndex = 0;

            comboBoxType.SelectedIndex = 0;

            textBoxFilterTittle.Text = "";

            isLoadSuccess = true;

            RefreshQuestions();
            //textBoxFilterOptions.Text = "";
        }
Beispiel #4
0
        public void RefreshDatas(int pageNumber, int currentPage)
        {
            ChapterInfo chapterInfo = (ChapterInfo)comboBoxChapter.SelectedItem;
            ChapterType chapterType = (ChapterType)cboxChaperType.SelectedItem;

            DataTable data = ChpaterQuestionManager.GetChapterQuestions(chapterType.ID, chapterInfo.ID, cboxClassification.SelectedIndex, comboBoxType.SelectedIndex, "%" + textBoxFilterTittle.Text + "%", pageNumber, currentPage);

            dataGridView1.Rows.Clear();
            if (null == data)
            {
                MessageBox.Show("获取题目数据失败");
                return;
            }

            Console.WriteLine(data.Rows.Count);
            foreach (DataRow row in data.Rows)
            {
                AddItem(row);
            }
        }
Beispiel #5
0
        //TODO;更新题目列表
        private void RefreshQuestions()
        {
            if (false == isLoadSuccess)
            {
                return;
            }


            ChapterInfo chapterInfo = (ChapterInfo)comboBoxChapter.SelectedItem;
            ChapterType chapterType = (ChapterType)cboxChaperType.SelectedItem;
            //ChpaterQuestionManager.GetChapterQuestionsCount(chapterType.ID, chapterInfo.ID, cboxClassification.SelectedIndex, comboBoxType.SelectedIndex);

            int dataCount = ChpaterQuestionManager.GetChapterQuestionsCount(chapterType.ID, chapterInfo.ID, cboxClassification.SelectedIndex, comboBoxType.SelectedIndex, "%" + textBoxFilterTittle.Text + "%");

            labelQuestionCount.Text = dataCount.ToString();
            pageControl1.BeginUpdate();
            pageControl1.TotalCount = dataCount;

            RefreshDatas(pageControl1.PerPageNumber, pageControl1.CurrentPage);

            pageControl1.EndUpdate();
            //labelQuestionCount.Text = data.Rows.Count.ToString();
        }