//该类中需要实现 通过PLATFORM_ID来查找所需的飞艇速度和续航时间 public Model.ILLUSTRATEDCAR_RANGE GetModel(decimal platformid) { StringBuilder strSql = new StringBuilder(); strSql.Append("Select * From ILLUSTRATEDCAR_RANGE "); strSql.Append(" Where PLATFORM_ID=" + platformid); Model.ILLUSTRATEDCAR_RANGE model = null; using (DbDataReader dr = DbHelperSQL.ExecuteReader(strSql.ToString())) { while (dr.Read()) { model = GetModel(dr);//本类中的重载函数 } return(model); } }
/// <summary> /// 地面测量车添加函数 /// </summary> /// <param name="model"></param> /// <returns></returns> public int Add(Model.ILLUSTRATEDCAR_RANGE model) { StringBuilder strSql = new StringBuilder(); strSql.Append("INSERT INTO ILLUSTRATEDCAR_RANGE("); strSql.Append("PLATFORM_ID,PLATFORM_Name,NumberOfSensor,MaxVelocity,Acceleration,"); strSql.Append("MaxDistance,ApproachAngle,DepartureAngle,MinimumGroundClearance,WheelBase,"); strSql.Append("AzimuthAngle,AzimuthAngleVelocity,AzimuthAngleAcceleration,PitchAngle,PitchAngleVelocity,"); strSql.Append("PitchAngleAcceleration,PolarizationAngle,PolarizationAngleVelocity,PolarizationAngleAcceleration)"); strSql.Append(" Values( "); strSql.Append("@in_PLATFORM_ID,@in_PLATFORM_Name,@in_NumberOfSensor,@in_MaxVelocity,@in_Acceleration,"); strSql.Append("@in_MaxDistance,@in_ApproachAngle,@in_DepartureAngle,@in_MinimumGroundClearance,@in_WheelBase,"); strSql.Append("@in_AzimuthAngle,@in_AzimuthAngleVelocity,@in_AzimuthAngleAcceleration,@in_PitchAngle,@in_PitchAngleVelocity,"); strSql.Append("@in_PitchAngleAcceleration,@in_PolarizationAngle,@in_PolarizationAngleVelocity,@in_PolarizationAngleAcceleration)"); SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@in_PLATFORM_ID", SqlDbType.Decimal), new SqlParameter("@in_PLATFORM_Name", SqlDbType.NVarChar), new SqlParameter("@in_NumberOfSensor", SqlDbType.Decimal), new SqlParameter("@in_MaxVelocity", SqlDbType.Decimal), new SqlParameter("@in_Acceleration", SqlDbType.Decimal), new SqlParameter("@in_MaxDistance", SqlDbType.Decimal), new SqlParameter("@in_ApproachAngle", SqlDbType.Decimal), new SqlParameter("@in_DepartureAngle", SqlDbType.Decimal), new SqlParameter("@in_MinimumGroundClearance", SqlDbType.Decimal), new SqlParameter("@in_WheelBase", SqlDbType.Decimal), new SqlParameter("@in_AzimuthAngle", SqlDbType.Decimal), new SqlParameter("@in_AzimuthAngleVelocity", SqlDbType.Decimal), new SqlParameter("@in_AzimuthAngleAcceleration", SqlDbType.Decimal), new SqlParameter("@in_PitchAngle", SqlDbType.Decimal), new SqlParameter("@in_PitchAngleVelocity", SqlDbType.Decimal), new SqlParameter("@in_PitchAngleAcceleration", SqlDbType.Decimal), new SqlParameter("@in_PolarizationAngle", SqlDbType.Decimal), new SqlParameter("@in_PolarizationAngleVelocity", SqlDbType.Decimal), new SqlParameter("@in_PolarizationAngleAcceleration", SqlDbType.Decimal) }; cmdParms[0].Value = model.PLATFORM_ID; cmdParms[1].Value = model.PLATFORM_Name; cmdParms[2].Value = model.NumberOfSensor; cmdParms[3].Value = model.MaxVelocity; cmdParms[4].Value = model.Acceleration; cmdParms[5].Value = model.MaxDistance; cmdParms[6].Value = model.ApproachAngle; cmdParms[7].Value = model.DepartureAngle; cmdParms[8].Value = model.MinimumGroundClearance; cmdParms[9].Value = model.WheelBase; cmdParms[10].Value = model.AzimuthAngle; cmdParms[11].Value = model.AzimuthAngleVelocity; cmdParms[12].Value = model.AzimuthAngleAcceleration; cmdParms[13].Value = model.PitchAngle; cmdParms[14].Value = model.PitchAngleVelocity; cmdParms[15].Value = model.PitchAngleAcceleration; cmdParms[16].Value = model.PolarizationAngle; cmdParms[17].Value = model.PolarizationAngleVelocity; cmdParms[18].Value = model.PolarizationAngleAcceleration; return(DbHelperSQL.ExecuteSql(strSql.ToString(), cmdParms)); }