Пример #1
0
        //该类中需要实现 通过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);
            }
        }
Пример #2
0
        /// <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));
        }