Example #1
0
        public MainteEditViewModel(MainteListViewModel _vm, MainteEditView _mw)
        {
            _MainteListVM = _vm;
            _Window = _mw;
            OperationType = OpType.Add;
            MainteObj = new MainteOR();

            Init();
        }
Example #2
0
        public MainteEditViewModel(MainteListViewModel _vm, MainteEditView _mw, MainteOR _MainteObj)
        {
            _MainteListVM = _vm;
            _Window = _mw;
            _SourceObj = _MainteObj;

            OperationType = OpType.Alert;
            MainteObj = new MainteOR();
            MainteObj.Clone(_MainteObj);

            Init();
        }
Example #3
0
 /// <summary>
 /// 插入t_Mainte
 /// </summary>
 public virtual bool Insert(MainteOR mainte)
 {
     string sql = @"insert into t_Mainte (DeviceID, StationID, ValueType, MainteTime, MainteName, Duty, ContentMainte)
     values (@DeviceID, @StationID, @ValueType, @MainteTime, @MainteName, @Duty, @ContentMainte)";
     SqlParameter[] parameters = new SqlParameter[]
     {
         //new SqlParameter("@ID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "ID", DataRowVersion.Default, mainte.Id),
         new SqlParameter("@DeviceID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "DeviceID", DataRowVersion.Default, mainte.Deviceid),
         new SqlParameter("@StationID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "StationID", DataRowVersion.Default, mainte.Stationid),
         new SqlParameter("@ValueType", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "ValueType", DataRowVersion.Default, mainte.Valuetype),
         new SqlParameter("@MainteTime", SqlDbType.DateTime, 8, ParameterDirection.Input, false, 0, 0, "MainteTime", DataRowVersion.Default, mainte.Maintetime),
         new SqlParameter("@MainteName", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "MainteName", DataRowVersion.Default, mainte.Maintename),
         new SqlParameter("@Duty", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "Duty", DataRowVersion.Default, mainte.Duty),
         new SqlParameter("@ContentMainte", SqlDbType.VarChar, 200, ParameterDirection.Input, false, 0, 0, "ContentMainte", DataRowVersion.Default, mainte.Contentmainte)
     };
     return db.ExecuteNoQuery(sql, parameters) > -1;
 }
Example #4
0
        public ObservableCollection<MainteOR> selectAllDate()
        {
            string sql = @"select m.*,t.StationName,d.DeviceName from t_Mainte m
            inner join t_station t on  t.stationid= m.stationid
            inner join t_Device d on m.DeviceID=d.DeviceID order by id";

            DataTable dt = null;
            try
            {
                dt = db.ExecuteQuery(sql);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            ObservableCollection<MainteOR> _List = new ObservableCollection<MainteOR>();
            foreach (DataRow dr in dt.Rows)
            {
                MainteOR obj = new MainteOR(dr);
                _List.Add(obj);
            }
            return _List;
        }
Example #5
0
        public void Clone(MainteOR obj)
        {
            //
            Id = obj.Id;
            //设备
            Deviceid = obj.Deviceid;
            //站点
            Stationid = obj.Stationid;
            //维修状态
            Valuetype = obj.Valuetype;
            //维修时间
            Maintetime = obj.Maintetime;
            //维修人员
            Maintename = obj.Maintename;
            //值班人员
            Duty = obj.Duty;
            //检修内容
            Contentmainte = obj.Contentmainte;

            StationName = obj.StationName;
            DeviceName = obj.DeviceName;
        }
Example #6
0
 public MainteEditView(MainteListViewModel _List, MainteOR _Mainte)
 {
     InitializeComponent();
     this.DataContext = new MainteEditViewModel(_List, this, _Mainte);
 }
Example #7
0
 /// <summary>
 /// 更新t_Mainte
 /// </summary>
 public virtual bool Update(MainteOR mainte)
 {
     string sql = "update t_Mainte set  DeviceID = @DeviceID,  StationID = @StationID,  ValueType = @ValueType,  MainteTime = @MainteTime,  MainteName = @MainteName,  Duty = @Duty,  ContentMainte = @ContentMainte where  ID = @ID";
     SqlParameter[] parameters = new SqlParameter[]
     {
         new SqlParameter("@ID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "ID", DataRowVersion.Default, mainte.Id),
         new SqlParameter("@DeviceID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "DeviceID", DataRowVersion.Default, mainte.Deviceid),
         new SqlParameter("@StationID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "StationID", DataRowVersion.Default, mainte.Stationid),
         new SqlParameter("@ValueType", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "ValueType", DataRowVersion.Default, mainte.Valuetype),
         new SqlParameter("@MainteTime", SqlDbType.DateTime, 8, ParameterDirection.Input, false, 0, 0, "MainteTime", DataRowVersion.Default, mainte.Maintetime),
         new SqlParameter("@MainteName", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "MainteName", DataRowVersion.Default, mainte.Maintename),
         new SqlParameter("@Duty", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "Duty", DataRowVersion.Default, mainte.Duty),
         new SqlParameter("@ContentMainte", SqlDbType.VarChar, 200, ParameterDirection.Input, false, 0, 0, "ContentMainte", DataRowVersion.Default, mainte.Contentmainte)
     };
     return db.ExecuteNoQuery(sql, parameters) > -1;
 }
Example #8
0
 public MainteOR selectARowDate(string m_id)
 {
     string sql = string.Format("select * from t_Mainte 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];
     MainteOR m_Main = new MainteOR(dr);
     return m_Main;
 }
Example #9
0
 public MainteEditViewModel(MainteOR _Sta)
 {
     OperationType = OpType.Alert;
     MainteObj = _Sta;
 }