/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.TaskObsRegion GetModel(decimal TaskID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT * FROM TaskRequirements_ObsRegion ");
strSql.Append(" WHERE TaskID=" + TaskID);
Model.TaskObsRegion model = null;
using (DbDataReader dr = DbHelperSQL.ExecuteReader(strSql.ToString()))
{
while (dr.Read())
{
model = GetModel(dr);
}
return(model);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Model.TaskObsRegion model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("INSERT INTO TaskRequirements_ObsRegion(");
strSql.Append("TaskID,MinLon,MaxLon,MinLat,MaxLat)");
strSql.Append(" VALUES (");
strSql.Append("@in_TaskID,@in_MinLon,@in_MaxLon,@in_MinLat,@in_MaxLat)");
SqlParameter[] cmdParms = new SqlParameter[] {
new SqlParameter("@in_TaskID", SqlDbType.Decimal),
new SqlParameter("@in_MinLon", SqlDbType.Decimal),
new SqlParameter("@in_MaxLon", SqlDbType.Decimal),
new SqlParameter("@in_MinLat", SqlDbType.Decimal),
new SqlParameter("@in_MaxLat", SqlDbType.Decimal)
};
cmdParms[0].Value = model.TaskID;
cmdParms[1].Value = model.MinLon;
cmdParms[2].Value = model.MaxLon;
cmdParms[3].Value = model.MinLat;
cmdParms[4].Value = model.MaxLat;
return(DbHelperSQL.ExecuteSql(strSql.ToString(), cmdParms));
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(Model.TaskObsRegion model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("UPDATE TaskRequirements_ObsRegion SET ");
strSql.Append("MinLon=@in_Minlon,");
strSql.Append("MaxLon=@in_MaxLon,");
strSql.Append("MinLat=@in_MinLat,");
strSql.Append("MaxLat=@in_MaxLat");
strSql.Append(" WHERE TaskID=@in_TaskID");
SqlParameter[] cmdParms = new SqlParameter[] {
new SqlParameter("@in_TaskID", SqlDbType.Decimal),
new SqlParameter("@in_MinLon", SqlDbType.Decimal),
new SqlParameter("@in_MaxLon", SqlDbType.Decimal),
new SqlParameter("@in_MinLat", SqlDbType.Decimal),
new SqlParameter("@in_MaxLat", SqlDbType.Decimal)
};
cmdParms[0].Value = model.TaskID;
cmdParms[1].Value = model.MinLon;
cmdParms[2].Value = model.MaxLon;
cmdParms[3].Value = model.MinLat;
cmdParms[4].Value = model.MaxLat;
return(DbHelperSQL.ExecuteSql(strSql.ToString(), cmdParms));
}
