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);
}
}
