/// <summary> /// 用户删除操作 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnUdelete2_Click(object sender, EventArgs e) { BLL.UsersBLL objUB = new BLL.UsersBLL(); if (dataGridView2.SelectedRows.Count > 0) { if (MessageBox.Show("确认要删除该行数据吗?", "删除确认", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK) { int rst = dataGridView2.SelectedRows.Count; foreach (DataGridViewRow dr in dataGridView2.SelectedRows) { DAL.Users objU = new DAL.Users(); objU.uid = (int)dr.Cells["uid"].Value; rst -= objUB.Delete(objU); } if (rst == 0) { MessageBox.Show("删除成功"); BLL.UsersBLL objU = new BLL.UsersBLL(); dataGridView2.DataSource = objU.GetList(x => true); dataGridView2.Refresh(); } else { MessageBox.Show("删除失败"); } } } else { MessageBox.Show("请先选中要删除的数据"); } }
/// <summary> /// 用户账户查询 /// </summary> /// <param name="sender"></param> /// <param name="e"></param>W private void btnUsearch_Click(object sender, EventArgs e) { if (string.IsNullOrWhiteSpace(txtUsearch.Text)) { MessageBox.Show("请输入要查询的学生的学号"); } else { BLL.UsersBLL objU = new BLL.UsersBLL(); dataGridView2.DataSource = objU.GetList(x => x.uid == Convert.ToInt32(txtUsearch.Text.ToString())); dataGridView2.Refresh(); } }
private void btnUModify_Click(object sender, EventArgs e) { if (dataGridView2.SelectedRows.Count == 1) { frmUserUpdate frmUserUpdate = new frmUserUpdate(); frmUserUpdate.ID = (int)(dataGridView2.SelectedRows[0].Cells["uid"].Value); frmUserUpdate.ShowDialog(); BLL.UsersBLL objU = new BLL.UsersBLL(); dataGridView2.DataSource = objU.GetList(x => true); dataGridView2.Refresh(); } else { MessageBox.Show("请先选中要修改的一行数据"); } }
private void frmUsers_Load(object sender, EventArgs e) { this.label1.Parent = pictureBox1; this.label1.BackColor = Color.FromArgb(0, Color.Transparent); this.label2.Parent = pictureBox1; this.label2.BackColor = Color.FromArgb(0, Color.Transparent); this.label3.Parent = pictureBox1; this.label3.BackColor = Color.FromArgb(0, Color.Transparent); this.label4.Parent = pictureBox1; this.label4.BackColor = Color.FromArgb(0, Color.Transparent); this.label5.Parent = pictureBox1; this.label5.BackColor = Color.FromArgb(0, Color.Transparent); this.label6.Parent = pictureBox1; this.label6.BackColor = Color.FromArgb(0, Color.Transparent); this.label9.Parent = pictureBox1; this.label9.BackColor = Color.FromArgb(0, Color.Transparent); this.rbMale.Parent = pictureBox1; this.rbMale.BackColor = Color.FromArgb(0, Color.Transparent); this.rbFemale.Parent = pictureBox1; this.rbFemale.BackColor = Color.FromArgb(0, Color.Transparent); BLL.UsersBLL objU = new BLL.UsersBLL(); dataGridView2.DataSource = objU.GetList(x => true); dataGridView2.Refresh(); BLL.UserGoodsBLL objUB = new BLL.UserGoodsBLL(); dataGridView1.DataSource = objUB.GetList(x => true); dataGridView1.Refresh(); dataGridView2.Columns[0].HeaderCell.Value = "学生ID"; dataGridView2.Columns[1].HeaderCell.Value = "姓名"; dataGridView2.Columns[2].HeaderCell.Value = "性别"; dataGridView2.Columns[3].HeaderCell.Value = "密码"; dataGridView2.Columns[4].HeaderCell.Value = "学校"; dataGridView1.Columns[0].HeaderCell.Value = "学生ID"; dataGridView1.Columns[1].HeaderCell.Value = "商品ID"; dataGridView1.Columns[2].HeaderCell.Value = "商品类别"; dataGridView1.Columns[3].HeaderCell.Value = "商品名称"; dataGridView1.Columns[4].HeaderCell.Value = "商品价格"; dataGridView1.Columns[5].HeaderCell.Value = "商品状态"; }
private void button4_Click(object sender, EventArgs e) { BLL.UsersBLL objU = new BLL.UsersBLL(); dataGridView2.DataSource = objU.GetList(x => true); dataGridView2.Refresh(); }
private void BindGrid() { BLL.UsersBLL objB = new BLL.UsersBLL(); dataGridView2.DataSource = objB.GetList(x => x.uid == int.Parse(txtUsearch.Text)); dataGridView2.Refresh(); }