private void FormatDataGrid()
{
try
{
RadGridLocalizationProvider.CurrentProvider = new MySpanishRadGridLocalizationProvider();
grdItems.Columns.Clear();
grdItems.AllowAddNewRow = false;
GridViewCommandColumn commandColumn;
commandColumn = new GridViewCommandColumn();
commandColumn.Name = "Edit";
commandColumn.HeaderText = @"Editar";
commandColumn.DefaultText = @"Editar";
commandColumn.UseDefaultText = true;
grdItems.Columns.Add(commandColumn);
grdItems.Columns["Edit"].AllowSort = false;
grdItems.Columns["Edit"].AllowFiltering = false;
commandColumn = new GridViewCommandColumn();
commandColumn.Name = "Delete";
commandColumn.HeaderText = @"Eliminar";
commandColumn.DefaultText = @"Eliminar";
commandColumn.UseDefaultText = true;
grdItems.Columns.Add(commandColumn);
grdItems.Columns["Delete"].AllowSort = false;
grdItems.Columns["Delete"].AllowFiltering = false;
grdItems.Columns.Add("TIPO_Banco", "Banco", "TIPO_Banco");
grdItems.Columns.Add("TIPO_Moneda", "Moneda", "TIPO_Moneda");
grdItems.Columns.Add("CACU_NroCuenta", "Cuenta", "CACU_NroCuenta");
grdItems.BestFitColumns();
tsmColumnas.DropDownItems.Clear();
defaultColumns = new string[grdItems.Columns.Count];
int index = 0;
foreach (GridViewDataColumn column in grdItems.Columns)
{
ToolStripMenuItem _item = new ToolStripMenuItem(column.HeaderText);
_item.Tag = column.Name;
_item.Checked = column.IsVisible;
_item.CheckOnClick = true;
_item.Click += tsmColumna_Click;
tsmColumnas.DropDownItems.Add(_item);
if (column.IsVisible)
{
defaultColumns[index] = column.Name; index += 1;
}
}
ToolStripSeparator tsmSeparacion = new ToolStripSeparator();
tsmColumnas.DropDownItems.Add(tsmSeparacion);
tsmTodos = new ToolStripMenuItem("Todos");
tsmTodos.Tag = "Todas";
tsmTodos.Checked = false;
tsmTodos.CheckOnClick = true;
tsmTodos.Click += tsmTodos_Click;
tsmColumnas.DropDownItems.Add(tsmTodos);
GridAutoFit.Fit(grdItems);
}
catch (Exception ex)
{ Dialogos.MostrarMensajeError(Presenter.Title, Mensajes.FormatDataGridView, ex); }
}
public void LoadGridFio(object sender, DoWorkEventArgs e)
{
var commandServer = new CommandServer();
try
{
radGridView5.Invoke(new MethodInvoker(delegate()
{
radGridView5.EnablePaging = true;
_bindingSource_personel = new BindingSource {
DataSource = commandServer.DataGridSet(@"select *
from spezialistView(0,0)
order by [ФИО]").Tables[0]
};
radGridView5.DataSource = _bindingSource_personel;
radGridView5.Columns[0].IsVisible = false;
GridViewCommandColumn command = new GridViewCommandColumn();
command.Name = "commandDelYes";
command.UseDefaultText = true;
command.DefaultText = "Удалить";
command.FieldName = "delete";
command.HeaderText = "Операция";
radGridView5.MasterTemplate.Columns.Add(command);
radGridView5.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
radGridView5.CommandCellClick += new CommandCellClickEventHandler(radGridViewButton_Click);
}));
}
catch (Exception ex)
{
CommandClient commandClient = new CommandClient();
commandClient.WriteFileError(ex, null);
}
}
private void LoadGridOff(object sender, DoWorkEventArgs e)
{
try
{
radGridView3.Invoke(new MethodInvoker(delegate()
{
radGridView3.EnablePaging = true;
_bindingSource_soc_off = new BindingSource {
DataSource = new CommandServer().DataGridSet(@"select *
from spezialistView(2,1)
order by [ФИО]").Tables[0]
};
radGridView3.DataSource = _bindingSource_soc_off;
radGridView3.Columns[0].IsVisible = false;
GridViewCommandColumn command = new GridViewCommandColumn();
command.Name = "commandDelNo";
command.UseDefaultText = true;
command.DefaultText = "Восстановить";
command.FieldName = "restore";
command.HeaderText = "Операция";
radGridView3.MasterTemplate.Columns.Add(command);
radGridView3.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
radGridView3.CommandCellClick += new CommandCellClickEventHandler(radGridViewButton_Click);
}));
}
catch (Exception ex)
{
CommandClient commandClient = new CommandClient();
commandClient.WriteFileError(ex, null);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (!SessionBox.CheckUserSession())
{
Response.Redirect("~/Login.aspx");
}
else
{
//初始化模块权限
UserHandle.InitModule(this.PageTag);
//是否有浏览权限
if (UserHandle.ValidationHandle(PermissionTag.Browse))
{
GridViewCommandColumn colEdit = (GridViewCommandColumn)ASPxGridView2.Columns["操作"];
if (!UserHandle.ValidationHandle(PermissionTag.Add))
{
colEdit.NewButton.Visible = false;
}
if (!UserHandle.ValidationHandle(PermissionTag.Edit))
{
colEdit.EditButton.Visible = false;
}
if (!UserHandle.ValidationHandle(PermissionTag.Delete))
{
colEdit.DeleteButton.Visible = false;
}
}
}
}
bindFXLX();
}
private void CreateGrid()
{
ASPxGridView grid = new ASPxGridView();
grid.ID = "grid";
this.Form.Controls.Add(grid);
grid.EnableCallBacks = false;
grid.KeyFieldName = "Id";
grid.DataBinding += grid_DataBinding;
grid.RowDeleting += grid_RowDeleting;
grid.RowUpdating += grid_RowUpdating;
grid.RowInserting += grid_RowInserting;
grid.DataBound += grid_DataBound;
grid.RowValidating += new ASPxDataValidationEventHandler(grid_RowValidating);
grid.DataBind();
if (!this.IsPostBack)
{
GridViewCommandColumn c = new GridViewCommandColumn();
grid.Columns.Add(c);
c.ShowEditButton = true;
c.ShowUpdateButton = true;
c.ShowNewButtonInHeader = true;
}
GridViewDataTextColumn col = grid.Columns["Id"] as GridViewDataTextColumn;
col.PropertiesTextEdit.ValidationSettings.RegularExpression.ValidationExpression = "\\d{1,9}";
}
protected override System.Web.UI.WebControls.WebControl CreateEditModeControlCore()
{
ASPxGridLookup lookupEdit = new ASPxGridLookup();
lookupEdit.ID = PropertyName + "_CheckedComboBox";
lookupEdit.Width = Unit.Percentage(100);
lookupEdit.SelectionMode = GridLookupSelectionMode.Multiple;
lookupEdit.TextChanged += EditValueChangedHandler;
lookupEdit.KeyFieldName = LookupValueColumnName;
lookupEdit.MultiTextSeparator = ", ";
lookupEdit.AllowUserInput = false;
// Set the drop-down editor width.
lookupEdit.GridView.Width = 500;
// OR
//string setSizeScript = "function(s, e){s.GetGridView().SetWidth(s.GetWidth()); }";
//lookupEdit.ClientSideEvents.Init = lookupEdit.ClientSideEvents.DropDown = setSizeScript;
lookupEdit.GridViewProperties.Settings.ShowColumnHeaders = false;
lookupEdit.GridViewProperties.Settings.GridLines = GridLines.None;
lookupEdit.GridViewStyles.SelectedRow.BackColor = System.Drawing.ColorTranslator.FromHtml("#00fbfbfb");
lookupEdit.GridViewStyles.FocusedRow.BackColor = System.Drawing.ColorTranslator.FromHtml("#00fbfbfb");
GridViewCommandColumn selectionColumn = new GridViewCommandColumn();
selectionColumn.ShowSelectCheckbox = true;
lookupEdit.Columns.Add(selectionColumn);
GridViewDataColumn valueColumn = new GridViewDataColumn(LookupValueColumnName);
lookupEdit.Columns.Add(valueColumn);
lookupEdit.DataSource = GetLookupData();
return(lookupEdit);
}
public override void InitGridLookup(ASPxGridLookup gridlookup)
{
gridlookup.KeyFieldName = "BillId";
gridlookup.TextFormatString = "{0}";
gridlookup.Columns.Clear();
GridViewColumn selectionColumn = new GridViewCommandColumn()
{
ShowSelectCheckbox = true,
VisibleIndex = 0
};
GridViewColumn codeColumn = new GridViewDataTextColumn()
{
ShowInCustomizationForm = true,
FieldName = "Code",
Caption = "Số phiếu bán",
VisibleIndex = 1
};
GridViewColumn nameColumn = new GridViewDataTextColumn()
{
ShowInCustomizationForm = true,
FieldName = "IssuedDate",
Caption = "Ngày",
VisibleIndex = 2
};
gridlookup.Columns.Add(selectionColumn);
gridlookup.Columns.Add(codeColumn);
gridlookup.Columns.Add(nameColumn);
}
private void FormatDataGrid()
{
try
{
RadGridLocalizationProvider.CurrentProvider = new MySpanishRadGridLocalizationProvider();
grdItems.Columns.Clear();
grdItems.AllowAddNewRow = false;
GridViewCommandColumn commandColumn;
commandColumn = new GridViewCommandColumn();
commandColumn.Name = "Imprimir";
commandColumn.HeaderText = @"Imprimir";
commandColumn.DefaultText = @"Imprimir";
commandColumn.UseDefaultText = true;
grdItems.Columns.Add(commandColumn);
grdItems.Columns["Imprimir"].AllowSort = false;
grdItems.Columns["Imprimir"].AllowFiltering = false;
grdItems.Columns.Add("COPE_NumDoc", "Número Operación", "COPE_NumDoc");
grdItems.Columns.Add("COPE_FecEmi", "Fecha Emisión", "COPE_FecEmi");
grdItems.Columns.Add("Cliente", "Cliente", "Cliente");
grdItems.Columns.Add("COPE_HBL", "HBL", "COPE_HBL");
grdItems.Columns.Add("MonedaSTR", "Moneda", "MonedaSTR");
grdItems.Columns.Add("CONS_CodEstadoSTR", "Estado", "CONS_CodEstadoSTR");
grdItems.Columns.Add("COPE_Observacion", "Observacación", "COPE_Observacion");
grdItems.BestFitColumns();
GridAutoFit.Fit(grdItems);
}
catch (Exception ex)
{ Dialogos.MostrarMensajeError(Presenter.Titulo, Mensajes.FormatDataGridView, ex); }
}
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);
}
protected void gridLabEditing_DataBound(object sender, EventArgs e)
{
ASPxGridView grid = sender as ASPxGridView;
bool hasCol = (grid.Columns.IndexOf(grid.Columns["CommandColumnGroups"]) != -1) ? true : false;
if (hasCol)
{
grid.Columns.Remove(grid.Columns["CommandColumnGroups"]);
}
GridViewCommandColumn col = new GridViewCommandColumn();
col.Name = "CommandColumnGroups";
col.CellStyle.HorizontalAlign = HorizontalAlign.Left;
for (int i = 0; i < 8; i++)
{
GridViewCommandColumnCustomButton but = new GridViewCommandColumnCustomButton();
but.ID = String.Format("grp{0}", i);
but.Text = String.Format("grp{0}", i);
but.Styles.Native = true;
col.CustomButtons.Add(but);
}
grid.Columns.Add(col);
}
protected void grid_DataBound(object sender, EventArgs e)
{
//Check to see if these have been added
bool hasCol = (grid.Columns.IndexOf(grid.Columns["CommandColumnGroups"]) != -1) ? true : false;
if (hasCol)
{
grid.Columns.Remove(grid.Columns["CommandColumnGroups"]);
}
GridViewCommandColumn col = new GridViewCommandColumn();
col.Name = "CommandColumnGroups";
GridViewCommandColumnCustomButton but = new GridViewCommandColumnCustomButton();
but.ID = "btnImportFlds";
but.Text = "Import flds from NDAR";
but.Styles.Native = true;
but.Styles.Style.Font.Size = 10;
col.CustomButtons.Add(but);
grid.Columns.Add(col);
col.Index = 0;
}
protected void Page_PreRenderComplete(object sender, EventArgs e)
{
if (!IsPostBack)
{
cboModuleGroup.Items.Insert(0, new DevExpress.Web.ASPxEditors.ListEditItem("--全部--", -1));
cboModuleGroup.SelectedIndex = 0;
if (!SessionBox.CheckUserSession())
{
Response.Redirect("~/Login.aspx");
}
else
{
//初始化模块权限
UserHandle.InitModule(this.PageTag);
//是否有浏览权限
if (UserHandle.ValidationHandle(PermissionTag.Browse))
{
GridViewCommandColumn colDel = (GridViewCommandColumn)ASPxGridView1.Columns["删除"];
GridViewDataHyperLinkColumn colEdit = (GridViewDataHyperLinkColumn)ASPxGridView1.Columns["编辑"];
if (!UserHandle.ValidationHandle(PermissionTag.Add))
{
btnAddModule.Visible = false;
}
if (!UserHandle.ValidationHandle(PermissionTag.Edit))
{
colEdit.Visible = false;
}
if (!UserHandle.ValidationHandle(PermissionTag.Delete))
{
colDel.Visible = false;
}
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (!SessionBox.CheckUserSession())
{
Response.Redirect("~/Login.aspx");
}
else
{
//初始化模块权限
UserHandle.InitModule(this.PageTag);
//是否有浏览权限
if (UserHandle.ValidationHandle(PermissionTag.Browse))
{
GridViewCommandColumn colEdit = (GridViewCommandColumn)gridRole.Columns["编辑"];
if (!UserHandle.ValidationHandle(PermissionTag.Add))
{
colEdit.NewButton.Visible = false;
}
if (!UserHandle.ValidationHandle(PermissionTag.Edit))
{
colEdit.EditButton.Visible = false;
}
if (!UserHandle.ValidationHandle(PermissionTag.Delete))
{
colEdit.DeleteButton.Visible = false;
}
SF_Role r = rbll.GetRoleModel(decimal.Parse(SessionBox.GetUserSession().CurrentRole[0].ToString().Split(',')[0]));
rolelevel = r.LevelID;
maindeptid = SessionBox.GetUserSession().DeptNumber;
switch ((int)rolelevel)
{
case 0:
Session["WhereRole"] = " ";
break;
case 1:
Session["WhereRole"] = string.Format("levelid >={0}", rolelevel);
break;
case 2:
Session["WhereRole"] = string.Format("MAINDEPTID='{0}'", maindeptid);
gridRole.Columns["创建单位"].Visible = false;
break;
default:
Session["WhereRole"] = string.Format("MAINDEPTID='{0}'", maindeptid);
gridRole.Columns["创建单位"].Visible = false;
break;
}
BindRole();
}
}
}
//if(rolelevel > 1)
//{
// Session["WhereRole"] = string.Format("MAINDEPTID='{0}'",maindeptid);
//}
}
public override void InitGridLookup(ASPxGridLookup gridlookup)
{
gridlookup.KeyFieldName = "OrganizationId";
gridlookup.TextFormatString = "{0} - {1}";
gridlookup.Columns.Clear();
GridViewColumn selectionColumn = new GridViewCommandColumn()
{
ShowSelectCheckbox = true,
VisibleIndex = 0
};
GridViewColumn codeColumn = new GridViewDataTextColumn()
{
ShowInCustomizationForm = true,
FieldName = "Code",
Caption = "Mã khách hàng",
VisibleIndex = 1
};
GridViewColumn nameColumn = new GridViewDataTextColumn()
{
ShowInCustomizationForm = true,
FieldName = "Name",
Caption = "Tên khách hàng",
VisibleIndex = 2
};
gridlookup.Columns.Add(selectionColumn);
gridlookup.Columns.Add(codeColumn);
gridlookup.Columns.Add(nameColumn);
}
private void GetDadosHoras()
{
List <object> valor = new List <object>();
try
{
valor = gridUsuario.GetSelectedFieldValues("Codigo");
valor[0].ToString();
}
catch
{
string strValor = detCodigo.InnerText.ToString();
valor.Add(strValor);
}
gridHoras.DataSource = hdo.GetLista(valor[0].ToString());
gridHoras.DataBind();
if (gridHoras.Columns.IndexOf(gridHoras.Columns["IDUsuario"]) == -1)
{
GridViewCommandColumn col = new GridViewCommandColumn();
col.ShowSelectCheckbox = true;
col.Name = "IDUsuario";
col.Index = 1;
gridHoras.Columns.Add(col);
}
}
//protected void Page_PreInit(object sender, EventArgs e)
//{
// Page.Theme = "Metropolis";
//}
public void SetearBotones(ASPxGridView grilla, bool agregar, bool editar, bool eliminar, bool actualizar, bool cancelar)
{
GridViewCommandColumn columna = new GridViewCommandColumn();
if (agregar)
{
columna.ShowNewButtonInHeader = true;
grilla.SettingsCommandButton.NewButton.Text = "<i class=\"ion-plus-round\"></i>";
}
if (editar)
{
columna.ShowEditButton = true;
grilla.SettingsCommandButton.EditButton.Text = "<i class=\"ion-edit\"></i>";
}
if (eliminar)
{
columna.ShowDeleteButton = true;
grilla.SettingsCommandButton.DeleteButton.Text = "<i style=\"margin-left: 15px\" class=\"ion-minus-round\"></i>";
}
if (actualizar)
{
grilla.SettingsCommandButton.UpdateButton.Text = "<i class=\"ion-checkmark-round\"></i>";
}
if (cancelar)
{
grilla.SettingsCommandButton.CancelButton.Text = "<i class=\"ion-close-round\"></i>";
}
grilla.Columns.Add(columna);
}
private void CreateDetailColumns(ASPxGridView detailGrid)
{
GridViewCommandColumn colCmd = new GridViewCommandColumn();
colCmd.ShowEditButton = true;
colCmd.ShowNewButton = true;
colCmd.ShowDeleteButton = true;
detailGrid.Columns.Add(colCmd);
GridViewDataColumn colProductID = new GridViewDataColumn();
colProductID.FieldName = "ProductID";
colProductID.EditFormSettings.Visible = DevExpress.Utils.DefaultBoolean.False;
detailGrid.Columns.Add(colProductID);
detailGrid.Columns.Add(new GridViewDataColumn("ProductName"));
GridViewDataTextColumn colCategoryID = new GridViewDataTextColumn();
colCategoryID.FieldName = "CategoryID";
colCategoryID.EditFormSettings.Visible = DevExpress.Utils.DefaultBoolean.False;
detailGrid.Columns.Add(colCategoryID);
detailGrid.Columns.Add(new GridViewDataColumn("UnitPrice"));
GridViewDataCheckColumn colDiscontinued = new GridViewDataCheckColumn();
colDiscontinued.FieldName = "Discontinued";
detailGrid.Columns.Add(colDiscontinued);
}
public CommandColumnInfo(GridViewCommandColumn column)
: base(column)
{
ShowEditButton = column.ShowEditButton;
ShowNewButton = column.ShowSelectButton;
ShowDeleteButton = column.ShowDeleteButton;
ShowSelectCheckbox = column.ShowSelectCheckbox;
}
private void FormatGridGastosBancarios()
{
try
{
Telerik.WinControls.UI.Localization.RadGridLocalizationProvider.CurrentProvider = new Infrastructure.WinForms.Controls.MySpanishRadGridLocalizationProvider();
this.grdItemsGastosBancarios.Columns.Clear();
this.grdItemsGastosBancarios.AllowAddNewRow = false;
GridViewCommandColumn commandColumn = new GridViewCommandColumn();
commandColumn.Name = "Edit";
commandColumn.HeaderText = "Editar";
commandColumn.DefaultText = "Editar";
commandColumn.UseDefaultText = true;
this.grdItemsGastosBancarios.Columns.Add(commandColumn);
this.grdItemsGastosBancarios.Columns["Edit"].AllowSort = false;
this.grdItemsGastosBancarios.Columns["Edit"].AllowFiltering = false;
commandColumn = new GridViewCommandColumn();
commandColumn.Name = "Delete";
commandColumn.HeaderText = "Eliminar";
commandColumn.DefaultText = "Eliminar";
commandColumn.UseDefaultText = true;
this.grdItemsGastosBancarios.Columns.Add(commandColumn);
this.grdItemsGastosBancarios.Columns["Delete"].AllowSort = false;
this.grdItemsGastosBancarios.Columns["Delete"].AllowFiltering = false;
this.grdItemsGastosBancarios.Columns.Add("GBAN_Codigo", "Código", "GBAN_Codigo");
this.grdItemsGastosBancarios.Columns.Add("TIPO_MND", "Moneda", "TIPO_MND");
this.grdItemsGastosBancarios.Columns.Add("GBAN_MontoDebe", "Debe", "GBAN_MontoDebe");
this.grdItemsGastosBancarios.Columns["GBAN_MontoDebe"].FormatString = "{0:#,###,##0.00}";
this.grdItemsGastosBancarios.Columns["GBAN_MontoDebe"].TextAlignment = ContentAlignment.MiddleRight;
this.grdItemsGastosBancarios.Columns.Add("GBAN_MontoHaber", "Haber", "GBAN_MontoHaber");
this.grdItemsGastosBancarios.Columns["GBAN_MontoHaber"].FormatString = "{0:#,###,##0.00}";
this.grdItemsGastosBancarios.Columns["GBAN_MontoHaber"].TextAlignment = ContentAlignment.MiddleRight;
this.grdItemsGastosBancarios.Columns.Add("GBAN_TipoCambio", "Tipo Cambio", "GBAN_TipoCambio");
this.grdItemsGastosBancarios.Columns["GBAN_TipoCambio"].FormatString = "{0:#,###,##0.00}";
this.grdItemsGastosBancarios.Columns["GBAN_TipoCambio"].TextAlignment = ContentAlignment.MiddleRight;
//this.grdItemsGastosBancarios.Columns.Add("Oficina", "Nro. Operación", "Oficina");
//this.grdItemsGastosBancarios.Columns.Add("Flujo", "Flujo", "Flujo");
/* Propiedades Finales */
grdItemsGastosBancarios.ReadOnly = true;
grdItemsGastosBancarios.ShowFilteringRow = false;
grdItemsGastosBancarios.EnableFiltering = false;
grdItemsGastosBancarios.MasterTemplate.EnableFiltering = false;
grdItemsGastosBancarios.EnableGrouping = false;
grdItemsGastosBancarios.MasterTemplate.EnableGrouping = false;
grdItemsGastosBancarios.EnableSorting = false;
grdItemsGastosBancarios.MasterTemplate.EnableCustomSorting = false;
grdItemsGastosBancarios.AutoGenerateColumns = false;
grdItemsGastosBancarios.BestFitColumns();
//Infrastructure.WinForms.Controls.GridAutoFit.Fit(grdItemsGastosBancarios);
}
catch (Exception ex)
{ Infrastructure.WinForms.Controls.Dialogos.MostrarMensajeError(Presenter.Title, Infrastructure.Aspect.Constants.Mensajes.FormatDataGridView + " (Grid Gastos Bancarios)", ex); }
}
/// <summary>
/// Hàm tạo column cho Gridview loại GridViewCommandColumn
/// </summary>
/// <returns>GridViewCommandColumn</returns>
public GridViewCommandColumn BuildCommandColumnEdit()
{
GridViewCommandColumn commandColumn = new GridViewCommandColumn();
commandColumn.Caption = "Sửa";
commandColumn.ButtonType = GridViewCommandButtonType.Image;
commandColumn.Width = Unit.Pixel(30);
commandColumn.ShowEditButton = true;
return commandColumn;
}
private void CreateMasterColumns(ASPxGridView masterGrid)
{
GridViewCommandColumn colCmd = new GridViewCommandColumn();
colCmd.ShowEditButton = true;
masterGrid.Columns.Add(colCmd);
masterGrid.Columns.Add(new GridViewDataColumn("CategoryID"));
masterGrid.Columns.Add(new GridViewDataColumn("CategoryName"));
masterGrid.Columns.Add(new GridViewDataColumn("Description"));
}
protected void Page_Load(object sender, EventArgs e)
{
if (!SessionBox.CheckUserSession())
{
Response.Redirect("~/Login.aspx");
}
else
{
List <string> lstRole = new List <string>();
lstRole.Add("2");
lstRole.Add("46");
if (SessionBox.GetUserSession().CurrentRole[0].ToString().Split(',')[0] == "31")
{
//var data = from p in db.Person
// select p;
//GridView.DataSource = data;
//GridView.DataBind();
//GridView.KeyFieldName = "Personid";
}
else if (lstRole.Contains(SessionBox.GetUserSession().CurrentRole[0].ToString().Split(',')[0]))
{
//var data = from p in db.Person
// select p;
//GridView.DataSource = data;
//GridView.DataBind();
//GridView.KeyFieldName = "Personid";
}
else
{
//var data = from p in db.Person
// where p.Maindeptid == SessionBox.GetUserSession().DeptNumber
// select p;
//GridView.DataSource = data;
//GridView.DataBind();
//GridView.KeyFieldName = "Personid";
//adsPerson.Where = "Maindeptid == \"" + SessionBox.GetUserSession().DeptNumber + "\"";
//adsDept.Where = "Deptnumber.StartsWith(\"" + SessionBox.GetUserSession().DeptNumber.Remove(4) + "\")";
//adsPosition.Where = "Maindeptid == \"" + SessionBox.GetUserSession().DeptNumber + "\"";
Session["maindeptid"] = SessionBox.GetUserSession().DeptNumber;
Session["deptid"] = SessionBox.GetUserSession().DeptNumber.Remove(4);
Session["PosDept"] = SessionBox.GetUserSession().DeptNumber;
}
//初始化模块权限
UserHandle.InitModule(this.PageTag);
//是否有浏览权限
if (UserHandle.ValidationHandle(PermissionTag.Browse))
{
GridViewCommandColumn colEdit = (GridViewCommandColumn)GridView.Columns["操作"];
if (!UserHandle.ValidationHandle(PermissionTag.Edit))
{
colEdit.EditButton.Visible = false;
}
}
}
}
private void AddCommandColumn(string name, string headerText, int width)
{
GridViewCommandColumn col = new GridViewCommandColumn();
col.Width = width;
col.UseDefaultText = true;
col.DefaultText = headerText;
col.Name = name;
grdLister.Columns.Add(col);
}
private void AddColumn(ASPxGridView grid, int index)
{
GridViewCommandColumn col = new GridViewCommandColumn();
col.Name = "Command";
col.ShowSelectCheckbox = true;
col.HeaderCaptionTemplate = check;
col.VisibleIndex = index;
grid.Columns.Insert(index, col);
}
private void AddCommandColumn(RadGridView grid, string name, string headerText)
{
GridViewCommandColumn col = new GridViewCommandColumn();
col.UseDefaultText = true;
col.DefaultText = headerText;
col.Name = name;
col.Width = 70;
col.TextAlignment = ContentAlignment.MiddleCenter;
grid.Columns.Add(col);
}
private void GridButton()
{
GridViewCommandColumn col = new GridViewCommandColumn();
col.Width = 135;
col.Name = "btnShowCustomer";
col.UseDefaultText = true;
col.ImageLayout = System.Windows.Forms.ImageLayout.Center;
col.DefaultText = "Show Customer";
col.TextAlignment = System.Drawing.ContentAlignment.MiddleCenter;
grdCustomerBunch.Columns.Add(col);
}
private void GridButton()
{
GridViewCommandColumn col = new GridViewCommandColumn();
col.Width = 160;
col.Name = "btnEditAddress";
col.UseDefaultText = true;
col.ImageLayout = System.Windows.Forms.ImageLayout.Center;
col.DefaultText = "Edit Address";
col.TextAlignment = System.Drawing.ContentAlignment.MiddleCenter;
grdLister.Columns.Add(col);
}
private void GetDados()
{
gridRegimes.DataSource = rhd.GetRegimes();
gridRegimes.DataBind();
if (gridRegimes.Columns.IndexOf(gridRegimes.Columns["check"]) == -1)
{
GridViewCommandColumn col = new GridViewCommandColumn();
col.ShowSelectCheckbox = true;
col.Name = "check";
gridRegimes.Columns.Add(col);
}
}
private void AddCommandColumn(string name, string headerText, int width)
{
GridViewCommandColumn col = new GridViewCommandColumn();
col.Width = width;
col.UseDefaultText = true;
col.DefaultText = headerText;
col.Name = name;
grdCompanyGroup.Columns.Add(col);
txtGroupName.Focus();
}
public void DetailGridButton()
{
GridViewCommandColumn cmd = new GridViewCommandColumn();
cmd.Name = "Delete";
cmd.HeaderText = "";
cmd.DefaultText = "Delete";
cmd.UseDefaultText = true;
cmd.TextImageRelation = TextImageRelation.ImageBeforeText;
cmd.TextAlignment = ContentAlignment.MiddleCenter;
cmd.Width = 80;
grdDetails.Columns.Add(cmd);
}
private void AddCommandColumn(RadGridView grid, string colName, string caption)
{
GridViewCommandColumn col = new GridViewCommandColumn();
col.Width = 100;
col.Name = colName;
col.UseDefaultText = true;
col.ImageLayout = System.Windows.Forms.ImageLayout.Center;
col.DefaultText = caption;
col.TextAlignment = System.Drawing.ContentAlignment.MiddleCenter;
grid.Columns.Add(col);
}
protected new GridViewCommandColumnButtonControl CreateCommandButtonControl(GridViewCommandColumn column, ColumnCommandButtonType commandItemType, GridViewCommandButtonType buttonType, string text, ImageProperties image, int visibleIndex, bool postponeClick)
{
if (!CanCreateCommandButton(commandItemType)) return null;
var isEditingRow = DataProxy.IsNewRowEditing && visibleIndex == -2147483647 || visibleIndex >= 0 && DataProxy.IsRowEditing(visibleIndex);
var eventArgs = new ASPxGridViewCommandButtonEventArgs(column, commandItemType, text, image, visibleIndex, isEditingRow, buttonType);
Grid.RaiseCommandButtonInitialize_Internal(eventArgs);
return eventArgs.Visible ? new GridViewCommandColumnButtonControl(eventArgs, Grid, GetCommandButtonClickHandlerArgs(commandItemType), postponeClick) : null;
}
protected void Bind()
{
if ((!this.IsCallback) && (!this.IsPostBack))
{
//Restore filter from cookies
this.LoadFilterFromCookies();
this.InitialFilterBind();
SessionManager.CurrentCategories = this.GetListOfCategories();
}
//Get main results
try
{
List<int> channelIds = (SessionManager.CurrentChannels.Count==0)?this.GetListOfChannels()
:SessionManager.CurrentChannels;
List<int> categoryIds = (SessionManager.CurrentCategories.Count==0)?this.GetListOfCategories()
:SessionManager.CurrentCategories;
SessionManager.CurrentChannels = channelIds;
SessionManager.CurrentCategories = categoryIds;
CanonMainMonitor monitor = new CanonMainMonitor(Cdb.ConnectionString);
monitor.Date = deDate.Date;
monitor.ChannelIds = channelIds;
monitor.PriceCondition = this.GetPriceCondition();
if (categoryIds != null)
monitor.CategoryIds = categoryIds;
if (!string.IsNullOrEmpty(txtProduct.Text.Trim()))
monitor.ProductName = Memos.Framework.Utilities.TruncateString(txtProduct.Text.Trim(), 300);
mappingRules = monitor.GetMappingRules();
DataSet ds = monitor.GetMainMonitorValues();
//get sorting settings before columns clearing
DevExpress.Data.ColumnSortOrder sortOrder = DevExpress.Data.ColumnSortOrder.None;
string sortColumn = string.Empty;
foreach (GridViewColumn gvc in gridMainMonitor.Columns)
{
GridViewDataColumn gvdc = gvc as GridViewDataColumn;
if (gvdc != null)
if (gvdc.SortOrder != DevExpress.Data.ColumnSortOrder.None)
{
sortColumn = gvdc.FieldName;
sortOrder = gvdc.SortOrder;
}
}
gridMainMonitor.Columns.Clear();
GridViewCommandColumn col0 = new GridViewCommandColumn();
col0.ShowSelectCheckbox = true;
col0.VisibleIndex = 0;
col0.HeaderTemplate = new CommandColumnHeaderTemplate(gridMainMonitor, "selCheckbox", "gridMainMonitorSelectionBox");
col0.HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
col0.HeaderStyle.VerticalAlign = VerticalAlign.Middle;
gridMainMonitor.Columns.Add(col0);
int visIndex = 1;
foreach (DataColumn dc in ds.Tables[0].Columns)
{
GridViewDataTextColumn col1 = new GridViewDataTextColumn();
col1.Caption = this.LocalizeColumnName(dc.ColumnName);
col1.FieldName = dc.ColumnName;
col1.VisibleIndex = visIndex++;
if (dc.ColumnName == "ProductId")
col1.Visible = false;
if ((!string.IsNullOrEmpty(sortColumn)) && (col1.FieldName == sortColumn))
col1.SortOrder = sortOrder;
col1.Settings.SortMode = DevExpress.XtraGrid.ColumnSortMode.Custom;
gridMainMonitor.Columns.Add(col1);
}
gridMainMonitor.SettingsPager.PageSize = int.Parse(cbPageSize.SelectedItem.Value.ToString());
gridMainMonitor.DataSource = ds.Tables[0];
gridMainMonitor.DataBind();
gridMainMonitor.JSProperties["cpRowsCount"] = gridMainMonitor.VisibleRowCount;
}
catch (Exception ex)
{
Logger.Log(string.Format("exception {0}", ex.ToString()), LogLevel.Error);
gridMainMonitor.Columns.Clear();
gridMainMonitor.DataSource = null;
gridMainMonitor.DataBind();
}
}
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
}
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 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);
}
public void CreateGridViewRetale(Page mypage, ASPxGridView gridViewName, DataTable sourceField, int modulerelateid, string keyFieldName, string ID, bool isStored)
{
try
{
//SETTING GRID
gridViewName.KeyFieldName = isStored ? keyFieldName : keyFieldName.ToLower();
gridViewName.ClientInstanceName = ID;
gridViewName.ID = ID;
gridViewName.Width = Unit.Percentage(100);
//add checkbox column
GridViewCommandColumn gridCommandColumn = new GridViewCommandColumn();
gridCommandColumn.ShowSelectCheckbox = true;
gridCommandColumn.VisibleIndex = 0;
gridCommandColumn.HeaderTemplate = new MyHeaderCheckBox(gridViewName.ClientInstanceName, true);
gridCommandColumn.Width = Unit.Pixel(35);
gridViewName.Columns.Add(gridCommandColumn);
//lay duong dan form newedit
string popupWindowControlURL = string.Format(ConfigurationManager.AppSettings["PopupMasterURL"].ToString(), modulerelateid);
//lấy thông tin module hiện tại với quyền userid hiện tại
DataTable dtCheckRight = ObjectUtils.getModuleRolesByUser(modulerelateid, CU.getuserid());
string formsetting = "";
if (dtCheckRight.Rows[0]["formsetting"] != null)
formsetting = dtCheckRight.Rows[0]["formsetting"].ToString();//gviewrl.GetRowKey(gviewrl.GetFocusedRowIndex()).toString()
//tao su kien doubleclick cho lưới
gridViewName.ClientSideEvents.RowDblClick = "function(s,e){ js:openModalEditWindowRelate('" + popupWindowControlURL + "','" + formsetting + "',s.GetRowKey(e.visibleIndex));}";
//kiem tra cache column
if (mypage.Session["colcollect_gridrlMain" + modulerelateid] != null)
{
GridViewColumn[] colarray = mypage.Session["colcollect_gridrlMain" + modulerelateid] as GridViewColumn[];
gridViewName.Columns.AddRange(colarray);
List<List<ASPxSummaryItem>> summarylist = mypage.Session["colcollect_gridMain_summary" + modulerelateid] as List<List<ASPxSummaryItem>>;
if (summarylist != null)
{
if (summarylist.Count > 0)
{
gridViewName.Settings.ShowFooter = true;
gridViewName.GroupSummary.AddRange(summarylist[0]);
gridViewName.TotalSummary.AddRange(summarylist[1]);
}
}
}
else
{
List<ASPxSummaryItem> groupitem = new List<ASPxSummaryItem>();
List<ASPxSummaryItem> footeritem = new List<ASPxSummaryItem>();
GridViewColumn[] colarray = new GridViewColumn[sourceField.Rows.Count];
string objectnamefk = string.Empty;
for (int i = 0; i < sourceField.Rows.Count; i++)
{
//SiAuto.Main.LogString("cot" + i.ToString(), sourceField.Rows[i]["fieldname"].ToString());
string fieldtext = sourceField.Rows[i]["fieldtext"].ToString();
string fieldname = isStored ? sourceField.Rows[i]["fieldname"].ToString() : sourceField.Rows[i]["fieldname"].ToString().ToLower();
string tablename = sourceField.Rows[i]["tablename"].ToString().ToLower();
string alias = sourceField.Rows[i]["alias"].ToString().ToLower();
int width = sourceField.Rows[i]["width"].ToString() == string.Empty ? 0 : int.Parse(sourceField.Rows[i]["width"].ToString());
string format = sourceField.Rows[i]["format"].ToString();
string tempeditor = sourceField.Rows[i]["tempeditor"].ToString();
string datasource = sourceField.Rows[i]["datasource"].ToString();
int isGroup = sourceField.Rows[i]["isGroup"].ToString() == string.Empty ? 0 : int.Parse(sourceField.Rows[i]["isGroup"].ToString());
string SummaryCalculator = sourceField.Rows[i]["SummaryCalculator"].ToString();
bool ishidden = false;
bool.TryParse(sourceField.Rows[i]["ishidden"].ToString(), out ishidden);
bool ishyperlinkrelate = sourceField.Rows[i]["ishyperlinkrelate"].ToString() == "True" ? true : false;
switch (sourceField.Rows[i]["tempcolumn"].ToString().ToLower())
{
case "textcolumn":
{
if (objectnamefk == string.Empty)
objectnamefk = ObjectUtils.getObjectNameFromModuleId(modulerelateid);
GridViewDataTextColumn dc = BuildTextColumn(fieldtext, fieldname, alias, width, format, tempeditor, modulerelateid,
tablename, datasource, ishyperlinkrelate, keyFieldName, objectnamefk);
gridViewName.Columns.Add(dc);
colarray[i] = dc;
break;
}
case "checkcolumn":
{
GridViewDataCheckColumn dc = BuildCheckColumn(fieldtext, fieldname, alias, width);
gridViewName.Columns.Add(dc);
colarray[i] = dc;
break;
}
case "datecolumn":
{
GridViewDataDateColumn dc = BuildDateColumn(fieldtext, fieldname, alias, width, format);
gridViewName.Columns.Add(dc);
colarray[i] = dc;
break;
}
case "progressbarcolumn":
{
GridViewDataProgressBarColumn dc = BuildProgressBarColumn(fieldtext, fieldname, alias, width);
gridViewName.Columns.Add(dc);
colarray[i] = dc;
break;
}
}
gridViewName.Columns[fieldname].Visible = !ishidden;
List<ASPxSummaryItem> sitem = SummaryCalculatorOnGview(fieldname, fieldtext, SummaryCalculator, gridViewName);
if (sitem != null)
{
groupitem.Add(sitem[0]);
footeritem.Add(sitem[1]);
}
}
List<List<ASPxSummaryItem>> summarylist = new List<List<ASPxSummaryItem>>();
summarylist.Add(groupitem);
summarylist.Add(footeritem);
mypage.Session["colcollect_gridrlMain" + modulerelateid] = colarray;
mypage.Session["colcollect_gridMain_summary" + modulerelateid] = summarylist;
}
DataRow[] dataRows = sourceField.Select("isGroup>0", "isGroup ASC");
if (dataRows.Length > 0)
{
gridViewName.Settings.ShowFooter = true;
for (int i = 0; i < dataRows.Length; i++)
{
string fieldname = dataRows[i]["fieldname"].ToString();
gridViewName.GroupBy(gridViewName.Columns[fieldname]);
((GridViewDataTextColumn)gridViewName.Columns[fieldname]).GroupIndex = i;
gridViewName.GroupSummary.Add(DevExpress.Data.SummaryItemType.Count, fieldname).DisplayFormat = "Tổng:{0}";
}
}
SiAuto.Main.LogColored(System.Drawing.Color.Chocolate, keyFieldName);
}
catch (Exception ex)
{
SiAuto.Main.LogColored(System.Drawing.Color.Red, ex.ToString());
}
}
/// <summary>
/// Hàm tạo column gridview động
/// </summary>
/// <param name="gridViewName">Tên lưới</param>
/// <param name="sourceField">DataTable chứa danh sách các field column cần tạo control</param>
/// <param name="strSQLDatasource">Datasource cho gridview</param>
/// <param name="ssParamsListGridView">Danh dách các tham số để load datasource cho gridview</param>
public void CreateGridViewDynamic(Page mypage, ASPxGridView gridViewName, DataTable sourceField, int moduleid, string keyFieldName, bool isStored)
{
try
{
//gridViewName.Columns.Clear();
gridViewName.KeyFieldName = isStored ? keyFieldName : keyFieldName.ToLower();
gridViewName.ClientInstanceName = "gview";//dat ten nay co dinh, khong thay doi duoc
//Add header template
GridViewCommandColumn gridCommandColumn = new GridViewCommandColumn();
gridCommandColumn.ShowSelectCheckbox = true;
gridCommandColumn.SelectAllCheckboxMode = GridViewSelectAllCheckBoxMode.Page;
gridCommandColumn.VisibleIndex = 0;
gridCommandColumn.Width = Unit.Pixel(35);
gridViewName.Columns.Add(gridCommandColumn);
//gridViewName.TotalSummary.Clear();
//
if (mypage.Session["colcollect_gridMain" + moduleid] != null)
{
GridViewColumn[] colarray = mypage.Session["colcollect_gridMain" + moduleid] as GridViewColumn[];
gridViewName.Columns.AddRange(colarray);
List<List<ASPxSummaryItem>> summarylist = mypage.Session["colcollect_gridMain_summary" + moduleid] as List<List<ASPxSummaryItem>>;
if (summarylist != null)
{
if (summarylist.Count > 0)
{
gridViewName.Settings.ShowFooter = true;
gridViewName.GroupSummary.AddRange(summarylist[0]);
gridViewName.TotalSummary.AddRange(summarylist[1]);
}
}
}
else
{
string objectnamemain = string.Empty;
List<ASPxSummaryItem> groupitem = new List<ASPxSummaryItem>();
List<ASPxSummaryItem> footeritem = new List<ASPxSummaryItem>();
GridViewColumn[] colarray = new GridViewColumn[sourceField.Rows.Count];
for (int i = 0; i < sourceField.Rows.Count; i++)
{
string fieldtext = sourceField.Rows[i]["fieldtext"].ToString();
string fieldname = isStored ? sourceField.Rows[i]["fieldname"].ToString() : sourceField.Rows[i]["fieldname"].ToString().ToLower();
string tablename = sourceField.Rows[i]["tablename"].ToString().ToLower();
string alias = sourceField.Rows[i]["alias"].ToString().ToLower();
int width = sourceField.Rows[i]["width"].ToString() == string.Empty ? 0 : int.Parse(sourceField.Rows[i]["width"].ToString());
string format = sourceField.Rows[i]["format"].ToString();
string tempeditor = sourceField.Rows[i]["tempeditor"].ToString();
string datasource = sourceField.Rows[i]["datasource"].ToString();
int isGroup = sourceField.Rows[i]["isGroup"].ToString() == string.Empty ? -1 : int.Parse(sourceField.Rows[i]["isGroup"].ToString());
string SummaryCalculator = sourceField.Rows[i]["SummaryCalculator"].ToString();
bool ishidden = false;
bool.TryParse(sourceField.Rows[i]["ishidden"].ToString(), out ishidden);
switch (sourceField.Rows[i]["tempcolumn"].ToString().ToLower())
{
case "bandcolumn":
{
GridViewBandColumn band = new GridViewBandColumn(fieldtext);
gridViewName.Columns.Add(band);
colarray[i] = band;
break;
}
case "textcolumn":
{
if (objectnamemain == string.Empty)
objectnamemain = ObjectUtils.getObjectNameFromModuleId(moduleid);
GridViewDataTextColumn dc = BuildTextColumn(fieldtext, fieldname, alias, width, format, tempeditor, moduleid, tablename, datasource, false, keyFieldName, objectnamemain);
if (i < 2 && Utils.isMobileBrowser())
dc.FixedStyle = GridViewColumnFixedStyle.Left;
gridViewName.Columns.Add(dc);
colarray[i] = dc;
break;
}
case "checkcolumn":
{
GridViewDataCheckColumn dc = BuildCheckColumn(fieldtext, fieldname, alias, width);
if (i < 2 && Utils.isMobileBrowser())
dc.FixedStyle = GridViewColumnFixedStyle.Left;
gridViewName.Columns.Add(dc);
colarray[i] = dc;
break;
}
case "datecolumn":
{
GridViewDataDateColumn dc = BuildDateColumn(fieldtext, fieldname, alias, width, format);
if (i < 2 && Utils.isMobileBrowser())
dc.FixedStyle = GridViewColumnFixedStyle.Left;
gridViewName.Columns.Add(dc);
colarray[i] = dc;
break;
}
case "progressbarcolumn":
{
GridViewDataProgressBarColumn dc = BuildProgressBarColumn(fieldtext, fieldname, alias, width);
if (i < 2 && Utils.isMobileBrowser())
dc.FixedStyle = GridViewColumnFixedStyle.Left;
gridViewName.Columns.Add(dc);
colarray[i] = dc;
break;
}
}
gridViewName.Columns[fieldname].Visible = !ishidden;
List<ASPxSummaryItem> sitem = SummaryCalculatorOnGview(fieldname, fieldtext, SummaryCalculator, gridViewName);
if (sitem != null)
{
groupitem.Add(sitem[0]);
footeritem.Add(sitem[1]);
}
}
List<List<ASPxSummaryItem>> summarylist = new List<List<ASPxSummaryItem>>();
summarylist.Add(groupitem);
summarylist.Add(footeritem);
mypage.Session["colcollect_gridMain" + moduleid] = colarray;
mypage.Session["colcollect_gridMain_summary" + moduleid] = summarylist;
}
DataRow[] dataRows = sourceField.Select("ISNULL(isGroup,-1)>=0", "isGroup ASC");
SiAuto.Main.LogDataTable("danh sach field chuan bi group filter ISNULL(isGroup,-1)>=0 isGroup ASC", sourceField);
if (dataRows.Length > 0)
{
gridViewName.Settings.ShowGroupPanel = true;
gridViewName.Settings.ShowFooter = true;
for (int i = 0; i < dataRows.Length; i++)
{
string fieldname = isStored ? dataRows[i]["fieldname"].ToString() : dataRows[i]["fieldname"].ToString().ToLower();
SiAuto.Main.LogColored(Color.Orange, fieldname);
gridViewName.GroupBy(gridViewName.Columns[fieldname], i);
//((GridViewDataTextColumn)gridViewName.Columns[fieldname]).GroupIndex = i;
//gridViewName.GroupSummary.Add(DevExpress.Data.SummaryItemType.Count, fieldname).DisplayFormat = "Tổng:{0}";
}
}
SiAuto.Main.LogColored(System.Drawing.Color.Chocolate, keyFieldName);
}
catch (Exception ex)
{
SiAuto.Main.LogColored(System.Drawing.Color.Red, ex.ToString());
}
}
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
}
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);
}
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);
}
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 ASPxSmartGridViewTableCommandCell(ASPxGridViewRenderHelper renderHelper, GridViewCommandColumn column, int visibleIndex, bool removeLeftBorder, bool removeRightBorder)
: base(renderHelper, column, visibleIndex, removeLeftBorder, removeRightBorder)
{
}
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);
}
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);
}
