private void LoadReportPanel()
        {
            // load table
            _reportProxy.LoadHeader();
            FI.Common.Data.FIDataTable rptTable = new FI.Common.Data.FIDataTable();
            rptTable.Columns.Add("name", typeof(string));
            rptTable.Columns.Add("description", typeof(string));
            rptTable.Rows.Add(new object[] { _reportProxy.Name, _reportProxy.Description });

            //loading grid control
            _rptGr                    = (FI.UI.Web.Controls.FIDataTableGrid)Page.LoadControl("Controls/FIDataTableGrid.ascx");
            _rptGr.ID                 = "RptGrid";
            _rptGr.InMemory           = true;
            _rptGr.DataSource         = rptTable;
            _rptGr.ColumnNameArray    = new string[] { "name", "description" };
            _rptGr.ColumnCaptionArray = new string[] { "Report Name", "Description" };
            _rptGr.ColumnWidthArray   = new int[] { 200, 400 };
            _rptGr.EnableSort         = false;
            _rptGr.EnableFilter       = false;
            _rptGr.EnableCheckBoxes   = false;
            _rptGr.EnablePages        = false;
            ReportPanel.Controls.Add(_rptGr);


            //load values into text fields
            string name = ((string)rptTable.Rows[0]["name"]).Trim();

            name                = (name.Length > 42?name.Substring(0, 42):name);
            txtName.Text        = "Copy of " + name;
            txtDescription.Text = ((string)rptTable.Rows[0]["description"]).Trim();
        }
Ejemplo n.º 2
0
        private void LoadGrid()
        {
            //loading grid control
            _gr    = (FI.UI.Web.Controls.FIDataTableGrid)Page.LoadControl("../Controls/FIDataTableGrid.ascx");
            _gr.ID = "ProductsGrid";
            _gr.DefaultPageSize    = 15;
            _gr.DataSourceDelegate = new FI.UI.Web.Controls.FIDataTableGrid.GridDataSourceDelegate(GetReportPage);
            //_gr.PrimaryKeyColumnArray=new string[] {"prodsern"};
            _gr.ColumnNameArray    = new string[] { "SALMNAME", "CCHNAME", "CHNNAME", "COMNAME", "COMCITY", "COMPCODE", "COMADDR", "DELDATE" };
            _gr.ColumnCaptionArray = new string[] { "Salesman", "Centr. Chain", "Chain", "Store", "City", "Post. Code", "Address", "Last Transact." };
            _gr.ColumnWidthArray   = new int[] { 150, 150, 150, 150, 100, 75, 150, 75 };
            _gr.EnableCheckBoxes   = false;
            _gr.EnablePages        = true;
            _gr.FilterChanged     += new EventHandler(_gr_FilterChanged);

            // assign report filter
            foreach (string colName in _gr.ColumnNameArray)
            {
                string val = _report.GetFilterItem(colName);
                if (val != null)
                {
                    _gr.Filter[colName] = val;
                }
                else
                {
                    _gr.Filter.Remove(colName);
                }
            }

            this.cellContents.Controls.Add(_gr);
        }
        private void LoadControls()
        {
            // _ddlUniqueName
            _ddlUniqueName          = new Controls.FIDropDownControl();
            _ddlUniqueName.CssClass = "tbl1_edit";
            this.pnlSourceMember.Controls.Add(_ddlUniqueName);


            // listFormat
            foreach (string format in Enum.GetNames(typeof(FI.BusinessObjects.Olap.CalculatedMember.FormatEnum)))
            {
                this.listFormat.Items.Add(format);
            }

            //  formatted members grid
            _gridFormattedMembers                         = (FI.UI.Web.Controls.FIDataTableGrid)Page.LoadControl("../Controls/FIDataTableGrid.ascx");
            _gridFormattedMembers.ID                      = "gridFormattedMembers";
            _gridFormattedMembers.EnablePages             = true;
            _gridFormattedMembers.DefaultPageSize         = 15;
            _gridFormattedMembers.EnableUpdatePager       = false;
            _gridFormattedMembers.InMemory                = true;
            _gridFormattedMembers.PrimaryKeyColumnArray   = new string[] { "uniquename" };
            _gridFormattedMembers.ColumnNameArray         = new string[] { "hierarchy", "default_name", "name", "format" };
            _gridFormattedMembers.ColumnCaptionArray      = new string[] { "Hierarchy", "Default Name", "Name", "Format" };
            _gridFormattedMembers.ColumnWidthArray        = new int[] { 150, 200, 200, 80 };
            _gridFormattedMembers.EnableMultipleSelection = true;
            this.pnlFormattedMembers.Controls.Add(_gridFormattedMembers);
        }
