複数行グリッド:行と列の固定

MultiRowコントロールを使用すると、行や列を固定して、それらを常に表示したままグリッドをスクロールすることができます。ExcelやFlexGridコントロールと同様に、固定されたセルも通常のセルとして編集したり選択することができます。次の例では、最初の行グループと列グループを固定するかどうかを切り替えることができます。

import 'bootstrap.css'; import '@grapecity/wijmo.styles/wijmo.css'; import './styles.css'; import * as wjMultiRow from '@grapecity/wijmo.grid.multirow'; import { generateAppData } from './data'; // document.readyState === 'complete' ? init() : window.onload = init; // function init() { let appData = generateAppData(); let freezeMultirow = new wjMultiRow.MultiRow('#freezeMultirow', { itemsSource: appData.orders, layoutDefinition: appData.ldTwoLines }); document.getElementById('btnFreeze').addEventListener('click', function (e) { freezeMultirow.frozenColumns = freezeMultirow.frozenColumns ? 0 : 2; freezeMultirow.frozenRows = freezeMultirow.frozenRows ? 0 : 2; e.target.textContent = freezeMultirow.frozenRows == 0 ? '行列の固定' : '行列固定の解除'; }); } <!DOCTYPE html> <html lang="en"> <head> <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <title>GrapeCity Wijmo MultiRow Row and Column Freezing</title> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <!-- SystemJS --> <script src="node_modules/systemjs/dist/system.src.js"></script> <script src="systemjs.config.js"></script> <script> System.import('./src/app'); </script> </head> <body> <div class="container-fluid"> <div id="freezeMultirow"></div> <br /> <button class="btn btn-default" id="btnFreeze"> 行列の固定 </button> </div> </body> </html> import * as wjCore from '@grapecity/wijmo'; import * as wjGrid from '@grapecity/wijmo.grid'; export function generateAppData() { // create some data let appData = {}, customers = [], firstNames = '佐藤,鈴木,高橋,田中,伊藤,山本,渡辺,中村,小林,加藤,吉田,山田,佐々木,山口,松本,井上,木村,斎藤,林,清水,山崎,阿部,森,池田,橋本,山下,石川,中島,前田,藤田'.split(','), lastNames = '浩,誠,健一,大輔,達也,翔太,浩一,哲也,剛,大介,健太,拓也,豊,修,和彦,学,直樹,健太郎,浩二,徹,隆,亮,翔,恵子,久美子,由美子,明美,直美,陽子,智子,絵美,恵,裕子,愛,真由美,由美,麻衣,美穂,愛美,彩'.split(','), cities = '東京都,神奈川県,大阪府,愛知県'.split(','), states = '日本'.split(','); for (let i = 0; i < 50; i++) { let first = firstNames[randBetween(0, firstNames.length - 1)], last = lastNames[randBetween(0, lastNames.length - 1)]; customers.push({ id: i, name: first + ' ' + last, address: `${String.fromCharCode(randBetween(65, 90))}市${String.fromCharCode(randBetween(65, 90))}町${randBetween(1, 10)}-${randBetween(1, 10)}-${randBetween(1, 10)}`, city: cities[randBetween(0, cities.length - 1)], state: states[randBetween(0, states.length - 1)], zip: wjCore.format('{p1:d3}-{p2:d4}', { p1: randBetween(100, 999), p2: randBetween(0, 9999) }), email: 'cust@x.com', phone: wjCore.format('090-{p1:d4}-{p2:d4}', { p1: randBetween(1000, 9999), p2: randBetween(1000, 9999) }) }); } let cityMap = new wjGrid.DataMap(cities); let shippers = [ { id: 0, name: 'アカネコ', email: 'ship1@x.com', phone: '03-3955-98xx', express: true }, { id: 1, name: 'トマト', email: 'ship2@x.com', phone: '03-3681-31xx', express: true }, { id: 2, name: 'ペンギン', email: 'ship3@x.com', phone: '03-3566-99xx', express: false } ]; let orders = []; let today = new Date(); for (let i = 0; i < 20; i++) { let shipped = wjCore.DateTime.addDays(today, -randBetween(1, 3000)); orders.push({ id: i, date: wjCore.DateTime.addDays(shipped, -randBetween(1, 5)), shippedDate: shipped, amount: randBetween(10000, 500000) / 100, customer: customers[randBetween(0, customers.length - 1)], shipper: shippers[randBetween(0, shippers.length - 1)] }); } function randBetween(min, max) { return Math.floor(Math.random() * (max - min + 1) + min); } // expose orders CollectionView to the app appData.orders = new wjCore.CollectionView(orders); // expose grouped orders CollectionView to the app appData.groupedOrders = new wjCore.CollectionView(orders, { groupDescriptions: [ 'customer.city' ] }); // expose paged orders CollectionView to the app appData.pagedOrders = new wjCore.CollectionView(orders, { pageSize: 4 }); // expose addNew oders CollectionView to the app appData.addNewOrders = new wjCore.CollectionView(orders, { newItemCreator: function () { return { customer: {}, shipper: {} }; }, }); appData.addNewOrders.moveCurrentToLast(); // refresh views when data source changes let ordersRefreshing = false; appData.orders.collectionChanged.addHandler(function () { ordersRefreshing = true; if (!pagedOrdersRefreshing) { appData.pagedOrders.refresh(); } if (!groupedOrdersRefreshing) { appData.groupedOrders.refresh(); } if (!addNewOrdersRefreshing) { appData.addNewOrders.refresh(); } ordersRefreshing = false; }); // addNew orders let addNewOrdersRefreshing = false; appData.addNewOrders.collectionChanged.addHandler(function () { addNewOrdersRefreshing = true; if (!ordersRefreshing) { appData.orders.refresh(); } if (!pagedOrdersRefreshing) { appData.pagedOrders.refresh(); } if (!groupedOrdersRefreshing) { appData.groupedOrders.refresh(); } addNewOrdersRefreshing = false; }); // grouped orders let groupedOrdersRefreshing = false; appData.groupedOrders.collectionChanged.addHandler(function () { groupedOrdersRefreshing = true; if (!ordersRefreshing) { appData.orders.refresh(); } if (!pagedOrdersRefreshing) { appData.pagedOrders.refresh(); } if (!addNewOrdersRefreshing) { appData.addNewOrders.refresh(); } groupedOrdersRefreshing = false; }); // paged orders let pagedOrdersRefreshing = false; appData.pagedOrders.collectionChanged.addHandler(function () { pagedOrdersRefreshing = true; if (!ordersRefreshing) { appData.orders.refresh(); } if (!addNewOrdersRefreshing) { appData.addNewOrders.refresh(); } if (!groupedOrdersRefreshing) { appData.groupedOrders.refresh(); } pagedOrdersRefreshing = false; }); // sample layout definitions appData.ldOneLine = [ { cells: [{ binding: 'id', header: 'ID', cssClass: 'id', isReadOnly: true }] }, { cells: [{ binding: 'date', header: '受注日' }] }, { cells: [{ binding: 'shippedDate', header: '出荷日' }] }, { cells: [{ binding: 'amount', header: '金額', format: 'c', cssClass: 'amount' }] }, { cells: [{ binding: 'customer.name', header: '顧客名' }] }, { cells: [{ binding: 'customer.address', header: '住所', wordWrap: true }] }, { cells: [{ binding: 'customer.city', header: '都道府県', dataMap: cityMap }] }, { cells: [{ binding: 'customer.state', header: '国', width: 45 }] }, { cells: [{ binding: 'customer.zip', header: '郵便番号' }] }, { cells: [{ binding: 'customer.email', header: '顧客のメール', cssClass: 'email' }] }, { cells: [{ binding: 'customer.phone', header: '顧客の電話番号' }] }, { cells: [{ binding: 'shipper.name', header: '運送業者' }] }, { cells: [{ binding: 'shipper.email', header: '運送業者のメール', cssClass: 'email' }] }, { cells: [{ binding: 'shipper.phone', header: '運送業者の電話番号' }] }, { cells: [{ binding: 'shipper.express', header: '速達' }] } ]; appData.ldTwoLines = [ { header: '受注', colspan: 2, cells: [ { binding: 'id', header: 'ID', cssClass: 'id', isReadOnly: true }, { binding: 'date', header: '受注日' }, { binding: 'amount', header: '金額', format: 'c', cssClass: 'amount' }, { binding: 'shippedDate', header: '出荷日' } ] }, { header: '顧客', colspan: 3, cells: [ { binding: 'customer.name', header: '顧客' }, { binding: 'customer.email', header: 'メール', colspan: 2, cssClass: 'email' }, { binding: 'customer.address', header: '住所' }, { binding: 'customer.city', header: '都道府県', dataMap: cityMap }, { binding: 'customer.state', header: '国', width: 45 } ] }, { header: '運送業者', cells: [ { binding: 'shipper.name', header: '運送業者', colspan: 2 }, { binding: 'shipper.email', header: 'メール', cssClass: 'email' }, { binding: 'shipper.express', header: '速達' } ] } ]; appData.ldThreeLines = [ { header: '受注', colspan: 2, cells: [ { binding: 'id', header: 'ID', colspan: 2, cssClass: 'id' }, { binding: 'amount', header: '金額', format: 'c', colspan: 2, cssClass: 'amount' }, { binding: 'date', header: '受注日' }, { binding: 'shippedDate', header: '出荷日' } ] }, { header: '顧客', colspan: 3, cells: [ { binding: 'customer.name', header: '顧客' }, { binding: 'customer.email', header: 'メール', colspan: 2, cssClass: 'email' }, { binding: 'customer.address', header: '住所', colspan: 2 }, { binding: 'customer.phone', header: '電話番号' }, { binding: 'customer.city', header: '都道府県', dataMap: cityMap }, { binding: 'customer.state', header: '国', width: 45 }, { binding: 'customer.zip', header: '郵便番号' }, ] }, { header: '運送業者', cells: [ { binding: 'shipper.name', header: '運送業者' }, { binding: 'shipper.email', header: 'メール', cssClass: 'email' }, { binding: 'shipper.express', header: '速達' } ] } ]; appData.layoutDefs = new wjCore.CollectionView([ { name: '従来のレイアウト', description: '従来のグリッドのように、1レコードを1行で表示します。ユーザーはレコード全体を見るには水平方向にスクロールする必要があります。', def: appData.ldOneLine }, { name: 'コンパクトなレイアウト', description: 'このビューでは、1レコードを2行で表示します。レイアウトは、注文情報、顧客情報、運送業者情報の3つのグループに分かれています。', def: appData.ldTwoLines }, { name: '詳細なレイアウト', description: 'このビューでは、1レコードを3行で表示します。レイアウトは、注文情報、顧客情報、運送業者情報の3つのグループに分かれています。', def: appData.ldThreeLines } ]); return appData; } .wj-multirow { height: 400px; width: 600px; margin: 6px 0; } /* custom styling for frozen cells */ .wj-flexgrid .wj-cell.wj-frozen:not(.wj-header):not(.wj-group):not(.wj-state-selected):not(.wj-state-multi-selected) { background-color: #f3fbcc; } import 'bootstrap.css'; import '@grapecity/wijmo.styles/wijmo.css'; import './styles.css'; // import * as wjMultirow from '@grapecity/wijmo.grid.multirow'; import { Component, Inject, enableProdMode, NgModule, ViewChild } from '@angular/core'; import { platformBrowserDynamic } from '@angular/platform-browser-dynamic'; import { BrowserModule } from '@angular/platform-browser'; import { WjGridMultirowModule } from '@grapecity/wijmo.angular2.grid.multirow'; import { DataService } from './app.data'; // @Component({ selector: 'app-component', templateUrl: 'src/app.component.html' }) export class AppComponent { @ViewChild('freezeMultirow') freezeMultirow: wjMultirow.MultiRow; orders: any layoutDefinition: any; textContent: string; // DataSvc will be passed by derived classes constructor(@Inject(DataService) private dataService: DataService) { let data = dataService.getData(); this.orders = data.orders; this.layoutDefinition = data.ldTwoLines; this.textContent = '行列の固定'; } // onFreezeClick() { this.freezeMultirow.frozenColumns = this.freezeMultirow.frozenColumns ? 0 : 2; this.freezeMultirow.frozenRows = this.freezeMultirow.frozenRows ? 0 : 2; this.textContent = this.freezeMultirow.frozenRows == 0 ? '行列の固定' : '行列固定の解除'; } } //\\ @NgModule({ imports: [WjGridMultirowModule, BrowserModule], declarations: [AppComponent], providers: [DataService], bootstrap: [AppComponent] }) export class AppModule { } // enableProdMode(); // Bootstrap application with hash style navigation and global services. platformBrowserDynamic().bootstrapModule(AppModule); <!DOCTYPE html> <html lang="en"> <head> <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <title>GrapeCity Wijmo MultiRow Row and Column Freezing</title> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <!-- Polyfills --> <script src="node_modules/core-js/client/shim.min.js"></script> <script src="node_modules/zone.js/dist/zone.min.js"></script> <!-- SystemJS --> <script src="node_modules/systemjs/dist/system.js"></script> <script src="systemjs.config.js"></script> <script> // workaround to load 'rxjs/operators' from the rxjs bundle System.import('rxjs').then(function (m) { System.set(SystemJS.resolveSync('rxjs/operators'), System.newModule(m.operators)); System.import('./src/app.component'); }); </script> </head> <body> <app-component></app-component> </body> </html> <div class="container-fluid"> <wj-multi-row #freezeMultirow [itemsSource]="orders" [layoutDefinition]="layoutDefinition"></wj-multi-row> <br /> <button class="btn btn-default" (click)="onFreezeClick()" [innerHTML]="textContent"> </button> </div> import { Injectable } from '@angular/core'; import * as wjCore from '@grapecity/wijmo'; import * as wjGrid from '@grapecity/wijmo.grid'; interface Cell { binding: string; header: string; cssClass?: string; format?: string; isReadOnly?: boolean; wordWrap?: boolean; width: number; } interface Line { Cells: Cell[]; header?: string; colspan?: number; } export interface AppData { orders: wjCore.CollectionView; groupedOrders: wjCore.CollectionView; pagedOrders: wjCore.CollectionView; addNewOrders: wjCore.CollectionView; ldOneLine: Cell[]; ldTwoLines: Line[]; ldThreeLines: Line[]; layoutDefs: wjCore.CollectionView; } @Injectable() export class DataService { getData(): AppData { // create some data let appData: any = {}, customers = [], firstNames = '佐藤,鈴木,高橋,田中,伊藤,山本,渡辺,中村,小林,加藤,吉田,山田,佐々木,山口,松本,井上,木村,斎藤,林,清水,山崎,阿部,森,池田,橋本,山下,石川,中島,前田,藤田'.split(','), lastNames = '浩,誠,健一,大輔,達也,翔太,浩一,哲也,剛,大介,健太,拓也,豊,修,和彦,学,直樹,健太郎,浩二,徹,隆,亮,翔,恵子,久美子,由美子,明美,直美,陽子,智子,絵美,恵,裕子,愛,真由美,由美,麻衣,美穂,愛美,彩'.split(','), cities = '東京都,神奈川県,大阪府,愛知県'.split(','), states = '日本'.split(','); for (let i = 0; i < 50; i++) { let first = firstNames[randBetween(0, firstNames.length - 1)], last = lastNames[randBetween(0, lastNames.length - 1)]; customers.push({ id: i, name: first + ' ' + last, address: `${String.fromCharCode(randBetween(65, 90))}市${String.fromCharCode(randBetween(65, 90))}町${randBetween(1, 10)}-${randBetween(1, 10)}-${randBetween(1, 10)}`, city: cities[randBetween(0, cities.length - 1)], state: states[randBetween(0, states.length - 1)], zip: wjCore.format('{p1:d3}-{p2:d4}', { p1: randBetween(100, 999), p2: randBetween(0, 9999) }), email: 'cust@x.com', phone: wjCore.format('090-{p1:d4}-{p2:d4}', { p1: randBetween(1000, 9999), p2: randBetween(1000, 9999) }) }); } let cityMap = new wjGrid.DataMap(cities); let shippers = [ { id: 0, name: 'アカネコ', email: 'ship1@x.com', phone: '03-3955-98xx', express: true }, { id: 1, name: 'トマト', email: 'ship2@x.com', phone: '03-3681-31xx', express: true }, { id: 2, name: 'ペンギン', email: 'ship3@x.com', phone: '03-3566-99xx', express: false } ]; let orders = []; let today = new Date(); for (let i = 0; i < 20; i++) { let shipped = wjCore.DateTime.addDays(today, -randBetween(1, 3000)); orders.push({ id: i, date: wjCore.DateTime.addDays(shipped, -randBetween(1, 5)), shippedDate: shipped, amount: randBetween(10000, 500000) / 100, customer: customers[randBetween(0, customers.length - 1)], shipper: shippers[randBetween(0, shippers.length - 1)] }); } function randBetween(min: number, max: number) { return Math.floor(Math.random() * (max - min + 1) + min); } // expose orders CollectionView to the app appData.orders = new wjCore.CollectionView(orders); // expose grouped orders CollectionView to the app appData.groupedOrders = new wjCore.CollectionView(orders, { groupDescriptions: [ 'customer.city' ] }); // expose paged orders CollectionView to the app appData.pagedOrders = new wjCore.CollectionView(orders, { pageSize: 4 }); // expose addNew oders CollectionView to the app appData.addNewOrders = new wjCore.CollectionView(orders, { newItemCreator: function () { return { // add empty customer and shipper objects to new orders customer: {}, shipper: {} } }, }); appData.addNewOrders.moveCurrentToLast(); // refresh views when data source changes let ordersRefreshing = false; appData.orders.collectionChanged.addHandler(function () { ordersRefreshing = true; if (!pagedOrdersRefreshing) { appData.pagedOrders.refresh(); } if (!groupedOrdersRefreshing) { appData.groupedOrders.refresh(); } if (!addNewOrdersRefreshing) { appData.addNewOrders.refresh(); } ordersRefreshing = false; }); // addNew orders let addNewOrdersRefreshing = false; appData.addNewOrders.collectionChanged.addHandler(function () { addNewOrdersRefreshing = true; if (!ordersRefreshing) { appData.orders.refresh(); } if (!pagedOrdersRefreshing) { appData.pagedOrders.refresh(); } if (!groupedOrdersRefreshing) { appData.groupedOrders.refresh(); } addNewOrdersRefreshing = false; }); // grouped orders let groupedOrdersRefreshing = false; appData.groupedOrders.collectionChanged.addHandler(function () { groupedOrdersRefreshing = true; if (!ordersRefreshing) { appData.orders.refresh(); } if (!pagedOrdersRefreshing) { appData.pagedOrders.refresh(); } if (!addNewOrdersRefreshing) { appData.addNewOrders.refresh(); } groupedOrdersRefreshing = false; }); // paged orders let pagedOrdersRefreshing = false; appData.pagedOrders.collectionChanged.addHandler(function () { pagedOrdersRefreshing = true; if (!ordersRefreshing) { appData.orders.refresh(); } if (!addNewOrdersRefreshing) { appData.addNewOrders.refresh(); } if (!groupedOrdersRefreshing) { appData.groupedOrders.refresh(); } pagedOrdersRefreshing = false; }); // sample layout definitions appData.ldOneLine = [ { cells: [{ binding: 'id', header: 'ID', cssClass: 'id', isReadOnly: true }] }, { cells: [{ binding: 'date', header: '受注日' }] }, { cells: [{ binding: 'shippedDate', header: '出荷日' }] }, { cells: [{ binding: 'amount', header: '金額', format: 'c', cssClass: 'amount' }] }, { cells: [{ binding: 'customer.name', header: '顧客名' }] }, { cells: [{ binding: 'customer.address', header: '住所', wordWrap: true }] }, { cells: [{ binding: 'customer.city', header: '都道府県', dataMap: cityMap }] }, { cells: [{ binding: 'customer.state', header: '国', width: 45 }] }, { cells: [{ binding: 'customer.zip', header: '郵便番号' }] }, { cells: [{ binding: 'customer.email', header: '顧客のメール', cssClass: 'email' }] }, { cells: [{ binding: 'customer.phone', header: '顧客の電話番号' }] }, { cells: [{ binding: 'shipper.name', header: '運送業者' }] }, { cells: [{ binding: 'shipper.email', header: '運送業者のメール', cssClass: 'email' }] }, { cells: [{ binding: 'shipper.phone', header: '運送業者の電話番号' }] }, { cells: [{ binding: 'shipper.express', header: '速達' }] } ]; appData.ldTwoLines = [ { header: '受注', colspan: 2, cells: [ { binding: 'id', header: 'ID', cssClass: 'id', isReadOnly: true }, { binding: 'date', header: '受注日' }, { binding: 'amount', header: '金額', format: 'c', cssClass: 'amount' }, { binding: 'shippedDate', header: '出荷日' } ] }, { header: '顧客', colspan: 3, cells: [ { binding: 'customer.name', header: '顧客' }, { binding: 'customer.email', header: 'メール', colspan: 2, cssClass: 'email' }, { binding: 'customer.address', header: '住所' }, { binding: 'customer.city', header: '都道府県', dataMap: cityMap }, { binding: 'customer.state', header: '国', width: 45 } ] }, { header: '運送業者', cells: [ { binding: 'shipper.name', header: '運送業者', colspan: 2 }, { binding: 'shipper.email', header: 'メール', cssClass: 'email' }, { binding: 'shipper.express', header: '速達' } ] } ]; appData.ldThreeLines = [ { header: '受注', colspan: 2, cells: [ { binding: 'id', header: 'ID', colspan: 2, cssClass: 'id' }, { binding: 'amount', header: '金額', format: 'c', colspan: 2, cssClass: 'amount' }, { binding: 'date', header: '受注日' }, { binding: 'shippedDate', header: '出荷日' } ] }, { header: '顧客', colspan: 3, cells: [ { binding: 'customer.name', header: '顧客' }, { binding: 'customer.email', header: 'メール', colspan: 2, cssClass: 'email' }, { binding: 'customer.address', header: '住所', colspan: 2 }, { binding: 'customer.phone', header: '電話番号' }, { binding: 'customer.city', header: '都道府県', dataMap: cityMap }, { binding: 'customer.state', header: '国', width: 45 }, { binding: 'customer.zip', header: '郵便番号' }, ] }, { header: '運送業者', cells: [ { binding: 'shipper.name', header: '運送業者' }, { binding: 'shipper.email', header: 'メール', cssClass: 'email' }, { binding: 'shipper.express', header: '速達' } ] } ]; appData.layoutDefs = new wjCore.CollectionView([ { name: '従来のレイアウト', description: '従来のグリッドのように、1レコードを1行で表示します。ユーザーはレコード全体を見るには水平方向にスクロールする必要があります。', def: appData.ldOneLine }, { name: 'コンパクトなレイアウト', description: 'このビューでは、1レコードを2行で表示します。レイアウトは、注文情報、顧客情報、運送業者情報の3つのグループに分かれています。', def: appData.ldTwoLines }, { name: '詳細なレイアウト', description: 'このビューでは、1レコードを3行で表示します。レイアウトは、注文情報、顧客情報、運送業者情報の3つのグループに分かれています。', def: appData.ldThreeLines } ]); return appData; } } .wj-multirow { height: 400px; width: 600px; margin: 6px 0; } /* custom styling for frozen cells */ .wj-flexgrid .wj-cell.wj-frozen:not(.wj-header):not(.wj-group):not(.wj-state-selected):not(.wj-state-multi-selected) { background-color: #f3fbcc; } import 'bootstrap.css'; import '@grapecity/wijmo.styles/wijmo.css'; import './app.css'; import * as React from 'react'; import * as ReactDOM from 'react-dom'; import * as wjGrid from '@grapecity/wijmo.react.grid.multirow'; import { getData } from './data'; class App extends React.Component { constructor(props) { super(props); this.initSlip = (freezeMultirow) => { this.setState({ freezeMultirow: freezeMultirow }); }; this.onFreezeClick = () => { let freezeMultirow = this.state.freezeMultirow; freezeMultirow.frozenColumns = this.state.freezeMultirow.frozenColumns ? 0 : 2; freezeMultirow.frozenRows = this.state.freezeMultirow.frozenRows ? 0 : 2; this.setState({ freezeMultirow: freezeMultirow, textContent: this.state.freezeMultirow.frozenRows == 0 ? '行列の固定' : '行列固定の解除' }); }; this.state = { orders: getData().orders, layoutDefinition: getData().ldTwoLines, textContent: '行列の固定', freezeMultirow: {} }; } render() { return <div className="container-fluid"> <wjGrid.MultiRow itemsSource={this.state.orders} layoutDefinition={this.state.layoutDefinition} initialized={this.initSlip}></wjGrid.MultiRow> <br /> <button className="btn btn-default" onClick={this.onFreezeClick} dangerouslySetInnerHTML={{ __html: this.state.textContent }}> </button> </div>; } } ReactDOM.render(<App />, document.getElementById('app')); <!DOCTYPE html> <html lang="en"> <head> <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <title>AutoComplete</title> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <!-- SystemJS --> <script src="node_modules/systemjs/dist/system.src.js"></script> <script src="systemjs.config.js"></script> <script> System.import('./src/app'); </script> </head> <body> <div id="app"></div> </body> </html> .wj-multirow { height: 400px; width: 600px; margin: 6px 0; } /* custom styling for frozen cells */ .wj-flexgrid .wj-cell.wj-frozen:not(.wj-header):not(.wj-group):not(.wj-state-selected):not(.wj-state-multi-selected) { background-color: #f3fbcc; } import * as wjCore from '@grapecity/wijmo'; import * as wjGrid from '@grapecity/wijmo.grid'; export function getData() { // create some data let appData = {}, customers = [], firstNames = '佐藤,鈴木,高橋,田中,伊藤,山本,渡辺,中村,小林,加藤,吉田,山田,佐々木,山口,松本,井上,木村,斎藤,林,清水,山崎,阿部,森,池田,橋本,山下,石川,中島,前田,藤田'.split(','), lastNames = '浩,誠,健一,大輔,達也,翔太,浩一,哲也,剛,大介,健太,拓也,豊,修,和彦,学,直樹,健太郎,浩二,徹,隆,亮,翔,恵子,久美子,由美子,明美,直美,陽子,智子,絵美,恵,裕子,愛,真由美,由美,麻衣,美穂,愛美,彩'.split(','), cities = '東京都,神奈川県,大阪府,愛知県'.split(','), states = '日本'.split(','); for (let i = 0; i < 50; i++) { let first = firstNames[randBetween(0, firstNames.length - 1)], last = lastNames[randBetween(0, lastNames.length - 1)]; customers.push({ id: i, name: first + ' ' + last, address: `${String.fromCharCode(randBetween(65, 90))}市${String.fromCharCode(randBetween(65, 90))}町${randBetween(1, 10)}-${randBetween(1, 10)}-${randBetween(1, 10)}`, city: cities[randBetween(0, cities.length - 1)], state: states[randBetween(0, states.length - 1)], zip: wjCore.format('{p1:d3}-{p2:d4}', { p1: randBetween(100, 999), p2: randBetween(0, 9999) }), email: 'cust@x.com', phone: wjCore.format('090-{p1:d4}-{p2:d4}', { p1: randBetween(1000, 9999), p2: randBetween(1000, 9999) }) }); } let cityMap = new wjGrid.DataMap(cities); let shippers = [ { id: 0, name: 'アカネコ', email: 'ship1@x.com', phone: '03-3955-98xx', express: true }, { id: 1, name: 'トマト', email: 'ship2@x.com', phone: '03-3681-31xx', express: true }, { id: 2, name: 'ペンギン', email: 'ship3@x.com', phone: '03-3566-99xx', express: false } ]; let orders = []; let today = new Date(); for (let i = 0; i < 20; i++) { let shipped = wjCore.DateTime.addDays(today, -randBetween(1, 3000)); orders.push({ id: i, date: wjCore.DateTime.addDays(shipped, -randBetween(1, 5)), shippedDate: shipped, amount: randBetween(10000, 500000) / 100, customer: customers[randBetween(0, customers.length - 1)], shipper: shippers[randBetween(0, shippers.length - 1)] }); } function randBetween(min, max) { return Math.floor(Math.random() * (max - min + 1) + min); } // expose orders CollectionView to the app appData.orders = new wjCore.CollectionView(orders); // expose grouped orders CollectionView to the app appData.groupedOrders = new wjCore.CollectionView(orders, { groupDescriptions: [ 'customer.city' ] }); // expose paged orders CollectionView to the app appData.pagedOrders = new wjCore.CollectionView(orders, { pageSize: 4 }); // expose addNew oders CollectionView to the app appData.addNewOrders = new wjCore.CollectionView(orders, { newItemCreator: function () { return { customer: {}, shipper: {} }; }, }); appData.addNewOrders.moveCurrentToLast(); // refresh views when data source changes let ordersRefreshing = false; appData.orders.collectionChanged.addHandler(function () { ordersRefreshing = true; if (!pagedOrdersRefreshing) { appData.pagedOrders.refresh(); } if (!groupedOrdersRefreshing) { appData.groupedOrders.refresh(); } if (!addNewOrdersRefreshing) { appData.addNewOrders.refresh(); } ordersRefreshing = false; }); // addNew orders let addNewOrdersRefreshing = false; appData.addNewOrders.collectionChanged.addHandler(function () { addNewOrdersRefreshing = true; if (!ordersRefreshing) { appData.orders.refresh(); } if (!pagedOrdersRefreshing) { appData.pagedOrders.refresh(); } if (!groupedOrdersRefreshing) { appData.groupedOrders.refresh(); } addNewOrdersRefreshing = false; }); // grouped orders let groupedOrdersRefreshing = false; appData.groupedOrders.collectionChanged.addHandler(function () { groupedOrdersRefreshing = true; if (!ordersRefreshing) { appData.orders.refresh(); } if (!pagedOrdersRefreshing) { appData.pagedOrders.refresh(); } if (!addNewOrdersRefreshing) { appData.addNewOrders.refresh(); } groupedOrdersRefreshing = false; }); // paged orders let pagedOrdersRefreshing = false; appData.pagedOrders.collectionChanged.addHandler(function () { pagedOrdersRefreshing = true; if (!ordersRefreshing) { appData.orders.refresh(); } if (!addNewOrdersRefreshing) { appData.addNewOrders.refresh(); } if (!groupedOrdersRefreshing) { appData.groupedOrders.refresh(); } pagedOrdersRefreshing = false; }); // sample layout definitions appData.ldOneLine = [ { cells: [{ binding: 'id', header: 'ID', cssClass: 'id', isReadOnly: true }] }, { cells: [{ binding: 'date', header: '受注日' }] }, { cells: [{ binding: 'shippedDate', header: '出荷日' }] }, { cells: [{ binding: 'amount', header: '金額', format: 'c', cssClass: 'amount' }] }, { cells: [{ binding: 'customer.name', header: '顧客名' }] }, { cells: [{ binding: 'customer.address', header: '住所', wordWrap: true }] }, { cells: [{ binding: 'customer.city', header: '都道府県', dataMap: cityMap }] }, { cells: [{ binding: 'customer.state', header: '国', width: 45 }] }, { cells: [{ binding: 'customer.zip', header: '郵便番号' }] }, { cells: [{ binding: 'customer.email', header: '顧客のメール', cssClass: 'email' }] }, { cells: [{ binding: 'customer.phone', header: '顧客の電話番号' }] }, { cells: [{ binding: 'shipper.name', header: '運送業者' }] }, { cells: [{ binding: 'shipper.email', header: '運送業者のメール', cssClass: 'email' }] }, { cells: [{ binding: 'shipper.phone', header: '運送業者の電話番号' }] }, { cells: [{ binding: 'shipper.express', header: '速達' }] } ]; appData.ldTwoLines = [ { header: '受注', colspan: 2, cells: [ { binding: 'id', header: 'ID', cssClass: 'id', isReadOnly: true }, { binding: 'date', header: '受注日' }, { binding: 'amount', header: '金額', format: 'c', cssClass: 'amount' }, { binding: 'shippedDate', header: '出荷日' } ] }, { header: '顧客', colspan: 3, cells: [ { binding: 'customer.name', header: '顧客' }, { binding: 'customer.email', header: 'メール', colspan: 2, cssClass: 'email' }, { binding: 'customer.address', header: '住所' }, { binding: 'customer.city', header: '都道府県', dataMap: cityMap }, { binding: 'customer.state', header: '国', width: 45 } ] }, { header: '運送業者', cells: [ { binding: 'shipper.name', header: '運送業者', colspan: 2 }, { binding: 'shipper.email', header: 'メール', cssClass: 'email' }, { binding: 'shipper.express', header: '速達' } ] } ]; appData.ldThreeLines = [ { header: '受注', colspan: 2, cells: [ { binding: 'id', header: 'ID', colspan: 2, cssClass: 'id' }, { binding: 'amount', header: '金額', format: 'c', colspan: 2, cssClass: 'amount' }, { binding: 'date', header: '受注日' }, { binding: 'shippedDate', header: '出荷日' } ] }, { header: '顧客', colspan: 3, cells: [ { binding: 'customer.name', header: '顧客' }, { binding: 'customer.email', header: 'メール', colspan: 2, cssClass: 'email' }, { binding: 'customer.address', header: '住所', colspan: 2 }, { binding: 'customer.phone', header: '電話番号' }, { binding: 'customer.city', header: '都道府県', dataMap: cityMap }, { binding: 'customer.state', header: '国', width: 45 }, { binding: 'customer.zip', header: '郵便番号' }, ] }, { header: '運送業者', cells: [ { binding: 'shipper.name', header: '運送業者' }, { binding: 'shipper.email', header: 'メール', cssClass: 'email' }, { binding: 'shipper.express', header: '速達' } ] } ]; appData.layoutDefs = new wjCore.CollectionView([ { name: '従来のレイアウト', description: '従来のグリッドのように、1レコードを1行で表示します。ユーザーはレコード全体を見るには水平方向にスクロールする必要があります。', def: appData.ldOneLine }, { name: 'コンパクトなレイアウト', description: 'このビューでは、1レコードを2行で表示します。レイアウトは、注文情報、顧客情報、運送業者情報の3つのグループに分かれています。', def: appData.ldTwoLines }, { name: '詳細なレイアウト', description: 'このビューでは、1レコードを3行で表示します。レイアウトは、注文情報、顧客情報、運送業者情報の3つのグループに分かれています。', def: appData.ldThreeLines } ]); return appData; } <template> <div class="container-fluid"> <wj-multi-row :initialized="initSlip" :itemsSource="orders" :layoutDefinition="layoutDefinition"></wj-multi-row> <br /> <button class="btn btn-default" @click="onFreezeClick" v-html="textContent"> </button> </div> </template> <script> import "@grapecity/wijmo.styles/wijmo.css"; import 'bootstrap.css'; import Vue from 'vue'; import '@grapecity/wijmo.vue2.core'; import '@grapecity/wijmo.vue2.grid.multirow'; import { generateAppData } from './data'; let App = Vue.extend({ name: 'app', data: function(){ let data = generateAppData(); return { orders: data.orders, layoutDefinition: data.ldTwoLines, textContent: '行列の固定', freezeMultirow: null } }, methods: { initSlip: function(freezeMultirow){ this.freezeMultirow = freezeMultirow; }, onFreezeClick: function() { this.freezeMultirow.frozenColumns = this.freezeMultirow.frozenColumns ? 0 : 2; this.freezeMultirow.frozenRows = this.freezeMultirow.frozenRows ? 0 : 2; this.textContent = this.freezeMultirow.frozenRows == 0 ? '行列の固定' : '行列固定の解除'; } } }); new Vue({ render: h => h(App) }).$mount('#app'); </script> <style> .wj-multirow { height: 400px; width: 600px; margin: 6px 0; } /* custom styling for frozen cells */ .container-fluid .wj-flexgrid .wj-cell.wj-frozen:not(.wj-header):not(.wj-group):not(.wj-state-selected):not(.wj-state-multi-selected) { background-color: #f3fbcc; } </style> <!DOCTYPE html> <html lang="en"> <head> <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <title>AutoComplete</title> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <!-- SystemJS --> <script src="node_modules/systemjs/dist/system.src.js"></script> <script src="systemjs.config.js"></script> <script> System.import('./src/app.vue'); </script> </head> <body> <div id="app"> </div> </body> </html> import * as wjCore from '@grapecity/wijmo'; import * as wjGrid from '@grapecity/wijmo.grid' export function generateAppData() { // create some data let appData = {}, customers = [], firstNames = '佐藤,鈴木,高橋,田中,伊藤,山本,渡辺,中村,小林,加藤,吉田,山田,佐々木,山口,松本,井上,木村,斎藤,林,清水,山崎,阿部,森,池田,橋本,山下,石川,中島,前田,藤田'.split(','), lastNames = '浩,誠,健一,大輔,達也,翔太,浩一,哲也,剛,大介,健太,拓也,豊,修,和彦,学,直樹,健太郎,浩二,徹,隆,亮,翔,恵子,久美子,由美子,明美,直美,陽子,智子,絵美,恵,裕子,愛,真由美,由美,麻衣,美穂,愛美,彩'.split(','), cities = '東京都,神奈川県,大阪府,愛知県'.split(','), states = '日本'.split(','); for (let i = 0; i < 50; i++) { let first = firstNames[randBetween(0, firstNames.length - 1)], last = lastNames[randBetween(0, lastNames.length - 1)]; customers.push({ id: i, name: first + ' ' + last, address: `${String.fromCharCode(randBetween(65, 90))}市${String.fromCharCode(randBetween(65, 90))}町${randBetween(1, 10)}-${randBetween(1, 10)}-${randBetween(1, 10)}`, city: cities[randBetween(0, cities.length - 1)], state: states[randBetween(0, states.length - 1)], zip: wjCore.format('{p1:d3}-{p2:d4}', { p1: randBetween(100, 999), p2: randBetween(0, 9999) }), email: 'cust@x.com', phone: wjCore.format('090-{p1:d4}-{p2:d4}', { p1: randBetween(1000, 9999), p2: randBetween(1000, 9999) }) }); } let cityMap = new wjGrid.DataMap(cities); let shippers = [ { id: 0, name: 'アカネコ', email: 'ship1@x.com', phone: '03-3955-98xx', express: true }, { id: 1, name: 'トマト', email: 'ship2@x.com', phone: '03-3681-31xx', express: true }, { id: 2, name: 'ペンギン', email: 'ship3@x.com', phone: '03-3566-99xx', express: false } ]; let orders = []; let today = new Date(); for (let i = 0; i < 20; i++) { let shipped = wjCore.DateTime.addDays(today, -randBetween(1, 3000)); orders.push({ id: i, date: wjCore.DateTime.addDays(shipped, -randBetween(1, 5)), shippedDate: shipped, amount: randBetween(10000, 500000) / 100, customer: customers[randBetween(0, customers.length - 1)], shipper: shippers[randBetween(0, shippers.length - 1)] }); } function randBetween(min, max) { return Math.floor(Math.random() * (max - min + 1) + min); } // expose orders CollectionView to the app appData.orders = new wjCore.CollectionView(orders); // expose grouped orders CollectionView to the app appData.groupedOrders = new wjCore.CollectionView(orders, { groupDescriptions: [ 'customer.city' ] }); // expose paged orders CollectionView to the app appData.pagedOrders = new wjCore.CollectionView(orders, { pageSize: 4 }); // expose addNew oders CollectionView to the app appData.addNewOrders = new wjCore.CollectionView(orders, { newItemCreator: function () { return { // add empty customer and shipper objects to new orders customer: {}, shipper: {} } }, }); appData.addNewOrders.moveCurrentToLast(); // refresh views when data source changes let ordersRefreshing = false; appData.orders.collectionChanged.addHandler(function () { ordersRefreshing = true; if (!pagedOrdersRefreshing) { appData.pagedOrders.refresh(); } if (!groupedOrdersRefreshing) { appData.groupedOrders.refresh(); } if (!addNewOrdersRefreshing) { appData.addNewOrders.refresh(); } ordersRefreshing = false; }); // addNew orders let addNewOrdersRefreshing = false; appData.addNewOrders.collectionChanged.addHandler(function () { addNewOrdersRefreshing = true; if (!ordersRefreshing) { appData.orders.refresh(); } if (!pagedOrdersRefreshing) { appData.pagedOrders.refresh(); } if (!groupedOrdersRefreshing) { appData.groupedOrders.refresh(); } addNewOrdersRefreshing = false; }); // grouped orders let groupedOrdersRefreshing = false; appData.groupedOrders.collectionChanged.addHandler(function () { groupedOrdersRefreshing = true; if (!ordersRefreshing) { appData.orders.refresh(); } if (!pagedOrdersRefreshing) { appData.pagedOrders.refresh(); } if (!addNewOrdersRefreshing) { appData.addNewOrders.refresh(); } groupedOrdersRefreshing = false; }); // paged orders let pagedOrdersRefreshing = false; appData.pagedOrders.collectionChanged.addHandler(function () { pagedOrdersRefreshing = true; if (!ordersRefreshing) { appData.orders.refresh(); } if (!addNewOrdersRefreshing) { appData.addNewOrders.refresh(); } if (!groupedOrdersRefreshing) { appData.groupedOrders.refresh(); } pagedOrdersRefreshing = false; }); // sample layout definitions appData.ldOneLine = [ { cells: [{ binding: 'id', header: 'ID', cssClass: 'id', isReadOnly: true }] }, { cells: [{ binding: 'date', header: '受注日' }] }, { cells: [{ binding: 'shippedDate', header: '出荷日' }] }, { cells: [{ binding: 'amount', header: '金額', format: 'c', cssClass: 'amount' }] }, { cells: [{ binding: 'customer.name', header: '顧客名' }] }, { cells: [{ binding: 'customer.address', header: '住所', wordWrap: true }] }, { cells: [{ binding: 'customer.city', header: '都道府県', dataMap: cityMap }] }, { cells: [{ binding: 'customer.state', header: '国', width: 45 }] }, { cells: [{ binding: 'customer.zip', header: '郵便番号' }] }, { cells: [{ binding: 'customer.email', header: '顧客のメール', cssClass: 'email' }] }, { cells: [{ binding: 'customer.phone', header: '顧客の電話番号' }] }, { cells: [{ binding: 'shipper.name', header: '運送業者' }] }, { cells: [{ binding: 'shipper.email', header: '運送業者のメール', cssClass: 'email' }] }, { cells: [{ binding: 'shipper.phone', header: '運送業者の電話番号' }] }, { cells: [{ binding: 'shipper.express', header: '速達' }] } ]; appData.ldTwoLines = [ { header: '受注', colspan: 2, cells: [ { binding: 'id', header: 'ID', cssClass: 'id', isReadOnly: true }, { binding: 'date', header: '受注日' }, { binding: 'amount', header: '金額', format: 'c', cssClass: 'amount' }, { binding: 'shippedDate', header: '出荷日' } ] }, { header: '顧客', colspan: 3, cells: [ { binding: 'customer.name', header: '顧客' }, { binding: 'customer.email', header: 'メール', colspan: 2, cssClass: 'email' }, { binding: 'customer.address', header: '住所' }, { binding: 'customer.city', header: '都道府県', dataMap: cityMap }, { binding: 'customer.state', header: '国', width: 45 } ] }, { header: '運送業者', cells: [ { binding: 'shipper.name', header: '運送業者', colspan: 2 }, { binding: 'shipper.email', header: 'メール', cssClass: 'email' }, { binding: 'shipper.express', header: '速達' } ] } ]; appData.ldThreeLines = [ { header: '受注', colspan: 2, cells: [ { binding: 'id', header: 'ID', colspan: 2, cssClass: 'id' }, { binding: 'amount', header: '金額', format: 'c', colspan: 2, cssClass: 'amount' }, { binding: 'date', header: '受注日' }, { binding: 'shippedDate', header: '出荷日' } ] }, { header: '顧客', colspan: 3, cells: [ { binding: 'customer.name', header: '顧客' }, { binding: 'customer.email', header: 'メール', colspan: 2, cssClass: 'email' }, { binding: 'customer.address', header: '住所', colspan: 2 }, { binding: 'customer.phone', header: '電話番号' }, { binding: 'customer.city', header: '都道府県', dataMap: cityMap }, { binding: 'customer.state', header: '国', width: 45 }, { binding: 'customer.zip', header: '郵便番号' }, ] }, { header: '運送業者', cells: [ { binding: 'shipper.name', header: '運送業者' }, { binding: 'shipper.email', header: 'メール', cssClass: 'email' }, { binding: 'shipper.express', header: '速達' } ] } ]; appData.layoutDefs = new wjCore.CollectionView([ { name: '従来のレイアウト', description: '従来のグリッドのように、1レコードを1行で表示します。ユーザーはレコード全体を見るには水平方向にスクロールする必要があります。', def: appData.ldOneLine }, { name: 'コンパクトなレイアウト', description: 'このビューでは、1レコードを2行で表示します。レイアウトは、注文情報、顧客情報、運送業者情報の3つのグループに分かれています。', def: appData.ldTwoLines }, { name: '詳細なレイアウト', description: 'このビューでは、1レコードを3行で表示します。レイアウトは、注文情報、顧客情報、運送業者情報の3つのグループに分かれています。', def: appData.ldThreeLines } ]); return appData; }