/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Model.IMG_LAYOUT_POSITION model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("INSERT INTO IMG_LAYOUT_POSITION(");
strSql.Append("LSTR_SEQID,SCHEMEID,TASKID,SAT_ID,SAT_STKNAME,TIME,LON,LAT,ALTITUDE,IMAGENATION)");
strSql.Append(" VALUES (");
strSql.Append("@in_LSTR_SEQID,@in_SCHEMEID,@in_TASKID,@in_SAT_ID,@in_SAT_STKNAME,@in_TIME,@in_LON,@in_LAT,@in_ALTITUDE,@in_IMAGENATION)");
SqlParameter[] cmdParms = new SqlParameter[] {
new SqlParameter("@in_LSTR_SEQID", SqlDbType.Decimal),
new SqlParameter("@in_SCHEMEID", SqlDbType.Decimal),
new SqlParameter("@in_TASKID", SqlDbType.Decimal),
new SqlParameter("@in_SAT_ID", SqlDbType.Decimal),
new SqlParameter("@in_SAT_STKNAME", SqlDbType.NVarChar),
new SqlParameter("@in_TIME", SqlDbType.DateTime),
new SqlParameter("@in_LON", SqlDbType.Decimal),
new SqlParameter("@in_LAT", SqlDbType.Decimal),
new SqlParameter("@in_ALTITUDE", SqlDbType.Decimal),
new SqlParameter("@in_IMAGENATION", SqlDbType.NVarChar)
};
cmdParms[0].Value = model.LSTR_SEQID;
cmdParms[1].Value = model.SCHEMEID;
cmdParms[2].Value = model.TASKID;
cmdParms[3].Value = model.SAT_ID;
cmdParms[4].Value = model.SAT_STKNAME;
cmdParms[5].Value = model.TIME;
cmdParms[6].Value = model.LON;
cmdParms[7].Value = model.LAT;
cmdParms[8].Value = model.ALTITUDE;
cmdParms[9].Value = model.IMAGENATION;
return(DbHelperSQL.ExecuteSql(strSql.ToString(), cmdParms));
}
/// <summary>
/// 由一行数据得到一个实体
/// </summary>
private Model.IMG_LAYOUT_POSITION GetModel(DbDataReader dr)
{
Model.IMG_LAYOUT_POSITION model = new Model.IMG_LAYOUT_POSITION();
model.POSITIONID = Convert.ToDecimal(dr["POSITIONID"]);
model.LSTR_SEQID = Convert.ToDecimal(dr["LSTR_SEQID"]);
model.SCHEMEID = Convert.ToDecimal(dr["SCHEMEID"]);
model.TASKID = Convert.ToDecimal(dr["TASKID"]);
model.SAT_ID = Convert.ToDecimal(dr["SAT_ID"]);
model.SAT_STKNAME = Convert.ToString(dr["SAT_STKNAME"]);
model.TIME = Convert.ToDateTime(dr["TIME"]);
model.LON = Convert.ToDecimal(dr["LON"]);
model.LAT = Convert.ToDecimal(dr["LAT"]);
model.ALTITUDE = Convert.ToDecimal(dr["ALTITUDE"]);
model.IMAGENATION = Convert.ToString(dr["IMAGENATION"]);
return(model);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.IMG_LAYOUT_POSITION GetModel(decimal POSITIONID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT * FROM IMG_LAYOUT_POSITION ");
strSql.Append(" WHERE POSITIONID=" + POSITIONID);
//SqlParameter[] cmdParms = new SqlParameter[] {
// new SqlParameter("@in_POSITIONID", SqlDbType.Decimal)};
//cmdParms[0].Value = POSITIONID;
Model.IMG_LAYOUT_POSITION model = null;
using (DbDataReader dr = DbHelperSQL.ExecuteReader(strSql.ToString()))
{
while (dr.Read())
{
model = GetModel(dr);
}
return(model);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(Model.IMG_LAYOUT_POSITION model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("UPDATE IMG_LAYOUT_POSITION SET ");
strSql.Append("LSTR_SEQID=@in_LSTR_SEQID,");
strSql.Append("SCHEMEID=@in_SCHEMEID,");
strSql.Append("TASKID=@in_TASKID,");
strSql.Append("SAT_ID=@in_SAT_ID,");
strSql.Append("SAT_STKNAME=@in_SAT_STKNAME,");
strSql.Append("TIME=@in_TIME,");
strSql.Append("LON=@in_LON,");
strSql.Append("LAT=@in_LAT,");
strSql.Append("ALTITUDE=@in_ALTITUDE,");
strSql.Append("IMAGENATION=@in_IMAGENATION");
strSql.Append(" WHERE POSITIONID=@in_POSITIONID");
SqlParameter[] cmdParms = new SqlParameter[] {
new SqlParameter("@in_LSTR_SEQID", SqlDbType.Decimal),
new SqlParameter("@in_SCHEMEID", SqlDbType.Decimal),
new SqlParameter("@in_TASKID", SqlDbType.Decimal),
new SqlParameter("@in_SAT_ID", SqlDbType.Decimal),
new SqlParameter("@in_SAT_STKNAME", SqlDbType.NVarChar),
new SqlParameter("@in_TIME", SqlDbType.DateTime),
new SqlParameter("@in_LON", SqlDbType.Decimal),
new SqlParameter("@in_LAT", SqlDbType.Decimal),
new SqlParameter("@in_ALTITUDE", SqlDbType.Decimal),
new SqlParameter("@in_ALTITUDE", SqlDbType.Decimal),
new SqlParameter("@in_IMAGENATION", SqlDbType.NVarChar)
};
cmdParms[0].Value = model.LSTR_SEQID;
cmdParms[1].Value = model.SCHEMEID;
cmdParms[2].Value = model.TASKID;
cmdParms[3].Value = model.SAT_ID;
cmdParms[4].Value = model.SAT_STKNAME;
cmdParms[5].Value = model.TIME;
cmdParms[6].Value = model.LON;
cmdParms[7].Value = model.LAT;
cmdParms[8].Value = model.ALTITUDE;
cmdParms[8].Value = model.POSITIONID;
cmdParms[9].Value = model.IMAGENATION;
return(DbHelperSQL.ExecuteSql(strSql.ToString(), cmdParms));
}
