/// <summary>
/// 任务需求记录添加函数
/// </summary>
/// <param name="model"></param>参数为任务需求实体类的一个实例
/// <returns></returns>返回值为影响的数据库中的行数
public int AddRecord(Model.TaskRequirement model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("INSERT INTO TaskRequirements_general(");
strSql.Append("TaskID,TaskName,SubmissionTime,TaskPriority,DisasterType,TaskStage,StartTime,EndTime,RespondingTime,SensorNeeded,ObservationFrequency,Weather,Windlevel,MinTemperature,MaxTemperature,RoadAccessability,SpaceResolution,Datavolume,OccurTime,PolygonString)");
strSql.Append(" VALUES (");
strSql.Append("@in_TaskID,@in_TaskName,@in_SubmissionTime,@in_TaskPriority,@in_DisasterType,@in_TaskStage,@in_StartTime,@in_EndTime,@in_RespondingTime,@in_SensorNeeded,@in_ObservationFrequency,@in_Weather,@in_Windlevel,@in_MinTemperature,@in_MaxTemperature,@in_RoadAccessability,@in_SpaceResolution,@in_Datavolume,@in_OccurTime,@in_PolygonString)");
SqlParameter[] cmdParms = new SqlParameter[] {
new SqlParameter("@in_TaskID", SqlDbType.Decimal),
new SqlParameter("@in_TaskName", SqlDbType.NVarChar),
new SqlParameter("@in_SubmissionTime", SqlDbType.DateTime),
new SqlParameter("@in_TaskPriority", SqlDbType.Decimal),
new SqlParameter("@in_DisasterType", SqlDbType.NVarChar),
new SqlParameter("@in_TaskStage", SqlDbType.NVarChar),
new SqlParameter("@in_StartTime", SqlDbType.DateTime),
new SqlParameter("@in_EndTime", SqlDbType.DateTime),
new SqlParameter("@in_RespondingTime", SqlDbType.Decimal),
new SqlParameter("@in_SensorNeeded", SqlDbType.NVarChar),
new SqlParameter("@in_ObservationFrequency", SqlDbType.Decimal),
new SqlParameter("@in_Weather", SqlDbType.NVarChar),
new SqlParameter("@in_Windlevel", SqlDbType.Decimal),
new SqlParameter("@in_MinTemperature", SqlDbType.Decimal),
new SqlParameter("@in_MaxTemperature", SqlDbType.Decimal),
new SqlParameter("@in_RoadAccessability", SqlDbType.Bit),
new SqlParameter("@in_SpaceResolution", SqlDbType.Decimal),
new SqlParameter("@in_Datavolume", SqlDbType.Decimal),
new SqlParameter("@in_OccurTime", SqlDbType.DateTime),
new SqlParameter("@in_PolygonString", SqlDbType.NVarChar)
};
cmdParms[0].Value = model.TaskID;
cmdParms[1].Value = model.TaskName;
cmdParms[2].Value = model.SubmissionTime;
cmdParms[3].Value = model.TaskPriority;
cmdParms[4].Value = model.DisasterType;
cmdParms[5].Value = model.TaskStage;
cmdParms[6].Value = model.StartTime;
cmdParms[7].Value = model.EndTime;
cmdParms[8].Value = model.RespondingTime;
cmdParms[9].Value = model.SensorNeeded;
cmdParms[10].Value = model.ObservationFrequency;
cmdParms[11].Value = model.Weather;
cmdParms[12].Value = model.Windlevel;
cmdParms[13].Value = model.MinTemperature;
cmdParms[14].Value = model.MaxTemperature;
cmdParms[15].Value = model.RoadAccessability;
cmdParms[16].Value = model.SpaceResolution;
cmdParms[17].Value = model.Datavolume;
cmdParms[18].Value = model.OccurTime;
cmdParms[19].Value = model.PolygonString;
return(DbHelperSQL.ExecuteSql(strSql.ToString(), cmdParms));//使用更改过的执行语句
}
/// <summary>
/// 得到一个对象实体 静态公用 规划用到
/// </summary>
public static Model.TaskRequirement GetModelforPlan(decimal TaskID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT * FROM TaskRequirements_general ");
strSql.Append(" WHERE TaskID=" + TaskID);
Model.TaskRequirement model = null;
using (DbDataReader dr = DbHelperSQL.ExecuteReader(strSql.ToString()))
{
while (dr.Read())
{
model = GetModel(dr);//本类中的
}
return(model);
}
}
/// <summary>
/// 根据ID修改数据库中的一条记录,增加的属性还未修改
/// </summary>
/// <param name="model"></param>任务需求实体类的实例
/// <returns></returns>返回值为修改的记录数
public int Update(Model.TaskRequirement model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("UPDATE TaskRequirements_general SET ");
strSql.Append("TaskName=@in_TaskName,");
strSql.Append("SubmissionTime=@in_SubmissionTime,");
strSql.Append("TaskPriority=@in_TaskPriority,");
strSql.Append("DisasterType=@in_DisasterType,");
strSql.Append("TaskStage=@in_TaskStage,");
strSql.Append("StartTime=@in_StartTime,");
strSql.Append("EndTime=@in_EndTime,");
strSql.Append("RespondingTime=@in_RespondingTime,");
strSql.Append("SensorNeeded=@in_SensorNeeded,");
strSql.Append("ObservationFrequency=@in_ObservationFrequency,");
strSql.Append("Weather=@in_Weather,");
strSql.Append("Windlevel=@in_Windlevel,");
strSql.Append("MinTemperature=@in_MinTemperature,");
strSql.Append("MaxTemperature=@in_MaxTemperature,");
strSql.Append("RoadAccessability=@in_RoadAccessability,");
strSql.Append("SpaceResolution=@in_SpaceResolution,");
strSql.Append("Datavolume=@in_Datavolume,");
strSql.Append("OccurTime=@in_OccurTime,");
strSql.Append("PolygonString=@in_PolygonString");
strSql.Append(" WHERE TaskID=@in_TaskID");
SqlParameter[] cmdParms = new SqlParameter[] {
new SqlParameter("@in_TaskID", SqlDbType.Decimal),
new SqlParameter("@in_TaskName", SqlDbType.NVarChar),
new SqlParameter("@in_SubmissionTime", SqlDbType.DateTime),
new SqlParameter("@in_TaskPriority", SqlDbType.Decimal),
new SqlParameter("@in_DisasterType", SqlDbType.NVarChar),
new SqlParameter("@in_TaskStage", SqlDbType.NVarChar),
new SqlParameter("@in_StartTime", SqlDbType.DateTime),
new SqlParameter("@in_EndTime", SqlDbType.DateTime),
new SqlParameter("@in_RespondingTime", SqlDbType.Decimal),
new SqlParameter("@in_SensorNeeded", SqlDbType.NVarChar),
new SqlParameter("@in_ObservationFrequency", SqlDbType.Decimal),
new SqlParameter("@in_Weather", SqlDbType.NVarChar),
new SqlParameter("@in_Windlevel", SqlDbType.Decimal),
new SqlParameter("@in_MinTemperature", SqlDbType.Decimal),
new SqlParameter("@in_MaxTemperature", SqlDbType.Decimal),
new SqlParameter("@in_RoadAccessability", SqlDbType.Bit),
new SqlParameter("@in_SpaceResolution", SqlDbType.Decimal),
new SqlParameter("@in_Datavolume", SqlDbType.Decimal),
new SqlParameter("@in_OccurTime", SqlDbType.DateTime),
new SqlParameter("@in_PolygonString", SqlDbType.NVarChar)
};
cmdParms[0].Value = model.TaskID;
cmdParms[1].Value = model.TaskName;
cmdParms[2].Value = model.SubmissionTime;
cmdParms[3].Value = model.TaskPriority;
cmdParms[4].Value = model.DisasterType;
cmdParms[5].Value = model.TaskStage;
cmdParms[6].Value = model.StartTime;
cmdParms[7].Value = model.EndTime;
cmdParms[8].Value = model.RespondingTime;
cmdParms[9].Value = model.SensorNeeded;
cmdParms[10].Value = model.ObservationFrequency;
cmdParms[11].Value = model.Weather;
cmdParms[12].Value = model.Windlevel;
cmdParms[13].Value = model.MinTemperature;
cmdParms[14].Value = model.MaxTemperature;
cmdParms[15].Value = model.RoadAccessability;
cmdParms[16].Value = model.SpaceResolution;
cmdParms[18].Value = model.OccurTime;
cmdParms[19].Value = model.PolygonString;
return(DbHelperSQL.ExecuteSql(strSql.ToString(), cmdParms));
}
