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