protected QSqlSelectMaker CreateLastSelect(int TagLevel, QField field, QField exField, bool bFinalStep) { QSqlSelectMaker retVal = null; string strTag = TagLevel.ToString(); string strParent = TagLevel == 1?"NULL":(TagLevel - 1).ToString(); retVal = new QSqlSelectMaker(strTag, strParent, this.OwnerObject.OwnerTable, this.TimeOffset, this.Language); AddLastFieldToSelect(retVal, field, exField, bFinalStep); // Add Filter [4/20/2004] //if(bFinalStep) { foreach (FilterCondition filter in this.Filters) { retVal.AddFilter(filter); } } // Where Extension Addon [4/30/2004] if (this.OwnerObject.GetWhereExtensions() != null) { foreach (FilterCondition exFilter in this.OwnerObject.GetWhereExtensions()) { retVal.AddFilter(exFilter); } } // end [4/30/2004] return(retVal); }
protected QSqlSelectMaker CreateGroupSelect(QField group) { QSqlSelectMaker retVal = null; // Create Root [4/21/2004] string GroupOwnerTable = group.Relations == null?this.OwnerObject.OwnerTable:group.Relations[group.Relations.Length - 1].DestTable; string strTag = CurrentStepTagLevel.ToString(); string strParent = CurrentStepTagLevel == 1?"NULL":(CurrentStepTagLevel - 1).ToString(); retVal = new QSqlSelectMaker(strTag, strParent, GroupOwnerTable, this.TimeOffset, this.Language, group.Relations == null); AddFieldToSelect(retVal); // Where Extension Addon [4/30/2004] if (this.OwnerObject.GetWhereExtensions() != null && GroupOwnerTable == this.OwnerObject.OwnerTable) { foreach (FilterCondition exFilter in this.OwnerObject.GetWhereExtensions()) { retVal.AddFilter(exFilter); } } // end [4/30/2004] // foreach(FilterCondition filter in this.Filters) // { // if(group==filter.OwnerField) // retVal.AddFilter(filter); // } return(retVal); }
protected QSqlSelectMaker CreateKeySelect() { QSqlSelectMaker retVal = null; string strTag = CurrentStepTagLevel.ToString(); string strParent = CurrentStepTagLevel == 1?"NULL":(CurrentStepTagLevel - 1).ToString(); retVal = new QSqlSelectMaker(strTag, strParent, this.OwnerObject.OwnerTable, this.TimeOffset, this.Language); AddItemKeyToSelect(retVal); // Add Filter [4/20/2004] foreach (FilterCondition filter in this.Filters) { retVal.AddFilter(filter); } // Where Extension Addon [4/30/2004] if (this.OwnerObject.GetWhereExtensions() != null) { foreach (FilterCondition exFilter in this.OwnerObject.GetWhereExtensions()) { retVal.AddFilter(exFilter); } } // end [4/30/2004] return(retVal); }
protected QSqlSelectMaker CreateRootSelect() { //Create Repoort Root QSqlSelectMaker retVal = null; // Create Root [4/21/2004] string strTag = CurrentStepTagLevel.ToString(); string strParent = CurrentStepTagLevel == 1?"NULL":(CurrentStepTagLevel - 1).ToString(); retVal = new QSqlSelectMaker(strTag, strParent, null, this.TimeOffset, this.Language); AddFieldToSelect(retVal); return(retVal); }
protected void AddItemKeyToSelect(QSqlSelectMaker select) { bool bShowAlias = false; // Add Root Static Field [4/21/2004] select.AddField(new QSqlSelectFieldMaker(new QField(_ReportName), false, bShowAlias?"Report!1!Name":null)); // Add Group Fields [4/20/2004] foreach (QField tmpGroupField in this.Groups) { // Step 1. Add Groups Item [4/21/2004] select.AddField(new QSqlSelectFieldMaker(new QField(tmpGroupField.FriendlyName), false, null)); select.AddField(new QSqlSelectFieldMaker(tmpGroupField, false, null)); select.AddField(new QSqlSelectFieldMaker(tmpGroupField.Relations == null?tmpGroupField:(new QField(tmpGroupField.Name, tmpGroupField.FriendlyName, tmpGroupField.FieldValueIsKey?tmpGroupField.DBName:tmpGroupField.Relations[tmpGroupField.Relations.Length - 1].DestKey, tmpGroupField.DataType, tmpGroupField.UsingType, tmpGroupField.Relations)), false, null)); } // Add Key Field [4/21/2004] if (this.OwnerObject.KeyField != null) { QField keyField = this.OwnerObject.KeyField; if (_KeyUniquePrefix != null) { keyField = new QField(this.OwnerObject.KeyField.Name, this.OwnerObject.KeyField.FriendlyName, "'" + _KeyUniquePrefix + "' + CONVERT(NVARCHAR(3000),{0}.[" + this.OwnerObject.KeyField.DBName + "],20)", this.OwnerObject.KeyField.DataType, this.OwnerObject.KeyField.UsingType, true); } select.AddField(new QSqlSelectFieldMaker(keyField, false, null)); } // [FieldName!Tag!Id] [4/22/2004] select.AddField(new QSqlSelectFieldMaker(null, true, null)); // [Field!Tag!Name] [4/22/2004] select.AddField(new QSqlSelectFieldMaker(null, true, null)); // [Field!Tag!Description] [4/22/2004] select.AddField(new QSqlSelectFieldMaker(null, true, null)); // [FieldName!Tag!Type] [4/22/2004] select.AddField(new QSqlSelectFieldMaker(null, true, null)); // [FieldName!Tag!DataType] [4/22/2004] select.AddField(new QSqlSelectFieldMaker(null, true, null)); // New Addon [4/22/2004] // [Values!Tag!Value] [4/22/2004] select.AddField(new QSqlSelectFieldMaker(null, true, null)); // End New Addon [4/22/2004] }
protected QSqlSelectMaker CreateGroupsSelect(QField group) { QSqlSelectMaker retVal = null; // Create Root [4/21/2004] string GroupOwnerTable = group.Relations == null?this.OwnerObject.OwnerTable:group.Relations[group.Relations.Length - 1].DestTable; string strTag = CurrentStepTagLevel.ToString(); string strParent = CurrentStepTagLevel == 1?"NULL":(CurrentStepTagLevel - 1).ToString(); retVal = new QSqlSelectMaker(strTag, strParent, GroupOwnerTable, this.TimeOffset, this.Language); AddFieldToSelect(retVal); return(retVal); }
protected QSqlSelectMaker CreateRootSelect() { //Create Repoort Root QSqlSelectMaker retVal = null; // Create Root [4/21/2004] string strTag = CurrentStepTagLevel.ToString(); string strParent = CurrentStepTagLevel==1?"NULL":(CurrentStepTagLevel-1).ToString(); retVal = new QSqlSelectMaker(strTag, strParent, null,this.TimeOffset,this.Language); AddFieldToSelect(retVal); return retVal; }
protected QSqlSelectMaker CreateLastSelect(int TagLevel, QField field, QField exField, bool bFinalStep) { QSqlSelectMaker retVal = null; string strTag = TagLevel.ToString(); string strParent = TagLevel==1?"NULL":(TagLevel-1).ToString(); retVal = new QSqlSelectMaker(strTag, strParent, this.OwnerObject.OwnerTable,this.TimeOffset,this.Language); AddLastFieldToSelect(retVal,field,exField,bFinalStep); // Add Filter [4/20/2004] //if(bFinalStep) { foreach(FilterCondition filter in this.Filters) { retVal.AddFilter(filter); } } // Where Extension Addon [4/30/2004] if(this.OwnerObject.GetWhereExtensions()!=null) { foreach(FilterCondition exFilter in this.OwnerObject.GetWhereExtensions()) { retVal.AddFilter(exFilter); } } // end [4/30/2004] return retVal; }
protected QSqlSelectMaker CreateKeySelect() { QSqlSelectMaker retVal = null; string strTag = CurrentStepTagLevel.ToString(); string strParent = CurrentStepTagLevel==1?"NULL":(CurrentStepTagLevel-1).ToString(); retVal = new QSqlSelectMaker(strTag, strParent, this.OwnerObject.OwnerTable,this.TimeOffset,this.Language); AddItemKeyToSelect(retVal); // Add Filter [4/20/2004] foreach(FilterCondition filter in this.Filters) { retVal.AddFilter(filter); } // Where Extension Addon [4/30/2004] if(this.OwnerObject.GetWhereExtensions()!=null) { foreach(FilterCondition exFilter in this.OwnerObject.GetWhereExtensions()) { retVal.AddFilter(exFilter); } } // end [4/30/2004] return retVal; }
protected QSqlSelectMaker CreateGroupsSelect(QField group) { QSqlSelectMaker retVal = null; // Create Root [4/21/2004] string GroupOwnerTable = group.Relations==null?this.OwnerObject.OwnerTable:group.Relations[group.Relations.Length-1].DestTable; string strTag = CurrentStepTagLevel.ToString(); string strParent = CurrentStepTagLevel==1?"NULL":(CurrentStepTagLevel-1).ToString(); retVal = new QSqlSelectMaker(strTag, strParent, GroupOwnerTable,this.TimeOffset,this.Language); AddFieldToSelect(retVal); return retVal; }
protected QSqlSelectMaker CreateGroupSelect(QField group) { QSqlSelectMaker retVal = null; // Create Root [4/21/2004] string GroupOwnerTable = group.Relations==null?this.OwnerObject.OwnerTable:group.Relations[group.Relations.Length-1].DestTable; string strTag = CurrentStepTagLevel.ToString(); string strParent = CurrentStepTagLevel==1?"NULL":(CurrentStepTagLevel-1).ToString(); retVal = new QSqlSelectMaker(strTag, strParent, GroupOwnerTable,this.TimeOffset,this.Language,group.Relations==null); AddFieldToSelect(retVal); // Where Extension Addon [4/30/2004] if(this.OwnerObject.GetWhereExtensions()!=null && GroupOwnerTable==this.OwnerObject.OwnerTable) { foreach(FilterCondition exFilter in this.OwnerObject.GetWhereExtensions()) { retVal.AddFilter(exFilter); } } // end [4/30/2004] // foreach(FilterCondition filter in this.Filters) // { // if(group==filter.OwnerField) // retVal.AddFilter(filter); // } return retVal; }
protected void AddLastFieldToSelect(QSqlSelectMaker select, QField availableField, QField exField,bool bFinalStep) { bool bShowAlias = false; // Add Root Static Field [4/21/2004] select.AddField(new QSqlSelectFieldMaker(new QField(_ReportName),false,bShowAlias?"Report!1!Name":null)); // Add Group Fields [4/20/2004] foreach(QField tmpGroupField in this.Groups) { // Step 1. Add Groups Item [4/21/2004] select.AddField(new QSqlSelectFieldMaker(new QField(tmpGroupField.FriendlyName),false,null)); select.AddField(new QSqlSelectFieldMaker(tmpGroupField,false,null)); select.AddField(new QSqlSelectFieldMaker(tmpGroupField.Relations==null?tmpGroupField:(new QField(tmpGroupField.FriendlyName,tmpGroupField.FriendlyName,tmpGroupField.FieldValueIsKey?tmpGroupField.DBName:tmpGroupField.Relations[tmpGroupField.Relations.Length-1].DestKey,tmpGroupField.DataType,tmpGroupField.UsingType,tmpGroupField.Relations)),false,null)); } // Add Key Field [4/21/2004] if(this.OwnerObject.KeyField!=null) { QField keyField = this.OwnerObject.KeyField; if(_KeyUniquePrefix!=null) { keyField = new QField(this.OwnerObject.KeyField.Name, this.OwnerObject.KeyField.FriendlyName, "'" + _KeyUniquePrefix+ "' + CONVERT(NVARCHAR(3000),{0}.["+this.OwnerObject.KeyField.DBName+"],20)", this.OwnerObject.KeyField.DataType,this.OwnerObject.KeyField.UsingType,true); } select.AddField(new QSqlSelectFieldMaker(keyField,false,null)); } if(bFinalStep) { // [FieldName!Tag!Id] [4/22/2004] select.AddField(new QSqlSelectFieldMaker(new QField(this.Fields.IndexOf(availableField).ToString("000")), false, null)); select.AddField(new QSqlSelectFieldMaker(new QField(availableField.Name),false,null)); select.AddField(new QSqlSelectFieldMaker(new QField(availableField.FriendlyName),false,null)); select.AddField(new QSqlSelectFieldMaker(new QField(availableField.Relations==null?"1":(availableField.Relations.Length==1?"2":"3") ),false,null)); select.AddField(new QSqlSelectFieldMaker(new QField(availableField.DataType.ToString()),false,null)); if(exField!=null) select.AddField(new QSqlSelectFieldMaker(exField,false,null)); else select.AddField(new QSqlSelectFieldMaker(availableField,false,null)); } else { // Add Fields [4/20/2004] //foreach(QField availableFields in this.Fields) //{ select.AddField(new QSqlSelectFieldMaker(new QField(this.Fields.IndexOf(availableField).ToString("000")),false,null)); select.AddField(new QSqlSelectFieldMaker(new QField(availableField.Name),false,null)); select.AddField(new QSqlSelectFieldMaker(new QField(availableField.FriendlyName),false,null)); select.AddField(new QSqlSelectFieldMaker(new QField(availableField.Relations==null?"1":(availableField.Relations.Length==1?"2":"3") ),false,null)); select.AddField(new QSqlSelectFieldMaker(new QField(availableField.DataType.ToString()),false,null)); select.AddField(new QSqlSelectFieldMaker(null,true,null)); //} } }
protected void AddItemKeyToSelect(QSqlSelectMaker select) { bool bShowAlias = false; // Add Root Static Field [4/21/2004] select.AddField(new QSqlSelectFieldMaker(new QField(_ReportName),false,bShowAlias?"Report!1!Name":null)); // Add Group Fields [4/20/2004] foreach(QField tmpGroupField in this.Groups) { // Step 1. Add Groups Item [4/21/2004] select.AddField(new QSqlSelectFieldMaker(new QField(tmpGroupField.FriendlyName),false,null)); select.AddField(new QSqlSelectFieldMaker(tmpGroupField,false,null)); select.AddField(new QSqlSelectFieldMaker(tmpGroupField.Relations==null?tmpGroupField:(new QField(tmpGroupField.Name,tmpGroupField.FriendlyName,tmpGroupField.FieldValueIsKey?tmpGroupField.DBName:tmpGroupField.Relations[tmpGroupField.Relations.Length-1].DestKey,tmpGroupField.DataType,tmpGroupField.UsingType,tmpGroupField.Relations)),false,null)); } // Add Key Field [4/21/2004] if(this.OwnerObject.KeyField!=null) { QField keyField = this.OwnerObject.KeyField; if(_KeyUniquePrefix!=null) { keyField = new QField(this.OwnerObject.KeyField.Name, this.OwnerObject.KeyField.FriendlyName, "'" + _KeyUniquePrefix+ "' + CONVERT(NVARCHAR(3000),{0}.["+this.OwnerObject.KeyField.DBName+"],20)", this.OwnerObject.KeyField.DataType,this.OwnerObject.KeyField.UsingType,true); } select.AddField(new QSqlSelectFieldMaker(keyField,false,null)); } // [FieldName!Tag!Id] [4/22/2004] select.AddField(new QSqlSelectFieldMaker(null,true,null)); // [Field!Tag!Name] [4/22/2004] select.AddField(new QSqlSelectFieldMaker(null,true,null)); // [Field!Tag!Description] [4/22/2004] select.AddField(new QSqlSelectFieldMaker(null,true,null)); // [FieldName!Tag!Type] [4/22/2004] select.AddField(new QSqlSelectFieldMaker(null,true,null)); // [FieldName!Tag!DataType] [4/22/2004] select.AddField(new QSqlSelectFieldMaker(null,true,null)); // New Addon [4/22/2004] // [Values!Tag!Value] [4/22/2004] select.AddField(new QSqlSelectFieldMaker(null,true,null)); // End New Addon [4/22/2004] }
protected void AddFieldToSelect(QSqlSelectMaker select) { bool bShowAlias = QSqlSelectList.Count==0; // Add Root Static Field [4/21/2004] select.AddField(new QSqlSelectFieldMaker(new QField(_ReportName),false,bShowAlias?"[Report!1!Name]":null)); // Add Group Fields [4/20/2004] int tmpGroupTagNumber = 2; foreach(QField tmpGroupField in this.Groups) { // Step 1. Add Groups Item [4/21/2004] string FieldAlias = null; if(bShowAlias) { FieldAlias = string.Format("[{0}!{1}!{2}]","Groups",tmpGroupTagNumber.ToString(),"Name"); if(!OrderByFields.Contains(FieldAlias)) OrderByFields.Add(FieldAlias); } bool FieldIsNull = false; if((tmpGroupTagNumber-2)>=ProcessedGroupItems) FieldIsNull = true; select.AddField(new QSqlSelectFieldMaker(new QField(tmpGroupField.FriendlyName),FieldIsNull,FieldAlias)); tmpGroupTagNumber++; // Step 2. Add Group Item [4/21/2004] ////////////////////////////////////////////////////////////////////////// if(bShowAlias) { FieldAlias = string.Format("[{0}!{1}!{2}]","Group",tmpGroupTagNumber.ToString(),"Name"); if(!OrderByFields.Contains(FieldAlias)) OrderByFields.Add(FieldAlias); } if((tmpGroupTagNumber-2)>=ProcessedGroupItems) FieldIsNull = true; select.AddField(new QSqlSelectFieldMaker(tmpGroupField,FieldIsNull,FieldAlias)); ////////////////////////////////////////////////////////////////////////// ////////////////////////////////////////////////////////////////////////// if(bShowAlias) { FieldAlias = string.Format("[{0}!{1}!{2}]","Group",tmpGroupTagNumber.ToString(),"Id"); if(!OrderByFields.Contains(FieldAlias)) OrderByFields.Add(FieldAlias); } if((tmpGroupTagNumber-2)>=ProcessedGroupItems) FieldIsNull = true; select.AddField(new QSqlSelectFieldMaker(tmpGroupField.Relations==null?tmpGroupField:(new QField(tmpGroupField.Name,tmpGroupField.FriendlyName,tmpGroupField.FieldValueIsKey?tmpGroupField.DBName:tmpGroupField.Relations[tmpGroupField.Relations.Length-1].DestKey,tmpGroupField.DataType,tmpGroupField.UsingType,tmpGroupField.Relations)),FieldIsNull,FieldAlias)); ////////////////////////////////////////////////////////////////////////// tmpGroupTagNumber++; } // Add Key Field [4/21/2004] if(this.OwnerObject.KeyField!=null) { string KeyFieldAlias = null; if(bShowAlias) { KeyFieldAlias = string.Format("[{0}!{1}!Key]","Item",tmpGroupTagNumber); if(!OrderByFields.Contains(KeyFieldAlias)) OrderByFields.Add(KeyFieldAlias); } select.AddField(new QSqlSelectFieldMaker(this.OwnerObject.KeyField,true,KeyFieldAlias)); } tmpGroupTagNumber++; // Add Fields [4/20/2004] //foreach(QField availableFields in this.Fields) { string FieldAlias = null; // [FieldName!Tag!Id] [4/22/2004] if(bShowAlias) { FieldAlias = string.Format("[{0}!{1}!{2}]","Field",tmpGroupTagNumber,"Id"); if(!OrderByFields.Contains(FieldAlias)) OrderByFields.Add(FieldAlias); } select.AddField(new QSqlSelectFieldMaker(null,true,FieldAlias)); // [Field!Tag!Name] [4/22/2004] if(bShowAlias) { FieldAlias = string.Format("[{0}!{1}!{2}]","Field",tmpGroupTagNumber,"Name"); if(!OrderByFields.Contains(FieldAlias)) OrderByFields.Add(FieldAlias); } select.AddField(new QSqlSelectFieldMaker(null,true,FieldAlias)); // [Field!Tag!Description] [4/22/2004] if(bShowAlias) { FieldAlias = string.Format("[{0}!{1}!{2}]","Field",tmpGroupTagNumber,"Description"); if(!OrderByFields.Contains(FieldAlias)) OrderByFields.Add(FieldAlias); } select.AddField(new QSqlSelectFieldMaker(null,true,FieldAlias)); // [FieldName!Tag!Type] [4/22/2004] if(bShowAlias) { FieldAlias = string.Format("[{0}!{1}!{2}]","Field",tmpGroupTagNumber,"Type"); if(!OrderByFields.Contains(FieldAlias)) OrderByFields.Add(FieldAlias); } select.AddField(new QSqlSelectFieldMaker(null,true,FieldAlias)); // [FieldName!Tag!DataType] [4/22/2004] if(bShowAlias) { FieldAlias = string.Format("[{0}!{1}!{2}]","Field",tmpGroupTagNumber,"DataType"); if(!OrderByFields.Contains(FieldAlias)) OrderByFields.Add(FieldAlias); } select.AddField(new QSqlSelectFieldMaker(null,true,FieldAlias)); // New Addon [4/22/2004] tmpGroupTagNumber++; // [Values!Tag!Value] [4/22/2004] if(bShowAlias) { FieldAlias = string.Format("[{0}!{1}!{2}!element]","Values",tmpGroupTagNumber,"Value"); if(!OrderByFields.Contains(FieldAlias)) OrderByFields.Add(FieldAlias); } select.AddField(new QSqlSelectFieldMaker(null,true,FieldAlias)); // End New Addon [4/22/2004] } }
protected void AddFieldToSelect(QSqlSelectMaker select) { bool bShowAlias = QSqlSelectList.Count == 0; // Add Root Static Field [4/21/2004] select.AddField(new QSqlSelectFieldMaker(new QField(_ReportName), false, bShowAlias?"[Report!1!Name]":null)); // Add Group Fields [4/20/2004] int tmpGroupTagNumber = 2; foreach (QField tmpGroupField in this.Groups) { // Step 1. Add Groups Item [4/21/2004] string FieldAlias = null; if (bShowAlias) { FieldAlias = string.Format("[{0}!{1}!{2}]", "Groups", tmpGroupTagNumber.ToString(), "Name"); if (!OrderByFields.Contains(FieldAlias)) { OrderByFields.Add(FieldAlias); } } bool FieldIsNull = false; if ((tmpGroupTagNumber - 2) >= ProcessedGroupItems) { FieldIsNull = true; } select.AddField(new QSqlSelectFieldMaker(new QField(tmpGroupField.FriendlyName), FieldIsNull, FieldAlias)); tmpGroupTagNumber++; // Step 2. Add Group Item [4/21/2004] ////////////////////////////////////////////////////////////////////////// if (bShowAlias) { FieldAlias = string.Format("[{0}!{1}!{2}]", "Group", tmpGroupTagNumber.ToString(), "Name"); if (!OrderByFields.Contains(FieldAlias)) { OrderByFields.Add(FieldAlias); } } if ((tmpGroupTagNumber - 2) >= ProcessedGroupItems) { FieldIsNull = true; } select.AddField(new QSqlSelectFieldMaker(tmpGroupField, FieldIsNull, FieldAlias)); ////////////////////////////////////////////////////////////////////////// ////////////////////////////////////////////////////////////////////////// if (bShowAlias) { FieldAlias = string.Format("[{0}!{1}!{2}]", "Group", tmpGroupTagNumber.ToString(), "Id"); if (!OrderByFields.Contains(FieldAlias)) { OrderByFields.Add(FieldAlias); } } if ((tmpGroupTagNumber - 2) >= ProcessedGroupItems) { FieldIsNull = true; } select.AddField(new QSqlSelectFieldMaker(tmpGroupField.Relations == null?tmpGroupField:(new QField(tmpGroupField.Name, tmpGroupField.FriendlyName, tmpGroupField.FieldValueIsKey?tmpGroupField.DBName:tmpGroupField.Relations[tmpGroupField.Relations.Length - 1].DestKey, tmpGroupField.DataType, tmpGroupField.UsingType, tmpGroupField.Relations)), FieldIsNull, FieldAlias)); ////////////////////////////////////////////////////////////////////////// tmpGroupTagNumber++; } // Add Key Field [4/21/2004] if (this.OwnerObject.KeyField != null) { string KeyFieldAlias = null; if (bShowAlias) { KeyFieldAlias = string.Format("[{0}!{1}!Key]", "Item", tmpGroupTagNumber); if (!OrderByFields.Contains(KeyFieldAlias)) { OrderByFields.Add(KeyFieldAlias); } } select.AddField(new QSqlSelectFieldMaker(this.OwnerObject.KeyField, true, KeyFieldAlias)); } tmpGroupTagNumber++; // Add Fields [4/20/2004] //foreach(QField availableFields in this.Fields) { string FieldAlias = null; // [FieldName!Tag!Id] [4/22/2004] if (bShowAlias) { FieldAlias = string.Format("[{0}!{1}!{2}]", "Field", tmpGroupTagNumber, "Id"); if (!OrderByFields.Contains(FieldAlias)) { OrderByFields.Add(FieldAlias); } } select.AddField(new QSqlSelectFieldMaker(null, true, FieldAlias)); // [Field!Tag!Name] [4/22/2004] if (bShowAlias) { FieldAlias = string.Format("[{0}!{1}!{2}]", "Field", tmpGroupTagNumber, "Name"); if (!OrderByFields.Contains(FieldAlias)) { OrderByFields.Add(FieldAlias); } } select.AddField(new QSqlSelectFieldMaker(null, true, FieldAlias)); // [Field!Tag!Description] [4/22/2004] if (bShowAlias) { FieldAlias = string.Format("[{0}!{1}!{2}]", "Field", tmpGroupTagNumber, "Description"); if (!OrderByFields.Contains(FieldAlias)) { OrderByFields.Add(FieldAlias); } } select.AddField(new QSqlSelectFieldMaker(null, true, FieldAlias)); // [FieldName!Tag!Type] [4/22/2004] if (bShowAlias) { FieldAlias = string.Format("[{0}!{1}!{2}]", "Field", tmpGroupTagNumber, "Type"); if (!OrderByFields.Contains(FieldAlias)) { OrderByFields.Add(FieldAlias); } } select.AddField(new QSqlSelectFieldMaker(null, true, FieldAlias)); // [FieldName!Tag!DataType] [4/22/2004] if (bShowAlias) { FieldAlias = string.Format("[{0}!{1}!{2}]", "Field", tmpGroupTagNumber, "DataType"); if (!OrderByFields.Contains(FieldAlias)) { OrderByFields.Add(FieldAlias); } } select.AddField(new QSqlSelectFieldMaker(null, true, FieldAlias)); // New Addon [4/22/2004] tmpGroupTagNumber++; // [Values!Tag!Value] [4/22/2004] if (bShowAlias) { FieldAlias = string.Format("[{0}!{1}!{2}!element]", "Values", tmpGroupTagNumber, "Value"); if (!OrderByFields.Contains(FieldAlias)) { OrderByFields.Add(FieldAlias); } } select.AddField(new QSqlSelectFieldMaker(null, true, FieldAlias)); // End New Addon [4/22/2004] } }
protected void AddLastFieldToSelect(QSqlSelectMaker select, QField availableField, QField exField, bool bFinalStep) { bool bShowAlias = false; // Add Root Static Field [4/21/2004] select.AddField(new QSqlSelectFieldMaker(new QField(_ReportName), false, bShowAlias?"Report!1!Name":null)); // Add Group Fields [4/20/2004] foreach (QField tmpGroupField in this.Groups) { // Step 1. Add Groups Item [4/21/2004] select.AddField(new QSqlSelectFieldMaker(new QField(tmpGroupField.FriendlyName), false, null)); select.AddField(new QSqlSelectFieldMaker(tmpGroupField, false, null)); select.AddField(new QSqlSelectFieldMaker(tmpGroupField.Relations == null?tmpGroupField:(new QField(tmpGroupField.FriendlyName, tmpGroupField.FriendlyName, tmpGroupField.FieldValueIsKey?tmpGroupField.DBName:tmpGroupField.Relations[tmpGroupField.Relations.Length - 1].DestKey, tmpGroupField.DataType, tmpGroupField.UsingType, tmpGroupField.Relations)), false, null)); } // Add Key Field [4/21/2004] if (this.OwnerObject.KeyField != null) { QField keyField = this.OwnerObject.KeyField; if (_KeyUniquePrefix != null) { keyField = new QField(this.OwnerObject.KeyField.Name, this.OwnerObject.KeyField.FriendlyName, "'" + _KeyUniquePrefix + "' + CONVERT(NVARCHAR(3000),{0}.[" + this.OwnerObject.KeyField.DBName + "],20)", this.OwnerObject.KeyField.DataType, this.OwnerObject.KeyField.UsingType, true); } select.AddField(new QSqlSelectFieldMaker(keyField, false, null)); } if (bFinalStep) { // [FieldName!Tag!Id] [4/22/2004] select.AddField(new QSqlSelectFieldMaker(new QField(this.Fields.IndexOf(availableField).ToString("000")), false, null)); select.AddField(new QSqlSelectFieldMaker(new QField(availableField.Name), false, null)); select.AddField(new QSqlSelectFieldMaker(new QField(availableField.FriendlyName), false, null)); select.AddField(new QSqlSelectFieldMaker(new QField(availableField.Relations == null?"1":(availableField.Relations.Length == 1?"2":"3")), false, null)); select.AddField(new QSqlSelectFieldMaker(new QField(availableField.DataType.ToString()), false, null)); if (exField != null) { select.AddField(new QSqlSelectFieldMaker(exField, false, null)); } else { select.AddField(new QSqlSelectFieldMaker(availableField, false, null)); } } else { // Add Fields [4/20/2004] //foreach(QField availableFields in this.Fields) //{ select.AddField(new QSqlSelectFieldMaker(new QField(this.Fields.IndexOf(availableField).ToString("000")), false, null)); select.AddField(new QSqlSelectFieldMaker(new QField(availableField.Name), false, null)); select.AddField(new QSqlSelectFieldMaker(new QField(availableField.FriendlyName), false, null)); select.AddField(new QSqlSelectFieldMaker(new QField(availableField.Relations == null?"1":(availableField.Relations.Length == 1?"2":"3")), false, null)); select.AddField(new QSqlSelectFieldMaker(new QField(availableField.DataType.ToString()), false, null)); select.AddField(new QSqlSelectFieldMaker(null, true, null)); //} } }