public MainteEditViewModel(MainteListViewModel _vm, MainteEditView _mw) { _MainteListVM = _vm; _Window = _mw; OperationType = OpType.Add; MainteObj = new MainteOR(); Init(); }
public MainteEditViewModel(MainteListViewModel _vm, MainteEditView _mw, MainteOR _MainteObj) { _MainteListVM = _vm; _Window = _mw; _SourceObj = _MainteObj; OperationType = OpType.Alert; MainteObj = new MainteOR(); MainteObj.Clone(_MainteObj); Init(); }
/// <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; }
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; }
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; }
public MainteEditView(MainteListViewModel _List, MainteOR _Mainte) { InitializeComponent(); this.DataContext = new MainteEditViewModel(_List, this, _Mainte); }
/// <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; }
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; }
public MainteEditViewModel(MainteOR _Sta) { OperationType = OpType.Alert; MainteObj = _Sta; }