public AlarmGroupsEditViewModel(AlarmGroupsListViewModel _vm, AlarmGroupsEditView _mw)
{
_AlarmGroupsListVM = _vm;
_Window = _mw;
OperationType = OpType.Add;
AlarmGroupsObj = new AlarmGroupsOR();
//UpdatetxtSource(_Window.gridContent);
Init();
}
/// <summary>
/// 插入t_AlarmGroups
/// </summary>
public virtual bool Insert(AlarmGroupsOR alarmGroups)
{
string sql = "insert into t_AlarmGroups (StationID, GroupName) values (@StationID, @GroupName)";
SqlParameter[] parameters = new SqlParameter[]
{
//new SqlParameter("@AlarmGroupsID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "AlarmGroupsID", DataRowVersion.Default, alarmGroups.Alarmgroupsid),
new SqlParameter("@StationID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "StationID", DataRowVersion.Default, alarmGroups.Stationid),
new SqlParameter("@GroupName", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "GroupName", DataRowVersion.Default, alarmGroups.Groupname)
};
return db.ExecuteNoQuery(sql, parameters) > -1;
}
public AlarmGroupsEditViewModel(AlarmGroupsListViewModel _vm, AlarmGroupsEditView _mw, AlarmGroupsOR _AlarmGroupsObj)
{
_AlarmGroupsListVM = _vm;
_Window = _mw;
_SourceObj = _AlarmGroupsObj;
OperationType = OpType.Alert;
AlarmGroupsObj = new AlarmGroupsOR();
AlarmGroupsObj.Clone(_AlarmGroupsObj);
Init();
}
public ObservableCollection<AlarmGroupsOR> selectAllDate()
{
string sql = @"select ag.*,s.StationName from t_AlarmGroups ag
inner join t_Station s on s.StationID=ag.StationID";
DataTable dt = null;
try
{
dt = db.ExecuteQuery(sql);
}
catch (Exception ex)
{
throw ex;
}
ObservableCollection<AlarmGroupsOR> _List = new ObservableCollection<AlarmGroupsOR>();
foreach (DataRow dr in dt.Rows)
{
AlarmGroupsOR obj = new AlarmGroupsOR(dr);
_List.Add(obj);
}
return _List;
}
/// <summary>
/// 更新t_AlarmGroups
/// </summary>
public virtual bool Update(AlarmGroupsOR alarmGroups)
{
string sql = "update t_AlarmGroups set StationID = @StationID, GroupName = @GroupName where AlarmGroupsID = @AlarmGroupsID";
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@AlarmGroupsID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "AlarmGroupsID", DataRowVersion.Default, alarmGroups.Alarmgroupsid),
new SqlParameter("@StationID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "StationID", DataRowVersion.Default, alarmGroups.Stationid),
new SqlParameter("@GroupName", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "GroupName", DataRowVersion.Default, alarmGroups.Groupname)
};
return db.ExecuteNoQuery(sql, parameters) > -1;
}
public AlarmGroupsOR selectARowDate(string m_id)
{
string sql = string.Format("select * from t_AlarmGroups where Alarmgroupsid='{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];
AlarmGroupsOR m_Alar = new AlarmGroupsOR(dr);
return m_Alar;
}
public AlarmGroupsEditView(AlarmGroupsListViewModel _List, AlarmGroupsOR _AlarmGroups)
{
InitializeComponent();
this.DataContext = new AlarmGroupsEditViewModel(_List, this, _AlarmGroups);
}
public void Clone(AlarmGroupsOR obj)
{
//
Alarmgroupsid = obj.Alarmgroupsid;
//站点
Stationid = obj.Stationid;
//名称
Groupname = obj.Groupname;
StationName = obj.StationName;
}
public AlarmGroupsEditViewModel(AlarmGroupsOR _Sta)
{
OperationType = OpType.Alert;
AlarmGroupsObj = _Sta;
}