/// <summary>
/// 由一行数据得到一个实体
/// </summary>
private Model.UAV GetModel(DbDataReader dr)
{
Model.UAV model = new Model.UAV();
model.PLATFORM_ID = DbHelperSQL.GetInt(dr["ID"]);
model.Model = DbHelperSQL.GetString(dr["Model"]);
model.Size = DbHelperSQL.GetDouble(dr["Size"]);
model.Loads = DbHelperSQL.GetString(dr["Loads"]);
model.WindResistance = DbHelperSQL.GetString(dr["WindResistance"]);
model.RainResistance = DbHelperSQL.GetString(dr["RainResistance"]);
model.Radius = Convert.ToDecimal(DbHelperSQL.GetDouble(dr["Radius"]));
model.Endurance = DbHelperSQL.GetDouble(dr["Endurance"]);
model.CruisingVelocity = Convert.ToDecimal(DbHelperSQL.GetDouble(dr["Speed"]));
model.Height = DbHelperSQL.GetDouble(dr["Height"]);
model.Voyage = Convert.ToDecimal(DbHelperSQL.GetDouble(dr["Voyage"]));
model.TakeoffMode = DbHelperSQL.GetString(dr["TakeoffMode"]);
model.RecycleMode = DbHelperSQL.GetString(dr["RecycleMode"]);
model.UnfoldTime = DbHelperSQL.GetDouble(dr["UnfoldTime"]);
model.FoldTime = DbHelperSQL.GetDouble(dr["FoldTime"]);
model.isUnload = DbHelperSQL.GetString(dr["isUnload"]);
model.RefulTime = DbHelperSQL.GetDouble(dr["RefulTime"]);
model.Camera = DbHelperSQL.GetString(dr["Camera"]);
model.isUse = DbHelperSQL.GetBool(dr["isUse"]);
model.Company = DbHelperSQL.GetString(dr["Company"]);
model.Type = DbHelperSQL.GetString(dr["Type"]);
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Model.UAV model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("INSERT INTO UAV(");
strSql.Append("Model,Size,Loads,WindResistance,RainResistance,Radius,Endurance,Speed,Height,Voyage,TakeoffMode,RecycleMode,UnfoldTime,FoldTime,isUnload,RefulTime,Camera,isUse,Company,Type)");
strSql.Append(" VALUES (");
strSql.Append("@in_Model,@in_Size,@in_Loads,@in_WindResistance,@in_RainResistance,@in_Radius,@in_Endurance,@in_Speed,@in_Height,@in_Voyage,@in_TakeoffMode,@in_RecycleMode,@in_UnfoldTime,@in_FoldTime,@in_isUnload,@in_RefulTime,@in_Camera,@in_isUse,@in_Company,@in_Type)");
SqlParameter[] cmdParms = new SqlParameter[] {
new SqlParameter("@in_Model", SqlDbType.NVarChar),
new SqlParameter("@in_Size", SqlDbType.Decimal),
new SqlParameter("@in_Loads", SqlDbType.NVarChar),
new SqlParameter("@in_WindResistance", SqlDbType.NVarChar),
new SqlParameter("@in_RainResistance", SqlDbType.NVarChar),
new SqlParameter("@in_Radius", SqlDbType.Decimal),
new SqlParameter("@in_Endurance", SqlDbType.Decimal),
new SqlParameter("@in_Speed", SqlDbType.Decimal),
new SqlParameter("@in_Height", SqlDbType.Decimal),
new SqlParameter("@in_Voyage", SqlDbType.Decimal),
new SqlParameter("@in_TakeoffMode", SqlDbType.NVarChar),
new SqlParameter("@in_RecycleMode", SqlDbType.NVarChar),
new SqlParameter("@in_UnfoldTime", SqlDbType.Decimal),
new SqlParameter("@in_FoldTime", SqlDbType.Decimal),
new SqlParameter("@in_isUnload", SqlDbType.NVarChar),
new SqlParameter("@in_RefulTime", SqlDbType.Decimal),
new SqlParameter("@in_Camera", SqlDbType.NVarChar),
new SqlParameter("@in_isUse", SqlDbType.Bit),
new SqlParameter("@in_Company", SqlDbType.NVarChar),
new SqlParameter("@in_Type", SqlDbType.NVarChar)
};
cmdParms[0].Value = model.Model;
cmdParms[1].Value = model.Size;
cmdParms[2].Value = model.Loads;
cmdParms[3].Value = model.WindResistance;
cmdParms[4].Value = model.RainResistance;
cmdParms[5].Value = model.Radius;
cmdParms[6].Value = model.Endurance;
cmdParms[7].Value = model.CruisingVelocity;
cmdParms[8].Value = model.Height;
cmdParms[9].Value = model.Voyage;
cmdParms[10].Value = model.TakeoffMode;
cmdParms[11].Value = model.RecycleMode;
cmdParms[12].Value = model.UnfoldTime;
cmdParms[13].Value = model.FoldTime;
cmdParms[14].Value = model.isUnload;
cmdParms[15].Value = model.RefulTime;
cmdParms[16].Value = model.Camera;
cmdParms[17].Value = model.isUse;
cmdParms[18].Value = model.Company;
cmdParms[19].Value = model.Type;
return(DbHelperSQL.ExecuteSql(strSql.ToString(), cmdParms));
}
/// <summary>
/// 获取单位数据列表
/// </summary>
public List <Model.UAV> GetCompany()
{
StringBuilder strSql = new StringBuilder("SELECT DISTINCT [Company] FROM UAV");
using (SqlDataReader dr = DbHelperSQL.ExecuteReader(strSql.ToString()))
{
List <Model.UAV> lst = new List <Model.UAV>();
while (dr.Read())
{
Model.UAV model = new Model.UAV();
model.Company = DbHelperSQL.GetString(dr["Company"]);
lst.Add(model);
}
return(lst);
}
}
/// <summary>
/// 根据条件得到一个对象实体
/// </summary>
public Model.UAV GetModel(string whereclause)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT * FROM UAV ");
strSql.Append(" WHERE " + whereclause);;
Model.UAV model = null;
using (SqlDataReader dr = DbHelperSQL.ExecuteReader(strSql.ToString()))
{
while (dr.Read())
{
model = GetModel(dr);
}
return(model);
}
}
/// <summary>
/// 获取无人机类型数据表
/// </summary>
public List <Model.UAV> GetUAVType(string whereclause)
{
StringBuilder strSql = new StringBuilder("SELECT DISTINCT * FROM UAV");
strSql.Append(" WHERE " + whereclause);
using (SqlDataReader dr = DbHelperSQL.ExecuteReader(strSql.ToString()))
{
List <Model.UAV> lst = new List <Model.UAV>();
while (dr.Read())
{
Model.UAV model = new Model.UAV();
model.PLATFORM_ID = Convert.ToInt32(DbHelperSQL.GetString(dr["ID"]));
model.Company = DbHelperSQL.GetString(dr["Company"]);
model.Type = DbHelperSQL.GetString(dr["Type"]);
lst.Add(model);
}
return(lst);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(Model.UAV model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("UPDATE UAV SET ");
strSql.Append("Model=@in_Model,");
strSql.Append("Size=@in_Size,");
strSql.Append("Loads=@in_Loads,");
strSql.Append("WindResistance=@in_WindResistance,");
strSql.Append("RainResistance=@in_RainResistance,");
strSql.Append("Radius=@in_Radius,");
strSql.Append("Endurance=@in_Endurance,");
strSql.Append("Speed=@in_Speed,");
strSql.Append("Height=@in_Height,");
strSql.Append("Voyage=@in_Voyage,");
strSql.Append("TakeoffMode=@in_TakeoffMode,");
strSql.Append("RecycleMode=@in_RecycleMode,");
strSql.Append("UnfoldTime=@in_UnfoldTime,");
strSql.Append("FoldTime=@in_FoldTime,");
strSql.Append("isUnload=@in_isUnload,");
strSql.Append("RefulTime=@in_RefulTime,");
strSql.Append("Camera=@in_Camera,");
strSql.Append("isUse=@in_isUse,");
strSql.Append("Company=@in_Company,");
strSql.Append("Type=@in_Type");
strSql.Append(" WHERE ID=@in_ID");
SqlParameter[] cmdParms = new SqlParameter[] {
new SqlParameter("@in_Model", SqlDbType.NVarChar),
new SqlParameter("@in_Size", SqlDbType.Decimal),
new SqlParameter("@in_Loads", SqlDbType.NVarChar),
new SqlParameter("@in_WindResistance", SqlDbType.NVarChar),
new SqlParameter("@in_RainResistance", SqlDbType.NVarChar),
new SqlParameter("@in_Radius", SqlDbType.Decimal),
new SqlParameter("@in_Endurance", SqlDbType.Decimal),
new SqlParameter("@in_Speed", SqlDbType.Decimal),
new SqlParameter("@in_Height", SqlDbType.Decimal),
new SqlParameter("@in_Voyage", SqlDbType.Decimal),
new SqlParameter("@in_TakeoffMode", SqlDbType.NVarChar),
new SqlParameter("@in_RecycleMode", SqlDbType.NVarChar),
new SqlParameter("@in_UnfoldTime", SqlDbType.Decimal),
new SqlParameter("@in_FoldTime", SqlDbType.Decimal),
new SqlParameter("@in_isUnload", SqlDbType.NVarChar),
new SqlParameter("@in_RefulTime", SqlDbType.Decimal),
new SqlParameter("@in_Camera", SqlDbType.NVarChar),
new SqlParameter("@in_isUse", SqlDbType.Bit),
new SqlParameter("@in_Company", SqlDbType.NVarChar),
new SqlParameter("@in_Type", SqlDbType.NVarChar),
new SqlParameter("@in_ID", SqlDbType.Int)
};
cmdParms[0].Value = model.Model;
cmdParms[1].Value = model.Size;
cmdParms[2].Value = model.Loads;
cmdParms[3].Value = model.WindResistance;
cmdParms[4].Value = model.RainResistance;
cmdParms[5].Value = model.Radius;
cmdParms[6].Value = model.Endurance;
cmdParms[7].Value = model.CruisingVelocity;
cmdParms[8].Value = model.Height;
cmdParms[9].Value = model.Voyage;
cmdParms[10].Value = model.TakeoffMode;
cmdParms[11].Value = model.RecycleMode;
cmdParms[12].Value = model.UnfoldTime;
cmdParms[13].Value = model.FoldTime;
cmdParms[14].Value = model.isUnload;
cmdParms[15].Value = model.RefulTime;
cmdParms[16].Value = model.Camera;
cmdParms[17].Value = model.isUse;
cmdParms[18].Value = model.Company;
cmdParms[19].Value = model.Type;
cmdParms[20].Value = model.PLATFORM_ID;
return(DbHelperSQL.ExecuteSql(strSql.ToString(), cmdParms));
}