示例#1
0
 private void btnPrint_Click(object sender, EventArgs e)
 {
     if (this.dataGridView1.SelectedRows.Count > 0)
     {
         int        myorder   = int.Parse(this.dataGridView1.SelectedRows[0].Cells[0].Value.ToString());
         DALStudent myStudent = new DALStudent();
         Candidate  cand      = myStudent.ReadyQueryWithKey(myorder.ToString());
         if (cand != null)
         {
             DoPrint(cand);
         }
     }
 }
示例#2
0
        //有条件查询
        private void SearchBind()
        {
            lblTotel.Text = "总人数:";
            lblPass.Text  = "合格人数:";
            lbkHGL.Text   = "合格率:";

            bool   flag    = false;
            string strCond = "";

            if (this.checkBox1.Checked != true)
            {
                flag    = true;
                strCond = " DATEDIFF(d,'" + this.txtDate.Text + "',KSRQ)=0 ";
            }
            //日期


            //姓名、身份证号、准考证号
            if (radioButton1.Checked == true && this.txtName.Text != "")
            {
                if (flag)
                {
                    flag     = true;
                    strCond += " and XM='" + this.txtName.Text.Trim() + "'";
                }
                else
                {
                    flag     = true;
                    strCond += "  XM='" + this.txtName.Text.Trim() + "'";
                }
            }
            if (radioButton2.Checked == true && this.txtSTZH.Text != "")
            {
                if (flag)
                {
                    flag     = true;
                    strCond += " and SFZMHM='" + this.txtSTZH.Text.Trim() + "'";
                }
                else
                {
                    flag     = true;
                    strCond += "  SFZMHM='" + this.txtSTZH.Text.Trim() + "'";
                }
            }
            if (radioButton3.Checked == true && this.txtZKZH.Text != "")
            {
                if (flag)
                {
                    flag     = true;
                    strCond += " and ZKZMBH='" + this.txtZKZH.Text.Trim() + "'";
                }
                else
                {
                    flag     = true;
                    strCond += "  ZKZMBH='" + this.txtZKZH.Text.Trim() + "'";
                }
            }

            DALStudent myStudent = new DALStudent();
            DataTable  dt        = null;

            try
            {
                dt = myStudent.ReadyQuery(strCond);
            }
            catch
            {
                this.dataGridView1.DataSource = null;
                MessageBox.Show("数据库读写错误");
                return;
            }

            if (dt.Rows.Count != 0)
            {
                this.dataGridView1.DataSource = dt;
                if (this.dataGridView1.Rows.Count != 0)
                {
                    if (checkBox1.Checked == false)
                    {
                        int ToltoKsrs   = myStudent.getToltoKsrs(this.txtDate.Text);
                        int ToltohgKsrs = myStudent.getToltohgKsrs(this.txtDate.Text);
                        lblTotel.Text = "总人数:" + ToltoKsrs.ToString();
                        lblPass.Text  = "合格人数:" + ToltohgKsrs.ToString();
                        if (ToltoKsrs != 0)
                        {
                            this.lbkHGL.Text = "合格率:" + ((ToltohgKsrs * 100) / (ToltoKsrs)).ToString() + "%";
                        }
                    }
                }
                FormatTable();
            }
            else
            {
                this.dataGridView1.DataSource = null;
            }
            this.txtSTZH.Text = "";
            this.txtName.Text = "";
            this.txtZKZH.Text = "";
        }