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