/// <summary> /// 更新一条数据 /// </summary> public bool Update(Entity.BASE_TERM_TYPE entity) { StringBuilder strSql = new StringBuilder(); strSql.Append("update BASE_TERM_TYPE set "); strSql.Append(" TYPEID = :TYPEID , "); strSql.Append(" TYPENAME = :TYPENAME "); strSql.Append(" where TYPEID=:TYPEID "); OracleParameter[] parameters = { new OracleParameter(":TYPEID", OracleType.Number, 4), new OracleParameter(":TYPENAME", OracleType.VarChar, 50) }; parameters[2].Value = entity.TYPEID; parameters[3].Value = entity.TYPENAME; int rows = OracleHelper.ExecuteNonQuery(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Entity.BASE_TERM_TYPE GetEntity(decimal TYPEID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select TYPEID, TYPENAME "); strSql.Append(" from BASE_TERM_TYPE "); strSql.Append(" where TYPEID=:TYPEID "); OracleParameter[] parameters = { new OracleParameter(":TYPEID", OracleType.Number, 4) }; parameters[0].Value = TYPEID; Entity.BASE_TERM_TYPE entity = new Entity.BASE_TERM_TYPE(); DataTable dt = OracleHelper.Query(CommandType.Text, strSql.ToString(), parameters); if (dt.Rows.Count > 0) { if (dt.Rows[0]["TYPEID"].ToString() != "") { entity.TYPEID = decimal.Parse(dt.Rows[0]["TYPEID"].ToString()); } entity.TYPENAME = dt.Rows[0]["TYPENAME"].ToString(); return(entity); } else { return(null); } }
/// <summary> /// 增加一条数据 /// </summary> public void Add(Entity.BASE_TERM_TYPE entity) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into BASE_TERM_TYPE("); strSql.Append("TYPEID,TYPENAME"); strSql.Append(") values ("); strSql.Append(":TYPEID,:TYPENAME"); strSql.Append(") "); OracleParameter[] parameters = { new OracleParameter(":TYPEID", OracleType.Number, 4), new OracleParameter(":TYPENAME", OracleType.VarChar, 50) }; parameters[0].Value = entity.TYPEID; parameters[1].Value = entity.TYPENAME; OracleHelper.ExecuteNonQuery(strSql.ToString(), parameters); }
/// <summary> /// 更新一条数据 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool update(Entity.BASE_TERM_TYPE model) { return(dal.Update(model)); }
/// <summary> /// 添加一条数据 /// </summary> /// <param name="model"></param> public void Add(Entity.BASE_TERM_TYPE model) { dal.Add(model); }