private void SetVariables()
{
//mVariables = new Dictionary<string, PXSqlVariable>();
mVariables = new PXSqlVariables(this);
mVariablesClassification = new PXSqlVariablesClassification();
// Get all the variables connected to the selected maintable
foreach (MainTableVariableRow aTVRow in mMetaQuery.GetMainTableVariableRows(mMainTableId))
{
if (aTVRow.VariableType == mConfig.Codes.VariableTypeT)
{
mTimeVariable = new PXSqlVariableTime(aTVRow, this);
mSqlVariable = mTimeVariable;
mVariables.Add(mSqlVariable.Name, mSqlVariable);
}
else
{ // Should be changed so that variabletype is set separate.
if (!mVariables.ContainsKey(aTVRow.Variable))
{
mSqlVariable = new PXSqlVariableClassification(aTVRow, this);
mVariablesClassification.Add(mSqlVariable.Name, (PXSqlVariableClassification)mSqlVariable);
mVariables.Add(mSqlVariable.Name, mSqlVariable);
}
}
mSqlVariable.VariableType = aTVRow.VariableType;
}
}
public int CompareTo(object obj)
{
//if (this.GetType() != obj.GetType())
//{
// throw new PCAxis.Sql.Exceptions.BugException(10000);
//}
//else
{
PXSqlVariable SqlVariableCompare = (PXSqlVariable)obj;
return(this.Index.CompareTo(SqlVariableCompare.Index)); //will not compare time-,classification and contens
// return ((PXSqlVariable)this).Index.CompareTo(SqlVariableCompare.Index);
/*if (this.Index == sqlVariableCompare.Index)
* {
* return(0);
* }
* else if(this.Index > sqlVariableCompare.Index)
* {
* return(1);
* }
* else if (this.Index < sqlVariableCompare.Index)
* {
* return(-1);
* }
* else
* {
* return(-1);
* }
*/
}
}
private List <PXSqlValue> GetValuesForParsingWhenSelection()
{
PXSqlVariable var = variable;
List <PXSqlValue> tempValuesList = new List <PXSqlValue>();
if (this.isHierarchy)
{
tempValuesList = GetHierarchicalValues(rootGroup, tempValuesList);
}
else
{
if (this.mIncludeType == GroupingIncludesType.AggregatedValues)
{
foreach (PXSqlGroup group in this.mGroups)
{
tempValuesList.Add(var.Values[group.ParentCode]); //todo; sortert etter gruppe sorteringskode
}
}
else if (this.mIncludeType == GroupingIncludesType.SingleValues)
{
foreach (PXSqlGroup group in this.mGroups)
{
foreach (string childCode in group.ChildCodes)
{
tempValuesList.Add(var.Values[childCode]); //todo; sortert etter gruppe sorteringskode
}
}
}
else if (this.IncludeType == GroupingIncludesType.All)
{
foreach (PXSqlGroup group in this.mGroups)
{
tempValuesList.Add(var.Values[group.ParentCode]); //todo; sortert etter gruppe sorteringskode
foreach (string childCode in group.ChildCodes)
{
tempValuesList.Add(var.Values[childCode]); //todo; sortert etter gruppe sorteringskode
}
}
}
//tempValuesList.Sort(PXSqlValue.SortByVsValue());
//TODO; Hvorfor hadde Linja under en if ( this.meta.MetaQuery.metaVersionLE("2.1")) { rundt seg
tempValuesList.Sort(PXSqlValue.SortByValue());
}
return(tempValuesList);
}
private void SetContents()
{
BasicValueType[] contentsInPxs = new BasicValueType[0];
if (this.ConstructedFromPxs)
{
contentsInPxs = mPxsFile.Query.Contents.Content;
}
List <PXSqlContent> mTempContentsList = GetSortedContentsList(mMainTableId, this.ConstructedFromPxs, contentsInPxs);
mFirstContents = mTempContentsList[0].Contents;
this.mContents = new Dictionary <string, PXSqlContent>();
foreach (PXSqlContent sortedCont in mTempContentsList)
{
sortedCont.AdjustPresDecimalsToCommonDecimals(this.mDecimalHandler.ShowDecimals);
mContents.Add(sortedCont.Contents, sortedCont);
}
PxSqlValues mValues = new PxSqlValues();
int counter = 0;
foreach (PXSqlContent content in mContents.Values)
{
mValue = new PXSqlValue(content, counter);
mValues.Add(mValue.ValueCode, mValue);
counter++;
}
mSqlVariable = new PXSqlVariableContents(mContVariableCode, this);
mSqlVariable.Values = mValues;
mVariables.Add(mSqlVariable.Name, mSqlVariable);
mContentsVariable = mSqlVariable;
}
public int CompareTo(object obj)
{
PXSqlVariable SqlVariableCompare = (PXSqlVariable)obj;
// return this.Index.CompareTo(SqlVariableCompare.Index); //will not compare time-,classification and contens
if (this.Index == SqlVariableCompare.Index)
{
return(0);
}
else if (this.Index > SqlVariableCompare.Index)
{
return(1);
}
else if (this.Index < SqlVariableCompare.Index)
{
return(-1);
}
else
{
return(-1);
}
}
