/// <summary> /// 更新状态 /// </summary> /// <param name="book"></param> /// <returns></returns> public bool Update(LMS_Map map) { // update LMS_Map set Bookstatu = 1 where Bookname = '在人间'; string sql = string.Format(@"update LMS_Map set flage={0} where number={1} ", map.Flage, map.Number); return(DBHeper.SQL(sql)); }
public bool Insert(LMS_Map map) { //拼接SQL string sql = string.Format(@"Insert into LMS_Map ( Booknumber,Usernumber,Borrowingdate,Returndate,flage) values({0},{1},'{2}','{3}',1 )", map.Booknumber, map.Usernumber, map.Borrowingdate, map.Returndate); //连接数据库 执行SQL return(DBHeper.SQL(sql)); }
public LMS_Map Select(string sql) { LMS_Map LMS_Map = new LMS_Map(); //从数据库获取信息 DataTable data = DBHeper.Select(sql); //如果有数据 将DataTable载入到LMS_Map对象 if (data.Rows.Count > 0) { var row = data.Rows[0]; LMS_Map.Booknumber = (int)row["Booknumber"]; LMS_Map.Usernumber = (int)row["Usernumber"]; LMS_Map.Borrowingdate = row["Borrowingdate"].ToString(); LMS_Map.Returndate = row["Returndate"].ToString(); LMS_Map.Flage = (int)row["Flage"]; LMS_Map.Number = (int)row["Number"]; } //返回书籍信息 return(LMS_Map); }
public List <LMS_Map> SelectList(string sql) { List <LMS_Map> list = new List <LMS_Map>(); //从数据库获取信息 DataTable data = DBHeper.Select(sql); foreach (DataRow row in data.Rows) { //利用将当前行数据 新建用户对象 LMS_Map LMS_Map = new LMS_Map(); LMS_Map.Booknumber = (int)row["Booknumber"]; LMS_Map.Usernumber = (int)row["Usernumber"]; LMS_Map.Borrowingdate = row["Borrowingdate"].ToString(); LMS_Map.Returndate = row["Returndate"].ToString(); LMS_Map.Flage = (int)row["Flage"]; LMS_Map.Number = (int)row["Number"]; //将用户对象 存入列表 list.Add(LMS_Map); } //返回列表 return(list); }
/// <summary> /// 归还书籍 /// </summary> /// <param name="map"></param> /// <returns></returns> public bool returnBook(LMS_Map map) { return(_dal.Update(map)); // string sql = string.Format("select* from LMS_map where usernumber = {0}", userNumber); }
/// <summary> /// 借阅书籍 /// </summary> /// <param name="map"></param> /// <returns></returns> public bool Borrow(LMS_Map map) { return(_dal.Insert(map)); }