コード例 #1
0
	protected void CreateColumns(PXDataSourceViewSchema schema, PXGrid grid)
	{
		List<string> list = new List<string>();
		foreach (PXGridColumn col in grid.Levels[0].Columns)
		{ 
			if (!String.IsNullOrEmpty(col.DataField))
			{
				list.Add(col.DataField);
			}
		}
		foreach (PXFieldState field in schema.GetFields())
		{
			if (!AUAuditInquire.FORBIDDEN_COLUMNS.Contains(field.Name) && field.Name.EndsWith(AUAuditInquire.VIRTUAL_FIELD_SUFFIX) && !list.Contains(field.Name))
			{
				PXGridColumn col = new PXGridColumn();
				col.DataField = field.Name;
				col.DataType = Type.GetTypeCode(field.DataType);
				col.TextAlign = HorizontalAlign.Right;
				col.Width = Unit.Pixel(120);
				switch (col.DataType)
				{
					case TypeCode.Boolean:
						col.Width = Unit.Pixel(60);
						col.Type = GridColumnType.CheckBox;
						col.TextAlign = HorizontalAlign.Center;
						break;
					case TypeCode.DateTime:
						col.TextAlign = HorizontalAlign.Left;
						col.DisplayFormat = "g";
						break;
					case TypeCode.String:
						col.TextAlign = HorizontalAlign.Left;
						break;
				}
				col.Visible = true;
				col.Header.Text = field.DisplayName == field.Name
                    ? field.DisplayName.Substring(0, field.DisplayName.Length - AUAuditInquire.VIRTUAL_FIELD_SUFFIX.Length)
					: field.DisplayName;
				col.AllowShowHide = AllowShowHide.Server;
				grid.Columns.Add(col);
			}

			list.Remove(field.Name);
		}

		foreach (string field in list)
		{
			PXGridColumn col = GetColumn(grid, field);
			if (col != null) grid.Levels[0].Columns.Remove(col);
		}

        grid.FastFilterFields = grid.Columns.Items.Select(col => col.DataField).ToArray();

		//if (grid.Levels[0].Columns.Count <= 1) grid.AllowAutoHide = true;
	}
コード例 #2
0
    protected void CreateColumns(PXDataSourceViewSchema schema, PXGrid grid)
    {
        var gridColumn = sp1.FindControl("gridColumn") as PXGrid;

        List <string> list = new List <string>();

        foreach (PXGridColumn col in grid.Levels[0].Columns)
        {
            if (!String.IsNullOrEmpty(col.DataField))
            {
                list.Add(col.DataField);
            }
        }
        foreach (PXFieldState field in schema.GetFields())
        {
            if (field.Name.Length <= 3 || field.Name.EndsWith("_StyleID"))
            {
                if (!list.Contains(field.Name))
                {
                    PXGridColumn col = new PXGridColumn();
                    col.DataField     = field.Name;
                    col.DataType      = Type.GetTypeCode(field.DataType);
                    col.Width         = Unit.Pixel(150);
                    col.Header.Text   = field.DisplayName;
                    col.AllowShowHide = AllowShowHide.Server;
                    if (grid == gridColumn)
                    {
                        col.TextField = field.Name + "_Text";
                    }
                    else if (field.Name.Length <= 3)
                    {
                        col.EditorID = "edColHeader";
                    }
                    grid.Columns.Add(col);
                }
            }
            list.Remove(field.Name);
        }
        foreach (string field in list)
        {
            foreach (PXGridColumn col in grid.Levels[0].Columns)
            {
                if (col.DataField == field)
                {
                    grid.Levels[0].Columns.Remove(col);
                    break;
                }
            }
        }
    }
