/// <summary>
/// 更新一条数据
/// </summary>
public int Update(Model.TASK_LAYOUT_LIST model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("UPDATE LHF.TASK_LAYOUT_LIST SET ");
strSql.Append("TASKNAME=@in_TASKNAME,");
strSql.Append("TASKTYPE=@in_TASKTYPE,");
strSql.Append("PRIORITY=@in_PRIORITY,");
strSql.Append("IMAGETYPE=@in_IMAGETYPE,");
strSql.Append("MAXGSD=@in_MAXGSD,");
strSql.Append("STARTTIME=@in_STARTTIME,");
strSql.Append("ENDTIME=@in_ENDTIME,");
strSql.Append("SCHEMEID=@in_SCHEMEID,");
strSql.Append("TARGET_ID=@in_TARGET_ID,");
strSql.Append("ISCONTINUEDSPY=@in_ISCONTINUEDSPY,");
strSql.Append("LON=@in_LON,");
strSql.Append("LAT=@in_LAT,");
strSql.Append("AREASTRING=@in_AREASTRING");
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_TASKTYPE", SqlDbType.Decimal),
new SqlParameter("@in_PRIORITY", SqlDbType.Decimal),
new SqlParameter("@in_IMAGETYPE", SqlDbType.NVarChar),
new SqlParameter("@in_MAXGSD", SqlDbType.Decimal),
new SqlParameter("@in_STARTTIME", SqlDbType.DateTime),
new SqlParameter("@in_ENDTIME", SqlDbType.DateTime),
new SqlParameter("@in_SCHEMEID", SqlDbType.Decimal),
new SqlParameter("@in_TARGET_ID", SqlDbType.Decimal),
new SqlParameter("@in_ISCONTINUEDSPY", SqlDbType.Decimal),
new SqlParameter("@in_LON", SqlDbType.Decimal),
new SqlParameter("@in_LAT", SqlDbType.Decimal),
new SqlParameter("@in_AREASTRING", SqlDbType.NVarChar)
};
cmdParms[0].Value = model.TASKID;
cmdParms[1].Value = model.TASKNAME;
cmdParms[2].Value = model.TASKTYPE;
cmdParms[3].Value = model.PRIORITY;
cmdParms[4].Value = model.IMAGETYPE;
cmdParms[5].Value = model.MAXGSD;
cmdParms[6].Value = model.STARTTIME;
cmdParms[7].Value = model.ENDTIME;
cmdParms[8].Value = model.SCHEMEID;
cmdParms[9].Value = model.TARGET_ID;
cmdParms[10].Value = model.ISCONTINUEDSPY;
cmdParms[11].Value = model.LON;
cmdParms[12].Value = model.LAT;
cmdParms[13].Value = model.AREASTRING;
return(DbHelperSQL.ExecuteSql(strSql.ToString(), cmdParms));
}
/// <summary>
/// 由一行数据得到一个实体
/// </summary>
private Model.TASK_LAYOUT_LIST GetModel(DbDataReader dr)
{
Model.TASK_LAYOUT_LIST model = new Model.TASK_LAYOUT_LIST();
model.TASKID = Convert.ToInt32(dr["TASKID"]);
model.TASKNAME = Convert.ToString(dr["TASKNAME"]);
model.TASKTYPE = Convert.ToInt32(dr["TASKTYPE"]);
model.PRIORITY = Convert.ToInt32(dr["PRIORITY"]);
model.IMAGETYPE = Convert.ToString(dr["IMAGETYPE"]);
model.MAXGSD = Convert.ToDecimal(dr["MAXGSD"]);
model.STARTTIME = Convert.ToDateTime(dr["STARTTIME"]);
model.ENDTIME = Convert.ToDateTime(dr["ENDTIME"]);
model.SCHEMEID = Convert.ToInt32(dr["SCHEMEID"]);
model.TARGET_ID = Convert.ToInt32(dr["TARGET_ID"]);
model.ISCONTINUEDSPY = Convert.ToInt32(dr["ISCONTINUEDSPY"]);
model.LON = Convert.ToDecimal(dr["LON"]);
model.LAT = Convert.ToDecimal(dr["LAT"]);
model.AREASTRING = Convert.ToString(dr["AREASTRING"]);
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Model.TASK_LAYOUT_LIST model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("INSERT INTO LHF.TASK_LAYOUT_LIST(");
strSql.Append("TASKNAME,TASKTYPE,PRIORITY,IMAGETYPE,MAXGSD,STARTTIME,ENDTIME,SCHEMEID,TARGET_ID,ISCONTINUEDSPY,LON,LAT,AREASTRING)");
strSql.Append(" VALUES (");
strSql.Append("@in_TASKNAME,@in_TASKTYPE,@in_PRIORITY,@in_IMAGETYPE,@in_MAXGSD,@in_STARTTIME,@in_ENDTIME,@in_SCHEMEID,@in_TARGET_ID,@in_ISCONTINUEDSPY,@in_LON,@in_LAT,@in_AREASTRING)");
SqlParameter[] cmdParms = new SqlParameter[] {
new SqlParameter("@in_TASKNAME", SqlDbType.NVarChar),
new SqlParameter("@in_TASKTYPE", SqlDbType.Decimal),
new SqlParameter("@in_PRIORITY", SqlDbType.Decimal),
new SqlParameter("@in_IMAGETYPE", SqlDbType.NVarChar),
new SqlParameter("@in_MAXGSD", SqlDbType.Decimal),
new SqlParameter("@in_STARTTIME", SqlDbType.DateTime),
new SqlParameter("@in_ENDTIME", SqlDbType.DateTime),
new SqlParameter("@in_SCHEMEID", SqlDbType.Decimal),
new SqlParameter("@in_TARGET_ID", SqlDbType.Decimal),
new SqlParameter("@in_ISCONTINUEDSPY", SqlDbType.Decimal),
new SqlParameter("@in_LON", SqlDbType.Decimal),
new SqlParameter("@in_LAT", SqlDbType.Decimal),
new SqlParameter("@in_AREASTRING", SqlDbType.NVarChar)
};
cmdParms[0].Value = model.TASKNAME;
cmdParms[1].Value = model.TASKTYPE;
cmdParms[2].Value = model.PRIORITY;
cmdParms[3].Value = model.IMAGETYPE;
cmdParms[4].Value = model.MAXGSD;
cmdParms[5].Value = model.STARTTIME;
cmdParms[6].Value = model.ENDTIME;
cmdParms[7].Value = model.SCHEMEID;
cmdParms[8].Value = model.TARGET_ID;
cmdParms[9].Value = model.ISCONTINUEDSPY;
cmdParms[10].Value = model.LON;
cmdParms[11].Value = model.LAT;
cmdParms[12].Value = model.AREASTRING;
return(DbHelperSQL.ExecuteSql(strSql.ToString(), cmdParms));
}
