public ArrayList GetLendBooks(string isbn) { ArrayList list = new ArrayList(); StringBuilder builder = new StringBuilder(); builder.Append("select ISBN,ClassID,BookTitle,PublishingHouse,Author,isnull(SumCopy,0) as SumCopy,isnull(LeaveCopy,0) as LeaveCopy from OA_Books_Storage where charindex(ISBN,'" + isbn + "')>0 "); DataTable table = publicDbOpClass.DataTableQuary(builder.ToString()); if (table.Rows.Count > 0) { foreach (DataRow row in table.Rows) { OABooksLend lend = new OABooksLend { BookTitle = row["BookTitle"].ToString(), BorrowMan = "", Copy = 1, ISBN = row["ISBN"].ToString(), LendDate = DateTime.Now, LendState = "1", PlanReturnDate = DateTime.Now, RecordID = 0, ReturnApplyDate = DateTime.Now, ReturnDate = DateTime.Now }; list.Add(lend); } } return(list); }
public OABooksLend GetModel(int ID) { StringBuilder builder = new StringBuilder(); builder.Append("select * "); builder.Append(" RecordID,BorrowMan,ISBN,BookTitle,Copy,LendDate,PlanReturnDate,ReturnApplyDate,ReturnDate,LendState "); builder.Append(" from OA_Books_Lend "); builder.Append(" where RecordID=" + ID); OABooksLend lend = new OABooksLend(); DataSet set = publicDbOpClass.DataSetQuary(builder.ToString()); if (set.Tables[0].Rows.Count <= 0) { return(null); } if (set.Tables[0].Rows[0]["RecordID"].ToString() != "") { lend.RecordID = int.Parse(set.Tables[0].Rows[0]["RecordID"].ToString()); } lend.BorrowMan = set.Tables[0].Rows[0]["BorrowMan"].ToString(); lend.ISBN = set.Tables[0].Rows[0]["ISBN"].ToString(); lend.BookTitle = set.Tables[0].Rows[0]["BookTitle"].ToString(); if (set.Tables[0].Rows[0]["Copy"].ToString() != "") { lend.Copy = int.Parse(set.Tables[0].Rows[0]["Copy"].ToString()); } if (set.Tables[0].Rows[0]["LendDate"].ToString() != "") { lend.LendDate = DateTime.Parse(set.Tables[0].Rows[0]["LendDate"].ToString()); } if (set.Tables[0].Rows[0]["PlanReturnDate"].ToString() != "") { lend.PlanReturnDate = DateTime.Parse(set.Tables[0].Rows[0]["PlanReturnDate"].ToString()); } if (set.Tables[0].Rows[0]["ReturnApplyDate"].ToString() != "") { lend.ReturnApplyDate = DateTime.Parse(set.Tables[0].Rows[0]["ReturnApplyDate"].ToString()); } if (set.Tables[0].Rows[0]["ReturnDate"].ToString() != "") { lend.ReturnDate = DateTime.Parse(set.Tables[0].Rows[0]["ReturnDate"].ToString()); } lend.LendState = set.Tables[0].Rows[0]["LendState"].ToString(); return(lend); }
public int Update(OABooksLend model) { StringBuilder builder = new StringBuilder(); builder.Append("update OA_Books_Lend set "); builder.Append("RecordID=" + model.RecordID + ","); builder.Append("BorrowMan='" + model.BorrowMan + "',"); builder.Append("ISBN='" + model.ISBN + "',"); builder.Append("BookTitle='" + model.BookTitle + "',"); builder.Append("Copy=" + model.Copy + ","); builder.Append("LendDate='" + model.LendDate + "',"); builder.Append("PlanReturnDate='" + model.PlanReturnDate + "',"); builder.Append("ReturnApplyDate='" + model.ReturnApplyDate + "',"); builder.Append("ReturnDate='" + model.ReturnDate + "',"); builder.Append("LendState='" + model.LendState + "'"); builder.Append(" where RecordID=" + model.RecordID); return(publicDbOpClass.ExecSqlString(builder.ToString())); }
public int Add(OABooksLend model) { StringBuilder builder = new StringBuilder(); builder.Append("insert into OA_Books_Lend("); builder.Append("RecordID,BorrowMan,ISBN,BookTitle,Copy,LendDate,PlanReturnDate,ReturnApplyDate,ReturnDate,LendState"); builder.Append(")"); builder.Append(" values ("); builder.Append(model.RecordID + ","); builder.Append("'" + model.BorrowMan + "',"); builder.Append("'" + model.ISBN + "',"); builder.Append("'" + model.BookTitle + "',"); builder.Append(model.Copy + ","); builder.Append("'" + model.LendDate + "',"); builder.Append("'" + model.PlanReturnDate + "',"); builder.Append("'" + model.ReturnApplyDate + "',"); builder.Append("'" + model.ReturnDate + "',"); builder.Append("'" + model.LendState + "'"); builder.Append(")"); return(publicDbOpClass.ExecSqlString(builder.ToString())); }