public ptOfficeResResources GetModel(int RecordID)
{
StringBuilder builder = new StringBuilder();
builder.Append(" select RecordID,TypeCode,ResCode,ResName,UseType,GetType,Unit,PlanFee ");
builder.Append(" from OA_OfficeRes_Resources ");
builder.Append(" where RecordID=" + RecordID + " ");
ptOfficeResResources resources = new ptOfficeResResources();
DataSet set = publicDbOpClass.DataSetQuary(builder.ToString());
if (set.Tables[0].Rows.Count <= 0)
{
return(null);
}
if (set.Tables[0].Rows[0]["RecordID"].ToString() != "")
{
resources.RecordID = int.Parse(set.Tables[0].Rows[0]["RecordID"].ToString());
}
resources.TypeCode = set.Tables[0].Rows[0]["TypeCode"].ToString();
resources.ResCode = set.Tables[0].Rows[0]["ResCode"].ToString();
resources.ResName = set.Tables[0].Rows[0]["ResName"].ToString();
resources.UseType = set.Tables[0].Rows[0]["UseType"].ToString();
resources.GetType = set.Tables[0].Rows[0]["GetType"].ToString();
resources.Unit = set.Tables[0].Rows[0]["Unit"].ToString();
if (set.Tables[0].Rows[0]["PlanFee"].ToString() != "")
{
resources.PlanFee = decimal.Parse(set.Tables[0].Rows[0]["PlanFee"].ToString());
}
return(resources);
}
protected void btnAdd_Click(object sender, EventArgs e)
{
ptOfficeResResources 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(ptOfficeResResources model)
{
StringBuilder builder = new StringBuilder();
builder.Append("update OA_OfficeRes_Resources set ");
builder.Append("ResName='" + model.ResName + "',");
builder.Append("UseType='" + model.UseType + "',");
builder.Append("GetType='" + model.GetType + "',");
builder.Append("Unit='" + model.Unit + "',");
builder.Append("PlanFee=" + model.PlanFee);
builder.Append(" where RecordID=" + model.RecordID);
return(publicDbOpClass.ExecSqlString(builder.ToString()));
}
private void EditDisplay()
{
ptOfficeResResources model = this.hrAction.GetModel(this.RecordID);
if (model != null)
{
this.txtPlanFee.Text = model.PlanFee.ToString("f2");
this.txtUnit.Text = model.Unit;
this.txtResName.Text = model.ResName;
this.DDLUseType.SelectedValue = model.UseType;
this.DDLGetType.SelectedValue = model.GetType;
}
}
public int Add(ptOfficeResResources model)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into OA_OfficeRes_Resources(");
builder.Append("TypeCode,ResCode,ResName,UseType,GetType,Unit,PlanFee");
builder.Append(")");
builder.Append(" values (");
builder.Append("'" + model.TypeCode + "',");
builder.Append("'" + model.ResCode + "',");
builder.Append("'" + model.ResName + "',");
builder.Append("'" + model.UseType + "',");
builder.Append("'" + model.GetType + "',");
builder.Append("'" + model.Unit + "',");
builder.Append(model.PlanFee);
builder.Append(")");
return(publicDbOpClass.ExecSqlString(builder.ToString()));
}
