/// <summary>
/// 更新一条数据
/// </summary>
public int UpdateAll(Model.UAVBD model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("UPDATE UAVBD SET ");
strSql.Append("CID=@in_CID,");
strSql.Append("Speed=@in_Speed,");
strSql.Append("Focus=@in_Focus,");
strSql.Append("Chip_L=@in_Chip_L,");
strSql.Append("Chip_W=@in_Chip_W,");
strSql.Append("Pixel_L=@in_Pixel_L,");
strSql.Append("Pixel_W=@in_Pixel_W,");
strSql.Append("Sidelap=@in_Sidelap,");
strSql.Append("Routelap=@in_Routelap,");
strSql.Append("X=@in_X,");
strSql.Append("Y=@in_Y,");
strSql.Append("Name=@in_Name,");
strSql.Append("Province=@in_Province,");
strSql.Append("GID=@in_GID");
strSql.Append(" WHERE ID=@in_ID");
SqlParameter[] cmdParms = new SqlParameter[] {
new SqlParameter("@in_CID", SqlDbType.Int),
new SqlParameter("@in_Speed", SqlDbType.Float),
new SqlParameter("@in_Focus", SqlDbType.Float),
new SqlParameter("@in_Chip_L", SqlDbType.Float),
new SqlParameter("@in_Chip_W", SqlDbType.Float),
new SqlParameter("@in_Pixel_L", SqlDbType.Float),
new SqlParameter("@in_Pixel_W", SqlDbType.Float),
new SqlParameter("@in_Sidelap", SqlDbType.Float),
new SqlParameter("@in_Routelap", SqlDbType.Float),
new SqlParameter("@in_X", SqlDbType.Float),
new SqlParameter("@in_Y", SqlDbType.Float),
new SqlParameter("@in_Name", SqlDbType.NVarChar),
new SqlParameter("@in_Province", SqlDbType.NVarChar),
new SqlParameter("@in_GID", SqlDbType.Int),
new SqlParameter("@in_ID", SqlDbType.Int)
};
cmdParms[0].Value = model.CID;
cmdParms[1].Value = model.Speed;
cmdParms[2].Value = model.Focus;
cmdParms[3].Value = model.Chip_L;
cmdParms[4].Value = model.Chip_W;
cmdParms[5].Value = model.Pixel_L;
cmdParms[6].Value = model.Pixel_W;
cmdParms[7].Value = model.Sidelap;
cmdParms[8].Value = model.Routelap;
cmdParms[9].Value = model.X;
cmdParms[10].Value = model.Y;
cmdParms[11].Value = model.Name;
cmdParms[12].Value = model.Province;
cmdParms[13].Value = model.GID;
cmdParms[14].Value = model.ID;
return(DbHelperSQL.ExecuteSql(strSql.ToString(), cmdParms));
}
/// <summary>
/// 根据条件得到一个对象实体
/// </summary>
public Model.UAVBD GetModel(string whereclause)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT * FROM UAVBD ");
strSql.Append(" WHERE " + whereclause);;
Model.UAVBD model = null;
using (SqlDataReader dr = DbHelperSQL.ExecuteReader(strSql.ToString()))
{
while (dr.Read())
{
model = GetModel(dr);
}
return(model);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(Model.UAVBD model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("UPDATE UAVBD SET ");
strSql.Append("GID=@in_GID");
strSql.Append(" WHERE Name=@in_PName");
SqlParameter[] cmdParms = new SqlParameter[] {
new SqlParameter("@in_GID", SqlDbType.Int),
new SqlParameter("@in_PName", SqlDbType.NVarChar)
};
cmdParms[0].Value = model.GID;
cmdParms[1].Value = model.Name;
return(DbHelperSQL.ExecuteSql(strSql.ToString(), cmdParms));
}
/// <summary>
/// 根据条件获取泛型数据列表
/// </summary>
public List <Model.UAVBD> GetUAVList(string whereclause)
{
StringBuilder strSql = new StringBuilder("SELECT * FROM UAVBD WHERE " + whereclause);
Model.UAVBD model;
List <Model.UAVBD> lst = new List <Model.UAVBD>();
using (SqlDataReader dr = DbHelperSQL.ExecuteReader(strSql.ToString()))
{
while (dr.Read())
{
model = new Model.UAVBD();
model.ID = DbHelperSQL.GetInt(dr["ID"]);
model.GID = DbHelperSQL.GetInt(dr["GID"]);
model.Name = DbHelperSQL.GetString(dr["Name"]);
lst.Add(model);
}
return(lst);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Model.UAVBD model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("INSERT INTO UAVBD(");
strSql.Append("CID,Speed,Focus,Chip_L,Chip_W,Pixel_L,Pixel_W,Sidelap,Routelap,X,Y,Name,Province,GID)");
strSql.Append(" VALUES (");
strSql.Append("@in_CID,@in_Speed,@in_Focus,@in_Chip_L,@in_Chip_W,@in_Pixel_L,@in_Pixel_W,@in_Sidelap,@in_Routelap,@in_X,@in_Y,@in_Name,@in_Province,@in_GID)");
SqlParameter[] cmdParms = new SqlParameter[] {
new SqlParameter("@in_CID", SqlDbType.Int),
new SqlParameter("@in_Speed", SqlDbType.Float),
new SqlParameter("@in_Focus", SqlDbType.Float),
new SqlParameter("@in_Chip_L", SqlDbType.Float),
new SqlParameter("@in_Chip_W", SqlDbType.Float),
new SqlParameter("@in_Pixel_L", SqlDbType.Float),
new SqlParameter("@in_Pixel_W", SqlDbType.Float),
new SqlParameter("@in_Sidelap", SqlDbType.Float),
new SqlParameter("@in_Routelap", SqlDbType.Float),
new SqlParameter("@in_X", SqlDbType.Float),
new SqlParameter("@in_Y", SqlDbType.Float),
new SqlParameter("@in_Name", SqlDbType.NVarChar),
new SqlParameter("@in_Province", SqlDbType.NVarChar),
new SqlParameter("@in_GID", SqlDbType.Int)
};
cmdParms[0].Value = model.CID;
cmdParms[1].Value = model.Speed;
cmdParms[2].Value = model.Focus;
cmdParms[3].Value = model.Chip_L;
cmdParms[4].Value = model.Chip_W;
cmdParms[5].Value = model.Pixel_L;
cmdParms[6].Value = model.Pixel_W;
cmdParms[7].Value = model.Sidelap;
cmdParms[8].Value = model.Routelap;
cmdParms[9].Value = model.X;
cmdParms[10].Value = model.Y;
cmdParms[11].Value = model.Name;
cmdParms[12].Value = model.Province;
cmdParms[13].Value = model.GID;
return(DbHelperSQL.ExecuteSql(strSql.ToString(), cmdParms));
}
/// <summary>
/// 由一行数据得到一个实体
/// </summary>
private Model.UAVBD GetModel(DbDataReader dr)
{
Model.UAVBD model = new Model.UAVBD();
model.ID = DbHelperSQL.GetInt(dr["ID"]);
model.CID = DbHelperSQL.GetInt(dr["CID"]);
model.Name = DbHelperSQL.GetString(dr["Name"]);
model.Speed = DbHelperSQL.GetDouble(dr["Speed"]);
model.Focus = DbHelperSQL.GetDouble(dr["Focus"]);
model.Chip_L = DbHelperSQL.GetDouble(dr["Chip_L"]);
model.Chip_W = DbHelperSQL.GetDouble(dr["Chip_W"]);
model.Pixel_L = DbHelperSQL.GetDouble(dr["Pixel_L"]);
model.Pixel_W = DbHelperSQL.GetDouble(dr["Pixel_W"]);
model.Sidelap = DbHelperSQL.GetDouble(dr["Sidelap"]);
model.Routelap = DbHelperSQL.GetDouble(dr["Routelap"]);
model.X = DbHelperSQL.GetDouble(dr["X"]);
model.Y = DbHelperSQL.GetDouble(dr["Y"]);
model.GID = DbHelperSQL.GetInt(dr["GID"]);
model.TotalTime = DbHelperSQL.GetDouble(dr["TotalTime"]);
model.TaskAreaIndex = DbHelperSQL.GetInt(dr["TaskAreaIndex"]);
model.Province = DbHelperSQL.GetString(dr["Province"]);
return(model);
}
