public Dictionary<int, GroupSwitchGroup> GetAllGroupSwitchGroups(ref string errMessage)
{
Database db = DatabaseFactory.CreateDatabase();
errMessage = "";
var list = new Dictionary<int, GroupSwitchGroup>();
try
{
GroupSwitchGroup groupSwitchGroup;
DataSet ds = GroupSwitchGroupDataAccess.GetAllGroupSwitchGroupInfo(db);
DataSet groupSwitchDetail;
GroupSwitchDetailInfo groupSwitchDetailInfo;
CameraMonitorPairInfo cameraMonitorPairInfo;
//对于每一个群组切换的组
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
groupSwitchGroup = new GroupSwitchGroup(ds.Tables[0].Rows[i]);
groupSwitchDetail = GroupSwitchDetailDataAccess.GetGroupSwitchDetailByGroupSwitchId(db, groupSwitchGroup.Id);
groupSwitchGroup.ListGroupSwitchDetailInfo = new Dictionary<int, GroupSwitchDetailInfo>();
//对于一个组中的所有与同步群组有联系的记录
foreach (DataRow drgsdi in groupSwitchDetail.Tables[0].Rows)
{
groupSwitchDetailInfo = new GroupSwitchDetailInfo(drgsdi);
//根据同步群组获取同步群组与摄像机、监视器的配对信息
DataSet dsCamMonPair = CameraMonitorPairDataAccess.GetCameraMonitorPairBySynGroupId(db,
groupSwitchDetailInfo.SynGroupId);
groupSwitchDetailInfo.ListCameraMonitorPair = new Dictionary<int, CameraMonitorPairInfo>();
foreach (DataRow drCmP in dsCamMonPair.Tables[0].Rows)
{
cameraMonitorPairInfo = new CameraMonitorPairInfo(drCmP);
groupSwitchDetailInfo.ListCameraMonitorPair.Add(cameraMonitorPairInfo.CameraMonitorPairId, cameraMonitorPairInfo);
}
groupSwitchGroup.ListGroupSwitchDetailInfo.Add(groupSwitchDetailInfo.Id, groupSwitchDetailInfo);
}
list.Add(groupSwitchGroup.Id, groupSwitchGroup);
}
return list;
}
catch (Exception ex)
{
errMessage = ex.Message + ex.StackTrace;
Logger.Error("Error Message:" + ex.Message + " Trace:" + ex.StackTrace);
return null;
}
}
public SynGroup GetSynGroupBySynGroupName(ref string errMessage, string synGroupName)
{
Database db = DatabaseFactory.CreateDatabase();
errMessage = "";
try
{
DataSet ds = SynGroupDataAccess.GetSynGroupBySynGroupName(db, synGroupName);
if (ds.Tables[0].Rows.Count == 0)
{
return null;
}
CameraInfo oCamera;
DeviceInfo oDevice;
var synGroup = new SynGroup(ds.Tables[0].Rows[0]) { ListCamera = new Dictionary<int, CameraInfo>() };
//DataSet dsCamera = CameraDataAccess.GetCamInfoBySynGroupId(db, synGroup.SynGroupId);
//synGroup.ListCamera = new Dictionary<int, CameraInfo>();
//foreach (DataRow drCam in dsCamera.Tables[0].Rows)
//{
// oCamera = new CameraInfo(drCam);
// synGroup.ListCamera.Add(oCamera.CameraId, oCamera);
//}
CameraMonitorPairInfo cameraMonitorPair;
DataSet dsCameraMonitorPair = CameraMonitorPairDataAccess.GetCameraMonitorPairBySynGroupId(db, synGroup.SynGroupId);
synGroup.ListCameraMonitorPair = new Dictionary<int, CameraMonitorPairInfo>();
foreach (DataRow drCamMonPair in dsCameraMonitorPair.Tables[0].Rows)
{
cameraMonitorPair = new CameraMonitorPairInfo(drCamMonPair);
synGroup.ListCameraMonitorPair.Add(cameraMonitorPair.CameraMonitorPairId, cameraMonitorPair);
}
return synGroup;
}
catch (Exception ex)
{
errMessage = ex.Message + ex.StackTrace;
Logger.Error("Error Message:" + ex.Message + " Trace:" + ex.StackTrace);
return null;
}
}
public Dictionary<int, SynGroup> GetAllSynGroups(ref string errMessage)
{
Database db = DatabaseFactory.CreateDatabase();
errMessage = "";
var list = new Dictionary<int, SynGroup>();
try
{
SynGroup synGroup;
DeviceInfo oDevice;
DataSet ds = SynGroupDataAccess.GetAllSynGroupInfo(db);
DataSet dsCamera;
CameraInfo oCamera;
DataSet dsCameraMonitorPair;
CameraMonitorPairInfo cameraMonitorPair;
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
synGroup = new SynGroup(ds.Tables[0].Rows[i]);
//dsCamera = CameraDataAccess.GetCamInfoBySynGroupId(db, synGroup.SynGroupId);
//synGroup.ListCamera = new Dictionary<int, CameraInfo>();
//foreach (DataRow drCam in dsCamera.Tables[0].Rows)
//{
// oCamera = new CameraInfo(drCam);
// synGroup.ListCamera.Add(oCamera.CameraId, oCamera);
//}
dsCameraMonitorPair = CameraMonitorPairDataAccess.GetCameraMonitorPairBySynGroupId(db, synGroup.SynGroupId);
synGroup.ListCameraMonitorPair = new Dictionary<int, CameraMonitorPairInfo>();
foreach (DataRow drCamMonPair in dsCameraMonitorPair.Tables[0].Rows)
{
cameraMonitorPair = new CameraMonitorPairInfo(drCamMonPair);
synGroup.ListCameraMonitorPair.Add(cameraMonitorPair.CameraMonitorPairId, cameraMonitorPair);
}
list.Add(synGroup.SynGroupId, synGroup);
}
return list;
}
catch (Exception ex)
{
errMessage = ex.Message + ex.StackTrace;
Logger.Error("Error Message:" + ex.Message + " Trace:" + ex.StackTrace);
return null;
}
}
public GroupSwitchGroup GetGroupSwitchGroupById(ref string errMessage, int groupSwitchGroupId)
{
Database db = DatabaseFactory.CreateDatabase();
errMessage = "";
try
{
DataSet ds = GroupSwitchGroupDataAccess.GetGroupSwitchGroupById(db, groupSwitchGroupId);
if (ds.Tables[0].Rows.Count == 0)
{
return null;
}
var groupSwitchGroup = new GroupSwitchGroup(ds.Tables[0].Rows[0]) {ListGroupSwitchDetailInfo = new Dictionary<int, GroupSwitchDetailInfo>()};
var groupSwitchDetail = GroupSwitchDetailDataAccess.GetGroupSwitchDetailByGroupSwitchId(db, groupSwitchGroup.Id);
groupSwitchGroup.ListGroupSwitchDetailInfo = new Dictionary<int, GroupSwitchDetailInfo>();
//对于一个组中的所有与同步群组有联系的记录
foreach (DataRow drgsdi in groupSwitchDetail.Tables[0].Rows)
{
var groupSwitchDetailInfo = new GroupSwitchDetailInfo(drgsdi);
//根据同步群组获取同步群组与摄像机、监视器的配对信息
DataSet dsCamMonPair = CameraMonitorPairDataAccess.GetCameraMonitorPairBySynGroupId(db,
groupSwitchDetailInfo.SynGroupId);
groupSwitchDetailInfo.ListCameraMonitorPair = new Dictionary<int, CameraMonitorPairInfo>();
foreach (DataRow drCmP in dsCamMonPair.Tables[0].Rows)
{
var cameraMonitorPairInfo = new CameraMonitorPairInfo(drCmP);
groupSwitchDetailInfo.ListCameraMonitorPair.Add(cameraMonitorPairInfo.CameraMonitorPairId, cameraMonitorPairInfo);
}
groupSwitchGroup.ListGroupSwitchDetailInfo.Add(groupSwitchDetailInfo.Id, groupSwitchDetailInfo);
}
return groupSwitchGroup;
}
catch (Exception ex)
{
errMessage = ex.Message + ex.StackTrace;
Logger.Error("Error Message:" + ex.Message + " Trace:" + ex.StackTrace);
return null;
}
}
