/// <summary> /// 修改事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void button2_Click(object sender, EventArgs e) { if (Fnumber.Text == "") { MessageBox.Show("请选择要修改的记录", "警告"); return; } linq = new MydatabaseDataContext(strsql); var result = from info in linq.T_LoginInfo where info.fnumber == Convert.ToInt32(Fnumber.Text) select info; //用foreach进行循环 foreach (T_LoginInfo info in result) { info.FNAME = Fname.Text; info.FSEX = Convert.ToChar(FSEX.Text); info.FTEL = FTEL.Text; info.FADRESS = FADRESS.Text; linq.SubmitChanges(); } MessageBox.Show("修改成功!", "提示"); SelectInfo(); }
/// <summary> /// 添加信息事件 /// </summary> private void button1_Click(object sender, EventArgs e) { linq = new MydatabaseDataContext(strsql); T_LoginInfo LoInFo = new T_LoginInfo();//创建员工信息表实体 LoInFo.fnumber = Convert.ToInt32(this.Fnumber.Text); LoInFo.FNAME = this.Fname.Text; LoInFo.FSEX = Convert.ToChar(this.FSEX.Text); LoInFo.FTEL = this.FTEL.Text; LoInFo.FADRESS = this.FADRESS.Text; linq.T_LoginInfo.InsertOnSubmit(LoInFo); //添加实体 linq.SubmitChanges(); //提交操作 SelectInfo(); }
/// <summary> /// 右键审核操作 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void 除ToolStripMenuItem_Click(object sender, EventArgs e) { if (Fnumber.Text == "") { MessageBox.Show("请选择要删除的记录", "警告"); return; } linq = new MydatabaseDataContext(strsql); var result = from info in linq.T_LoginInfo where info.fnumber == Convert.ToInt32(Fnumber.Text) select info; linq.T_LoginInfo.DeleteAllOnSubmit(result); linq.SubmitChanges(); MessageBox.Show("删除成功!", "提示"); SelectInfo(); }