public Dictionary <int, DisplayChannelInfo> GetAllDisplayChannelInfo(ref string errMessage)
{
Database db = DatabaseFactory.CreateDatabase();
errMessage = "";
Dictionary <int, DisplayChannelInfo> list = new Dictionary <int, DisplayChannelInfo>();
try
{
DisplayChannelInfo displayChannelInfo;
DataSet ds = DisplayChannelDataAccess.GetAllDisplayChannelInfos(db);
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
displayChannelInfo = new DisplayChannelInfo(ds.Tables[0].Rows[i]);
list.Add(displayChannelInfo.DisplayChannelId, displayChannelInfo);
}
return(list);
}
catch (Exception ex)
{
errMessage = ex.Message + ex.StackTrace;
logger.Error("Error Message:" + ex.Message + " Trace:" + ex.StackTrace);
return(null);
}
}
public static int Insert(Database db, DisplayChannelInfo displayChannelInfo)
{
StringBuilder sbField = new StringBuilder();
StringBuilder sbValue = new StringBuilder();
sbField.Append("INSERT INTO DisplayChannelInfo(");
sbValue.Append("values(");
sbField.Append("DisplayChannelName,");
sbValue.AppendFormat("'{0}',", displayChannelInfo.DisplayChannelName);
sbField.Append("DecodeCardNo,");
sbValue.AppendFormat("{0},", displayChannelInfo.DecodeCardNo);
sbField.Append("DispalyChannelNoInCurrentCard,");
sbValue.AppendFormat("{0},", displayChannelInfo.DispalyChannelNoInCurrentCard);
sbField.Append("SplitScreenNo) ");
sbValue.AppendFormat("{0})", displayChannelInfo.SplitScreenNo);
string cmdText = sbField.ToString() + " " + sbValue.ToString() + "";
try
{
return(db.ExecuteNonQuery(CommandType.Text, cmdText));
}
catch (Exception ex)
{
throw ex;
}
}
public int Update(ref string errMessage, DisplayChannelInfo displayChannelInfo)
{
Database db = DatabaseFactory.CreateDatabase();
errMessage = "";
try
{
return(DisplayChannelDataAccess.Update(db, displayChannelInfo));
}
catch (Exception ex)
{
errMessage = ex.Message + ex.StackTrace;
logger.Error("Error Message:" + ex.Message + " Trace:" + ex.StackTrace);
return(-1);
}
}
public static int Update(Database db, DisplayChannelInfo displayChannelInfo)
{
StringBuilder sb = new StringBuilder();
sb.Append("update displayChannelInfo set");
sb.AppendFormat(" DisplayChannelName='{0}'", displayChannelInfo.DisplayChannelName);
sb.AppendFormat(" where DisplayChannelId={0})", displayChannelInfo.DisplayChannelId);
string cmdText = sb.ToString();
try
{
return(db.ExecuteNonQuery(CommandType.Text, cmdText));
}
catch (Exception ex)
{
throw ex;
}
}
private void buttonAddSynGroup_Click(object sender, EventArgs e)
{
if (treeViewSynGroupCamera.SelectedNode == null)
{
return;
}
if (treeViewSynGroup.SelectedNode == null)
{
return;
}
if (treeViewMonitor.SelectedNode == null)
{
return;
}
if (cbDisplayScreenNo.Text == "")
{
XtraMessageBox.Show("请正确选择输出通道!");
return;
}
alCameras.Clear();
getCameras(treeViewSynGroupCamera.SelectedNode);
int synGroupToAdd = getSynGroupId(treeViewSynGroup.SelectedNode);
alDisplayChannels.Clear();
getDisplayChannels(treeViewMonitor.SelectedNode);
int splitScreenNo = int.Parse(cbDisplayScreenNo.Text) - 1;
foreach (int camid in alCameras)
{
foreach (int dc in alDisplayChannels)
{
int addId = addCamera2SynGroup(synGroupToAdd, camid, dc, splitScreenNo);
if (addId == -1)
{
CameraInfo ci = CameraBusiness.Instance.GetCameraInfoByCameraId(ref errMessage, camid);
SynGroup sg = SynGroupBusiness.Instance.GetSynGroupBySynGroupId(ref errMessage, synGroupToAdd);
DisplayChannelInfo mi = DisplayChannelBusiness.Instance.GetDisplayChannelInfoById(ref errMessage, dc);
XtraMessageBox.Show(ci.DeviceName + "_" + ci.Name + "_" + mi.DisplayChannelName + " 在 " + sg.Name + " 组中已存在!");
}
}
}
BuildSynGroupTree();
DisplaySynGroupDetail();
}
