C# QueryHelper类代码示例

        public Absence_EmailNotification()
        {
            InitializeComponent();

            Access = new AccessHelper();
            Query = new QueryHelper();
        }

 protected override void OnPrimaryKeyChangedAsync()
 {
     string studentID = this.PrimaryKey;
     //1.取得修課紀錄
     QueryHelper q = new QueryHelper();
     string sql = @"select ref_course_id
                             from $ischool.emba.scattend_ext att inner join course c on c.id = att.ref_course_id
                             where att.ref_student_id={0} and c.school_year={1} and c.semester={2}";
     //string schoolyear = K12.Data.School.DefaultSchoolYear;
     //string semester = K12.Data.School.DefaultSemester;
     DataTable dt = q.Select(string.Format(sql, studentID, this.SchoolYear, this.Semester));
     this.attRecords = new List<string>();
     foreach (DataRow dr in dt.Rows)
     {
         this.attRecords.Add(dr[0].ToString());
     }
     this.attRecords = this.attRecords.Distinct().ToList();
     //2. 取得加退選紀錄
     AccessHelper ah = new AccessHelper();
     this.udtCourses = ah.Select<UDT.AddDropCourse>("ref_student_id='" + this.PrimaryKey + "' and confirm_date is null ");
     this.dicAddDropList = new Dictionary<string, UDT.AddDropCourse>();
     foreach (UDT.AddDropCourse addDrop in this.udtCourses)
     {
         if (!this.dicAddDropList.ContainsKey(addDrop.CourseID.ToString()))
             this.dicAddDropList.Add(addDrop.CourseID.ToString(), addDrop);
     }
 }

        public frmEvaluationConfiguration(bool QueryMode = true)
        {
            InitializeComponent();

            this.dgvData.CurrentCellDirtyStateChanged += new EventHandler(dgvData_CurrentCellDirtyStateChanged);
            this.dgvData.CellEnter += new DataGridViewCellEventHandler(dgvData_CellEnter);
            this.dgvData.EditingControlShowing += new DataGridViewEditingControlShowingEventHandler(dgvData_EditingControlShowing);
            this.dgvData.DataError += new DataGridViewDataErrorEventHandler(dgvData_DataError);
            this.dgvData.ColumnHeaderMouseClick += new System.Windows.Forms.DataGridViewCellMouseEventHandler(this.dgvData_ColumnHeaderMouseClick);
            this.dgvData.RowHeaderMouseClick += new System.Windows.Forms.DataGridViewCellMouseEventHandler(this.dgvData_RowHeaderMouseClick);
            this.dgvData.MouseClick += new System.Windows.Forms.MouseEventHandler(this.dgvData_MouseClick);

            this.Load += new EventHandler(frmTeachingEvaluation_Load);
            dgvData.SortCompare += new DataGridViewSortCompareEventHandler(
                this.DataGridView_SortCompare);

            this.dicTeachersCases = new Dictionary<string, List<string>>();
            this.dicReplys = new Dictionary<string, UDT.Reply>();
            this.dicCourses = new Dictionary<string, CourseRecord>();
            this.dicCourseInstructors = new Dictionary<string, KeyValuePair<string, string>>();
            this.dicCases = new Dictionary<string, List<string>>();
            this.dicSurveys = new Dictionary<string, UDT.Survey>();
            this.dicAssignedSurveys = new Dictionary<string, UDT.AssignedSurvey>();

            this.QueryMode = QueryMode;

            Access = new AccessHelper();
            Query = new QueryHelper();
        }

        /// <summary>
        /// 取得科目中英文對照表
        /// </summary>
        /// <returns></returns>
        public static Dictionary<string,string> SelectAll()
        {
            //"科目中英文對照表"
            //<Content>
            //   <Subject Chinese="國文" English="Chinese"/>
            //   <Subject Chinese="英文" English="English"/>
            //</Content>

            QueryHelper helper = new QueryHelper();

            Dictionary<string, string> result = new Dictionary<string, string>();

            DataTable table = helper.Select("select * from list where name='科目中英文對照表'");

            if (table.Rows.Count == 1)
            {
                string Content = table.Rows[0].Field<string>("content");

                StringReader reader = new StringReader(Content);

                XElement Element = XElement.Load(reader);

                foreach (XElement elmSubject in Element.Elements("Subject"))
                {
                    string Chinese = elmSubject.AttributeText("Chinese");
                    string English = elmSubject.AttributeText("English");

                    if (!result.ContainsKey(Chinese))
                        result.Add(Chinese, English);
                }
            }

            return result;
       }

        public Approach_DetailContent()
        {
            InitializeComponent();

            Access = new AccessHelper();
            Query = new QueryHelper();
            dicSurveyFields = new Dictionary<decimal, IEnumerable<string>>();

            this.Group = "畢業學生進路";
            _RunningKey = "";

            this.Load += new EventHandler(Form_Load);
            this.form_loaded = false;
            _Errors = new ErrorProvider();
            _Listener = new ChangeListener();
            _Listener.Add(new DataGridViewSource(this.dgvData));
            _Listener.Add(new TextBoxSource(this.txtMemo));
            _Listener.Add(new NumericUpDownSource(this.txtSurveyYear));
            _Listener.StatusChanged += new EventHandler<ChangeEventArgs>(Listener_StatusChanged);

            this.dgvData.CellEnter += new DataGridViewCellEventHandler(dgvData_CellEnter);
            this.dgvData.CurrentCellDirtyStateChanged += new EventHandler(dgvData_CurrentCellDirtyStateChanged);
            this.dgvData.DataError += new DataGridViewDataErrorEventHandler(dgvData_DataError);
            this.dgvData.ColumnHeaderMouseClick += new System.Windows.Forms.DataGridViewCellMouseEventHandler(this.dgvData_ColumnHeaderMouseClick);
            this.dgvData.RowHeaderMouseClick += new System.Windows.Forms.DataGridViewCellMouseEventHandler(this.dgvData_RowHeaderMouseClick);
            this.dgvData.MouseClick += new System.Windows.Forms.MouseEventHandler(this.dgvData_MouseClick);

            _BGWLoadData = new BackgroundWorker();
            _BGWLoadData.DoWork += new DoWorkEventHandler(_BGWLoadData_DoWork);
            _BGWLoadData.RunWorkerCompleted += new RunWorkerCompletedEventHandler(_BGWLoadData_RunWorkerCompleted);

            _BGWSaveData = new BackgroundWorker();
            _BGWSaveData.DoWork += new DoWorkEventHandler(_BGWSaveData_DoWork);
            _BGWSaveData.RunWorkerCompleted += new RunWorkerCompletedEventHandler(_BGWSaveData_RunWorkerCompleted);
        }

 private string GetReturnUrl()
 {
     QueryHelper helper = new QueryHelper(this);
     helper.Push("df", this.txtDateFrom.Text);
     helper.Push("dt", this.txtDateTo.Text);
     return helper.OutputReturnUrl();
 }

    private void btnSave_Click(object sender, EventArgs e)
    {
        string classname = txtName.Text.Trim();

            if (classname == String.Empty)
                return;

            QueryHelper queryHelper = new QueryHelper();
            string strQuery = String.Format(@"select class_name from class where class_name='{0}'", classname);

            DataTable dataTable = queryHelper.Select(strQuery);

            if (dataTable == null || dataTable.Rows.Count == 0)
            {
                K12.Data.ClassRecord addRecord = new K12.Data.ClassRecord();

                addRecord.Name = classname;

                string addRecord_ID = K12.Data.Class.Insert(addRecord);
                //Class.Instance.SyncDataBackground(ClassID);   同步處理
                //  log 待處理
                //PermRecLogProcess prlp = new PermRecLogProcess();
                //prlp.SaveLog("學籍.班級", "新增班級", "新增班級,名稱:" + txtName.Text);
                if (chkInputData.Checked)
                    K12.Presentation.NLDPanels.Class.PopupDetailPane(addRecord_ID);
                //Class.Instance.SyncDataBackground(ClassID);   同步處理
            }
            else
            {
                MessageBox.Show("班級名稱重複");
                return;
            }
            this.Close();
    }

 private string GetReturnUrl()
 {
     QueryHelper helper = new QueryHelper(this);
     helper.Push("pd", this.drpPeriod.SelectedValue);
     helper.Push("df", this.txtDateFrom.Text.Trim());
     helper.Push("dt", this.txtDateTo.Text.Trim());
     return helper.OutputReturnUrl();
 }

        public frmCoursePlanUrl()
        {
            queryHelper = new QueryHelper();
            Access = new AccessHelper();

            InitializeComponent();
            this.Load += new EventHandler(frmCoursePlanUrl_Load);
        }

 public Course_Student_List(List<string> CourseIDs)
 {
     this.CourseIDs = CourseIDs;
     this.Query = new QueryHelper();
     this.BGW = new BackgroundWorker();
     this.BGW.DoWork += new DoWorkEventHandler(BGW_DoWork);
     this.BGW.RunWorkerCompleted += new RunWorkerCompletedEventHandler(BGW_RunWorkerCompleted);
 }

 public Student_UpdateRecord_Export_Excel(IEnumerable<string> StudentIDs)
 {
     this.StudentIDs = StudentIDs;
     this.Query = new QueryHelper();
     this.BGW = new BackgroundWorker();
     this.BGW.DoWork += new DoWorkEventHandler(BGW_DoWork);
     this.BGW.RunWorkerCompleted += new RunWorkerCompletedEventHandler(BGW_RunWorkerCompleted);
 }

        public Approach_Export()
        {
            InitializeComponent();

            this.Load += new System.EventHandler(this.Form_Load);
            this.chkSelectAll.CheckedChanged += new System.EventHandler(this.chkSelectAll_CheckedChanged);
            this.selectedFields = new List<string>();
            this.Query = new QueryHelper();
        }

        public frmCSAttendToSnapshot()
        {
            InitializeComponent();

            Query = new QueryHelper();
            Access = new AccessHelper();

            this.Load += new EventHandler(frmCSAttendToSnapshot_Load);
        }

        public TemplateManagement()
        {
            InitializeComponent();

            Access = new AccessHelper();
            Query = new QueryHelper();

            this.Load += new EventHandler(TemplateManagement_Load);
        }

 /// <summary>
 /// 檢查一般學生學號是否重複
 /// </summary>
 /// <param name="number"></param>
 /// <returns></returns>
 public static bool CheckStudentNumberSame1(string number)
 {
     bool retVal = false;
     QueryHelper qh = new QueryHelper();
     string strSQL = "select id from student where status=1 and student_number='"+number+"'";
     DataTable dt= qh.Select(strSQL);
     if (dt.Rows.Count > 0)
         retVal = true;
     return retVal;
 }