public DisarmTimeEditViewModel(DisarmTimeListViewModel _vm, DisarmTimeEditView _mw) { _DisarmTimeListVM = _vm; _Window = _mw; OperationType = OpType.Add; DisarmTimeObj = new DisarmTimeOR(); //UpdatetxtSource(_Window.gridContent); }
public DisarmTimeEditViewModel(DisarmTimeListViewModel _vm, DisarmTimeEditView _mw, DisarmTimeOR _DisarmTimeObj) { _DisarmTimeListVM = _vm; _Window = _mw; _SourceObj = _DisarmTimeObj; OperationType = OpType.Alert; DisarmTimeObj = new DisarmTimeOR(); DisarmTimeObj.Clone(_DisarmTimeObj); }
/// <summary> /// 插入t_DisarmTime /// </summary> public virtual bool Insert(DisarmTimeOR disarmTime) { string sql = "insert into t_DisarmTime (DisarmName, DisarmStartTime, DisarmEndTime) values(@DisarmName, @DisarmStartTime, @DisarmEndTime)"; SqlParameter[] parameters = new SqlParameter[] { //new SqlParameter("@DisarmID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "DisarmID", DataRowVersion.Default, disarmTime.Disarmid), new SqlParameter("@DisarmName", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "DisarmName", DataRowVersion.Default, disarmTime.Disarmname), new SqlParameter("@DisarmStartTime", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "DisarmStartTime", DataRowVersion.Default, disarmTime.Disarmstarttime), new SqlParameter("@DisarmEndTime", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "DisarmEndTime", DataRowVersion.Default, disarmTime.Disarmendtime) }; return db.ExecuteNoQuery(sql, parameters) > -1; }
public ObservableCollection<DisarmTimeOR> selectAllDate() { string sql = "select * from t_DisarmTime"; DataTable dt = null; try { dt = db.ExecuteQuery(sql); } catch (Exception ex) { throw ex; } ObservableCollection<DisarmTimeOR> _List = new ObservableCollection<DisarmTimeOR>(); foreach (DataRow dr in dt.Rows) { DisarmTimeOR obj = new DisarmTimeOR(dr); _List.Add(obj); } return _List; }
public void Clone(DisarmTimeOR obj) { // Disarmid = obj.Disarmid; //撤防名称 Disarmname = obj.Disarmname; //撤防开始时间 Disarmstarttime = obj.Disarmstarttime; //撤防结束时间 Disarmendtime = obj.Disarmendtime; }
public DisarmTimeEditView(DisarmTimeListViewModel _List, DisarmTimeOR _DisarmTime) { InitializeComponent(); this.DataContext = new DisarmTimeEditViewModel(_List, this, _DisarmTime); }
public DisarmTimeEditViewModel(DisarmTimeOR _Sta) { OperationType = OpType.Alert; DisarmTimeObj = _Sta; }
public DisarmTimeOR selectARowDate(string m_id) { string sql = string.Format("select * from t_DisarmTime where Disarmid='{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]; DisarmTimeOR m_Disa = new DisarmTimeOR(dr); return m_Disa; }
/// <summary> /// 更新t_DisarmTime /// </summary> public virtual bool Update(DisarmTimeOR disarmTime) { string sql = "update t_DisarmTime set DisarmName = @DisarmName, DisarmStartTime = @DisarmStartTime, DisarmEndTime = @DisarmEndTime where DisarmID = @DisarmID"; SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@DisarmID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "DisarmID", DataRowVersion.Default, disarmTime.Disarmid), new SqlParameter("@DisarmName", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "DisarmName", DataRowVersion.Default, disarmTime.Disarmname), new SqlParameter("@DisarmStartTime", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "DisarmStartTime", DataRowVersion.Default, disarmTime.Disarmstarttime), new SqlParameter("@DisarmEndTime", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "DisarmEndTime", DataRowVersion.Default, disarmTime.Disarmendtime) }; return db.ExecuteNoQuery(sql, parameters) > -1; }