private void button4_Click(object sender, EventArgs e)
{
netEntities1 db = new netEntities1();
if (dataGridView1.SelectedRows.Count > 0)
{
string id = dataGridView1.SelectedRows[0].Cells["spid"].Value.ToString();
sp new1 = db.sp.SingleOrDefault(a => a.spid == id);
db.sp.Remove(new1);
db.SaveChanges();
MessageBox.Show("删除成功！");
var sj = from a in db.sp select new { a.spid, a.spname, a.spgysid, a.spzlid };
dataGridView1.DataSource = sj.ToList();
}
else
{
MessageBox.Show("请先选择行！");
}
}
private void button1_Click(object sender, EventArgs e)
{
netEntities1 db = new netEntities1();
sp new1 = new sp();
new1.spzlid = Convert.ToString(comboBox2.SelectedValue);
new1.spgysid = Convert.ToString(comboBox1.SelectedValue);
if (mode == "insert")
{
string a = DateTime.Now.Ticks.ToString();
a = a.Substring(a.Length - 7);
new1.spid = a;
db.sp.Add(new1);
}
if (mode == "update")
{
new1.spid = label5.Text;
db.Entry <sp>(new1).State = EntityState.Modified;
}
new1.spname = textBox1.Text;
db.SaveChanges();
DialogResult = System.Windows.Forms.DialogResult.OK;
}