protected void btnAdd_Click(object sender, EventArgs e)
{
OAOfficeResPersonalApplication data = this.GetData();
if (this.OperateType == "add")
{
int num = this.amAction.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.amAction.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(OAOfficeResPersonalApplication model)
{
StringBuilder builder = new StringBuilder();
builder.Append("update OA_OfficeRes_PersonalApplication set ");
builder.Append("ApplyMan='" + model.ApplyMan + "',");
builder.Append("UseMan='" + model.UseMan + "',");
builder.Append("CorpCode='" + model.CorpCode + "'");
builder.Append(" where PARecordID=" + model.PARecordID);
return(publicDbOpClass.ExecSqlString(builder.ToString()));
}
public int Add(OAOfficeResPersonalApplication model)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into OA_OfficeRes_PersonalApplication(");
builder.Append("CorpCode,ApplyDate,ApplyMan,UseMan,IsSubmit,IsComplete,UserCode,RecordDate,ACRecordID");
builder.Append(")");
builder.Append(" values (");
builder.Append("'" + model.CorpCode + "',");
builder.Append("'" + model.ApplyDate + "',");
builder.Append("'" + model.ApplyMan + "',");
builder.Append("'" + model.UseMan + "',");
builder.Append("'" + model.IsSubmit + "',");
builder.Append("'" + model.IsComplete + "',");
builder.Append("'" + model.UserCode + "',");
builder.Append("'" + model.RecordDate + "',");
builder.Append("'" + model.ACRecordID + "'");
builder.Append(")");
return(publicDbOpClass.ExecSqlString(builder.ToString()));
}
public OAOfficeResPersonalApplication GetModel(int PARecordID)
{
StringBuilder builder = new StringBuilder();
builder.Append("select * ");
builder.Append(" PARecordID,CorpCode,ApplyDate,ApplyMan,UseMan,IsSubmit,IsComplete,UserCode,RecordDate,ACRecordID ");
builder.Append(" from OA_OfficeRes_PersonalApplication ");
builder.Append(" where PARecordID=" + PARecordID);
OAOfficeResPersonalApplication application = new OAOfficeResPersonalApplication();
DataSet set = publicDbOpClass.DataSetQuary(builder.ToString());
if (set.Tables[0].Rows.Count <= 0)
{
return(null);
}
if (set.Tables[0].Rows[0]["PARecordID"].ToString() != "")
{
application.PARecordID = int.Parse(set.Tables[0].Rows[0]["PARecordID"].ToString());
}
application.CorpCode = set.Tables[0].Rows[0]["CorpCode"].ToString();
if (set.Tables[0].Rows[0]["ApplyDate"].ToString() != "")
{
application.ApplyDate = DateTime.Parse(set.Tables[0].Rows[0]["ApplyDate"].ToString());
}
application.ApplyMan = set.Tables[0].Rows[0]["ApplyMan"].ToString();
application.UseMan = set.Tables[0].Rows[0]["UseMan"].ToString();
application.IsSubmit = set.Tables[0].Rows[0]["IsSubmit"].ToString();
application.IsComplete = set.Tables[0].Rows[0]["IsComplete"].ToString();
application.UserCode = set.Tables[0].Rows[0]["UserCode"].ToString();
if (set.Tables[0].Rows[0]["RecordDate"].ToString() != "")
{
application.RecordDate = DateTime.Parse(set.Tables[0].Rows[0]["RecordDate"].ToString());
}
if (set.Tables[0].Rows[0]["ACRecordID"].ToString() != "")
{
application.ACRecordID = new Guid(set.Tables[0].Rows[0]["ACRecordID"].ToString());
}
return(application);
}
