private void DataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (dataGridView1.Columns[e.ColumnIndex].Name == "colBtn_drop")
{
Lend model = new Lend();
model.id = Convert.ToInt32(dataGridView1.Rows[e.RowIndex].Cells["id"].Value);
if (LendHelper.Drop(model, new List <string>()
{
"id"
}))
{
ShowDataGird(); MessageBox.Show("删除成功", "", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
if (dataGridView1.Columns[e.ColumnIndex].Name == "colBtn_alter")
{
Lend model = new Lend();
model.id = Convert.ToInt32(dataGridView1.Rows[e.RowIndex].Cells["Id"].Value);
model.name = dataGridView1.Rows[e.RowIndex].Cells["name"].Value.ToString();
model.bookname = dataGridView1.Rows[e.RowIndex].Cells["bookname"].Value.ToString();
model.date = dataGridView1.Rows[e.RowIndex].Cells["date"].Value.ToString();
if (LendHelper.AlterByPK(model, "id"))
{
ShowDataGird(); MessageBox.Show("修改成功", "", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
/// <summary>
/// 显示数据网格控件
/// </summary>
public void ShowDataGird()
{
this.dataGridView1.DataSource = null;
this.dataGridView1.Columns.Clear();
List <Lend> list = LendHelper.FindList(new Lend(), new List <string>());
dataGridView1.DataSource = list;
dataGridView1.Columns["name"].HeaderText = "借阅人";
dataGridView1.Columns["bookname"].HeaderText = "图书名";
dataGridView1.Columns["date"].HeaderText = "借阅日期";
dataGridView1.Columns["id"].Visible = false;
DataGridViewButtonColumn col_Btn_alter = new DataGridViewButtonColumn();
col_Btn_alter.Name = "colBtn_alter";
col_Btn_alter.HeaderText = "";
col_Btn_alter.DefaultCellStyle.NullValue = "修改";
dataGridView1.Columns.Add(col_Btn_alter);
DataGridViewButtonColumn col_Btn_Drop = new DataGridViewButtonColumn();
col_Btn_Drop.Name = "colBtn_drop";
col_Btn_Drop.HeaderText = "";
col_Btn_Drop.DefaultCellStyle.NullValue = "删除";
dataGridView1.Columns.Add(col_Btn_Drop);
}
private void Button1_Click(object sender, EventArgs e)
{
if (textBox1.Text == "" || textBox2.Text == "" || textBox3.Text == "")
{
MessageBox.Show("请填写完整的新增信息", "", MessageBoxButtons.OK, MessageBoxIcon.Warning); return;
}
Lend model = new Lend();
model.name = textBox1.Text;
model.bookname = textBox2.Text;
model.date = textBox2.Text;
if (LendHelper.Add(model))
{
ShowDataGird(); MessageBox.Show("添加成功", "", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}