public static bool Back_book(string sernum) { string str = return_state(sernum); int state = int.Parse(str); if (state == 0) { return(false); } else { state--; StringBuilder stringBuilder = new StringBuilder(); stringBuilder.Append("update lend_list set "); stringBuilder.Append("state='"); stringBuilder.Append(state + "'"); stringBuilder.Append(" where sernum='"); stringBuilder.Append(sernum + "'"); int rows = DBhelp.ExecuteNonQuery(stringBuilder.ToString()); if (rows > 0) { return(true); } else { return(false); } } }
public static bool User_lend() { int count; string c = ""; SqlDataReader sqlDataReader = ExistsID(ruid); while (sqlDataReader.Read()) { c = sqlDataReader["borrowable"].ToString(); } sqlDataReader.Close(); count = int.Parse(c); if (count == 0) { return(false); } else { count--; StringBuilder stringBuilder = new StringBuilder(); stringBuilder.Append("update reader_info set borrowable='"); stringBuilder.Append(count); stringBuilder.Append("' where reader_id='"); stringBuilder.Append(ruid + "'"); if (DBhelp.ExecuteNonQuery(stringBuilder.ToString()) > 0) { return(true); } else { return(false); } } }
//故障申报 public static bool Updateconfig(long id, int duration, string start_time) { /* ex: * update config * set 计划维护时长 = 10, * 开始维护时间 = '2018-07-11', * Meter_malfunc = 0 * where Meter_id = 2018071007; */ StringBuilder updatestr = new StringBuilder(); updatestr.Append("update config set 计划维护时长 = "); updatestr.Append(duration); updatestr.Append(", 开始维护时间 = '"); updatestr.Append(start_time); updatestr.Append("' , Meter_malfunc = 0 "); updatestr.Append("where Meter_id = "); updatestr.Append(id); int row = DBhelp.ExecuteNonQuery(updatestr.ToString()); if (row > 0) { return(true); } else { return(false); } }
public static bool register(string strsql) { int rows = DBhelp.ExecuteNonQuery(strsql); if (rows > 0) { return(true); } else { return(false); } }
//删除图书 public static bool DeleteBook(string bookid) { StringBuilder deleteBuilder = new StringBuilder(); deleteBuilder.Append("delete from book_info where book_id = '"); deleteBuilder.Append(bookid + "'"); int row = DBhelp.ExecuteNonQuery(deleteBuilder.ToString()); if (row > 0) { return(true); } else { return(false); } }
public static bool deleteReader(string reader_id) { StringBuilder stringBuilder = new StringBuilder(); stringBuilder.Append("delete from reader_info where reader_id = '"); stringBuilder.Append(reader_id + "'"); int row = DBhelp.ExecuteNonQuery(stringBuilder.ToString()); if (row > 0) { return(true); } else { return(false); } }
//delete supplier public static bool DeleteSupplier(string id) { StringBuilder deletestr = new StringBuilder(); deletestr.Append("delete from supplier_info where Supplier_id = '"); deletestr.Append(id + "'"); int row = DBhelp.ExecuteNonQuery(deletestr.ToString()); if (row > 0) { return(true); } else { return(false); } }
public static bool deleteorder(string sernum) { StringBuilder deletestr = new StringBuilder(); deletestr.Append("delete from order_list where sernum = '"); deletestr.Append(sernum + "'"); int row = DBhelp.ExecuteNonQuery(deletestr.ToString()); if (row > 0) { return(true); } else { return(false); } }
public static bool Insert_info(string cname) { StringBuilder stringBuilder = new StringBuilder(); stringBuilder.Append("insert into component_info(Component_name) values('"); stringBuilder.Append(cname + "')"); int rows = DBhelp.ExecuteNonQuery(stringBuilder.ToString()); if (rows > 0) { return(true); } else { return(false); } }
public static bool Delete_info(string cnum) { StringBuilder stringBuilder = new StringBuilder(); stringBuilder.Append("delete from component_info where Component_id='"); stringBuilder.Append(cnum + "'"); int rows = DBhelp.ExecuteNonQuery(stringBuilder.ToString()); if (rows > 0) { return(true); } else { return(false); } }
/* * 删除用户信息 */ public static bool Delete_info(string uid) { StringBuilder stringBuilder = new StringBuilder(); stringBuilder.Append("delete from user_info where User_id='"); stringBuilder.Append(uid + "'"); int rows = DBhelp.ExecuteNonQuery(stringBuilder.ToString()); if (rows > 0) { return(true); } else { return(false); } }
//修改机器故障状态 public static bool UpdateMalfunc(long id) { StringBuilder updatestr = new StringBuilder(); updatestr.Append("update config set Meter_malfunc = 1,计划维护时长=null,开始维护时间=null "); updatestr.Append("where Meter_id = "); updatestr.Append(id); int row = DBhelp.ExecuteNonQuery(updatestr.ToString()); if (row > 0) { return(true); } else { return(false); } }
//增加新书 public static bool AddBookinfo(string addinfo) { StringBuilder stringBuilder = new StringBuilder(); stringBuilder.Append("insert into book_info(book_id, name," + " author, publish, introduction, price, pubdate, class_id," + " state,book_count) values("); stringBuilder.Append(addinfo + ")"); int row = DBhelp.ExecuteNonQuery(stringBuilder.ToString()); if (row > 0) { return(true); } else { return(false); } }
public static bool Changeinfo(string Uid, string info) { StringBuilder stringBuilder = new StringBuilder(); stringBuilder.Append("update reader_info set "); stringBuilder.Append(info); stringBuilder.Append(" where reader_id="); stringBuilder.Append(Uid); int rows = DBhelp.ExecuteNonQuery(stringBuilder.ToString()); if (rows > 0) { return(true); } else { return(false); } }
/* * 用户信息录入 */ public static bool Insert_uinfo(string uname, string pwd) { StringBuilder stringBuilder = new StringBuilder(); stringBuilder.Append("insert into user_info(User_name,User_pwd,User_limit) values('"); stringBuilder.Append(uname + "','"); stringBuilder.Append(pwd + "','"); stringBuilder.Append(0 + "')"); int rows = DBhelp.ExecuteNonQuery(stringBuilder.ToString()); if (rows > 0) { return(true); } else { return(false); } }
//新增供应商 public static bool AddSupplier(string sup_name, string sup_addr) { StringBuilder addSup = new StringBuilder(); addSup.Append("insert into supplier_info" + "(Supplier_name,Supplier_addr) values('"); addSup.Append(sup_name + "', '"); addSup.Append(sup_addr + "')"); int row = DBhelp.ExecuteNonQuery(addSup.ToString()); if (row > 0) { return(true); } else { return(false); } }
public static bool Change_pwd(string uid, string pwd) { StringBuilder stringBuilder = new StringBuilder(); stringBuilder.Append("update user_info set "); stringBuilder.Append("User_pwd='"); stringBuilder.Append(pwd + "' "); stringBuilder.Append("where User_id='"); stringBuilder.Append(uid + "'"); int rows = DBhelp.ExecuteNonQuery(stringBuilder.ToString()); if (rows > 0) { return(true); } else { return(false); } }
public static bool Change_info(string cnum, string cname) { StringBuilder stringBuilder = new StringBuilder(); stringBuilder.Append("update component_info set "); stringBuilder.Append("Component_name='"); stringBuilder.Append(cname + "' "); stringBuilder.Append("where Component_id='"); stringBuilder.Append(cnum + "'"); int rows = DBhelp.ExecuteNonQuery(stringBuilder.ToString()); if (rows > 0) { return(true); } else { return(false); } }
public static bool UpdateBook_lend(string bookid, string bookCount) { StringBuilder updateBuilder = new StringBuilder(); updateBuilder.Append("update book_info set "); updateBuilder.Append("book_count = '"); updateBuilder.Append(bookCount); updateBuilder.Append("' where book_id = '"); updateBuilder.Append(bookid + "'"); int row = DBhelp.ExecuteNonQuery(updateBuilder.ToString()); if (row > 0) { return(true); } else { return(false); } }
public static bool adminChangePassword(string Uid, string pwd) { StringBuilder stringBuilder = new StringBuilder(); stringBuilder.Append("update admin set "); stringBuilder.Append("password="******"where admin_id="); stringBuilder.Append(Uid); int rows = DBhelp.ExecuteNonQuery(stringBuilder.ToString()); if (rows > 0) { return(true); } else { return(false); } }
//update supplier public static bool UpdateSupplier(string id, string name, string addr) { StringBuilder updatestr = new StringBuilder(); updatestr.Append("update supplier_info set Supplier_name = '"); updatestr.Append(name); updatestr.Append("' , Supplier_addr = '"); updatestr.Append(addr + "'"); updatestr.Append("where Supplier_id = '"); updatestr.Append(id + "'"); int row = DBhelp.ExecuteNonQuery(updatestr.ToString()); if (row > 0) { return(true); } else { return(false); } }
public static bool Record_Lend(string bookid) { StringBuilder stringBuilder = new StringBuilder(); stringBuilder.Append("insert into lend_list(book_id, reader_id, " + "lend_date, back_date) values("); stringBuilder.Append("'" + bookid + "' ,"); stringBuilder.Append("'" + ruid + "' ,"); stringBuilder.Append("'" + DateTime.Now.ToShortDateString() + "' ,"); stringBuilder.Append("'" + DateTime.Now.AddMonths(3).ToShortDateString() + "'"); stringBuilder.Append(")"); int rows = DBhelp.ExecuteNonQuery(stringBuilder.ToString()); if (rows > 0) { return(true); } else { return(false); } }
//更新图书 public static bool UpdateBook(string bookid, string name, string author, string press, string intro, string price, string pubdate, string classid, string state, string bookCount) { StringBuilder updateBuilder = new StringBuilder(); updateBuilder.Append("update book_info set "); updateBuilder.Append("name = '"); updateBuilder.Append(name); updateBuilder.Append("' , author = '"); updateBuilder.Append(author); updateBuilder.Append("' , publish = '"); updateBuilder.Append(press); updateBuilder.Append("' , introduction = '"); updateBuilder.Append(intro); updateBuilder.Append("' , price = '"); updateBuilder.Append(price); updateBuilder.Append("' , pubdate = '"); updateBuilder.Append(pubdate); updateBuilder.Append("' , class_id = '"); updateBuilder.Append(classid); updateBuilder.Append("' , state = '"); updateBuilder.Append(state); updateBuilder.Append("' , book_count = '"); updateBuilder.Append(bookCount); updateBuilder.Append("' where book_id = '"); updateBuilder.Append(bookid + "'"); int row = DBhelp.ExecuteNonQuery(updateBuilder.ToString()); if (row > 0) { return(true); } else { return(false); } }
public static bool update_ustate() { int count = Lend_num(); count++; StringBuilder stringBuilder = new StringBuilder(); stringBuilder.Append("update reader_info set "); stringBuilder.Append("borrowable='"); stringBuilder.Append(count + "'"); stringBuilder.Append(" where reader_id='"); stringBuilder.Append(ruid + "'"); int rows = DBhelp.ExecuteNonQuery(stringBuilder.ToString()); if (rows > 0) { return(true); } else { return(false); } }
public static bool addOrder(int orderNum, string supName, string ComName1, string ComName2, string ComName3, string ComName4, string ComName5) { StringBuilder addstr = new StringBuilder(); addstr.Append("insert into order_list select Su.Supplier_id, Co.Component_id, Order_num = "); addstr.Append(orderNum); addstr.Append(" from( select Supplier_id from supplier_info where Supplier_name = '"); addstr.Append(supName + "') as Su, (select Component_id from component_info where Component_name='"); addstr.Append(ComName1 + "' or Component_name='"); addstr.Append(ComName2 + "' or Component_name='"); addstr.Append(ComName3 + "' or Component_name='"); addstr.Append(ComName4 + "' or Component_name='"); addstr.Append(ComName5 + "' )as Co"); int row = DBhelp.ExecuteNonQuery(addstr.ToString()); if (row > 0) { return(true); } else { return(false); } }