public void FormatGrid()
{
GridViewTextBoxColumn col = new GridViewTextBoxColumn();
col.Name = COLS.Id;
col.IsVisible = false;
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.Name = COLS.AddressLine1;
col.IsVisible = false;
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.Name = COLS.Address;
col.HeaderText = COLS.Address;
col.Width = 350;
grdLister.Columns.Add(col);
grdLister.AddDeleteColumn();
grdLister.Columns["btnDelete"].Width = 80;
this.grdLister.CommandCellClick += new CommandCellClickEventHandler(grdLister_CommandCellClick);
this.grdLister.ShowFilteringRow = true;
this.grdLister.EnableFiltering = true;
}
private void FormatSMSTempletGrid()
{
grdSMSTemplets.ShowGroupPanel = false;
GridViewTextBoxColumn col = new GridViewTextBoxColumn();
col.IsVisible = false;
col.Name = COL_SMSTEMPLET.ID;
grdSMSTemplets.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.IsVisible = false;
col.Name = COL_SMSTEMPLET.POLICYID;
grdSMSTemplets.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.HeaderText = "Templates Message";
col.Width = 717;
col.ReadOnly = true;
col.Name = COL_SMSTEMPLET.Tempplet;
grdSMSTemplets.Columns.Add(col);
grdSMSTemplets.AllowAddNewRow = false;
grdSMSTemplets.ShowGroupPanel = false;
grdSMSTemplets.ShowRowHeaderColumn = false;
grdSMSTemplets.CurrentRow = null;
}
private void IniTurnoCombo()
{
radmccbTurno.AutoSizeDropDownToBestFit = true;
RadMultiColumnComboBoxElement multiColumnComboElement = radmccbTurno.MultiColumnComboBoxElement;
multiColumnComboElement.DropDownSizingMode = SizingMode.UpDownAndRightBottom;
//multiColumnComboElement.DropDownMinSize = new Size(420, 300);
multiColumnComboElement.EditorControl.MasterGridViewTemplate.AutoGenerateColumns = false;
GridViewTextBoxColumn column = new GridViewTextBoxColumn("Turno_id");
column.HeaderText = @"Turno Code";
multiColumnComboElement.Columns.Add(column);
column = new GridViewTextBoxColumn("Fecha_apertura");
column.HeaderText = @"Fecha Apertura";
multiColumnComboElement.Columns.Add(column);
column = new GridViewTextBoxColumn("Fecha_cierre");
column.HeaderText = @"Fecha Cierre";
multiColumnComboElement.Columns.Add(column);
column = new GridViewTextBoxColumn("Estado");
column.HeaderText = @"Estado";
multiColumnComboElement.Columns.Add(column);
column = new GridViewTextBoxColumn("Turno_Desc");
column.HeaderText = @"Turno Descripcion";
column.IsVisible = false;
multiColumnComboElement.Columns.Add(column);
}
private void PrepareGrid(RadGridView grid)
{
GridViewImageColumn imageColumn = new GridViewImageColumn("Image", "Image");
imageColumn.Width = 50;
imageColumn.HeaderText = String.Empty;
GridViewTextBoxColumn nameColumn = new GridViewTextBoxColumn("Name", "Name");
nameColumn.Width = 70;
GridViewTextBoxColumn countryColumn = new GridViewTextBoxColumn("Country", "Country");
countryColumn.Width = 90;
GridViewDecimalColumn priceColumn = new GridViewDecimalColumn("Price", "Price");
priceColumn.Width = 90;
priceColumn.FormatString = "{0:c}";
grid.Columns.Add(imageColumn);
grid.Columns.Add(nameColumn);
grid.Columns.Add(countryColumn);
grid.Columns.Add(priceColumn);
grid.TableElement.RowHeight = 50;
grid.MasterTemplate.AllowRowReorder = true;
grid.ReadOnly = true;
grid.MultiSelect = true;
grid.MasterTemplate.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
grid.GridBehavior = new CustomGridBehavior();
}
private void FormatSelectedPostCodesGrid()
{
grdSelectedPostCodes.AllowAutoSizeColumns = true;
grdSelectedPostCodes.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
grdSelectedPostCodes.AllowAddNewRow = false;
grdSelectedPostCodes.AllowRowReorder = true;
grdSelectedPostCodes.ShowGroupPanel = false;
grdSelectedPostCodes.AutoCellFormatting = true;
grdSelectedPostCodes.ShowRowHeaderColumn = false;
grdSelectedPostCodes.EnableFiltering = true;
GridViewTextBoxColumn col = new GridViewTextBoxColumn();
col.IsVisible = false;
col.Name = COLS.Id;
grdSelectedPostCodes.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.ReadOnly = true;
col.HeaderText = "PostCode";
col.Name = COLS.PostCode;
col.Width = 70;
col.ReadOnly = true;
grdSelectedPostCodes.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.ReadOnly = true;
col.HeaderText = "Area Name";
col.Name = COLS.AreaName;
col.Width = 90;
col.ReadOnly = true;
grdSelectedPostCodes.Columns.Add(col);
}
private void InitializeTemplatesGrid()
{
GridViewTextBoxColumn col = new GridViewTextBoxColumn();
col.HeaderText = "Template";
col.Width = 150;
col.ReadOnly = true;
col.Name = COLS_TEMPLATES.TEMPLATENAME;
grdReportTemplates.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.IsVisible = false;
col.Name = COLS_TEMPLATES.TEMPLATEID;
grdReportTemplates.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.IsVisible = false;
col.Name = COLS_TEMPLATES.FORMID;
grdReportTemplates.Columns.Add(col);
GridViewCheckBoxColumn colChk = new GridViewCheckBoxColumn();
colChk.HeaderText = "Default";
colChk.Name = COLS_TEMPLATES.ISDEFAULT;
grdReportTemplates.Columns.Add(colChk);
}
public Form1()
{
InitializeComponent();
this.SelectedControl = this.radMultiColumnComboBox1;
this.radMultiColumnComboBox1.AutoSizeDropDownToBestFit = true;
RadMultiColumnComboBoxElement multiColumnComboElement = this.radMultiColumnComboBox1.MultiColumnComboBoxElement;
multiColumnComboElement.DropDownSizingMode = SizingMode.UpDownAndRightBottom;
multiColumnComboElement.DropDownMinSize = new Size(420, 300);
multiColumnComboElement.EditorControl.MasterTemplate.AutoGenerateColumns = false;
GridViewTextBoxColumn column = new GridViewTextBoxColumn("CustomerID");
column.HeaderText = "Customer ID";
multiColumnComboElement.Columns.Add(column);
column = new GridViewTextBoxColumn("ContactName");
column.HeaderText = "Contact Name";
multiColumnComboElement.Columns.Add(column);
column = new GridViewTextBoxColumn("ContactTitle");
column.HeaderText = "Contact Title";
multiColumnComboElement.Columns.Add(column);
column = new GridViewTextBoxColumn("Country");
column.HeaderText = "Country";
multiColumnComboElement.Columns.Add(column);
column = new GridViewTextBoxColumn("Phone");
column.HeaderText = "Phone";
multiColumnComboElement.Columns.Add(column);
this.SetTheme();
}
public void LoadItemsOfRequest(EQ_Requests request)
{
this.Text = string.Empty;
RadMultiColumnComboBoxElement multiColumnComboElement = this.MultiColumnComboBoxElement;
multiColumnComboElement.DropDownSizingMode = SizingMode.UpDownAndRightBottom;
multiColumnComboElement.Columns.Clear();
this.EditorControl.FilterDescriptors.Clear();
multiColumnComboElement.EditorControl.MasterTemplate.AutoGenerateColumns = false;
GridViewTextBoxColumn column = new GridViewTextBoxColumn("Code");
multiColumnComboElement.Columns.Add(column);
column = new GridViewTextBoxColumn("Name");
multiColumnComboElement.Columns.Add(column);
column = new GridViewTextBoxColumn("Address");
multiColumnComboElement.Columns.Add(column);
FilterDescriptor descriptor = new FilterDescriptor("Name", FilterOperator.StartsWith, string.Empty);
this.EditorControl.FilterDescriptors.Add(descriptor);
this.DropDownStyle = RadDropDownStyle.DropDown;
this.AutoFilter = true;
this.AutoSizeDropDownToBestFit = true;
this.DataSource = dbContext.EQ_QuoteSupplier.Where(qs => qs.EQ_Quotes.RequestID == request.RequestID).Select(qs => qs.Supplier).ToList <Supplier>().Distinct(new SupplierComparer());
this.DisplayMember = "Name";
this.ValueMember = "Code";
}
public void FormatGrid()
{
GridViewTextBoxColumn col = new GridViewTextBoxColumn();
col.IsVisible = false;
col.Name = "Id";
grdBookingType.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.Name = COLS.BookingType;
col.ReadOnly = true;
col.Width = 250;
col.HeaderText = "Airport";
grdBookingType.Columns.Add(col);
GridViewDecimalColumn colExpiry = new GridViewDecimalColumn();
colExpiry.Name = "Expiry";
colExpiry.ReadOnly = false;
colExpiry.HeaderText = " ";
colExpiry.Width = 100;
colExpiry.DecimalPlaces = 0;
colExpiry.Minimum = 0;
grdBookingType.Columns.Add(colExpiry);
// grdBookingType.CommandCellClick+=new CommandCellClickEventHandler(grdBookingType_CommandCellClick);
// grdBookingType.ViewCellFormatting += new CellFormattingEventHandler(grdBookingType_ViewCellFormatting);
grdBookingType.TableElement.RowHeight = 35;
}
public void LoadItems()
{
FilterDescriptor descriptor = new FilterDescriptor("Name", FilterOperator.StartsWith, string.Empty);
this.EditorControl.FilterDescriptors.Add(descriptor);
this.DropDownStyle = RadDropDownStyle.DropDown;
this.AutoFilter = true;
this.AutoSizeDropDownToBestFit = true;
RadMultiColumnComboBoxElement multiColumnComboElement = this.MultiColumnComboBoxElement;
multiColumnComboElement.DropDownSizingMode = SizingMode.UpDownAndRightBottom;
multiColumnComboElement.EditorControl.MasterTemplate.AutoGenerateColumns = false;
GridViewTextBoxColumn column = new GridViewTextBoxColumn("Code");
multiColumnComboElement.Columns.Add(column);
column = new GridViewTextBoxColumn("Name");
multiColumnComboElement.Columns.Add(column);
column = new GridViewTextBoxColumn("Address");
multiColumnComboElement.Columns.Add(column);
this.DataSource = dbContext.Suppliers.ToList <Supplier>();
this.DisplayMember = "Name";
this.ValueMember = "Code";
}
private void FormatFaresGrid()
{
grdCompany.AllowAddNewRow = false;
grdCompany.AllowEditRow = true;
GridViewTextBoxColumn col = new GridViewTextBoxColumn();
col.Name = COLS.Id;
col.IsVisible = false;
grdCompany.Columns.Add(col);
GridViewCheckBoxColumn colcheck = new GridViewCheckBoxColumn();
colcheck.HeaderText = "";
colcheck.Name = COLS.colcheck;
grdCompany.Columns.Add(colcheck);
col = new GridViewTextBoxColumn();
col.HeaderText = "Company Name";
col.Name = COLS.CompanyName;
col.Width = 300;
col.ReadOnly = true;
grdCompany.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.Name = COLS.RowNo;
col.IsVisible = false;
grdCompany.Columns.Add(col);
}
private void FormatDriverGrid()
{
grdDriver.AllowAddNewRow = false;
grdDriver.ShowGroupPanel = false;
grdDriver.TableElement.RowHeight = 30;
grdDriver.EnableFiltering = true;
grdDriver.MasterTemplate.ShowRowHeaderColumn = false;
GridViewTextBoxColumn col = new GridViewTextBoxColumn();
col.Name = COLS.Id;
col.IsVisible = false;
grdDriver.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.Name = COLS.DriverNo;
col.HeaderText = "No";
col.Width = 90;
col.ReadOnly = true;
grdDriver.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.Name = COLS.Driver;
col.HeaderText = "Driver Name";
col.Width = 140;
col.ReadOnly = true;
grdDriver.Columns.Add(col);
grdDriver.CellClick += GrdDriver_CellClick;
}
public frmInputTrans(string custType)
{
InitializeComponent();
RadMultiColumnComboBoxElement multiColumnComboElement = this.mrddPel.MultiColumnComboBoxElement;
multiColumnComboElement.DropDownSizingMode = SizingMode.UpDownAndRightBottom;
multiColumnComboElement.DropDownWidth = 400;
multiColumnComboElement.DropDownHeight = 300;
multiColumnComboElement.EditorControl.MasterTemplate.AutoGenerateColumns = false;
multiColumnComboElement.EditorControl.Size = new Size(420, 300);
GridViewTextBoxColumn column = new GridViewTextBoxColumn("Name");
column.HeaderText = "NAMA";
column.Width = 150;
multiColumnComboElement.Columns.Add(column);
column = new GridViewTextBoxColumn("Address");
column.HeaderText = "Alamat";
column.Width = 225;
multiColumnComboElement.Columns.Add(column);
column = new GridViewTextBoxColumn("CustID");
column.HeaderText = "CustID";
column.Width = 225;
column.IsVisible = false;
multiColumnComboElement.Columns.Add(column);
mrddPel.DataSource = pelBindingSource;
custType_ = custType;
}
private void gridUsers_CellBeginEdit(object sender, GridViewCellCancelEventArgs e)
{
if (this.gridUsers.CurrentColumn is GridViewMultiComboBoxColumn)
{
if (!maNhanVienColumnAdded)
{
maNhanVienColumnAdded = true;
GridViewMultiComboBoxColumn column = this.gridUsers.CurrentColumn as GridViewMultiComboBoxColumn;
RadMultiColumnComboBoxElement editor = (RadMultiColumnComboBoxElement)this.gridUsers.ActiveEditor;
FilterDescriptor descriptorCode = new FilterDescriptor("FirstName", FilterOperator.StartsWith, string.Empty);
editor.EditorControl.FilterDescriptors.Add(descriptorCode);
editor.AutoFilter = true;
editor.EditorControl.MasterTemplate.AutoGenerateColumns = false;
GridViewTextBoxColumn col = new GridViewTextBoxColumn();
col.IsVisible = false;
col.FieldName = "Employee_ID";
editor.EditorControl.Columns.Add(col);//new GridViewTextBoxColumn("Employee_ID"));
editor.EditorControl.Columns.Add(new GridViewTextBoxColumn("FirstName"));
editor.EditorControl.Columns.Add(new GridViewTextBoxColumn("LastName"));
col = new GridViewTextBoxColumn("FullName");
editor.EditorControl.Columns.Add(col);
col.Expression = "FirstName + ' ' + LastName";
editor.EditorControl.Columns.Add(new GridViewTextBoxColumn("Birthday"));
editor.AutoSizeDropDownToBestFit = true;
}
}
}
public void Load_MatRequestForOrder()
{
FilterDescriptor descriptor = new FilterDescriptor("Code", FilterOperator.StartsWith, string.Empty);
this.EditorControl.FilterDescriptors.Add(descriptor);
this.DropDownStyle = RadDropDownStyle.DropDown;
this.AutoFilter = true;
this.AutoSizeDropDownToBestFit = true;
RadMultiColumnComboBoxElement multiColumnComboElement = this.MultiColumnComboBoxElement;
multiColumnComboElement.DropDownSizingMode = SizingMode.UpDownAndRightBottom;
multiColumnComboElement.EditorControl.MasterTemplate.AutoGenerateColumns = false;
GridViewTextBoxColumn column = new GridViewTextBoxColumn("RequestID");
column.IsVisible = false;
multiColumnComboElement.Columns.Add(column);
column = new GridViewTextBoxColumn("Code");
multiColumnComboElement.Columns.Add(column);
column = new GridViewTextBoxColumn("Date");
column.FormatString = "{0:dd/MM/yyyy}";
multiColumnComboElement.Columns.Add(column);
column = new GridViewTextBoxColumn("Notes");
multiColumnComboElement.Columns.Add(column);
this.DataSource = dbContext.Mat_Requests.Where(mr => mr.Status != "Chưa được duyệt" && mr.Status != "Kết thúc").ToList <Mat_Requests>();
this.DisplayMember = "Code";
this.ValueMember = "RequestID";
}
private void FormatSMSTempletGrid()
{
grdSMSTemplets.CellDoubleClick += new GridViewCellEventHandler(grdSMSTemplets_CellDoubleClick);
grdSMSTemplets.CommandCellClick += new CommandCellClickEventHandler(grdSMSTemplets_CommandCellClick);
grdSMSTemplets.ShowGroupPanel = false;
GridViewTextBoxColumn col = new GridViewTextBoxColumn();
col.IsVisible = false;
col.Name = COL_SMSTEMPLET.ID;
grdSMSTemplets.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.IsVisible = false;
col.Name = COL_SMSTEMPLET.POLICYID;
grdSMSTemplets.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.HeaderText = "Templates Message";
col.Width = 640;
col.ReadOnly = true;
col.Name = COL_SMSTEMPLET.Tempplet;
grdSMSTemplets.Columns.Add(col);
grdSMSTemplets.AddDeleteColumn();
grdSMSTemplets.AllowAddNewRow = false;
grdSMSTemplets.ShowGroupPanel = false;
grdSMSTemplets.ShowRowHeaderColumn = false;
grdSMSTemplets.CurrentRow = null;
}
private void BindGrid()
{
//in this column we are going to store our RadDropDownButton
//which comes from our CustomCell
GridViewTextBoxColumn editButtonColumn = new GridViewTextBoxColumn("Edit");
editButtonColumn.FieldName = "Edit";
editButtonColumn.ReadOnly = true;
editButtonColumn.HeaderText = "Edit";
editButtonColumn.Width = 200;
radGridView1.MasterTemplate.Columns.Add(editButtonColumn);
GridViewTextBoxColumn textBoxColumn = new GridViewTextBoxColumn("TextBoxColumn");
textBoxColumn.FieldName = "TextBoxColumn";
textBoxColumn.HeaderText = "TextBoxColumn";
textBoxColumn.Width = 200;
radGridView1.MasterTemplate.Columns.Add(textBoxColumn);
GridViewDateTimeColumn dateTimeColumn = new GridViewDateTimeColumn("DateTimeColumn");
dateTimeColumn.FieldName = "DateTimeColumn";
dateTimeColumn.HeaderText = "DateTimeColumn";
dateTimeColumn.Width = 200;
radGridView1.MasterTemplate.Columns.Add(dateTimeColumn);
for (int i = 0; i < 10; i++)
{
radGridView1.Rows.Add(null, "Some Text " + i, DateTime.Now.AddHours(i));
}
}
public static GridViewDataColumn GenerateGridviewColumn(string fieldName, string header, bool readOnly, int width, GridViewColumnType columnType)
{
var columnw = new GridViewHyperlinkColumn();
GridViewDataColumn column = null;
if (columnType == GridViewColumnType.Text)
{
column = new GridViewTextBoxColumn();
}
else if (columnType == GridViewColumnType.Numeric)
{
column = new GridViewTextBoxColumn();
}
else if (columnType == GridViewColumnType.CheckBox)
{
column = new GridViewCheckBoxColumn();
(column as GridViewCheckBoxColumn).ThreeState = true;
}
else if (columnType == GridViewColumnType.Command)
{
column = new GridViewCommandColumn();
}
else if (columnType == GridViewColumnType.Link)
{
column = new GridViewHyperlinkColumn();
}
column.Name = fieldName;
column.FieldName = fieldName;
column.HeaderText = header;
column.ReadOnly = readOnly;
column.Width = width;
return(column);
}
private void PrepareGrid()
{
GridViewImageColumn imageColumn = new GridViewImageColumn("Imagem")
{
Width = 16,
HeaderText = String.Empty,
TextAlignment = ContentAlignment.MiddleCenter
};
GridViewTextBoxColumn dateColumn = new GridViewTextBoxColumn("Data")
{
Width = 50,
TextAlignment = ContentAlignment.MiddleCenter
};
GridViewTextBoxColumn infoColumn = new GridViewTextBoxColumn("Informações")
{
Width = 90,
TextAlignment = ContentAlignment.MiddleLeft
};
GrdListConnection.Columns.Add(imageColumn);
GrdListConnection.Columns.Add(dateColumn);
GrdListConnection.Columns.Add(infoColumn);
GrdListConnection.TableElement.RowHeight = 22;
GrdListConnection.MasterTemplate.AllowRowReorder = false;
GrdListConnection.ReadOnly = true;
GrdListConnection.MasterTemplate.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
}
private void refreshGrid()
{
radGridView1.Columns.Clear();
var data = _repo.getColumns(_tableName);
GridViewDataColumn colmn = null;
foreach (var item in data)
{
var itemType = MetaDataSourceExtension.GetArtificialFieldType(item.FieldType, false);
if (itemType == typeof(string))
{
colmn = new GridViewTextBoxColumn();
colmn.TextAlignment = ContentAlignment.BottomLeft;
colmn.Width = 50;
}
else if (itemType == typeof(bool))
{
colmn = new GridViewCheckBoxColumn();
colmn.TextAlignment = ContentAlignment.MiddleCenter;
colmn.Width = 50;
}
else
{
colmn = new GridViewTextBoxColumn();
colmn.TextAlignment = ContentAlignment.MiddleCenter;
colmn.Width = 50;
}
colmn.DataType = itemType;
colmn.Name = item.Name;
colmn.HeaderText = item.Name;
colmn.FieldName = item.Name;
radGridView1.Columns.Add(colmn);
}
}
private void FormatLocationGrid()
{
grdLocations.AllowAutoSizeColumns = true;
grdLocations.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
grdLocations.AllowAddNewRow = false;
grdLocations.ShowGroupPanel = false;
grdLocations.AutoCellFormatting = true;
grdLocations.ShowRowHeaderColumn = false;
grdLocations.EnableFiltering = true;
GridViewCheckBoxColumn cbcol = new GridViewCheckBoxColumn();
cbcol.Name = COLSD.Delete;
cbcol.HeaderText = "";
cbcol.Width = 50;
grdLocations.Columns.Add(cbcol);
GridViewTextBoxColumn col = new GridViewTextBoxColumn();
col.IsVisible = false;
col.Name = COLSD.Id;
grdLocations.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.Width = 220;
col.Name = COLSD.Address;
col.ReadOnly = true;
grdLocations.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.IsVisible = false;
col.Name = COLSD.HalfPostCode;
grdLocations.Columns.Add(col);
}
public Form1()
{
InitializeComponent();
//populate with data
GridViewTextBoxColumn col = new GridViewTextBoxColumn("col");
col.Width = 200;
radGridView1.Columns.Add(col);
for (int i = 0; i < 10; i++)
{
radGridView1.Rows.Add("Row " + i);
radTreeView1.Nodes.Add("Node " + i);
}
//register the custom row behavior
BaseGridBehavior gridBehavior = this.radGridView1.GridBehavior as BaseGridBehavior;
gridBehavior.UnregisterBehavior(typeof(GridViewDataRowInfo));
gridBehavior.RegisterBehavior(typeof(GridViewDataRowInfo), new CustomGridDataRowBehavior());
RadDragDropService dragDropService = radGridView1.GridViewElement.GetService <RadDragDropService>();
dragDropService.PreviewDragStart += dragDropService_PreviewDragStart;
dragDropService.PreviewDragOver += dragDropService_PreviewDragOver;
dragDropService.PreviewDragDrop += dragDropService_PreviewDragDrop;
dragDropService.PreviewDragHint += dragDropService_PreviewDragHint;
dragDropService.Stopped += dragDropService_Stopped;
}
private void FormatGrid()
{
try
{
grdNearestDrv.Visible = true;
GridViewTextBoxColumn col = new GridViewTextBoxColumn();
col.HeaderText = "Id";
col.Name = "Id";
col.IsVisible = false;
grdNearestDrv.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.HeaderText = "Driver No";
col.Name = "Driver";
col.Width = 380;
grdNearestDrv.Columns.Add(col);
grdNearestDrv.CellDoubleClick += new GridViewCellEventHandler(grdNearestDrv_CellDoubleClick);
grdNearestDrv.RowFormatting += new RowFormattingEventHandler(grdNearestDrv_RowFormatting);
}
catch (Exception ex)
{
}
}
private void FormatGrid()
{
grdPostCodes.AllowAutoSizeColumns = true;
grdPostCodes.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
grdPostCodes.AllowAddNewRow = false;
grdPostCodes.ShowGroupPanel = false;
grdPostCodes.AutoCellFormatting = true;
grdPostCodes.ShowRowHeaderColumn = false;
//grdDocuments.CommandCellClick += new CommandCellClickEventHandler(grdDocuments_CommandCellClick);
GridViewTextBoxColumn col = new GridViewTextBoxColumn();
col.IsVisible = false;
col.Name = COLS.Id;
grdPostCodes.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.IsVisible = false;
col.Name = COLS.MasterId;
grdPostCodes.Columns.Add(col);
//col = new GridViewTextBoxColumn();
//col.HeaderText = "Area";
//col.Name = COLS.Area;
//col.ReadOnly = true;
//col.Width = 120;
//grdPostCodes.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.HeaderText = "Post Code";
col.Name = COLS.PostCode;
col.Width = 100;
col.ReadOnly = true;
grdPostCodes.Columns.Add(col);
UI.GridFunctions.AddDeleteColumn(grdPostCodes);
RadListDataItem item = new RadListDataItem();
item.Text = "Inner";
item.Value = 1;
ddlKind.Items.Add(item);
item = new RadListDataItem();
item.Text = "Outer";
item.Value = 2;
item.Selected = true;
ddlKind.Items.Add(item);
}
private void FormatServiceChargesGrid()
{
GridViewTextBoxColumn col = new GridViewTextBoxColumn();
col.Name = COLS.Id;
col.IsVisible = false;
grdServiceCharges.Columns.Add(col);
GridViewCheckBoxColumn colcHK = new GridViewCheckBoxColumn();
colcHK.Name = COLS.Account;
colcHK.HeaderText = "Account";
colcHK.Width = 70;
grdServiceCharges.Columns.Add(colcHK);
GridViewDecimalColumn dcol = new GridViewDecimalColumn();
dcol.Name = COLS.FromValue;
dcol.HeaderText = "From";
dcol.Width = 90;
grdServiceCharges.Columns.Add(dcol);
dcol = new GridViewDecimalColumn();
dcol.Name = COLS.ToValue;
dcol.HeaderText = "Till";
dcol.Width = 90;
grdServiceCharges.Columns.Add(dcol);
dcol = new GridViewDecimalColumn();
dcol.Name = COLS.ServiceChargePercent;
dcol.HeaderText = "Service Charge Percent";
dcol.Width = 170;
grdServiceCharges.Columns.Add(dcol);
GridViewCheckBoxColumn cbcol = new GridViewCheckBoxColumn();
cbcol.Name = COLS.AmountWise;
cbcol.HeaderText = "Amount Wise";
cbcol.Width = 120;
grdServiceCharges.Columns.Add(cbcol);
//grdServiceCharges.AddEditColumn();
dcol = new GridViewDecimalColumn();
dcol.Name = COLS.ServiceChargeAmount;
dcol.HeaderText = "Service Charge Amount";
dcol.Width = 170;
grdServiceCharges.Columns.Add(dcol);
grdServiceCharges.AddDeleteColumn();
grdServiceCharges.ShowRowHeaderColumn = false;
//grdServiceCharges.Columns["btnEdit"].Width = 100;
grdServiceCharges.Columns["btnDelete"].Width = 80;
}
private void FormatSurchargeRateGrid()
{
grdSurchargeRates.ShowGroupPanel = false;
GridViewTextBoxColumn col = new GridViewTextBoxColumn();
col.IsVisible = false;
col.Name = COL_SURCHARGERATES.ID;
grdSurchargeRates.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.IsVisible = false;
col.Name = COL_SURCHARGERATES.POLICYID;
grdSurchargeRates.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.HeaderText = COL_SURCHARGERATES.POSTCODE;
col.Width = 100;
col.Name = COL_SURCHARGERATES.POSTCODE;
grdSurchargeRates.Columns.Add(col);
GridViewCheckBoxColumn colChk = new GridViewCheckBoxColumn();
colChk.HeaderText = "Amount Wise";
colChk.Width = 110;
colChk.Name = COL_SURCHARGERATES.AMOUNTWISE;
grdSurchargeRates.Columns.Add(colChk);
GridViewDecimalColumn col2 = new GridViewDecimalColumn();
col2.HeaderText = "Percentage (%)";
col2.Width = 110;
col2.Maximum = 100;
col2.Name = COL_SURCHARGERATES.PERCENTAGE;
grdSurchargeRates.Columns.Add(col2);
col2 = new GridViewDecimalColumn();
col2.HeaderText = "Amount (£)";
col2.Width = 110;
col2.Maximum = 100000;
col2.Name = COL_SURCHARGERATES.AMOUNT;
grdSurchargeRates.Columns.Add(col2);
UI.GridFunctions.AddDeleteColumn(grdSurchargeRates);
grdSurchargeRates.ShowGroupPanel = false;
grdSurchargeRates.AddNewRowPosition = SystemRowPosition.Bottom;
grdSurchargeRates.CellBeginEdit += new GridViewCellCancelEventHandler(grdSurchargeRates_CellBeginEdit);
grdSurchargeRates.CellEndEdit += GrdSurchargeRates_CellEndEdit;
}
private void FormatGrid()
{
grdPriceplot.AllowAutoSizeColumns = true;
grdPriceplot.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
grdPriceplot.AllowAddNewRow = false;
grdPriceplot.ShowGroupPanel = false;
grdPriceplot.AutoCellFormatting = true;
grdPriceplot.ShowRowHeaderColumn = false;
//grdDocuments.CommandCellClick += new CommandCellClickEventHandler(grdDocuments_CommandCellClick);
GridViewTextBoxColumn col = new GridViewTextBoxColumn();
col.IsVisible = false;
col.Name = COLS_PricePlot.ID;
grdPriceplot.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.HeaderText = "Name";
col.Name = COLS_PricePlot.NAME;
col.Width = 100;
col.ReadOnly = true;
grdPriceplot.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.HeaderText = "From";
col.Name = COLS_PricePlot.FROMPRICE;
col.ReadOnly = true;
col.Width = 60;
grdPriceplot.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.HeaderText = "Till";
col.Name = COLS_PricePlot.TILLPRICE;
col.ReadOnly = true;
col.Width = 60;
grdPriceplot.Columns.Add(col);
//UI.GridFunctions.AddDeleteColumn(grdPriceplot);
grdPriceplot.AddEditColumn();
grdPriceplot.Columns["btnEdit"].Width = 60;
grdPriceplot.AddDeleteColumn();
grdPriceplot.Columns["btnDelete"].Width = 80;
//UI.GridFunctions.AddDeleteColumn(grdPriceplot);
grdPriceplot.EnableFiltering = true;
// UI.GridFunctions.SetFilter(grdPriceplot);
}
public void LoadLocations()
{
GridViewTextBoxColumn col = new GridViewTextBoxColumn();
col.IsVisible = false;
col.Name = "Id";
grdLocationTypes.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.Name = "LocationType";
col.ReadOnly = true;
col.HeaderText = "Location Type";
grdLocationTypes.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.Name = "ShortCutKey";
col.ReadOnly = false;
col.HeaderText = "Short Cut Key";
grdLocationTypes.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.Name = "ShortKey";
col.ReadOnly = true;
col.HeaderText = "ShortKey";
grdLocationTypes.Columns.Add(col);
// grdLocationTypes.CellEndEdit += new GridViewCellEventHandler(grdLocationTypes_CellEndEdit);
grdLocationTypes.CellValidating += new CellValidatingEventHandler(grdLocationTypes_CellValidating);
var data1 = General.GetQueryable <Gen_LocationType>(c => c.Id != Enums.LOCATION_TYPES.ADDRESS && c.Id != Enums.LOCATION_TYPES.POSTCODE);// (c => c.CustomerMobileNo != null && c.CustomerPhoneNo != null);
var query = (from a in data1
select new
{
Id = a.Id,
LocationType = a.LocationType,
ShortCutKey = a.ShortCutKey,
}).ToList();
grdLocationTypes.RowCount = query.Count;
for (int i = 0; i < query.Count; i++)
{
grdLocationTypes.Rows[i].Cells[COLS.Id].Value = query[i].Id;
grdLocationTypes.Rows[i].Cells[COLS.LocationType].Value = query[i].LocationType;
grdLocationTypes.Rows[i].Cells[COLS.ShortCutKey].Value = query[i].ShortCutKey;
grdLocationTypes.Rows[i].Cells[COLS.ShortKey].Value = query[i].ShortCutKey;
}
grdLocationTypes.Columns["LocationType"].HeaderText = "Location Type";
grdLocationTypes.Columns["ShortCutKey"].HeaderText = "Short Cut Key";
grdLocationTypes.Columns["LocationType"].Width = 200;
grdLocationTypes.Columns["ShortCutKey"].Width = 157;
grdLocationTypes.Columns["ShortKey"].IsVisible = false;
grdLocationTypes.Columns["Id"].IsVisible = false;
}
private void PrepareUnboundGrid(DragAndDropRadGrid grid)
{
GridViewTextBoxColumn firstName = new GridViewTextBoxColumn("FirstName", "FirstName");
firstName.HeaderText = "First Name";
GridViewTextBoxColumn lastName = new GridViewTextBoxColumn("LastName", "LastName");
lastName.HeaderText = "Last Name";
grid.Columns.AddRange(firstName, lastName);
}
private void InitializeDataGrid()
{
#region SetDataGrid
Rgv_ReportAllLeaveCount.AutoGenerateColumns = false;
Rgv_ReportAllLeaveCount.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
Rgv_ReportAllLeaveCount.Dock = DockStyle.Fill;
Rgv_ReportAllLeaveCount.ReadOnly = true;
GridViewTextBoxColumn PWEMPLOYEE = new GridViewTextBoxColumn();
PWEMPLOYEE.Name = "PWEMPLOYEE";
PWEMPLOYEE.FieldName = "PWEMPLOYEE";
PWEMPLOYEE.HeaderText = "รหัสพนักงาน";
PWEMPLOYEE.IsVisible = true;
PWEMPLOYEE.ReadOnly = true;
PWEMPLOYEE.BestFit();
Rgv_ReportAllLeaveCount.Columns.Add(PWEMPLOYEE);
GridViewTextBoxColumn PWNAME = new GridViewTextBoxColumn();
PWNAME.Name = "PWNAME";
PWNAME.FieldName = "PWNAME";
PWNAME.HeaderText = "ชื่อพนักงาน";
PWNAME.IsVisible = true;
PWNAME.ReadOnly = true;
PWNAME.BestFit();
Rgv_ReportAllLeaveCount.Columns.Add(PWNAME);
GridViewTextBoxColumn LEAVETYPE = new GridViewTextBoxColumn();
LEAVETYPE.Name = "LEAVETYPE";
LEAVETYPE.FieldName = "LEAVETYPE";
LEAVETYPE.HeaderText = "ประเภทการลา";
LEAVETYPE.IsVisible = true;
LEAVETYPE.ReadOnly = true;
LEAVETYPE.BestFit();
Rgv_ReportAllLeaveCount.Columns.Add(LEAVETYPE);
GridViewTextBoxColumn LEAVECOUNT = new GridViewTextBoxColumn();
LEAVECOUNT.Name = "LEAVECOUNT";
LEAVECOUNT.FieldName = "LEAVECOUNT";
LEAVECOUNT.HeaderText = "จำนวนวัน";
LEAVECOUNT.IsVisible = true;
LEAVECOUNT.ReadOnly = true;
LEAVECOUNT.BestFit();
Rgv_ReportAllLeaveCount.Columns.Add(LEAVECOUNT);
GridViewCommandColumn DetaiButton = new GridViewCommandColumn();
DetaiButton.Name = "DetaiButton";
DetaiButton.FieldName = "DetaiButton";
DetaiButton.HeaderText = "รายละเอียด";
Rgv_ReportAllLeaveCount.Columns.Add(DetaiButton);
#endregion
}
async private void BindingDataSource()
{
this.radGridViewBind.Dock = DockStyle.Fill;
this.radGridViewBind.Visible = true;
this.radGridViewStock.Visible = false;
this.radGridViewBind.DataSource = null;
GridViewTextBoxColumn order = this.radGridViewBind.Columns[DataGridViewColumnName.rdvc_order.ToString()] as GridViewTextBoxColumn;
//GridViewComboBoxColumn materialCode = this.radGridView1.Columns[DataGridViewColumnName.rdvc_materialCode.ToString()] as GridViewComboBoxColumn;
GridViewComboBoxColumn productTypeNo = this.radGridViewBind.Columns[DataGridViewColumnName.rdvc_typeNo.ToString()] as GridViewComboBoxColumn;
GridViewTextBoxColumn describle = this.radGridViewBind.Columns[DataGridViewColumnName.rdvc_describle.ToString()] as GridViewTextBoxColumn;
DataTable materialCodeDt = (await serviceClient.SelectMaterialPNAsync()).Tables[0]; //0
DataTable typeNoDt = (await serviceClient.SelectProductContinairCapacityAsync("")).Tables[0]; //1
List <string> materialListTemp = new List <string>();
List <string> typeNoListTemp = new List <string>();
this.radGridViewBind.BeginEdit();
if (materialCodeDt.Rows.Count > 0)
{
for (int i = 0; i < materialCodeDt.Rows.Count; i++)
{
var materialPN = materialCodeDt.Rows[i][0].ToString();
var materialName = materialCodeDt.Rows[i][1].ToString();
if (!materialListTemp.Contains(materialPN))
{
if (!string.IsNullOrEmpty(materialName))
{
materialListTemp.Add(materialPN + "(" + materialName + ")");
}
else
{
materialListTemp.Add(materialPN);
}
}
}
}
if (typeNoDt.Rows.Count > 0)
{
for (int i = 0; i < typeNoDt.Rows.Count; i++)
{
typeNoListTemp.Add(typeNoDt.Rows[i][0].ToString());
}
}
//materialCode.DataSource = materialListTemp;
productTypeNo.DataSource = typeNoListTemp;
SelectData();
this.radGridViewBind.EndEdit();
//设置第一列不可编辑
this.radGridViewBind.Columns[0].ReadOnly = true;
this.radGridViewBind.Columns[5].ReadOnly = true;
this.radGridViewBind.Columns[6].ReadOnly = true;
this.pmListTemp.Clear();
}
public static void initializeRadgridCell(ref RadGridView _radgrid, string _tableName)
{
Telerik.WinControls.UI.GridViewTextBoxColumn cell;
Telerik.WinControls.UI.GridViewCheckBoxColumn cellCb;
var schema = getTableSchema(_tableName);
foreach (DataRow row in schema.Rows)
{
if (!IsCheckboxCellType(row["COLUMN_NAME"].ToString().ToUpper()))
{
cellCb = new GridViewCheckBoxColumn();
cellCb.Name = row["COLUMN_NAME"].ToString();
cellCb.FieldName = row["COLUMN_NAME"].ToString();
cellCb.HeaderText = row["COLUMN_DESCRIPTION"].ToString();
cellCb.IsVisible = true;
cellCb.ReadOnly = true;
cellCb.DataType = typeOf(row["DATA_TYPE"].ToString());
cellCb.ThreeState = false;
cellCb.BestFit();
_radgrid.MasterTemplate.Columns.Add(cellCb);
}
else
{
cell = new GridViewTextBoxColumn();
cell.Name = row["COLUMN_NAME"].ToString();
cell.FieldName = row["COLUMN_NAME"].ToString();
cell.HeaderText = row["COLUMN_DESCRIPTION"].ToString();
cell.IsVisible = true;
cell.ReadOnly = true;
cell.DataType = typeOf(row["DATA_TYPE"].ToString());//getType(row["DATA_TYPE"].ToString());
//cell.FormatString = (cell.DataType == typeof(decimal)) ? "{0:N2}" : (cell.DataType == typeof(DateTime) && row["COLUMN_NAME"].ToString() == "") ? "{0:dd/MM/yyyy}" : "{0}";
cell.FormatString = getCellFormatString(cell.DataType, cell.FieldName);
cell.BestFit();
_radgrid.MasterTemplate.Columns.Add(cell);
}
}
//return _radgrid;
}
private void InitializeDataGrid()
{
rvg_LeaveDetail.AutoGenerateColumns = false;
rvg_LeaveDetail.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
rvg_LeaveDetail.Dock = DockStyle.Fill;
rvg_LeaveDetail.ReadOnly = true;
GridViewTextBoxColumn PWDATEADJ = new GridViewTextBoxColumn();
PWDATEADJ.Name = "PWDATEADJ";
PWDATEADJ.FieldName = "PWDATEADJ";
PWDATEADJ.HeaderText = "วันที่ลา";
PWDATEADJ.IsVisible = true;
PWDATEADJ.ReadOnly = true;
PWDATEADJ.BestFit();
rvg_LeaveDetail.Columns.Add(PWDATEADJ);
GridViewTextBoxColumn LEAVETYPE = new GridViewTextBoxColumn();
LEAVETYPE.Name = "LEAVETYPE";
LEAVETYPE.FieldName = "LEAVETYPE";
LEAVETYPE.HeaderText = "ประเภทการลา";
LEAVETYPE.IsVisible = true;
LEAVETYPE.ReadOnly = true;
LEAVETYPE.BestFit();
rvg_LeaveDetail.Columns.Add(LEAVETYPE);
GridViewTextBoxColumn PWUPDTYPE = new GridViewTextBoxColumn();
PWUPDTYPE.Name = "PWUPDTYPE";
PWUPDTYPE.FieldName = "PWUPDTYPE";
PWUPDTYPE.HeaderText = "จำนวนวัน";
PWUPDTYPE.IsVisible = true;
PWUPDTYPE.ReadOnly = true;
PWUPDTYPE.BestFit();
rvg_LeaveDetail.Columns.Add(PWUPDTYPE);
}
/// <summary>
/// Inits the grid param def.
/// </summary>
private void InitGridParamDef()
{
this.gvParameterDefinition.Columns.Clear();
this.gvParameterDefinition.AllowEditRow = true;
var colId = new GridViewTextBoxColumn() { DataType = typeof(int), Name = "Id", FieldName = "Id", HeaderText = "Id", Width = 20, ReadOnly = true };
this.gvParameterDefinition.MasterTemplate.Columns.Add(colId);
var colActive = new GridViewCheckBoxColumn() { DataType = typeof(bool), Name = "IsActive", FieldName = "IsActive", HeaderText = "Bearbeiten", Width = 30, ReadOnly = false };
this.gvParameterDefinition.MasterTemplate.Columns.Add(colActive);
var colParamName = new GridViewTextBoxColumn() { DataType = typeof(string), Name = "Parametername", FieldName = "Name", HeaderText = "Parametername", MinWidth = 80, ReadOnly = true };
this.gvParameterDefinition.MasterTemplate.Columns.Add(colParamName);
var colParamObis = new GridViewTextBoxColumn() { DataType = typeof(string), Name = "Obis", FieldName = "ObisCode", HeaderText = "Obis", Width = 50, ReadOnly = true };
this.gvParameterDefinition.MasterTemplate.Columns.Add(colParamObis);
var colValName = new GridViewMaskBoxColumn() { DataType = typeof(string), Name = "Sollwert", FieldName = "TargetValue", HeaderText = "Sollwert", MinWidth = 80, ReadOnly = false };
colValName.MaskType = MaskType.Standard;
colValName.Mask = "?";
this.gvParameterDefinition.MasterTemplate.Columns.Add(colValName);
var colAutoIncrement = new GridViewCheckBoxColumn() { DataType = typeof(bool), Name = "Hochzählen", FieldName = "IsAutoIncrement", HeaderText = "Hochzählen", Width = 30, ReadOnly = false };
this.gvParameterDefinition.MasterTemplate.Columns.Add(colAutoIncrement);
}
private void InitializeDataGridView()
{
#region SetDataGrid
this.rgv_EmpData.Dock = DockStyle.Fill;
this.rgv_EmpData.ReadOnly = true;
this.rgv_EmpData.AutoGenerateColumns = true;
this.rgv_EmpData.EnableFiltering = false;
this.rgv_EmpData.AllowAddNewRow = false;
this.rgv_EmpData.MasterTemplate.AutoGenerateColumns = false;
this.rgv_EmpData.ShowGroupedColumns = true;
this.rgv_EmpData.MasterTemplate.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
this.rgv_EmpData.EnableHotTracking = true;
this.rgv_EmpData.AutoSizeRows = true;
GridViewTextBoxColumn COUNTDOC = new GridViewTextBoxColumn();
COUNTDOC.Name = "COUNTDOC";
COUNTDOC.FieldName = "COUNTDOC";
COUNTDOC.HeaderText = "ลำดับ";
COUNTDOC.IsVisible = true;
COUNTDOC.ReadOnly = true;
COUNTDOC.BestFit();
rgv_EmpData.Columns.Add(COUNTDOC);
GridViewTextBoxColumn FROMHOLIDAY = new GridViewTextBoxColumn();
FROMHOLIDAY.Name = "FROMHOLIDAY";
FROMHOLIDAY.FieldName = "FROMHOLIDAY";
FROMHOLIDAY.HeaderText = "วันที่มาทำ";
FROMHOLIDAY.IsVisible = true;
FROMHOLIDAY.ReadOnly = true;
FROMHOLIDAY.BestFit();
rgv_EmpData.Columns.Add(FROMHOLIDAY);
GridViewTextBoxColumn TOSHIFTID = new GridViewTextBoxColumn();
TOSHIFTID.Name = "TOSHIFTID";
TOSHIFTID.FieldName = "TOSHIFTID";
TOSHIFTID.HeaderText = "กะที่มาทำ";
TOSHIFTID.IsVisible = true;
TOSHIFTID.ReadOnly = true;
TOSHIFTID.BestFit();
rgv_EmpData.Columns.Add(TOSHIFTID);
GridViewTextBoxColumn TOSHIFTDESC = new GridViewTextBoxColumn();
TOSHIFTDESC.Name = "TOSHIFTDESC";
TOSHIFTDESC.FieldName = "TOSHIFTDESC";
TOSHIFTDESC.HeaderText = "คำอธิบาย";
TOSHIFTDESC.IsVisible = true;
TOSHIFTDESC.ReadOnly = true;
TOSHIFTDESC.BestFit();
rgv_EmpData.Columns.Add(TOSHIFTDESC);
GridViewTextBoxColumn TOHOLIDAY = new GridViewTextBoxColumn();
TOHOLIDAY.Name = "TOHOLIDAY";
TOHOLIDAY.FieldName = "TOHOLIDAY";
TOHOLIDAY.HeaderText = "วันที่หยุด";
TOHOLIDAY.IsVisible = true;
TOHOLIDAY.ReadOnly = true;
TOHOLIDAY.BestFit();
rgv_EmpData.Columns.Add(TOHOLIDAY);
GridViewTextBoxColumn REASON = new GridViewTextBoxColumn();
REASON.Name = "REASON";
REASON.FieldName = "REASON";
REASON.HeaderText = "เหตุผล";
REASON.IsVisible = true;
REASON.ReadOnly = true;
REASON.BestFit();
rgv_EmpData.Columns.Add(REASON);
GridViewTextBoxColumn TRANSDATE = new GridViewTextBoxColumn();
TRANSDATE.Name = "TRANSDATE";
TRANSDATE.FieldName = "TRANSDATE";
TRANSDATE.HeaderText = "วันที่บันทึก";
TRANSDATE.IsVisible = true;
TRANSDATE.ReadOnly = true;
TRANSDATE.BestFit();
rgv_EmpData.Columns.Add(TRANSDATE);
#endregion
}
public Leave_Hist(string Empid)
{
_empid = Empid;
InitializeComponent();
CheckApproveID();
Load_Section();
this.dt_FromSec.Text = DateTime.Now.ToString("yyyy-01-01");
this.dt_ToSec.Text = DateTime.Now.ToString("yyyy-MM-dd");
btn_SearchData.Click += new EventHandler(btn_SearchData_Click);
#region radGridView
// GridData
this.radGridView1.Dock = DockStyle.Fill;
this.radGridView1.ReadOnly = true;
this.radGridView1.AutoGenerateColumns = true;
this.radGridView1.EnableFiltering = false;
this.radGridView1.AllowAddNewRow = false;
this.radGridView1.MasterTemplate.AutoGenerateColumns = false;
this.radGridView1.ShowGroupedColumns = true;
this.radGridView1.MasterTemplate.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
this.radGridView1.EnableHotTracking = true;
this.radGridView1.AutoSizeRows = true;
GridViewTextBoxColumn YR = new GridViewTextBoxColumn();
YR.Name = "YR";
YR.FieldName = "YR";
YR.HeaderText = "ปี";
YR.IsVisible = true;
YR.ReadOnly = true;
YR.BestFit();
radGridView1.Columns.Add(YR);
GridViewTextBoxColumn FULLNAME = new GridViewTextBoxColumn();
FULLNAME.Name = "FULLNAME";
FULLNAME.FieldName = "FULLNAME";
FULLNAME.HeaderText = "ชื่อ - สกุล";
FULLNAME.IsVisible = true;
FULLNAME.ReadOnly = true;
FULLNAME.BestFit();
radGridView1.Columns.Add(FULLNAME);
GridViewTextBoxColumn EVENTNANE = new GridViewTextBoxColumn();
EVENTNANE.Name = "EVENTNANE";
EVENTNANE.FieldName = "EVENTNANE";
EVENTNANE.HeaderText = "ประเภท";
EVENTNANE.IsVisible = true;
EVENTNANE.ReadOnly = true;
EVENTNANE.BestFit();
radGridView1.Columns.Add(EVENTNANE);
GridViewTextBoxColumn USESUMMARY = new GridViewTextBoxColumn();
USESUMMARY.Name = "USESUMMARY";
USESUMMARY.FieldName = "USESUMMARY";
USESUMMARY.HeaderText = "ใช้ไป";
USESUMMARY.IsVisible = true;
USESUMMARY.ReadOnly = true;
USESUMMARY.BestFit();
radGridView1.Columns.Add(USESUMMARY);
GridViewTextBoxColumn TOTALL = new GridViewTextBoxColumn();
TOTALL.Name = "TOTALL";
TOTALL.FieldName = "TOTALL";
TOTALL.HeaderText = "คงเหลือ";
TOTALL.IsVisible = true;
TOTALL.ReadOnly = true;
TOTALL.BestFit();
radGridView1.Columns.Add(TOTALL);
#endregion
}
void InitializeSetGridView()
{
// GridData
this.rgv_ReportStatus.Dock = DockStyle.Fill;
this.rgv_ReportStatus.ReadOnly = true;
this.rgv_ReportStatus.AutoGenerateColumns = true;
this.rgv_ReportStatus.EnableFiltering = false;
this.rgv_ReportStatus.AllowAddNewRow = false;
this.rgv_ReportStatus.MasterTemplate.AutoGenerateColumns = false;
this.rgv_ReportStatus.ShowGroupedColumns = true;
this.rgv_ReportStatus.MasterTemplate.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
this.rgv_ReportStatus.EnableHotTracking = true;
this.rgv_ReportStatus.AutoSizeRows = true;
GridViewTextBoxColumn DOCID = new GridViewTextBoxColumn();
DOCID.Name = "DOCID";
DOCID.FieldName = "DOCID";
DOCID.HeaderText = "เลขที่เอกสาร";
DOCID.IsVisible = true;
DOCID.ReadOnly = true;
DOCID.BestFit();
rgv_ReportStatus.Columns.Add(DOCID);
GridViewTextBoxColumn CREATEDDATE = new GridViewTextBoxColumn();
CREATEDDATE.Name = "CREATEDDATE";
CREATEDDATE.FieldName = "CREATEDDATE";
CREATEDDATE.HeaderText = "วันที่สร้าง";
CREATEDDATE.IsVisible = true;
CREATEDDATE.ReadOnly = true;
CREATEDDATE.BestFit();
rgv_ReportStatus.Columns.Add(CREATEDDATE);
GridViewTextBoxColumn EMPLNAME = new GridViewTextBoxColumn();
EMPLNAME.Name = "EMPLNAME";
EMPLNAME.FieldName = "EMPLNAME";
EMPLNAME.HeaderText = "ชื่อ";
EMPLNAME.IsVisible = true;
EMPLNAME.ReadOnly = true;
EMPLNAME.BestFit();
rgv_ReportStatus.Columns.Add(EMPLNAME);
GridViewTextBoxColumn DOCTYP = new GridViewTextBoxColumn();
DOCTYP.Name = "DOCTYP";
DOCTYP.FieldName = "DOCTYP";
DOCTYP.HeaderText = "ชนิดเอกสารยกเลิก";
DOCTYP.IsVisible = false;
DOCTYP.ReadOnly = true;
DOCTYP.BestFit();
rgv_ReportStatus.Columns.Add(DOCTYP);
GridViewTextBoxColumn TYPDESC = new GridViewTextBoxColumn();
TYPDESC.Name = "TYPDESC";
TYPDESC.FieldName = "TYPDESC";
TYPDESC.HeaderText = "เอกสารยกเลิก";
TYPDESC.IsVisible = true;
TYPDESC.ReadOnly = true;
TYPDESC.BestFit();
rgv_ReportStatus.Columns.Add(TYPDESC);
GridViewTextBoxColumn HEADAPPROVED = new GridViewTextBoxColumn();
HEADAPPROVED.Name = "HEADAPPROVED";
HEADAPPROVED.FieldName = "HEADAPPROVED";
HEADAPPROVED.HeaderText = "หน./ผช.";
HEADAPPROVED.IsVisible = true;
HEADAPPROVED.ReadOnly = true;
HEADAPPROVED.BestFit();
rgv_ReportStatus.Columns.Add(HEADAPPROVED);
GridViewTextBoxColumn HEADAPPROVEDBYNAME = new GridViewTextBoxColumn();
HEADAPPROVEDBYNAME.Name = "HEADAPPROVEDBYNAME";
HEADAPPROVEDBYNAME.FieldName = "HEADAPPROVEDBYNAME";
HEADAPPROVEDBYNAME.HeaderText = "ผู้อนุมัติ";
HEADAPPROVEDBYNAME.IsVisible = true;
HEADAPPROVEDBYNAME.ReadOnly = true;
HEADAPPROVEDBYNAME.BestFit();
rgv_ReportStatus.Columns.Add(HEADAPPROVEDBYNAME);
GridViewTextBoxColumn HEADAPPROVEDDATE = new GridViewTextBoxColumn();
HEADAPPROVEDDATE.Name = "HEADAPPROVEDDATE";
HEADAPPROVEDDATE.FieldName = "HEADAPPROVEDDATE";
HEADAPPROVEDDATE.HeaderText = "วันที่อนุมัติ";
HEADAPPROVEDDATE.IsVisible = true;
HEADAPPROVEDDATE.ReadOnly = true;
HEADAPPROVEDDATE.BestFit();
rgv_ReportStatus.Columns.Add(HEADAPPROVEDDATE);
GridViewTextBoxColumn HEADAPPORVEREMARK = new GridViewTextBoxColumn();
HEADAPPORVEREMARK.Name = "HEADAPPORVEREMARK";
HEADAPPORVEREMARK.FieldName = "HEADAPPORVEREMARK";
HEADAPPORVEREMARK.HeaderText = "หมายเหตุ";
HEADAPPORVEREMARK.IsVisible = true;
HEADAPPORVEREMARK.ReadOnly = true;
HEADAPPORVEREMARK.BestFit();
rgv_ReportStatus.Columns.Add(HEADAPPORVEREMARK);
GridViewTextBoxColumn HRAPPROVED = new GridViewTextBoxColumn();
HRAPPROVED.Name = "HRAPPROVED";
HRAPPROVED.FieldName = "HRAPPROVED";
HRAPPROVED.HeaderText = "บุคคล";
HRAPPROVED.IsVisible = true;
HRAPPROVED.ReadOnly = true;
HRAPPROVED.BestFit();
rgv_ReportStatus.Columns.Add(HRAPPROVED);
GridViewTextBoxColumn HRAPPROVEDBYNAME = new GridViewTextBoxColumn();
HRAPPROVEDBYNAME.Name = "HRAPPROVEDBYNAME";
HRAPPROVEDBYNAME.FieldName = "HRAPPROVEDBYNAME";
HRAPPROVEDBYNAME.HeaderText = "ผู้อนุมัติ";
HRAPPROVEDBYNAME.IsVisible = true;
HRAPPROVEDBYNAME.ReadOnly = true;
HRAPPROVEDBYNAME.BestFit();
rgv_ReportStatus.Columns.Add(HRAPPROVEDBYNAME);
GridViewTextBoxColumn HRAPPROVEDDATE = new GridViewTextBoxColumn();
HRAPPROVEDDATE.Name = "HRAPPROVEDDATE";
HRAPPROVEDDATE.FieldName = "HRAPPROVEDDATE";
HRAPPROVEDDATE.HeaderText = "วันที่อนุมัติ";
HRAPPROVEDDATE.IsVisible = true;
HRAPPROVEDDATE.ReadOnly = true;
HRAPPROVEDDATE.BestFit();
rgv_ReportStatus.Columns.Add(HRAPPROVEDDATE);
GridViewCommandColumn DetailButton = new GridViewCommandColumn();
DetailButton.Name = "DetailButton";
DetailButton.FieldName = "DetailButton";
DetailButton.HeaderText = "รายละเอียด";
rgv_ReportStatus.Columns.Add(DetailButton);
}
private void InitializeDataGridView()
{
#region SetDataGrid
this.rgv_EmpData.Dock = DockStyle.Fill;
this.rgv_EmpData.ReadOnly = true;
this.rgv_EmpData.AutoGenerateColumns = true;
this.rgv_EmpData.EnableFiltering = false;
this.rgv_EmpData.AllowAddNewRow = false;
this.rgv_EmpData.MasterTemplate.AutoGenerateColumns = false;
this.rgv_EmpData.ShowGroupedColumns = true;
this.rgv_EmpData.MasterTemplate.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
this.rgv_EmpData.EnableHotTracking = true;
this.rgv_EmpData.AutoSizeRows = true;
GridViewTextBoxColumn TYPDESC = new GridViewTextBoxColumn();
TYPDESC.Name = "TYPDESC";
TYPDESC.FieldName = "TYPDESC";
TYPDESC.HeaderText = "ประเภทเอกสาร";
TYPDESC.IsVisible = true;
TYPDESC.ReadOnly = true;
TYPDESC.BestFit();
rgv_EmpData.Columns.Add(TYPDESC);
GridViewTextBoxColumn DLDOCNO = new GridViewTextBoxColumn();
DLDOCNO.Name = "DLDOCNO";
DLDOCNO.FieldName = "DLDOCNO";
DLDOCNO.HeaderText = "เลขที่เอกสาร";
DLDOCNO.IsVisible = true;
DLDOCNO.ReadOnly = true;
DLDOCNO.BestFit();
rgv_EmpData.Columns.Add(DLDOCNO);
GridViewTextBoxColumn LEAVEDATE = new GridViewTextBoxColumn();
LEAVEDATE.Name = "LEAVEDATE";
LEAVEDATE.FieldName = "LEAVEDATE";
LEAVEDATE.HeaderText = "วันที่ลาหยุด";
LEAVEDATE.IsVisible = true;
LEAVEDATE.ReadOnly = true;
LEAVEDATE.BestFit();
rgv_EmpData.Columns.Add(LEAVEDATE);
GridViewTextBoxColumn LEAVETYPEDETAIL = new GridViewTextBoxColumn();
LEAVETYPEDETAIL.Name = "LEAVETYPEDETAIL";
LEAVETYPEDETAIL.FieldName = "LEAVETYPEDETAIL";
LEAVETYPEDETAIL.HeaderText = "ประเภทการลา";
LEAVETYPEDETAIL.IsVisible = true;
LEAVETYPEDETAIL.ReadOnly = true;
LEAVETYPEDETAIL.BestFit();
rgv_EmpData.Columns.Add(LEAVETYPEDETAIL);
GridViewTextBoxColumn ATTACH = new GridViewTextBoxColumn();
ATTACH.Name = "ATTACH";
ATTACH.FieldName = "ATTACH";
ATTACH.HeaderText = "ใบรับรองแพทย์";
ATTACH.IsVisible = true;
ATTACH.ReadOnly = true;
ATTACH.BestFit();
rgv_EmpData.Columns.Add(ATTACH);
GridViewTextBoxColumn HALFDAY = new GridViewTextBoxColumn();
HALFDAY.Name = "HALFDAY";
HALFDAY.FieldName = "HALFDAY";
HALFDAY.HeaderText = "จำนวนวัน";
HALFDAY.IsVisible = true;
HALFDAY.ReadOnly = true;
HALFDAY.BestFit();
rgv_EmpData.Columns.Add(HALFDAY);
GridViewTextBoxColumn HALFDAYTIME1 = new GridViewTextBoxColumn();
HALFDAYTIME1.Name = "HALFDAYTIME1";
HALFDAYTIME1.FieldName = "HALFDAYTIME1";
HALFDAYTIME1.HeaderText = "ตั้งแต่เวลา";
HALFDAYTIME1.IsVisible = true;
HALFDAYTIME1.ReadOnly = true;
HALFDAYTIME1.BestFit();
rgv_EmpData.Columns.Add(HALFDAYTIME1);
GridViewTextBoxColumn HALFDAYTIME2 = new GridViewTextBoxColumn();
HALFDAYTIME2.Name = "HALFDAYTIME2";
HALFDAYTIME2.FieldName = "HALFDAYTIME2";
HALFDAYTIME2.HeaderText = "ถึงเวลา";
HALFDAYTIME2.IsVisible = true;
HALFDAYTIME2.ReadOnly = true;
HALFDAYTIME2.BestFit();
rgv_EmpData.Columns.Add(HALFDAYTIME2);
GridViewTextBoxColumn LEAVEREMARK = new GridViewTextBoxColumn();
LEAVEREMARK.Name = "LEAVEREMARK";
LEAVEREMARK.FieldName = "LEAVEREMARK";
LEAVEREMARK.HeaderText = "เหตุผล";
LEAVEREMARK.IsVisible = true;
LEAVEREMARK.ReadOnly = true;
LEAVEREMARK.BestFit();
rgv_EmpData.Columns.Add(LEAVEREMARK);
GridViewTextBoxColumn CREATEDDATE = new GridViewTextBoxColumn();
CREATEDDATE.Name = "CREATEDDATE";
CREATEDDATE.FieldName = "CREATEDDATE";
CREATEDDATE.HeaderText = "วันที่บันทึก";
CREATEDDATE.IsVisible = true;
CREATEDDATE.ReadOnly = true;
CREATEDDATE.BestFit();
rgv_EmpData.Columns.Add(CREATEDDATE);
#endregion
}
void InitializeGridView()
{
this.rgv_EmplData.Dock = DockStyle.Fill;
this.rgv_EmplData.ReadOnly = true;
this.rgv_EmplData.AutoGenerateColumns = true;
this.rgv_EmplData.EnableFiltering = false;
this.rgv_EmplData.AllowAddNewRow = false;
this.rgv_EmplData.MasterTemplate.AutoGenerateColumns = false;
this.rgv_EmplData.ShowGroupedColumns = true;
this.rgv_EmplData.MasterTemplate.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
this.rgv_EmplData.EnableHotTracking = true;
this.rgv_EmplData.AutoSizeRows = true;
GridViewTextBoxColumn PAYDESC = new GridViewTextBoxColumn();
PAYDESC.Name = "PAYDESC";
PAYDESC.FieldName = "PAYDESC";
PAYDESC.HeaderText = "รายการ";
PAYDESC.IsVisible = true;
PAYDESC.ReadOnly = true;
PAYDESC.BestFit();
rgv_EmplData.Columns.Add(PAYDESC);
GridViewTextBoxColumn JOBS = new GridViewTextBoxColumn();
JOBS.Name = "JOBS";
JOBS.FieldName = "JOBS";
JOBS.HeaderText = "จัดหางาน";
JOBS.IsVisible = true;
JOBS.ReadOnly = true;
JOBS.BestFit();
rgv_EmplData.Columns.Add(JOBS);
GridViewTextBoxColumn BROKERS = new GridViewTextBoxColumn();
BROKERS.Name = "BROKERS";
BROKERS.FieldName = "BROKERS";
BROKERS.HeaderText = "โบรกเกอร์";
BROKERS.IsVisible = true;
BROKERS.ReadOnly = true;
BROKERS.BestFit();
rgv_EmplData.Columns.Add(BROKERS);
GridViewTextBoxColumn CENTER = new GridViewTextBoxColumn();
CENTER.Name = "CENTER";
CENTER.FieldName = "CENTER";
CENTER.HeaderText = "ศูนย์พูลผล";
CENTER.IsVisible = true;
CENTER.ReadOnly = true;
CENTER.BestFit();
rgv_EmplData.Columns.Add(CENTER);
GridViewTextBoxColumn MIMIGRATION = new GridViewTextBoxColumn();
MIMIGRATION.Name = "MIMIGRATION";
MIMIGRATION.FieldName = "MIMIGRATION";
BROKERS.HeaderText = "ตม.";
MIMIGRATION.IsVisible = true;
MIMIGRATION.ReadOnly = true;
MIMIGRATION.BestFit();
rgv_EmplData.Columns.Add(MIMIGRATION);
GridViewTextBoxColumn HOSPITAL = new GridViewTextBoxColumn();
HOSPITAL.Name = "HOSPITAL";
HOSPITAL.FieldName = "HOSPITAL";
HOSPITAL.HeaderText = "รพ.";
HOSPITAL.IsVisible = true;
HOSPITAL.ReadOnly = true;
HOSPITAL.BestFit();
rgv_EmplData.Columns.Add(HOSPITAL);
GridViewTextBoxColumn DISTRICT = new GridViewTextBoxColumn();
DISTRICT.Name = "DISTRICT";
DISTRICT.FieldName = "DISTRICT";
DISTRICT.HeaderText = "อำเภอ";
DISTRICT.IsVisible = true;
DISTRICT.ReadOnly = true;
DISTRICT.BestFit();
rgv_EmplData.Columns.Add(DISTRICT);
GridViewTextBoxColumn SUMPAY = new GridViewTextBoxColumn();
SUMPAY.Name = "SUMPAY";
SUMPAY.FieldName = "SUMPAY";
SUMPAY.HeaderText = "รวม";
SUMPAY.IsVisible = true;
SUMPAY.ReadOnly = true;
SUMPAY.BestFit();
rgv_EmplData.Columns.Add(SUMPAY);
GridViewTextBoxColumn SUPC = new GridViewTextBoxColumn();
SUPC.Name = "SUPC";
SUPC.FieldName = "SUPC";
SUPC.HeaderText = "SUPC";
SUPC.IsVisible = true;
SUPC.ReadOnly = true;
SUPC.BestFit();
rgv_EmplData.Columns.Add(SUPC);
GridViewTextBoxColumn TOTAL = new GridViewTextBoxColumn();
TOTAL.Name = "TOTAL";
TOTAL.FieldName = "TOTAL";
TOTAL.HeaderText = "ยอดเรียกเก็บ";
TOTAL.IsVisible = true;
TOTAL.ReadOnly = true;
TOTAL.BestFit();
rgv_EmplData.Columns.Add(TOTAL);
GridViewSummaryRowItem summary = new GridViewSummaryRowItem();
summary.Add(new GridViewSummaryItem("JOBS", "{0:N2}", GridAggregateFunction.Sum));
summary.Add(new GridViewSummaryItem("BROKERS", "{0:N2}", GridAggregateFunction.Sum));
summary.Add(new GridViewSummaryItem("CENTER", "{0:N2}", GridAggregateFunction.Sum));
summary.Add(new GridViewSummaryItem("MIMIGRATION", "{0:N2}", GridAggregateFunction.Sum));
summary.Add(new GridViewSummaryItem("HOSPITAL", "{0:N2}", GridAggregateFunction.Sum));
summary.Add(new GridViewSummaryItem("DISTRICT", "{0:N2}", GridAggregateFunction.Sum));
summary.Add(new GridViewSummaryItem("SUMPAY", "{0:N2}", GridAggregateFunction.Sum));
summary.Add(new GridViewSummaryItem("SUPC", "{0:N2}", GridAggregateFunction.Sum));
summary.Add(new GridViewSummaryItem("TOTAL", "{0:N2}", GridAggregateFunction.Sum));
this.rgv_EmplData.MasterTemplate.SummaryRowsBottom.Add(summary);
}
void InitiazaGridView()
{
#region radGridView
// GridData
this.rgv_ApproveMN.Dock = DockStyle.Fill;
this.rgv_ApproveMN.ReadOnly = true;
this.rgv_ApproveMN.AutoGenerateColumns = true;
this.rgv_ApproveMN.EnableFiltering = false;
this.rgv_ApproveMN.AllowAddNewRow = false;
this.rgv_ApproveMN.MasterTemplate.AutoGenerateColumns = false;
this.rgv_ApproveMN.ShowGroupedColumns = true;
this.rgv_ApproveMN.MasterTemplate.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
this.rgv_ApproveMN.EnableHotTracking = true;
this.rgv_ApproveMN.AutoSizeRows = true;
GridViewTextBoxColumn DOCID = new GridViewTextBoxColumn();
DOCID.Name = "DOCID";
DOCID.FieldName = "DOCID";
DOCID.HeaderText = "เลขที่เอกสาร";
DOCID.IsVisible = true;
DOCID.ReadOnly = true;
DOCID.BestFit();
rgv_ApproveMN.Columns.Add(DOCID);
GridViewTextBoxColumn DOCSTAT = new GridViewTextBoxColumn();
DOCSTAT.Name = "DOCSTAT";
DOCSTAT.FieldName = "DOCSTAT";
DOCSTAT.HeaderText = "สถานะเอกสาร";
DOCSTAT.IsVisible = true;
DOCSTAT.ReadOnly = true;
DOCSTAT.BestFit();
rgv_ApproveMN.Columns.Add(DOCSTAT);
GridViewTextBoxColumn EMPLNAME = new GridViewTextBoxColumn();
EMPLNAME.Name = "EMPLNAME";
EMPLNAME.FieldName = "EMPLNAME";
EMPLNAME.HeaderText = "ชื่อ";
EMPLNAME.IsVisible = true;
EMPLNAME.ReadOnly = true;
EMPLNAME.BestFit();
rgv_ApproveMN.Columns.Add(EMPLNAME);
GridViewTextBoxColumn DEPTNAME = new GridViewTextBoxColumn();
DEPTNAME.Name = "DEPTNAME";
DEPTNAME.FieldName = "DEPTNAME";
DEPTNAME.HeaderText = "ตำแหน่ง";
DEPTNAME.IsVisible = true;
DEPTNAME.ReadOnly = true;
DEPTNAME.BestFit();
rgv_ApproveMN.Columns.Add(DEPTNAME);
GridViewTextBoxColumn HEADAPPROVED = new GridViewTextBoxColumn();
HEADAPPROVED.Name = "HEADAPPROVED";
HEADAPPROVED.FieldName = "HEADAPPROVED";
HEADAPPROVED.HeaderText = "หน./ผช.";
HEADAPPROVED.IsVisible = true;
HEADAPPROVED.ReadOnly = true;
HEADAPPROVED.BestFit();
rgv_ApproveMN.Columns.Add(HEADAPPROVED);
GridViewTextBoxColumn HEADAPPROVEDBYNAME = new GridViewTextBoxColumn();
HEADAPPROVEDBYNAME.Name = "HEADAPPROVEDBYNAME";
HEADAPPROVEDBYNAME.FieldName = "HEADAPPROVEDBYNAME";
HEADAPPROVEDBYNAME.HeaderText = "ผู้อนุมัติ";
HEADAPPROVEDBYNAME.IsVisible = true;
HEADAPPROVEDBYNAME.ReadOnly = true;
HEADAPPROVEDBYNAME.BestFit();
rgv_ApproveMN.Columns.Add(HEADAPPROVEDBYNAME);
GridViewTextBoxColumn HRAPPROVED = new GridViewTextBoxColumn();
HRAPPROVED.Name = "HRAPPROVED";
HRAPPROVED.FieldName = "HRAPPROVED";
HRAPPROVED.HeaderText = "บุคคล";
HRAPPROVED.IsVisible = true;
HRAPPROVED.ReadOnly = true;
HRAPPROVED.BestFit();
rgv_ApproveMN.Columns.Add(HRAPPROVED);
GridViewTextBoxColumn HRAPPROVEDBYNAME = new GridViewTextBoxColumn();
HRAPPROVEDBYNAME.Name = "HRAPPROVEDBYNAME";
HRAPPROVEDBYNAME.FieldName = "HRAPPROVEDBYNAME";
HRAPPROVEDBYNAME.HeaderText = "ผู้อนุมัติ";
HRAPPROVEDBYNAME.IsVisible = true;
HRAPPROVEDBYNAME.ReadOnly = true;
HRAPPROVEDBYNAME.BestFit();
rgv_ApproveMN.Columns.Add(HRAPPROVEDBYNAME);
GridViewCommandColumn ApproveButton = new GridViewCommandColumn();
ApproveButton.Name = "ApproveButton";
ApproveButton.FieldName = "ApproveButton";
ApproveButton.HeaderText = "อนุมัติ";
rgv_ApproveMN.Columns.Add(ApproveButton);
GridViewTextBoxColumn TRANSDATE = new GridViewTextBoxColumn();
TRANSDATE.Name = "TRANSDATE";
TRANSDATE.FieldName = "TRANSDATE";
TRANSDATE.HeaderText = "วันที่สร้าง";
TRANSDATE.IsVisible = false;
TRANSDATE.ReadOnly = true;
TRANSDATE.BestFit();
rgv_ApproveMN.Columns.Add(TRANSDATE);
#endregion
}
void GridViewCHDDT()
{
this.rgv_CHDDT.Dock = DockStyle.Fill;
this.rgv_CHDDT.ReadOnly = true;
this.rgv_CHDDT.AutoGenerateColumns = true;
this.rgv_CHDDT.EnableFiltering = false;
this.rgv_CHDDT.AllowAddNewRow = false;
this.rgv_CHDDT.MasterTemplate.AutoGenerateColumns = false;
this.rgv_CHDDT.ShowGroupedColumns = true;
this.rgv_CHDDT.MasterTemplate.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
this.rgv_CHDDT.EnableHotTracking = true;
this.rgv_CHDDT.AutoSizeRows = true;
GridViewTextBoxColumn DOCID = new GridViewTextBoxColumn();
DOCID.Name = "DOCID";
DOCID.FieldName = "DOCID";
DOCID.HeaderText = "เลขที่เอกสาร";
DOCID.IsVisible = true;
DOCID.ReadOnly = true;
DOCID.BestFit();
rgv_CHDDT.Columns.Add(DOCID);
GridViewTextBoxColumn TYPDESC = new GridViewTextBoxColumn();
TYPDESC.Name = "TYPDESC";
TYPDESC.FieldName = "TYPDESC";
TYPDESC.HeaderText = "ประเภทเอกสาร";
TYPDESC.IsVisible = true;
TYPDESC.ReadOnly = true;
TYPDESC.BestFit();
rgv_CHDDT.Columns.Add(TYPDESC);
GridViewTextBoxColumn CHG_DOCID = new GridViewTextBoxColumn();
CHG_DOCID.Name = "CHG_DOCID";
CHG_DOCID.FieldName = "CHG_DOCID";
CHG_DOCID.HeaderText = "เลขที่ที่อ้างอิง";
CHG_DOCID.IsVisible = true;
CHG_DOCID.ReadOnly = true;
CHG_DOCID.BestFit();
rgv_CHDDT.Columns.Add(CHG_DOCID);
GridViewTextBoxColumn FROMHOLIDAY = new GridViewTextBoxColumn();
FROMHOLIDAY.Name = "FROMHOLIDAY";
FROMHOLIDAY.FieldName = "FROMHOLIDAY";
FROMHOLIDAY.HeaderText = "วันที่มาทำ";
FROMHOLIDAY.IsVisible = true;
FROMHOLIDAY.ReadOnly = true;
FROMHOLIDAY.BestFit();
rgv_CHDDT.Columns.Add(FROMHOLIDAY);
GridViewTextBoxColumn TOSHIFTID = new GridViewTextBoxColumn();
TOSHIFTID.Name = "TOSHIFTID";
TOSHIFTID.FieldName = "TOSHIFTID";
TOSHIFTID.HeaderText = "กะที่มาทำ";
TOSHIFTID.IsVisible = true;
TOSHIFTID.ReadOnly = true;
TOSHIFTID.BestFit();
rgv_CHDDT.Columns.Add(TOSHIFTID);
GridViewTextBoxColumn TOSHIFTDESC = new GridViewTextBoxColumn();
TOSHIFTDESC.Name = "TOSHIFTDESC";
TOSHIFTDESC.FieldName = "TOSHIFTDESC";
TOSHIFTDESC.HeaderText = "คำอธิบาย";
TOSHIFTDESC.IsVisible = true;
TOSHIFTDESC.ReadOnly = true;
TOSHIFTDESC.BestFit();
rgv_CHDDT.Columns.Add(TOSHIFTDESC);
GridViewTextBoxColumn TOHOLIDAY = new GridViewTextBoxColumn();
TOHOLIDAY.Name = "TOHOLIDAY";
TOHOLIDAY.FieldName = "TOHOLIDAY";
TOHOLIDAY.HeaderText = "วันที่หยุด";
TOHOLIDAY.IsVisible = true;
TOHOLIDAY.ReadOnly = true;
TOHOLIDAY.BestFit();
rgv_CHDDT.Columns.Add(TOHOLIDAY);
GridViewTextBoxColumn CHG_REASON = new GridViewTextBoxColumn();
CHG_REASON.Name = "CHG_REASON";
CHG_REASON.FieldName = "CHG_REASON";
CHG_REASON.HeaderText = "เหตุผล";
CHG_REASON.IsVisible = true;
CHG_REASON.ReadOnly = true;
CHG_REASON.BestFit();
rgv_CHDDT.Columns.Add(CHG_REASON);
GridViewTextBoxColumn TRANSDATE = new GridViewTextBoxColumn();
TRANSDATE.Name = "TRANSDATE";
TRANSDATE.FieldName = "TRANSDATE";
TRANSDATE.HeaderText = "วันที่บันทึก";
TRANSDATE.IsVisible = true;
TRANSDATE.ReadOnly = true;
TRANSDATE.BestFit();
rgv_CHDDT.Columns.Add(TRANSDATE);
}
private void InitializeGridView()
{
rgv_Payment.Dock = DockStyle.Fill;
rgv_Payment.AutoGenerateColumns = true;
rgv_Payment.EnableFiltering = false;
rgv_Payment.AllowAddNewRow = false;
rgv_Payment.MasterTemplate.AutoGenerateColumns = false;
rgv_Payment.ShowGroupedColumns = true;
rgv_Payment.MasterTemplate.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
rgv_Payment.EnableHotTracking = true;
rgv_Payment.AutoSizeRows = true;
GridViewTextBoxColumn EMPLID = new GridViewTextBoxColumn();
EMPLID.Name = "EMPLID";
EMPLID.FieldName = "EMPLID";
EMPLID.HeaderText = "พนักงาน";
EMPLID.IsVisible = true;
EMPLID.ReadOnly = true;
EMPLID.BestFit();
rgv_Payment.Columns.Add(EMPLID);
GridViewTextBoxColumn PAYID = new GridViewTextBoxColumn();
PAYID.Name = "PAYID";
PAYID.FieldName = "PAYID";
PAYID.HeaderText = "ID";
PAYID.IsVisible = true;
PAYID.ReadOnly = true;
PAYID.BestFit();
rgv_Payment.Columns.Add(PAYID);
GridViewTextBoxColumn PAYNAME = new GridViewTextBoxColumn();
PAYNAME.Name = "PAYNAME";
PAYNAME.FieldName = "PAYNAME";
PAYNAME.HeaderText = "รายการ";
PAYNAME.IsVisible = true;
PAYNAME.ReadOnly = true;
PAYNAME.BestFit();
rgv_Payment.Columns.Add(PAYNAME);
GridViewTextBoxColumn JOBS = new GridViewTextBoxColumn();
JOBS.Name = "JOBS";
JOBS.FieldName = "JOBS";
JOBS.HeaderText = "จัดหางาน";
JOBS.IsVisible = true;
JOBS.ReadOnly = true;
JOBS.BestFit();
rgv_Payment.Columns.Add(JOBS);
GridViewTextBoxColumn BROKERS = new GridViewTextBoxColumn();
BROKERS.Name = "BROKERS";
BROKERS.FieldName = "BROKERS";
BROKERS.HeaderText = "โบรกเกอร์";
BROKERS.IsVisible = true;
BROKERS.ReadOnly = true;
BROKERS.BestFit();
rgv_Payment.Columns.Add(BROKERS);
GridViewTextBoxColumn CENTER = new GridViewTextBoxColumn();
CENTER.Name = "CENTER";
CENTER.FieldName = "CENTER";
CENTER.HeaderText = "ศูนย์พูนผล";
CENTER.IsVisible = true;
CENTER.ReadOnly = true;
CENTER.BestFit();
rgv_Payment.Columns.Add(CENTER);
GridViewTextBoxColumn MIMIGRATION = new GridViewTextBoxColumn();
MIMIGRATION.Name = "MIMIGRATION";
MIMIGRATION.FieldName = "MIMIGRATION";
MIMIGRATION.HeaderText = "ตม.";
MIMIGRATION.IsVisible = true;
MIMIGRATION.ReadOnly = true;
MIMIGRATION.BestFit();
rgv_Payment.Columns.Add(MIMIGRATION);
GridViewTextBoxColumn HOSPITAL = new GridViewTextBoxColumn();
HOSPITAL.Name = "HOSPITAL";
HOSPITAL.FieldName = "HOSPITAL";
HOSPITAL.HeaderText = "รพ.";
HOSPITAL.IsVisible = true;
HOSPITAL.ReadOnly = true;
HOSPITAL.BestFit();
rgv_Payment.Columns.Add(HOSPITAL);
GridViewTextBoxColumn DISTRICT = new GridViewTextBoxColumn();
DISTRICT.Name = "DISTRICT";
DISTRICT.FieldName = "DISTRICT";
DISTRICT.HeaderText = "อำเภอ.";
DISTRICT.IsVisible = true;
DISTRICT.ReadOnly = true;
DISTRICT.BestFit();
rgv_Payment.Columns.Add(DISTRICT);
GridViewTextBoxColumn SUMPAY = new GridViewTextBoxColumn();
SUMPAY.Name = "SUMPAY";
SUMPAY.FieldName = "SUMPAY";
SUMPAY.HeaderText = "รวม";
SUMPAY.IsVisible = true;
SUMPAY.ReadOnly = true;
SUMPAY.BestFit();
rgv_Payment.Columns.Add(SUMPAY);
GridViewTextBoxColumn SUPC = new GridViewTextBoxColumn();
SUPC.Name = "SUPC";
SUPC.FieldName = "SUPC";
SUPC.HeaderText = "เข้าบริษัท";
SUPC.IsVisible = true;
SUPC.ReadOnly = true;
SUPC.BestFit();
rgv_Payment.Columns.Add(SUPC);
GridViewTextBoxColumn TOTAL = new GridViewTextBoxColumn();
TOTAL.Name = "TOTAL";
TOTAL.FieldName = "TOTAL";
TOTAL.HeaderText = "ยอดเรียกเก็บ";
TOTAL.IsVisible = true;
TOTAL.ReadOnly = true;
TOTAL.BestFit();
rgv_Payment.Columns.Add(TOTAL);
GridViewCommandColumn BTDELETE = new GridViewCommandColumn();
BTDELETE.Name = "BTDELETE";
BTDELETE.HeaderText = "ลบ";
BTDELETE.Width = 100;
rgv_Payment.Columns.Add(BTDELETE);
GridViewSummaryRowItem summary = new GridViewSummaryRowItem();
summary.Add(new GridViewSummaryItem("JOBS", "{0:N2}", GridAggregateFunction.Sum));
summary.Add(new GridViewSummaryItem("BROKERS", "{0:N2}", GridAggregateFunction.Sum));
summary.Add(new GridViewSummaryItem("CENTER", "{0:N2}", GridAggregateFunction.Sum));
summary.Add(new GridViewSummaryItem("MIMIGRATION", "{0:N2}", GridAggregateFunction.Sum));
summary.Add(new GridViewSummaryItem("HOSPITAL", "{0:N2}", GridAggregateFunction.Sum));
summary.Add(new GridViewSummaryItem("DISTRICT", "{0:N2}", GridAggregateFunction.Sum));
summary.Add(new GridViewSummaryItem("SUMPAY", "{0:N2}", GridAggregateFunction.Sum));
summary.Add(new GridViewSummaryItem("SUPC", "{0:N2}", GridAggregateFunction.Sum));
summary.Add(new GridViewSummaryItem("TOTAL", "{0:N2}", GridAggregateFunction.Sum));
this.rgv_Payment.MasterTemplate.SummaryRowsBottom.Add(summary);
}
public Form1()
{
InitializeComponent();
// <Create objects>
#region <Window Form>
this.Text = string.Format(@"Usr:{0}; {1}", System.Security.Principal.WindowsIdentity.GetCurrent().Name, "รายงานการวิเคราะห์จำนวนพนักงานสาขา(ย้อนหลัง 1 วัน)");
this.KeyPreview = true;
this.ShowIcon = true;
this.StartPosition = FormStartPosition.CenterScreen;
this.Shown += new EventHandler(Form1_Shown);
#endregion
#region <layout>
this.toolStrip1.BackColor = System.Drawing.Color.FromArgb(196, 206, 221);
this.toolStripContainer1.Dock = DockStyle.Top;
this.panelRight.Dock = DockStyle.Right;
this.panelContainer.Dock = DockStyle.Fill;
this.panelContTop.Dock = DockStyle.Top;
this.panelContButtom.Dock = DockStyle.Fill;
this.groupBoxGeneral.Dock = DockStyle.Fill;
#endregion
#region <DateTimePicker>
this.dateTimePickerTransdate.Format = DateTimePickerFormat.Custom;
this.dateTimePickerTransdate.CustomFormat = @"dd/MM/yyyy";
this.dateTimePickerTransdate.Value = DateTime.Now.AddDays(-1);
this.dateTimePickerTransdate.MaxDate = DateTime.Now.AddDays(-1);
#endregion
#region <RadGridView>
this.radGridReport.Dock = DockStyle.Fill;
this.radGridReport.AutoGenerateColumns = true;
this.radGridReport.EnableFiltering = true;
this.radGridReport.AllowAddNewRow = false;
this.radGridReport.ReadOnly = true;
this.radGridReport.BestFitColumns(Telerik.WinControls.UI.BestFitColumnMode.HeaderCells);
this.radGridReport.MasterTemplate.ShowHeaderCellButtons = true;
this.radGridReport.MasterTemplate.ShowFilteringRow = false;
this.radGridReport.MasterTemplate.AutoGenerateColumns = false;
this.radGridReport.ShowGroupedColumns = true;
this.radGridReport.MasterTemplate.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.None;
GridViewTextBoxColumn txtCol0 = new GridViewTextBoxColumn();
txtCol0.FieldName = "PWDATE";
txtCol0.Name = "PWDATE";
txtCol0.HeaderText = "วันที่";
txtCol0.FormatString = "{0:dd/MM/yyyy}";
txtCol0.IsVisible = true;
this.radGridReport.Columns.Add(txtCol0);
GridViewTextBoxColumn txtCol1 = new GridViewTextBoxColumn();
txtCol1.FieldName = "PWRDATE";
txtCol1.Name = "PWRDATE";
txtCol1.HeaderText = "วันที่(2)";
txtCol1.FormatString = "{0:dd/MM/yyyy}";
txtCol1.IsVisible = false;
this.radGridReport.Columns.Add(txtCol1);
GridViewTextBoxColumn txtCol2 = new GridViewTextBoxColumn();
txtCol2.FieldName = "PWEMPLOYEE";
txtCol2.Name = "PWEMPLOYEE";
txtCol2.HeaderText = "พนักงาน";
txtCol2.IsVisible = true;
this.radGridReport.Columns.Add(txtCol2);
GridViewTextBoxColumn txtCol3 = new GridViewTextBoxColumn();
txtCol3.FieldName = "PWCARD";
txtCol3.Name = "PWCARD";
txtCol3.HeaderText = "บัตร";
txtCol3.IsVisible = false;
this.radGridReport.Columns.Add(txtCol3);
GridViewTextBoxColumn txtCol4 = new GridViewTextBoxColumn();
txtCol4.FieldName = "PWFNAME";
txtCol4.Name = "PWFNAME";
txtCol4.HeaderText = "ชื่อ";
txtCol4.IsVisible = true;
this.radGridReport.Columns.Add(txtCol4);
GridViewTextBoxColumn txtCol5 = new GridViewTextBoxColumn();
txtCol5.FieldName = "PWLNAME";
txtCol5.Name = "PWLNAME";
txtCol5.HeaderText = "สกุล";
txtCol5.IsVisible = true;
this.radGridReport.Columns.Add(txtCol5);
////
GridViewTextBoxColumn txtCol6 = new GridViewTextBoxColumn();
txtCol6.FieldName = "PWSECTION";
txtCol6.Name = "PWSECTION";
txtCol6.HeaderText = "แผนก";
txtCol6.IsVisible = false;
this.radGridReport.Columns.Add(txtCol6);
GridViewTextBoxColumn txtCol7 = new GridViewTextBoxColumn();
txtCol7.FieldName = "SECTIONDESC";
txtCol7.Name = "SECTIONDESC";
txtCol7.HeaderText = "ชื่อแผนก";
txtCol7.IsVisible = true;
this.radGridReport.Columns.Add(txtCol7);
GridViewTextBoxColumn txtCol8 = new GridViewTextBoxColumn();
txtCol8.FieldName = "PWDEPT";
txtCol8.Name = "PWDEPT";
txtCol8.HeaderText = "ตำแหน่ง";
txtCol8.IsVisible = false;
this.radGridReport.Columns.Add(txtCol8);
GridViewTextBoxColumn txtCol9 = new GridViewTextBoxColumn();
txtCol9.FieldName = "DEPTDESC";
txtCol9.Name = "DEPTDESC";
txtCol9.HeaderText = "ชื่อตำแหน่ง";
txtCol9.IsVisible = true;
this.radGridReport.Columns.Add(txtCol9);
GridViewTextBoxColumn txtCol10 = new GridViewTextBoxColumn();
txtCol10.FieldName = "MINTIME";
txtCol10.Name = "MINTIME";
txtCol10.HeaderText = "เวลารูดต่ำสุด";
txtCol10.IsVisible = true;
this.radGridReport.Columns.Add(txtCol10);
GridViewTextBoxColumn txtCol12 = new GridViewTextBoxColumn();
txtCol12.FieldName = "MAXTIME";
txtCol12.Name = "MAXTIME";
txtCol12.HeaderText = "เวลารูดสูงสุด";
txtCol12.IsVisible = true;
this.radGridReport.Columns.Add(txtCol12);
GridViewTextBoxColumn txtCol13 = new GridViewTextBoxColumn();
txtCol13.FieldName = "IDCARD";
txtCol13.Name = "IDCARD";
txtCol13.HeaderText = "บัตร";
txtCol13.IsVisible = true;
this.radGridReport.Columns.Add(txtCol13);
GridViewTextBoxColumn txtCol14 = new GridViewTextBoxColumn();
txtCol14.FieldName = "CODE";
txtCol14.Name = "CODE";
txtCol14.HeaderText = "รหัสกะ";
txtCol14.IsVisible = false;
this.radGridReport.Columns.Add(txtCol14);
GridViewTextBoxColumn txtCol141 = new GridViewTextBoxColumn();
txtCol141.FieldName = "SHIFTID";
txtCol141.Name = "SHIFTID";
txtCol141.HeaderText = "รหัสกะ(2)";
txtCol141.IsVisible = true;
this.radGridReport.Columns.Add(txtCol141);
GridViewTextBoxColumn txtCol15 = new GridViewTextBoxColumn();
txtCol15.FieldName = "STARTTIME";
txtCol15.Name = "STARTTIME";
txtCol15.HeaderText = "เวลาเริ่มต้น";
txtCol15.IsVisible = true;
this.radGridReport.Columns.Add(txtCol15);
GridViewTextBoxColumn txtCol16 = new GridViewTextBoxColumn();
txtCol16.FieldName = "ENDTIME";
txtCol16.Name = "ENDTIME";
txtCol16.HeaderText = "เวลาสิ้นสุด";
txtCol16.IsVisible = true;
this.radGridReport.Columns.Add(txtCol16);
GridViewTextBoxColumn txtCol17 = new GridViewTextBoxColumn();
txtCol17.FieldName = "CHECKING";
txtCol17.Name = "CHECKING";
txtCol17.HeaderText = "การตรวจสอบ";
txtCol17.IsVisible = true;
this.radGridReport.Columns.Add(txtCol17);
#endregion
#region <Button>
this.btnFuncProcess.Click += new EventHandler(btnFuncProcess_Click);
this.btnViewTimeTemp.Click += new EventHandler(btnViewTimeTemp_Click);
#endregion
#region <MenuItem>
this.toolStripMenuFile.Visible = false;
this.toolStripBtnExportExcel.ToolTipText = "Export to Excel (Ctrl+Alt+X)";
this.toolStripBtnExportExcel.Click += new EventHandler(toolStripBtnExportExcel_Click);
#endregion
#region <StatusLabel>
this.statusLabel.Text = "ready.";
#endregion
theprogress = new ThreadStart(FuncProcess);
startprogress = new Thread(theprogress);
}
void GridViewReport()
{
#region DL
this.rgv_ReportDLHR.Dock = DockStyle.Fill;
this.rgv_ReportDLHR.ReadOnly = true;
this.rgv_ReportDLHR.AutoGenerateColumns = true;
this.rgv_ReportDLHR.EnableFiltering = false;
this.rgv_ReportDLHR.AllowAddNewRow = false;
this.rgv_ReportDLHR.MasterTemplate.AutoGenerateColumns = false;
this.rgv_ReportDLHR.ShowGroupedColumns = true;
this.rgv_ReportDLHR.MasterTemplate.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
this.rgv_ReportDLHR.EnableHotTracking = true;
this.rgv_ReportDLHR.AutoSizeRows = true;
this.rgv_ReportDLHR.Visible = false;
GridViewTextBoxColumn DOCID = new GridViewTextBoxColumn();
DOCID.Name = "DOCID";
DOCID.FieldName = "DOCID";
DOCID.HeaderText = "เลขที่เอกสาร";
DOCID.IsVisible = true;
DOCID.ReadOnly = true;
DOCID.BestFit();
rgv_ReportDLHR.Columns.Add(DOCID);
GridViewTextBoxColumn EMPLID = new GridViewTextBoxColumn();
EMPLID.Name = "EMPLID";
EMPLID.FieldName = "EMPLID";
EMPLID.HeaderText = "รหัส";
EMPLID.IsVisible = true;
EMPLID.ReadOnly = true;
EMPLID.BestFit();
rgv_ReportDLHR.Columns.Add(EMPLID);
GridViewTextBoxColumn EMPLNAME = new GridViewTextBoxColumn();
EMPLNAME.Name = "EMPLNAME";
EMPLNAME.FieldName = "EMPLNAME";
EMPLNAME.HeaderText = "ชื่อ";
EMPLNAME.IsVisible = true;
EMPLNAME.ReadOnly = true;
EMPLNAME.BestFit();
rgv_ReportDLHR.Columns.Add(EMPLNAME);
GridViewTextBoxColumn SECTIONNAME = new GridViewTextBoxColumn();
SECTIONNAME.Name = "SECTIONNAME";
SECTIONNAME.FieldName = "SECTIONNAME";
SECTIONNAME.HeaderText = "แผนก";
SECTIONNAME.IsVisible = true;
SECTIONNAME.ReadOnly = true;
SECTIONNAME.BestFit();
rgv_ReportDLHR.Columns.Add(SECTIONNAME);
GridViewTextBoxColumn DEPTNAME = new GridViewTextBoxColumn();
DEPTNAME.Name = "DEPTNAME";
DEPTNAME.FieldName = "DEPTNAME";
DEPTNAME.HeaderText = "ตำแหน่ง";
DEPTNAME.IsVisible = true;
DEPTNAME.ReadOnly = true;
DEPTNAME.BestFit();
rgv_ReportDLHR.Columns.Add(DEPTNAME);
GridViewTextBoxColumn TYPDESC = new GridViewTextBoxColumn();
TYPDESC.Name = "TYPDESC";
TYPDESC.FieldName = "TYPDESC";
TYPDESC.HeaderText = "เอกสารยกเลิก";
TYPDESC.IsVisible = true;
TYPDESC.ReadOnly = true;
TYPDESC.BestFit();
rgv_ReportDLHR.Columns.Add(TYPDESC);
GridViewTextBoxColumn DOCREFER = new GridViewTextBoxColumn();
DOCREFER.Name = "DOCREFER";
DOCREFER.FieldName = "DOCREFER";
DOCREFER.HeaderText = "เลขที่อ้างอิง";
DOCREFER.IsVisible = true;
DOCREFER.ReadOnly = true;
DOCREFER.BestFit();
rgv_ReportDLHR.Columns.Add(DOCREFER);
GridViewTextBoxColumn DATEREFER = new GridViewTextBoxColumn();
DATEREFER.Name = "DATEREFER";
DATEREFER.FieldName = "DATEREFER";
DATEREFER.HeaderText = "วันที่อ้างอิง";
DATEREFER.IsVisible = true;
DATEREFER.ReadOnly = true;
DATEREFER.BestFit();
rgv_ReportDLHR.Columns.Add(DATEREFER);
GridViewTextBoxColumn REASON = new GridViewTextBoxColumn();
REASON.Name = "REASON";
REASON.FieldName = "REASON";
REASON.HeaderText = "เหตุผล";
REASON.IsVisible = true;
REASON.ReadOnly = true;
REASON.BestFit();
rgv_ReportDLHR.Columns.Add(REASON);
GridViewTextBoxColumn HEADAPPROVED = new GridViewTextBoxColumn();
HEADAPPROVED.Name = "HEADAPPROVED";
HEADAPPROVED.FieldName = "HEADAPPROVED";
HEADAPPROVED.HeaderText = "หน./ผช.";
HEADAPPROVED.IsVisible = true;
HEADAPPROVED.ReadOnly = true;
HEADAPPROVED.BestFit();
rgv_ReportDLHR.Columns.Add(HEADAPPROVED);
GridViewTextBoxColumn HEADAPPROVEDBYNAME = new GridViewTextBoxColumn();
HEADAPPROVEDBYNAME.Name = "HEADAPPROVEDBYNAME";
HEADAPPROVEDBYNAME.FieldName = "HEADAPPROVEDBYNAME";
HEADAPPROVEDBYNAME.HeaderText = "ผู้อนุมัติ";
HEADAPPROVEDBYNAME.IsVisible = true;
HEADAPPROVEDBYNAME.ReadOnly = true;
HEADAPPROVEDBYNAME.BestFit();
rgv_ReportDLHR.Columns.Add(HEADAPPROVEDBYNAME);
GridViewTextBoxColumn HEADAPPROVEDDATE = new GridViewTextBoxColumn();
HEADAPPROVEDDATE.Name = "HEADAPPROVEDDATE";
HEADAPPROVEDDATE.FieldName = "HEADAPPROVEDDATE";
HEADAPPROVEDDATE.HeaderText = "วันที่อนุมัติ";
HEADAPPROVEDDATE.IsVisible = true;
HEADAPPROVEDDATE.ReadOnly = true;
HEADAPPROVEDDATE.BestFit();
rgv_ReportDLHR.Columns.Add(HEADAPPROVEDDATE);
GridViewTextBoxColumn HRAPPROVED = new GridViewTextBoxColumn();
HRAPPROVED.Name = "HRAPPROVED";
HRAPPROVED.FieldName = "HRAPPROVED";
HRAPPROVED.HeaderText = "บุคคล";
HRAPPROVED.IsVisible = true;
HRAPPROVED.ReadOnly = true;
HRAPPROVED.BestFit();
rgv_ReportDLHR.Columns.Add(HRAPPROVED);
GridViewTextBoxColumn HRAPPROVEDBYNAME = new GridViewTextBoxColumn();
HRAPPROVEDBYNAME.Name = "HRAPPROVEDBYNAME";
HRAPPROVEDBYNAME.FieldName = "HRAPPROVEDBYNAME";
HRAPPROVEDBYNAME.HeaderText = "ผู้อนุมัติ";
HRAPPROVEDBYNAME.IsVisible = true;
HRAPPROVEDBYNAME.ReadOnly = true;
HRAPPROVEDBYNAME.BestFit();
rgv_ReportDLHR.Columns.Add(HRAPPROVEDBYNAME);
GridViewTextBoxColumn HRAPPORVEREMARK = new GridViewTextBoxColumn();
HRAPPORVEREMARK.Name = "HRAPPORVEREMARK";
HRAPPORVEREMARK.FieldName = "HRAPPORVEREMARK";
HRAPPORVEREMARK.HeaderText = "หมายเหตุ";
HRAPPORVEREMARK.IsVisible = true;
HRAPPORVEREMARK.ReadOnly = true;
HRAPPORVEREMARK.BestFit();
rgv_ReportDLHR.Columns.Add(HRAPPORVEREMARK);
GridViewTextBoxColumn HRAPPROVEDDATE = new GridViewTextBoxColumn();
HRAPPROVEDDATE.Name = "HRAPPROVEDDATE";
HRAPPROVEDDATE.FieldName = "HRAPPROVEDDATE";
HRAPPROVEDDATE.HeaderText = "วันที่อนุมัติ";
HRAPPROVEDDATE.IsVisible = true;
HRAPPROVEDDATE.ReadOnly = true;
HRAPPROVEDDATE.BestFit();
rgv_ReportDLHR.Columns.Add(HRAPPROVEDDATE);
#endregion
#region DS
this.rgv_ReportDSHR.Dock = DockStyle.Fill;
this.rgv_ReportDSHR.ReadOnly = true;
this.rgv_ReportDSHR.AutoGenerateColumns = true;
this.rgv_ReportDSHR.EnableFiltering = false;
this.rgv_ReportDSHR.AllowAddNewRow = false;
this.rgv_ReportDSHR.MasterTemplate.AutoGenerateColumns = false;
this.rgv_ReportDSHR.ShowGroupedColumns = true;
this.rgv_ReportDSHR.MasterTemplate.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
this.rgv_ReportDSHR.EnableHotTracking = true;
this.rgv_ReportDSHR.AutoSizeRows = true;
this.rgv_ReportDSHR.Visible = false;
GridViewTextBoxColumn DOCID_DS = new GridViewTextBoxColumn();
DOCID_DS.Name = "DOCID";
DOCID_DS.FieldName = "DOCID";
DOCID_DS.HeaderText = "เลขที่เอกสาร";
DOCID_DS.IsVisible = true;
DOCID_DS.ReadOnly = true;
DOCID_DS.BestFit();
rgv_ReportDSHR.Columns.Add(DOCID_DS);
GridViewTextBoxColumn EMPLID_DS = new GridViewTextBoxColumn();
EMPLID_DS.Name = "EMPLID";
EMPLID_DS.FieldName = "EMPLID";
EMPLID_DS.HeaderText = "รหัส";
EMPLID_DS.IsVisible = true;
EMPLID_DS.ReadOnly = true;
EMPLID_DS.BestFit();
rgv_ReportDSHR.Columns.Add(EMPLID_DS);
GridViewTextBoxColumn EMPLNAME_DS = new GridViewTextBoxColumn();
EMPLNAME_DS.Name = "EMPLNAME";
EMPLNAME_DS.FieldName = "EMPLNAME";
EMPLNAME_DS.HeaderText = "ชื่อ";
EMPLNAME_DS.IsVisible = true;
EMPLNAME_DS.ReadOnly = true;
EMPLNAME_DS.BestFit();
rgv_ReportDSHR.Columns.Add(EMPLNAME_DS);
GridViewTextBoxColumn SECTIONNAME_DS = new GridViewTextBoxColumn();
SECTIONNAME_DS.Name = "SECTIONNAME";
SECTIONNAME_DS.FieldName = "SECTIONNAME";
SECTIONNAME_DS.HeaderText = "แผนก";
SECTIONNAME_DS.IsVisible = true;
SECTIONNAME_DS.ReadOnly = true;
SECTIONNAME_DS.BestFit();
rgv_ReportDSHR.Columns.Add(SECTIONNAME_DS);
GridViewTextBoxColumn DEPTNAME_DS = new GridViewTextBoxColumn();
DEPTNAME_DS.Name = "DEPTNAME";
DEPTNAME_DS.FieldName = "DEPTNAME";
DEPTNAME_DS.HeaderText = "ตำแหน่ง";
DEPTNAME_DS.IsVisible = true;
DEPTNAME_DS.ReadOnly = true;
DEPTNAME_DS.BestFit();
rgv_ReportDSHR.Columns.Add(DEPTNAME_DS);
GridViewTextBoxColumn TYPDESC_DS = new GridViewTextBoxColumn();
TYPDESC_DS.Name = "TYPDESC";
TYPDESC_DS.FieldName = "TYPDESC";
TYPDESC_DS.HeaderText = "เอกสารยกเลิก";
TYPDESC_DS.IsVisible = true;
TYPDESC_DS.ReadOnly = true;
TYPDESC_DS.BestFit();
rgv_ReportDSHR.Columns.Add(TYPDESC_DS);
GridViewTextBoxColumn DOCREFER_DS = new GridViewTextBoxColumn();
DOCREFER_DS.Name = "DOCREFER";
DOCREFER_DS.FieldName = "DOCREFER";
DOCREFER_DS.HeaderText = "เลขที่อ้างอิง";
DOCREFER_DS.IsVisible = true;
DOCREFER_DS.ReadOnly = true;
DOCREFER_DS.BestFit();
rgv_ReportDSHR.Columns.Add(DOCREFER_DS);
GridViewTextBoxColumn DATEREFER_DS = new GridViewTextBoxColumn();
DATEREFER_DS.Name = "DATEREFER";
DATEREFER_DS.FieldName = "DATEREFER";
DATEREFER_DS.HeaderText = "วันที่อ้างอิง";
DATEREFER_DS.IsVisible = true;
DATEREFER_DS.ReadOnly = true;
DATEREFER_DS.BestFit();
rgv_ReportDSHR.Columns.Add(DATEREFER_DS);
GridViewTextBoxColumn FROMSHIFT_DS = new GridViewTextBoxColumn();
FROMSHIFT_DS.Name = "FROMSHIFT";
FROMSHIFT_DS.FieldName = "FROMSHIFT";
FROMSHIFT_DS.HeaderText = "กะเดิม";
FROMSHIFT_DS.IsVisible = true;
FROMSHIFT_DS.ReadOnly = true;
FROMSHIFT_DS.BestFit();
rgv_ReportDSHR.Columns.Add(FROMSHIFT_DS);
GridViewTextBoxColumn TOSHIFT_DS = new GridViewTextBoxColumn();
TOSHIFT_DS.Name = "TOSHIFT";
TOSHIFT_DS.FieldName = "TOSHIFT";
TOSHIFT_DS.HeaderText = "กะใหม่";
TOSHIFT_DS.IsVisible = true;
TOSHIFT_DS.ReadOnly = true;
TOSHIFT_DS.BestFit();
rgv_ReportDSHR.Columns.Add(TOSHIFT_DS);
GridViewTextBoxColumn REASON_DS = new GridViewTextBoxColumn();
REASON_DS.Name = "REASON";
REASON_DS.FieldName = "REASON";
REASON_DS.HeaderText = "เหตุผล";
REASON_DS.IsVisible = true;
REASON_DS.ReadOnly = true;
REASON_DS.BestFit();
rgv_ReportDSHR.Columns.Add(REASON_DS);
GridViewTextBoxColumn HEADAPPROVED_DS = new GridViewTextBoxColumn();
HEADAPPROVED_DS.Name = "HEADAPPROVED";
HEADAPPROVED_DS.FieldName = "HEADAPPROVED";
HEADAPPROVED_DS.HeaderText = "หน./ผช.";
HEADAPPROVED_DS.IsVisible = true;
HEADAPPROVED_DS.ReadOnly = true;
HEADAPPROVED_DS.BestFit();
rgv_ReportDSHR.Columns.Add(HEADAPPROVED_DS);
GridViewTextBoxColumn HEADAPPROVEDBYNAME_DS = new GridViewTextBoxColumn();
HEADAPPROVEDBYNAME_DS.Name = "HEADAPPROVEDBYNAME";
HEADAPPROVEDBYNAME_DS.FieldName = "HEADAPPROVEDBYNAME";
HEADAPPROVEDBYNAME_DS.HeaderText = "ผู้อนุมัติ";
HEADAPPROVEDBYNAME_DS.IsVisible = true;
HEADAPPROVEDBYNAME_DS.ReadOnly = true;
HEADAPPROVEDBYNAME_DS.BestFit();
rgv_ReportDSHR.Columns.Add(HEADAPPROVEDBYNAME_DS);
GridViewTextBoxColumn HEADAPPROVEDDATE_DS = new GridViewTextBoxColumn();
HEADAPPROVEDDATE_DS.Name = "HEADAPPROVEDDATE";
HEADAPPROVEDDATE_DS.FieldName = "HEADAPPROVEDDATE";
HEADAPPROVEDDATE_DS.HeaderText = "วันที่อนุมัติ";
HEADAPPROVEDDATE_DS.IsVisible = true;
HEADAPPROVEDDATE_DS.ReadOnly = true;
HEADAPPROVEDDATE_DS.BestFit();
rgv_ReportDSHR.Columns.Add(HEADAPPROVEDDATE_DS);
GridViewTextBoxColumn HRAPPROVED_DS = new GridViewTextBoxColumn();
HRAPPROVED_DS.Name = "HRAPPROVED";
HRAPPROVED_DS.FieldName = "HRAPPROVED";
HRAPPROVED_DS.HeaderText = "บุคคล";
HRAPPROVED_DS.IsVisible = true;
HRAPPROVED_DS.ReadOnly = true;
HRAPPROVED_DS.BestFit();
rgv_ReportDSHR.Columns.Add(HRAPPROVED_DS);
GridViewTextBoxColumn HRAPPROVEDBYNAME_DS = new GridViewTextBoxColumn();
HRAPPROVEDBYNAME_DS.Name = "HRAPPROVEDBYNAME";
HRAPPROVEDBYNAME_DS.FieldName = "HRAPPROVEDBYNAME";
HRAPPROVEDBYNAME_DS.HeaderText = "ผู้อนุมัติ";
HRAPPROVEDBYNAME_DS.IsVisible = true;
HRAPPROVEDBYNAME_DS.ReadOnly = true;
HRAPPROVEDBYNAME_DS.BestFit();
rgv_ReportDSHR.Columns.Add(HRAPPROVEDBYNAME_DS);
GridViewTextBoxColumn HRAPPORVEREMARK_DS = new GridViewTextBoxColumn();
HRAPPORVEREMARK_DS.Name = "HRAPPORVEREMARK";
HRAPPORVEREMARK_DS.FieldName = "HRAPPORVEREMARK";
HRAPPORVEREMARK_DS.HeaderText = "หมายเหตุ";
HRAPPORVEREMARK_DS.IsVisible = true;
HRAPPORVEREMARK_DS.ReadOnly = true;
HRAPPORVEREMARK_DS.BestFit();
rgv_ReportDSHR.Columns.Add(HRAPPORVEREMARK_DS);
GridViewTextBoxColumn HRAPPROVEDDATE_DS = new GridViewTextBoxColumn();
HRAPPROVEDDATE_DS.Name = "HRAPPROVEDDATE";
HRAPPROVEDDATE_DS.FieldName = "HRAPPROVEDDATE";
HRAPPROVEDDATE_DS.HeaderText = "วันที่อนุมัติ";
HRAPPROVEDDATE_DS.IsVisible = true;
HRAPPROVEDDATE_DS.ReadOnly = true;
HRAPPROVEDDATE_DS.BestFit();
rgv_ReportDSHR.Columns.Add(HRAPPROVEDDATE_DS);
#endregion
#region CHD
this.rgv_ReportCHDHR.Dock = DockStyle.Fill;
this.rgv_ReportCHDHR.ReadOnly = true;
this.rgv_ReportCHDHR.AutoGenerateColumns = true;
this.rgv_ReportCHDHR.EnableFiltering = false;
this.rgv_ReportCHDHR.AllowAddNewRow = false;
this.rgv_ReportCHDHR.MasterTemplate.AutoGenerateColumns = false;
this.rgv_ReportCHDHR.ShowGroupedColumns = true;
this.rgv_ReportCHDHR.MasterTemplate.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
this.rgv_ReportCHDHR.EnableHotTracking = true;
this.rgv_ReportCHDHR.AutoSizeRows = true;
this.rgv_ReportCHDHR.Visible = false;
GridViewTextBoxColumn DOCID_CHD = new GridViewTextBoxColumn();
DOCID_CHD.Name = "DOCID";
DOCID_CHD.FieldName = "DOCID";
DOCID_CHD.HeaderText = "เลขที่เอกสาร";
DOCID_CHD.IsVisible = true;
DOCID_CHD.ReadOnly = true;
DOCID_CHD.BestFit();
rgv_ReportCHDHR.Columns.Add(DOCID_CHD);
GridViewTextBoxColumn EMPLID_CHD = new GridViewTextBoxColumn();
EMPLID_CHD.Name = "EMPLID";
EMPLID_CHD.FieldName = "EMPLID";
EMPLID_CHD.HeaderText = "รหัส";
EMPLID_CHD.IsVisible = true;
EMPLID_CHD.ReadOnly = true;
EMPLID_CHD.BestFit();
rgv_ReportCHDHR.Columns.Add(EMPLID_CHD);
GridViewTextBoxColumn EMPLNAME_CHD = new GridViewTextBoxColumn();
EMPLNAME_CHD.Name = "EMPLNAME";
EMPLNAME_CHD.FieldName = "EMPLNAME";
EMPLNAME_CHD.HeaderText = "ชื่อ";
EMPLNAME_CHD.IsVisible = true;
EMPLNAME_CHD.ReadOnly = true;
EMPLNAME_DS.BestFit();
rgv_ReportCHDHR.Columns.Add(EMPLNAME_CHD);
GridViewTextBoxColumn SECTIONNAME_CHD = new GridViewTextBoxColumn();
SECTIONNAME_CHD.Name = "SECTIONNAME";
SECTIONNAME_CHD.FieldName = "SECTIONNAME";
SECTIONNAME_CHD.HeaderText = "แผนก";
SECTIONNAME_CHD.IsVisible = true;
SECTIONNAME_CHD.ReadOnly = true;
SECTIONNAME_CHD.BestFit();
rgv_ReportCHDHR.Columns.Add(SECTIONNAME_CHD);
GridViewTextBoxColumn DEPTNAME_CHD = new GridViewTextBoxColumn();
DEPTNAME_CHD.Name = "DEPTNAME";
DEPTNAME_CHD.FieldName = "DEPTNAME";
DEPTNAME_CHD.HeaderText = "ตำแหน่ง";
DEPTNAME_CHD.IsVisible = true;
DEPTNAME_CHD.ReadOnly = true;
DEPTNAME_CHD.BestFit();
rgv_ReportCHDHR.Columns.Add(DEPTNAME_CHD);
GridViewTextBoxColumn TYPDESC_CHD = new GridViewTextBoxColumn();
TYPDESC_CHD.Name = "TYPDESC";
TYPDESC_CHD.FieldName = "TYPDESC";
TYPDESC_CHD.HeaderText = "เอกสารยกเลิก";
TYPDESC_CHD.IsVisible = true;
TYPDESC_CHD.ReadOnly = true;
TYPDESC_CHD.BestFit();
rgv_ReportCHDHR.Columns.Add(TYPDESC_CHD);
GridViewTextBoxColumn DOCREFER_CHD = new GridViewTextBoxColumn();
DOCREFER_CHD.Name = "DOCREFER";
DOCREFER_CHD.FieldName = "DOCREFER";
DOCREFER_CHD.HeaderText = "เลขที่อ้างอิง";
DOCREFER_CHD.IsVisible = true;
DOCREFER_CHD.ReadOnly = true;
DOCREFER_CHD.BestFit();
rgv_ReportCHDHR.Columns.Add(DOCREFER_CHD);
GridViewTextBoxColumn DATEREFER_CHD = new GridViewTextBoxColumn();
DATEREFER_CHD.Name = "DATEREFER";
DATEREFER_CHD.FieldName = "DATEREFER";
DATEREFER_CHD.HeaderText = "วันที่หยุด";
DATEREFER_CHD.IsVisible = true;
DATEREFER_CHD.ReadOnly = true;
DATEREFER_CHD.BestFit();
rgv_ReportCHDHR.Columns.Add(DATEREFER_CHD);
GridViewTextBoxColumn EMPLSHIFT_CHD = new GridViewTextBoxColumn();
EMPLSHIFT_CHD.Name = "EMPLSHIFT";
EMPLSHIFT_CHD.FieldName = "EMPLSHIFT";
EMPLSHIFT_CHD.HeaderText = "กะเดิมวันที่หยุด";
EMPLSHIFT_CHD.IsVisible = true;
EMPLSHIFT_CHD.ReadOnly = true;
EMPLSHIFT_CHD.BestFit();
rgv_ReportCHDHR.Columns.Add(EMPLSHIFT_CHD);
GridViewTextBoxColumn FROMHOLIDAY_CHD = new GridViewTextBoxColumn();
FROMHOLIDAY_CHD.Name = "FROMHOLIDAY_CHD";
FROMHOLIDAY_CHD.FieldName = "FROMHOLIDAY_CHD";
FROMHOLIDAY_CHD.HeaderText = "วันที่มาทำ";
FROMHOLIDAY_CHD.IsVisible = true;
FROMHOLIDAY_CHD.ReadOnly = true;
FROMHOLIDAY_CHD.BestFit();
rgv_ReportCHDHR.Columns.Add(FROMHOLIDAY_CHD);
GridViewTextBoxColumn REASON_CHD = new GridViewTextBoxColumn();
REASON_CHD.Name = "REASON";
REASON_CHD.FieldName = "REASON";
REASON_CHD.HeaderText = "เหตุผล";
REASON_CHD.IsVisible = true;
REASON_CHD.ReadOnly = true;
REASON_CHD.BestFit();
rgv_ReportCHDHR.Columns.Add(REASON_CHD);
GridViewTextBoxColumn HEADAPPROVED_CHD = new GridViewTextBoxColumn();
HEADAPPROVED_CHD.Name = "HEADAPPROVED";
HEADAPPROVED_CHD.FieldName = "HEADAPPROVED";
HEADAPPROVED_CHD.HeaderText = "หน./ผช.";
HEADAPPROVED_CHD.IsVisible = true;
HEADAPPROVED_CHD.ReadOnly = true;
HEADAPPROVED_CHD.BestFit();
rgv_ReportCHDHR.Columns.Add(HEADAPPROVED_CHD);
GridViewTextBoxColumn HEADAPPROVEDBYNAME_CHD = new GridViewTextBoxColumn();
HEADAPPROVEDBYNAME_CHD.Name = "HEADAPPROVEDBYNAME";
HEADAPPROVEDBYNAME_CHD.FieldName = "HEADAPPROVEDBYNAME";
HEADAPPROVEDBYNAME_CHD.HeaderText = "ผู้อนุมัติ";
HEADAPPROVEDBYNAME_CHD.IsVisible = true;
HEADAPPROVEDBYNAME_CHD.ReadOnly = true;
HEADAPPROVEDBYNAME_CHD.BestFit();
rgv_ReportCHDHR.Columns.Add(HEADAPPROVEDBYNAME_CHD);
GridViewTextBoxColumn HEADAPPROVEDDATE_CHD = new GridViewTextBoxColumn();
HEADAPPROVEDDATE_CHD.Name = "HEADAPPROVEDDATE";
HEADAPPROVEDDATE_CHD.FieldName = "HEADAPPROVEDDATE";
HEADAPPROVEDDATE_CHD.HeaderText = "วันที่อนุมัติ";
HEADAPPROVEDDATE_CHD.IsVisible = true;
HEADAPPROVEDDATE_CHD.ReadOnly = true;
HEADAPPROVEDDATE_CHD.BestFit();
rgv_ReportCHDHR.Columns.Add(HEADAPPROVEDDATE_CHD);
GridViewTextBoxColumn HRAPPROVED_CHD = new GridViewTextBoxColumn();
HRAPPROVED_CHD.Name = "HRAPPROVED";
HRAPPROVED_CHD.FieldName = "HRAPPROVED";
HRAPPROVED_CHD.HeaderText = "บุคคล";
HRAPPROVED_CHD.IsVisible = true;
HRAPPROVED_CHD.ReadOnly = true;
HRAPPROVED_CHD.BestFit();
rgv_ReportCHDHR.Columns.Add(HRAPPROVED_CHD);
GridViewTextBoxColumn HRAPPROVEDBYNAME_CHD = new GridViewTextBoxColumn();
HRAPPROVEDBYNAME_CHD.Name = "HRAPPROVEDBYNAME";
HRAPPROVEDBYNAME_CHD.FieldName = "HRAPPROVEDBYNAME";
HRAPPROVEDBYNAME_CHD.HeaderText = "ผู้อนุมัติ";
HRAPPROVEDBYNAME_CHD.IsVisible = true;
HRAPPROVEDBYNAME_CHD.ReadOnly = true;
HRAPPROVEDBYNAME_CHD.BestFit();
rgv_ReportCHDHR.Columns.Add(HRAPPROVEDBYNAME_CHD);
GridViewTextBoxColumn HRAPPORVEREMARK_CHD = new GridViewTextBoxColumn();
HRAPPORVEREMARK_CHD.Name = "HRAPPORVEREMARK";
HRAPPORVEREMARK_CHD.FieldName = "HRAPPORVEREMARK";
HRAPPORVEREMARK_CHD.HeaderText = "หมายเหตุ";
HRAPPORVEREMARK_CHD.IsVisible = true;
HRAPPORVEREMARK_CHD.ReadOnly = true;
HRAPPORVEREMARK_CHD.BestFit();
rgv_ReportCHDHR.Columns.Add(HRAPPORVEREMARK_CHD);
GridViewTextBoxColumn HRAPPROVEDDATE_CHD = new GridViewTextBoxColumn();
HRAPPROVEDDATE_CHD.Name = "HRAPPROVEDDATE";
HRAPPROVEDDATE_CHD.FieldName = "HRAPPROVEDDATE";
HRAPPROVEDDATE_CHD.HeaderText = "วันที่อนุมัติ";
HRAPPROVEDDATE_CHD.IsVisible = true;
HRAPPROVEDDATE_CHD.ReadOnly = true;
HRAPPROVEDDATE_CHD.BestFit();
rgv_ReportCHDHR.Columns.Add(HRAPPROVEDDATE_CHD);
#endregion
}
/// <summary>
/// Inits the grid param status.
/// </summary>
private void InitGridParamStatus()
{
this.gvParameterStatus.Columns.Clear();
//this.gvParameterStatus.AllowEditRow = false;
var colId = new GridViewTextBoxColumn() { DataType = typeof(int), Name = "Id", FieldName = "Id", HeaderText = "Id", Width = 10, ReadOnly = true };
this.gvParameterStatus.MasterTemplate.Columns.Add(colId);
var colActive = new GridViewCheckBoxColumn() { DataType = typeof(bool), Name = "IsActive", FieldName = "IsActive", HeaderText = "Bearbeiten", Width = 10 };
this.gvParameterStatus.MasterTemplate.Columns.Add(colActive);
var colParamName = new GridViewTextBoxColumn() { DataType = typeof(string), Name = "Parametername", FieldName = "Name", HeaderText = "Parametername", MinWidth = 80, ReadOnly = true };
this.gvParameterStatus.MasterTemplate.Columns.Add(colParamName);
var colParamObis = new GridViewTextBoxColumn() { DataType = typeof(string), Name = "Obis", FieldName = "ObisCode", HeaderText = "Obis", Width = 30, ReadOnly = true };
this.gvParameterStatus.MasterTemplate.Columns.Add(colParamObis);
var colTargetValName = new GridViewTextBoxColumn() { DataType = typeof(string), Name = "Sollwert", FieldName = "TargetValue", HeaderText = "Sollwert", MinWidth = 80, ReadOnly = true };
this.gvParameterStatus.MasterTemplate.Columns.Add(colTargetValName);
var colRealValName = new GridViewTextBoxColumn() { DataType = typeof(string), Name = "Istwert", FieldName = "RealValue", HeaderText = "Istwert", MinWidth = 80, ReadOnly = true };
this.gvParameterStatus.MasterTemplate.Columns.Add(colRealValName);
var colIsWritten = new GridViewCheckBoxColumn() { DataType = typeof(bool), Name = "Schreibstatus", FieldName = "IsWritten", HeaderText = "Schreibstatus", MinWidth = 10, ReadOnly = true };
this.gvParameterStatus.MasterTemplate.Columns.Add(colIsWritten);
var colIsValid = new GridViewCheckBoxColumn() { DataType = typeof(bool), Name = "IsValid", FieldName = "IsReadBackValid", HeaderText = "Prüfstatus", MinWidth = 10, ReadOnly = true };
this.gvParameterStatus.MasterTemplate.Columns.Add(colIsValid);
}
private void InitGridExcel()
{
this.gvExcel.Columns.Clear();
this.gvExcel.Rows.Clear();
//this.gvParameterStatus.AllowEditRow = false;
var colPruefplatznr = new GridViewTextBoxColumn() { DataType = typeof(string), Name = "Pruefplatznr", FieldName = "Pruefplatznr", HeaderText = "Prüfplatz-Nr", Width = 80, ReadOnly = true };
this.gvExcel.MasterTemplate.Columns.Add(colPruefplatznr);
var colPubKey = new GridViewTextBoxColumn() { DataType = typeof(string), Name = "PublicKey", FieldName = "PublicKey", HeaderText = "Public Key", Width = 600 };
this.gvExcel.MasterTemplate.Columns.Add(colPubKey);
var colManufNo = new GridViewTextBoxColumn() { DataType = typeof(string), Name = "FabrikNr", FieldName = "FabrikNr", HeaderText = "Fabrik-Nr", Width = 150, ReadOnly = true };
this.gvExcel.MasterTemplate.Columns.Add(colManufNo);
var colServerId = new GridViewTextBoxColumn() { DataType = typeof(string), Name = "ServerId", FieldName = "ServerId", HeaderText = "ServerId", Width = 200, ReadOnly = true };
this.gvExcel.MasterTemplate.Columns.Add(colServerId);
var colEigNr = new GridViewTextBoxColumn() { DataType = typeof(string), Name = "Eigentumsnr", FieldName = "Eigentumsnr", HeaderText = "Eigentumsnr", Width = 200, ReadOnly = true };
this.gvExcel.MasterTemplate.Columns.Add(colEigNr);
var colType = new GridViewTextBoxColumn() { DataType = typeof(string), Name = "Typ", FieldName = "Typ", HeaderText = "Typ", Width = 100, ReadOnly = true };
this.gvExcel.MasterTemplate.Columns.Add(colType);
var colPin = new GridViewTextBoxColumn() { DataType = typeof(string), Name = "Pin", FieldName = "Pin", HeaderText = "Pin", Width = 80, ReadOnly = true };
this.gvExcel.MasterTemplate.Columns.Add(colPin);
}
void GridViewHD()
{
this.rgv_HD.Dock = DockStyle.Fill;
this.rgv_HD.ReadOnly = true;
this.rgv_HD.AutoGenerateColumns = true;
this.rgv_HD.EnableFiltering = false;
this.rgv_HD.AllowAddNewRow = false;
this.rgv_HD.MasterTemplate.AutoGenerateColumns = false;
this.rgv_HD.ShowGroupedColumns = true;
this.rgv_HD.MasterTemplate.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
this.rgv_HD.EnableHotTracking = true;
this.rgv_HD.AutoSizeRows = true;
GridViewTextBoxColumn DOCID = new GridViewTextBoxColumn();
DOCID.Name = "DOCID";
DOCID.FieldName = "DOCID";
DOCID.HeaderText = "เลขที่เอกสาร";
DOCID.IsVisible = true;
DOCID.ReadOnly = true;
DOCID.BestFit();
rgv_HD.Columns.Add(DOCID);
GridViewTextBoxColumn DOCTYP = new GridViewTextBoxColumn();
DOCTYP.Name = "DOCTYP";
DOCTYP.FieldName = "DOCTYP";
DOCTYP.HeaderText = "ประเภท";
DOCTYP.IsVisible = true;
DOCTYP.ReadOnly = true;
DOCTYP.BestFit();
rgv_HD.Columns.Add(DOCTYP);
GridViewTextBoxColumn DOCREFER = new GridViewTextBoxColumn();
DOCREFER.Name = "DOCREFER";
DOCREFER.FieldName = "DOCREFER";
DOCREFER.HeaderText = "เลขที่ที่อ้างอิง";
DOCREFER.IsVisible = true;
DOCREFER.ReadOnly = true;
DOCREFER.BestFit();
rgv_HD.Columns.Add(DOCREFER);
GridViewTextBoxColumn EMPLNAME = new GridViewTextBoxColumn();
EMPLNAME.Name = "EMPLNAME";
EMPLNAME.FieldName = "EMPLNAME";
EMPLNAME.HeaderText = "ชื่อ";
EMPLNAME.IsVisible = true;
EMPLNAME.ReadOnly = true;
EMPLNAME.BestFit();
rgv_HD.Columns.Add(EMPLNAME);
GridViewTextBoxColumn HEADAPPROVED = new GridViewTextBoxColumn();
HEADAPPROVED.Name = "HEADAPPROVED";
HEADAPPROVED.FieldName = "HEADAPPROVED";
HEADAPPROVED.HeaderText = "หน./ผช.";
HEADAPPROVED.IsVisible = true;
HEADAPPROVED.ReadOnly = true;
HEADAPPROVED.BestFit();
rgv_HD.Columns.Add(HEADAPPROVED);
GridViewTextBoxColumn HEADAPPROVEDBYNAME = new GridViewTextBoxColumn();
HEADAPPROVEDBYNAME.Name = "HEADAPPROVEDBYNAME";
HEADAPPROVEDBYNAME.FieldName = "HEADAPPROVEDBYNAME";
HEADAPPROVEDBYNAME.HeaderText = "ผู้อนุมัติ";
HEADAPPROVEDBYNAME.IsVisible = true;
HEADAPPROVEDBYNAME.ReadOnly = true;
HEADAPPROVEDBYNAME.BestFit();
rgv_HD.Columns.Add(HEADAPPROVEDBYNAME);
GridViewTextBoxColumn HRAPPROVED = new GridViewTextBoxColumn();
HRAPPROVED.Name = "HRAPPROVED";
HRAPPROVED.FieldName = "HRAPPROVED";
HRAPPROVED.HeaderText = "บุคคล";
HRAPPROVED.IsVisible = true;
HRAPPROVED.ReadOnly = true;
HRAPPROVED.BestFit();
rgv_HD.Columns.Add(HRAPPROVED);
GridViewTextBoxColumn HRAPPROVEDBYNAME = new GridViewTextBoxColumn();
HRAPPROVEDBYNAME.Name = "HRAPPROVEDBYNAME";
HRAPPROVEDBYNAME.FieldName = "HRAPPROVEDBYNAME";
HRAPPROVEDBYNAME.HeaderText = "ผู้อนุมัติ";
HRAPPROVEDBYNAME.IsVisible = true;
HRAPPROVEDBYNAME.ReadOnly = true;
HRAPPROVEDBYNAME.BestFit();
rgv_HD.Columns.Add(HRAPPROVEDBYNAME);
GridViewTextBoxColumn DOCSTAT = new GridViewTextBoxColumn();
DOCSTAT.Name = "DOCSTAT";
DOCSTAT.FieldName = "DOCSTAT";
DOCSTAT.HeaderText = "สถานะเอกสาร";
DOCSTAT.IsVisible = true;
DOCSTAT.ReadOnly = true;
DOCSTAT.BestFit();
rgv_HD.Columns.Add(DOCSTAT);
}
void InitializeGridVeiw()
{
// GridData
this.rgv_empholiday.Dock = DockStyle.Fill;
this.rgv_empholiday.ReadOnly = true;
this.rgv_empholiday.AutoGenerateColumns = true;
this.rgv_empholiday.EnableFiltering = false;
this.rgv_empholiday.AllowAddNewRow = false;
this.rgv_empholiday.MasterTemplate.AutoGenerateColumns = false;
this.rgv_empholiday.ShowGroupedColumns = true;
this.rgv_empholiday.MasterTemplate.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
this.rgv_empholiday.EnableHotTracking = true;
this.rgv_empholiday.AutoSizeRows = true;
//GridViewTextBoxColumn PWEMPLOYEE = new GridViewTextBoxColumn();
//PWEMPLOYEE.Name = "PWEMPLOYEE";
//PWEMPLOYEE.FieldName = "PWEMPLOYEE";
//PWEMPLOYEE.HeaderText = "รหัสพนักงาน";
//PWEMPLOYEE.IsVisible = true;
//PWEMPLOYEE.ReadOnly = true;
//PWEMPLOYEE.BestFit();
//rgv_empholiday.Columns.Add(PWEMPLOYEE);
//GridViewTextBoxColumn PWNAME = new GridViewTextBoxColumn();
//PWNAME.Name = "PWNAME";
//PWNAME.FieldName = "PWNAME";
//PWNAME.HeaderText = "ชื่อ-สกุล";
//PWNAME.IsVisible = true;
//PWNAME.ReadOnly = true;
//PWNAME.BestFit();
//rgv_empholiday.Columns.Add(PWNAME);
//GridViewTextBoxColumn SECTIONNAME = new GridViewTextBoxColumn();
//SECTIONNAME.Name = "SECTIONNAME";
//SECTIONNAME.FieldName = "SECTIONNAME";
//SECTIONNAME.HeaderText = "แผนก";
//SECTIONNAME.IsVisible = true;
//SECTIONNAME.ReadOnly = true;
//SECTIONNAME.BestFit();
//rgv_empholiday.Columns.Add(SECTIONNAME);
GridViewTextBoxColumn PWDATE = new GridViewTextBoxColumn();
PWDATE.Name = "PWDATE";
PWDATE.FieldName = "PWDATE";
PWDATE.HeaderText = "วันที่";
PWDATE.IsVisible = true;
PWDATE.ReadOnly = true;
PWDATE.BestFit();
rgv_empholiday.Columns.Add(PWDATE);
GridViewTextBoxColumn PWDESC = new GridViewTextBoxColumn();
PWDESC.Name = "PWDESC";
PWDESC.FieldName = "PWDESC";
PWDESC.HeaderText = "คำอธิบาย";
PWDESC.IsVisible = true;
PWDESC.ReadOnly = true;
PWDESC.BestFit();
rgv_empholiday.Columns.Add(PWDESC);
GridViewTextBoxColumn PWTIME0 = new GridViewTextBoxColumn();
PWTIME0.Name = "PWTIME0";
PWTIME0.FieldName = "PWTIME0";
PWTIME0.HeaderText = "รหัสกะ";
PWTIME0.IsVisible = true;
PWTIME0.ReadOnly = true;
PWTIME0.BestFit();
rgv_empholiday.Columns.Add(PWTIME0);
}
private void InitializeradGridview()
{
rgv_changholiday.Dock = DockStyle.Fill;
rgv_changholiday.AutoGenerateColumns = true;
rgv_changholiday.EnableFiltering = false;
rgv_changholiday.AllowAddNewRow = false;
rgv_changholiday.MasterTemplate.AutoGenerateColumns = false;
rgv_changholiday.ShowGroupedColumns = true;
rgv_changholiday.MasterTemplate.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
rgv_changholiday.EnableHotTracking = true;
rgv_changholiday.AutoSizeRows = true;
GridViewTextBoxColumn FROMHOLIDAY = new GridViewTextBoxColumn();
FROMHOLIDAY.Name = "FROMHOLIDAY";
FROMHOLIDAY.FieldName = "FROMHOLIDAY";
FROMHOLIDAY.HeaderText = "วันที่มาทำ";
FROMHOLIDAY.IsVisible = true;
FROMHOLIDAY.ReadOnly = true;
FROMHOLIDAY.BestFit();
rgv_changholiday.Columns.Add(FROMHOLIDAY);
GridViewTextBoxColumn TOSHIFTID = new GridViewTextBoxColumn();
TOSHIFTID.Name = "TOSHIFTID";
TOSHIFTID.FieldName = "TOSHIFTID";
TOSHIFTID.HeaderText = "รหัสกะ";
TOSHIFTID.IsVisible = true;
TOSHIFTID.ReadOnly = true;
TOSHIFTID.BestFit();
rgv_changholiday.Columns.Add(TOSHIFTID);
GridViewTextBoxColumn TOSHIFTDESC = new GridViewTextBoxColumn();
TOSHIFTDESC.Name = "TOSHIFTDESC";
TOSHIFTDESC.FieldName = "TOSHIFTDESC";
TOSHIFTDESC.HeaderText = "คำอธิบาย";
TOSHIFTDESC.IsVisible = true;
TOSHIFTDESC.ReadOnly = true;
TOSHIFTDESC.BestFit();
rgv_changholiday.Columns.Add(TOSHIFTDESC);
GridViewTextBoxColumn TOHOLIDAY = new GridViewTextBoxColumn();
TOHOLIDAY.Name = "TOHOLIDAY";
TOHOLIDAY.FieldName = "TOHOLIDAY";
TOHOLIDAY.HeaderText = "วันที่หยุด";
TOHOLIDAY.IsVisible = true;
TOHOLIDAY.ReadOnly = true;
TOHOLIDAY.BestFit();
rgv_changholiday.Columns.Add(TOHOLIDAY);
GridViewTextBoxColumn REASON = new GridViewTextBoxColumn();
REASON.Name = "REASON";
REASON.FieldName = "REASON";
REASON.HeaderText = "เหตุผล";
REASON.IsVisible = true;
REASON.ReadOnly = true;
REASON.BestFit();
rgv_changholiday.Columns.Add(REASON);
GridViewCommandColumn BTDELETE = new GridViewCommandColumn();
BTDELETE.Name = "BTDELETE";
BTDELETE.HeaderText = "ยกเลิก";
BTDELETE.Width = 20;
rgv_changholiday.Columns.Add(BTDELETE);
}
public FormEmplEdit()
{
InitializeComponent();
this.KeyPreview = true;
this.Icon = HROUTOFFICE.Properties.Resources.sign_out_ico;
// <layOut>
this.panelRightSide.Dock = DockStyle.Right;
this.radGroupBox1.Dock = DockStyle.Fill;
this.panelTop.Dock = DockStyle.Top;
this.panelBottom.Dock = DockStyle.Fill;
this.radGridViewEditDoc.Dock = DockStyle.Fill;
// <Status>
this.statusLabelMessage.Text = string.Empty;
this.stutusF5.Text = string.Format(@"{0}: {1}", "F5", "Refresh");
// <Button>
this.btnAdjust.Click += new EventHandler(btnAdjust_Click);
// <RadGridView Bottom>
#region radGridViewl
// GridData
this.radGridViewEditDoc.Dock = DockStyle.Fill;
this.radGridViewEditDoc.AutoGenerateColumns = true;
this.radGridViewEditDoc.EnableFiltering = false;
this.radGridViewEditDoc.AllowAddNewRow = false;
this.radGridViewEditDoc.MasterTemplate.AutoGenerateColumns = false;
this.radGridViewEditDoc.ShowGroupedColumns = true;
this.radGridViewEditDoc.MasterTemplate.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
this.radGridViewEditDoc.EnableHotTracking = true;
this.radGridViewEditDoc.AutoSizeRows = true;
this.radGridViewEditDoc.ReadOnly = true;
this.radGridViewEditDoc.CurrentRowChanged += new CurrentRowChangedEventHandler(radGridViewEditDoc_CurrentRowChanged);
#endregion
#region Gridlines
this.radGridLines = new RadGridView();
// <WS>
this.radGridLines.Font = new System.Drawing.Font("Tahoma", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(222)));
this.radGridLines.ShowGroupPanel = false;
this.radGridLines.ShowGroupedColumns = true;
// </WS>
this.radGridLines.Dock = DockStyle.Fill;
this.radGridLines.AutoGenerateColumns = true;
this.radGridLines.EnableFiltering = true;
this.radGridLines.AllowAddNewRow = false;
this.radGridLines.ReadOnly = true;
this.radGridLines.BestFitColumns(Telerik.WinControls.UI.BestFitColumnMode.HeaderCells);
this.radGridLines.MasterTemplate.ShowHeaderCellButtons = true;
this.radGridLines.MasterTemplate.ShowFilteringRow = false;
this.radGridLines.MasterTemplate.AutoGenerateColumns = false;
this.radGridLines.ShowGroupedColumns = true;
this.radGridLines.MasterTemplate.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
GridViewTextBoxColumn col0_0 = new GridViewTextBoxColumn();
col0_0.Name = @"DocId";
col0_0.HeaderText = @"เอกสาร";
col0_0.FieldName = @"DocId";
col0_0.ReadOnly = true;
radGridLines.Columns.Add(col0_0);
panelBottom.Controls.Add(radGridLines);
GridViewTextBoxColumn col0_1 = new GridViewTextBoxColumn();
col0_1.Name = @"OutOfficeId";
col0_1.HeaderText = @"ลำดับ";
col0_1.FieldName = @"OutOfficeId";
col0_1.ReadOnly = true;
radGridLines.Columns.Add(col0_1);
panelBottom.Controls.Add(radGridLines);
GridViewTextBoxColumn col0 = new GridViewTextBoxColumn();
col0.Name = @"EmplId";
col0.HeaderText = @"พนักงาน";
col0.FieldName = @"EmplId";
col0.ReadOnly = true;
radGridLines.Columns.Add(col0);
panelBottom.Controls.Add(radGridLines);
GridViewTextBoxColumn col1 = new GridViewTextBoxColumn();
col1.Name = @"EmplFullName";
col1.HeaderText = @"ชื่อ-สกุล";
col1.FieldName = @"EmplFullName";
col1.ReadOnly = true;
radGridLines.Columns.Add(col1);
panelBottom.Controls.Add(radGridLines);
GridViewTextBoxColumn col1_1 = new GridViewTextBoxColumn();
col1_1.Name = @"Dept";
col1_1.HeaderText = @"ชื่อตำแหน่ง";
col1_1.FieldName = @"Dept";
col1_1.ReadOnly = true;
radGridLines.Columns.Add(col1_1);
panelBottom.Controls.Add(radGridLines);
GridViewTextBoxColumn col3 = new GridViewTextBoxColumn();
col3.Name = @"DimentionId";
col3.HeaderText = @"รหัสแผนก";
col3.FieldName = @"DimentionId";
col3.ReadOnly = true;
col3.IsVisible = false;
radGridLines.Columns.Add(col3);
panelBottom.Controls.Add(radGridLines);
GridViewTextBoxColumn col4 = new GridViewTextBoxColumn();
col4.Name = @"Dimention";
col4.HeaderText = @"แผนก";
col4.FieldName = @"Dimention";
col4.ReadOnly = true;
radGridLines.Columns.Add(col4);
GridViewTextBoxColumn col4_0 = new GridViewTextBoxColumn();
col4_0.Name = @"OutType";
col4_0.HeaderText = @"ประเภท";
col4_0.FieldName = @"OutType";
col4_0.ReadOnly = true;
radGridLines.Columns.Add(col4_0);
//OutType
GridViewTextBoxColumn col4_1 = new GridViewTextBoxColumn();
col4_1.Name = @"HeadApproved";
col4_1.HeaderText = @"หน./ผช.";
col4_1.FieldName = @"HeadApproved";
col4_1.ReadOnly = true;
radGridLines.Columns.Add(col4_1);
GridViewTextBoxColumn col5 = new GridViewTextBoxColumn();
col5.Name = @"HeadApprovedName";
col5.HeaderText = @"อนุมัติโดย";
col5.FieldName = @"HeadApprovedName";
col5.ReadOnly = true;
radGridLines.Columns.Add(col5);
panelBottom.Controls.Add(radGridLines);
#endregion
}
void InitializeSetGridView()
{
// GridData
this.rgv_ApproveHD.Dock = DockStyle.Fill;
this.rgv_ApproveHD.ReadOnly = true;
this.rgv_ApproveHD.AutoGenerateColumns = true;
this.rgv_ApproveHD.EnableFiltering = false;
this.rgv_ApproveHD.AllowAddNewRow = false;
this.rgv_ApproveHD.MasterTemplate.AutoGenerateColumns = false;
this.rgv_ApproveHD.ShowGroupedColumns = true;
this.rgv_ApproveHD.MasterTemplate.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
this.rgv_ApproveHD.EnableHotTracking = true;
this.rgv_ApproveHD.AutoSizeRows = true;
GridViewTextBoxColumn DOCID = new GridViewTextBoxColumn();
DOCID.Name = "DOCID";
DOCID.FieldName = "DOCID";
DOCID.HeaderText = "เลขที่เอกสาร";
DOCID.IsVisible = true;
DOCID.ReadOnly = true;
DOCID.BestFit();
rgv_ApproveHD.Columns.Add(DOCID);
GridViewTextBoxColumn CREATEDDATE = new GridViewTextBoxColumn();
CREATEDDATE.Name = "CREATEDDATE";
CREATEDDATE.FieldName = "CREATEDDATE";
CREATEDDATE.HeaderText = "วันที่สร้าง";
CREATEDDATE.IsVisible = true;
CREATEDDATE.ReadOnly = true;
CREATEDDATE.BestFit();
rgv_ApproveHD.Columns.Add(CREATEDDATE);
GridViewTextBoxColumn CREATEDNAME = new GridViewTextBoxColumn();
CREATEDNAME.Name = "CREATEDNAME";
CREATEDNAME.FieldName = "CREATEDNAME";
CREATEDNAME.HeaderText = "ผู้สร้าง";
CREATEDNAME.IsVisible = true;
CREATEDNAME.ReadOnly = true;
CREATEDNAME.BestFit();
rgv_ApproveHD.Columns.Add(CREATEDNAME);
GridViewTextBoxColumn MODIFIEDDATE = new GridViewTextBoxColumn();
MODIFIEDDATE.Name = "MODIFIEDDATE";
MODIFIEDDATE.FieldName = "MODIFIEDDATE";
MODIFIEDDATE.HeaderText = "แก้ไขล่าสุด";
MODIFIEDDATE.IsVisible = true;
MODIFIEDDATE.ReadOnly = true;
MODIFIEDDATE.BestFit();
rgv_ApproveHD.Columns.Add(MODIFIEDDATE);
GridViewTextBoxColumn EXPIREDATE = new GridViewTextBoxColumn();
EXPIREDATE.Name = "EXPIREDATE";
EXPIREDATE.FieldName = "EXPIREDATE";
EXPIREDATE.HeaderText = "อนุมัติภายใน";
EXPIREDATE.IsVisible = true;
EXPIREDATE.ReadOnly = true;
EXPIREDATE.BestFit();
rgv_ApproveHD.Columns.Add(EXPIREDATE);
GridViewTextBoxColumn EMPLNAME = new GridViewTextBoxColumn();
EMPLNAME.Name = "EMPLNAME";
EMPLNAME.FieldName = "EMPLNAME";
EMPLNAME.HeaderText = "ชื่อ";
EMPLNAME.IsVisible = true;
EMPLNAME.ReadOnly = true;
EMPLNAME.BestFit();
rgv_ApproveHD.Columns.Add(EMPLNAME);
GridViewTextBoxColumn DOCTYP = new GridViewTextBoxColumn();
DOCTYP.Name = "DOCTYP";
DOCTYP.FieldName = "DOCTYP";
DOCTYP.HeaderText = "ชนิดเอกสารยกเลิก";
DOCTYP.IsVisible = false;
DOCTYP.ReadOnly = true;
DOCTYP.BestFit();
rgv_ApproveHD.Columns.Add(DOCTYP);
GridViewTextBoxColumn TYPDESC = new GridViewTextBoxColumn();
TYPDESC.Name = "TYPDESC";
TYPDESC.FieldName = "TYPDESC";
TYPDESC.HeaderText = "เอกสารยกเลิก";
TYPDESC.IsVisible = true;
TYPDESC.ReadOnly = true;
TYPDESC.BestFit();
rgv_ApproveHD.Columns.Add(TYPDESC);
GridViewTextBoxColumn HEADAPPROVED = new GridViewTextBoxColumn();
HEADAPPROVED.Name = "HEADAPPROVED";
HEADAPPROVED.FieldName = "HEADAPPROVED";
HEADAPPROVED.HeaderText = "หน./ผช.";
HEADAPPROVED.IsVisible = true;
HEADAPPROVED.ReadOnly = true;
HEADAPPROVED.BestFit();
rgv_ApproveHD.Columns.Add(HEADAPPROVED);
GridViewTextBoxColumn HEADAPPROVEDBYNAME = new GridViewTextBoxColumn();
HEADAPPROVEDBYNAME.Name = "HEADAPPROVEDBYNAME";
HEADAPPROVEDBYNAME.FieldName = "HEADAPPROVEDBYNAME";
HEADAPPROVEDBYNAME.HeaderText = "ผู้อนุมัติ";
HEADAPPROVEDBYNAME.IsVisible = true;
HEADAPPROVEDBYNAME.ReadOnly = true;
HEADAPPROVEDBYNAME.BestFit();
rgv_ApproveHD.Columns.Add(HEADAPPROVEDBYNAME);
GridViewTextBoxColumn HRAPPROVED = new GridViewTextBoxColumn();
HRAPPROVED.Name = "HRAPPROVED";
HRAPPROVED.FieldName = "HRAPPROVED";
HRAPPROVED.HeaderText = "บุคคล";
HRAPPROVED.IsVisible = true;
HRAPPROVED.ReadOnly = true;
HRAPPROVED.BestFit();
rgv_ApproveHD.Columns.Add(HRAPPROVED);
GridViewTextBoxColumn HRAPPROVEDBYNAME = new GridViewTextBoxColumn();
HRAPPROVEDBYNAME.Name = "HRAPPROVEDBYNAME";
HRAPPROVEDBYNAME.FieldName = "HRAPPROVEDBYNAME";
HRAPPROVEDBYNAME.HeaderText = "ผู้อนุมัติ";
HRAPPROVEDBYNAME.IsVisible = true;
HRAPPROVEDBYNAME.ReadOnly = true;
HRAPPROVEDBYNAME.BestFit();
rgv_ApproveHD.Columns.Add(HRAPPROVEDBYNAME);
GridViewCommandColumn ApproveButton = new GridViewCommandColumn();
ApproveButton.Name = "ApproveButton";
ApproveButton.FieldName = "ApproveButton";
ApproveButton.HeaderText = "อนุมัติ";
rgv_ApproveHD.Columns.Add(ApproveButton);
}
public PWTIMETEMP()
{
InitializeComponent();
#region <Window Form>
this.Text = string.Format(@"Usr:{0}; {1}", System.Security.Principal.WindowsIdentity.GetCurrent().Name, "พฤติกรรมการรูดบัตร");
this.KeyPreview = true;
this.ShowIcon = true;
this.StartPosition = FormStartPosition.CenterParent;
this.Load += new EventHandler(PWTIMETEMP_Load);
#endregion
#region <layout>
this.toolStrip1.Dock = DockStyle.Top;
this.panelContainer.Dock = DockStyle.Fill;
#endregion
#region <RadGridView>
this.radGridTimeTemp.Dock = DockStyle.Fill;
this.radGridTimeTemp.AutoGenerateColumns = true;
this.radGridTimeTemp.EnableFiltering = true;
this.radGridTimeTemp.AllowAddNewRow = false;
this.radGridTimeTemp.ReadOnly = true;
this.radGridTimeTemp.BestFitColumns(Telerik.WinControls.UI.BestFitColumnMode.HeaderCells);
this.radGridTimeTemp.MasterTemplate.ShowHeaderCellButtons = true;
this.radGridTimeTemp.MasterTemplate.ShowFilteringRow = false;
this.radGridTimeTemp.MasterTemplate.AutoGenerateColumns = false;
GridViewTextBoxColumn txtCol0 = new GridViewTextBoxColumn();
txtCol0.FieldName = "PWDATE";
txtCol0.Name = "PWDATE";
txtCol0.HeaderText = "วันที่";
txtCol0.FormatString = "{0:dd/MM/yyyy}";
txtCol0.IsVisible = true;
this.radGridTimeTemp.Columns.Add(txtCol0);
GridViewTextBoxColumn txtCol1 = new GridViewTextBoxColumn();
txtCol1.FieldName = "PWRDATE";
txtCol1.Name = "PWRDATE";
txtCol1.HeaderText = "วันที่(2)";
txtCol1.FormatString = "{0:dd/MM/yyyy}";
txtCol1.IsVisible = true;
this.radGridTimeTemp.Columns.Add(txtCol1);
GridViewTextBoxColumn txtCol2 = new GridViewTextBoxColumn();
txtCol2.FieldName = "PWEMPLOYEE";
txtCol2.Name = "PWEMPLOYEE";
txtCol2.HeaderText = "พนักงาน";
txtCol2.IsVisible = true;
this.radGridTimeTemp.Columns.Add(txtCol2);
GridViewTextBoxColumn txtCol3 = new GridViewTextBoxColumn();
txtCol3.FieldName = "PWSOURCE";
txtCol3.Name = "PWSOURCE";
txtCol3.HeaderText = "PWSOURCE";
txtCol3.IsVisible = true;
this.radGridTimeTemp.Columns.Add(txtCol3);
GridViewDecimalColumn txtCol4 = new GridViewDecimalColumn();
txtCol4.FieldName = "PWTIME";
txtCol4.Name = "PWTIME";
txtCol4.HeaderText = "เวลา";
txtCol4.IsVisible = true;
this.radGridTimeTemp.Columns.Add(txtCol4);
GridViewTextBoxColumn txtCol5 = new GridViewTextBoxColumn();
txtCol5.FieldName = "PWTRANTYPE";
txtCol5.Name = "PWTRANTYPE";
txtCol5.HeaderText = "ประเภท";
txtCol5.IsVisible = true;
this.radGridTimeTemp.Columns.Add(txtCol5);
GridViewTextBoxColumn txtCol6 = new GridViewTextBoxColumn();
txtCol6.FieldName = "PWEVENT";
txtCol6.Name = "PWEVENT";
txtCol6.HeaderText = "เหตุการณ์";
txtCol6.IsVisible = true;
this.radGridTimeTemp.Columns.Add(txtCol6);
#endregion
#region <MenuItem>
toolStripBtnExportExcel.Click += new EventHandler(toolStripBtnExportExcel_Click);
#endregion
}
private void InitializeDataGridView()
{
#region SetDataGrid
this.rgv_EmpData.Dock = DockStyle.Fill;
this.rgv_EmpData.ReadOnly = true;
this.rgv_EmpData.AutoGenerateColumns = true;
this.rgv_EmpData.EnableFiltering = false;
this.rgv_EmpData.AllowAddNewRow = false;
this.rgv_EmpData.MasterTemplate.AutoGenerateColumns = false;
this.rgv_EmpData.ShowGroupedColumns = true;
this.rgv_EmpData.MasterTemplate.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
this.rgv_EmpData.EnableHotTracking = true;
this.rgv_EmpData.AutoSizeRows = true;
GridViewTextBoxColumn TYPDESC = new GridViewTextBoxColumn();
TYPDESC.Name = "TYPDESC";
TYPDESC.FieldName = "TYPDESC";
TYPDESC.HeaderText = "ประเภทเอกสาร";
TYPDESC.IsVisible = true;
TYPDESC.ReadOnly = true;
TYPDESC.BestFit();
rgv_EmpData.Columns.Add(TYPDESC);
GridViewTextBoxColumn DSDOCNO = new GridViewTextBoxColumn();
DSDOCNO.Name = "DSDOCNO";
DSDOCNO.FieldName = "DSDOCNO";
DSDOCNO.HeaderText = "เลขที่เอกสาร";
DSDOCNO.IsVisible = true;
DSDOCNO.ReadOnly = true;
DSDOCNO.BestFit();
rgv_EmpData.Columns.Add(DSDOCNO);
GridViewTextBoxColumn SHIFTDATE = new GridViewTextBoxColumn();
SHIFTDATE.Name = "SHIFTDATE";
SHIFTDATE.FieldName = "SHIFTDATE";
SHIFTDATE.HeaderText = "วันที่เปลี่ยนกะ";
SHIFTDATE.IsVisible = true;
SHIFTDATE.ReadOnly = true;
SHIFTDATE.BestFit();
rgv_EmpData.Columns.Add(SHIFTDATE);
GridViewTextBoxColumn FROMSHIFTID = new GridViewTextBoxColumn();
FROMSHIFTID.Name = "FROMSHIFTID";
FROMSHIFTID.FieldName = "FROMSHIFTID";
FROMSHIFTID.HeaderText = "กะเดิม";
FROMSHIFTID.IsVisible = true;
FROMSHIFTID.ReadOnly = true;
FROMSHIFTID.BestFit();
rgv_EmpData.Columns.Add(FROMSHIFTID);
GridViewTextBoxColumn FROMSHIFTDESC = new GridViewTextBoxColumn();
FROMSHIFTDESC.Name = "FROMSHIFTDESC";
FROMSHIFTDESC.FieldName = "FROMSHIFTDESC";
FROMSHIFTDESC.HeaderText = "คำอธิบาย";
FROMSHIFTDESC.IsVisible = true;
FROMSHIFTDESC.ReadOnly = true;
FROMSHIFTDESC.BestFit();
rgv_EmpData.Columns.Add(FROMSHIFTDESC);
GridViewTextBoxColumn TOSHIFTID = new GridViewTextBoxColumn();
TOSHIFTID.Name = "TOSHIFTID";
TOSHIFTID.FieldName = "TOSHIFTID";
TOSHIFTID.HeaderText = "กะใหม่";
TOSHIFTID.IsVisible = true;
TOSHIFTID.ReadOnly = true;
TOSHIFTID.BestFit();
rgv_EmpData.Columns.Add(TOSHIFTID);
GridViewTextBoxColumn TOSHIFTDESC = new GridViewTextBoxColumn();
TOSHIFTDESC.Name = "TOSHIFTDESC";
TOSHIFTDESC.FieldName = "TOSHIFTDESC";
TOSHIFTDESC.HeaderText = "คำอธิบาย";
TOSHIFTDESC.IsVisible = true;
TOSHIFTDESC.ReadOnly = true;
TOSHIFTDESC.BestFit();
rgv_EmpData.Columns.Add(TOSHIFTDESC);
GridViewTextBoxColumn REMARK = new GridViewTextBoxColumn();
REMARK.Name = "REMARK";
REMARK.FieldName = "REMARK";
REMARK.HeaderText = "เหตุผล";
REMARK.IsVisible = true;
REMARK.ReadOnly = true;
REMARK.BestFit();
rgv_EmpData.Columns.Add(REMARK);
GridViewTextBoxColumn CREATEDDATE = new GridViewTextBoxColumn();
CREATEDDATE.Name = "CREATEDDATE";
CREATEDDATE.FieldName = "CREATEDDATE";
CREATEDDATE.HeaderText = "วันที่บันทึก";
CREATEDDATE.IsVisible = true;
CREATEDDATE.ReadOnly = true;
CREATEDDATE.BestFit();
rgv_EmpData.Columns.Add(CREATEDDATE);
#endregion
}
void InitializeGridView()
{
this.GridViewShowData.Dock = DockStyle.Fill;
this.GridViewShowData.ReadOnly = true;
this.GridViewShowData.AutoGenerateColumns = true;
this.GridViewShowData.EnableFiltering = false;
this.GridViewShowData.AllowAddNewRow = false;
this.GridViewShowData.MasterTemplate.AutoGenerateColumns = false;
this.GridViewShowData.ShowGroupedColumns = true;
this.GridViewShowData.MasterTemplate.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
this.GridViewShowData.EnableHotTracking = true;
this.GridViewShowData.AutoSizeRows = true;
GridViewTextBoxColumn OutOfficeId = new GridViewTextBoxColumn();
OutOfficeId.Name = "OutOfficeId";
OutOfficeId.FieldName = "OutOfficeId";
OutOfficeId.HeaderText = "จำนวน";
OutOfficeId.Width = 15;
OutOfficeId.IsVisible = true;
OutOfficeId.ReadOnly = true;
OutOfficeId.BestFit();
GridViewShowData.Columns.Add(OutOfficeId);
GridViewTextBoxColumn EmplId = new GridViewTextBoxColumn();
EmplId.Name = "EmplId";
EmplId.FieldName = "EmplId";
EmplId.HeaderText = "รหัสพนักงาน";
EmplId.Width = 30;
EmplId.IsVisible = true;
EmplId.ReadOnly = true;
EmplId.BestFit();
GridViewShowData.Columns.Add(EmplId);
GridViewTextBoxColumn EmplFullName = new GridViewTextBoxColumn();
EmplFullName.Name = "EmplFullName";
EmplFullName.FieldName = "EmplFullName";
EmplFullName.HeaderText = "ชื่อ-สกุล";
EmplFullName.IsVisible = true;
EmplFullName.ReadOnly = true;
EmplFullName.BestFit();
GridViewShowData.Columns.Add(EmplFullName);
GridViewTextBoxColumn Dimention = new GridViewTextBoxColumn();
Dimention.Name = "Dimention";
Dimention.FieldName = "Dimention";
Dimention.HeaderText = "แผนก";
Dimention.IsVisible = true;
Dimention.ReadOnly = true;
Dimention.BestFit();
GridViewShowData.Columns.Add(Dimention);
}
void InitializeGridVeiw()
{
// GridData
this.rgv_ApproveHR.Dock = DockStyle.Fill;
this.rgv_ApproveHR.ReadOnly = true;
this.rgv_ApproveHR.AutoGenerateColumns = true;
this.rgv_ApproveHR.EnableFiltering = false;
this.rgv_ApproveHR.AllowAddNewRow = false;
this.rgv_ApproveHR.MasterTemplate.AutoGenerateColumns = false;
this.rgv_ApproveHR.ShowGroupedColumns = true;
this.rgv_ApproveHR.MasterTemplate.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
this.rgv_ApproveHR.EnableHotTracking = true;
this.rgv_ApproveHR.AutoSizeRows = true;
GridViewTextBoxColumn DOCID = new GridViewTextBoxColumn();
DOCID.Name = "DOCID";
DOCID.FieldName = "DOCID";
DOCID.HeaderText = "เลขที่เอกสาร";
DOCID.IsVisible = true;
DOCID.ReadOnly = true;
DOCID.BestFit();
rgv_ApproveHR.Columns.Add(DOCID);
GridViewTextBoxColumn DOCSTAT = new GridViewTextBoxColumn();
DOCSTAT.Name = "DOCSTAT";
DOCSTAT.FieldName = "DOCSTAT";
DOCSTAT.HeaderText = "สถานะเอกสาร";
DOCSTAT.IsVisible = true;
DOCSTAT.ReadOnly = true;
DOCSTAT.BestFit();
rgv_ApproveHR.Columns.Add(DOCSTAT);
GridViewTextBoxColumn CREATEDNAME = new GridViewTextBoxColumn();
CREATEDNAME.Name = "CREATEDNAME";
CREATEDNAME.FieldName = "CREATEDNAME";
CREATEDNAME.HeaderText = "ผู้สร้าง";
CREATEDNAME.IsVisible = true;
CREATEDNAME.ReadOnly = true;
CREATEDNAME.BestFit();
rgv_ApproveHR.Columns.Add(CREATEDNAME);
GridViewTextBoxColumn MODIFIEDDATE = new GridViewTextBoxColumn();
MODIFIEDDATE.Name = "MODIFIEDDATE";
MODIFIEDDATE.FieldName = "MODIFIEDDATE";
MODIFIEDDATE.HeaderText = "แก้ไขล่าสุด";
MODIFIEDDATE.IsVisible = true;
MODIFIEDDATE.ReadOnly = true;
MODIFIEDDATE.BestFit();
rgv_ApproveHR.Columns.Add(MODIFIEDDATE);
GridViewTextBoxColumn EMPLNAME = new GridViewTextBoxColumn();
EMPLNAME.Name = "EMPLNAME";
EMPLNAME.FieldName = "EMPLNAME";
EMPLNAME.HeaderText = "ชื่อ";
EMPLNAME.IsVisible = true;
EMPLNAME.ReadOnly = true;
EMPLNAME.BestFit();
rgv_ApproveHR.Columns.Add(EMPLNAME);
GridViewTextBoxColumn HEADAPPROVED = new GridViewTextBoxColumn();
HEADAPPROVED.Name = "HEADAPPROVED";
HEADAPPROVED.FieldName = "HEADAPPROVED";
HEADAPPROVED.HeaderText = "หน./ผช.";
HEADAPPROVED.IsVisible = true;
HEADAPPROVED.ReadOnly = true;
HEADAPPROVED.BestFit();
rgv_ApproveHR.Columns.Add(HEADAPPROVED);
GridViewTextBoxColumn HEADAPPROVEDBYNAME = new GridViewTextBoxColumn();
HEADAPPROVEDBYNAME.Name = "HEADAPPROVEDBYNAME";
HEADAPPROVEDBYNAME.FieldName = "HEADAPPROVEDBYNAME";
HEADAPPROVEDBYNAME.HeaderText = "ผู้อนุมัติ";
HEADAPPROVEDBYNAME.IsVisible = true;
HEADAPPROVEDBYNAME.ReadOnly = true;
HEADAPPROVEDBYNAME.BestFit();
rgv_ApproveHR.Columns.Add(HEADAPPROVEDBYNAME);
GridViewTextBoxColumn HRAPPROVED = new GridViewTextBoxColumn();
HRAPPROVED.Name = "HRAPPROVED";
HRAPPROVED.FieldName = "HRAPPROVED";
HRAPPROVED.HeaderText = "บุคคล";
HRAPPROVED.IsVisible = true;
HRAPPROVED.ReadOnly = true;
HRAPPROVED.BestFit();
rgv_ApproveHR.Columns.Add(HRAPPROVED);
GridViewTextBoxColumn HRAPPROVEDBYNAME = new GridViewTextBoxColumn();
HRAPPROVEDBYNAME.Name = "HRAPPROVEDBYNAME";
HRAPPROVEDBYNAME.FieldName = "HRAPPROVEDBYNAME";
HRAPPROVEDBYNAME.HeaderText = "ผู้อนุมัติ";
HRAPPROVEDBYNAME.IsVisible = true;
HRAPPROVEDBYNAME.ReadOnly = true;
HRAPPROVEDBYNAME.BestFit();
rgv_ApproveHR.Columns.Add(HRAPPROVEDBYNAME);
GridViewCommandColumn ApproveButton = new GridViewCommandColumn();
ApproveButton.Name = "ApproveButton";
ApproveButton.FieldName = "ApproveButton";
ApproveButton.HeaderText = "อนุมัติ";
rgv_ApproveHR.Columns.Add(ApproveButton);
}
void GridViewReport()
{
this.rgv_StatusDoc.Dock = DockStyle.Fill;
this.rgv_StatusDoc.ReadOnly = true;
this.rgv_StatusDoc.AutoGenerateColumns = true;
this.rgv_StatusDoc.EnableFiltering = false;
this.rgv_StatusDoc.AllowAddNewRow = false;
this.rgv_StatusDoc.MasterTemplate.AutoGenerateColumns = false;
this.rgv_StatusDoc.ShowGroupedColumns = true;
this.rgv_StatusDoc.MasterTemplate.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
this.rgv_StatusDoc.EnableHotTracking = true;
this.rgv_StatusDoc.AutoSizeRows = true;
GridViewTextBoxColumn DOCID = new GridViewTextBoxColumn();
DOCID.Name = "DOCID";
DOCID.FieldName = "DOCID";
DOCID.HeaderText = "เลขที่เอกสาร";
DOCID.IsVisible = true;
DOCID.ReadOnly = true;
DOCID.BestFit();
rgv_StatusDoc.Columns.Add(DOCID);
GridViewTextBoxColumn EMPLID = new GridViewTextBoxColumn();
EMPLID.Name = "EMPLID";
EMPLID.FieldName = "EMPLID";
EMPLID.HeaderText = "รหัส";
EMPLID.IsVisible = true;
EMPLID.ReadOnly = true;
EMPLID.BestFit();
rgv_StatusDoc.Columns.Add(EMPLID);
GridViewTextBoxColumn EMPLNAME = new GridViewTextBoxColumn();
EMPLNAME.Name = "EMPLNAME";
EMPLNAME.FieldName = "EMPLNAME";
EMPLNAME.HeaderText = "ชื่อ";
EMPLNAME.IsVisible = true;
EMPLNAME.ReadOnly = true;
EMPLNAME.BestFit();
rgv_StatusDoc.Columns.Add(EMPLNAME);
GridViewTextBoxColumn SECTIONNAME = new GridViewTextBoxColumn();
SECTIONNAME.Name = "SECTIONNAME";
SECTIONNAME.FieldName = "SECTIONNAME";
SECTIONNAME.HeaderText = "แผนก";
SECTIONNAME.IsVisible = true;
SECTIONNAME.ReadOnly = true;
SECTIONNAME.BestFit();
rgv_StatusDoc.Columns.Add(SECTIONNAME);
GridViewTextBoxColumn DEPTNAME = new GridViewTextBoxColumn();
DEPTNAME.Name = "DEPTNAME";
DEPTNAME.FieldName = "DEPTNAME";
DEPTNAME.HeaderText = "ตำแหน่ง";
DEPTNAME.IsVisible = true;
DEPTNAME.ReadOnly = true;
DEPTNAME.BestFit();
rgv_StatusDoc.Columns.Add(DEPTNAME);
GridViewTextBoxColumn FROMHOLIDAY = new GridViewTextBoxColumn();
FROMHOLIDAY.Name = "FROMHOLIDAY";
FROMHOLIDAY.FieldName = "FROMHOLIDAY";
FROMHOLIDAY.HeaderText = "วันที่มาทำ";
FROMHOLIDAY.IsVisible = true;
FROMHOLIDAY.ReadOnly = true;
FROMHOLIDAY.BestFit();
rgv_StatusDoc.Columns.Add(FROMHOLIDAY);
GridViewTextBoxColumn TOSHIFTID = new GridViewTextBoxColumn();
TOSHIFTID.Name = "TOSHIFTID";
TOSHIFTID.FieldName = "TOSHIFTID";
TOSHIFTID.HeaderText = "กะที่มาทำ";
TOSHIFTID.IsVisible = true;
TOSHIFTID.ReadOnly = true;
TOSHIFTID.BestFit();
rgv_StatusDoc.Columns.Add(TOSHIFTID);
GridViewTextBoxColumn TOSHIFTDESC = new GridViewTextBoxColumn();
TOSHIFTDESC.Name = "TOSHIFTDESC";
TOSHIFTDESC.FieldName = "TOSHIFTDESC";
TOSHIFTDESC.HeaderText = "คำอธิบาย";
TOSHIFTDESC.IsVisible = true;
TOSHIFTDESC.ReadOnly = true;
TOSHIFTDESC.BestFit();
rgv_StatusDoc.Columns.Add(TOSHIFTDESC);
GridViewTextBoxColumn TOHOLIDAY = new GridViewTextBoxColumn();
TOHOLIDAY.Name = "TOHOLIDAY";
TOHOLIDAY.FieldName = "TOHOLIDAY";
TOHOLIDAY.HeaderText = "วันที่หยุด";
TOHOLIDAY.IsVisible = true;
TOHOLIDAY.ReadOnly = true;
TOHOLIDAY.BestFit();
rgv_StatusDoc.Columns.Add(TOHOLIDAY);
GridViewTextBoxColumn REASON = new GridViewTextBoxColumn();
REASON.Name = "REASON";
REASON.FieldName = "REASON";
REASON.HeaderText = "เหตุผล";
REASON.IsVisible = true;
REASON.ReadOnly = true;
REASON.BestFit();
rgv_StatusDoc.Columns.Add(REASON);
GridViewTextBoxColumn HEADAPPROVED = new GridViewTextBoxColumn();
HEADAPPROVED.Name = "HEADAPPROVED";
HEADAPPROVED.FieldName = "HEADAPPROVED";
HEADAPPROVED.HeaderText = "หน./ผช.";
HEADAPPROVED.IsVisible = true;
HEADAPPROVED.ReadOnly = true;
HEADAPPROVED.BestFit();
rgv_StatusDoc.Columns.Add(HEADAPPROVED);
GridViewTextBoxColumn HEADAPPROVEDBYNAME = new GridViewTextBoxColumn();
HEADAPPROVEDBYNAME.Name = "HEADAPPROVEDBYNAME";
HEADAPPROVEDBYNAME.FieldName = "HEADAPPROVEDBYNAME";
HEADAPPROVEDBYNAME.HeaderText = "ผู้อนุมัติ";
HEADAPPROVEDBYNAME.IsVisible = true;
HEADAPPROVEDBYNAME.ReadOnly = true;
HEADAPPROVEDBYNAME.BestFit();
rgv_StatusDoc.Columns.Add(HEADAPPROVEDBYNAME);
GridViewTextBoxColumn HEADAPPORVEREMARK = new GridViewTextBoxColumn();
HEADAPPORVEREMARK.Name = "HEADAPPORVEREMARK";
HEADAPPORVEREMARK.FieldName = "HEADAPPORVEREMARK";
HEADAPPORVEREMARK.HeaderText = "หมายเหตุ";
HEADAPPORVEREMARK.IsVisible = true;
HEADAPPORVEREMARK.ReadOnly = true;
HEADAPPORVEREMARK.BestFit();
rgv_StatusDoc.Columns.Add(HEADAPPORVEREMARK);
GridViewTextBoxColumn HEADAPPROVEDDATE = new GridViewTextBoxColumn();
HEADAPPROVEDDATE.Name = "HEADAPPROVEDDATE";
HEADAPPROVEDDATE.FieldName = "HEADAPPROVEDDATE";
HEADAPPROVEDDATE.HeaderText = "วันที่อนุมัติ";
HEADAPPROVEDDATE.IsVisible = true;
HEADAPPROVEDDATE.ReadOnly = true;
HEADAPPROVEDDATE.BestFit();
rgv_StatusDoc.Columns.Add(HEADAPPROVEDDATE);
GridViewTextBoxColumn HRAPPROVED = new GridViewTextBoxColumn();
HRAPPROVED.Name = "HRAPPROVED";
HRAPPROVED.FieldName = "HRAPPROVED";
HRAPPROVED.HeaderText = "บุคคล";
HRAPPROVED.IsVisible = true;
HRAPPROVED.ReadOnly = true;
HRAPPROVED.BestFit();
rgv_StatusDoc.Columns.Add(HRAPPROVED);
GridViewTextBoxColumn HRAPPROVEDBYNAME = new GridViewTextBoxColumn();
HRAPPROVEDBYNAME.Name = "HRAPPROVEDBYNAME";
HRAPPROVEDBYNAME.FieldName = "HRAPPROVEDBYNAME";
HRAPPROVEDBYNAME.HeaderText = "ผู้อนุมัติ";
HRAPPROVEDBYNAME.IsVisible = true;
HRAPPROVEDBYNAME.ReadOnly = true;
HRAPPROVEDBYNAME.BestFit();
rgv_StatusDoc.Columns.Add(HRAPPROVEDBYNAME);
GridViewTextBoxColumn HRAPPORVEREMARK = new GridViewTextBoxColumn();
HRAPPORVEREMARK.Name = "HRAPPORVEREMARK";
HRAPPORVEREMARK.FieldName = "HRAPPORVEREMARK";
HRAPPORVEREMARK.HeaderText = "หมายเหตุ";
HRAPPORVEREMARK.IsVisible = true;
HRAPPORVEREMARK.ReadOnly = true;
HRAPPORVEREMARK.BestFit();
rgv_StatusDoc.Columns.Add(HRAPPORVEREMARK);
GridViewTextBoxColumn HRAPPROVEDDATE = new GridViewTextBoxColumn();
HRAPPROVEDDATE.Name = "HRAPPROVEDDATE";
HRAPPROVEDDATE.FieldName = "HRAPPROVEDDATE";
HRAPPROVEDDATE.HeaderText = "วันที่อนุมัติ";
HRAPPROVEDDATE.IsVisible = true;
HRAPPROVEDDATE.ReadOnly = true;
HRAPPROVEDDATE.BestFit();
rgv_StatusDoc.Columns.Add(HRAPPROVEDDATE);
}
public Chd_ApproveHD()
{
InitializeComponent();
#region radGridView
// GridData
this.rgv_ApproveHD.Dock = DockStyle.Fill;
this.rgv_ApproveHD.ReadOnly = true;
this.rgv_ApproveHD.AutoGenerateColumns = true;
this.rgv_ApproveHD.EnableFiltering = false;
this.rgv_ApproveHD.AllowAddNewRow = false;
this.rgv_ApproveHD.MasterTemplate.AutoGenerateColumns = false;
this.rgv_ApproveHD.ShowGroupedColumns = true;
this.rgv_ApproveHD.MasterTemplate.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
this.rgv_ApproveHD.EnableHotTracking = true;
this.rgv_ApproveHD.AutoSizeRows = true;
GridViewTextBoxColumn DOCID = new GridViewTextBoxColumn();
DOCID.Name = "DOCID";
DOCID.FieldName = "DOCID";
DOCID.HeaderText = "เลขที่เอกสาร";
DOCID.IsVisible = true;
DOCID.ReadOnly = true;
DOCID.BestFit();
rgv_ApproveHD.Columns.Add(DOCID);
GridViewTextBoxColumn DOCSTAT = new GridViewTextBoxColumn();
DOCSTAT.Name = "DOCSTAT";
DOCSTAT.FieldName = "DOCSTAT";
DOCSTAT.HeaderText = "สถานะเอกสาร";
DOCSTAT.IsVisible = true;
DOCSTAT.ReadOnly = true;
DOCSTAT.BestFit();
rgv_ApproveHD.Columns.Add(DOCSTAT);
GridViewTextBoxColumn TRANSDATE = new GridViewTextBoxColumn();
TRANSDATE.Name = "TRANSDATE";
TRANSDATE.FieldName = "TRANSDATE";
TRANSDATE.HeaderText = "วันที่สร้าง";
TRANSDATE.IsVisible = true;
TRANSDATE.ReadOnly = true;
TRANSDATE.BestFit();
rgv_ApproveHD.Columns.Add(TRANSDATE);
GridViewTextBoxColumn CREATEDNAME = new GridViewTextBoxColumn();
CREATEDNAME.Name = "CREATEDNAME";
CREATEDNAME.FieldName = "CREATEDNAME";
CREATEDNAME.HeaderText = "ผู้สร้าง";
CREATEDNAME.IsVisible = true;
CREATEDNAME.ReadOnly = true;
CREATEDNAME.BestFit();
rgv_ApproveHD.Columns.Add(CREATEDNAME);
GridViewTextBoxColumn MODIFIEDDATE = new GridViewTextBoxColumn();
MODIFIEDDATE.Name = "MODIFIEDDATE";
MODIFIEDDATE.FieldName = "MODIFIEDDATE";
MODIFIEDDATE.HeaderText = "แก้ไขล่าสุด";
MODIFIEDDATE.IsVisible = true;
MODIFIEDDATE.ReadOnly = true;
MODIFIEDDATE.BestFit();
rgv_ApproveHD.Columns.Add(MODIFIEDDATE);
GridViewTextBoxColumn EMPLNAME = new GridViewTextBoxColumn();
EMPLNAME.Name = "EMPLNAME";
EMPLNAME.FieldName = "EMPLNAME";
EMPLNAME.HeaderText = "ชื่อ";
EMPLNAME.IsVisible = true;
EMPLNAME.ReadOnly = true;
EMPLNAME.BestFit();
rgv_ApproveHD.Columns.Add(EMPLNAME);
GridViewTextBoxColumn HEADAPPROVED = new GridViewTextBoxColumn();
HEADAPPROVED.Name = "HEADAPPROVED";
HEADAPPROVED.FieldName = "HEADAPPROVED";
HEADAPPROVED.HeaderText = "หน./ผช.";
HEADAPPROVED.IsVisible = true;
HEADAPPROVED.ReadOnly = true;
HEADAPPROVED.BestFit();
rgv_ApproveHD.Columns.Add(HEADAPPROVED);
GridViewTextBoxColumn HEADAPPROVEDBYNAME = new GridViewTextBoxColumn();
HEADAPPROVEDBYNAME.Name = "HEADAPPROVEDBYNAME";
HEADAPPROVEDBYNAME.FieldName = "HEADAPPROVEDBYNAME";
HEADAPPROVEDBYNAME.HeaderText = "ผู้อนุมัติ";
HEADAPPROVEDBYNAME.IsVisible = true;
HEADAPPROVEDBYNAME.ReadOnly = true;
HEADAPPROVEDBYNAME.BestFit();
rgv_ApproveHD.Columns.Add(HEADAPPROVEDBYNAME);
GridViewTextBoxColumn HRAPPROVED = new GridViewTextBoxColumn();
HRAPPROVED.Name = "HRAPPROVED";
HRAPPROVED.FieldName = "HRAPPROVED";
HRAPPROVED.HeaderText = "บุคคล";
HRAPPROVED.IsVisible = true;
HRAPPROVED.ReadOnly = true;
HRAPPROVED.BestFit();
rgv_ApproveHD.Columns.Add(HRAPPROVED);
GridViewTextBoxColumn HRAPPROVEDBYNAME = new GridViewTextBoxColumn();
HRAPPROVEDBYNAME.Name = "HRAPPROVEDBYNAME";
HRAPPROVEDBYNAME.FieldName = "HRAPPROVEDBYNAME";
HRAPPROVEDBYNAME.HeaderText = "ผู้อนุมัติ";
HRAPPROVEDBYNAME.IsVisible = true;
HRAPPROVEDBYNAME.ReadOnly = true;
HRAPPROVEDBYNAME.BestFit();
rgv_ApproveHD.Columns.Add(HRAPPROVEDBYNAME);
GridViewCommandColumn ApproveButton = new GridViewCommandColumn();
ApproveButton.Name = "ApproveButton";
ApproveButton.FieldName = "ApproveButton";
ApproveButton.HeaderText = "อนุมัติ";
rgv_ApproveHD.Columns.Add(ApproveButton);
#endregion
this.btn_Search.Click += new EventHandler(btn_Search_Click);
}
void InitializeGridView()
{
this.rgv_GetData.Dock = DockStyle.Fill;
this.rgv_GetData.ReadOnly = true;
this.rgv_GetData.AutoGenerateColumns = true;
this.rgv_GetData.EnableFiltering = false;
this.rgv_GetData.AllowAddNewRow = false;
this.rgv_GetData.MasterTemplate.AutoGenerateColumns = false;
this.rgv_GetData.ShowGroupedColumns = true;
this.rgv_GetData.MasterTemplate.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
this.rgv_GetData.EnableHotTracking = true;
this.rgv_GetData.AutoSizeRows = true;
GridViewTextBoxColumn DOCID = new GridViewTextBoxColumn();
DOCID.Name = "DOCID";
DOCID.FieldName = "DOCID";
DOCID.HeaderText = "เลขที่เอกสาร";
DOCID.IsVisible = true;
DOCID.ReadOnly = true;
DOCID.BestFit();
rgv_GetData.Columns.Add(DOCID);
GridViewTextBoxColumn EMPLID = new GridViewTextBoxColumn();
EMPLID.Name = "EMPLID";
EMPLID.FieldName = "EMPLID";
EMPLID.HeaderText = "รหัส";
EMPLID.IsVisible = true;
EMPLID.ReadOnly = true;
EMPLID.BestFit();
rgv_GetData.Columns.Add(EMPLID);
GridViewTextBoxColumn EMPLNAME = new GridViewTextBoxColumn();
EMPLNAME.Name = "EMPLNAME";
EMPLNAME.FieldName = "EMPLNAME";
EMPLNAME.HeaderText = "ชื่อ";
EMPLNAME.IsVisible = true;
EMPLNAME.ReadOnly = true;
EMPLNAME.BestFit();
rgv_GetData.Columns.Add(EMPLNAME);
GridViewTextBoxColumn SECTIONNAME = new GridViewTextBoxColumn();
SECTIONNAME.Name = "SECTIONNAME";
SECTIONNAME.FieldName = "SECTIONNAME";
SECTIONNAME.HeaderText = "แผนก";
SECTIONNAME.IsVisible = true;
SECTIONNAME.ReadOnly = true;
SECTIONNAME.BestFit();
rgv_GetData.Columns.Add(SECTIONNAME);
GridViewTextBoxColumn CREATEDNAME = new GridViewTextBoxColumn();
CREATEDNAME.Name = "CREATEDNAME";
CREATEDNAME.FieldName = "CREATEDNAME";
CREATEDNAME.HeaderText = "ผู้บันทึก";
CREATEDNAME.IsVisible = true;
CREATEDNAME.ReadOnly = true;
CREATEDNAME.BestFit();
rgv_GetData.Columns.Add(CREATEDNAME);
GridViewTextBoxColumn TRANSDATE = new GridViewTextBoxColumn();
TRANSDATE.Name = "TRANSDATE";
TRANSDATE.FieldName = "TRANSDATE";
TRANSDATE.HeaderText = "วันที่บันทึก";
TRANSDATE.IsVisible = true;
TRANSDATE.ReadOnly = true;
TRANSDATE.BestFit();
rgv_GetData.Columns.Add(TRANSDATE);
//GridViewTextBoxColumn BROKERS = new GridViewTextBoxColumn();
//BROKERS.Name = "BROKERS";
//BROKERS.FieldName = "BROKERS";
//BROKERS.HeaderText = "โบรกเกอร์";
//BROKERS.IsVisible = true;
//BROKERS.ReadOnly = true;
//BROKERS.BestFit();
//rgv_GetData.Columns.Add(BROKERS);
//GridViewTextBoxColumn CENTER = new GridViewTextBoxColumn();
//CENTER.Name = "CENTER";
//CENTER.FieldName = "CENTER";
//CENTER.HeaderText = "ศูนย์พูลผล";
//CENTER.IsVisible = true;
//CENTER.ReadOnly = true;
//CENTER.BestFit();
//rgv_GetData.Columns.Add(CENTER);
//GridViewTextBoxColumn MIMIGRATION = new GridViewTextBoxColumn();
//MIMIGRATION.Name = "MIMIGRATION";
//MIMIGRATION.FieldName = "MIMIGRATION";
//BROKERS.HeaderText = "ตม.";
//MIMIGRATION.IsVisible = true;
//MIMIGRATION.ReadOnly = true;
//MIMIGRATION.BestFit();
//rgv_GetData.Columns.Add(MIMIGRATION);
//GridViewTextBoxColumn HOSPITAL = new GridViewTextBoxColumn();
//HOSPITAL.Name = "HOSPITAL";
//HOSPITAL.FieldName = "HOSPITAL";
//HOSPITAL.HeaderText = "รพ.";
//HOSPITAL.IsVisible = true;
//HOSPITAL.ReadOnly = true;
//HOSPITAL.BestFit();
//rgv_GetData.Columns.Add(HOSPITAL);
//GridViewTextBoxColumn DISTRICT = new GridViewTextBoxColumn();
//DISTRICT.Name = "DISTRICT";
//DISTRICT.FieldName = "DISTRICT";
//DISTRICT.HeaderText = "อำเภอ";
//DISTRICT.IsVisible = true;
//DISTRICT.ReadOnly = true;
//DISTRICT.BestFit();
//rgv_GetData.Columns.Add(DISTRICT);
//GridViewTextBoxColumn SUMPAY = new GridViewTextBoxColumn();
//SUMPAY.Name = "SUMPAY";
//SUMPAY.FieldName = "SUMPAY";
//SUMPAY.HeaderText = "รวม";
//SUMPAY.IsVisible = true;
//SUMPAY.ReadOnly = true;
//SUMPAY.BestFit();
//rgv_GetData.Columns.Add(SUMPAY);
//GridViewTextBoxColumn SUPC = new GridViewTextBoxColumn();
//SUPC.Name = "SUPC";
//SUPC.FieldName = "SUPC";
//SUPC.HeaderText = "SUPC";
//SUPC.IsVisible = true;
//SUPC.ReadOnly = true;
//SUPC.BestFit();
//rgv_GetData.Columns.Add(SUPC);
//GridViewTextBoxColumn TOTAL = new GridViewTextBoxColumn();
//TOTAL.Name = "TOTAL";
//TOTAL.FieldName = "TOTAL";
//TOTAL.HeaderText = "ยอดเรียกเก็บ";
//TOTAL.IsVisible = true;
//TOTAL.ReadOnly = true;
//TOTAL.BestFit();
//rgv_GetData.Columns.Add(TOTAL);
GridViewCommandColumn DeleteButton = new GridViewCommandColumn();
DeleteButton.Name = "DeleteButton";
DeleteButton.FieldName = "DeleteButton";
DeleteButton.HeaderText = "ยกเลิก";
rgv_GetData.Columns.Add(DeleteButton);
//GridViewSummaryRowItem summary = new GridViewSummaryRowItem();
//summary.Add(new GridViewSummaryItem("JOBS", "{0:N2}", GridAggregateFunction.Sum));
//summary.Add(new GridViewSummaryItem("BROKERS", "{0:N2}", GridAggregateFunction.Sum));
//summary.Add(new GridViewSummaryItem("CENTER", "{0:N2}", GridAggregateFunction.Sum));
//summary.Add(new GridViewSummaryItem("MIMIGRATION", "{0:N2}", GridAggregateFunction.Sum));
//summary.Add(new GridViewSummaryItem("HOSPITAL", "{0:N2}", GridAggregateFunction.Sum));
//summary.Add(new GridViewSummaryItem("DISTRICT", "{0:N2}", GridAggregateFunction.Sum));
//summary.Add(new GridViewSummaryItem("SUMPAY", "{0:N2}", GridAggregateFunction.Sum));
//summary.Add(new GridViewSummaryItem("SUPC", "{0:N2}", GridAggregateFunction.Sum));
//summary.Add(new GridViewSummaryItem("TOTAL", "{0:N2}", GridAggregateFunction.Sum));
//this.rgv_GetData.MasterTemplate.SummaryRowsBottom.Add(summary);
}
public FormAddEmpl()
{
InitializeComponent();
this.btn_save.Click += new EventHandler(btn_save_Click);
#region GridVied
this.GridViewShowData.Dock = DockStyle.Fill;
this.GridViewShowData.ReadOnly = true;
this.GridViewShowData.AutoGenerateColumns = true;
this.GridViewShowData.EnableFiltering = false;
this.GridViewShowData.AllowAddNewRow = false;
this.GridViewShowData.MasterTemplate.AutoGenerateColumns = false;
this.GridViewShowData.ShowGroupedColumns = true;
this.GridViewShowData.MasterTemplate.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
this.GridViewShowData.EnableHotTracking = true;
this.GridViewShowData.AutoSizeRows = true;
GridViewTextBoxColumn PWCARD = new GridViewTextBoxColumn();
PWCARD.Name = "PWCARD";
PWCARD.FieldName = "PWCARD";
PWCARD.HeaderText = "รหัสบัตร";
PWCARD.IsVisible = false;
PWCARD.ReadOnly = true;
PWCARD.BestFit();
GridViewShowData.Columns.Add(PWCARD);
GridViewTextBoxColumn PWEMPLOYEE = new GridViewTextBoxColumn();
PWEMPLOYEE.Name = "PWEMPLOYEE";
PWEMPLOYEE.FieldName = "PWEMPLOYEE";
PWEMPLOYEE.HeaderText = "รหัสพนักงาน";
PWEMPLOYEE.IsVisible = true;
PWEMPLOYEE.ReadOnly = true;
PWEMPLOYEE.BestFit();
GridViewShowData.Columns.Add(PWEMPLOYEE);
GridViewTextBoxColumn EmplFullName = new GridViewTextBoxColumn();
EmplFullName.Name = "EmplFullName";
EmplFullName.FieldName = "EmplFullName";
EmplFullName.HeaderText = "ชื่อ-สกุล";
EmplFullName.IsVisible = true;
EmplFullName.ReadOnly = true;
EmplFullName.BestFit();
GridViewShowData.Columns.Add(EmplFullName);
GridViewTextBoxColumn PWBIRTHDAY = new GridViewTextBoxColumn();
PWBIRTHDAY.Name = "PWBIRTHDAY";
PWBIRTHDAY.FieldName = "PWBIRTHDAY";
PWBIRTHDAY.HeaderText = "วันเกิด";
PWBIRTHDAY.IsVisible = false;
PWBIRTHDAY.ReadOnly = true;
PWBIRTHDAY.BestFit();
GridViewShowData.Columns.Add(PWBIRTHDAY);
GridViewTextBoxColumn SECTIONID = new GridViewTextBoxColumn();
SECTIONID.Name = "SECTIONID";
SECTIONID.FieldName = "SECTIONID";
SECTIONID.HeaderText = "รหัสแผนก";
SECTIONID.IsVisible = false;
SECTIONID.ReadOnly = true;
SECTIONID.BestFit();
GridViewShowData.Columns.Add(SECTIONID);
GridViewTextBoxColumn SECTION = new GridViewTextBoxColumn();
SECTION.Name = "SECTION";
SECTION.FieldName = "SECTION";
SECTION.HeaderText = "ชื่อแผนก";
SECTION.IsVisible = true;
SECTION.ReadOnly = true;
SECTION.BestFit();
GridViewShowData.Columns.Add(SECTION);
GridViewTextBoxColumn DEPTID = new GridViewTextBoxColumn();
DEPTID.Name = "DEPTID";
DEPTID.FieldName = "DEPTID";
DEPTID.HeaderText = "รหัสตำแหน่ง";
DEPTID.IsVisible = false;
DEPTID.ReadOnly = true;
DEPTID.BestFit();
GridViewShowData.Columns.Add(DEPTID);
GridViewTextBoxColumn DEPT = new GridViewTextBoxColumn();
DEPT.Name = "DEPT";
DEPT.FieldName = "DEPT";
DEPT.HeaderText = "ตำแหน่ง";
DEPT.IsVisible = true;
DEPT.ReadOnly = true;
DEPT.BestFit();
GridViewShowData.Columns.Add(DEPT);
GridViewTextBoxColumn POSITIONID = new GridViewTextBoxColumn();
POSITIONID.Name = "POSITIONID";
POSITIONID.FieldName = "POSITIONID";
POSITIONID.HeaderText = "รหัส";
POSITIONID.IsVisible = false;
POSITIONID.ReadOnly = true;
POSITIONID.BestFit();
GridViewShowData.Columns.Add(POSITIONID);
GridViewTextBoxColumn POSITION = new GridViewTextBoxColumn();
POSITION.Name = "POSITION";
POSITION.FieldName = "POSITION";
POSITION.HeaderText = "ชื่อตำแหน่ง";
POSITION.IsVisible = false;
POSITION.ReadOnly = true;
POSITION.BestFit();
GridViewShowData.Columns.Add(POSITION);
#endregion
}
