예제 #1
0
        private void button6_Click(object sender, EventArgs e)//确认修改
        {
            StudentData studentData = new StudentData();

            studentData.StuNo      = textBox2.Text;
            studentData.StuPwd     = textBox3.Text;
            studentData.StuName    = textBox4.Text;
            studentData.StuNianji  = textBox5.Text;
            studentData.Academy    = textBox6.Text;
            studentData.Profession = textBox7.Text;
            studentData.StuClass   = Convert.ToInt32(textBox8.Text);
            studentData.Grade      = Convert.ToInt32(textBox9.Text);

            ad_ServicesBLL BLL = new ad_ServicesBLL();

            if (BLL.UpdateStudatabll(studentData) > 0)
            {
                MessageBox.Show("修改成功", "提示", MessageBoxButtons.OK);
                textBox2.Text = "";
                textBox3.Text = "";
                textBox4.Text = "";
                textBox5.Text = "2016";
                textBox6.Text = "";
                textBox7.Text = "";
                textBox8.Text = "";
                textBox9.Text = "";
                DataTable table = BLL.SelectStubll();
                dataGridView1.DataSource = table;
            }
            else
            {
                MessageBox.Show("更新失败", "提示", MessageBoxButtons.OKCancel);
            }
        }
예제 #2
0
        private void StudentList_Load(object sender, EventArgs e)
        {
            ad_ServicesBLL BLL          = new ad_ServicesBLL();
            DataTable      studentTable = BLL.SelectStubll();

            dataGridView1.DataSource = studentTable;
            textBox5.Text            = "2016";
        }
예제 #3
0
        private void button7_Click_1(object sender, EventArgs e)//删除
        {
            string         id  = dataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells[0].Value.ToString();
            ad_ServicesBLL bLL = new ad_ServicesBLL();

            if (bLL.RemoveStudata(id))
            {
                MessageBox.Show("删除成功", "提示", MessageBoxButtons.OK);
                ad_ServicesBLL BLL   = new ad_ServicesBLL();
                DataTable      table = BLL.SelectStubll();
                dataGridView1.DataSource = table;
            }
            else
            {
                MessageBox.Show("删除失败", "提示", MessageBoxButtons.OK);
            }
        }
예제 #4
0
        private void button5_Click(object sender, EventArgs e)//添加单个信息
        {
            ad_ServicesBLL BLL         = new ad_ServicesBLL();
            StudentData    studentData = new StudentData();

            studentData.StuNo      = textBox2.Text;
            studentData.StuPwd     = textBox3.Text;
            studentData.StuName    = textBox4.Text;
            studentData.StuNianji  = textBox5.Text;
            studentData.Academy    = textBox6.Text;
            studentData.Profession = textBox6.Text;
            studentData.StuClass   = Convert.ToInt32(textBox8.Text);
            studentData.Grade      = Convert.ToInt32(textBox9.Text);
            //if (BLL.Check(studentData.StuNo))//true代表数据库中已有该值
            //{
            //    MessageBox.Show("该学号已存在,不可重复录入", "警示", MessageBoxButtons.OK);
            //}
            //else
            //{
            if (BLL.InsertStubll(studentData))
            {
                MessageBox.Show("导入成功", "提示", MessageBoxButtons.OK);
                textBox2.Text = "";
                textBox3.Text = "";
                textBox4.Text = "";
                textBox5.Text = "";
                textBox6.Text = "";
                textBox7.Text = "";
                textBox8.Text = "";
                textBox9.Text = "";
                DataTable table = BLL.SelectStubll();
                dataGridView1.DataSource = table;
            }
            else
            {
                MessageBox.Show("导入失败", "提示", MessageBoxButtons.OKCancel);
            }
            //}
        }