protected void btnAdd_Click(object sender, EventArgs e) { OAFileLibrary data = this.GetData(); if (this.OperateType == "add") { int num = this.mcAction.Add(data); if (num > 0) { this.JS.Text = "returnValue=true;window.close();"; } else { this.JS.Text = "没有相关数据可添加!"; } } if (this.OperateType == "upd") { int num = this.mcAction.Update(data); if (num > 0) { this.JS.Text = "returnValue=true;window.close();"; return; } this.JS.Text = "没有相关数据可更新!"; } }
public int Update(OAFileLibrary model) { StringBuilder builder = new StringBuilder(); builder.Append("update OA_File_Library set "); builder.Append("LibraryName='" + model.LibraryName + "',"); builder.Append("Content='" + model.Content + "',"); builder.Append("IsValid='" + model.IsValid + "',"); builder.Append("Manager='" + model.Manager + "'"); builder.Append(" where LibraryCode='" + model.LibraryCode + "'"); return(publicDbOpClass.ExecSqlString(builder.ToString())); }
public int Add(OAFileLibrary model) { StringBuilder builder = new StringBuilder(); builder.Append("insert into OA_File_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())); }
private OAFileLibrary GetData() { OAFileLibrary oAFileLibrary = new OAFileLibrary(); oAFileLibrary.Content = this.txtRemark.Text.Trim(); oAFileLibrary.IsValid = "1"; if (this.OperateType == "upd") { oAFileLibrary.LibraryCode = this.LibraryCode; } else { oAFileLibrary.LibraryCode = FileCommonClass.GetNewLibraryCode(); } oAFileLibrary.LibraryName = this.txtBookLibraryName.Text.Trim(); oAFileLibrary.Manager = ""; return(oAFileLibrary); }
public OAFileLibrary GetModel(string LibraryCode) { StringBuilder builder = new StringBuilder(); builder.Append("select * "); builder.Append(" LibraryCode,LibraryName,Content,IsValid,Manager "); builder.Append(" from OA_File_Library "); builder.Append(" where LibraryCode='" + LibraryCode + "'"); OAFileLibrary library = new OAFileLibrary(); 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); }