private void AppendProgSwitchNode(TreeNode aNode)
{
string[] str = aNode.Tag.ToString().Split(';');
int key = int.Parse(str[0]);
ProgSwitchInfo groupSwitchGroup = _listProgSwitch[key];
if (groupSwitchGroup.ListProgSwitchDetailInfo == null)
{
return;
}
foreach (KeyValuePair <int, ProgSwitchDetailInfo> keyValuePair in groupSwitchGroup.ListProgSwitchDetailInfo)
{
var node = new TreeNode(keyValuePair.Value.DeviceName + "_" + keyValuePair.Value.CameraName + "_" + keyValuePair.Value.TickTime);
//P-程序切换群组ID
//C-摄像头ID
//D-Detail ID
//T-TickYime
node.Tag = keyValuePair.Key + ";D;" + key + ";P;" + keyValuePair.Value.CameraId + ";C;" + keyValuePair.Value.TickTime + ";T";
if (_lastSelectedProgSwitchTreeNode != null)
{
if (_lastSelectedProgSwitchTreeNode.Tag.ToString() == node.Tag.ToString())
{
node.BackColor = Color.Gray;
_lastSelectedProgSwitchTreeNode = node;
}
}
aNode.Nodes.Add(node);
}
}
public static int Insert(Database db, ProgSwitchInfo progSwitchInfo)
{
StringBuilder sbField = new StringBuilder();
StringBuilder sbValue = new StringBuilder();
sbField.Append("INSERT INTO ProgSwitch(");
sbValue.Append("values(");
sbField.Append("Name");
sbValue.AppendFormat("'{0}'", progSwitchInfo.Name);
sbField.Append(",Description");
sbValue.AppendFormat(",'{0}'", progSwitchInfo.Description);
sbField.Append(",DisplayChannelId");
sbValue.AppendFormat(",{0}", progSwitchInfo.DisplayChannelId);
sbField.Append(",DisplaySplitScreenNo)");
sbValue.AppendFormat(",{0})", progSwitchInfo.DisplaySplitScreenNo);
string cmdText = sbField.ToString() + " " + sbValue.ToString() + "";
try
{
return(db.ExecuteNonQuery(CommandType.Text, cmdText));
}
catch (Exception ex)
{
throw ex;
}
}
public ProgSwitchInfo GetProgSwitchById(ref string errMessage, int progSwitchId)
{
Database db = DatabaseFactory.CreateDatabase();
errMessage = "";
try
{
DataSet ds = ProgSwitchDataAccess.GetProgSwitchById(db, progSwitchId);
if (ds.Tables[0].Rows.Count == 0)
{
return(null);
}
var progSwitchInfo = new ProgSwitchInfo(ds.Tables[0].Rows[0])
{
ListProgSwitchDetailInfo = new Dictionary <int, ProgSwitchDetailInfo>()
};
var progSwitchDetail = ProgSwitchDetailDataAccess.GetProgSwitchDetailByProgSwitchId(db, progSwitchInfo.Id);
progSwitchInfo.ListProgSwitchDetailInfo = new Dictionary <int, ProgSwitchDetailInfo>();
//对于一个程序切换中的所有与程序切换有联系的记录
foreach (DataRow drpsd in progSwitchDetail.Tables[0].Rows)
{
var progSwitchDetailInfo = new ProgSwitchDetailInfo(drpsd);
progSwitchInfo.ListProgSwitchDetailInfo.Add(progSwitchDetailInfo.ProgSwitchDetailId, progSwitchDetailInfo);
}
return(progSwitchInfo);
}
catch (Exception ex)
{
errMessage = ex.Message + ex.StackTrace;
Logger.Error("Error Message:" + ex.Message + " Trace:" + ex.StackTrace);
return(null);
}
}
private void btnOK_Click(object sender, EventArgs e)
{
ProgSwitchInfo progSwitchInfo = new ProgSwitchInfo();
if (txtName.Text.Trim() == "" || comboBoxEditDisplayChannel.Text.Trim() == "" || comboBoxEditDisplaySplitScreenNo.Text.Trim() == "")
{
return;
}
progSwitchInfo.Name = txtName.Text;
progSwitchInfo.Description = txtDescription.Text;
progSwitchInfo.DisplayChannelId = _listMonitorByName[comboBoxEditDisplayChannel.Text].DisplayChannelId;
progSwitchInfo.DisplaySplitScreenNo = int.Parse(comboBoxEditDisplaySplitScreenNo.Text) - 1;
errMessage = "";
switch (Opt)
{
case Util.Operateion.Add:
GroupId = ProgSwitchBusiness.Instance.Insert(ref errMessage, progSwitchInfo);
OperateLogBusiness.Instance.Insert(ref errMessage, new OperateLog
{
HappenTime = DateTime.Now,
ClientUserId = MainForm.CurrentUser.UserId,
ClientUserName = MainForm.CurrentUser.UserName,
Content = progSwitchInfo.ToString(),
OperateTypeId = (int)OperateLogTypeId.ProgSwitchAdd,
OperateTypeName = OperateLogTypeName.ProgSwitchAdd,
OperateUserName = MainForm.CurrentUser.UserName
});
break;
case Util.Operateion.Update:
//ogroup.GroupID = GeroupId;
GroupId = ProgSwitchBusiness.Instance.Update(ref errMessage, progSwitchInfo);
OperateLogBusiness.Instance.Insert(ref errMessage, new OperateLog
{
HappenTime = DateTime.Now,
ClientUserId = MainForm.CurrentUser.UserId,
ClientUserName = MainForm.CurrentUser.UserName,
Content = progSwitchInfo.ToString(),
OperateTypeId = (int)OperateLogTypeId.GroupSwitchUpdate,
OperateTypeName = OperateLogTypeName.GroupSwitchUpdate,
OperateUserName = MainForm.CurrentUser.UserName
});
break;
case Util.Operateion.Delete:
break;
default:
break;
}
if (errMessage.Length == 0)
{
this.Close();
}
}
private void btnOK_Click(object sender, EventArgs e)
{
ProgSwitchInfo progSwitchInfo = new ProgSwitchInfo();
progSwitchInfo.Name = txtName.Text;
progSwitchInfo.Description = txtDescription.Text;
errMessage = "";
switch (Opt)
{
case Util.Operateion.Add:
GroupId = ProgSwitchBusiness.Instance.Insert(ref errMessage, progSwitchInfo);
OperateLogBusiness.Instance.Insert(ref errMessage, new OperateLog
{
HappenTime = DateTime.Now,
ClientUserId = MainForm.CurrentUser.UserId,
ClientUserName = MainForm.CurrentUser.UserName,
Content = progSwitchInfo.ToString(),
OperateTypeId = (int)OperateLogTypeId.ProgSwitchAdd,
OperateTypeName = OperateLogTypeName.ProgSwitchAdd,
OperateUserName = MainForm.CurrentUser.UserName
});
break;
case Util.Operateion.Update:
//ogroup.GroupID = GeroupId;
GroupId = ProgSwitchBusiness.Instance.Update(ref errMessage, progSwitchInfo);
OperateLogBusiness.Instance.Insert(ref errMessage, new OperateLog
{
HappenTime = DateTime.Now,
ClientUserId = MainForm.CurrentUser.UserId,
ClientUserName = MainForm.CurrentUser.UserName,
Content = progSwitchInfo.ToString(),
OperateTypeId = (int)OperateLogTypeId.ProgSwitchUpdate,
OperateTypeName = OperateLogTypeName.ProgSwitchUpdate,
OperateUserName = MainForm.CurrentUser.UserName
});
break;
case Util.Operateion.Delete:
break;
default:
break;
}
if (errMessage.Length == 0)
{
this.Close();
}
}
public int Update(ref string errMessage, ProgSwitchInfo progSwitchInfo)
{
Database db = DatabaseFactory.CreateDatabase();
errMessage = "";
try
{
return(ProgSwitchDataAccess.Update(db, progSwitchInfo));
}
catch (Exception ex)
{
errMessage = ex.Message + ex.StackTrace;
Logger.Error("Error Message:" + ex.Message + " Trace:" + ex.StackTrace);
return(-1);
}
}
private void DisplayProgSwitchDetail()
{
dgvProgSwitchDetail.Rows.Clear();
lblProgSwitchName.Text = "";
if (_lastSelectedProgSwitchTreeNode == null)
{
return;
}
string str = _lastSelectedProgSwitchTreeNode.Tag.ToString();
if (str.IndexOf("D") < 0)
{
string[] strs = str.Split(';');
int psID = int.Parse(strs[0]);
ProgSwitchInfo progSwitchInfo = _listProgSwitch[psID];
lblProgSwitchName.Text = progSwitchInfo.Name;
foreach (KeyValuePair <int, ProgSwitchDetailInfo> keyValuePair in progSwitchInfo.ListProgSwitchDetailInfo)
{
int index = dgvProgSwitchDetail.Rows.Add();
DataGridViewRow dgvr = dgvProgSwitchDetail.Rows[index];
dgvr.Cells["ProgSwitchDevice"].Value = keyValuePair.Value.DeviceName;
dgvr.Cells["ProgSwitchCamera"].Value = keyValuePair.Value.CameraName;
dgvr.Cells["ProgSwitchMonitor"].Value = progSwitchInfo.DisplayChannelName;
dgvr.Cells["ProgSwitchTick"].Value = keyValuePair.Value.TickTime;
dgvr.Cells["ProgSwitchDetailId"].Value = keyValuePair.Key;
dgvr.Cells["ProgSwitchDisplaySplitScreenNo"].Value = progSwitchInfo.DisplaySplitScreenNo;
}
}
else if (str.IndexOf("D") >= 0)
{
string[] strs = str.Split(';');
int psID = int.Parse(strs[2]);
ProgSwitchInfo progSwitchInfo = _listProgSwitch[psID];
lblProgSwitchName.Text = progSwitchInfo.Name;
int detailId = int.Parse(strs[0]);
ProgSwitchDetailInfo progSwitchDetailInfo = progSwitchInfo.ListProgSwitchDetailInfo[detailId];
int index = dgvProgSwitchDetail.Rows.Add();
DataGridViewRow dgvr = dgvProgSwitchDetail.Rows[index];
dgvr.Cells["ProgSwitchDevice"].Value = progSwitchDetailInfo.DeviceName;
dgvr.Cells["ProgSwitchCamera"].Value = progSwitchDetailInfo.CameraName;
dgvr.Cells["ProgSwitchMonitor"].Value = progSwitchInfo.DisplayChannelName;
dgvr.Cells["ProgSwitchTick"].Value = progSwitchDetailInfo.TickTime;
dgvr.Cells["ProgSwitchDetailId"].Value = progSwitchDetailInfo.ProgSwitchDetailId;
dgvr.Cells["ProgSwitchDisplaySplitScreenNo"].Value = progSwitchInfo.DisplaySplitScreenNo;
}
}
public static int Update(Database db, ProgSwitchInfo progSwitchInfo)
{
StringBuilder sb = new StringBuilder();
sb.Append("update ProgSwitch set");
sb.AppendFormat(" Name='{0}'", progSwitchInfo.Name);
sb.AppendFormat(",Description='{0}'", progSwitchInfo.Description);
sb.AppendFormat(",DisplaySplitScreenNo={0}", progSwitchInfo.DisplaySplitScreenNo);
sb.AppendFormat(",DisplayChannelId={0} ", progSwitchInfo.DisplayChannelId);
sb.AppendFormat(" where ID={0})", progSwitchInfo.Id);
string cmdText = sb.ToString();
try
{
return(db.ExecuteNonQuery(CommandType.Text, cmdText));
}
catch (Exception ex)
{
throw ex;
}
}
public Dictionary <int, ProgSwitchInfo> GetAllProgSwitchs(ref string errMessage)
{
Database db = DatabaseFactory.CreateDatabase();
errMessage = "";
var list = new Dictionary <int, ProgSwitchInfo>();
try
{
ProgSwitchInfo progSwitchInfo;
DataSet ds = ProgSwitchDataAccess.GetAllProgSwitchInfo(db);
DataSet dsProgSwitchDetail;
ProgSwitchDetailInfo progSwitchDetailInfo;
//对于每一个程序切换
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
progSwitchInfo = new ProgSwitchInfo(ds.Tables[0].Rows[i]);
dsProgSwitchDetail = ProgSwitchDetailDataAccess.GetProgSwitchDetailByProgSwitchId(db, progSwitchInfo.Id);
progSwitchInfo.ListProgSwitchDetailInfo = new Dictionary <int, ProgSwitchDetailInfo>();
//对于一个程序切换中的所有与程序切换有联系的记录
foreach (DataRow drpsd in dsProgSwitchDetail.Tables[0].Rows)
{
progSwitchDetailInfo = new ProgSwitchDetailInfo(drpsd);
progSwitchInfo.ListProgSwitchDetailInfo.Add(progSwitchDetailInfo.ProgSwitchDetailId, progSwitchDetailInfo);
}
list.Add(progSwitchInfo.Id, progSwitchInfo);
}
return(list);
}
catch (Exception ex)
{
errMessage = ex.Message + ex.StackTrace;
Logger.Error("Error Message:" + ex.Message + " Trace:" + ex.StackTrace);
return(null);
}
}
private void btnDeleteProgSwitchDetail_Click(object sender, EventArgs e)
{
if (_lastSelectedProgSwitchTreeNode == null)
{
return;
}
string selectTagStr = _lastSelectedProgSwitchTreeNode.Tag.ToString();
if (selectTagStr.IndexOf("D") < 0)
{
if (_lastSelectedProgSwitchTreeNode.FirstNode != null)
{
XtraMessageBox.Show("程序切换非空，不能直接删除!");
}
else
{
string[] strs = selectTagStr.Split(';');
int progSwitchId = int.Parse(strs[0]);
_lastSelectedProgSwitchTreeNode = tvProgSwitch.SelectedNode.PrevNode;
ProgSwitchInfo progSwitchInfo = ProgSwitchBusiness.Instance.GetProgSwitchById(ref errMessage,
progSwitchId);
ProgSwitchBusiness.Instance.Delete(ref errMessage, progSwitchId);
OperateLogBusiness.Instance.Insert(ref errMessage,
new OperateLog
{
ClientUserId = MainForm.CurrentUser.UserId,
ClientUserName = MainForm.CurrentUser.UserName,
Content = progSwitchInfo.ToString(),
HappenTime = DateTime.Now,
OperateTypeId = (int)(OperateLogTypeId.ProgSwitchDelete),
OperateTypeName = OperateLogTypeName.ProgSwitchDelete,
OperateUserName = MainForm.CurrentUser.UserName
});
}
}
else
{
string[] tagStrs = selectTagStr.Split(';');
int detailId = int.Parse(tagStrs[0]);
ProgSwitchDetailInfo progSwitchDetailInfo =
ProgSwitchDetailBusiness.Instance.GetProgSwitchDetailByDetailId(ref errMessage, detailId);
ProgSwitchDetailBusiness.Instance.DeleteProgSwitchDetailById(ref errMessage, detailId);
OperateLogBusiness.Instance.Insert(ref errMessage,
new OperateLog
{
ClientUserId = MainForm.CurrentUser.UserId,
ClientUserName = MainForm.CurrentUser.UserName,
Content = progSwitchDetailInfo.ToString(),
HappenTime = DateTime.Now,
OperateTypeId = (int)(OperateLogTypeId.ProgSwitchGroupDelete),
OperateTypeName = OperateLogTypeName.ProgSwitchDetailDelete,
OperateUserName = MainForm.CurrentUser.UserName
});
_lastSelectedProgSwitchTreeNode = _lastSelectedProgSwitchTreeNode.PrevNode ??
_lastSelectedProgSwitchTreeNode.Parent;
}
LoadProgSwitch();
}
