public OAFileDestroyMain GetModel(Guid RecordID) { StringBuilder builder = new StringBuilder(); builder.Append("select * "); builder.Append(" RecordID,LibraryCode,AuditState,UserCode,RecordDate,Remark,IsConfirm "); builder.Append(" from OA_File_DestroyMain "); builder.Append(" where RecordID=" + RecordID); OAFileDestroyMain main = new OAFileDestroyMain(); DataSet set = publicDbOpClass.DataSetQuary(builder.ToString()); if (set.Tables[0].Rows.Count <= 0) { return(null); } if (set.Tables[0].Rows[0]["RecordID"].ToString() != "") { main.RecordID = new Guid(set.Tables[0].Rows[0]["RecordID"].ToString()); } main.LibraryCode = set.Tables[0].Rows[0]["LibraryCode"].ToString(); if (set.Tables[0].Rows[0]["AuditState"].ToString() != "") { main.AuditState = int.Parse(set.Tables[0].Rows[0]["AuditState"].ToString()); } main.UserCode = set.Tables[0].Rows[0]["UserCode"].ToString(); if (set.Tables[0].Rows[0]["RecordDate"].ToString() != "") { main.RecordDate = DateTime.Parse(set.Tables[0].Rows[0]["RecordDate"].ToString()); } main.Remark = set.Tables[0].Rows[0]["Remark"].ToString(); main.IsConfirm = set.Tables[0].Rows[0]["IsConfirm"].ToString(); return(main); }
public int Update(OAFileDestroyMain model) { StringBuilder builder = new StringBuilder(); builder.Append("update OA_File_DestroyMain set "); builder.Append("LibraryCode='" + model.LibraryCode + "',"); builder.Append("AuditState=" + model.AuditState + ","); builder.Append("UserCode='" + model.UserCode + "',"); builder.Append("RecordDate='" + model.RecordDate + "',"); builder.Append("Remark='" + model.Remark + "',"); builder.Append("IsConfirm='" + model.IsConfirm + "'"); builder.Append(" where RecordID='" + model.RecordID + "'"); return(publicDbOpClass.ExecSqlString(builder.ToString())); }
public int Add(OAFileDestroyMain model) { StringBuilder builder = new StringBuilder(); builder.Append("insert into OA_File_DestroyMain("); builder.Append("RecordID,LibraryCode,AuditState,UserCode,RecordDate,Remark,IsConfirm"); builder.Append(")"); builder.Append(" values ("); builder.Append("'" + model.RecordID + "',"); builder.Append("'" + model.LibraryCode + "',"); builder.Append(model.AuditState + ","); builder.Append("'" + model.UserCode + "',"); builder.Append("'" + model.RecordDate + "',"); builder.Append("'" + model.Remark + "',"); builder.Append("'" + model.IsConfirm + "'"); builder.Append(")"); return(publicDbOpClass.ExecSqlString(builder.ToString())); }
protected void btnAdd_Click(object sender, EventArgs e) { OAFileDestroyMain data = this.GetData(); if (this.OperateType == "add") { int num = this.amAction.Add(data); if (num > 0) { this.JS.Text = "returnValue=true;"; this.Page.RegisterStartupScript("", string.Concat(new string[] { "<script>document.getElementById('frmLibrary').src='FileDestroyAssTabEdit.aspx?isSave=1&op=", this.OperateType, "&ac=", this.RecordCode.ToString(), "&lc=", this.LibraryCode, "';</script>" })); this.JS.Text = "alert('保存成功!');"; } else { this.JS.Text = "alert('没有相关数据可添加!');"; } } if (this.OperateType == "upd") { int num = this.amAction.Update(data); if (num > 0) { this.JS.Text = "returnValue=true;window.close();"; return; } this.JS.Text = "alert('没有相关数据可更新!');"; } }