/// <summary>
/// 由一行数据得到一个实体
/// </summary>
private Model.SatelliteAltitude GetModel(DbDataReader dr)
{
Model.SatelliteAltitude model = new Model.SatelliteAltitude();
model.SAT_ID = Convert.ToDecimal(dr["SAT_ID"]);
model.PERIGEE = Convert.ToDecimal(dr["PERIGEE"]);
model.APOGEE = Convert.ToDecimal(dr["APOGEE"]);
model.MEAN = Convert.ToDecimal(dr["MEAN"]);
return(model);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.SatelliteAltitude GetModel(decimal SAT_ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT * FROM LHF.SATELLITE_ALTITUDE ");
strSql.Append(" WHERE SAT_ID=" + SAT_ID);
Model.SatelliteAltitude model = null;
using (DbDataReader dr = DbHelperSQL.ExecuteReader(strSql.ToString()))
{
while (dr.Read())
{
model = GetModel(dr);
}
return(model);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Model.SatelliteAltitude model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("INSERT INTO LHF.SATELLITE_ALTITUDE(");
strSql.Append("SAT_ID,PERIGEE,APOGEE,MEAN)");
strSql.Append(" VALUES (");
strSql.Append("@in_SAT_ID,@in_PERIGEE,@in_APOGEE,@in_MEAN)");
SqlParameter[] cmdParms = new SqlParameter[] {
new SqlParameter("@in_SAT_ID", SqlDbType.Decimal),
new SqlParameter("@in_PERIGEE", SqlDbType.Decimal),
new SqlParameter("@in_APOGEE", SqlDbType.Decimal),
new SqlParameter("@in_MEAN", SqlDbType.Decimal)
};
cmdParms[0].Value = model.SAT_ID;
cmdParms[1].Value = model.PERIGEE;
cmdParms[2].Value = model.APOGEE;
cmdParms[3].Value = model.MEAN;
return(DbHelperSQL.ExecuteSql(strSql.ToString(), cmdParms));
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(Model.SatelliteAltitude model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("UPDATE LHF.SATELLITE_ALTITUDE SET ");
strSql.Append("PERIGEE=@in_PERIGEE,");
strSql.Append("APOGEE=@in_APOGEE,");
strSql.Append("MEAN=@in_MEAN");
strSql.Append(" WHERE SAT_ID=@in_SAT_ID");
SqlParameter[] cmdParms = new SqlParameter[] {
new SqlParameter("@in_SAT_ID", SqlDbType.Decimal),
new SqlParameter("@in_PERIGEE", SqlDbType.Decimal),
new SqlParameter("@in_APOGEE", SqlDbType.Decimal),
new SqlParameter("@in_MEAN", SqlDbType.Decimal)
};
cmdParms[0].Value = model.SAT_ID;
cmdParms[1].Value = model.PERIGEE;
cmdParms[2].Value = model.APOGEE;
cmdParms[3].Value = model.MEAN;
return(DbHelperSQL.ExecuteSql(strSql.ToString(), cmdParms));
}
