/// <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();
}
