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