/// <summary>
/// 插入t_Station
/// </summary>
public virtual bool Insert(StationOR station)
{
string sql = "insert into t_Station ( StationName, IP, Port, HistoryPort) values ( @StationName, @IP, @Port, @HistoryPort)";
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@StationName", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "StationName", DataRowVersion.Default, station.Stationname),
new SqlParameter("@IP", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "IP", DataRowVersion.Default, station.Ip),
new SqlParameter("@Port", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "Port", DataRowVersion.Default, station.Port),
new SqlParameter("@HistoryPort", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "HistoryPort", DataRowVersion.Default, station.Historyport)
};
return db.ExecuteNoQuery(sql, parameters) > -1;
}
public StationOR selectARowDate(string m_id)
{
string sql = string.Format("select * from t_Station where Stationid='{0}'", m_id);
DataTable dt = null;
try
{
dt = db.ExecuteQueryDataSet(sql).Tables[0];
}
catch (Exception ex)
{
throw ex;
}
if (dt == null)
return null;
if (dt.Rows.Count == 0)
return null;
DataRow dr = dt.Rows[0];
StationOR m_Stat = new StationOR(dr);
return m_Stat;
}
/// <summary>
/// 更新t_Station
/// </summary>
public virtual bool Update(StationOR station)
{
string sql = "update t_Station set StationName = @StationName, IP = @IP, Port = @Port, HistoryPort = @HistoryPort where StationID = @StationID";
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@StationID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "StationID", DataRowVersion.Default, station.Stationid),
new SqlParameter("@StationName", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "StationName", DataRowVersion.Default, station.Stationname),
new SqlParameter("@IP", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "IP", DataRowVersion.Default, station.Ip),
new SqlParameter("@Port", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "Port", DataRowVersion.Default, station.Port),
new SqlParameter("@HistoryPort", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "HistoryPort", DataRowVersion.Default, station.Historyport)
};
return db.ExecuteNoQuery(sql, parameters) > -1;
}