Ejemplo n.º 4
0
 private void LoadDistributionLogPanel()
 {
     //loading grid control
     _gr = (FI.UI.Web.Controls.FIDataTableGrid)Page.LoadControl("../Controls/FIDataTableGrid.ascx");
     _gr.DefaultPageSize       = 20;
     _gr.DataSourceDelegate    = new FI.UI.Web.Controls.FIDataTableGrid.GridDataSourceDelegate(GetDistributionLogPage);
     _gr.PrimaryKeyColumnArray = new string[] { "log_id" };
     _gr.ColumnNameArray       = new string[] { "timestamp", "status", "duration", "isfromcache", "message", "contact_name", "contact_email" };
     _gr.ColumnCaptionArray    = new string[] { "Timestamp", "Status", "Duration(sec)", "FromCache", "Message", "Contact Name", "Contact Email" };
     _gr.ColumnWidthArray      = new int[] { 150, 150, 80, 80, 150, 150, 150 };
     _gr.EnableCheckBoxes      = false;
     _gr.EnablePages           = true;
     DistributionLogPanel.Controls.Add(_gr);
 }
 private void LoadDistributionLogPanel()
 {
     //loading grid control
     _gr = (FI.UI.Web.Controls.FIDataTableGrid)Page.LoadControl("../Controls/FIDataTableGrid.ascx");
     _gr.DefaultPageSize=20;
     _gr.DataSourceDelegate=new FI.UI.Web.Controls.FIDataTableGrid.GridDataSourceDelegate(GetDistributionLogPage);
     _gr.PrimaryKeyColumnArray=new string[] {"log_id"};
     _gr.ColumnNameArray=new string[] {"timestamp", "status" , "duration", "isfromcache", "message" , "contact_name" , "contact_email"};
     _gr.ColumnCaptionArray=new string[] {"Timestamp", "Status" , "Duration(sec)", "FromCache", "Message" , "Contact Name" , "Contact Email"};
     _gr.ColumnWidthArray=new int[] {150, 150 , 80, 80, 150 , 150 , 150};
     _gr.EnableCheckBoxes=false;
     _gr.EnablePages=true;
     DistributionLogPanel.Controls.Add(_gr);
 }
 private void LoadProductsGrid()
 {
     //loading grid control
     _gr    = (FI.UI.Web.Controls.FIDataTableGrid)Page.LoadControl("../Controls/FIDataTableGrid.ascx");
     _gr.ID = "ProductsGrid";
     _gr.DefaultPageSize         = 15;
     _gr.DataSourceDelegate      = new FI.UI.Web.Controls.FIDataTableGrid.GridDataSourceDelegate(GetSppProductsPage);
     _gr.PrimaryKeyColumnArray   = new string[] { "prodsern" };
     _gr.ColumnNameArray         = new string[] { "prodname", "prodsname", "prodcode", "proddunc", "prodeanc", "prodprice", "prodcps", "prodcpu", "prodsize", "prodpallet" };
     _gr.ColumnCaptionArray      = new string[] { "Name", "Short Name", "Code", "DUN Code", "EAN Code", "Price", "Cons Pkg Size", "Units", "Case Size", "Pallet Size" };
     _gr.ColumnWidthArray        = new int[] { 200, 100, 100, 100, 100, 75, 75, 75, 75, 75 };
     _gr.EnableMultipleSelection = true;
     _gr.EnablePages             = true;
     this.cellContents.Controls.Add(_gr);
 }