コード例 #3
0
    protected void Page_Init(object sender, EventArgs e)
    {
        RMReportMaint graph = (RMReportMaint)ds.DataGraph;

        PXDataSourceViewSchema schema = ds.GetSchema("Report");

        RMReport    currentReport     = graph.Report.Current;
        RMRowSet    currentRowSet     = (RMRowSet)graph.Caches[typeof(RMRowSet)].Current;
        RMColumnSet currentColumnSet  = (RMColumnSet)graph.Caches[typeof(RMColumnSet)].Current;
        RMUnitSet   currentUnitSet    = (RMUnitSet)graph.Caches[typeof(RMUnitSet)].Current;
        string      currentTypeReport = currentReport != null ? currentReport.Type : null;

        RMDataSource currentDataSource = graph.DataSourceByID.Current;

        if (currentTypeReport == null)
        {
            graph.Report.Current = currentReport = new RMReport();
        }
        if (currentRowSet == null)
        {
            graph.Caches[typeof(RMRowSet)].Current = new RMRowSet();
        }
        graph.Caches[typeof(RMColumnSet)].Current = null;
        graph.Caches[typeof(RMUnitSet)].Current   = null;

        Dictionary <string, List <PXFieldSchema> > controls = new Dictionary <string, List <PXFieldSchema> >();

        string[] arrTypes = ((PXStringState)graph.Report.Cache.GetStateExt <RMReport.type>(null)).AllowedValues;

        foreach (string type in arrTypes)
        {
            graph.Report.Current.Type = type;
            ((RMRowSet)graph.Caches[typeof(RMRowSet)].Current).Type = type;
            graph.Report.Current = currentReport;

            graph.DataSourceByID.Current = null;

            List <PXFieldSchema> lControls = new List <PXFieldSchema>();
            List <PXFieldSchema> list      = RefreshFieldsList(schema, graph);

            foreach (PXFieldSchema f in list)
            {
                if (f.DataType == TypeCode.Object)
                {
                    continue;
                }
                if (!ContainsControlDictionary(f, controls))
                {
                    lControls.Add(f);
                }
            }
            controls.Add(type, lControls);
        }

        if (currentTypeReport == null)
        {
            graph.Report.Cache.Clear();
        }
        else
        {
            graph.Report.Current.Type = currentTypeReport;
        }

        graph.DataSourceByID.Current              = currentDataSource;
        graph.Caches[typeof(RMRowSet)].Current    = currentRowSet;
        graph.Caches[typeof(RMColumnSet)].Current = currentColumnSet;
        graph.Caches[typeof(RMUnitSet)].Current   = currentUnitSet;

        _insertIndex = 0;
        foreach (Control control in this.form.TemplateContainer.Controls)
        {
            if (!string.IsNullOrEmpty(control.ID))
            {
                if (!control.ID.Equals("edStartUnitCode", StringComparison.OrdinalIgnoreCase))
                {
                    _insertIndex++;
                }
                else
                {
                    break;
                }
            }
            else
            {
                _insertIndex++;
            }
        }
        _insertIndex++;

        PXLayoutRule rule1 = new PXLayoutRule()
        {
            ID = "rule1", StartGroup = true, GroupCaption = "Default Data Source Settings"
        };

        (rule1).ApplyStyleSheetSkin(this.Page);
        this.form.TemplateContainer.Controls.AddAt(_insertIndex, rule1);
        _insertIndex++;

        for (int c = arrTypes.Length - 1; c >= 0; c--)
        {
            string type = arrTypes[c];
            List <PXFieldSchema> lDsControls = new List <PXFieldSchema>();

            for (int i = 0; i < controls[type].Count; i++)
            {
                if (controls[type][i].DataField.StartsWith("DataSource", StringComparison.OrdinalIgnoreCase) &&
                    !controls[type][i].DataField.Equals("datasourceexpand", StringComparison.OrdinalIgnoreCase) &&
                    !controls[type][i].DataField.Equals("datasourceamounttype", StringComparison.OrdinalIgnoreCase) &&
                    !controls[type][i].DataField.Equals("datasourcestartPeriodOffset", StringComparison.OrdinalIgnoreCase) &&
                    !controls[type][i].DataField.Equals("datasourceEndPeriodOffset", StringComparison.OrdinalIgnoreCase)
                    //ContainsControl("Request" + controls[type][i].DataField.Replace("DataSource", string.Empty), controls[type])
                    )
                {
                    lDsControls.Add(controls[type][i]);
                }
            }

            int cntFirstColumn = lDsControls.Count / 2;
            if ((lDsControls.Count % 2) > 0)
            {
                cntFirstColumn++;
            }

            for (int i = 0; i < cntFirstColumn; i++)
            {
                AddControl(lDsControls[i], controls[type]);
                if ((lDsControls.Count - 1) >= (i + cntFirstColumn))
                {
                    AddControl(lDsControls[i + cntFirstColumn], controls[type]);
                }
            }
        }

        PXDropDown edDataSourceAmountType = new PXDropDown()
        {
            ID = "edDataSourceAmountType", AllowNull = false, DataField = "DataSourceAmountType"
        };

        form.TemplateContainer.Controls.AddAt(_insertIndex, edDataSourceAmountType);
        (edDataSourceAmountType).ApplyStyleSheetSkin(this.Page);
        _insertIndex++;

        PXCheckBox chkApplyRestrictionGroups = new PXCheckBox()
        {
            ID = "chkApplyRestrictionGroups", DataField = "ApplyRestrictionGroups"
        };

        form.TemplateContainer.Controls.AddAt(_insertIndex, chkApplyRestrictionGroups);
        (chkApplyRestrictionGroups).ApplyStyleSheetSkin(this.Page);
    }
