Esempio n. 1
0
        public ObservableCollection<AlarmGroupMembersOR> selectAllDate()
        {
            string sql = @"select tm.*,s.StationName,ag.GroupName,als.LevelName,ts.FrequencyName from t_AlarmGroupMembers tm
            inner join t_Station s on s.stationid=tm.stationid
            inner join t_AlarmGroups ag on ag.AlarmGroupsID= tm.alarmgroupsid
            inner join t_AlarmLevelSet als on als.id= tm.processlevel
            inner join t_Scheduling ts on ts.Frequency= tm.scheduling ";

            DataTable dt = null;
            try
            {
                dt = db.ExecuteQuery(sql);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            ObservableCollection<AlarmGroupMembersOR> _List = new ObservableCollection<AlarmGroupMembersOR>();
            foreach (DataRow dr in dt.Rows)
            {
                AlarmGroupMembersOR obj = new AlarmGroupMembersOR(dr);
                _List.Add(obj);
            }
            return _List;
        }
        public AlarmGroupMembersEditViewModel(AlarmGroupMembersListViewModel _vm, AlarmGroupMembersEditView _mw)
        {
            _AlarmGroupMembersListVM = _vm;
            _Window = _mw;
            OperationType = OpType.Add;
            AlarmGroupMembersObj = new AlarmGroupMembersOR();

            Init();
        }
        public AlarmGroupMembersEditViewModel(AlarmGroupMembersListViewModel _vm, AlarmGroupMembersEditView _mw, AlarmGroupMembersOR _AlarmGroupMembersObj)
        {
            _AlarmGroupMembersListVM = _vm;
            _Window = _mw;
            _SourceObj = _AlarmGroupMembersObj;

            OperationType = OpType.Alert;
            AlarmGroupMembersObj = new AlarmGroupMembersOR();
            AlarmGroupMembersObj.Clone(_AlarmGroupMembersObj);

            Init();
        }
Esempio n. 4
0
 /// <summary>
 /// 插入t_AlarmGroupMembers
 /// </summary>
 public virtual bool Insert(AlarmGroupMembersOR alarmGroupMembers)
 {
     string sql = @"insert into t_AlarmGroupMembers(StationID, AlarmGroupsID, Name, MobileNo, TelNo,
     Email, Scheduling, ProcessLevel) values (@StationID, @AlarmGroupsID, @Name, @MobileNo, @TelNo, @Email, @Scheduling, @ProcessLevel)";
     SqlParameter [] parameters = new SqlParameter[]
     {
         //new SqlParameter("@ID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "ID", DataRowVersion.Default, alarmGroupMembers.Id),
         new SqlParameter("@StationID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "StationID", DataRowVersion.Default, alarmGroupMembers.Stationid),
         new SqlParameter("@AlarmGroupsID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "AlarmGroupsID", DataRowVersion.Default, alarmGroupMembers.Alarmgroupsid),
         new SqlParameter("@Name", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "Name", DataRowVersion.Default, alarmGroupMembers.Name),
         new SqlParameter("@MobileNo", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "MobileNo", DataRowVersion.Default, alarmGroupMembers.Mobileno),
         new SqlParameter("@TelNo", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "TelNo", DataRowVersion.Default, alarmGroupMembers.Telno),
         new SqlParameter("@Email", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "Email", DataRowVersion.Default, alarmGroupMembers.Email),
         new SqlParameter("@Scheduling", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "Scheduling", DataRowVersion.Default, alarmGroupMembers.Scheduling),
         new SqlParameter("@ProcessLevel", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "ProcessLevel", DataRowVersion.Default, alarmGroupMembers.Processlevel)
     };
     return db.ExecuteNoQuery(sql, parameters) > -1;
 }
 public AlarmGroupMembersEditViewModel(AlarmGroupMembersOR _Sta)
 {
     OperationType = OpType.Alert;
     AlarmGroupMembersObj = _Sta;
 }
Esempio n. 6
0
        public void Clone(AlarmGroupMembersOR obj)
        {
            //
            Id = obj.Id;
            //站点
            Stationid = obj.Stationid;
            //告警组
            Alarmgroupsid = obj.Alarmgroupsid;
            //姓名
            Name = obj.Name;
            //手机
            Mobileno = obj.Mobileno;
            //固定号码
            Telno = obj.Telno;
            //Email
            Email = obj.Email;
            //排次
            Scheduling = obj.Scheduling;
            //处理等级
            Processlevel = obj.Processlevel;

            StationName = obj.StationName;
            GroupName = obj.GroupName;
            LevelName = obj.LevelName;
            FrequencyName = obj.FrequencyName;
        }
Esempio n. 7
0
 /// <summary>
 /// 更新t_AlarmGroupMembers
 /// </summary>
 public virtual bool Update(AlarmGroupMembersOR alarmGroupMembers)
 {
     string sql = "update t_AlarmGroupMembers set  StationID = @StationID,  AlarmGroupsID = @AlarmGroupsID,  Name = @Name,  MobileNo = @MobileNo,  TelNo = @TelNo,  Email = @Email,  Scheduling = @Scheduling,  ProcessLevel = @ProcessLevel where  ID = @ID";
     SqlParameter [] parameters = new SqlParameter[]
     {
         new SqlParameter("@ID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "ID", DataRowVersion.Default, alarmGroupMembers.Id),
         new SqlParameter("@StationID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "StationID", DataRowVersion.Default, alarmGroupMembers.Stationid),
         new SqlParameter("@AlarmGroupsID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "AlarmGroupsID", DataRowVersion.Default, alarmGroupMembers.Alarmgroupsid),
         new SqlParameter("@Name", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "Name", DataRowVersion.Default, alarmGroupMembers.Name),
         new SqlParameter("@MobileNo", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "MobileNo", DataRowVersion.Default, alarmGroupMembers.Mobileno),
         new SqlParameter("@TelNo", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "TelNo", DataRowVersion.Default, alarmGroupMembers.Telno),
         new SqlParameter("@Email", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "Email", DataRowVersion.Default, alarmGroupMembers.Email),
         new SqlParameter("@Scheduling", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "Scheduling", DataRowVersion.Default, alarmGroupMembers.Scheduling),
         new SqlParameter("@ProcessLevel", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "ProcessLevel", DataRowVersion.Default, alarmGroupMembers.Processlevel)
     };
     return db.ExecuteNoQuery(sql, parameters) > -1;
 }
Esempio n. 8
0
 public AlarmGroupMembersOR selectARowDate(string m_id)
 {
     string sql = string.Format("select * from t_AlarmGroupMembers where  Id='{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];
     AlarmGroupMembersOR m_Alar=new AlarmGroupMembersOR(dr);
      return m_Alar;
 }
 public AlarmGroupMembersEditView(AlarmGroupMembersListViewModel _List, AlarmGroupMembersOR _AlarmGroupMembers)
 {
     InitializeComponent();
     this.DataContext = new AlarmGroupMembersEditViewModel(_List, this, _AlarmGroupMembers);
 }