private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
{
linq = new MydatabaseDataContext(strsql);
//获取选中的员工编号
Fnumber.Text = Convert.ToString(dataGridView1[0, e.RowIndex].Value).Trim();
//根据员工编号获取其详细信息，并重新生成一个表
var result = from info in linq.T_LoginInfo
where info.fnumber == Convert.ToInt32(Fnumber.Text)
select new
{
员工编码 = info.fnumber,
员工姓名 = info.FNAME,
性别 = info.FSEX,
联系方式 = info.FTEL,
家庭住址 = info.FADRESS
};
///相应的文本框及下拉列表中显示选中的员工信息
foreach (var item in result)
{
Fname.Text = item.员工姓名;
FSEX.Text = Convert.ToString(item.性别);
FTEL.Text = item.联系方式;
FADRESS.Text = item.家庭住址;
}
//用datagridview属性
//Fnumber.Text = dataGridView1.SelectedCells[0].Value.ToString();
//Fname.Text = dataGridView1.SelectedCells[1].Value.ToString();
//FSEX.Text = dataGridView1.SelectedCells[2].Value.ToString();
//FTEL.Text = dataGridView1.SelectedCells[3].Value.ToString();
//FADRESS.Text = dataGridView1.SelectedCells[4].Value.ToString();
}
/// <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>
private void SelectInfo()
{
linq = new MydatabaseDataContext(strsql);
//获取所有员工信息
var result = from info in linq.T_LoginInfo
select new
{
员工编码 = info.fnumber,
员工姓名 = info.FNAME,
性别 = info.FSEX,
联系方式 = info.FTEL,
家庭住址 = info.FADRESS
};
dataGridView1.DataSource = result;
}
/// <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();
}