コード例 #4
0
    /// <summary>
    /// Refresh the list of data fields using specified view name.
    /// </summary>
    private List <PXFieldSchema> RefreshFieldsList(PXDataSourceViewSchema schema, RMReportMaint graph)
    {
        PX.Data.PXFieldState[] fields = schema.GetFields();
        List <PXFieldSchema>   list   = new List <PXFieldSchema>();

        if (fields != null)
        {
            foreach (PX.Data.PXFieldState f in fields)
            {
                if (String.IsNullOrEmpty(f.Name) || !f.Name.StartsWith("DataSource", StringComparison.OrdinalIgnoreCase) && !f.Name.StartsWith("Request", StringComparison.OrdinalIgnoreCase) && !f.Name.StartsWith("UsrRequest", StringComparison.OrdinalIgnoreCase))
                {
                    continue;
                }

                string dsField = f.Name;
                if (dsField.StartsWith("DataSource", StringComparison.OrdinalIgnoreCase))
                {
                    dsField = dsField.Substring(10);
                }
                else if (f.Name.StartsWith("Request", StringComparison.OrdinalIgnoreCase))
                {
                    dsField = dsField.Substring(7);
                }
                else
                {
                    dsField = "Usr" + dsField.Substring(10);
                }

                PXFieldState dsState = graph.DataSourceByID.Cache.GetStateExt(null, dsField) as PXFieldState;

                if (dsState == null || !dsState.Visible)
                {
                    continue;
                }

                TypeCode dataType = Type.GetTypeCode(f.DataType);
                if (dataType == TypeCode.Object)
                {
                    continue;
                }

                PXFieldSchema item = new PXFieldSchema(true, f.Name, dataType);
                item.ControlType = PXSchemaGenerator.GetControlType(f);
                item.PrimaryKey  = f.PrimaryKey;
                item.ReadOnly    = f.IsReadOnly;
                item.AllowNull   = f.Nullable;
                item.MaxLength   = (f.Length > 0) ? f.Length : 0;
                item.Precision   = (f.Precision > 0) ? f.Precision : 0;

                item.Caption      = f.DisplayName;
                item.ViewName     = f.ViewName;
                item.HintField    = f.DescriptionName;
                item.FieldList    = f.FieldList;
                item.HeaderList   = f.HeaderList;
                item.DefaultValue = f.DefaultValue;

                list.Add(item);
            }
        }

        return(list);
    }
コード例 #5
0
    protected void CreateColumns(PXDataSourceViewSchema schema, PXGrid grid)
    {
        List <string> list = new List <string>();

        foreach (PXGridColumn col in grid.Levels[0].Columns)
        {
            if (!String.IsNullOrEmpty(col.DataField))
            {
                list.Add(col.DataField);
            }
        }
        foreach (PXFieldState field in schema.GetFields())
        {
            if (!AUAuditInquire.FORBIDDEN_COLUMNS.Contains(field.Name) && field.Name.EndsWith(AUAuditInquire.VIRTUAL_FIELD_SUFFIX) && !list.Contains(field.Name))
            {
                PXGridColumn col = new PXGridColumn();
                col.DataField = field.Name;
                col.DataType  = Type.GetTypeCode(field.DataType);
                col.TextAlign = HorizontalAlign.Right;
                col.Width     = Unit.Pixel(120);
                switch (col.DataType)
                {
                case TypeCode.Boolean:
                    col.Width     = Unit.Pixel(60);
                    col.Type      = GridColumnType.CheckBox;
                    col.TextAlign = HorizontalAlign.Center;
                    break;

                case TypeCode.DateTime:
                    col.TextAlign     = HorizontalAlign.Left;
                    col.DisplayFormat = "g";
                    break;

                case TypeCode.String:
                    col.TextAlign = HorizontalAlign.Left;
                    break;
                }
                col.Visible     = true;
                col.Header.Text = field.DisplayName == field.Name
                    ? field.DisplayName.Substring(0, field.DisplayName.Length - AUAuditInquire.VIRTUAL_FIELD_SUFFIX.Length)
                                        : field.DisplayName;
                col.AllowShowHide = AllowShowHide.Server;
                grid.Columns.Add(col);
            }

            list.Remove(field.Name);
        }

        foreach (string field in list)
        {
            PXGridColumn col = GetColumn(grid, field);
            if (col != null)
            {
                grid.Levels[0].Columns.Remove(col);
            }
        }

        grid.FastFilterFields = grid.Columns.Items.Select(col => col.DataField).ToArray();

        //if (grid.Levels[0].Columns.Count <= 1) grid.AllowAutoHide = true;
    }
