public AlarmLevelSetEditViewModel(AlarmLevelSetListViewModel _vm, AlarmLevelSetEditView _mw)
{
_AlarmLevelSetListVM = _vm;
_Window = _mw;
OperationType = OpType.Add;
AlarmLevelSetObj = new AlarmLevelSetOR();
Init();
}
/// <summary>
/// 插入t_AlarmLevelSet
/// </summary>
public virtual bool Insert(AlarmLevelSetOR alarmLevelSet)
{
string sql = "insert into t_AlarmLevelSet ( Priority, LevelName, UpInterval) values (@Priority, @LevelName, @UpInterval)";
SqlParameter [] parameters = new SqlParameter[]
{
//new SqlParameter("@ID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "ID", DataRowVersion.Default, alarmLevelSet.Id),
new SqlParameter("@Priority", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "Priority", DataRowVersion.Default, alarmLevelSet.Priority),
new SqlParameter("@LevelName", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "LevelName", DataRowVersion.Default, alarmLevelSet.Levelname),
new SqlParameter("@UpInterval", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "UpInterval", DataRowVersion.Default, alarmLevelSet.Upinterval)
};
return db.ExecuteNoQuery(sql, parameters) > -1;
}
public AlarmLevelSetEditViewModel(AlarmLevelSetListViewModel _vm, AlarmLevelSetEditView _mw, AlarmLevelSetOR _AlarmLevelSetObj)
{
_AlarmLevelSetListVM = _vm;
_Window = _mw;
_SourceObj = _AlarmLevelSetObj;
OperationType = OpType.Alert;
AlarmLevelSetObj = new AlarmLevelSetOR();
AlarmLevelSetObj.Clone(_AlarmLevelSetObj);
Init();
}
public ObservableCollection<AlarmLevelSetOR> selectAllDate()
{
string sql = "select * from t_AlarmLevelSet";
DataTable dt = null;
try
{
dt = db.ExecuteQuery(sql);
}
catch (Exception ex)
{
throw ex;
}
ObservableCollection<AlarmLevelSetOR> _List = new ObservableCollection<AlarmLevelSetOR>();
foreach (DataRow dr in dt.Rows)
{
AlarmLevelSetOR obj = new AlarmLevelSetOR(dr);
_List.Add(obj);
}
return _List;
}
public AlarmLevelSetOR selectARowDate(string m_id)
{
string sql = string.Format("select * from t_AlarmLevelSet 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];
AlarmLevelSetOR m_Alar=new AlarmLevelSetOR(dr);
return m_Alar;
}
/// <summary>
/// 更新t_AlarmLevelSet
/// </summary>
public virtual bool Update(AlarmLevelSetOR alarmLevelSet)
{
string sql = "update t_AlarmLevelSet set Priority = @Priority, LevelName = @LevelName, UpInterval = @UpInterval where ID = @ID";
SqlParameter [] parameters = new SqlParameter[]
{
new SqlParameter("@ID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "ID", DataRowVersion.Default, alarmLevelSet.Id),
new SqlParameter("@Priority", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "Priority", DataRowVersion.Default, alarmLevelSet.Priority),
new SqlParameter("@LevelName", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "LevelName", DataRowVersion.Default, alarmLevelSet.Levelname),
new SqlParameter("@UpInterval", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "UpInterval", DataRowVersion.Default, alarmLevelSet.Upinterval)
};
return db.ExecuteNoQuery(sql, parameters) > -1;
}
public AlarmLevelSetEditView(AlarmLevelSetListViewModel _List, AlarmLevelSetOR _AlarmLevelSet)
{
InitializeComponent();
this.DataContext = new AlarmLevelSetEditViewModel(_List, this, _AlarmLevelSet);
}
public AlarmLevelSetEditViewModel(AlarmLevelSetOR _Sta)
{
OperationType = OpType.Alert;
AlarmLevelSetObj = _Sta;
}
public void Clone(AlarmLevelSetOR obj)
{
//
Id = obj.Id;
//级别
Priority = obj.Priority;
//等级名称
Levelname = obj.Levelname;
//自动升级间隔时间
Upinterval = obj.Upinterval;
}