/// <summary>
/// 获得数据列表
/// </summary>
public List<DB_Talk.Model.Data_Alarm> DataTableToList(DataSet ds)
{
List<DB_Talk.Model.Data_Alarm> modelList = new List<DB_Talk.Model.Data_Alarm>();
if (ds == null) return modelList;
DataTable dt = ds.Tables[0];
int rowsCount = dt.Rows.Count;
if (rowsCount > 0)
{
DB_Talk.Model.Data_Alarm model;
for (int n = 0; n < rowsCount; n++)
{
model = new DB_Talk.Model.Data_Alarm();
if(dt.Rows[n]["ID"]!=null && dt.Rows[n]["ID"].ToString()!="")
{
model.ID=int.Parse(dt.Rows[n]["ID"].ToString());
}
if(dt.Rows[n]["BoxID"]!=null && dt.Rows[n]["BoxID"].ToString()!="")
{
model.BoxID=int.Parse(dt.Rows[n]["BoxID"].ToString());
}
if(dt.Rows[n]["dt_DateTime"]!=null && dt.Rows[n]["dt_DateTime"].ToString()!="")
{
model.dt_DateTime=DateTime.Parse(dt.Rows[n]["dt_DateTime"].ToString());
}
if(dt.Rows[n]["AlarmTypeID"]!=null && dt.Rows[n]["AlarmTypeID"].ToString()!="")
{
model.AlarmTypeID=int.Parse(dt.Rows[n]["AlarmTypeID"].ToString());
}
if(dt.Rows[n]["vc_Memo"]!=null && dt.Rows[n]["vc_Memo"].ToString()!="")
{
model.vc_Memo= dt.Rows[n]["vc_Memo"].ToString();
}
if(dt.Rows[n]["i_AlarmSeriesNumber"]!=null && dt.Rows[n]["i_AlarmSeriesNumber"].ToString()!="")
{
model.i_AlarmSeriesNumber=int.Parse(dt.Rows[n]["i_AlarmSeriesNumber"].ToString());
}
if(dt.Rows[n]["i_AlarmInfo"]!=null && dt.Rows[n]["i_AlarmInfo"].ToString()!="")
{
model.i_AlarmInfo=int.Parse(dt.Rows[n]["i_AlarmInfo"].ToString());
}
if(dt.Rows[n]["i_AlarmInfoDetail"]!=null && dt.Rows[n]["i_AlarmInfoDetail"].ToString()!="")
{
model.i_AlarmInfoDetail=int.Parse(dt.Rows[n]["i_AlarmInfoDetail"].ToString());
}
if(dt.Rows[n]["i_AlarmEntityType"]!=null && dt.Rows[n]["i_AlarmEntityType"].ToString()!="")
{
model.i_AlarmEntityType=int.Parse(dt.Rows[n]["i_AlarmEntityType"].ToString());
}
if(dt.Rows[n]["i_AlarmEntityInstance"]!=null && dt.Rows[n]["i_AlarmEntityInstance"].ToString()!="")
{
model.i_AlarmEntityInstance=int.Parse(dt.Rows[n]["i_AlarmEntityInstance"].ToString());
}
if(dt.Rows[n]["i_AlarmEntityInstanceShelf"]!=null && dt.Rows[n]["i_AlarmEntityInstanceShelf"].ToString()!="")
{
model.i_AlarmEntityInstanceShelf=int.Parse(dt.Rows[n]["i_AlarmEntityInstanceShelf"].ToString());
}
if(dt.Rows[n]["i_AlarmEntityInstanceSlot"]!=null && dt.Rows[n]["i_AlarmEntityInstanceSlot"].ToString()!="")
{
model.i_AlarmEntityInstanceSlot=int.Parse(dt.Rows[n]["i_AlarmEntityInstanceSlot"].ToString());
}
if(dt.Rows[n]["i_AlarmEntityInstancePort"]!=null && dt.Rows[n]["i_AlarmEntityInstancePort"].ToString()!="")
{
model.i_AlarmEntityInstancePort=int.Parse(dt.Rows[n]["i_AlarmEntityInstancePort"].ToString());
}
if(dt.Rows[n]["i_AlarmClass"]!=null && dt.Rows[n]["i_AlarmClass"].ToString()!="")
{
model.i_AlarmClass=int.Parse(dt.Rows[n]["i_AlarmClass"].ToString());
}
if(dt.Rows[n]["i_AlarmSeverity"]!=null && dt.Rows[n]["i_AlarmSeverity"].ToString()!="")
{
model.i_AlarmSeverity=int.Parse(dt.Rows[n]["i_AlarmSeverity"].ToString());
}
if(dt.Rows[n]["i_AlarmAckFlag"]!=null && dt.Rows[n]["i_AlarmAckFlag"].ToString()!="")
{
model.i_AlarmAckFlag=int.Parse(dt.Rows[n]["i_AlarmAckFlag"].ToString());
}
modelList.Add(model);
}
}
return modelList;
}
/// <summary>
/// 告警回调函数
/// </summary>
/// <param name="alarmLevel"></param>
/// <param name="notify"></param>
/// <param name="hInstance"></param>
private void cllBackForAlarm(MBoxSDK.TalkSDK.EnumALARM_LEVEL alarmLevel, MBoxSDK.TalkSDK.MBox_AlarmNotify notify, IntPtr hInstance)
{
DB_Talk.Model.Data_Alarm alarmModel = new DB_Talk.Model.Data_Alarm();
alarmModel.AlarmTypeID = alarmLevel.GetHashCode();
alarmModel.i_AlarmAckFlag = notify.alarmAckFlag;
alarmModel.i_AlarmClass = notify.alarmClass;
alarmModel.i_AlarmEntityInstance = notify.alarmEntityInstance;
alarmModel.i_AlarmEntityType = notify.alarmEntityType;
alarmModel.i_AlarmInfo = notify.alarmInfo;
alarmModel.i_AlarmSeriesNumber = notify.alarmSeriesNumber;
alarmModel.i_AlarmSeverity = notify.alarmSeverity;
alarmModel.dt_DateTime = DateTime.Now;
new DB_Talk.BLL.Data_Alarm().Add(alarmModel);
}
/// <summary>
/// 根据条件得到一个对象实体
/// </summary>
public DB_Talk.Model.Data_Alarm GetModel(string strWhere)
{
StringBuilder strSql=new StringBuilder();
strSql.Append(" select top 1 ");
strSql.Append(" ID, BoxID, dt_DateTime, AlarmTypeID, vc_Memo, i_AlarmSeriesNumber, i_AlarmInfo, i_AlarmInfoDetail, i_AlarmEntityType, i_AlarmEntityInstance, i_AlarmEntityInstanceShelf, i_AlarmEntityInstanceSlot, i_AlarmEntityInstancePort, i_AlarmClass, i_AlarmSeverity, i_AlarmAckFlag ");
strSql.Append(" from Data_Alarm ");
if(strWhere.Trim()!="")
{
strSql.Append(" where "+strWhere);
}
DB_Talk.Model.Data_Alarm model=new DB_Talk.Model.Data_Alarm();
DataSet ds=GetDataSet(strSql.ToString());
if(ds!=null && ds.Tables[0].Rows.Count>0)
{
model=DataTableToList(ds)[0];
return model;
}
else
{
return null;
}
}
