Ejemplo n.º 1
0
        /// <summary>
        /// 設定領域名稱
        /// </summary>
        public static void SetDomainList()
        {
            DomainNameList.Clear();

            // 從學生修課動態取得科目領域名稱
            if (_SelStudentIDList.Count > 0 && _SelSchoolYear > 0 && _SelSemester > 0 && _SelExamID != "")
            {
                QueryHelper qh     = new QueryHelper();
                string      strSQL = "SELECT DISTINCT " +
                                     "domain " +
                                     "FROM " +
                                     "sc_attend " +
                                     "INNER JOIN " +
                                     "course " +
                                     "ON sc_attend.ref_course_id=course.id " +
                                     "INNER JOIN te_include " +
                                     "ON course.ref_exam_template_id = te_include.ref_exam_template_id " +
                                     "WHERE sc_attend.ref_student_id IN(" + string.Join(",", _SelStudentIDList.ToArray()) + ") " +
                                     "AND course.school_year=" + _SelSchoolYear + " " +
                                     "AND course.semester=" + _SelSemester + " " +
                                     "AND te_include.ref_exam_id = " + _SelExamID + " AND domain <>'';";
                DataTable dt = qh.Select(strSQL);

                foreach (DataRow dr in dt.Rows)
                {
                    string domain = dr["domain"].ToString();
                    if (!DomainNameList.Contains(domain))
                    {
                        DomainNameList.Add(domain);
                    }
                }
            }
            else
            {
                // 預設
                DomainNameList.Add("國語文");
                DomainNameList.Add("英語");
                DomainNameList.Add("數學");
                DomainNameList.Add("社會");
                DomainNameList.Add("自然與生活科技");
                DomainNameList.Add("自然科學");
                DomainNameList.Add("藝術");
                DomainNameList.Add("健康與體育");
                DomainNameList.Add("藝術與人文");
                DomainNameList.Add("綜合活動");
                DomainNameList.Add("彈性課程");
                DomainNameList.Add("科技");
                DomainNameList.Add("特殊需求");
            }

            if (!DomainNameList.Contains("彈性課程"))
            {
                DomainNameList.Add("彈性課程");
            }
        }
Ejemplo n.º 2
0
        void ListDomainWebResponse(object sender, ResponseEventArgs args)
        {
            ISimpleDBResponse result = args.Response;

            SimpleDB.Client.OnSimpleDBResponse -= ListDomainWebResponse;

            if (result is AmazonSimpleDBException)
            {
                this.Dispatcher.BeginInvoke(() =>
                {
                    this.ListDomainMessage = "Error: " + ((AmazonSimpleDBException)result).Message;
                });
                return;
            }

            ListDomainsResponse response = (ListDomainsResponse)result;

            this.Dispatcher.BeginInvoke(() =>
            {
                DomainNameList.Clear();
                response.ListDomainsResult.DomainName.ForEach(b => DomainNameList.Add(b));
                this.ListDomainMessage = "No of Domains: " + response.ListDomainsResult.DomainName.Count;
            });
        }