/// <summary> /// 插入t_MonitorSystemParam /// </summary> public virtual bool Insert(t_MonitorSystemParam monitorSystemParam) { string sql = "insert into t_MonitorSystemParam (MonitorRefreshTime, StartScreenID, AlarmLogTime, ServerIP, ServerPort, Door_Sysid, Door_Com, HaveDoor) values (@MonitorRefreshTime, @StartScreenID, @AlarmLogTime, @ServerIP, @ServerPort, @Door_Sysid, @Door_Com, @HaveDoor)"; SqlParameter [] parameters = new SqlParameter[] { new SqlParameter("@MonitorRefreshTime", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "MonitorRefreshTime", DataRowVersion.Default, monitorSystemParam.MonitorRefreshTime), new SqlParameter("@StartScreenID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "StartScreenID", DataRowVersion.Default, monitorSystemParam.StartScreenID), new SqlParameter("@AlarmLogTime", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "AlarmLogTime", DataRowVersion.Default, monitorSystemParam.AlarmLogTime), new SqlParameter("@ServerIP", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "ServerIP", DataRowVersion.Default, monitorSystemParam.ServerIP), new SqlParameter("@ServerPort", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "ServerPort", DataRowVersion.Default, monitorSystemParam.ServerPort), new SqlParameter("@Door_Sysid", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "Door_Sysid", DataRowVersion.Default, monitorSystemParam.Door_Sysid), new SqlParameter("@Door_Com", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "Door_Com", DataRowVersion.Default, monitorSystemParam.Door_Com), new SqlParameter("@HaveDoor", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "HaveDoor", DataRowVersion.Default, monitorSystemParam.HaveDoor) }; return db.ExecuteNoQuery(sql, parameters) > -1; }
public List<t_MonitorSystemParam> selectAllDate() { string sql = "select * from t_MonitorSystemParam"; DataTable dt = null; try { dt = db.ExecuteQuery(sql); } catch (Exception ex) { throw ex; } List<t_MonitorSystemParam> _List = new List<t_MonitorSystemParam>(); foreach (DataRow dr in dt.Rows) { t_MonitorSystemParam obj = new t_MonitorSystemParam(dr); _List.Add(obj); } return _List; }
public t_MonitorSystemParam selectARowDate(string m_id) { string sql = string.Format("select * from t_MonitorSystemParam where Monitorrefreshtime='{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]; t_MonitorSystemParam m_Moni=new t_MonitorSystemParam(dr); return m_Moni; }
/// <summary> /// 更新t_MonitorSystemParam /// </summary> public virtual bool Update(t_MonitorSystemParam monitorSystemParam) { string sql = "update t_MonitorSystemParam set StartScreenID = @StartScreenID, AlarmLogTime = @AlarmLogTime, ServerIP = @ServerIP, ServerPort = @ServerPort, Door_Sysid = @Door_Sysid, Door_Com = @Door_Com, HaveDoor = @HaveDoor where MonitorRefreshTime = @MonitorRefreshTime"; SqlParameter [] parameters = new SqlParameter[] { new SqlParameter("@MonitorRefreshTime", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "MonitorRefreshTime", DataRowVersion.Default, monitorSystemParam.MonitorRefreshTime), new SqlParameter("@StartScreenID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "StartScreenID", DataRowVersion.Default, monitorSystemParam.StartScreenID), new SqlParameter("@AlarmLogTime", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "AlarmLogTime", DataRowVersion.Default, monitorSystemParam.AlarmLogTime), new SqlParameter("@ServerIP", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "ServerIP", DataRowVersion.Default, monitorSystemParam.ServerIP), new SqlParameter("@ServerPort", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "ServerPort", DataRowVersion.Default, monitorSystemParam.ServerPort), new SqlParameter("@Door_Sysid", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "Door_Sysid", DataRowVersion.Default, monitorSystemParam.Door_Sysid), new SqlParameter("@Door_Com", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "Door_Com", DataRowVersion.Default, monitorSystemParam.Door_Com), new SqlParameter("@HaveDoor", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "HaveDoor", DataRowVersion.Default, monitorSystemParam.HaveDoor) }; return db.ExecuteNoQuery(sql, parameters) > -1; }
public void Clone(t_MonitorSystemParam obj) { // MonitorRefreshTime = obj.MonitorRefreshTime; // StartScreenID = obj.StartScreenID; //报警框刷新时间 AlarmLogTime = obj.AlarmLogTime; // ServerIP = obj.ServerIP; // ServerPort = obj.ServerPort; // Door_Sysid = obj.Door_Sysid; // Door_Com = obj.Door_Com; // HaveDoor = obj.HaveDoor; }
/// <summary> /// 加载参数完成! /// </summary> /// <param name="result"></param> private void LoadParmCompleted() { try { var result = new MonitorSystemParamDA().selectAllDate(); if (result.Count == 0) { ErrorMsg += "未设置系统参数!\n"; } else { SystemParam = result.First(); } LoadCommpleteNumber++; InitComplete(); } catch (Exception ex) { LoadCommpleteNumber++; ErrorMsg += "无法加载系统参数数据!\n"; InitComplete(); return; } }