protected void btnSubmit_Click(object sender, EventArgs e)
{
litmsg.Visible = false;
Entity.BASE_ASSESS_TYPE model = new Entity.BASE_ASSESS_TYPE();
model = this.GetEntity();
if (this.CheckEntity(model))
{
if (model.ID < 0)
{
bll.Add(model);
this.SetEntity(new Entity.BASE_ASSESS_TYPE());
this.BindDataSource();
litmsg.Visible = true;
litmsg.Text = "<div style='font-size:16px; font-family:微软雅黑; color:red;font-weight:bold; text-align:center;'>添加成功!</div>";
}
else
{
if (bll.Update(model))
{
litmsg.Visible = true;
litmsg.Text = "<div style='font-size:16px; font-family:微软雅黑; color:red;font-weight:bold; text-align:center;'>更新成功!</div>";
}
else
{
litmsg.Visible = true;
litmsg.Text = "<div style='font-size:16px; font-family:微软雅黑; color:red;font-weight:bold; text-align:center;'>更新失败!</div>";
}
}
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(Entity.BASE_ASSESS_TYPE model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into BASE_ASSESS_TYPE(");
strSql.Append("ID,DEPTCODE,NAME,SUMMARY,PARENTID,SORT,STATUS,SCORE");
strSql.Append(") values (");
strSql.Append(":ID,:DEPTCODE,:NAME,:SUMMARY,:PARENTID,:SORT,:STATUS,:SCORE");
strSql.Append(") ");
OracleParameter[] parameters =
{
new OracleParameter(":ID", OracleType.Number, 4),
new OracleParameter(":DEPTCODE", OracleType.Number, 4),
new OracleParameter(":NAME", OracleType.VarChar, 50),
new OracleParameter(":SUMMARY", OracleType.VarChar, 200),
new OracleParameter(":PARENTID", OracleType.Number, 4),
new OracleParameter(":SORT", OracleType.Number, 4),
new OracleParameter(":STATUS", OracleType.Number, 4),
new OracleParameter(":SCORE", OracleType.Number, 4)
};
parameters[0].Value = model.ID;
parameters[1].Value = model.DEPTCODE;
parameters[2].Value = model.NAME;
parameters[3].Value = model.SUMMARY;
parameters[4].Value = model.PARENTID;
parameters[5].Value = model.SORT;
parameters[6].Value = model.STATUS;
parameters[7].Value = model.SCORE;
OracleHelper.ExecuteNonQuery(strSql.ToString(), parameters);
}
private void SetEntity(Entity.BASE_ASSESS_TYPE model)
{
txtName.Text = model.NAME;
txtSummary.Text = model.SUMMARY;
txtScore.Text = model.SCORE.ToString();
txtSort.Text = model.SORT.ToString();
ddlParentType.SelectedValue = model.PARENTID.ToString();
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Entity.BASE_ASSESS_TYPE GetEntity(decimal ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ID, DEPTCODE, NAME, SUMMARY, PARENTID, SORT, STATUS, SCORE ");
strSql.Append(" from BASE_ASSESS_TYPE ");
strSql.Append(" where ID=:ID ");
OracleParameter[] parameters =
{
new OracleParameter(":ID", OracleType.Number, 4)
};
parameters[0].Value = ID;
Entity.BASE_ASSESS_TYPE entity = new Entity.BASE_ASSESS_TYPE();
DataTable dt = OracleHelper.Query(CommandType.Text, strSql.ToString(), parameters);
if (dt.Rows.Count > 0)
{
if (dt.Rows[0]["ID"].ToString() != "")
{
entity.ID = decimal.Parse(dt.Rows[0]["ID"].ToString());
}
if (dt.Rows[0]["DEPTCODE"].ToString() != "")
{
entity.DEPTCODE = decimal.Parse(dt.Rows[0]["DEPTCODE"].ToString());
}
entity.NAME = dt.Rows[0]["NAME"].ToString();
entity.SUMMARY = dt.Rows[0]["SUMMARY"].ToString();
if (dt.Rows[0]["PARENTID"].ToString() != "")
{
entity.PARENTID = decimal.Parse(dt.Rows[0]["PARENTID"].ToString());
}
if (dt.Rows[0]["SORT"].ToString() != "")
{
entity.SORT = decimal.Parse(dt.Rows[0]["SORT"].ToString());
}
if (dt.Rows[0]["STATUS"].ToString() != "")
{
entity.STATUS = decimal.Parse(dt.Rows[0]["STATUS"].ToString());
}
if (dt.Rows[0]["SCORE"].ToString() != "")
{
entity.SCORE = decimal.Parse(dt.Rows[0]["SCORE"].ToString());
}
return(entity);
}
else
{
return(null);
}
}
private Entity.BASE_ASSESS_TYPE GetEntity()
{
Entity.BASE_ASSESS_TYPE model = new Entity.BASE_ASSESS_TYPE();
model.NAME = txtName.Text;
model.SUMMARY = txtSummary.Text;
model.SCORE = Convert.ToDecimal(txtScore.Text);
model.SORT = Convert.ToDecimal(txtSort.Text);
model.PARENTID = Convert.ToDecimal(ddlParentType.SelectedValue);
model.DEPTCODE = session.DEPTID;
model.ID = Convert.ToDecimal(hidPrimary.Value);
model.STATUS = 0;
return(model);
}
protected void Page_Load(object sender, EventArgs e)
{
session = (Utility.UserSession)Session["user"];
if (!IsPostBack)
{
BindDataSource();
if (Request.QueryString["id"] != null)
{
Entity.BASE_ASSESS_TYPE model = new Entity.BASE_ASSESS_TYPE();
model = bll.GetEntity(Convert.ToDecimal(Request.QueryString["id"]));
this.SetEntity(model);
}
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Entity.BASE_ASSESS_TYPE model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update BASE_ASSESS_TYPE set ");
strSql.Append(" ID = :ID , ");
strSql.Append(" DEPTCODE = :DEPTCODE , ");
strSql.Append(" NAME = :NAME , ");
strSql.Append(" SUMMARY = :SUMMARY , ");
strSql.Append(" PARENTID = :PARENTID , ");
strSql.Append(" SORT = :SORT , ");
strSql.Append(" STATUS = :STATUS , ");
strSql.Append(" SCORE = :SCORE ");
strSql.Append(" where ID=:ID ");
OracleParameter[] parameters =
{
new OracleParameter(":ID", OracleType.Number, 4),
new OracleParameter(":DEPTCODE", OracleType.Number, 4),
new OracleParameter(":NAME", OracleType.VarChar, 50),
new OracleParameter(":SUMMARY", OracleType.VarChar, 200),
new OracleParameter(":PARENTID", OracleType.Number, 4),
new OracleParameter(":SORT", OracleType.Number, 4),
new OracleParameter(":STATUS", OracleType.Number, 4),
new OracleParameter(":SCORE", OracleType.Number, 4)
};
parameters[8].Value = model.ID;
parameters[9].Value = model.DEPTCODE;
parameters[10].Value = model.NAME;
parameters[11].Value = model.SUMMARY;
parameters[12].Value = model.PARENTID;
parameters[13].Value = model.SORT;
parameters[14].Value = model.STATUS;
parameters[15].Value = model.SCORE;
int rows = OracleHelper.ExecuteNonQuery(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
public bool Update(Entity.BASE_ASSESS_TYPE model)
{
return(dal.Update(model));
}
public void Add(Entity.BASE_ASSESS_TYPE model)
{
dal.Add(model);
}
private bool CheckEntity(Entity.BASE_ASSESS_TYPE model)
{
return(true);
}
