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