/// <summary>
/// 单击预设位标签时调用
/// 显示选中预设位的信息
/// </summary>
/// <param name="go">Go.</param>
void OnPresetPosItemSelected(GameObject go)
{
Logger.Instance.WriteLog("显示选中预设位的信息");
go.GetComponent <UIButton> ().normalSprite = go.GetComponent <UIButton> ().pressedSprite;
if (SelectedPresetPosInfo.Id == PresetPosInfos [PresetPosItems.IndexOf(go)].Id)
{
return;
}
foreach (GameObject item in PresetPosItems)
{
if (item != go)
{
item.GetComponent <UIButton> ().normalSprite = defaultSprite;
}
}
SelectedPresetPosInfo = PresetPosInfos [PresetPosItems.IndexOf(go)];
Description.value = SelectedPresetPosInfo.DESCRIPTION;
CMSManageInstance.GotoPresetPosition(cameraId, guid, ushort.Parse(SelectedPresetPosInfo.Name));
}
/// <summary>
/// 检索出所有的 name 小于 name + 1，
/// 而且name + 1 的记录不存在的所有记录，并按升序排列
/// </summary>
public void Select002()
{
Result = new List <PrestPositionInfo> ();
string sql = "select t.ID,t.DEVICEID,t.NAME,t.DESCRIPTION,t.KEEPWATCH from CYGJ_PRESET_POSITION t where not exists(select t.* from CYGJ_PRESET_POSITION t2 where t2.name = t.name + 1) order by t.name asc";
DataSet ds = OdbcDataManager.Instance.odbcOra.ReturnDataSet(sql, "CYGJ_PRESET_POSITION");
if (ds.Tables.Count > 0)
{
DataTable dt = ds.Tables[0];
foreach (DataRow dr in dt.Rows)
{
PrestPositionInfo info = new PrestPositionInfo();
info.Id = dr["ID"].ToString();
info.DeviceId = dr["DEVICEID"].ToString();
info.Name = dr["NAME"].ToString();
info.DESCRIPTION = dr["DESCRIPTION"].ToString();
info.IsKeepWatch = dr["KEEPWATCH"].ToString();
Result.Add(info);
}
}
Logger.Instance.WriteLog("检索出所有的 name 小于 name + 1 的预设位信息。检索件数：" + Result.Count);
}
/// <summary>
/// 根据设备Id检索相关的预设位信息
/// </summary>
/// <param name="DeviceId">Device identifier.</param>
public void Select001(string DeviceId)
{
Result = new List <PrestPositionInfo> ();
string sql = "select ID,DEVICEID,NAME,DESCRIPTION,KEEPWATCH from CYGJ_PRESET_POSITION where DEVICEID = '" + DeviceId + "' order by ID asc";
DataSet ds = OdbcDataManager.Instance.odbcOra.ReturnDataSet(sql, "CYGJ_PRESET_POSITION");
if (ds.Tables.Count > 0)
{
DataTable dt = ds.Tables[0];
foreach (DataRow dr in dt.Rows)
{
PrestPositionInfo info = new PrestPositionInfo();
info.Id = dr["ID"].ToString();
info.DeviceId = dr["DEVICEID"].ToString();
info.Name = dr["NAME"].ToString();
info.DESCRIPTION = dr["DESCRIPTION"].ToString();
info.IsKeepWatch = dr["KEEPWATCH"].ToString();
Result.Add(info);
}
}
Logger.Instance.WriteLog("根据设备Id检索相关的预设位信息。检索件数：" + Result.Count + ",检索条件：DEVICEID = " + DeviceId);
}