Ejemplo n.º 7
0
 private void LoadGridControl()
 {
     //loading grid control
     _gr    = (FI.UI.Web.Controls.FIDataTableGrid)Page.LoadControl("Controls/FIDataTableGrid.ascx");
     _gr.ID = "DLogGr";
     _gr.ColumnNameArray    = new string[] { "timestamp", "status", "duration", "message", "rpt_type", "rpt_name", "rpt_description", "contact_name", "contact_email" };
     _gr.ColumnCaptionArray = new string[] { "Timestamp", "Status", "Duration(sec)", "Message", "Report Type", "Report Name", "Report Descr.", "Contact Name", "Contact Email" };
     _gr.ColumnWidthArray   = new int[] { 100, 50, 80, 200, 100, 150, 150, 150, 150 };
     _gr.EnableSort         = true;
     _gr.EnableCheckBoxes   = false;
     _gr.EnablePages        = true;
     _gr.DefaultPageSize    = 25;
     _gr.DataSourceDelegate = new FI.UI.Web.Controls.FIDataTableGrid.GridDataSourceDelegate(GetDistributionLogPage);
     ControlPanel.Controls.Add(_gr);
     //end loading grid control
 }
 private void LoadGridControl()
 {
     //loading grid control
     _gr    = (FI.UI.Web.Controls.FIDataTableGrid)Page.LoadControl("Controls/FIDataTableGrid.ascx");
     _gr.ID = "ContactsGrid";
     _gr.PrimaryKeyColumnArray   = new string[] { "id" };
     _gr.ColumnNameArray         = new string[] { "name", "email", "distr_format" };
     _gr.ColumnCaptionArray      = new string[] { "Name", "EMail", "Distribution Format" };
     _gr.ColumnWidthArray        = new int[] { 200, 300, 200 };
     _gr.EnableSort              = true;
     _gr.EnableMultipleSelection = true;
     _gr.EnablePages             = true;
     _gr.DefaultPageSize         = 20;
     _gr.DataSourceDelegate      = new FI.UI.Web.Controls.FIDataTableGrid.GridDataSourceDelegate(_user.ContactSystem.GetContactsPage);
     ControlPanel.Controls.Add(_gr);
     //end loading grid control
 }
        private void LoadReportPanel()
        {
            //loading grid control

            _gr = (FI.UI.Web.Controls.FIDataTableGrid)Page.LoadControl("../Controls/FIDataTableGrid.ascx");
            _gr.DefaultPageSize         = 20;
            _gr.InMemory                = true;
            _gr.DataSource              = _user.ReportSystem.GetReportHeaders(typeof(FI.BusinessObjects.OlapReport));
            _gr.EnableMultipleSelection = false;
            _gr.PrimaryKeyColumnArray   = new string[] { "id" };
            _gr.ColumnNameArray         = new string[] { "name", "description", "owner_name", "timestamp" };
            _gr.ColumnCaptionArray      = new string[] { "Name", "Description", "Owner", "Timestamp" };
            _gr.ColumnWidthArray        = new int[] { 150, 350, 100, 85 };
            _gr.EnableCheckBoxes        = true;
            _gr.EnablePages             = true;
            ReportPanel.Controls.Add(_gr);
        }
Ejemplo n.º 10
0
        private void CreateGridControl()
        {
            //loading grid control
            _gr    = (FI.UI.Web.Controls.FIDataTableGrid)Page.LoadControl("../Controls/FIDataTableGrid.ascx");
            _gr.ID = "DQueueGr";
            _gr.PrimaryKeyColumnArray = new string[] { "Id", "UserId", "ReportId", "ReportTypeCode" };
            _gr.ColumnNameArray       =
                new string[] {
                "LastTimestamp", "CheckStatus", "LastStatus", "LastMessage", "IsQueued",
                "ScheduleType", "ScheduleValue",
                "Domain", "UserName",
                "ReportType", "ReportName", "ReportDescr",
                "Contact", "ContactEmail",
                "OkCount", "OkLastDuration", "OkAvgDuration",
                "CancelCount", "CancelAvgDuration",
                "ErrorCount"
            };
            _gr.ColumnCaptionArray = _gr.ColumnNameArray;
            _gr.ColumnWidthArray   =
                new int[] {
                100, 100, 80, 200, 80,
                80, 80,
                80, 80,
                80, 100, 200,
                80, 80,
                80, 100, 100,
                80, 100,
                80
            };
            _gr.EnableCheckBoxes        = true;
            _gr.EnableMultipleSelection = true;
            _gr.EnablePages             = true;
            _gr.DefaultPageSize         = 100;
            _gr.EnableSort = true;
            _gr.InMemory   = true;
            if (_gr.Sort.Count == 0)
            {
                //_gr.Sort.Add("CheckStatus", "DESC");
                _gr.Sort.Add("LastTimestamp", "DESC");
                _gr.Sort.Add("IsQueued", "DESC");
            }

            ControlPanel.Controls.Add(_gr);
            //end loading grid control
        }
