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