예제 #1
0
        private void wqd_stuList_Load(object sender, EventArgs e)
        {
            BindCmbKSMC();
            DataTable dtStudents = examModel.GetList(combSql()).Tables[0];

            dgvList.DataSource = dtStudents;

            TitleDgvBillList();
        }
예제 #2
0
 private void txtStuName_TextChanged(object sender, EventArgs e)
 {
     if (checkTxt())
     {
         DataTable dt = new db_students().GetList(" stuName='" + txtStuName.Text.Trim() + "' and idcard='" + txtIdCard.Text.Trim() + "' and examNameID='" + publicModel.examName + "'").Tables[0];
         if (dt.Rows.Count > 0)
         {
             lblExamNo.Text = dt.Rows[0]["stuno"].ToString();
         }
         else
         {
             lblExamNo.Text = "--";
         }
         DataTable dtExam = examModel.GetList(" name like'" + txtStuName.Text.Trim() + "%' and idcard like'" + txtIdCard.Text.Trim() + "%' and examNameID='" + publicModel.examName + "'").Tables[0];
         dgvList.DataSource = dtExam;
         TitleDgvBillList();
     }
 }