/// <summary>
/// 增加一条数据
/// </summary>
public void Add(Entity.BASE_ARTICLE_TYPE model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into BASE_ARTICLE_TYPE(");
strSql.Append("ID,TYPENAME,SUMMARY,STATUS,PARENT,SORT,DEPTID");
strSql.Append(") values (");
strSql.Append(":ID,:TYPENAME,:SUMMARY,:STATUS,:PARENT,:SORT,:DEPTID");
strSql.Append(") ");
OracleParameter[] parameters =
{
new OracleParameter(":ID", OracleType.Number, 4),
new OracleParameter(":TYPENAME", OracleType.VarChar, 50),
new OracleParameter(":SUMMARY", OracleType.VarChar, 200),
new OracleParameter(":STATUS", OracleType.Number, 4),
new OracleParameter(":PARENT", OracleType.Number, 4),
new OracleParameter(":SORT", OracleType.Number, 4),
new OracleParameter(":DEPTID", OracleType.Number, 4)
};
parameters[0].Value = model.ID;
parameters[1].Value = model.TYPENAME;
parameters[2].Value = model.SUMMARY;
parameters[3].Value = model.STATUS;
parameters[4].Value = model.PARENT;
parameters[5].Value = model.SORT;
parameters[6].Value = model.DEPTID;
OracleHelper.ExecuteNonQuery(strSql.ToString(), parameters);
}
private void SetModel(Entity.BASE_ARTICLE_TYPE model)
{
txtTitle.Text = model.TYPENAME;
txtSummary.Text = model.SUMMARY;
txtSort.Text = model.SORT.ToString();
hidPrimary.Value = model.ID.ToString();
ddlTypeId.SelectedValue = model.PARENT.ToString();
}
private Entity.BASE_ARTICLE_TYPE GetModel()
{
Entity.BASE_ARTICLE_TYPE model = new Entity.BASE_ARTICLE_TYPE();
model.DEPTID = userSession.DEPTID;
model.ID = Convert.ToInt32(hidPrimary.Value);
model.PARENT = Convert.ToInt32(ddlTypeId.SelectedValue);
model.SORT = Convert.ToInt32(txtSort.Text.Trim());
model.STATUS = 0;
model.SUMMARY = txtSummary.Text.Trim();
model.TYPENAME = txtTitle.Text.Trim();
return(model);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Entity.BASE_ARTICLE_TYPE GetEntity(decimal ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ID, TYPENAME, SUMMARY, STATUS, PARENT, SORT, DEPTID ");
strSql.Append(" from BASE_ARTICLE_TYPE ");
strSql.Append(" where ID=:ID ");
OracleParameter[] parameters =
{
new OracleParameter(":ID", OracleType.Number, 4)
};
parameters[0].Value = ID;
Entity.BASE_ARTICLE_TYPE entity = new Entity.BASE_ARTICLE_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());
}
entity.TYPENAME = dt.Rows[0]["TYPENAME"].ToString();
entity.SUMMARY = dt.Rows[0]["SUMMARY"].ToString();
if (dt.Rows[0]["STATUS"].ToString() != "")
{
entity.STATUS = decimal.Parse(dt.Rows[0]["STATUS"].ToString());
}
if (dt.Rows[0]["PARENT"].ToString() != "")
{
entity.PARENT = decimal.Parse(dt.Rows[0]["PARENT"].ToString());
}
if (dt.Rows[0]["SORT"].ToString() != "")
{
entity.SORT = decimal.Parse(dt.Rows[0]["SORT"].ToString());
}
if (dt.Rows[0]["DEPTID"].ToString() != "")
{
entity.DEPTID = decimal.Parse(dt.Rows[0]["DEPTID"].ToString());
}
return(entity);
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Entity.BASE_ARTICLE_TYPE model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update BASE_ARTICLE_TYPE set ");
strSql.Append(" ID = :ID , ");
strSql.Append(" TYPENAME = :TYPENAME , ");
strSql.Append(" SUMMARY = :SUMMARY , ");
strSql.Append(" STATUS = :STATUS , ");
strSql.Append(" PARENT = :PARENT , ");
strSql.Append(" SORT = :SORT , ");
strSql.Append(" DEPTID = :DEPTID ");
strSql.Append(" where ID=:ID ");
OracleParameter[] parameters =
{
new OracleParameter(":ID", OracleType.Number, 4),
new OracleParameter(":TYPENAME", OracleType.VarChar, 50),
new OracleParameter(":SUMMARY", OracleType.VarChar, 200),
new OracleParameter(":STATUS", OracleType.Number, 4),
new OracleParameter(":PARENT", OracleType.Number, 4),
new OracleParameter(":SORT", OracleType.Number, 4),
new OracleParameter(":DEPTID", OracleType.Number, 4)
};
parameters[0].Value = model.ID;
parameters[1].Value = model.TYPENAME;
parameters[2].Value = model.SUMMARY;
parameters[3].Value = model.STATUS;
parameters[4].Value = model.PARENT;
parameters[5].Value = model.SORT;
parameters[6].Value = model.DEPTID;
int rows = OracleHelper.ExecuteNonQuery(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
protected void btnAdd_Click(object sender, EventArgs e)
{
Entity.BASE_ARTICLE_TYPE model = new Entity.BASE_ARTICLE_TYPE();
model = GetModel();
if (CheckModel(model))
{
if (model.ID < 0)
{
bll.Add(model);
}
else
{
bll.Update(model);
}
Response.Redirect("List.aspx", true);
}
}
private bool CheckModel(Entity.BASE_ARTICLE_TYPE model)
{
if (string.IsNullOrWhiteSpace(txtTitle.Text))
{
litmsg.Visible = true;
litmsg.Text = "<div style='font-size:16px; font-family:微软雅黑; color:red;font-weight:bold; text-align:center;float:left;'>标题不能为空!</div>";
txtTitle.Focus();
return(false);
}
if (string.IsNullOrWhiteSpace(txtSummary.Text))
{
litmsg.Visible = true;
litmsg.Text = "<div style='font-size:16px; font-family:微软雅黑; color:red;font-weight:bold; text-align:center;float:left;'>描述不能为空!</div>";
txtSummary.Focus();
return(false);
}
return(true);
}
public void Add(Entity.BASE_ARTICLE_TYPE model)
{
dal.Add(model);
}
public void Update(Entity.BASE_ARTICLE_TYPE model)
{
dal.Update(model);
}
