/// <summary>
/// 更新一条数据
/// </summary>
public int Update(Model.TASKSCHEME_PRIVATE_ORBIT model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("UPDATE LHF.TASKSCHEME_PRIVATE_ORBIT SET ");
strSql.Append("SAT_ORBITEPOCH=@in_SAT_ORBITEPOCH,");
strSql.Append("SAT_MEANMOTION=@in_SAT_MEANMOTION,");
strSql.Append("SAT_ECCENTRICITY=@in_SAT_ECCENTRICITY,");
strSql.Append("SAT_INCLINATION=@in_SAT_INCLINATION,");
strSql.Append("SAT_ARGOFPERIGEE=@in_SAT_ARGOFPERIGEE,");
strSql.Append("SAT_RAAN=@in_SAT_RAAN,");
strSql.Append("SAT_MEANANOMALY=@in_SAT_MEANANOMALY,");
strSql.Append("SAT_MEANMOTIONDOT=@in_SAT_MEANMOTIONDOT,");
strSql.Append("SAT_MEANMOTIONDOTDOT=@in_SAT_MEANMOTIONDOTDOT,");
strSql.Append("SAT_BSTAR=@in_SAT_BSTAR,");
strSql.Append("SAT_TLE1=@in_SAT_TLE1,");
strSql.Append("SAT_TLE2=@in_SAT_TLE2,");
strSql.Append("SCHEMEID=@in_SCHEMEID");
strSql.Append(" WHERE SAT_ID=@in_SAT_ID");
SqlParameter[] cmdParms = new SqlParameter[] {
new SqlParameter("@in_SAT_ID", SqlDbType.Decimal),
new SqlParameter("@in_SAT_ORBITEPOCH", SqlDbType.NVarChar),
new SqlParameter("@in_SAT_MEANMOTION", SqlDbType.NVarChar),
new SqlParameter("@in_SAT_ECCENTRICITY", SqlDbType.NVarChar),
new SqlParameter("@in_SAT_INCLINATION", SqlDbType.NVarChar),
new SqlParameter("@in_SAT_ARGOFPERIGEE", SqlDbType.NVarChar),
new SqlParameter("@in_SAT_RAAN", SqlDbType.NVarChar),
new SqlParameter("@in_SAT_MEANANOMALY", SqlDbType.NVarChar),
new SqlParameter("@in_SAT_MEANMOTIONDOT", SqlDbType.NVarChar),
new SqlParameter("@in_SAT_MEANMOTIONDOTDOT", SqlDbType.NVarChar),
new SqlParameter("@in_SAT_BSTAR", SqlDbType.NVarChar),
new SqlParameter("@in_SAT_TLE1", SqlDbType.NVarChar),
new SqlParameter("@in_SAT_TLE2", SqlDbType.NVarChar),
new SqlParameter("@in_SCHEMEID", SqlDbType.Int)
};
cmdParms[0].Value = model.SAT_ID;
cmdParms[1].Value = model.SAT_ORBITEPOCH;
cmdParms[2].Value = model.SAT_MEANMOTION;
cmdParms[3].Value = model.SAT_ECCENTRICITY;
cmdParms[4].Value = model.SAT_INCLINATION;
cmdParms[5].Value = model.SAT_ARGOFPERIGEE;
cmdParms[6].Value = model.SAT_RAAN;
cmdParms[7].Value = model.SAT_MEANANOMALY;
cmdParms[8].Value = model.SAT_MEANMOTIONDOT;
cmdParms[9].Value = model.SAT_MEANMOTIONDOTDOT;
cmdParms[10].Value = model.SAT_BSTAR;
cmdParms[11].Value = model.SAT_TLE1;
cmdParms[12].Value = model.SAT_TLE2;
cmdParms[13].Value = model.SCHEMEID;
return(DbHelperSQL.ExecuteSql(strSql.ToString(), cmdParms));
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.TASKSCHEME_PRIVATE_ORBIT GetModel(decimal SAT_ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT * FROM LHF.TASKSCHEME_PRIVATE_ORBIT ");
strSql.Append(" WHERE SAT_ID=" + SAT_ID);
Model.TASKSCHEME_PRIVATE_ORBIT model = null;
using (DbDataReader dr = DbHelperSQL.ExecuteReader(strSql.ToString()))
{
while (dr.Read())
{
model = GetModel(dr);
}
return(model);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Model.TASKSCHEME_PRIVATE_ORBIT model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("INSERT INTO LHF.TASKSCHEME_PRIVATE_ORBIT(");
strSql.Append("SAT_ID,SAT_ORBITEPOCH,SAT_MEANMOTION,SAT_ECCENTRICITY,SAT_INCLINATION,SAT_ARGOFPERIGEE,SAT_RAAN,SAT_MEANANOMALY,SAT_MEANMOTIONDOT,SAT_MEANMOTIONDOTDOT,SAT_BSTAR,SAT_TLE1,SAT_TLE2,SCHEMEID)");
strSql.Append(" VALUES (");
strSql.Append("@in_SAT_ID,@in_SAT_ORBITEPOCH,@in_SAT_MEANMOTION,@in_SAT_ECCENTRICITY,@in_SAT_INCLINATION,@in_SAT_ARGOFPERIGEE,@in_SAT_RAAN,@in_SAT_MEANANOMALY,@in_SAT_MEANMOTIONDOT,@in_SAT_MEANMOTIONDOTDOT,@in_SAT_BSTAR,,@in_SAT_TLE1,@in_SAT_TLE2,@in_SCHEMEID)");
SqlParameter[] cmdParms = new SqlParameter[] {
new SqlParameter("@in_SAT_ID", SqlDbType.Decimal),
new SqlParameter("@in_SAT_ORBITEPOCH", SqlDbType.NVarChar),
new SqlParameter("@in_SAT_MEANMOTION", SqlDbType.NVarChar),
new SqlParameter("@in_SAT_ECCENTRICITY", SqlDbType.NVarChar),
new SqlParameter("@in_SAT_INCLINATION", SqlDbType.NVarChar),
new SqlParameter("@in_SAT_ARGOFPERIGEE", SqlDbType.NVarChar),
new SqlParameter("@in_SAT_RAAN", SqlDbType.NVarChar),
new SqlParameter("@in_SAT_MEANANOMALY", SqlDbType.NVarChar),
new SqlParameter("@in_SAT_MEANMOTIONDOT", SqlDbType.NVarChar),
new SqlParameter("@in_SAT_MEANMOTIONDOTDOT", SqlDbType.NVarChar),
new SqlParameter("@in_SAT_BSTAR", SqlDbType.NVarChar),
new SqlParameter("@in_SAT_TLE1", SqlDbType.NVarChar),
new SqlParameter("@in_SAT_TLE2", SqlDbType.NVarChar),
new SqlParameter("@in_SCHEMEID", SqlDbType.Int)
};
cmdParms[0].Value = model.SAT_ID;
cmdParms[1].Value = model.SAT_ORBITEPOCH;
cmdParms[2].Value = model.SAT_MEANMOTION;
cmdParms[3].Value = model.SAT_ECCENTRICITY;
cmdParms[4].Value = model.SAT_INCLINATION;
cmdParms[5].Value = model.SAT_ARGOFPERIGEE;
cmdParms[6].Value = model.SAT_RAAN;
cmdParms[7].Value = model.SAT_MEANANOMALY;
cmdParms[8].Value = model.SAT_MEANMOTIONDOT;
cmdParms[9].Value = model.SAT_MEANMOTIONDOTDOT;
cmdParms[10].Value = model.SAT_BSTAR;
cmdParms[11].Value = model.SAT_TLE1;
cmdParms[12].Value = model.SAT_TLE2;
cmdParms[13].Value = model.SCHEMEID;
return(DbHelperSQL.ExecuteSql(strSql.ToString(), cmdParms));
}
/// <summary>
/// 由一行数据得到一个实体
/// </summary>
private Model.TASKSCHEME_PRIVATE_ORBIT GetModel(DbDataReader dr)
{
Model.TASKSCHEME_PRIVATE_ORBIT model = new Model.TASKSCHEME_PRIVATE_ORBIT();
model.SAT_ID = Convert.ToDecimal(dr["SAT_ID"]);
model.SAT_ORBITEPOCH = Convert.ToString(dr["SAT_ORBITEPOCH"]);
model.SAT_MEANMOTION = Convert.ToString(dr["SAT_MEANMOTION"]);
model.SAT_ECCENTRICITY = Convert.ToString(dr["SAT_ECCENTRICITY"]);
model.SAT_INCLINATION = Convert.ToString(dr["SAT_INCLINATION"]);
model.SAT_ARGOFPERIGEE = Convert.ToString(dr["SAT_ARGOFPERIGEE"]);
model.SAT_RAAN = Convert.ToString(dr["SAT_RAAN"]);
model.SAT_MEANANOMALY = Convert.ToString(dr["SAT_MEANANOMALY"]);
model.SAT_MEANMOTIONDOT = Convert.ToString(dr["SAT_MEANMOTIONDOT"]);
model.SAT_MEANMOTIONDOTDOT = Convert.ToString(dr["SAT_MEANMOTIONDOTDOT"]);
model.SAT_BSTAR = Convert.ToString(dr["SAT_BSTAR"]);
try
{
model.SAT_TLE1 = Convert.ToString(dr["SAT_TLE1"]);
}
catch (Exception e)
{
model.SAT_TLE1 = "";
}
try
{
model.SAT_TLE2 = Convert.ToString(dr["SAT_TLE2"]);
}
catch (Exception e)
{
model.SAT_TLE2 = "";
}
try
{
model.SCHEMEID = Convert.ToInt32(dr["SCHEMEID"]);
}
catch (Exception e)
{
model.SCHEMEID = 0;
}
return(model);
}