private void PaintGrdView()
{
//FarPoint.Win.Spread.Cell aCell;
GrdView.Visible = false;
GrdView.Reset();
rowgrdView = 1;
GrdView.ActiveSheet.RowCount = rowgrdView;
GrdView.ActiveSheet.ColumnCount = 3;
//GrdView.Height = this.Height - 60;
//GrdView.Width = this.Width - 30;
//GrdView.Top = 30;
//GrdView.Left = 500;
FarPoint.Win.Spread.CellType.TextCellType cellTxt = new FarPoint.Win.Spread.CellType.TextCellType();
GrdView.Sheets[0].Columns[colEmail, colEmailFlag].CellType = cellTxt;
//GrdView.Sheets[0].Columns[colMemID, colMemID].CellType = cellTxt;
FarPoint.Win.Spread.CellType.CheckBoxCellType cellGrdCheck = new FarPoint.Win.Spread.CellType.CheckBoxCellType();
cellGrdCheck.TextTrue = "use";
cellGrdCheck.TextFalse = "use";
GrdView.ActiveSheet.Columns[colFlag].CellType = cellGrdCheck;
GrdView.ActiveSheet.SetColumnLabel(0, colFlag, "USE");
GrdView.ActiveSheet.SetColumnLabel(0, colEmail, "EMail");
GrdView.ActiveSheet.SetColumnLabel(0, colEmailFlag, "Flag");
GrdView.ActiveSheet.SetColumnWidth(colFlag, 60);
GrdView.ActiveSheet.SetColumnWidth(colEmail, 200);
GrdView.ActiveSheet.SetColumnWidth(colEmail, 100);
GrdView.HorizontalScrollBarPolicy = FarPoint.Win.Spread.ScrollBarPolicy.AsNeeded;
GrdView.VerticalScrollBarPolicy = FarPoint.Win.Spread.ScrollBarPolicy.AsNeeded;
GrdView.Visible = true;
}
private void PaintGrdView()
{
//FarPoint.Win.Spread.Cell aCell;
GrdView.Reset();
GrdView.Visible = false;
GrdView.ActiveSheet.RowCount = 1;
GrdView.ActiveSheet.ColumnCount = 2;
//GrdView.Height = this.Height - 150;
//GrdView.Width = this.Width - 30;
//GrdView.Top = 75;
//GrdView.Left = 12;
GrdView.HorizontalScrollBarPolicy = FarPoint.Win.Spread.ScrollBarPolicy.Never;
GrdView.VerticalScrollBarPolicy = FarPoint.Win.Spread.ScrollBarPolicy.Never;
GrdView.ActiveSheet.SetColumnWidth(0, 35);
GrdView.ActiveSheet.SetColumnWidth(1, 300);
FarPoint.Win.Spread.Column col;
FarPoint.Win.Spread.CellType.TextCellType cell = new FarPoint.Win.Spread.CellType.TextCellType();
col = GrdView.ActiveSheet.Columns[1];
col.CellType = cell;
col = GrdView.ActiveSheet.Columns[0];
col.CellType = cell;
GrdView.ActiveSheet.Columns[0, 0].Locked = true;
GrdView.ActiveSheet.SetColumnLabel(0, 0, "NO");
GrdView.ActiveSheet.SetColumnLabel(0, 1, "Name");
GrdView.ScrollBarTrackPolicy = FarPoint.Win.Spread.ScrollBarTrackPolicy.Off;
GrdView.BorderStyle = BorderStyle.None;
GrdView.Visible = true;
}
private void PaintGrdView()
{
GrdView.Visible = false;
GrdView.Reset();
GrdView.ActiveSheet.RowCount = 1;
GrdView.ActiveSheet.ColumnCount = 5;
GrdView.Height = this.Height - 100;
GrdView.Width = this.Width - 30;
GrdView.Top = 35;
GrdView.Left = 12;
FarPoint.Win.Spread.Column col;
FarPoint.Win.Spread.CellType.TextCellType cell = new FarPoint.Win.Spread.CellType.TextCellType();
col = GrdView.ActiveSheet.Columns[0, liColUserName];
col.CellType = cell;
GrdView.ActiveSheet.SetColumnWidth(liColStaffID, 105);
GrdView.ActiveSheet.SetColumnWidth(liColSatffName, 300);
GrdView.ActiveSheet.SetColumnWidth(liColIDCard, 65);
GrdView.ActiveSheet.SetColumnWidth(liColStaffType, 150);
GrdView.ActiveSheet.SetColumnWidth(liColUserName, 150);
if (flagStaff == FlagStaff.Staff)
{
GrdView.ActiveSheet.SetColumnLabel(0, liColStaffID, "StaffID");
GrdView.ActiveSheet.SetColumnLabel(0, liColSatffName, "Staff Name");
NewStaff.Text = " New Staff";
}
else if (flagStaff == FlagStaff.Committee)
{
GrdView.ActiveSheet.SetColumnLabel(0, liColStaffID, "CommitteeID");
GrdView.ActiveSheet.SetColumnLabel(0, liColSatffName, "Committee Name");
NewStaff.Text = " New Committee";
}
else if (flagStaff == FlagStaff.PR)
{
GrdView.ActiveSheet.SetColumnLabel(0, liColStaffID, "ID");
GrdView.ActiveSheet.SetColumnLabel(0, liColSatffName, " Name");
NewStaff.Text = " New ¼ÙéÊ×èÍ¢èÒÇ";
}
else if (flagStaff == FlagStaff.Guess)
{
GrdView.ActiveSheet.SetColumnLabel(0, liColStaffID, "Guess ID");
GrdView.ActiveSheet.SetColumnLabel(0, liColSatffName, "Guess Name");
NewStaff.Text = " New Guess";
}
GrdView.ActiveSheet.SetColumnLabel(0, liColIDCard, "ID");
GrdView.ActiveSheet.SetColumnLabel(0, liColStaffType, "Type");
GrdView.ActiveSheet.SetColumnLabel(0, liColUserName, "UserName");
GrdView.ScrollBarTrackPolicy = FarPoint.Win.Spread.ScrollBarTrackPolicy.Off;
GrdView.BorderStyle = BorderStyle.None;
GrdView.ActiveSheet.OperationMode = FarPoint.Win.Spread.OperationMode.RowMode;
GrdView.HorizontalScrollBarPolicy = FarPoint.Win.Spread.ScrollBarPolicy.AsNeeded;
GrdView.VerticalScrollBarPolicy = FarPoint.Win.Spread.ScrollBarPolicy.AsNeeded;
GrdView.ActiveSheet.Columns[0, liColUserName].AllowAutoSort = true;
GrdView.ActiveSheet.Columns[0, liColUserName].AllowAutoFilter = true;
GrdView.Visible = true;
GrdView.AllowColumnMove = true;
}
private void PaintGrdView()
{
//FarPoint.Win.Spread.Cell aCell;
GrdView.Visible = false;
GrdView.Reset();
GrdView.ActiveSheet.RowCount = 1;
GrdView.ActiveSheet.ColumnCount = 11;
//GrdView.Height = this.Height - 60;
//GrdView.Width = this.Width - 30;
//GrdView.Top = 30;
//GrdView.Left = 500;
FarPoint.Win.Spread.CellType.TextCellType cellTxt = new FarPoint.Win.Spread.CellType.TextCellType();
GrdView.Sheets[0].Columns[liColMeetingContactID, colMemNameT].CellType = cellTxt;
GrdView.Sheets[0].Columns[colMemID, colMemID].CellType = cellTxt;
GrdView.Sheets[0].Columns[liColMeetingContactID].Visible = false;
//GrdView.Sheets[0].Columns[liColPrintLabel].Visible = false;
FarPoint.Win.Spread.CellType.CheckBoxCellType cellGrdCheck = new FarPoint.Win.Spread.CellType.CheckBoxCellType();
cellGrdCheck.TextTrue = "use";
cellGrdCheck.TextFalse = "use";
GrdView.ActiveSheet.Columns[liColFlag].CellType = cellGrdCheck;
GrdView.ActiveSheet.SetColumnWidth(liColMeetingContactID, 72);
GrdView.ActiveSheet.SetColumnWidth(liColMeetingContactName, 170);
GrdView.ActiveSheet.SetColumnWidth(liColCompanyName, 170);
GrdView.ActiveSheet.SetColumnWidth(liColPositionName, 80);
GrdView.ActiveSheet.SetColumnWidth(liColTypeMeetingContact, 80);
GrdView.ActiveSheet.SetColumnLabel(0, liColFlag, "USE");
GrdView.ActiveSheet.SetColumnLabel(0, liColMeetingContactID, "meetingcontactid");
GrdView.ActiveSheet.SetColumnLabel(0, liColMeetingContactName, "ª×èͼÙéà¢éÒ»ÃЪØÁ");
GrdView.ActiveSheet.SetColumnLabel(0, liColCompanyName, "ºÃÔÉÑ·");
GrdView.ActiveSheet.SetColumnLabel(0, liColPositionName, "µÓá˹è§");
GrdView.ActiveSheet.SetColumnLabel(0, liColTypeMeetingContact, "»ÃÐàÀ·");
GrdView.ActiveSheet.SetColumnLabel(0, liColPrintLabel, "printlabel");
GrdView.ActiveSheet.SetColumnLabel(0, colTmemNameT, "»ÃÐàÀ·ÊÁÒªÔ¡");
GrdView.ActiveSheet.SetColumnLabel(0, colMemNameT, "ª×èÍÊÁÒªÔ¡ÀÒÉÒä·Â");
GrdView.ActiveSheet.SetColumnLabel(0, colContactID, "contactid");
GrdView.ActiveSheet.SetColumnLabel(0, colMemID, "memid");
GrdView.ScrollBarTrackPolicy = FarPoint.Win.Spread.ScrollBarTrackPolicy.Off;
GrdView.BorderStyle = BorderStyle.None;
GrdView.ActiveSheet.OperationMode = FarPoint.Win.Spread.OperationMode.RowMode;
GrdView.HorizontalScrollBarPolicy = FarPoint.Win.Spread.ScrollBarPolicy.AsNeeded;
GrdView.VerticalScrollBarPolicy = FarPoint.Win.Spread.ScrollBarPolicy.AsNeeded;
GrdView.Visible = true;
GrdView.ActiveSheet.Columns[liColMeetingContactID, liColTypeMeetingContact].AllowAutoSort = true;
GrdView.ActiveSheet.Columns[liColMeetingContactID, liColTypeMeetingContact].AllowAutoFilter = true;
GrdView.Sheets[0].Columns[colContactID].Visible = false;
GrdView.AllowColumnMove = true;
}
private void PaintGrdView()
{
//FarPoint.Win.Spread.Cell aCell;
GrdView.Visible = false;
GrdView.Reset();
GrdView.ActiveSheet.RowCount = 1;
GrdView.ActiveSheet.ColumnCount = 5;
GrdView.Height = this.Height - 60;
GrdView.Width = this.Width - 30;
GrdView.Top = 35;
GrdView.Left = 12;
FarPoint.Win.Spread.CellType.TextCellType cellTxt = new FarPoint.Win.Spread.CellType.TextCellType();
GrdView.Sheets[0].Columns[liColMeetingID, liColEndDate].CellType = cellTxt;
GrdView.Sheets[0].Columns[liColMeetingID].Visible = false;
GrdView.ActiveSheet.SetColumnWidth(liColMeetingID, 72);
GrdView.ActiveSheet.SetColumnWidth(liColMeetingNameE, 300);
GrdView.ActiveSheet.SetColumnWidth(liColPlace, 300);
GrdView.ActiveSheet.SetColumnWidth(liColStartDate, 90);
GrdView.ActiveSheet.SetColumnWidth(liColEndDate, 90);
GrdView.ActiveSheet.SetColumnLabel(0, liColMeetingID, "meetingid");
GrdView.ActiveSheet.SetColumnLabel(0, liColMeetingNameE, "ª×èÍ¡ÒûÃЪØÁ");
GrdView.ActiveSheet.SetColumnLabel(0, liColPlace, "ʶҹ·Õè»ÃЪØÁ");
GrdView.ActiveSheet.SetColumnLabel(0, liColStartDate, "Çѹ·Õè»ÃЪØÁ");
GrdView.ActiveSheet.SetColumnLabel(0, liColEndDate, "¶Ö§Çѹ·Õè");
GrdView.ScrollBarTrackPolicy = FarPoint.Win.Spread.ScrollBarTrackPolicy.Off;
GrdView.BorderStyle = BorderStyle.None;
GrdView.ActiveSheet.OperationMode = FarPoint.Win.Spread.OperationMode.RowMode;
GrdView.HorizontalScrollBarPolicy = FarPoint.Win.Spread.ScrollBarPolicy.AsNeeded;
GrdView.VerticalScrollBarPolicy = FarPoint.Win.Spread.ScrollBarPolicy.Never;
GrdView.Visible = true;
GrdView.ActiveSheet.Columns[liColMeetingID, liColEndDate].AllowAutoSort = true;
GrdView.ActiveSheet.Columns[liColMeetingID, liColEndDate].AllowAutoFilter = true;
GrdView.AllowColumnMove = true;
}
private void PaintGrdView()
{
GrdView.Visible = false;
GrdView.Reset();
GrdView.BorderStyle = BorderStyle.None;
GrdView.ActiveSheet.RowCount = 1;
GrdView.ActiveSheet.ColumnCount = 8;
GrdView.ActiveSheet.SetColumnWidth(liColDistrictCode, 200);
GrdView.ActiveSheet.SetColumnWidth(liColDistrictNameT, 250);
GrdView.ActiveSheet.SetColumnWidth(liColDistrictNameE, 150);
GrdView.ActiveSheet.SetColumnWidth(liColPostCode, 150);
GrdView.ActiveSheet.SetColumnLabel(0, liColDistrictCode, "ÃËÑÊ");
GrdView.ActiveSheet.SetColumnLabel(0, liColDistrictNameT, "ª×èÍÀÒÉÒä·Â");
GrdView.ActiveSheet.SetColumnLabel(0, liColDistrictNameE, "Name English");
GrdView.ActiveSheet.SetColumnLabel(0, liColPostCode, "Postcode");
GrdView.ActiveSheet.SetColumnLabel(0, liColProvCode, "provcode");
GrdView.ActiveSheet.SetColumnLabel(0, liColCouCode, "coucode");
GrdView.ActiveSheet.SetColumnLabel(0, liColDistrictCode, "districtcode");
GrdView.ActiveSheet.SetColumnLabel(0, liColFlag, "flag");
FarPoint.Win.Spread.Column col;
FarPoint.Win.Spread.CellType.TextCellType cell = new FarPoint.Win.Spread.CellType.TextCellType();
col = GrdView.ActiveSheet.Columns[liColCode, liColDistrictCode];
//col.Locked = true;
col.CellType = cell;
GrdView.ScrollBarTrackPolicy = FarPoint.Win.Spread.ScrollBarTrackPolicy.Off;
GrdView.HorizontalScrollBarPolicy = FarPoint.Win.Spread.ScrollBarPolicy.Never;
GrdView.VerticalScrollBarPolicy = FarPoint.Win.Spread.ScrollBarPolicy.Never;
GrdView.ActiveSheet.Columns[liColCode, liColDistrictCode].AllowAutoSort = true;
GrdView.ActiveSheet.Columns[liColCode, liColDistrictCode].AllowAutoFilter = true;
//GrdView.ActiveSheet.Columns[liColProvCode].Visible = false;
//GrdView.ActiveSheet.Columns[liColCouCode].Visible = false;
//GrdView.ActiveSheet.Columns[liColDistrictCode].Visible = false;
GrdView.Visible = true;
}
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;
}
private void PaintGrdView()
{
//FarPoint.Win.Spread.Cell aCell;
GrdView.Visible = false;
GrdView.Reset();
GrdView.ActiveSheet.RowCount = 1;
GrdView.ActiveSheet.ColumnCount = 9;
GrdView.Height = this.Height - GrdFilter.Height - 60;
GrdView.Width = this.Width - 30;
GrdView.Top = 35;
GrdView.Left = 12;
FarPoint.Win.Spread.Column col;
FarPoint.Win.Spread.CellType.TextCellType cell = new FarPoint.Win.Spread.CellType.TextCellType();
col = GrdView.ActiveSheet.Columns[liColMemID, liColContactNameSkk9];
col.CellType = cell;
FarPoint.Win.Spread.CellType.NumberCellType cellNum = new FarPoint.Win.Spread.CellType.NumberCellType();
col = GrdView.ActiveSheet.Columns[liColRoom];
cellNum.DecimalPlaces = 0;
col.CellType = cellNum;
FarPoint.Win.Spread.CellType.ImageCellType cellImg = new FarPoint.Win.Spread.CellType.ImageCellType();
col = GrdView.ActiveSheet.Columns[liColStar1];
cellImg.Style = FarPoint.Win.RenderStyle.StretchAndScale;
col.CellType = cellImg;
GrdView.ActiveSheet.SetColumnWidth(liColMemID, 72);
GrdView.ActiveSheet.SetColumnWidth(liColMemNameE, 300);
GrdView.ActiveSheet.SetColumnWidth(liColRoom, 65);
GrdView.ActiveSheet.SetColumnWidth(liColRegion, 150);
GrdView.ActiveSheet.SetColumnWidth(liColTMem, 110);
GrdView.ActiveSheet.SetColumnWidth(liColHotelChain, 150);
GrdView.ActiveSheet.SetColumnWidth(liColStar1, 100);
GrdView.ActiveSheet.SetColumnWidth(liColProvNameT, 110);
GrdView.ActiveSheet.SetColumnLabel(0, liColMemID, "memid");
GrdView.ActiveSheet.SetColumnLabel(0, liColMemNameE, "Member Name");
GrdView.ActiveSheet.SetColumnLabel(0, liColRoom, "room");
GrdView.ActiveSheet.SetColumnLabel(0, liColRegion, "Region");
GrdView.ActiveSheet.SetColumnLabel(0, liColTMem, "Type Member");
GrdView.ActiveSheet.SetColumnLabel(0, liColHotelChain, "Hotel Chain");
GrdView.ActiveSheet.SetColumnLabel(0, liColStar1, "star");
GrdView.ActiveSheet.SetColumnLabel(0, liColProvNameT, "province");
GrdView.ActiveSheet.SetColumnLabel(0, liColContactNameSkk9, "ª×èͼÙéá·¹");
GrdView.ScrollBarTrackPolicy = FarPoint.Win.Spread.ScrollBarTrackPolicy.Off;
GrdView.BorderStyle = BorderStyle.None;
GrdView.ActiveSheet.OperationMode = FarPoint.Win.Spread.OperationMode.RowMode;
GrdView.HorizontalScrollBarPolicy = FarPoint.Win.Spread.ScrollBarPolicy.AsNeeded;
GrdView.VerticalScrollBarPolicy = FarPoint.Win.Spread.ScrollBarPolicy.AsNeeded;
GrdView.Visible = true;
//GrdView.Width = this.Width - 10;
GrdFilter.ActiveSheet.RowCount = 0;
GrdFilter.ActiveSheet.ColumnCount = 27;
GrdFilter.Width = 1111;
GrdFilter.Top = this.Height - 80;
GrdFilter.Left = 18;
//GrdFilter.ActiveSheet.SetRowVisible(0, false);
GrdFilter.ActiveSheet.RowHeaderVisible = false;
//GrdFilter.h
GrdFilter.Sheets[0].SetColumnLabel(0, 26, "ALL");
GrdView.ActiveSheet.Columns[liColMemID, liColContactNameSkk9].AllowAutoSort = true;
GrdView.ActiveSheet.Columns[liColMemID, liColContactNameSkk9].AllowAutoFilter = true;
for (Int32 i = 0; i <= 26; i++)
{
GrdFilter.ActiveSheet.SetColumnWidth(i + 1, 38);
}
GrdView.AllowColumnMove = true;
}