/// <summary>
/// 由一行数据得到一个实体
/// </summary>
private CoScheduling.Core.Model.BIGAREA_SENSOR GetModel(DbDataReader dr)
{
CoScheduling.Core.Model.BIGAREA_SENSOR model = new CoScheduling.Core.Model.BIGAREA_SENSOR();
model.SATSENSORID = Convert.ToDecimal(dr["SATSENSORID"]);
model.SENSORID = Convert.ToDecimal(dr["SENSORID"]);
model.SATID = Convert.ToDecimal(dr["SATID"]);
model.SCHEMEID = Convert.ToDecimal(dr["SCHEMEID"]);
return(model);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public CoScheduling.Core.Model.BIGAREA_SENSOR GetModel(decimal SATSENSORID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT * FROM BIGAREA_SENSOR ");
strSql.Append(" WHERE SATSENSORID=" + SATSENSORID);
CoScheduling.Core.Model.BIGAREA_SENSOR model = new CoScheduling.Core.Model.BIGAREA_SENSOR();
using (DbDataReader dr = DbHelperSQL.ExecuteReader(strSql.ToString()))
{
while (dr.Read())
{
model = GetModel(dr);
}
return(model);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(CoScheduling.Core.Model.BIGAREA_SENSOR model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("INSERT INTO BIGAREA_SENSOR(");
strSql.Append("SENSORID,SATID,SCHEMEID)");
strSql.Append(" VALUES (");
strSql.Append("@in_SENSORID,@in_SATID,@in_SCHEMEID)");
SqlParameter[] cmdParms = new SqlParameter[] {
new SqlParameter("@in_SENSORID", SqlDbType.Decimal),
new SqlParameter("@in_SATID", SqlDbType.Decimal),
new SqlParameter("@in_SCHEMEID", SqlDbType.Decimal)
};
cmdParms[0].Value = model.SENSORID;
cmdParms[1].Value = model.SATID;
cmdParms[2].Value = model.SCHEMEID;
return(DbHelperSQL.ExecuteSql(strSql.ToString(), cmdParms));
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(CoScheduling.Core.Model.BIGAREA_SENSOR model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("UPDATE BIGAREA_SENSOR SET ");
strSql.Append("SENSORID=@in_SENSORID,");
strSql.Append("SATID=@in_SATID,");
strSql.Append("SCHEMEID=@in_SCHEMEID");
strSql.Append(" WHERE SATSENSORID=@in_SATSENSORID");
SqlParameter[] cmdParms = new SqlParameter[] {
new SqlParameter("@in_SENSORID", SqlDbType.Decimal),
new SqlParameter("@in_SATID", SqlDbType.Decimal),
new SqlParameter("@in_SCHEMEID", SqlDbType.Decimal),
new SqlParameter("@in_SATSENSORID", SqlDbType.Decimal)
};
cmdParms[0].Value = model.SENSORID;
cmdParms[1].Value = model.SATID;
cmdParms[2].Value = model.SCHEMEID;
cmdParms[3].Value = model.SATSENSORID;
return(DbHelperSQL.ExecuteSql(strSql.ToString(), cmdParms));
}
