public OABooksStorage GetModel(string ISBN) { StringBuilder builder = new StringBuilder(); builder.Append("select * "); builder.Append(" ISBN,ClassID,BookTitle,PublishingHouse,Author,SumCopy,LeaveCopy "); builder.Append(" from OA_Books_Storage "); builder.Append(" where ISBN='" + ISBN + "'"); OABooksStorage storage = new OABooksStorage(); DataSet set = publicDbOpClass.DataSetQuary(builder.ToString()); if (set.Tables[0].Rows.Count <= 0) { return(null); } storage.ISBN = set.Tables[0].Rows[0]["ISBN"].ToString(); if (set.Tables[0].Rows[0]["ClassID"].ToString() != "") { storage.ClassID = int.Parse(set.Tables[0].Rows[0]["ClassID"].ToString()); } storage.BookTitle = set.Tables[0].Rows[0]["BookTitle"].ToString(); storage.PublishingHouse = set.Tables[0].Rows[0]["PublishingHouse"].ToString(); storage.Author = set.Tables[0].Rows[0]["Author"].ToString(); if (set.Tables[0].Rows[0]["SumCopy"].ToString() != "") { storage.SumCopy = int.Parse(set.Tables[0].Rows[0]["SumCopy"].ToString()); } if (set.Tables[0].Rows[0]["LeaveCopy"].ToString() != "") { storage.LeaveCopy = int.Parse(set.Tables[0].Rows[0]["LeaveCopy"].ToString()); } return(storage); }
public int Update(OABooksStorage model) { StringBuilder builder = new StringBuilder(); builder.Append("update OA_Books_Storage set "); builder.Append("ClassID=" + model.ClassID + ","); builder.Append("BookTitle='" + model.BookTitle + "',"); builder.Append("PublishingHouse='" + model.PublishingHouse + "',"); builder.Append("Author='" + model.Author + "',"); builder.Append("SumCopy=" + model.SumCopy + ","); builder.Append("LeaveCopy=" + model.LeaveCopy); builder.Append(" where ISBN='" + model.ISBN + "'"); return(publicDbOpClass.ExecSqlString(builder.ToString())); }
public int Add(OABooksStorage model) { StringBuilder builder = new StringBuilder(); builder.Append("insert into OA_Books_Storage("); builder.Append("ISBN,ClassID,BookTitle,PublishingHouse,Author,SumCopy,LeaveCopy"); builder.Append(")"); builder.Append(" values ("); builder.Append("'" + model.ISBN + "',"); builder.Append(model.ClassID + ","); builder.Append("'" + model.BookTitle + "',"); builder.Append("'" + model.PublishingHouse + "',"); builder.Append("'" + model.Author + "',"); builder.Append(model.SumCopy + ","); builder.Append(model.LeaveCopy); builder.Append(")"); return(publicDbOpClass.ExecSqlString(builder.ToString())); }