public void RefreshViewName()
{
CachedViewNames.Clear();
if( SelectedViewIds.Count > 0 )
{
if( SelectMode != CswEnumNbtPropertySelectMode.Multiple && CswConvert.ToInt32( SelectedViewIds[0] ) > 0 )
{
CswNbtView ThisView = _CswNbtResources.ViewSelect.restoreView( new CswNbtViewId( CswConvert.ToInt32( SelectedViewIds[0] ) ) );
if( null != ThisView )
{
CachedViewNames.Add( ThisView.ViewName );
}
}
else
{
Collection<Int32> SelectedViewIdCollection = SelectedViewIds.ToIntCollection();
foreach( Int32 ViewId in SelectedViewIdCollection )
{
CswNbtView ThisView = _CswNbtResources.ViewSelect.restoreView( new CswNbtViewId( ViewId ) );
if( null != ThisView )
{
CachedViewNames.Add( ThisView.ViewName );
}
} // foreach( Int32 ViewId in SelectedViewIdCollection )
}
} // if( SelectedViewIds.Count > 0 )
this.PendingUpdate = false;
} // RefreshViewName()
/// <summary>
/// Assumes the _MasterSchemaResources is initialized
/// </summary>
/// <returns></returns>
private string _getMasterSessionIdsWhere()
{
string ret = "";
bool first = true;
CswTableSelect SessionListIdsTS = _MasterSchemaResources.makeCswTableSelect("get_all_session_ids", "sessionlist");
DataTable RemainingSessionListIdsDT = SessionListIdsTS.getTable(new CswCommaDelimitedString {
"sessionid"
});
CswCommaDelimitedString SessionListIds = new CswCommaDelimitedString(0, "'");
foreach (DataRow Row in RemainingSessionListIdsDT.Rows)
{
if (SessionListIds.Count == 999) //can't have more than 1000 literals in an "in" clause"
{
if (first)
{
ret = " where sessionid not in (" + SessionListIds.ToString() + ") ";
first = false;
}
else
{
ret += " and sessionid not in (" + SessionListIds.ToString() + ") ";
}
SessionListIds.Clear();
}
SessionListIds.Add(Row["sessionid"].ToString());
}
if (SessionListIds.Count > 0) //if we never reached the max in the latest iteration
{
if (first) //if we never reached the max period
{
ret = " where sessionid not in (" + SessionListIds.ToString() + ") ";
}
else //if we never reached the max on any iteration other than the first
{
ret += " and sessionid not in (" + SessionListIds.ToString() + ") ";
}
}
return(ret);
}
