/// <summary>
/// 增加一条数据
/// </summary>
public void Add(Entity.BASE_COMPS entity)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into BASE_COMPS(");
strSql.Append("ID,COMPSNAME,UNIT,MONEY,REMARK");
strSql.Append(") values (");
strSql.Append(":ID,:COMPSNAME,:UNIT,:MONEY,:REMARK");
strSql.Append(") ");
OracleParameter[] parameters =
{
new OracleParameter(":ID", OracleType.Number, 4),
new OracleParameter(":COMPSNAME", OracleType.VarChar, 50),
new OracleParameter(":UNIT", OracleType.VarChar, 10),
new OracleParameter(":MONEY", OracleType.Number, 4),
new OracleParameter(":REMARK", OracleType.VarChar, 50)
};
parameters[0].Value = entity.ID;
parameters[1].Value = entity.COMPSNAME;
parameters[2].Value = entity.UNIT;
parameters[3].Value = entity.MONEY;
parameters[4].Value = entity.REMARK;
OracleHelper.ExecuteNonQuery(strSql.ToString(), parameters);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Entity.BASE_COMPS entity)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update BASE_COMPS set ");
strSql.Append(" ID = :ID , ");
strSql.Append(" COMPSNAME = :COMPSNAME , ");
strSql.Append(" UNIT = :UNIT , ");
strSql.Append(" MONEY = :MONEY , ");
strSql.Append(" REMARK = :REMARK ");
strSql.Append(" where ID=:ID ");
OracleParameter[] parameters =
{
new OracleParameter(":ID", OracleType.Number, 4),
new OracleParameter(":COMPSNAME", OracleType.VarChar, 50),
new OracleParameter(":UNIT", OracleType.VarChar, 10),
new OracleParameter(":MONEY", OracleType.Number, 4),
new OracleParameter(":REMARK", OracleType.VarChar, 50)
};
parameters[5].Value = entity.ID;
parameters[6].Value = entity.COMPSNAME;
parameters[7].Value = entity.UNIT;
parameters[8].Value = entity.MONEY;
parameters[9].Value = entity.REMARK;
int rows = OracleHelper.ExecuteNonQuery(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Entity.BASE_COMPS GetEntity(decimal ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ID, COMPSNAME, UNIT, MONEY, REMARK ");
strSql.Append(" from BASE_COMPS ");
strSql.Append(" where ID=:ID ");
OracleParameter[] parameters =
{
new OracleParameter(":ID", OracleType.Number, 4)
};
parameters[0].Value = ID;
Entity.BASE_COMPS entity = new Entity.BASE_COMPS();
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.COMPSNAME = dt.Rows[0]["COMPSNAME"].ToString();
entity.UNIT = dt.Rows[0]["UNIT"].ToString();
if (dt.Rows[0]["MONEY"].ToString() != "")
{
entity.MONEY = decimal.Parse(dt.Rows[0]["MONEY"].ToString());
}
entity.REMARK = dt.Rows[0]["REMARK"].ToString();
return(entity);
}
else
{
return(null);
}
}
