public List <GroupSwitchDetailInfo> GetGroupSwitchDetailByGroupSwitchId(ref string errMessage, int groupSwitchId)
{
Database db = DatabaseFactory.CreateDatabase();
errMessage = "";
try
{
List <GroupSwitchDetailInfo> list = new List <GroupSwitchDetailInfo>();
DataSet ds = GroupSwitchDetailDataAccess.GetGroupSwitchDetailByGroupSwitchId(db, groupSwitchId);
if (ds.Tables[0].Rows.Count == 0)
{
return(null);
}
GroupSwitchDetailInfo oGroupSwitchDetailInfo;
foreach (DataRow dr in ds.Tables[0].Rows)
{
oGroupSwitchDetailInfo = new GroupSwitchDetailInfo(dr);
list.Add(oGroupSwitchDetailInfo);
}
return(list);
}
catch (Exception ex)
{
errMessage = ex.Message + ex.StackTrace;
logger.Error("Error Message:" + ex.Message + " Trace:" + ex.StackTrace);
return(null);
}
}
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 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);
}
}
private void DisplayGroupSwitchDetail()
{
dgvGroupSwitchDetail.Rows.Clear();
lblGroupSwitchName.Text = "";
if (_lastSelectedGroupSwitchGroupTreeNode == null)
{
return;
}
string str = _lastSelectedGroupSwitchGroupTreeNode.Tag.ToString();
if (str.IndexOf("D") < 0)
{
string[] strs = str.Split(';');
int gsID = int.Parse(strs[0]);
GroupSwitchGroup groupSwitchGroup = _listGroupSwitchGroup[gsID];
lblGroupSwitchName.Text = groupSwitchGroup.Name;
foreach (KeyValuePair <int, GroupSwitchDetailInfo> keyValuePair in groupSwitchGroup.ListGroupSwitchDetailInfo)
{
int index = dgvGroupSwitchDetail.Rows.Add();
DataGridViewRow dgvr = dgvGroupSwitchDetail.Rows[index];
dgvr.Cells["SynGroup"].Value = keyValuePair.Value.SynGroupName;
dgvr.Cells["Tick"].Value = keyValuePair.Value.TickTime;
dgvr.Cells["Id"].Value = keyValuePair.Key;
}
}
else if (str.IndexOf("D") >= 0)
{
string[] strs = str.Split(';');
int gsID = int.Parse(strs[2]);
GroupSwitchGroup groupSwitchGroup = _listGroupSwitchGroup[gsID];
lblGroupSwitchName.Text = groupSwitchGroup.Name;
int detailId = int.Parse(strs[0]);
GroupSwitchDetailInfo groupSwitchDetailInfo = groupSwitchGroup.ListGroupSwitchDetailInfo[detailId];
int index = dgvGroupSwitchDetail.Rows.Add();
DataGridViewRow dgvr = dgvGroupSwitchDetail.Rows[index];
dgvr.Cells["SynGroup"].Value = groupSwitchDetailInfo.SynGroupName;
dgvr.Cells["Tick"].Value = groupSwitchDetailInfo.TickTime;
dgvr.Cells["Id"].Value = groupSwitchDetailInfo.Id;
}
}
private void btnDeleteGroupSwitchDetail_Click(object sender, EventArgs e)
{
if (_lastSelectedGroupSwitchGroupTreeNode == null)
{
return;
}
string selectTagStr = _lastSelectedGroupSwitchGroupTreeNode.Tag.ToString();
if (selectTagStr.IndexOf("D") < 0)
{
if (_lastSelectedGroupSwitchGroupTreeNode.FirstNode != null)
{
XtraMessageBox.Show("群组切换非空，不能直接删除!");
}
else
{
string[] strs = selectTagStr.Split(';');
int groupSwitchGroupId = int.Parse(strs[0]);
_lastSelectedGroupSwitchGroupTreeNode = tvGroupSwitchGroup.SelectedNode.PrevNode;
GroupSwitchGroup groupSwitchGroup = GroupSwitchGroupBusiness.Instance.GetGroupSwitchGroupById(ref errMessage,
groupSwitchGroupId);
GroupSwitchGroupBusiness.Instance.Delete(ref errMessage, groupSwitchGroupId);
OperateLogBusiness.Instance.Insert(ref errMessage,
new OperateLog
{
ClientUserId = MainForm.CurrentUser.UserId,
ClientUserName = MainForm.CurrentUser.UserName,
Content = groupSwitchGroup.ToString(),
HappenTime = DateTime.Now,
OperateTypeId = (int)(OperateLogTypeId.GroupSwitchDelete),
OperateTypeName = OperateLogTypeName.GroupSwitchDelete,
OperateUserName = MainForm.CurrentUser.UserName
});
}
}
else
{
string[] tagStrs = selectTagStr.Split(';');
int detailId = int.Parse(tagStrs[0]);
GroupSwitchDetailInfo groupSwitchDetailInfo =
GroupSwitchDetailBusiness.Instance.GetGroupSwitchDetailById(ref errMessage, detailId);
GroupSwitchDetailBusiness.Instance.DeleteGroupSwitchDetailById(ref errMessage, detailId);
OperateLogBusiness.Instance.Insert(ref errMessage,
new OperateLog
{
ClientUserId = MainForm.CurrentUser.UserId,
ClientUserName = MainForm.CurrentUser.UserName,
Content = groupSwitchDetailInfo.ToString(),
HappenTime = DateTime.Now,
OperateTypeId = (int)(OperateLogTypeId.GroupSwitchDetailDelete),
OperateTypeName = OperateLogTypeName.GroupSwitchDetailDelete,
OperateUserName = MainForm.CurrentUser.UserName
});
_lastSelectedGroupSwitchGroupTreeNode = _lastSelectedGroupSwitchGroupTreeNode.PrevNode ??
_lastSelectedGroupSwitchGroupTreeNode.Parent;
}
LoadGroupSwitch();
}
