private void button1_Click(object sender, EventArgs e)
{
string sql = "delete * from TB_BlacakList ";
driverListBll.ExecuteSql(sql);
string getblacklistsql = "select * from TB_BlacakList ";
DataTable dtDriverList = driverListBll.FindAll_infos(getblacklistsql);
dgvBlackList.DataSource = dtDriverList;
}
private void btnSave_Click(object sender, EventArgs e)
{
try
{
string sql = "update TB_BlacakList set User_ChineseName='" + txtUser_ChineseName.Text + "',User_EnglishName='" + txtUser_EnglishName.Text + "',Department_EnglishName='" + txtDepartment_EnglishName.Text + "',Department_ChineseName='" + txtDepartment_ChineseName.Text + "',Job='" + txt_Job.Text + "',Birthdy='" + txtBirthdy.Text + "' ,Identification_Type='" + txtIdentification_Type.Text + "',Identification_Number='" + txtIdentification_Number.Text + "',Telephone='" + txtTELEPHONE.Text + "',Employer='" + txtEmployer.Text + "' where ID=" + driver.Id + "";
if (driverList.ExecuteSql(sql))
{
MessageBox.Show("保存成功");
string getblacklistsql = "select ID ,User_ChineseName as 中文,User_EnglishName as 英文,Department_ChineseName as 单位名称中文,Department_EnglishName as 单位名称英文,Job as 职务,Sex as 性别,Birthdy as 出生日期,Identification_Type as 身份证件类型,Identification_Number as 身份证件号码,Employer as 工作单位,TELEPHONE as 联系方式 from TB_BlacakList ";
DataTable dtDriverList = driverListBll.FindAll_infos(getblacklistsql);
DataGridView dgv = (DataGridView)(f1.Controls["tabContro1"].Controls["tabPage1"].Controls["dgvBlackList"]);
dgv.DataSource = dtDriverList;
this.Close();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}