/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Model.Satellite model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("INSERT INTO LHF.SATELLITE_INFO(");
strSql.Append("SAT_ID,SAT_COSPAR,SAT_SHORTNAME,SAT_LONGNAME,SAT_FULLNAME,SAT_ORBITCLASS,SAT_ORBITTYPE,SAT_LONGITUDEOFGEO,SAT_APPLICATION,SAT_COUNTRY,SAT_USES,SAT_AGENCIES,SAT_DESCRIPTION,SAT_DESCRIPTION2,SAT_LAUNCHTIME,SAT_EOLTIME,SAT_REPEATCYCLE,SAT_DATAACCESS,SAT_CHARTER,MAXGSD,MAXSW)");
strSql.Append(" VALUES (");
strSql.Append("@in_SAT_ID,@in_SAT_COSPAR,@in_SAT_SHORTNAME,@in_SAT_LONGNAME,@in_SAT_FULLNAME,@in_SAT_ORBITCLASS,@in_SAT_ORBITTYPE,@in_SAT_LONGITUDEOFGEO,@in_SAT_APPLICATION,@in_SAT_COUNTRY,@in_SAT_USES,@in_SAT_AGENCIES,@in_SAT_DESCRIPTION,@in_SAT_DESCRIPTION2,@in_SAT_LAUNCHTIME,@in_SAT_EOLTIME,@in_SAT_REPEATCYCLE,@in_SAT_DATAACCESS,@in_SAT_CHARTER,@in_MAXGSD,@in_MAXSW)");
SqlParameter[] cmdParms = new SqlParameter[] {
new SqlParameter("@in_SAT_ID", SqlDbType.Decimal),
new SqlParameter("@in_SAT_COSPAR", SqlDbType.NVarChar),
new SqlParameter("@in_SAT_SHORTNAME", SqlDbType.NVarChar),
new SqlParameter("@in_SAT_LONGNAME", SqlDbType.NVarChar),
new SqlParameter("@in_SAT_FULLNAME", SqlDbType.NVarChar),
new SqlParameter("@in_SAT_ORBITCLASS", SqlDbType.NVarChar),
new SqlParameter("@in_SAT_ORBITTYPE", SqlDbType.NVarChar),
new SqlParameter("@in_SAT_LONGITUDEOFGEO", SqlDbType.Decimal),
new SqlParameter("@in_SAT_APPLICATION", SqlDbType.NVarChar),
new SqlParameter("@in_SAT_COUNTRY", SqlDbType.NVarChar),
new SqlParameter("@in_SAT_USES", SqlDbType.NVarChar),
new SqlParameter("@in_SAT_AGENCIES", SqlDbType.NVarChar),
new SqlParameter("@in_SAT_DESCRIPTION", SqlDbType.NVarChar),
new SqlParameter("@in_SAT_DESCRIPTION2", SqlDbType.NVarChar),
new SqlParameter("@in_SAT_LAUNCHTIME", SqlDbType.DateTime),
new SqlParameter("@in_SAT_EOLTIME", SqlDbType.DateTime),
new SqlParameter("@in_SAT_REPEATCYCLE", SqlDbType.Decimal),
new SqlParameter("@in_SAT_DATAACCESS", SqlDbType.NVarChar),
new SqlParameter("@in_SAT_CHARTER", SqlDbType.Decimal),
new SqlParameter("@in_MAXGSD", SqlDbType.Decimal),
new SqlParameter("@in_MAXSW", SqlDbType.Decimal)
};
cmdParms[0].Value = model.SAT_ID;
cmdParms[1].Value = model.SAT_COSPAR;
cmdParms[2].Value = model.SAT_SHORTNAME;
cmdParms[3].Value = model.SAT_LONGNAME;
cmdParms[4].Value = model.SAT_FULLNAME;
cmdParms[5].Value = model.SAT_ORBITCLASS;
cmdParms[6].Value = model.SAT_ORBITTYPE;
cmdParms[7].Value = model.SAT_LONGITUDEOFGEO;
cmdParms[8].Value = model.SAT_APPLICATION;
cmdParms[9].Value = model.SAT_COUNTRY;
cmdParms[10].Value = model.SAT_USES;
cmdParms[11].Value = model.SAT_AGENCIES;
cmdParms[12].Value = model.SAT_DESCRIPTION;
cmdParms[13].Value = model.SAT_DESCRIPTION2;
cmdParms[14].Value = model.SAT_LAUNCHTIME;
cmdParms[15].Value = model.SAT_EOLTIME;
cmdParms[16].Value = model.SAT_REPEATCYCLE;
cmdParms[17].Value = model.SAT_DATAACCESS;
cmdParms[18].Value = model.SAT_CHARTER;
cmdParms[19].Value = model.MAXGSD;
cmdParms[20].Value = model.MAXSW;
return(DbHelperSQL.ExecuteSql(strSql.ToString(), cmdParms));
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.Satellite GetModel(decimal SAT_ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT * FROM LHF.SATELLITE_INFO ");
strSql.Append(" WHERE SAT_ID=" + SAT_ID);
Model.Satellite model = null;
using (DbDataReader dr = DbHelperSQL.ExecuteReader(strSql.ToString()))
{
while (dr.Read())
{
model = GetModel(dr);
}
return(model);
}
}
