// public PXSqlVariableClassification() { }
public PXSqlVariableClassification(MainTableVariableRow aTVRow, PXSqlMeta_22 meta)
: base(aTVRow.Variable, meta, false, false, true)
{
if (this.meta.ConstructedFromPxs)
{
foreach (PQVariable tmpVar in this.meta.PxsFile.Query.Variables)
{
if (this.Name == tmpVar.code)
{
this.pxsQueryVariable = tmpVar;
}
}
}
SetSelected();
if (this.isSelected)
{
this.mStoreColumnNo = int.Parse(aTVRow.StoreColumnNo);
if (!this.meta.ConstructedFromPxs)
{
this.mIndex = this.mStoreColumnNo;
}
SetValueset();
SetValuePool();
SetPresText();
SetDefaultPresTextOption(); // would be overwritten if options set in pxs
if (this.meta.ConstructedFromPxs)
{
SetOptionsFromPxs();
}
if (this.meta.inSelectionModus)
{
this.groupingInfos = new PXSqlGroupingInfos(this.meta, this.Name, valusetIds);
}
}
else
{
SetValueset();
}
// Elimination must be done after SetValues moved down.
// if (this.meta.InstanceModus == Instancemodus.selection)
// SetElimForSelection();
// else
// SetElimForPresentation();
if (this.aggregationType.Equals("G"))
{
if (String.IsNullOrEmpty(this.aggregatingStructureId))
{
throw new ApplicationException("Not implemented yet");
}
else if (this.aggregatingStructureId.Equals("UNKNOWNSTRUCTUREID"))
{
List <PXSqlGroup> groupFromFile = GetListOfGroupFromPxs();
currentGrouping = new PXSqlGrouping(this.meta, this, groupFromFile);
}
else
{
currentGrouping = new PXSqlGrouping(this.metaQuery.GetGroupingRow(this.aggregatingStructureId), this.meta, this, this.pxsQueryVariable.GetCodesNoWildcards());
}
}
else
{
SetValues();
SetCodelists();
}
if (this.meta.inSelectionModus)
{
SetElimForSelection();
}
else
{
SetElimForPresentation();
}
}
//when pxs
internal void SetValues(StringCollection selSubTables, PQVariable var)
{
log.Debug("PQVariable code = " + var.code);
StringCollection mSelectedValues = new StringCollection();
// Defines a dictionary to hold all the sortorders. Necessary because of the wildcards
Dictionary <string, int> mDefinedSortorder = new Dictionary <string, int>();
DataSet mValueInfoTbl;
DataRowCollection mValueInfo;
string mPxsSubTableId = meta.PxsFile.Query.SubTable;
#region foreach var.Values.Items
if (var.Values.Items.Length > 0)
{
int documentOrder = 0;
foreach (PCAxis.Sql.Pxs.ValueTypeWithGroup val in var.Values.Items)
{
if (val.Group != null)
{
//currentGrouping = ...
//TODO; PXSqlVariableClassification, SetValues: group not implemented yet"
throw new NotImplementedException("PXSqlVariableClassification, SetValues: group not implemented yet");
}
if (val.code.Contains("*") || val.code.Contains("?"))
{
if (mPxsSubTableId == null)
{
mValueInfoTbl = meta.MetaQuery.GetValueWildCardBySubTable(meta.MainTable.MainTable, var.code, null, val.code);
}
else
{
mValueInfoTbl = meta.MetaQuery.GetValueWildCardBySubTable(meta.MainTable.MainTable, var.code, mPxsSubTableId, val.code);
}
mValueInfo = mValueInfoTbl.Tables[0].Rows;
foreach (DataRow row in mValueInfo)
{
string mTempCode = row[meta.MetaQuery.DB.Value.ValueCodeCol.PureColumnName()].ToString();
mSelectedValues.Add(mTempCode);
if (!mDefinedSortorder.ContainsKey(mTempCode))
{
mDefinedSortorder.Add(mTempCode, documentOrder);
}
documentOrder++;
}
}
else
{
mSelectedValues.Add(val.code);
if (!mDefinedSortorder.ContainsKey(val.code))
{
mDefinedSortorder.Add(val.code, documentOrder);
}
}
documentOrder++;
}
#endregion foreach var.Values.Items
// mSelectedValues now contains all the selected values, including those defined by wildcards
Dictionary <string, PXSqlValue> mTempPXSqlValues = new Dictionary <string, PXSqlValue>();
List <PXSqlValue> mSortedValues = new List <PXSqlValue>();
ValueRowDictionary mValueRowDictionary = meta.MetaQuery.GetValueRowDictionary(meta.MainTable.MainTable, selSubTables, var.code, mSelectedValues, this.ValuePool.ValueTextExists);
//todo; fortsette her
Dictionary <string, ValueRow2> mValueRows = mValueRowDictionary.ValueRows;
#region foreach mValueRows
foreach (ValueRow2 myValueRow in mValueRows.Values)
{
PXSqlValue mValue = new PXSqlValue(myValueRow, meta.LanguageCodes, meta.MainLanguageCode);
// jfi: kommentaren sto i en kodeblock som forsvant inn i PXSqlValue
// todo; legge til sjekk om koden finnes blandt valgte i basen.
mValue.SortCodePxs = mDefinedSortorder[myValueRow.ValueCode];
mSortedValues.Add(mValue);
}
#endregion foreach mValueRows
mValues = new PxSqlValues();
foreach (PXSqlValue sortedValue in mSortedValues)
{
mValues.Add(sortedValue.ValueCode, sortedValue);
}
this.Values = mValues;
}
}
