private void editReader_Click(object sender, EventArgs e) { try { int index = readerSearchResult.CurrentRow.Index; string inputborrowid = readerSearchResult.Rows[index].Cells[0].Value.ToString().Trim(); string inputrname = readerSearchResult.Rows[index].Cells[1].Value.ToString().Trim(); string inputsex = readerSearchResult.Rows[index].Cells[2].Value.ToString().Trim(); string inputjob = readerSearchResult.Rows[index].Cells[3].Value.ToString().Trim(); string inputrCurNum = readerSearchResult.Rows[index].Cells[4].Value.ToString().Trim(); string inputrBorrowedNum = readerSearchResult.Rows[index].Cells[5].Value.ToString().Trim(); string inputdept = readerSearchResult.Rows[index].Cells[6].Value.ToString().Trim(); string inputphone = readerSearchResult.Rows[index].Cells[7].Value.ToString().Trim(); string inputaccount = readerSearchResult.Rows[index].Cells[8].Value.ToString().Trim(); ReaderEdit readerEditForm = new ReaderEdit(inputborrowid, inputrname, inputrCurNum, inputrBorrowedNum, inputjob, inputphone, inputdept, inputaccount, inputsex); readerEditForm.Text = "读者信息编辑"; readerEditForm.opType = "EDIT"; readerEditForm.ShowDialog(); readerEditForm.Dispose(); //刷新读者查询的结果 string readerSearchSql = String.Format("select * from readers where borrowid like '%{0}%' and rname like '%{1}%' and sex='{2}' and job like '%{3}%' and rCurNum>={4} and rBorrowedNum>={5} and dept like '%{6}%' and phone like '%{7}%'", borrowid.Text, rname.Text, sex.Text, job.Text, rCurNum.Text, rBorrowedNum.Text, dept.Text, phone.Text); DataSet result = DbHelperSQL.Query(readerSearchSql); this.readerSearchResult.DataSource = result.Tables["ds"]; } catch (NullReferenceException exception) { MessageBox.Show("请先选中一行!"); return; } }
private void addReader_Click(object sender, EventArgs e) { ReaderEdit readerEditForm = new ReaderEdit(); readerEditForm.Text = "读者信息添加"; readerEditForm.opType = "ADD"; readerEditForm.ShowDialog(); readerEditForm.Dispose(); //刷新读者查询的结果 string readerSearchSql = String.Format("select * from readers where borrowid like '%{0}%' and rname like '%{1}%' and sex='{2}' and job like '%{3}%' and rCurNum>={4} and rBorrowedNum>={5} and dept like '%{6}%' and phone like '%{7}%'", borrowid.Text, rname.Text, sex.Text, job.Text, rCurNum.Text, rBorrowedNum.Text, dept.Text, phone.Text); DataSet result = DbHelperSQL.Query(readerSearchSql); this.readerSearchResult.DataSource = result.Tables["ds"]; }