protected void btnAdd_Click(object sender, EventArgs e) { OAFileClasses 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 OAFileClasses GetModel(int ClassID) { StringBuilder builder = new StringBuilder(); builder.Append("select * "); builder.Append(" ClassID,LibraryCode,ClassCode,ClassName,Remark,IsValid "); builder.Append(" from OA_File_Classes "); builder.Append(" where ClassID=" + ClassID); OAFileClasses classes = new OAFileClasses(); DataSet set = publicDbOpClass.DataSetQuary(builder.ToString()); if (set.Tables[0].Rows.Count <= 0) { return(null); } if (set.Tables[0].Rows[0]["ClassID"].ToString() != "") { classes.ClassID = int.Parse(set.Tables[0].Rows[0]["ClassID"].ToString()); } classes.LibraryCode = set.Tables[0].Rows[0]["LibraryCode"].ToString(); classes.ClassCode = set.Tables[0].Rows[0]["ClassCode"].ToString(); classes.ClassName = set.Tables[0].Rows[0]["ClassName"].ToString(); classes.Remark = set.Tables[0].Rows[0]["Remark"].ToString(); classes.IsValid = set.Tables[0].Rows[0]["IsValid"].ToString(); return(classes); }
public int Update(OAFileClasses model) { StringBuilder builder = new StringBuilder(); builder.Append(" update OA_File_Classes set "); builder.Append(" ClassName='" + model.ClassName + "', "); builder.Append(" Remark='" + model.Remark + "' "); builder.Append(" where "); builder.Append(" LibraryCode='" + model.LibraryCode + "' and "); builder.Append(" ClassCode='" + model.ClassCode + "' "); return(publicDbOpClass.ExecSqlString(builder.ToString())); }
public int Add(OAFileClasses model) { StringBuilder builder = new StringBuilder(); builder.Append("insert into OA_File_Classes("); builder.Append("LibraryCode,ClassCode,ClassName,Remark,IsValid"); builder.Append(")"); builder.Append(" values ("); builder.Append("'" + model.LibraryCode + "',"); builder.Append("'" + model.ClassCode + "',"); builder.Append("'" + model.ClassName + "',"); builder.Append("'" + model.Remark + "',"); builder.Append("'" + model.IsValid + "'"); builder.Append(")"); return(publicDbOpClass.ExecSqlString(builder.ToString())); }
private OAFileClasses GetData() { OAFileClasses oAFileClasses = new OAFileClasses(); if (this.OperateType == "upd") { oAFileClasses.ClassCode = this.ClassCode; } else { oAFileClasses.ClassCode = FileCommonClass.GetNewFileCode(this.LibraryCode); } oAFileClasses.LibraryCode = this.LibraryCode; oAFileClasses.ClassName = this.txtClassName.Text.Trim(); oAFileClasses.Remark = this.txtRemark.Text.Trim(); oAFileClasses.IsValid = "1"; return(oAFileClasses); }