Ejemplo n.º 11
0
 private void LoadGridControl()
 {
     //loading grid control
     _gr    = (FI.UI.Web.Controls.FIDataTableGrid)Page.LoadControl("Controls/FIDataTableGrid.ascx");
     _gr.ID = "ContactsGrid";
     _gr.PrimaryKeyColumnArray   = new string[] { "Id" };
     _gr.ColumnNameArray         = new string[] { "Logon", "Name", "Email", "IsAdmin" };
     _gr.ColumnCaptionArray      = new string[] { "Logon", "Name", "Email", "IsAdmin" };
     _gr.ColumnWidthArray        = new int[] { 200, 200, 200, 50 };
     _gr.EnableSort              = true;
     _gr.EnableMultipleSelection = true;
     _gr.EnablePages             = true;
     _gr.DefaultPageSize         = 20;
     _gr.InMemory   = true;
     _gr.DataSource = _user.GetSystemUsers();
     ControlPanel.Controls.Add(_gr);
     //end loading grid control
 }
 private void LoadGridControl()
 {
     //loading grid control
     _gr    = (FI.UI.Web.Controls.FIDataTableGrid)Page.LoadControl("../Controls/FIDataTableGrid.ascx");
     _gr.ID = "DQueueGr";
     _gr.PrimaryKeyColumnArray   = new string[] { "log_id", "distribution_id" };
     _gr.ColumnNameArray         = new string[] { "distribution_id", "company_name", "user_name", "timestamp", "status", "duration", "message", "rpt_type", "rpt_name", "rpt_description", "contact_name", "contact_email" };
     _gr.ColumnCaptionArray      = new string[] { "Id", "Domain", "User", "Timestamp", "Status", "Duration(sec)", "Message", "Report Type", "Report Name", "Report Descr.", "Contact Name", "Contact Email" };
     _gr.ColumnWidthArray        = new int[] { 30, 100, 100, 100, 50, 80, 200, 100, 150, 150, 150, 150 };
     _gr.EnableCheckBoxes        = true;
     _gr.EnableMultipleSelection = true;
     _gr.EnablePages             = true;
     _gr.DefaultPageSize         = 25;
     _gr.EnableSort         = true;
     _gr.DataSourceDelegate = new FI.UI.Web.Controls.FIDataTableGrid.GridDataSourceDelegate(GetMasterDistributionQueuePage);
     ControlPanel.Controls.Add(_gr);
     //end loading grid control
 }
Ejemplo n.º 13
0
        private void LoadSharingPanel()
        {
            SharingPanel.Controls.Clear();

            //loading grid control
            _gr    = (FI.UI.Web.Controls.FIDataTableGrid)Page.LoadControl("Controls/FIDataTableGrid.ascx");
            _gr.ID = "SharingGrid";
            _gr.DefaultPageSize         = 15;
            _gr.InMemory                = true;
            _gr.DataSource              = GetUsersWithChildReports();
            _gr.PrimaryKeyColumnArray   = new string[] { "user_id", "report_id" };
            _gr.ColumnNameArray         = new string[] { "name", "sharing_string" };
            _gr.ColumnCaptionArray      = new string[] { "User Name", "Sharing" };
            _gr.ColumnWidthArray        = new int[] { 200, 150 };
            _gr.EnableMultipleSelection = true;
            _gr.EnablePages             = true;
            SharingPanel.Controls.Add(_gr);
        }
 private void LoadGridControl()
 {
     //loading grid control
     _gr = (FI.UI.Web.Controls.FIDataTableGrid)Page.LoadControl("../Controls/FIDataTableGrid.ascx");
     _gr.ID="ProcInfoGr";
     _gr.PrimaryKeyColumnArray=new string[] {"TcpPort"};
     _gr.ColumnNameArray=new string[] {"Server", "Database", "State", "AllocatedSpan" , "TaskId", "TaskTag"};
     _gr.ColumnCaptionArray=new string[] {"Server", "Database", "State", "AllocatedSpan" , "TaskId", "TaskTag"};
     _gr.ColumnWidthArray=new int[] {100, 100, 100, 100 , 150 , 250};
     _gr.EnableCheckBoxes=false;
     _gr.EnableMultipleSelection=false;
     _gr.EnablePages=false;
     //_gr.DefaultPageSize=50;
     _gr.EnableSort=true;
     _gr.EnableFilter=false;
     _gr.InMemory=true;
     _gr.DataSource=FI.BusinessObjects.BusinessFacade.Instance.GetOlapProcessorInfo();
     ControlPanel.Controls.Add(_gr);
     //end loading grid control
 }
