public TimeLinkageEditViewModel(TimeLinkageListViewModel _vm, TimeLinkageEditView _mw)
{
_TimeLinkageListVM = _vm;
_Window = _mw;
OperationType = OpType.Add;
TimeLinkageObj = new TimeLinkageOR();
Init();
}
public TimeLinkageEditViewModel(TimeLinkageListViewModel _vm, TimeLinkageEditView _mw, TimeLinkageOR _TimeLinkageObj)
{
_TimeLinkageListVM = _vm;
_Window = _mw;
_SourceObj = _TimeLinkageObj;
OperationType = OpType.Alert;
TimeLinkageObj = new TimeLinkageOR();
TimeLinkageObj.Clone(_TimeLinkageObj);
Init();
}
/// <summary>
/// 插入t_TimeLinkage
/// </summary>
public virtual bool Insert(TimeLinkageOR timeLinkage)
{
string sql = @"insert into t_TimeLinkage (LinkageStationID, LinkageDeviceID, LinkageChannelNo, TriggerTime)
values (@LinkageStationID, @LinkageDeviceID, @LinkageChannelNo, @TriggerTime)";
SqlParameter[] parameters = new SqlParameter[]
{
//new SqlParameter("@LinkageID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "LinkageID", DataRowVersion.Default, timeLinkage.Linkageid),
new SqlParameter("@LinkageStationID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "LinkageStationID", DataRowVersion.Default, timeLinkage.Linkagestationid),
new SqlParameter("@LinkageDeviceID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "LinkageDeviceID", DataRowVersion.Default, timeLinkage.Linkagedeviceid),
new SqlParameter("@LinkageChannelNo", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "LinkageChannelNo", DataRowVersion.Default, timeLinkage.Linkagechannelno),
new SqlParameter("@TriggerTime", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "TriggerTime", DataRowVersion.Default, timeLinkage.Triggertime)
};
return db.ExecuteNoQuery(sql, parameters) > -1;
}
public ObservableCollection<TimeLinkageOR> selectAllDate()
{
string sql = @"select tl.*,t.StationName,d.DeviceName,c.ChannelName from t_TimeLinkage tl
inner join t_Station t on tl.LinkageStationID=t.StationID
inner join t_Device d on tl.LinkageDeviceID=d.DeviceID
inner join t_Channel c on tl.LinkageChannelNo=c.ChannelNo and c.DeviceID=d.DeviceID";
DataTable dt = null;
try
{
dt = db.ExecuteQuery(sql);
}
catch (Exception ex)
{
throw ex;
}
ObservableCollection<TimeLinkageOR> _List = new ObservableCollection<TimeLinkageOR>();
foreach (DataRow dr in dt.Rows)
{
TimeLinkageOR obj = new TimeLinkageOR(dr);
_List.Add(obj);
}
return _List;
}
/// <summary>
/// 更新t_TimeLinkage
/// </summary>
public virtual bool Update(TimeLinkageOR timeLinkage)
{
string sql = "update t_TimeLinkage set LinkageStationID = @LinkageStationID, LinkageDeviceID = @LinkageDeviceID, LinkageChannelNo = @LinkageChannelNo, TriggerTime = @TriggerTime where LinkageID = @LinkageID";
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@LinkageID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "LinkageID", DataRowVersion.Default, timeLinkage.Linkageid),
new SqlParameter("@LinkageStationID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "LinkageStationID", DataRowVersion.Default, timeLinkage.Linkagestationid),
new SqlParameter("@LinkageDeviceID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "LinkageDeviceID", DataRowVersion.Default, timeLinkage.Linkagedeviceid),
new SqlParameter("@LinkageChannelNo", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "LinkageChannelNo", DataRowVersion.Default, timeLinkage.Linkagechannelno),
new SqlParameter("@TriggerTime", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "TriggerTime", DataRowVersion.Default, timeLinkage.Triggertime)
};
return db.ExecuteNoQuery(sql, parameters) > -1;
}
public TimeLinkageOR selectARowDate(string m_id)
{
string sql = string.Format("select * from t_TimeLinkage where Linkageid='{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];
TimeLinkageOR m_Time = new TimeLinkageOR(dr);
return m_Time;
}
public void Clone(TimeLinkageOR obj)
{
//
Linkageid = obj.Linkageid;
//联动机房名称
Linkagestationid = obj.Linkagestationid;
//联动设备名称
Linkagedeviceid = obj.Linkagedeviceid;
//联动通道名称
Linkagechannelno = obj.Linkagechannelno;
//联动时间
Triggertime = obj.Triggertime;
StationName = obj.StationName;
DeviceName = obj.DeviceName;
ChannelName = obj.ChannelName;
}
public TimeLinkageEditViewModel(TimeLinkageOR _Sta)
{
OperationType = OpType.Alert;
TimeLinkageObj = _Sta;
}
public TimeLinkageEditView(TimeLinkageListViewModel _List, TimeLinkageOR _TimeLinkage)
{
InitializeComponent();
this.DataContext = new TimeLinkageEditViewModel(_List, this, _TimeLinkage);
}
