/// <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); }