/// <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)); }