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