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('没有相关数据可更新!');";
}
}