コード例 #6
0
	protected void CreateColumns(PXDataSourceViewSchema schema, PXGrid grid)
	{
        var gridColumn = sp1.FindControl("gridColumn") as PXGrid;
        
        List<string> list = new List<string>();
		foreach (PXGridColumn col in grid.Levels[0].Columns)
		{
			if (!String.IsNullOrEmpty(col.DataField))
			{
				list.Add(col.DataField);
			}
		}
		foreach (PXFieldState field in schema.GetFields())
		{
			if (field.Name.Length <= 3 || field.Name.EndsWith("_StyleID"))
			{
				if (!list.Contains(field.Name))
				{
					PXGridColumn col = new PXGridColumn();
					col.DataField = field.Name;
					col.DataType = Type.GetTypeCode(field.DataType);
					col.Width = Unit.Pixel(150);
					col.Header.Text = field.DisplayName;
					col.AllowShowHide = AllowShowHide.Server;
					if (grid == gridColumn)
					{
						col.TextField = field.Name + "_Text";
					}
					else if (field.Name.Length <= 3)
					{
						col.EditorID = "edColHeader";
					}
					grid.Columns.Add(col);
				}
			}
			list.Remove(field.Name);
		}
		foreach (string field in list)
		{
			foreach (PXGridColumn col in grid.Levels[0].Columns)
			{
				if (col.DataField == field)
				{
					grid.Levels[0].Columns.Remove(col);
					break;
				}
			}
		}
	}
コード例 #7
0
	/// <summary>
	/// Refresh the list of data fields using specified view name.
	/// </summary>
	private List<PXFieldSchema> RefreshFieldsList(PXDataSourceViewSchema schema, RMReportMaint graph)
	{
		PX.Data.PXFieldState[] fields = schema.GetFields();
		List<PXFieldSchema> list = new List<PXFieldSchema>();

		if (fields != null)
		{
			foreach (PX.Data.PXFieldState f in fields)
			{
				if (String.IsNullOrEmpty(f.Name) || !f.Name.StartsWith("DataSource", StringComparison.OrdinalIgnoreCase) && !f.Name.StartsWith("Request", StringComparison.OrdinalIgnoreCase) && !f.Name.StartsWith("UsrRequest", StringComparison.OrdinalIgnoreCase))
					continue;

				string dsField = f.Name;
				if (dsField.StartsWith("DataSource", StringComparison.OrdinalIgnoreCase))
					dsField = dsField.Substring(10);
				else if (f.Name.StartsWith("Request", StringComparison.OrdinalIgnoreCase))
					dsField = dsField.Substring(7);
				else
					dsField = "Usr" + dsField.Substring(10);

				PXFieldState dsState = graph.DataSourceByID.Cache.GetStateExt(null, dsField) as PXFieldState;

				if (dsState == null || !dsState.Visible) continue;

				TypeCode dataType = Type.GetTypeCode(f.DataType);
				if (dataType == TypeCode.Object) continue;

				PXFieldSchema item = new PXFieldSchema(true, f.Name, dataType);
				item.ControlType = PXSchemaGenerator.GetControlType(f);
				item.PrimaryKey = f.PrimaryKey;
				item.ReadOnly = f.IsReadOnly;
				item.AllowNull = f.Nullable;
				item.MaxLength = (f.Length > 0) ? f.Length : 0;
				item.Precision = (f.Precision > 0) ? f.Precision : 0;

				item.Caption = f.DisplayName;
				item.ViewName = f.ViewName;
				item.HintField = f.DescriptionName;
				item.FieldList = f.FieldList;
				item.HeaderList = f.HeaderList;
				item.DefaultValue = f.DefaultValue;

				list.Add(item);
			}
		}

		return list;
	}