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