//添加记录
public static bool Insert(CriminalBasicInfoTable user)
{
using (CriminalDbContext db = new CriminalDbContext())
{
db.CriminalBasicInfo.Add(user);
return(db.SaveChanges() > 0); //保存数据
}
}
//修改记录
public static bool Update(CriminalBasicInfoTable user)
{
using (CriminalDbContext db = new CriminalDbContext())
{
db.CriminalBasicInfo.Attach(user);
db.Entry(user).State = System.Data.Entity.EntityState.Modified;
return(db.SaveChanges() > 0);
}
}
//删除记录(User中应包含主键ID值)
public static bool Delete(CriminalBasicInfoTable user)
{
using (CriminalDbContext db = new CriminalDbContext())
{
db.CriminalBasicInfo.Attach(user);
db.CriminalBasicInfo.Remove(user);
return(db.SaveChanges() > 0);
}
}
//删除
private void Button2_Click(object sender, EventArgs e)
{
var cr = new CriminalBasicInfoTable();
cr.criminalID = dataGridView1.CurrentRow.Cells[0].Value.ToString();
ButtonAction.Delete(cr);
MessageBox.Show("删除成功!");
dataGridView1.DataSource = ButtonAction.GetAll();
}
//保存//更新
private void Button5_Click(object sender, EventArgs e)
{
var st = new CriminalBasicInfoTable();
try
{
st.criminalID = dataGridView1.CurrentRow.Cells[0].Value.ToString();
st.criminalName = dataGridView1.CurrentRow.Cells[1].Value.ToString();
st.IDNumber = dataGridView1.CurrentRow.Cells[2].Value.ToString();
st.imprisonTime = DateTime.Parse(dataGridView1.CurrentRow.Cells[3].Value.ToString());
st.imprisonReason = dataGridView1.CurrentRow.Cells[4].Value.ToString();
st.prisonTerm = float.Parse(dataGridView1.CurrentRow.Cells[5].Value.ToString());
st.RFIDNumber = dataGridView1.CurrentRow.Cells[6].Value.ToString();
st.predecessorFileNumber = dataGridView1.CurrentRow.Cells[7].Value.ToString();
ButtonAction.Insert(st);
var st2 = new CriminalBasicInfoTable
{
criminalID = "null",
imprisonTime = DateTime.Parse("1900/01/01"),
prisonTerm = 0
};
ButtonAction.Insert(st2);
MessageBox.Show("保存成功！");
dataGridView1.DataSource = ButtonAction.GetAll();
}
catch (Exception)
{
try
{
st.criminalID = dataGridView1.CurrentRow.Cells[0].Value.ToString();
st.criminalName = dataGridView1.CurrentRow.Cells[1].Value.ToString();
st.IDNumber = dataGridView1.CurrentRow.Cells[2].Value.ToString();
st.imprisonTime = DateTime.Parse(dataGridView1.CurrentRow.Cells[3].Value.ToString());
st.imprisonReason = dataGridView1.CurrentRow.Cells[4].Value.ToString();
st.prisonTerm = float.Parse(dataGridView1.CurrentRow.Cells[5].Value.ToString());
st.RFIDNumber = dataGridView1.CurrentRow.Cells[6].Value.ToString();
st.predecessorFileNumber = dataGridView1.CurrentRow.Cells[7].Value.ToString();
ButtonAction.Update(st);
MessageBox.Show("保存成功！");
dataGridView1.DataSource = ButtonAction.GetAll();
}
catch (Exception)
{
MessageBox.Show("请输入完整！");
}
}
}