示例#1
0
        private void InitializeComponent()
        {
            Document_FpSpread.SelectionBlockOptions = FarPoint.Win.Spread.SelectionBlockOptions.None;
            Document_FpSpread.Cursor = Cursors.Default;

            Document_SheetView.Reset();
            Document_SheetView.Cells[Document_SheetView.Rows.Count - 1, Document_SheetView.Columns.Count - 1].Value = DBNull.Value;
            Document_SheetView.OperationMode       = FarPoint.Win.Spread.OperationMode.ReadOnly;
            Document_SheetView.HorizontalGridLine  = new GridLine(GridLineType.None);
            Document_SheetView.VerticalGridLine    = Document_SheetView.HorizontalGridLine;
            Document_SheetView.RowHeaderVisible    = false;
            Document_SheetView.ColumnHeaderVisible = false;
        }
示例#2
0
        public override void InitializeBSpread()
        {
            RemoveSuperfluousColumns(this.filteredParam);

            this.bsprData.ActiveSheet.RowCount    = 0;
            this.bsprData.ActiveSheet.ColumnCount = 0;

            this.bsprData.ClearHead();
            this.bsprData.AddHeadComplete();
            this.bsprData.UseSpreadEdit       = false;
            this.bsprData.Locked              = true;
            this.bsprData.AutoGenerateColumns = true;

            this.bsprData.DataSource = this.filteredParam;

            foreach (DataTable dt in filteredParam.Tables)
            {
                SheetView sheet = new SheetView();
                sheet.Reset();
                sheet.SheetName = dt.TableName;
                this.bsprData.Sheets.Add(sheet);
                sheet.DataSource = dt;

                for (int cIdx = 0; cIdx < sheet.Columns.Count; cIdx++)
                {
                    sheet.ColumnHeader.Cells[0, cIdx].Text = dt.Columns[cIdx].ToString();
                }
            }

            this.bsprData_Sheet1.Visible = false;

            UpdateRowColor(this.bsprData);

            if (this.isVisibleRawData)
            {
                RemoveSuperfluousColumns(this.filteredRaw);

                this.bsprRawData.ActiveSheet.RowCount    = 0;
                this.bsprRawData.ActiveSheet.ColumnCount = 0;

                this.bsprRawData.ClearHead();
                this.bsprRawData.AddHeadComplete();
                this.bsprRawData.UseSpreadEdit       = false;
                this.bsprRawData.Locked              = true;
                this.bsprRawData.AutoGenerateColumns = true;

                this.bsprRawData.DataSource = filteredRaw;

                foreach (DataTable dt in filteredRaw.Tables)
                {
                    SheetView sheet = new SheetView();
                    sheet.Reset();
                    sheet.SheetName = dt.TableName;
                    this.bsprRawData.Sheets.Add(sheet);
                    sheet.DataSource = dt;

                    for (int cIdx = 0; cIdx < sheet.Columns.Count; cIdx++)
                    {
                        sheet.ColumnHeader.Cells[0, cIdx].Text = dt.Columns[cIdx].ToString();
                    }
                }

                this.bsprRawData_Sheet1.Visible = false;

                UpdateRowColor(this.bsprRawData);
            }
        }