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