Exemplo n.º 1
0
		protected void FillSelectedTokens()
		{
			if (GeneratedReportID > 0)
			{
				ddlSelectedTokens.Items.Clear();
				BPTokens bpTokens = new BPTokens();
				BEQuickReports dsTokens = new BEQuickReports();
				BPCompanyAliases bpAliases = new BPCompanyAliases();
				Hashtable aliases = bpAliases.SelectColumnMappings(CompanyID);

				dsTokens = bpTokens.SelectByGeneratedReportID(GeneratedReportID);

				ListItem item;
				foreach (BEQuickReports.tbl_TokensRow row in dsTokens.tbl_Tokens)
				{
					item = new ListItem();
					item.Value = row.TokenID.ToString().Replace('_',' ');
					if (!row.LookupAlias)
					{
						item.Text = row.TokenAlias.Replace('_',' '); //.Replace added, part of bug fix 20090603 - hs
					}
					else
					{
						string columnName = row.TokenColumns.Replace("|","");
						if (aliases.Count > 0 && aliases.ContainsKey(columnName) && aliases[columnName].ToString()!="")
						{
							item.Text = aliases[columnName].ToString();	
						}
						else
						{
							item.Text = row.TokenAlias.Replace('_',' ');
						}
					}
					ddlSelectedTokens.Items.Add(item);
					SelectedTokens.Value += item.Value + ",";
				}
			}
		}
Exemplo n.º 2
0
		private void UpdateDataSource()
		{
			string CompanyColumnAlias = "";
			BPCompanyAliases bpAliases = new BPCompanyAliases();
			Hashtable aliases = bpAliases.SelectColumnMappings(CompanyID);

			BPTokens bp = new BPTokens();
			BEQuickReports ds = bp.SelectByQuickReportID(QuickReportID);
			foreach (BEQuickReports.tbl_TokensRow row in ds.tbl_Tokens.Rows)
			{
				if (row.LookupAlias)
				{
					string columnName = row.TokenColumns.Replace("|","");
					if (aliases.Count > 0 && aliases.ContainsKey(columnName) && aliases[columnName].ToString()!="")
					{
						CompanyColumnAlias = aliases[columnName].ToString();	
					}
					else if (! columnName.StartsWith("ExtraColumn"))
					{
						CompanyColumnAlias = row.TokenAlias.Replace('_',' ');
					}
				}
				else
					CompanyColumnAlias = ""; //bug fix 20090603 - hs

//				else
//				{
//					CompanyColumnAlias = row.TokenAlias.Replace('_', ' ');
//				}

				if (gridDataSource.GetTokenByTokenID(row.TokenID) == null)
				{
					if (SelectedTokensList.Contains(row.TokenID))
					{
						gridDataSource.Add(row, CompanyColumnAlias);
					}
				}
				else if (! SelectedTokensList.Contains(row.TokenID))
				{
					gridDataSource.Remove(row);
				}
			}
		}
Exemplo n.º 3
0
		protected void FillAvailableTokens()
		{
			ddlAvailableTokens.Items.Clear();
			if (ddlTokenCategories.SelectedValue != "0")
			{
				BPTokens bpTokens = new BPTokens();
				BEQuickReports dsTokens = new BEQuickReports();
				BPCompanyAliases bpAliases = new BPCompanyAliases();
				Hashtable aliases = bpAliases.SelectColumnMappings(CompanyID);

				dsTokens = bpTokens.SelectByTokenCategoryID(Convert.ToInt32(ddlTokenCategories.SelectedValue));

				ListItem item;
				foreach (BEQuickReports.tbl_TokensRow row in dsTokens.tbl_Tokens)
				{
					item = new ListItem();
					item.Value = row.TokenID.ToString();
					if (!row.LookupAlias)
					{
						item.Text = row.TokenAlias.Replace('_',' ');
						ddlAvailableTokens.Items.Add(item);
					}
					else
					{
						string columnName = row.TokenColumns.Replace("|","");
						if (aliases.Count > 0 && aliases.ContainsKey(columnName) && aliases[columnName].ToString()!="")
						{
							item.Text = aliases[columnName].ToString();	
							ddlAvailableTokens.Items.Add(item);
						}
						else if (! columnName.StartsWith("ExtraColumn"))
						{
							item.Text = row.TokenAlias.Replace('_',' ');
							ddlAvailableTokens.Items.Add(item);
						}
					}
				}
			}
		}
Exemplo n.º 4
0
		private void SaveToken_Click(object sender, EventArgs e)
		{
			if (txtResult.Text.Length > 0 && txtTokenAlias.Text.Length >0)
			{
				BPTokens bp = new BPTokens();
				BEQuickReports ds = new BEQuickReports();
				BEQuickReports.tbl_TokensRow row = ds.tbl_Tokens.Newtbl_TokensRow();
				row.TokenAlias = txtTokenAlias.Text;
				row.TokenColumns = txtResult.Text;
				row.TokenCategoryID = Convert.ToInt32(ddlCategories.SelectedValue);
				row.QuickReportID = Convert.ToInt32(ddlTables.SelectedItem.Value);
				ds.tbl_Tokens.Rows.Add(row);
				bp.Update(ds);
			}
			else
			{
				lblError2.Visible = true;
			}
		}