Esempio n. 1
0
 //添加记录
 public static bool Insert(CriminalBasicInfoTable user)
 {
     using (CriminalDbContext db = new CriminalDbContext())
     {
         db.CriminalBasicInfo.Add(user);
         return(db.SaveChanges() > 0);  //保存数据
     }
 }
Esempio n. 2
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);
     }
 }
Esempio n. 3
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);
     }
 }
Esempio n. 4
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();
        }
Esempio n. 5
0
        //保存//更新
        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("请输入完整!");
                }
            }
        }