public int Update(OABooksLibrary model) { StringBuilder builder = new StringBuilder(); builder.Append("update OA_Books_Library set "); builder.Append("LibraryName='" + model.LibraryName + "',"); builder.Append("Content='" + model.Content + "'"); builder.Append(" where LibraryCode='" + model.LibraryCode + "'"); return(publicDbOpClass.ExecSqlString(builder.ToString())); }
public int Add(OABooksLibrary model) { StringBuilder builder = new StringBuilder(); builder.Append("insert into OA_Books_Library("); builder.Append("LibraryCode,LibraryName,Content,IsValid,Manager"); builder.Append(")"); builder.Append(" values ("); builder.Append("'" + model.LibraryCode + "',"); builder.Append("'" + model.LibraryName + "',"); builder.Append("'" + model.Content + "',"); builder.Append("'" + model.IsValid + "',"); builder.Append("'" + model.Manager + "'"); builder.Append(")"); return(publicDbOpClass.ExecSqlString(builder.ToString())); }
public OABooksLibrary GetModel(string LibraryCode) { StringBuilder builder = new StringBuilder(); builder.Append("select * "); builder.Append(" LibraryCode,LibraryName,Content,IsValid,Manager "); builder.Append(" from OA_Books_Library "); builder.Append(" where LibraryCode='" + LibraryCode + "'"); OABooksLibrary library = new OABooksLibrary(); DataSet set = publicDbOpClass.DataSetQuary(builder.ToString()); if (set.Tables[0].Rows.Count > 0) { library.LibraryCode = set.Tables[0].Rows[0]["LibraryCode"].ToString(); library.LibraryName = set.Tables[0].Rows[0]["LibraryName"].ToString(); library.Content = set.Tables[0].Rows[0]["Content"].ToString(); library.IsValid = set.Tables[0].Rows[0]["IsValid"].ToString(); library.Manager = set.Tables[0].Rows[0]["Manager"].ToString(); return(library); } return(null); }