private void confirm_Click_1(object sender, EventArgs e)
{
try
{
string sql = String.Format(@"insert into readerTable
values('{0}','{1}','{2}','{3}',{4},{5},'{6}','{7}')",
txt_rid.Text.Trim(), txt_rname.Text.Trim(), txt_sex.Text, txt_job.Text.Trim(), txt_cbn.Text, txt_bn.Text, txt_dept.Text, txt_phone.Text.Trim());
AddReader.ExecuteSql(sql);
MessageBox.Show("添加成功");
}
catch (Exception exception)
{
MessageBox.Show(exception.Message);
return;
}
this.Close();
}
private void button12_Click(object sender, EventArgs e)
{
string readerid = txt_rid.Text.Trim();
string rname = txt_rname.Text.Trim();
string sex = txt_sex.Text.Trim();
string jobTitle = txt_job.Text.Trim();
string canBorrowNum = txt_cbn.Text.Trim();
string borrowedNum = txt_bn.Text.Trim();
string department = txt_dept.Text.Trim();
string phone = txt_phone.Text.Trim();
AddReader childrenform = new AddReader();
childrenform.Owner = this;
childrenform.ShowDialog();
childrenform.Dispose();
this.Readerlist.DataSource = Query("select * from readerTable where ReaderId like '%" + readerid + "%' and ReaderName like '%" + rname + "%' and Sex like '%" + sex + "%' and JobTitle like '%" + jobTitle + "%' and CanBorrowNum like '%" + canBorrowNum + "%' and BorrowedNum like '%" + borrowedNum + "%' and Department like '%" + department + "%' and PhoneNumber like '%" + phone + "%'").Tables["ds"];
}
