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;
}
