private void PaintGrdView(Int32 aGrd) { GrdView.Sheets[aGrd].ColumnCount = 15; GrdView.HorizontalScrollBarPolicy = FarPoint.Win.Spread.ScrollBarPolicy.Never; GrdView.VerticalScrollBarPolicy = FarPoint.Win.Spread.ScrollBarPolicy.Never; GrdView.Sheets[aGrd].SetColumnWidth(liColVouNo, 82); GrdView.Sheets[aGrd].SetColumnWidth(liColGuestName, 220); GrdView.Sheets[aGrd].SetColumnWidth(liColVouDate, 70); GrdView.Sheets[aGrd].SetColumnWidth(liColCounter, 75); GrdView.Sheets[aGrd].SetColumnWidth(liColMac, 65); GrdView.Sheets[aGrd].SetColumnWidth(liColRoomRate, 82); GrdView.Sheets[aGrd].SetColumnWidth(liColRoomRate1, 82); GrdView.Sheets[aGrd].SetColumnWidth(liColStaffName, 85); GrdView.Sheets[aGrd].SetColumnWidth(liColStatus, 65); GrdView.Sheets[aGrd].SetColumnWidth(liColCheckInDate, 65); GrdView.Sheets[aGrd].SetColumnWidth(liColCheckOutDate, 65); GrdView.Sheets[aGrd].SetColumnWidth(liColDays, 45); GrdView.Sheets[aGrd].SetColumnWidth(liColPax, 45); GrdView.Sheets[aGrd].SetColumnWidth(liColDeposit, 82); GrdView.Sheets[aGrd].SetColumnWidth(liColRoomNO, 60); FarPoint.Win.Spread.Column col; FarPoint.Win.Spread.CellType.TextCellType cell = new FarPoint.Win.Spread.CellType.TextCellType(); col = GrdView.Sheets[aGrd].Columns[liColVouNo, liColRoomNO]; col.CellType = cell; GrdView.Sheets[aGrd].Columns[liColDetailCounterID, liColDetailDepositAMT].Locked = true; GrdView.Sheets[aGrd].SetColumnLabel(0, liColVouNo, "Vou No"); GrdView.Sheets[aGrd].SetColumnLabel(0, liColGuestName, "Guest Name"); GrdView.Sheets[aGrd].SetColumnLabel(0, liColVouDate, "Vou Date"); GrdView.Sheets[aGrd].SetColumnLabel(0, liColCounter, "Counter"); GrdView.Sheets[aGrd].SetColumnLabel(0, liColMac, "MAC"); GrdView.Sheets[aGrd].SetColumnLabel(0, liColRoomRate, "Room Rate"); GrdView.Sheets[aGrd].SetColumnLabel(0, liColRoomRate1, "Room Rate++"); GrdView.Sheets[aGrd].SetColumnLabel(0, liColStaffName, "Staff"); GrdView.Sheets[aGrd].SetColumnLabel(0, liColStatus, "Status"); GrdView.Sheets[aGrd].SetColumnLabel(0, liColCheckInDate, "in Date"); GrdView.Sheets[aGrd].SetColumnLabel(0, liColCheckOutDate, "out Date"); GrdView.Sheets[aGrd].SetColumnLabel(0, liColPax, "PAX"); GrdView.Sheets[aGrd].SetColumnLabel(0, liColDays, "Days"); GrdView.Sheets[aGrd].SetColumnLabel(0, liColDeposit, "Deposit"); GrdView.Sheets[aGrd].SetColumnLabel(0, liColRoomNO, "Room NO"); GrdView.ScrollBarTrackPolicy = FarPoint.Win.Spread.ScrollBarTrackPolicy.Off; GrdView.BorderStyle = BorderStyle.None; //GrdView.Sheets[aGrd].Columns[liColVouNo].Visible = false; FarPoint.Win.Spread.HideRowFilter hideRowFilter = new FarPoint.Win.Spread.HideRowFilter(GrdView.ActiveSheet); GrdView.Sheets[aGrd].Columns[liColGuestName].AllowAutoFilter = true; GrdView.Sheets[aGrd].Columns[liColVouDate].AllowAutoFilter = true; GrdView.Sheets[aGrd].Columns[liColCounter].AllowAutoFilter = true; GrdView.Sheets[aGrd].Columns[liColStaffName].AllowAutoFilter = true; GrdView.Sheets[aGrd].Columns[liColCheckInDate].AllowAutoFilter = true; //GrdView.Visible = true; }
/// <summary> /// 设置Farpoint过滤功能,不符合过滤条件的行将被隐藏 /// 注意:Farpoint中的冻结行的数据将不会被过滤;若未设置冻结行,冻结行的内容也会被添加到过滤条件当中! /// </summary> /// <param name="fp"></param> /// <param name="filterColumnIdxs">需要过滤的列的索引</param> static public void SetFpFilterHideProperties(FarPoint.Win.Spread.FpSpread fp, int[] filterColumnIdxs) { if (filterColumnIdxs == null || filterColumnIdxs.Length == 0) { return; } FarPoint.Win.Spread.HideRowFilter rowFilter = new FarPoint.Win.Spread.HideRowFilter(fp.ActiveSheet); //冻结行不进行过滤 rowFilter.FilterFrozenRows = false; //非空行字符串 rowFilter.NonBlanksString = Const.NONBLANK_STRING; //全部字符串,选择全部时过滤内容会没有符合条件的,因此ALL_STRING定义为“取消” rowFilter.AllString = Const.ALL_STRING; //空行字符串 rowFilter.BlanksString = Const.BLANK_STRING; int fcLen = filterColumnIdxs.Length; string[] curFilters = new string[fcLen]; for (int i = 0; i < fcLen; i++) { if (fp.ActiveSheet.RowFilter != null) { curFilters[i] = fp.ActiveSheet.RowFilter.GetColumnFilterBy(filterColumnIdxs[i]); } FarPoint.Win.Spread.FilterColumnDefinition fcd = new FarPoint.Win.Spread.FilterColumnDefinition(filterColumnIdxs[i], ~FarPoint.Win.Spread.FilterListBehavior.NonBlank & ~FarPoint.Win.Spread.FilterListBehavior.Blank);//取消显示“非空白行”和“空白行”过滤条件 rowFilter.AddColumn(fcd); } fp.ActiveSheet.RowFilter = rowFilter; //按照先前选中的过滤方式过滤 for (int i = 0; i < fcLen; i++) { if (curFilters[i] != null && curFilters[i].Length != 0) { fp.ActiveSheet.AutoFilterColumn(filterColumnIdxs[i], curFilters[i], 0); } } }
private void PaintGrdView() { //FarPoint.Win.Spread.Cell aCell; GrdView.Reset(); GrdView.Visible = false; GrdView.ActiveSheet.RowCount = 1; GrdView.ActiveSheet.ColumnCount = 12; GrdView.Height = this.Height - 150; GrdView.Width = this.Width - 30; GrdView.Top = 85; GrdView.Left = 12; GrdView.HorizontalScrollBarPolicy = FarPoint.Win.Spread.ScrollBarPolicy.Never; GrdView.VerticalScrollBarPolicy = FarPoint.Win.Spread.ScrollBarPolicy.Never; GrdView.ActiveSheet.SetColumnWidth(liColVouNo, 82); GrdView.ActiveSheet.SetColumnWidth(liColGuestName, 180); GrdView.ActiveSheet.SetColumnWidth(liColVouDate, 70); GrdView.ActiveSheet.SetColumnWidth(liColHotel, 285); GrdView.ActiveSheet.SetColumnWidth(liColCounter, 65); GrdView.ActiveSheet.SetColumnWidth(liColMac, 45); GrdView.ActiveSheet.SetColumnWidth(liColRoom, 45); GrdView.ActiveSheet.SetColumnWidth(liColConfirm, 48); GrdView.ActiveSheet.SetColumnWidth(liColRoomRate, 70); GrdView.ActiveSheet.SetColumnWidth(liColRoomRate1, 74); GrdView.ActiveSheet.SetColumnWidth(liColStaffName, 90); GrdView.ActiveSheet.SetColumnWidth(liColStatus, 60); FarPoint.Win.Spread.Column col; FarPoint.Win.Spread.CellType.TextCellType cell = new FarPoint.Win.Spread.CellType.TextCellType(); col = GrdView.ActiveSheet.Columns[liColVouNo, liColStatus]; col.CellType = cell; col = GrdView.ActiveSheet.Columns[liColCounter, liColRoom]; col.CellType = cell; FarPoint.Win.Spread.CellType.NumberCellType cell8 = new FarPoint.Win.Spread.CellType.NumberCellType(); cell8.Separator = ","; col = GrdView.ActiveSheet.Columns[liColRoomRate, liColRoomRate1]; col.CellType = cell8; FarPoint.Win.Spread.Column col7; FarPoint.Win.Spread.CellType.ButtonCellType cell7 = new FarPoint.Win.Spread.CellType.ButtonCellType(); col7 = GrdView.ActiveSheet.Columns[liColConfirm]; //col.Locked = true; //col7.Label = "Confirm"; col7.CellType = cell7; //GrdView .ActiveSheet FarPoint.Win.Spread.HideRowFilter hideRowFilter = new FarPoint.Win.Spread.HideRowFilter(GrdView.ActiveSheet); GrdView.ActiveSheet.Columns[liColVouNo, liColGuestName].AllowAutoFilter = true; GrdView.ActiveSheet.Columns[liColHotel, liColCounter].AllowAutoFilter = true; GrdView.ActiveSheet.OperationMode = FarPoint.Win.Spread.OperationMode.RowMode; GrdView.ActiveSheet.Columns[0, 6].Locked = true; GrdView.ActiveSheet.SetColumnLabel(0, liColVouNo, "Vou NO"); GrdView.ActiveSheet.SetColumnLabel(0, liColGuestName, "Guest Name"); GrdView.ActiveSheet.SetColumnLabel(0, liColVouDate, "Vou Date"); GrdView.ActiveSheet.SetColumnLabel(0, liColHotel, "Hotel"); GrdView.ActiveSheet.SetColumnLabel(0, liColCounter, "Counter"); GrdView.ActiveSheet.SetColumnLabel(0, liColMac, "MAC"); GrdView.ActiveSheet.SetColumnLabel(0, liColRoom, "ROOM"); GrdView.ActiveSheet.SetColumnLabel(0, liColConfirm, "Confirm"); GrdView.ActiveSheet.SetColumnLabel(0, liColRoomRate, "RoomRate"); GrdView.ActiveSheet.SetColumnLabel(0, liColRoomRate1, "RoomRate++"); GrdView.ActiveSheet.SetColumnLabel(0, liColStaffName, "Staff Name"); GrdView.ActiveSheet.SetColumnLabel(0, liColStatus, "Status"); GrdView.ScrollBarTrackPolicy = FarPoint.Win.Spread.ScrollBarTrackPolicy.Off; GrdView.BorderStyle = BorderStyle.None; GrdView.AllowColumnMove = true; GrdView.Visible = true; }