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)); //} } }
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] }