/// <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; }