/// <summary>
/// 根据传感器ID修改数据库中的一条记录
/// </summary>
/// <param name="model"></param>第一类传感器实体类的实例
/// <returns></returns>返回值为修改的记录数
public int Update(Model.SENSOR_2 model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("Update SENSOR_2 set ");
strSql.Append("SensorName=@in_SensorName,");
strSql.Append("PLATFORM_ID=@in_PLATFORM_ID,");
strSql.Append("SensorType=@in_SensorType,");
strSql.Append("Application=@in_Application,");
strSql.Append("Pixel=@in_Pixel,");
strSql.Append("Resolution=@in_Resolution,");
strSql.Append("HorizontalResolution=@in_HorizontalResolution,");
strSql.Append("MinIllumination=@in_MinIllumination,");
strSql.Append("LookAngle=@in_LookAngle,");
strSql.Append("SquintAngle=@in_SquintAngle,");
strSql.Append("MaxDistance=@in_MaxDistance,");
strSql.Append("Aperture=@in_Aperture,");
strSql.Append("FocalLength=@in_FocalLength,");
strSql.Append("MAXGSD=@in_MAXGSD");
strSql.Append(" where SensorID=@in_SensorID");
SqlParameter[] cmdParms = new SqlParameter[] {
new SqlParameter("@in_SensorID", SqlDbType.Decimal),
new SqlParameter("@in_SensorName", SqlDbType.NVarChar),
new SqlParameter("@in_PLATFORM_ID", SqlDbType.Decimal),
new SqlParameter("@in_SensorType", SqlDbType.NVarChar),
new SqlParameter("@in_Application", SqlDbType.NVarChar),
new SqlParameter("@in_Pixel", SqlDbType.Decimal),
new SqlParameter("@in_Resolution", SqlDbType.Decimal),
new SqlParameter("@in_HorizontalResolution", SqlDbType.Decimal),
new SqlParameter("@in_MinIllumination", SqlDbType.Decimal),
new SqlParameter("@in_LookAngle", SqlDbType.Decimal),
new SqlParameter("@in_SquintAngle", SqlDbType.Decimal),
new SqlParameter("@in_MaxDistance", SqlDbType.Decimal),
new SqlParameter("@in_Aperture", SqlDbType.Decimal),
new SqlParameter("@in_FocalLength", SqlDbType.Decimal),
new SqlParameter("@in_MAXGSD", SqlDbType.Decimal)
};
cmdParms[0].Value = model.SensorID;
cmdParms[1].Value = model.SensorName;
cmdParms[2].Value = model.PLATFORM_ID;
cmdParms[3].Value = model.SensorType;
cmdParms[4].Value = model.Application;
cmdParms[5].Value = model.Pixel;
cmdParms[6].Value = model.Resolution;
cmdParms[7].Value = model.HorizontalResolution;
cmdParms[8].Value = model.MinIllumination;
cmdParms[9].Value = model.LookAngle;
cmdParms[10].Value = model.SquintAngle;
cmdParms[11].Value = model.MaxDistance;
cmdParms[12].Value = model.Aperture;
cmdParms[13].Value = model.FocalLength;
cmdParms[14].Value = model.MAXGSD;
return(DbHelperSQL.ExecuteSql(strSql.ToString(), cmdParms));
}
/// <summary>
/// 第二类传感器添加函数
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Add(Model.SENSOR_2 model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("INSERT INTO SENSOR_2(");
strSql.Append("SensorID,SensorName,PLATFORM_ID,SensorType,Application,");
strSql.Append("Pixel,Resolution,HorizontalResolution,MinIllumination,");
strSql.Append("LookAngle,SquintAngle,MaxDistance,Aperture,FocalLength,MAXGSD)");
strSql.Append(" Values(");
strSql.Append("@in_SensorID,@in_SensorName,@in_PLATFORM_ID,@in_SensorType,");
strSql.Append("@in_Application,@in_Pixel,@in_Resolution,@in_HorizontalResolution,@in_MinIllumination,@in_LookAngle,");
strSql.Append("@in_SquintAngle,@in_MaxDistance,@in_Aperture,@in_FocalLength,@in_MAXGSD)");
SqlParameter[] cmdParms = new SqlParameter[] {
new SqlParameter("@in_SensorID", SqlDbType.Decimal),
new SqlParameter("@in_SensorName", SqlDbType.NVarChar),
new SqlParameter("@in_PLATFORM_ID", SqlDbType.Decimal),
new SqlParameter("@in_SensorType", SqlDbType.NVarChar),
new SqlParameter("@in_Application", SqlDbType.NVarChar),
new SqlParameter("@in_Pixel", SqlDbType.Decimal),
new SqlParameter("@in_Resolution", SqlDbType.Decimal),
new SqlParameter("@in_HorizontalResolution", SqlDbType.Decimal),
new SqlParameter("@in_MinIllumination", SqlDbType.Decimal),
new SqlParameter("@in_LookAngle", SqlDbType.Decimal),
new SqlParameter("@in_SquintAngle", SqlDbType.Decimal),
new SqlParameter("@in_MaxDistance", SqlDbType.Decimal),
new SqlParameter("@in_Aperture", SqlDbType.Decimal),
new SqlParameter("@in_FocalLength", SqlDbType.Decimal),
new SqlParameter("@in_MAXGSD", SqlDbType.Decimal)
};
cmdParms[0].Value = model.SensorID;
cmdParms[1].Value = model.SensorName;
cmdParms[2].Value = model.PLATFORM_ID;
cmdParms[3].Value = model.SensorType;
cmdParms[4].Value = model.Application;
cmdParms[5].Value = model.Pixel;
cmdParms[6].Value = model.Resolution;
cmdParms[7].Value = model.HorizontalResolution;
cmdParms[8].Value = model.MinIllumination;
cmdParms[9].Value = model.LookAngle;
cmdParms[10].Value = model.SquintAngle;
cmdParms[11].Value = model.MaxDistance;
cmdParms[12].Value = model.Aperture;
cmdParms[13].Value = model.FocalLength;
cmdParms[14].Value = model.MAXGSD;
return(DbHelperSQL.ExecuteSql(strSql.ToString(), cmdParms));//执行SQL语句，还需修改数据库连接的问题
}
/// <summary>
/// 得到一个对象实体
/// </summary>
/// <param name="SensorID"></param>
/// <returns></returns>
public Model.SENSOR_2 GetModel(decimal SensorID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("Select * from SENSOR_2 ");
strSql.Append(" Where SensorID=" + SensorID);
Model.SENSOR_2 model = null;
using (DbDataReader dr = DbHelperSQL.ExecuteReader(strSql.ToString()))
{
while (dr.Read())
{
model = GetModel(dr);//本类中的重载函数
}
return(model);
}
}