Ejemplo n.º 15
0
 private void LoadGridControl()
 {
     //loading grid control
     _gr    = (FI.UI.Web.Controls.FIDataTableGrid)Page.LoadControl("../Controls/FIDataTableGrid.ascx");
     _gr.ID = "ProcInfoGr";
     _gr.PrimaryKeyColumnArray   = new string[] { "TcpPort" };
     _gr.ColumnNameArray         = new string[] { "Server", "Database", "State", "AllocatedSpan", "TaskId", "TaskDescription" };
     _gr.ColumnCaptionArray      = new string[] { "Server", "Database", "State", "AllocatedSpan", "TaskId", "TaskDescription" };
     _gr.ColumnWidthArray        = new int[] { 100, 100, 100, 100, 150, 250 };
     _gr.EnableCheckBoxes        = false;
     _gr.EnableMultipleSelection = false;
     _gr.EnablePages             = false;
     //_gr.DefaultPageSize=50;
     _gr.EnableSort   = true;
     _gr.EnableFilter = false;
     _gr.InMemory     = true;
     _gr.DataSource   = FI.BusinessObjects.BusinessFacade.Instance.GetOlapProcessorInfo();
     ControlPanel.Controls.Add(_gr);
     //end loading grid control
 }
        private void LoadDistributionPanel()
        {
            //loading grid control
            _gr    = (FI.UI.Web.Controls.FIDataTableGrid)Page.LoadControl("Controls/FIDataTableGrid.ascx");
            _gr.ID = "DistrGrid";
            _gr.DefaultPageSize         = 15;
            _gr.DataSourceDelegate      = new FI.UI.Web.Controls.FIDataTableGrid.GridDataSourceDelegate(GetDistributionsWithContactsPage);
            _gr.PrimaryKeyColumnArray   = new string[] { "contact_id", "distribution_id" };
            _gr.ColumnNameArray         = new string[] { "name", "email", "format", "distr_format", "freq_type", "freq_value" };
            _gr.ColumnCaptionArray      = new string[] { "Contact Name", "Contact EMail", "Format", "EMail View", "Frequency Type", "Frequency Value" };
            _gr.ColumnWidthArray        = new int[] { 150, 200, 75, 125, 100, 250 };
            _gr.EnableMultipleSelection = true;
            DistributionPanel.Controls.Add(_gr);

            // load export types
            this.ddlFormat.Items.Clear();
            string[] names = Enum.GetNames(typeof(Report.ExportFormat));
            foreach (string name in names)
            {
                this.ddlFormat.Items.Add(name);
            }
        }
