/// <summary>
///
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void DataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (dataGridView1.Columns[e.ColumnIndex].Name == "colBtn_drop")
{
WorkShop model = new WorkShop();
model.Id = Convert.ToInt32(dataGridView1.Rows[e.RowIndex].Cells["id"].Value);
if (WorkShopHelper.Drop(model, new List <string>()
{
"id"
}))
{
ShowDataGird(); MessageBox.Show("删除成功", "", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
if (dataGridView1.Columns[e.ColumnIndex].Name == "colBtn_alter")
{
WorkShop model = new WorkShop();
model.Id = Convert.ToInt32(dataGridView1.Rows[e.RowIndex].Cells["Id"].Value);
model.master = dataGridView1.Rows[e.RowIndex].Cells["master"].Value.ToString();
model.name = dataGridView1.Rows[e.RowIndex].Cells["name"].Value.ToString();
model.sum = Convert.ToInt32(dataGridView1.Rows[e.RowIndex].Cells["sum"].Value);
if (WorkShopHelper.AlterByPK(model, "id"))
{
ShowDataGird(); MessageBox.Show("修改成功", "", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
/// <summary>
/// 显示数据网格控件
/// </summary>
public void ShowDataGird()
{
this.dataGridView1.DataSource = null;
this.dataGridView1.Columns.Clear();
List <WorkShop> list = WorkShopHelper.FindList(new WorkShop(), new List <string>());
dataGridView1.DataSource = list;
dataGridView1.Columns["name"].HeaderText = "车间名";
dataGridView1.Columns["master"].HeaderText = "车间负责人";
dataGridView1.Columns["sum"].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);
}
/// <summary>
///
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Button1_Click(object sender, EventArgs e)
{
if (textBox1.Text == "" || textBox2.Text == "" || textBox3.Text == "")
{
MessageBox.Show("请填写完整的新增信息", "", MessageBoxButtons.OK, MessageBoxIcon.Warning); return;
}
WorkShop model = new WorkShop();
model.name = textBox1.Text;
model.master = textBox2.Text;
model.sum = Convert.ToInt32(textBox3.Text);
if (WorkShopHelper.Add(model))
{
ShowDataGird(); MessageBox.Show("添加成功", "", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
