protected void btnAdd_Click(object sender, EventArgs e)
{
HROrgAdjust data = this.GetData();
if (this.OperateType == "add")
{
int num = this.hrAction.Add(data);
if (num > 0)
{
this.Page.RegisterStartupScript("", "<script>alert('添加成功!');returnValue=true;window.close();</script>");
}
else
{
this.Page.RegisterStartupScript("", "<script>alert('没有相关数据可添加!');</script>");
}
}
if (this.OperateType == "upd")
{
int num = this.hrAction.Update(data);
if (num > 0)
{
this.Page.RegisterStartupScript("", "<script>alert('修改成功!');returnValue=true;window.close();</script>");
return;
}
this.Page.RegisterStartupScript("", "<script>alert('没有相关数据可更新!');</script>");
}
}
public int Update(HROrgAdjust model)
{
StringBuilder builder = new StringBuilder();
builder.Append("update HR_Org_Adjust set ");
builder.Append("AuditState=" + model.AuditState + ",");
builder.Append("CorpCode='" + model.CorpCode + "',");
builder.Append("UserCode='" + model.UserCode + "',");
builder.Append("RecordDate='" + model.RecordDate + "',");
builder.Append("AdjustContent='" + model.AdjustContent + "',");
builder.Append("AdjustReason='" + model.AdjustReason + "',");
builder.Append("Remark='" + model.Remark + "'");
builder.Append(" where RecordID='" + model.RecordID + "'");
return(publicDbOpClass.ExecSqlString(builder.ToString()));
}
public int Add(HROrgAdjust model)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into HR_Org_Adjust(");
builder.Append("RecordID,AuditState,CorpCode,UserCode,RecordDate,AdjustContent,AdjustReason,Remark");
builder.Append(")");
builder.Append(" values (");
builder.Append("'" + model.RecordID + "',");
builder.Append(model.AuditState + ",");
builder.Append("'" + model.CorpCode + "',");
builder.Append("'" + model.UserCode + "',");
builder.Append("'" + model.RecordDate + "',");
builder.Append("'" + model.AdjustContent + "',");
builder.Append("'" + model.AdjustReason + "',");
builder.Append("'" + model.Remark + "'");
builder.Append(")");
return(publicDbOpClass.ExecSqlString(builder.ToString()));
}