Ejemplo n.º 17
0
        private void LoadReportPanel()
        {
            // load table
            _reportProxy.LoadHeader();
            FI.Common.Data.FIDataTable rptTable = new FI.Common.Data.FIDataTable();
            rptTable.Columns.Add("name", typeof(string));
            rptTable.Columns.Add("description", typeof(string));
            rptTable.Rows.Add(new object[] { _reportProxy.Name, _reportProxy.Description });

            //loading grid control
            _rptGr                    = (FI.UI.Web.Controls.FIDataTableGrid)Page.LoadControl("../Controls/FIDataTableGrid.ascx");
            _rptGr.InMemory           = true;
            _rptGr.DataSource         = rptTable;
            _rptGr.ColumnNameArray    = new string[] { "name", "description" };
            _rptGr.ColumnCaptionArray = new string[] { "Report Name", "Description" };
            _rptGr.ColumnWidthArray   = new int[] { 200, 400 };
            _rptGr.EnableSort         = false;
            _rptGr.EnableFilter       = false;
            _rptGr.EnableCheckBoxes   = false;
            _rptGr.EnablePages        = false;
            ReportPanel.Controls.Add(_rptGr);
        }
        private void LoadReportPanel()
        {
            // load table
            _reportProxy.LoadHeader();
            FI.Common.Data.FIDataTable rptTable=new FI.Common.Data.FIDataTable();
            rptTable.Columns.Add("name" , typeof(string));
            rptTable.Columns.Add("description" , typeof(string));
            rptTable.Rows.Add(new object[] {_reportProxy.Name , _reportProxy.Description});

            //loading grid control
            _rptGr = (FI.UI.Web.Controls.FIDataTableGrid)Page.LoadControl("Controls/FIDataTableGrid.ascx");
            _rptGr.ID="RptGrid";
            _rptGr.InMemory=true;
            _rptGr.DataSource=rptTable;
            _rptGr.ColumnNameArray=new string[] {"name" , "description" };
            _rptGr.ColumnCaptionArray=new string[] {"Report Name" , "Description"};
            _rptGr.ColumnWidthArray=new int[] {200 , 400};
            _rptGr.EnableSort=false;
            _rptGr.EnableFilter=false;
            _rptGr.EnableCheckBoxes=false;
            _rptGr.EnablePages=false;
            ReportPanel.Controls.Add(_rptGr);
        }
        private void LoadDistributionPanel()
        {
            //loading grid control
            _gr = (FI.UI.Web.Controls.FIDataTableGrid)Page.LoadControl("Controls/FIDataTableGrid.ascx");
            _gr.ID="DistrGrid";
            _gr.DefaultPageSize=15;
            _gr.DataSourceDelegate=new FI.UI.Web.Controls.FIDataTableGrid.GridDataSourceDelegate(GetDistributionsWithContactsPage);
            _gr.PrimaryKeyColumnArray=new string[] {"contact_id" , "distribution_id"};
            _gr.ColumnNameArray=new string[] {"name" , "email" , "format", "distr_format" , "freq_type" , "freq_value"};
            _gr.ColumnCaptionArray=new string[] {"Contact Name" , "Contact EMail" , "Format", "EMail View" , "Frequency Type" , "Frequency Value" };
            _gr.ColumnWidthArray=new int[] {150 , 200 , 75, 125 , 100 , 250};
            _gr.EnableMultipleSelection=true;
            DistributionPanel.Controls.Add(_gr);

            // load export types
            this.ddlFormat.Items.Clear();
            string[] names=Enum.GetNames(typeof(Report.ExportFormat));
            foreach(string name in names)
                this.ddlFormat.Items.Add(name);
        }
        private void LoadReportPanel()
        {
            // load table
            _report.LoadHeader();
            FI.Common.Data.FIDataTable rptTable=new FI.Common.Data.FIDataTable();
            rptTable.Columns.Add("name" , typeof(string));
            rptTable.Columns.Add("description" , typeof(string));
            rptTable.Rows.Add(new object[] {_report.Name , _report.Description});

            //loading grid control
            _rptGr = (FI.UI.Web.Controls.FIDataTableGrid)Page.LoadControl("Controls/FIDataTableGrid.ascx");
            _rptGr.ID="RptGrid";
            _rptGr.InMemory=true;
            _rptGr.DataSource=rptTable;
            _rptGr.ColumnNameArray=new string[] {"name" , "description" };
            _rptGr.ColumnCaptionArray=new string[] {"Report Name" , "Description"};
            _rptGr.ColumnWidthArray=new int[] {200 , 400};
            _rptGr.EnableSort=false;
            _rptGr.EnableFilter=false;
            _rptGr.EnableCheckBoxes=false;
            _rptGr.EnablePages=false;
            ReportPanel.Controls.Add(_rptGr);

            // if shared report	, saving is disabled
            if(_report.SharingStatus==Report.SharingEnum.InheriteSubscriber || _report.SharingStatus==Report.SharingEnum.SnapshotSubscriber)
                this.radioSave.Enabled=false;

            //load values into text fields
            string name=((string)rptTable.Rows[0]["name"]).Trim();
            name=(name.Length>42?name.Substring(0,42):name);
            txtName.Text="Copy of " + name;
            txtDescription.Text=((string)rptTable.Rows[0]["description"]).Trim();
        }
        private void CreateGridControl()
        {
            //loading grid control
            _gr = (FI.UI.Web.Controls.FIDataTableGrid)Page.LoadControl("../Controls/FIDataTableGrid.ascx");
            _gr.ID="DQueueGr";
            _gr.PrimaryKeyColumnArray=new string[] {"Id", "UserId", "ReportId", "ReportTypeCode"};
            _gr.ColumnNameArray=
                new string[] {
                                "LastTimestamp", "CheckStatus", "LastStatus", "LastMessage", "IsQueued",
                                "ScheduleType", "ScheduleValue",
                                "Domain", "UserName",
                                 "ReportType", "ReportName" , "ReportDescr",
                                 "Contact" , "ContactEmail" ,
                                "OkCount", "OkLastDuration", "OkAvgDuration",
                                "CancelCount", "CancelAvgDuration",
                                "ErrorCount"
                };
            _gr.ColumnCaptionArray=_gr.ColumnNameArray;
            _gr.ColumnWidthArray=
                new int[] {
                              100, 100, 80 , 200, 80 ,
                              80, 80,
                              80 , 80 ,
                              80, 100 , 200 ,
                              80, 80 ,
                              80, 100 , 100,
                              80, 100 ,
                              80
                          };
            _gr.EnableCheckBoxes=true;
            _gr.EnableMultipleSelection=true;
            _gr.EnablePages=true;
            _gr.DefaultPageSize=100;
            _gr.EnableSort=true;
            _gr.InMemory=true;
            if(_gr.Sort.Count==0)
            {
                //_gr.Sort.Add("CheckStatus", "DESC");
                _gr.Sort.Add("LastTimestamp", "DESC");
                _gr.Sort.Add("IsQueued", "DESC");
            }

            ControlPanel.Controls.Add(_gr);
            //end loading grid control
        }
        private void LoadControls()
        {
            // _ddlUniqueName
            _ddlUniqueName=new Controls.FIDropDownControl();
            _ddlUniqueName.CssClass="tbl1_edit";
            this.pnlSourceMember.Controls.Add(_ddlUniqueName);

            // listFormat
            foreach(string format in Enum.GetNames(typeof(FI.BusinessObjects.Olap.CalculatedMember.FormatEnum)))
                this.listFormat.Items.Add(format);

            //  formatted members grid
            _gridFormattedMembers = (FI.UI.Web.Controls.FIDataTableGrid)Page.LoadControl("../Controls/FIDataTableGrid.ascx");
            _gridFormattedMembers.ID="gridFormattedMembers";
            _gridFormattedMembers.EnablePages=true;
            _gridFormattedMembers.DefaultPageSize=15;
            _gridFormattedMembers.EnableUpdatePager=false;
            _gridFormattedMembers.InMemory=true;
            _gridFormattedMembers.PrimaryKeyColumnArray=new string[] {"uniquename"};
            _gridFormattedMembers.ColumnNameArray=new string[] {"hierarchy", "default_name", "name", "format"};
            _gridFormattedMembers.ColumnCaptionArray=new string[] {"Hierarchy" , "Default Name",  "Name", "Format" };
            _gridFormattedMembers.ColumnWidthArray=new int[] {150 , 200, 200, 80};
            _gridFormattedMembers.EnableMultipleSelection=true;
            this.pnlFormattedMembers.Controls.Add(_gridFormattedMembers);
        }
 private void LoadGridControl()
 {
     //loading grid control
     _gr = (FI.UI.Web.Controls.FIDataTableGrid)Page.LoadControl("Controls/FIDataTableGrid.ascx");
     _gr.ID="ContactsGrid";
     _gr.PrimaryKeyColumnArray=new string[] {"id"};
     _gr.ColumnNameArray=new string[] {"name" , "email" , "distr_format"};
     _gr.ColumnCaptionArray=new string[] {"Name" , "EMail" , "Distribution Format" };
     _gr.ColumnWidthArray=new int[] {200 , 300 , 200};
     _gr.EnableSort=true;
     _gr.EnableMultipleSelection=true;
     _gr.EnablePages=true;
     _gr.DefaultPageSize=20;
     _gr.DataSourceDelegate=new FI.UI.Web.Controls.FIDataTableGrid.GridDataSourceDelegate(_user.ContactSystem.GetContactsPage);
     ControlPanel.Controls.Add(_gr);
     //end loading grid control
 }
        private void LoadReportPanel()
        {
            //loading grid control

            _gr = (FI.UI.Web.Controls.FIDataTableGrid)Page.LoadControl("../Controls/FIDataTableGrid.ascx");
            _gr.DefaultPageSize=20;
            _gr.InMemory=true;
            _gr.DataSource=_user.ReportSystem.GetReportHeaders(typeof(FI.BusinessObjects.OlapReport));
            _gr.EnableMultipleSelection=false;
            _gr.PrimaryKeyColumnArray=new string[] {"id"};
            _gr.ColumnNameArray=new string[] {"name" , "description" , "owner_name" , "timestamp"};
            _gr.ColumnCaptionArray=new string[] {"Name" , "Description" , "Owner", "Timestamp" };
            _gr.ColumnWidthArray=new int[] {150 , 350 , 100, 85};
            _gr.EnableCheckBoxes=true;
            _gr.EnablePages=true;
            ReportPanel.Controls.Add(_gr);
        }
