public DataSet SelectReader(bool ch1, bool ch2, string name, string sfcq) {
string sql = \; if (ch1) {
sql += \; }
if (ch2) {
sql += \; }
DataSet ds = GetDataSet(sql, MakeParam(\, name), MakeParam(\, sfcq)); return ds; }
///
/// 根据借阅号删除读者信息 ///
///
public bool DeleteReader(string id) {
bool flag1, flag2;
string sql1 = \; flag1 = Execsql(sql1, MakeParam(\, id));
string sql2 = \; flag2 = Execsql(sql2,MakeParam(\,id)); return flag1 && flag2; }
///
///
string sj = DateTime.Now.ToString(\);
string sql = \; int i = Convert.ToInt32(GetFirstRow(sql, MakeParam(\, sj + \))) + 1; string bookid = sj +\+ i.ToString().PadLeft(3, '0'); return bookid; }
///
///
/// public bool InsertBook(string id, string writer, string name, string publish, DateTime publishdate, string price, string sort) {
string sql = @\
(BookID,BookWriter,BookName,BookPublish,BookPublishDate,BookPrice,BookSort)
27
values (@id,@writer,@name,@publish,@publishdate,@price,@sort)\; bool flag = Execsql(sql, MakeParam(\, id), MakeParam(\, writer), MakeParam(\, name), MakeParam(\, publish), new SqlParameter(\, publishdate), MakeParam(\, price), MakeParam(\, sort)); return flag; }
///
///
public DataSet GetBookID_1() {
string sql = \; DataSet ds = GetDataSet(sql); return ds; }
///
/// 根据图书ID获取信息 ///
///
public DataSet GetBook(string id) {
string sql = \; DataSet ds = GetDataSet(sql, MakeParam(\, id)); return ds; }
///
/// 根据图书号更新图书信息 ///
///
/// public bool UpdateBook(string id, string writer, string name, string publish, DateTime publishdate, string price, string sort) {
string sql = \
BookWriter=@writer,BookName=@name,BookPublish=@publish,BookPublishDate=@publishdate,BookPrice=@price,BookSort=@sort where BookID=@id\;
bool flag = Execsql(sql, MakeParam(\, writer), MakeParam(\, name),
MakeParam(\, publish), new SqlParameter(\, publishdate), MakeParam(\, price), MakeParam(\, sort), MakeParam(\, id)); return flag; }
///
///
28
///
///
public DataSet SelectBook(bool ch1, bool ch2, bool ch3,string bookname, string name,string publish) {
string sql = \; if (ch1) {
sql += \; }
if (ch2) {
sql += \; }
if (ch3) {
sql += \; }
DataSet ds = GetDataSet(sql,MakeParam(\,bookname+\), MakeParam(\, name+\), MakeParam(\, publish+\)); return ds; }
///
/// 通过图书号删除图书信息 ///
///
public bool DeleteBook(string id) {
string sql = \; bool flag = Execsql(sql, MakeParam(\, id)); return flag; }
///
/// 获取出版社名字 ///
///
public DataSet GetPublishName() {
string sql = \; DataSet ds = GetDataSet(sql); return ds; }
///
/// 添加出版社信息 ///
///
public bool InsertPublish(string name,string address,string phone,string email) {
29
string sql = @\
(PublishName,PublishAddress,PublishPhoneNO,PublishEmail)
values (@name,@address,@phone,@email)\; bool flag =
Execsql(sql,MakeParam(\,name),MakeParam(\,address),MakeParam(\,phone),MakeParam(\email\,email));
return flag; }
///
/// 通过出版社名获取出版社信息 ///
///
public DataSet GetPublish(string name) {
string sql = \; DataSet ds = GetDataSet(sql, MakeParam(\, name)); return ds; }
///
/// 更新出版社信息 ///
///
public bool UpdatePublish(string name, string address, string phone, string email) {
string sql = \
PublishAddress=@address,PublishPhoneNO=@phone,PublishEmail=@email where PublishName=@name\; bool flag =
Execsql(sql,MakeParam(\,address),MakeParam(\,phone),MakeParam(\,email),MakeParam(\,name));
return flag; }
///
/// 查询出版社信息 ///
///
public DataSet SelectPublish(string name) {
string sql = \; DataSet ds = GetDataSet(sql, MakeParam(\, \ + name + \)); return ds; }
///
/// 删除出版社信息 ///
///
public bool DeletePublish(string name) {
string sql = \;
30
bool flag = Execsql(sql, MakeParam(\,name )); return flag; }
///
///
///
public bool BorrowBook(string readerid,string bookid,DateTime borrowdate,DateTime returndate) {
bool flag1, flag2, flag3; //插入借阅信息表
string sql1 = @\ values (@readerid,@bookid,@borrowdate,@returndate,'否')\;
flag1 = Execsql(sql1, MakeParam(\, readerid), MakeParam(\, bookid),new SqlParameter(\,borrowdate),new SqlParameter(\,returndate)); //更新读者借阅图书数量
string sql2 = \; flag2 = Execsql(sql2,MakeParam(\,readerid)); //更新图书状态为被借阅
string sql3 = \是' where BookID=@id1\; flag3 = Execsql(sql3,MakeParam(\,bookid)); return flag1 && flag2 && flag3; }
///
/// 借阅管理根据图书ID获取信息 ///
///
public DataSet BorrowGetBook(string id) {
string sql = \否'\; DataSet ds = GetDataSet(sql, MakeParam(\, id)); return ds; }
///
/// 还书界面根据用户名获取还未还的信息 ///
///
public DataSet BorrowGetBookID(string username) {
string sql = \否' and ReaderID=@username\; DataSet ds = GetDataSet(sql,MakeParam(\,username)); return ds; }
///
///
31