/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Model.SatelliteResault model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("INSERT INTO SAT_RESAULT(");
strSql.Append("LSTR_SEQID,SCHEMEID,TASKID,PID,POLYGONSTRING,STARTTIME,ENDTIME,COVERAGE,ACCUCOVERAGE)");
strSql.Append(" VALUES (");
strSql.Append("@in_LSTR_SEQID,@in_SCHEMEID,@in_TASKID,@in_PID,@in_POLYGONSTRING,@in_STARTTIME,@in_ENDTIME,@in_COVERAGE,@in_ACCUCOVERAGE)");
SqlParameter[] cmdParms = new SqlParameter[] {
new SqlParameter("@in_LSTR_SEQID", SqlDbType.Int),
new SqlParameter("@in_SCHEMEID", SqlDbType.Int),
new SqlParameter("@in_TASKID", SqlDbType.Int),
new SqlParameter("@in_PID", SqlDbType.Int),
new SqlParameter("@in_POLYGONSTRING", SqlDbType.NVarChar),
new SqlParameter("@in_STARTTIME", SqlDbType.DateTime),
new SqlParameter("@in_ENDTIME", SqlDbType.DateTime),
new SqlParameter("@in_COVERAGE", SqlDbType.Decimal),
new SqlParameter("@in_ACCUCOVERAGE", SqlDbType.Decimal)
};
cmdParms[0].Value = model.LSTR_SEQID;
cmdParms[1].Value = model.SCHEMEID;
cmdParms[2].Value = model.TASKID;
cmdParms[3].Value = model.PID;
cmdParms[4].Value = model.POLYGONSTRING;
cmdParms[5].Value = model.STARTTIME;
cmdParms[6].Value = model.ENDTIME;
cmdParms[7].Value = model.COVERAGE;
cmdParms[8].Value = model.ACCUCOVERAGE;
return(DbHelperSQL.ExecuteSql(strSql.ToString(), cmdParms));
}
/// <summary>
/// 由一行数据得到一个实体
/// </summary>
private Model.SatelliteResault GetModel(DbDataReader dr)
{
Model.SatelliteResault model = new Model.SatelliteResault();
model.LSTR_SEQID = DbHelperSQL.GetInt(dr["LSTR_SEQID"]);
model.SCHEMEID = DbHelperSQL.GetInt(dr["SCHEMEID"]);
model.TASKID = DbHelperSQL.GetInt(dr["TASKID"]);
model.PID = DbHelperSQL.GetInt(dr["PID"]);
model.POLYGONSTRING = DbHelperSQL.GetString(dr["POLYGONSTRING"]);
model.STARTTIME = Convert.ToDateTime(dr["STARTTIME"]);
model.ENDTIME = Convert.ToDateTime(dr["ENDTIME"]);
try
{
model.COVERAGE = Convert.ToDecimal(dr["COVERAGE"]);
}
catch (System.Exception ex)
{
model.COVERAGE = 0;
}
try
{
model.ACCUCOVERAGE = Convert.ToDecimal(dr["ACCUCOVERAGE"]);
}
catch (System.Exception ex)
{
model.ACCUCOVERAGE = 0;
}
return(model);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.SatelliteResault GetModel(int LSTR_SEQID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT * FROM SAT_RESAULT ");
strSql.Append(" WHERE LSTR_SEQID=" + LSTR_SEQID.ToString());
Model.SatelliteResault model = null;
using (SqlDataReader dr = DbHelperSQL.ExecuteReader(strSql.ToString()))
{
while (dr.Read())
{
model = GetModel(dr);
}
return(model);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(Model.SatelliteResault model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("UPDATE SAT_RESAULT SET ");
strSql.Append("SCHEMEID=@in_SCHEMEID,");
strSql.Append("TASKID=@in_TASKID,");
strSql.Append("PID=@in_PID,");
strSql.Append("POLYGONSTRING=@in_POLYGONSTRING,");
strSql.Append("STARTTIME=@in_STARTTIME,");
strSql.Append("ENDTIME=@in_ENDTIME,");
strSql.Append("COVERAGE=@in_COVERAGE,");
strSql.Append("ACCUCOVERAGE=@in_ACCUCOVERAGE");
strSql.Append(" WHERE LSTR_SEQID=@in_LSTR_SEQID");
SqlParameter[] cmdParms = new SqlParameter[] {
new SqlParameter("@in_LSTR_SEQID", SqlDbType.Int),
new SqlParameter("@in_SCHEMEID", SqlDbType.Int),
new SqlParameter("@in_TASKID", SqlDbType.Int),
new SqlParameter("@in_PID", SqlDbType.Int),
new SqlParameter("@in_POLYGONSTRING", SqlDbType.NVarChar),
new SqlParameter("@in_STARTTIME", SqlDbType.DateTime),
new SqlParameter("@in_ENDTIME", SqlDbType.DateTime),
new SqlParameter("@in_COVERAGE", SqlDbType.Decimal),
new SqlParameter("@in_ACCUCOVERAGE", SqlDbType.Decimal)
};
cmdParms[0].Value = model.LSTR_SEQID;
cmdParms[1].Value = model.SCHEMEID;
cmdParms[2].Value = model.TASKID;
cmdParms[3].Value = model.PID;
cmdParms[4].Value = model.POLYGONSTRING;
cmdParms[5].Value = model.STARTTIME;
cmdParms[6].Value = model.ENDTIME;
cmdParms[7].Value = model.COVERAGE;
cmdParms[8].Value = model.ACCUCOVERAGE;
return(DbHelperSQL.ExecuteSql(strSql.ToString(), cmdParms));
}
