/// <summary> /// 更新t_Sys_MainRealTimeSet /// </summary> public virtual bool Update(SysMainRealTimeSetOR sysMainRealTimeSet) { string sql = "update t_Sys_MainRealTimeSet set StationID = @StationID, DeviceID = @DeviceID, ChannelNO = @ChannelNO, YmaxValue = @YmaxValue, YminValue = @YminValue, Yupper = @Yupper, Ylower = @Ylower, GridHeight = @GridHeight"; SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@StationID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "StationID", DataRowVersion.Default, sysMainRealTimeSet.Stationid), new SqlParameter("@DeviceID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "DeviceID", DataRowVersion.Default, sysMainRealTimeSet.Deviceid), new SqlParameter("@ChannelNO", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "ChannelNO", DataRowVersion.Default, sysMainRealTimeSet.Channelno), new SqlParameter("@YmaxValue", SqlDbType.Float, 8, ParameterDirection.Input, false, 0, 0, "YmaxValue", DataRowVersion.Default, sysMainRealTimeSet.Ymaxvalue), new SqlParameter("@YminValue", SqlDbType.Float, 8, ParameterDirection.Input, false, 0, 0, "YminValue", DataRowVersion.Default, sysMainRealTimeSet.Yminvalue), new SqlParameter("@Yupper", SqlDbType.Float, 8, ParameterDirection.Input, false, 0, 0, "Yupper", DataRowVersion.Default, sysMainRealTimeSet.Yupper), new SqlParameter("@Ylower", SqlDbType.Float, 8, ParameterDirection.Input, false, 0, 0, "Ylower", DataRowVersion.Default, sysMainRealTimeSet.Ylower), new SqlParameter("@GridHeight", SqlDbType.Float, 8, ParameterDirection.Input, false, 0, 0, "GridHeight", DataRowVersion.Default, sysMainRealTimeSet.Gridheight) }; return db.ExecuteNoQuery(sql, parameters) > -1; }
public SysMainRealTimeSetOR selectARowDate() { string sql = string.Format("select * from t_Sys_MainRealTimeSet"); 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]; SysMainRealTimeSetOR m_SysM = new SysMainRealTimeSetOR(dr); return m_SysM; }