/// <summary>
/// 根任务ID获取任务状态
/// </summary>
public Model.PlanResult GetTasksStateByTID(int TID)
{
StringBuilder strSql = new StringBuilder("SELECT * FROM PlanResult WHERE TID=" + TID);
Model.PlanResult model = null;
using (SqlDataReader dr = DbHelperSQL.ExecuteReader(strSql.ToString()))
{
while (dr.Read())
{
model = GetModel(dr);
}
return(model);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.PlanResult GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT * FROM PlanResult ");
strSql.Append(" WHERE ID=" + ID);
Model.PlanResult model = null;
using (SqlDataReader dr = DbHelperSQL.ExecuteReader(strSql.ToString()))
{
while (dr.Read())
{
model = GetModel(dr);
}
return(model);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.PlanResult GetTopModel(int PID, int UID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT TOP 1 * FROM PlanResult ");
strSql.Append(" WHERE PID=" + PID + " AND UAVID=" + UID + " AND isSend<>1 ORDER BY ID asc");
Model.PlanResult model = null;
using (SqlDataReader dr = DbHelperSQL.ExecuteReader(strSql.ToString()))
{
while (dr.Read())
{
model = GetModel(dr);
}
return(model);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(Model.PlanResult model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("UPDATE PlanResult SET ");
strSql.Append("UAVID=@in_UAVID,");
strSql.Append("UAVName=@in_UAVName,");
strSql.Append("TotalCost=@in_TotalCost,");
strSql.Append("TID=@in_TID,");
strSql.Append("TName=@in_TName,");
strSql.Append("TLAT=@in_TLAT,");
strSql.Append("TLON=@in_TLON,");
strSql.Append("TCost=@in_TCost,");
strSql.Append("FCost=@in_FCost,");
strSql.Append("PID=@in_PID,");
strSql.Append("GID=@in_GID ");
strSql.Append(" WHERE ID=@in_ID");
SqlParameter[] cmdParms = new SqlParameter[] {
new SqlParameter("@in_UAVID", SqlDbType.Int),
new SqlParameter("@in_UAVName", SqlDbType.NVarChar),
new SqlParameter("@in_TotalCost", SqlDbType.NVarChar),
new SqlParameter("@in_TID", SqlDbType.Int),
new SqlParameter("@in_TName", SqlDbType.NVarChar),
new SqlParameter("@in_TLAT", SqlDbType.Decimal),
new SqlParameter("@in_TLON", SqlDbType.Decimal),
new SqlParameter("@in_TCost", SqlDbType.NVarChar),
new SqlParameter("@in_FCost", SqlDbType.NVarChar),
new SqlParameter("@in_PID", SqlDbType.Int),
new SqlParameter("@in_GID", SqlDbType.Int),
new SqlParameter("@in_ID", SqlDbType.Int)
};
cmdParms[0].Value = model.UAVID;
cmdParms[1].Value = model.UAVName;
cmdParms[2].Value = model.TotalCost;
cmdParms[3].Value = model.TID;
cmdParms[4].Value = model.TName;
cmdParms[5].Value = model.TLAT;
cmdParms[6].Value = model.TLON;
cmdParms[7].Value = model.TCost;
cmdParms[8].Value = model.FCost;
cmdParms[9].Value = model.PID;
cmdParms[10].Value = model.GID;
cmdParms[11].Value = model.ID;
return(DbHelperSQL.ExecuteSql(strSql.ToString(), cmdParms));
}
/// <summary>
/// 由一行数据得到一个实体
/// </summary>
private Model.PlanResult GetModel(DbDataReader dr)
{
Model.PlanResult model = new Model.PlanResult();
model.ID = DbHelperSQL.GetInt(dr["ID"]);
model.UAVID = DbHelperSQL.GetInt(dr["UAVID"]);
model.UAVName = DbHelperSQL.GetString(dr["UAVName"]);
model.TotalCost = DbHelperSQL.GetString(dr["TotalCost"]);
model.TID = DbHelperSQL.GetInt(dr["TID"]);
model.TName = DbHelperSQL.GetString(dr["TName"]);
model.TLAT = DbHelperSQL.GetDouble(dr["TLAT"]);
model.TLON = DbHelperSQL.GetDouble(dr["TLON"]);
model.TCost = DbHelperSQL.GetString(dr["TCost"]);
model.FCost = DbHelperSQL.GetString(dr["FCost"]);
model.PID = DbHelperSQL.GetInt(dr["PID"]);
model.GID = DbHelperSQL.GetInt(dr["GID"]);
model.State = DbHelperSQL.GetInt(dr["State"]);
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Model.PlanResult model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("INSERT INTO PlanResult(");
strSql.Append("UAVID,UAVName,TotalCost,TID,TName,TLAT,TLON,TCost,FCost,PID,GID)");
strSql.Append(" VALUES (");
strSql.Append("@in_UAVID,@in_UAVName,@in_TotalCost,@in_TID,@in_TName,@in_TLAT,@in_TLON,@in_TCost,@in_FCost,@in_PID,@in_GID)");
SqlParameter[] cmdParms = new SqlParameter[] {
new SqlParameter("@in_UAVID", SqlDbType.Int),
new SqlParameter("@in_UAVName", SqlDbType.NVarChar),
new SqlParameter("@in_TotalCost", SqlDbType.NVarChar),
new SqlParameter("@in_TID", SqlDbType.Int),
new SqlParameter("@in_TName", SqlDbType.NVarChar),
new SqlParameter("@in_TLAT", SqlDbType.Decimal),
new SqlParameter("@in_TLON", SqlDbType.Decimal),
new SqlParameter("@in_TCost", SqlDbType.NVarChar),
new SqlParameter("@in_FCost", SqlDbType.NVarChar),
new SqlParameter("@in_PID", SqlDbType.Int),
new SqlParameter("@in_GID", SqlDbType.Int)
};
cmdParms[0].Value = model.UAVID;
cmdParms[1].Value = model.UAVName;
cmdParms[2].Value = model.TotalCost;
cmdParms[3].Value = model.TID;
cmdParms[4].Value = model.TName;
cmdParms[5].Value = model.TLAT;
cmdParms[6].Value = model.TLON;
cmdParms[7].Value = model.TCost;
cmdParms[8].Value = model.FCost;
cmdParms[9].Value = model.PID;
cmdParms[10].Value = model.GID;
return(DbHelperSQL.ExecuteSql(strSql.ToString(), cmdParms));
}
