/// <summary>
/// 更新一条数据
/// </summary>
public int Update(Model.CompanyUAV model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("UPDATE CompanyUAV SET ");
strSql.Append("Length=@in_Length,");
strSql.Append("Wingspan=@in_Wingspan,");
strSql.Append("Weight=@in_Weight,");
strSql.Append("DriveMode=@in_DriveMode,");
strSql.Append("TakeoffMode=@in_TakeoffMode,");
strSql.Append("LandingMode=@in_LandingMode,");
strSql.Append("FlightAltitude=@in_FlightAltitude,");
strSql.Append("Radius=@in_Radius,");
strSql.Append("AverageSpeed=@in_AverageSpeed,");
strSql.Append("Endurance=@in_Endurance,");
strSql.Append("WindResistance=@in_WindResistance,");
strSql.Append("StallSpeed=@in_StallSpeed,");
strSql.Append("ControlDistance=@in_ControlDistance,");
strSql.Append("Camera=@in_Camera,");
strSql.Append("CID=@in_CID");
strSql.Append(" WHERE ID=@in_ID");
SqlParameter[] cmdParms = new SqlParameter[] {
new SqlParameter("@in_Length", SqlDbType.Decimal),
new SqlParameter("@in_Wingspan", SqlDbType.Decimal),
new SqlParameter("@in_Weight", SqlDbType.Decimal),
new SqlParameter("@in_DriveMode", SqlDbType.NVarChar),
new SqlParameter("@in_TakeoffMode", SqlDbType.NVarChar),
new SqlParameter("@in_LandingMode", SqlDbType.NVarChar),
new SqlParameter("@in_FlightAltitude", SqlDbType.Decimal),
new SqlParameter("@in_Radius", SqlDbType.Decimal),
new SqlParameter("@in_AverageSpeed", SqlDbType.Decimal),
new SqlParameter("@in_Endurance", SqlDbType.Decimal),
new SqlParameter("@in_WindResistance", SqlDbType.Decimal),
new SqlParameter("@in_StallSpeed", SqlDbType.Decimal),
new SqlParameter("@in_ControlDistance", SqlDbType.Decimal),
new SqlParameter("@in_Camera", SqlDbType.NVarChar),
new SqlParameter("@in_CID", SqlDbType.Int),
new SqlParameter("@in_ID", SqlDbType.Int)
};
cmdParms[0].Value = model.Length;
cmdParms[1].Value = model.Wingspan;
cmdParms[2].Value = model.Weight;
cmdParms[3].Value = model.DriveMode;
cmdParms[4].Value = model.TakeoffMode;
cmdParms[5].Value = model.LandingMode;
cmdParms[6].Value = model.FlightAltitude;
cmdParms[7].Value = model.Radius;
cmdParms[8].Value = model.AverageSpeed;
cmdParms[9].Value = model.Endurance;
cmdParms[10].Value = model.WindResistance;
cmdParms[11].Value = model.StallSpeed;
cmdParms[12].Value = model.ControlDistance;
cmdParms[13].Value = model.Camera;
cmdParms[14].Value = model.CID;
cmdParms[15].Value = model.ID;
return(DbHelperSQL.ExecuteSql(strSql.ToString(), cmdParms));
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.CompanyUAV GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT * FROM CompanyUAV ");
strSql.Append(" WHERE ID=@in_ID");
Model.CompanyUAV model = null;
using (SqlDataReader dr = DbHelperSQL.ExecuteReader(strSql.ToString()))
{
while (dr.Read())
{
model = GetModel(dr);
}
return(model);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Model.CompanyUAV model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("INSERT INTO CompanyUAV(");
strSql.Append("Length,Wingspan,Weight,DriveMode,TakeoffMode,LandingMode,FlightAltitude,Radius,AverageSpeed,Endurance,WindResistance,StallSpeed,ControlDistance,Camera,CID)");
strSql.Append(" VALUES (");
strSql.Append("@in_Length,@in_Wingspan,@in_Weight,@in_DriveMode,@in_TakeoffMode,@in_LandingMode,@in_FlightAltitude,@in_Radius,@in_AverageSpeed,@in_Endurance,@in_WindResistance,@in_StallSpeed,@in_ControlDistance,@in_Camera,@in_CID)");
SqlParameter[] cmdParms = new SqlParameter[] {
new SqlParameter("@in_Length", SqlDbType.Decimal),
new SqlParameter("@in_Wingspan", SqlDbType.Decimal),
new SqlParameter("@in_Weight", SqlDbType.Decimal),
new SqlParameter("@in_DriveMode", SqlDbType.NVarChar),
new SqlParameter("@in_TakeoffMode", SqlDbType.NVarChar),
new SqlParameter("@in_LandingMode", SqlDbType.NVarChar),
new SqlParameter("@in_FlightAltitude", SqlDbType.Decimal),
new SqlParameter("@in_Radius", SqlDbType.Decimal),
new SqlParameter("@in_AverageSpeed", SqlDbType.Decimal),
new SqlParameter("@in_Endurance", SqlDbType.Decimal),
new SqlParameter("@in_WindResistance", SqlDbType.Decimal),
new SqlParameter("@in_StallSpeed", SqlDbType.Decimal),
new SqlParameter("@in_ControlDistance", SqlDbType.Decimal),
new SqlParameter("@in_Camera", SqlDbType.NVarChar),
new SqlParameter("@in_CID", SqlDbType.Int)
};
cmdParms[0].Value = model.Length;
cmdParms[1].Value = model.Wingspan;
cmdParms[2].Value = model.Weight;
cmdParms[3].Value = model.DriveMode;
cmdParms[4].Value = model.TakeoffMode;
cmdParms[5].Value = model.LandingMode;
cmdParms[6].Value = model.FlightAltitude;
cmdParms[7].Value = model.Radius;
cmdParms[8].Value = model.AverageSpeed;
cmdParms[9].Value = model.Endurance;
cmdParms[10].Value = model.WindResistance;
cmdParms[11].Value = model.StallSpeed;
cmdParms[12].Value = model.ControlDistance;
cmdParms[13].Value = model.Camera;
cmdParms[14].Value = model.CID;
return(DbHelperSQL.ExecuteSql(strSql.ToString(), cmdParms));
}
/// <summary>
/// 由一行数据得到一个实体
/// </summary>
private Model.CompanyUAV GetModel(DbDataReader dr)
{
Model.CompanyUAV model = new Model.CompanyUAV();
model.ID = DbHelperSQL.GetInt(dr["ID"]);
model.Length = DbHelperSQL.GetDouble(dr["Length"]);
model.Wingspan = DbHelperSQL.GetDouble(dr["Wingspan"]);
model.Weight = DbHelperSQL.GetDouble(dr["Weight"]);
model.DriveMode = DbHelperSQL.GetString(dr["DriveMode"]);
model.TakeoffMode = DbHelperSQL.GetString(dr["TakeoffMode"]);
model.LandingMode = DbHelperSQL.GetString(dr["LandingMode"]);
model.FlightAltitude = DbHelperSQL.GetDouble(dr["FlightAltitude"]);
model.Radius = DbHelperSQL.GetDouble(dr["Radius"]);
model.AverageSpeed = DbHelperSQL.GetDouble(dr["AverageSpeed"]);
model.Endurance = DbHelperSQL.GetDouble(dr["Endurance"]);
model.WindResistance = DbHelperSQL.GetDouble(dr["WindResistance"]);
model.StallSpeed = DbHelperSQL.GetDouble(dr["StallSpeed"]);
model.ControlDistance = DbHelperSQL.GetDouble(dr["ControlDistance"]);
model.Camera = DbHelperSQL.GetString(dr["Camera"]);
model.CID = DbHelperSQL.GetInt(dr["CID"]);
return(model);
}
