public ObservableCollection<FalseAlarmPolicyOR> selectAllDate()
{
string sql = @"select fp.*,t.StationName,d.DeviceName,c.ChannelName from t_FalseAlarmPolicy fp
inner join t_AlarmPolicyManagement am on fp.PolicyID= am.AlarmPolicyManagementID
inner join t_Station t on am.StationID=t.StationID
inner join t_Device d on am.DeviceID=d.DeviceID
inner join t_Channel c on am.DeviceChannelID=c.ChannelNo and c.DeviceID=d.DeviceID
";
DataTable dt = null;
try
{
dt = db.ExecuteQuery(sql);
}
catch (Exception ex)
{
throw ex;
}
ObservableCollection<FalseAlarmPolicyOR> _List = new ObservableCollection<FalseAlarmPolicyOR>();
foreach (DataRow dr in dt.Rows)
{
FalseAlarmPolicyOR obj = new FalseAlarmPolicyOR(dr);
_List.Add(obj);
}
return _List;
}
public FalseAlarmPolicyEditViewModel(FalseAlarmPolicyListViewModel _vm, FalseAlarmPolicyEditView _mw)
{
_FalseAlarmPolicyListVM = _vm;
_Window = _mw;
OperationType = OpType.Add;
FalseAlarmPolicyObj = new FalseAlarmPolicyOR();
//UpdatetxtSource(_Window.gridContent);
Init();
}
public FalseAlarmPolicyEditViewModel(FalseAlarmPolicyListViewModel _vm, FalseAlarmPolicyEditView _mw, FalseAlarmPolicyOR _FalseAlarmPolicyObj)
{
_FalseAlarmPolicyListVM = _vm;
_Window = _mw;
_SourceObj = _FalseAlarmPolicyObj;
OperationType = OpType.Alert;
FalseAlarmPolicyObj = new FalseAlarmPolicyOR();
FalseAlarmPolicyObj.Clone(_FalseAlarmPolicyObj);
Init();
}
/// <summary>
/// 插入t_FalseAlarmPolicy
/// </summary>
public virtual bool Insert(FalseAlarmPolicyOR falseAlarmPolicy)
{
string sql = @"insert into t_FalseAlarmPolicy ( FalsePolicyID, PolicyID, FalseType)
values (@FalsePolicyID, @PolicyID, @FalseType)";
SqlParameter[] parameters = new SqlParameter[]
{
//new SqlParameter("@FalseAlarmID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "FalseAlarmID", DataRowVersion.Default, falseAlarmPolicy.Falsealarmid),
new SqlParameter("@FalsePolicyID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "FalsePolicyID", DataRowVersion.Default, falseAlarmPolicy.Falsepolicyid),
new SqlParameter("@PolicyID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "PolicyID", DataRowVersion.Default, falseAlarmPolicy.Policyid),
new SqlParameter("@FalseType", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "FalseType", DataRowVersion.Default, falseAlarmPolicy.Falsetype)
};
return db.ExecuteNoQuery(sql, parameters) > -1;
}
/// <summary>
/// 更新t_FalseAlarmPolicy
/// </summary>
public virtual bool Update(FalseAlarmPolicyOR falseAlarmPolicy)
{
string sql = "update t_FalseAlarmPolicy set FalsePolicyID = @FalsePolicyID, PolicyID = @PolicyID, FalseType = @FalseType where FalseAlarmID = @FalseAlarmID";
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@FalseAlarmID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "FalseAlarmID", DataRowVersion.Default, falseAlarmPolicy.Falsealarmid),
new SqlParameter("@FalsePolicyID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "FalsePolicyID", DataRowVersion.Default, falseAlarmPolicy.Falsepolicyid),
new SqlParameter("@PolicyID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "PolicyID", DataRowVersion.Default, falseAlarmPolicy.Policyid),
new SqlParameter("@FalseType", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "FalseType", DataRowVersion.Default, falseAlarmPolicy.Falsetype)
};
return db.ExecuteNoQuery(sql, parameters) > -1;
}
public FalseAlarmPolicyOR selectARowDate(string m_id)
{
string sql = string.Format("select * from t_FalseAlarmPolicy where Falsealarmid='{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];
FalseAlarmPolicyOR m_Fals = new FalseAlarmPolicyOR(dr);
return m_Fals;
}
public FalseAlarmPolicyEditViewModel(FalseAlarmPolicyOR _Sta)
{
OperationType = OpType.Alert;
FalseAlarmPolicyObj = _Sta;
}
public FalseAlarmPolicyEditView(FalseAlarmPolicyListViewModel _List, FalseAlarmPolicyOR _FalseAlarmPolicy)
{
InitializeComponent();
this.DataContext = new FalseAlarmPolicyEditViewModel(_List, this, _FalseAlarmPolicy);
}
public void Clone(FalseAlarmPolicyOR obj)
{
//机房名称
Falsealarmid = obj.Falsealarmid;
//设备名称
Falsepolicyid = obj.Falsepolicyid;
//策略名
Policyid = obj.Policyid;
//限制类型
Falsetype = obj.Falsetype;
StationName = obj.StationName;
DeviceName = obj.DeviceName;
ChannelName = obj.ChannelName;
}
