/// <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();
}
