/// <summary> /// 根据无人机ID修改数据库中的一条记录 /// </summary> /// <param name="model"></param>无人机平台实体类的实例 /// <returns></returns>返回值为修改的记录数 public int Update(Model.AEROSHIP_RANGE model) { StringBuilder strSql = new StringBuilder(); strSql.Append("Update AEROSHIP_RANGE set "); strSql.Append("PLATFORM_Name=@in_PLATFORM_Name,"); strSql.Append("NumberOfSensor=@in_NumberOfSensor,"); strSql.Append("CruisingVelocity=@in_CruisingVelocity,"); strSql.Append("PitchVelocity=@in_PitchVelocity,"); strSql.Append("MaxVelocity=@in_MaxVelocity,"); strSql.Append("MinVelocity=@in_MinVelocity,"); strSql.Append("Acceleration=@in_Acceleration,"); strSql.Append("CruisingTime=@in_CruisingTime,"); strSql.Append("CruisingAltitude=@in_CruisingAltitude,"); strSql.Append("MaxAltitude=@in_MaxAltitude,"); strSql.Append("MaxDistance=@in_MaxDistance,"); strSql.Append("PayLoad=@in_PayLoad,"); strSql.Append("MaxLoad=@in_MaxLoad"); strSql.Append(" where PLATFORM_ID=@in_PLATFORM_ID"); 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_CruisingVelocity", SqlDbType.Decimal), new SqlParameter("@in_PitchVelocity", SqlDbType.Decimal), new SqlParameter("@in_MaxVelocity", SqlDbType.Decimal), new SqlParameter("@in_MinVelocity", SqlDbType.Decimal), new SqlParameter("@in_Acceleration", SqlDbType.Decimal), new SqlParameter("@in_CruisingTime", SqlDbType.Decimal), new SqlParameter("@in_CruisingAltitude", SqlDbType.Decimal), new SqlParameter("@in_MaxAltitude", SqlDbType.Decimal), new SqlParameter("@in_MaxDistance", SqlDbType.Decimal), new SqlParameter("@in_PayLoad", SqlDbType.Decimal), new SqlParameter("@in_MaxLoad", SqlDbType.Decimal) }; cmdParms[0].Value = model.PLATFORM_ID; cmdParms[1].Value = model.PLATFORM_Name; cmdParms[2].Value = model.NumberOfSensor; cmdParms[3].Value = model.CruisingVelocity; cmdParms[4].Value = model.PitchVelocity; cmdParms[5].Value = model.MaxVelocity; cmdParms[6].Value = model.MinVelocity; cmdParms[7].Value = model.Acceleration; cmdParms[8].Value = model.CruisingTime; cmdParms[9].Value = model.CruisingAltitude; cmdParms[10].Value = model.MaxAltitude; cmdParms[11].Value = model.MaxDistance; cmdParms[12].Value = model.PayLoad; cmdParms[13].Value = model.MaxLoad; return(DbHelperSQL.ExecuteSql(strSql.ToString(), cmdParms)); }
/// <summary> /// 无人机添加函数,添加删除和管理的数据库连接还存在问题 /// </summary> /// <param name="model"></param> /// <returns></returns> public int Add(Model.AEROSHIP_RANGE model) { StringBuilder strSql = new StringBuilder(); strSql.Append("INSERT INTO AEROSHIP_RANGE("); strSql.Append("PLATFORM_ID,PLATFORM_Name,NumberOfSensor,CruisingVelocity,PitchVelocity,MaxVelocity,MinVelocity,Acceleration,CruisingTime,"); strSql.Append("CruisingAltitude,MaxAltitude,MaxDistance,PayLoad,"); strSql.Append("MaxLoad)"); strSql.Append(" Values("); strSql.Append("@in_PLATFORM_ID,@in_PLATFORM_Name,@in_NumberOfSensor,@in_CruisingVelocity,@in_PitchVelocity,@in_MaxVelocity,"); strSql.Append("@in_MinVelocity,@in_Acceleration,@in_CruisingTime,"); strSql.Append("@in_CruisingAltitude,@in_MaxAltitude,@in_MaxDistance,"); strSql.Append("@in_PayLoad,@in_MaxLoad)"); 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_CruisingVelocity", SqlDbType.Decimal), new SqlParameter("@in_PitchVelocity", SqlDbType.Decimal), new SqlParameter("@in_MaxVelocity", SqlDbType.Decimal), new SqlParameter("@in_MinVelocity", SqlDbType.Decimal), new SqlParameter("@in_Acceleration", SqlDbType.Decimal), new SqlParameter("@in_CruisingTime", SqlDbType.Decimal), new SqlParameter("@in_CruisingAltitude", SqlDbType.Decimal), new SqlParameter("@in_MaxAltitude", SqlDbType.Decimal), new SqlParameter("@in_MaxDistance", SqlDbType.Decimal), new SqlParameter("@in_PayLoad", SqlDbType.Decimal), new SqlParameter("@in_MaxLoad", SqlDbType.Decimal) }; cmdParms[0].Value = model.PLATFORM_ID; cmdParms[1].Value = model.PLATFORM_Name; cmdParms[2].Value = model.NumberOfSensor; cmdParms[3].Value = model.CruisingVelocity; cmdParms[4].Value = model.PitchVelocity; cmdParms[5].Value = model.MaxVelocity; cmdParms[6].Value = model.MinVelocity; cmdParms[7].Value = model.Acceleration; cmdParms[8].Value = model.CruisingTime; cmdParms[9].Value = model.CruisingAltitude; cmdParms[10].Value = model.MaxAltitude; cmdParms[11].Value = model.MaxDistance; cmdParms[12].Value = model.PayLoad; cmdParms[13].Value = model.MaxLoad; return(DbHelperSQL.ExecuteSql(strSql.ToString(), cmdParms)); }
//该类中需要实现 通过PLATFORM_ID来查找所需的飞艇速度和续航时间 public Model.AEROSHIP_RANGE GetModel(decimal platformid) { StringBuilder strSql = new StringBuilder(); strSql.Append("Select * From AEROSHIP_RANGE "); strSql.Append(" Where PLATFORM_ID=" + platformid); Model.AEROSHIP_RANGE model = null; using (DbDataReader dr = DbHelperSQL.ExecuteReader(strSql.ToString())) { while (dr.Read()) { model = GetModel(dr);//本类中的重载函数 } return(model); } }