Ejemplo n.º 25
0
        private void LoadGrid()
        {
            //loading grid control
            _gr = (FI.UI.Web.Controls.FIDataTableGrid)Page.LoadControl("../Controls/FIDataTableGrid.ascx");
            _gr.ID="ProductsGrid";
            _gr.DefaultPageSize=15;
            _gr.DataSourceDelegate=new FI.UI.Web.Controls.FIDataTableGrid.GridDataSourceDelegate(GetReportPage);
            //_gr.PrimaryKeyColumnArray=new string[] {"prodsern"};
            _gr.ColumnNameArray=new string[] {"SALMNAME", "CCHNAME" , "CHNNAME" , "COMNAME" , "COMCITY" , "COMPCODE" , "COMADDR" , "DELDATE"};
            _gr.ColumnCaptionArray=new string[] {"Salesman" , "Centr. Chain" ,  "Chain" , "Store" , "City", "Post. Code" , "Address" , "Last Transact."};
            _gr.ColumnWidthArray=new int[] {150 , 150 , 150 , 150 , 100 , 75 , 150 , 75 };
            _gr.EnableCheckBoxes=false;
            _gr.EnablePages=true;
            _gr.FilterChanged+=new EventHandler(_gr_FilterChanged);

            // assign report filter
            foreach(string colName in _gr.ColumnNameArray)
            {
                string val=_report.GetFilterItem(colName);
                if(val!=null)
                    _gr.Filter[colName]=val;
                else
                    _gr.Filter.Remove(colName);
            }

            this.cellContents.Controls.Add(_gr);
        }
 private void LoadGridControl()
 {
     //loading grid control
     _gr = (FI.UI.Web.Controls.FIDataTableGrid)Page.LoadControl("Controls/FIDataTableGrid.ascx");
     _gr.ID="DQueueGr";
     _gr.PrimaryKeyColumnArray=new string[] {"log_id", "distribution_id"};
     _gr.ColumnNameArray=new string[] {"distribution_id", "timestamp" , "status" , "duration", "message" , "rpt_type" , "rpt_name" , "rpt_description", "contact_name" , "contact_email"};
     _gr.ColumnCaptionArray=new string[] {"Id", "Timestamp" , "Status", "Duration(sec)", "Message" , "Report Type",  "Report Name" , "Report Descr.", "Contact Name" , "Contact Email"};
     _gr.ColumnWidthArray=new int[] {30, 100 , 50 , 80, 200 , 100 , 150 , 150 , 150 , 150 };
     _gr.EnableSort=true;
     _gr.EnableCheckBoxes=true;
     _gr.EnableMultipleSelection=true;
     _gr.EnablePages=true;
     _gr.DefaultPageSize=25;
     _gr.DataSourceDelegate=new FI.UI.Web.Controls.FIDataTableGrid.GridDataSourceDelegate(GetDistributionQueuePage);
     ControlPanel.Controls.Add(_gr);
     //end loading grid control
 }
 private void LoadProductsGrid()
 {
     //loading grid control
     _gr = (FI.UI.Web.Controls.FIDataTableGrid)Page.LoadControl("../Controls/FIDataTableGrid.ascx");
     _gr.ID="ProductsGrid";
     _gr.DefaultPageSize=15;
     _gr.DataSourceDelegate=new FI.UI.Web.Controls.FIDataTableGrid.GridDataSourceDelegate(GetSppProductsPage);
     _gr.PrimaryKeyColumnArray=new string[] {"prodsern"};
     _gr.ColumnNameArray=new string[] {"prodname" , "prodsname" , "prodcode" , "proddunc", "prodeanc" , "prodprice", "prodcps", "prodcpu" , "prodsize" , "prodpallet"};
     _gr.ColumnCaptionArray=new string[] {"Name" , "Short Name" ,  "Code" , "DUN Code" , "EAN Code", "Price" , "Cons Pkg Size" , "Units", "Case Size" , "Pallet Size"};
     _gr.ColumnWidthArray=new int[] {200 , 100 , 100 , 100 , 100 , 75 , 75 , 75 , 75 , 75};
     _gr.EnableMultipleSelection=true;
     _gr.EnablePages=true;
     this.cellContents.Controls.Add(_gr);
 }
        private void LoadSharingPanel()
        {
            SharingPanel.Controls.Clear();

            //loading grid control
            _gr = (FI.UI.Web.Controls.FIDataTableGrid)Page.LoadControl("Controls/FIDataTableGrid.ascx");
            _gr.ID="SharingGrid";
            _gr.DefaultPageSize=15;
            _gr.InMemory=true;
            _gr.DataSource=GetUsersWithChildReports();
            _gr.PrimaryKeyColumnArray=new string[] {"user_id" , "report_id"};
            _gr.ColumnNameArray=new string[] {"name" , "sharing_string"};
            _gr.ColumnCaptionArray=new string[] {"User Name" , "Sharing" };
            _gr.ColumnWidthArray=new int[] {200 , 150};
            _gr.EnableMultipleSelection=true;
            _gr.EnablePages=true;
            SharingPanel.Controls.Add(_gr);
        }
Ejemplo n.º 29
0
 private void LoadGridControl()
 {
     //loading grid control
     _gr = (FI.UI.Web.Controls.FIDataTableGrid)Page.LoadControl("Controls/FIDataTableGrid.ascx");
     _gr.ID="ContactsGrid";
     _gr.PrimaryKeyColumnArray=new string[] {"Id"};
     _gr.ColumnNameArray=new string[] {"Logon" , "Name" , "Email" , "IsAdmin"};
     _gr.ColumnCaptionArray=new string[] {"Logon" , "Name" , "Email"  , "IsAdmin" };
     _gr.ColumnWidthArray=new int[] {200 , 200 , 200, 50};
     _gr.EnableSort=true;
     _gr.EnableMultipleSelection=true;
     _gr.EnablePages=true;
     _gr.DefaultPageSize=20;
     _gr.InMemory=true;
     _gr.DataSource=_user.GetSystemUsers();
     ControlPanel.Controls.Add(_gr);
     //end loading grid control
 }