Programación: grid

Mostrando entradas con la etiqueta grid. Mostrar todas las entradas

jueves, 6 de abril de 2017

C# - Jquery Grid activar orden (sort) en encabezados de una grilla.-

var lastsel;
function defineGridOp() {
try {
$("#grid_op").jqGrid({
caption: "Nominas",
datatype: "local",
colNames: ['Nómina', 'Estado', 'Fecha Nómina', 'Total Nómina'],
colModel: [
{ name: 'numero_nomina', index: 'numero_nomina', width: '150px', align: 'center', formatter: 'number', sorttype: 'number', formatoptions: { decimalPlaces: 0} },
{ name: 'estado', index: 'estado', align: 'center', width: '200px', editable: false, hidden: false },
{ name: 'fecha_nomina', index: 'fecha_nomina', width: '200px', align: 'center', editable: false, hidden: false, formatter: 'date', formatoptions: { newformat: 'd/m/Y' } },
{ name: 'total_nomina', index: 'total_nomina', width: '300px', align: 'center', formatter: 'number',sorttype: 'number', formatoptions: { decimalPlaces: 0 } }
],
multiselect: true,
rowNum: 200,
pgbuttons: true,
pager: $('#pager2'),
viewrecords: true,
width: 950,
shrinkToFit: false,
autowidth: false,
onSortCol: true,
forceFit: true,
height: 400,
editurl: jutils.pageName(),
deselectAfterSort: false,
onSelectRow: function (id, status) {
if (id && id !== lastsel) {
$('#grid_op').jqGrid('restoreRow', lastsel);
}
}
});
$("#grid_op").jqGrid('navGrid', "#pager2", { edit: false, add: false, del: false, refresh: false, search: false });
$("#grid_op").jqGrid('navButtonAdd', '#pager2', { buttonicon: 'ui-icon-document', onClickButton: function () { Ver(); }, caption: ' Reimprimir Nómina ', title: ' Reimprimir Nómina ' });
$("#grid_op").jqGrid('navButtonAdd', '#pager2', { buttonicon: 'ui-icon-document', onClickButton: function () { Exportar(); }, caption: ' Excel', title: ' Exportar ' });
$("#grid_op").jqGrid('navButtonAdd', '#pager2', { buttonicon: 'ui-icon-document', onClickButton: function () { Ver2(); }, caption: ' Detalle', title: ' Report e' });

} catch (e) {
jutils.showError(e, arguments.callee.name);
}
}

martes, 20 de septiembre de 2016

C# - Generar Grilla Jquery Standard pasando solo columnas (separadas por ;)

.ASPX (tiene pagina maestra, pero no es necesaria)
_________________________________________________________

<%@ Page Title="Genera Grilla Standard" Language="C#" MasterPageFile="~/Site.Master"
AutoEventWireup="true" CodeBehind="GeneraGrillaStandard.aspx.cs" Inherits="LeaseOperWeb.Utils.GeneraGrillaStandard" %>

<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" runat="server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="HeaderContent" runat="server">
<table width="100%" border="2">
<tr>
<td>
</td>
<td align="center">
GENERADOR GRILLA STANDARD JQUERY 
</td>
<td>
 
</td>
<td>
 
</td>
</tr>
<tr>
<td>
Ingrese Columnas<br />
Separador de Columnas ";"
</td>
<td>
<asp:Button ID="BtnGenerarGrilla" runat="server" Text="Generar Grilla JQUERY" ToolTip="el separador debe ser ;"
Height="67px" Width="154px" onclick="BtnGenerarGrilla_Click1"/>
</td>
<td>
 
</td>
<td>
 
</td>
</tr>
<tr>
<td>
 
</td>
<td>
 </td>
<td>
 
</td>
<td>
 
</td>
</tr>
<tr>
<td>
Grilla Standard
</td>
<td>
 
<asp:TextBox ID="txtColumnasEntrada" runat="server" Height="182px"
TextMode="MultiLine" Width="574px"></asp:TextBox>
</td>
<td>
 
</td>
<td>
 
</td>
</tr>
<tr>
<td>
 
</td>
<td>
<asp:TextBox ID="txtGrillaJqueryStandard" runat="server" Height="492px" TextMode="MultiLine"
Width="726px"></asp:TextBox>
</td>
<td>
 
</td>
<td>
 
</td>
</tr>
<tr>
<td>
 
</td>
<td>
 
</td>
<td>
 
</td>
<td>
 
</td>
</tr>
<tr>
<td>
 
</td>
<td>
 
</td>
<td>
 
</td>
<td>
 
</td>
</tr>
</table>
</asp:Content>

.CS
_________________________________________________________

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

namespace LeaseOperWeb.Utils
{
public partial class GeneraGrillaStandard : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
txtGrillaJqueryStandard.Attributes.Add("onfocus", "this.select();");

}

protected void BtnGenerarGrilla_Click1(object sender, EventArgs e)
{
try
{
if (txtColumnasEntrada.Text.Trim() != string.Empty)
PrepararGrilla();
else
Response.Write("<script language='JavaScript'>alert('Debe indicar las columnas para generar Grilla JQuery');</script>");
}
catch (Exception ex)
{
throw ex;
}
}

private void PrepararGrilla()
{
try
{
const string quote = "\"";
var listaColumnas = txtColumnasEntrada.Text.Trim().Split(';');
var grillaEncabezado = @"var lastsel;" + Environment.NewLine +
@"function defineGrid() {" + Environment.NewLine +
@"try {" + Environment.NewLine +
@" $(" + quote + "#Grid" + quote + ").jqGrid({" + Environment.NewLine +
@"datatype:" + quote + "local" + quote +","+ Environment.NewLine +
@"colNames: [";

var grillaColumnasEncabezado = string.Empty;
var tope = listaColumnas.Length - 1;
for (int j = 0; j < listaColumnas.Length; j++)
{
if (j != tope)
grillaColumnasEncabezado = grillaColumnasEncabezado + "'" + listaColumnas[j] + "',";
else
grillaColumnasEncabezado = grillaColumnasEncabezado + "'" + listaColumnas[j] + "']," + Environment.NewLine;
}

var grillaPreColumnas = @"colModel: [";
const string columnasStandard =
@"{name: 'nomCol', index: 'nomCol', align: 'center', width: '100px', editable: false, hidden: false }";
var grillaColumnaDetalle = string.Empty;
for (int i = 0; i < listaColumnas.Length; i++)
{
listaColumnas[i] = columnasStandard.Replace("nomCol", listaColumnas[i]);
if (i != tope)
grillaColumnaDetalle = grillaColumnaDetalle + listaColumnas[i]+","+ Environment.NewLine;
else
grillaColumnaDetalle = grillaColumnaDetalle + listaColumnas[i] + @"]," + Environment.NewLine;

}

var grillaPie = @" //multiselect: true," + Environment.NewLine +
"rowNum: 150," + Environment.NewLine +
"rowList: [10, 25, 50, 100, 150, 200, 250, 300, 350]," + Environment.NewLine +
"pgbuttons: false," + Environment.NewLine +
"pager: $('#pager2')," + Environment.NewLine +
"viewrecords: true," + Environment.NewLine +
"width: 1000," + Environment.NewLine +
"shrinkToFit: false," + Environment.NewLine +
"autowidth: false," + Environment.NewLine +
"forceFit: true," + Environment.NewLine +
"height: 200," + Environment.NewLine +
"editurl: jutils.pageName()," + Environment.NewLine +
"onSelectRow: function (id, status) {" + Environment.NewLine +
"if (id && id !== lastsel) {" + Environment.NewLine +
" $('#Grid').jqGrid('restoreRow', lastsel);" + Environment.NewLine +
"}" + Environment.NewLine +
"}" + Environment.NewLine +
"});" + Environment.NewLine +
"$(" + quote + "#Grid" + quote + ").jqGrid('navGrid'," + quote + "#pager2" + quote + ", { edit: false, add: false, del: false, refresh: false, search: false });" + Environment.NewLine +
"} catch (e) {" + Environment.NewLine +
"jutils.showError(e, arguments.callee.name);" + Environment.NewLine +
"}" + Environment.NewLine +
"}";

ArmarGrilla(grillaEncabezado, grillaColumnasEncabezado, grillaPreColumnas, grillaColumnaDetalle,
grillaPie);
}
catch (Exception ex)
{
throw ex;
}
}

private void ArmarGrilla(string grillaEncabezado, string grillaColumnasEncabezado, string grillaPreColumnas, string grillaColumnaDetalle, string grillaPie)
{
txtGrillaJqueryStandard.Text = grillaEncabezado + grillaColumnasEncabezado + grillaPreColumnas +
grillaColumnaDetalle + grillaPie;

txtGrillaJqueryStandard.Focus();
}

}
}

.ASPX (representación de la grilla en una pantalla)
_________________________________________________________

<tr>

<tr>

<td>

</td>

</tr>

</table>

</div>

</div>

</td>

</td>

</tr>

jueves, 28 de julio de 2016

C# - Devexpress Seleccionar valor en combo (grilla con EditItemTemplate)

________________________________________________
Grilla .aspx
________________________________________________

<dx:ASPxGridView ID="gvDetPago" runat="server" Width="100%" CssClass="margenGrillaCentro"
ClientInstanceName="gvDetPago" KeyFieldName="operacion;cod_tipo_cuota;correlativo;num_cuota;cod_concepto">
<ClientSideEvents EndCallback="function(s, e){EndCallGrid(s, e);}" CustomButtonClick="function(s, e) {
if (e.buttonID == 'upd')
{
if (confirm('¿Desea Grabar?'))
{
s.UpdateEdit();
}
}
}" />
<SettingsBehavior AllowFocusedRow="True" AllowDragDrop="false" ConfirmDelete="true" />
<SettingsPager Visible="True" Mode="ShowPager" PageSize="5" Position="Bottom" />
<SettingsEditing Mode="PopupEditForm" PopupEditFormHorizontalAlign="Center" PopupEditFormShowHeader="True"
PopupEditFormVerticalAlign="Middle" PopupEditFormWidth="500px" />
<Settings ShowVerticalScrollBar="true" VerticalScrollableHeight="150" ShowHorizontalScrollBar="true"
ShowFooter="True" />
<SettingsText ConfirmDelete="¿Está seguro que desea eliminar este registro?" PopupEditFormCaption="Ingreso y Edición de Valores" />
<TotalSummary>
<dx:ASPxSummaryItem SummaryType="Sum" FieldName="PagadoCuotaPeso" DisplayFormat="Total Cuota: {0:N0} "
ShowInColumn="Operación"></dx:ASPxSummaryItem>
<dx:ASPxSummaryItem SummaryType="Sum" FieldName="interes_mora" DisplayFormat="Total Interes Mora: {0:N0} "
ShowInColumn="Operación"></dx:ASPxSummaryItem>
<dx:ASPxSummaryItem SummaryType="Sum" FieldName="total_pagado" DisplayFormat="Total Pagado: {0:N0} "
Tag="tot" ShowInColumn="Operación"></dx:ASPxSummaryItem>
</TotalSummary>
<Columns>
<dx:GridViewCommandColumn VisibleIndex="0" ButtonType="Image" CellStyle-Font-Size="9px"
Caption=" " Width="50px">
<EditButton Text="Editar" Visible="true" Image-Url="../../../Style/img/botones/pencil_small.png">
<Image Url="../../../Style/img/botones/pencil_small.png" />
<Image Url="../../../Style/img/botones/pencil_small.png">
</Image>
</EditButton>
<CancelButton Text="Cancelar" Visible="true" Image-Url="../../../Style/img/botones/stop.png">
<Image Url="../../../Style/img/botones/stop.png">
</Image>
</CancelButton>
<UpdateButton Text="Grabar" Visible="True" Image-Url="../../../Style/img/botones/save.png">
<Image Url="../../../Style/img/botones/save.png">
</Image>
</UpdateButton>
<DeleteButton Visible="true" Text="Eliminar" Image-Url="../../../Style/img/botones/remove_minus_sign_small.png">
<Image Url="../../../Style/img/botones/remove_minus_sign_small.png" />
</DeleteButton>
<CellStyle Font-Size="9px">
</CellStyle>
</dx:GridViewCommandColumn>
<%-- <dx:GridViewDataTextColumn Caption="Operación" FieldName="operacion" Visible="true"
Width="70px" VisibleIndex="1" CellStyle-HorizontalAlign="Left" EditCellStyle-HorizontalAlign="Left"
ReadOnly="false">
<PropertiesTextEdit Width="150px">
<ClientSideEvents KeyDown="SoloNumeros2" GotFocus="NoCopyPaste" LostFocus="SiCopyPaste"
ValueChanged="function(s, e){ cbckPage.PerformCallback('R,' + s.GetValue()) }" />
</PropertiesTextEdit>
<DataItemTemplate>
<dx:ASPxLabel ID="txbOp" Width="70px" ClientInstanceName="txbOp" runat="server" Text='<%# Bind("operacion")%>'>
</dx:ASPxLabel>
</DataItemTemplate>
<CellStyle HorizontalAlign="Left">
</CellStyle>
</dx:GridViewDataTextColumn>--%>
<dx:GridViewDataTextColumn Caption="Operación" FieldName="operacion" VisibleIndex="1"
Visible="true" EditCellStyle-HorizontalAlign="Right" CellStyle-HorizontalAlign="Right"
HeaderStyle-HorizontalAlign="Right" ReadOnly="false">
<EditCellStyle HorizontalAlign="Right">
</EditCellStyle>
<HeaderStyle HorizontalAlign="Right"></HeaderStyle>
<CellStyle HorizontalAlign="Right">
</CellStyle>
<DataItemTemplate>
<dx:ASPxLabel ID="txbOp" ClientInstanceName="txbOp" runat="server" Text='<%# Bind("operacion")%>'>
</dx:ASPxLabel>
</DataItemTemplate>
<EditItemTemplate>
<dx:ASPxTextBox ID="txtOperacion" Text='<%# Bind("operacion")%>' runat="server" MaxLength="12"
DisplayFormatInEditMode="True" HorizontalAlign="Right">
<ClientSideEvents KeyDown="SoloNumeros2" GotFocus="NoCopyPaste" LostFocus="SiCopyPaste"
ValueChanged="function(s, e){ cbckPage.PerformCallback('R,' + s.GetValue()) }" />
</dx:ASPxTextBox>
</EditItemTemplate>
<PropertiesTextEdit Style-HorizontalAlign="Right">
<Style HorizontalAlign="Right"></Style>
</PropertiesTextEdit>
</dx:GridViewDataTextColumn>
<%-- <dx:GridViewDataComboBoxColumn Caption="Tipo Cta." FieldName="cod_tipo_cuota" EditCellStyle-HorizontalAlign="Left"
CellStyle-HorizontalAlign="Left" HeaderStyle-HorizontalAlign="Left" VisibleIndex="2"
ReadOnly="false" Width="120px">
<PropertiesComboBox Width="150px" ValueType="System.String" TextField="desc_valor"
ValueField="valor" DataSourceID="objTipoCuota">
<ClientSideEvents ValueChanged="function(s, e){ cbckPage.PerformCallback('TC,' + s.GetValue()); }" />
</PropertiesComboBox>
<EditCellStyle HorizontalAlign="Left">
</EditCellStyle>
<HeaderStyle HorizontalAlign="Left"></HeaderStyle>
<CellStyle HorizontalAlign="Left">
</CellStyle>
</dx:GridViewDataComboBoxColumn>--%>
<dx:GridViewDataComboBoxColumn Caption="Tipo Cta." FieldName="cod_tipo_cuota" EditCellStyle-HorizontalAlign="Left"
CellStyle-HorizontalAlign="Left" HeaderStyle-HorizontalAlign="Left" VisibleIndex="2"
ReadOnly="false" Width="120px">
<%--<DataItemTemplate>
<dx:ASPxComboBox ID="cbxTipoCuota0" ClientInstanceName="cbxTipoCuota0" ValueField="valor"
SelectedIndex="0" DataSourceID="objTipoCuota" TextField="desc_valor" ValueType="System.String"
runat="server" Width="100px" HorizontalAlign="Right" Enabled="False" >
</dx:ASPxComboBox>
</DataItemTemplate>--%>
<EditItemTemplate>
<dx:ASPxComboBox ID="cbxTipoCuota" ClientInstanceName="cbxTipoCuota" ValueField="valor"
DataSourceID="objTipoCuota" TextField="desc_valor" ValueType="System.String"
runat="server" Width="150px" HorizontalAlign="Right" >
<ClientSideEvents ValueChanged="function(s, e){ cbckPage.PerformCallback('TC,' + s.GetValue()); }" />
</dx:ASPxComboBox>
</EditItemTemplate>
<PropertiesComboBox Width="150px" ValueType="System.String" TextField="desc_valor"
ValueField="valor" DataSourceID="objTipoCuota">
<ClientSideEvents ValueChanged="function(s, e){ cbckPage.PerformCallback('TC,' + s.GetValue()); }" />
</PropertiesComboBox>
<EditCellStyle HorizontalAlign="Left">
</EditCellStyle>
<HeaderStyle HorizontalAlign="Left"></HeaderStyle>
<CellStyle HorizontalAlign="Left">
</CellStyle>
</dx:GridViewDataComboBoxColumn>
<dx:GridViewDataTextColumn Caption="Corr." FieldName="correlativo_origen" Width="100"
EditCellStyle-HorizontalAlign="Left" CellStyle-HorizontalAlign="Left" HeaderStyle-HorizontalAlign="Left"
VisibleIndex="3" ReadOnly="false">
<EditCellStyle HorizontalAlign="Left">
</EditCellStyle>
<HeaderStyle HorizontalAlign="Left"></HeaderStyle>
<CellStyle HorizontalAlign="Right">
</CellStyle>
<DataItemTemplate>
<dx:ASPxLabel ID="lblCorrelativo" ClientInstanceName="lblCorrelativo" runat="server"
Text='<%# Bind("correlativo_origen")%>'>
</dx:ASPxLabel>
</DataItemTemplate>
<EditItemTemplate>
<dx:ASPxSpinEdit ID="txbCorrelativo" ClientInstanceName="txbCorrelativo" runat="server"
Width="150px" Text='<%# Bind("correlativo_origen") %>' MinValue="0" MaxValue="2147483647"
MaxLength="10" NullText="0" HorizontalAlign="Right" DecimalPlaces="0" SpinButtons-ShowIncrementButtons="false"
SpinButtons-ShowLargeIncrementButtons="false">
</dx:ASPxSpinEdit>
</EditItemTemplate>
</dx:GridViewDataTextColumn>
<%-- <dx:GridViewDataTextColumn Caption="Corr." FieldName="correlativo_deuda" Width="100"
EditCellStyle-HorizontalAlign="Left" CellStyle-HorizontalAlign="Left" HeaderStyle-HorizontalAlign="Left"
VisibleIndex="3" ReadOnly="false">
<EditCellStyle HorizontalAlign="Left">
</EditCellStyle>
<HeaderStyle HorizontalAlign="Left"></HeaderStyle>
<CellStyle HorizontalAlign="Right">
</CellStyle>
<DataItemTemplate>
<dx:ASPxLabel ID="lblCorrelativo" ClientInstanceName="lblCorrelativo" runat="server"
Text='<%# Bind("correlativo_deuda")%>'>
</dx:ASPxLabel>
</DataItemTemplate>
<EditItemTemplate>
<dx:ASPxSpinEdit ID="txbCorrelativo" ClientInstanceName="txbCorrelativo" runat="server"
Width="150px" Text='<%# Bind("correlativo_deuda") %>' MinValue="0" MaxValue="2147483647"
MaxLength="10" NullText="0" HorizontalAlign="Right" DecimalPlaces="0" SpinButtons-ShowIncrementButtons="false"
SpinButtons-ShowLargeIncrementButtons="false">
</dx:ASPxSpinEdit>
</EditItemTemplate>
</dx:GridViewDataTextColumn>--%>
<dx:GridViewDataTextColumn Caption="Cuota" Width="80" FieldName="num_cuota" EditCellStyle-HorizontalAlign="Left"
CellStyle-HorizontalAlign="Right" HeaderStyle-HorizontalAlign="Right" VisibleIndex="4"
ReadOnly="false">
<EditCellStyle HorizontalAlign="Right">
</EditCellStyle>
<EditItemTemplate>
<dx:ASPxSpinEdit ID="txbnumcuota" ClientInstanceName="txbnumcuota" runat="server"
MinValue="0" MaxValue="32767" MaxLength="5" HorizontalAlign="Right" DecimalPlaces="0"
SpinButtons-ShowIncrementButtons="false" SpinButtons-ShowLargeIncrementButtons="false"
NullText="0" Width="150px" Text='<%# Bind("num_cuota")%>' ReadOnly='<%# (Eval("cod_concepto") != null && Eval("cod_concepto").ToString() == "95" )? true : false %>'>
<ClientSideEvents ValueChanged="function(s, e){ cbckPage.PerformCallback('NC,' + s.GetValue()); }" />
</dx:ASPxSpinEdit>
</EditItemTemplate>
<HeaderStyle HorizontalAlign="Right"></HeaderStyle>
<CellStyle HorizontalAlign="Right">
</CellStyle>
</dx:GridViewDataTextColumn>
<dx:GridViewDataComboBoxColumn Caption="Concepto" FieldName="cod_concepto" VisibleIndex="5"
EditCellStyle-HorizontalAlign="Left" Width="150px" CellStyle-Wrap="True" CellStyle-HorizontalAlign="Center"
HeaderStyle-Wrap="True" HeaderStyle-HorizontalAlign="Center">
<EditItemTemplate>
<dx:ASPxComboBox ID="cbxConcepto" Width="150px" DataSourceID="objConceptos" runat="server"
TextField="descripcion" ValueField="cod_concepto"
ValueType="System.String" IncrementalFilteringMode="StartsWith">
<ClientSideEvents ValueChanged="function(s, e){ cbckPage.PerformCallback('CC,' + s.GetValue()); }" />
</dx:ASPxComboBox>
</EditItemTemplate>
<PropertiesComboBox Width="150px" DataSourceID="objConceptos" TextField="descripcion"
ValueField="cod_concepto" IncrementalFilteringMode="StartsWith">
<ClientSideEvents ValueChanged="function(s, e){ cbckPage.PerformCallback('CC,' + s.GetValue()); }" />
</PropertiesComboBox>
<HeaderStyle HorizontalAlign="Center" Wrap="True"></HeaderStyle>
<CellStyle HorizontalAlign="Center">
</CellStyle>
<EditFormSettings Visible="true" />
</dx:GridViewDataComboBoxColumn>
<dx:GridViewDataDateColumn Caption="Fecha Vcto." FieldName="fecha_vencimiento" VisibleIndex="6"
EditCellStyle-HorizontalAlign="Left" ReadOnly="true">
<DataItemTemplate>
<dx:ASPxLabel ID="txbFechaVcto" ClientInstanceName="txbFechaVcto" runat="server"
DisplayFormatString="{0:dd/MM/yyyy}" Text='<%# Bind("fecha_vencimiento")%>'>
</dx:ASPxLabel>
</DataItemTemplate>
<EditItemTemplate>
<dx:ASPxDateEdit ID="dFechaVcto" ClientInstanceName="dFechaVcto" runat="server" Width="150px"
Date='<%# Convert.ToDateTime(Eval("fecha_vencimiento"))%>' DisplayFormatInEditMode="True"
DisplayFormatString="{0:dd/MM/yyyy}" ClientEnabled="false">
</dx:ASPxDateEdit>
</EditItemTemplate>
<PropertiesDateEdit DisplayFormatString="{0:dd/MM/yyyy}">
</PropertiesDateEdit>
<HeaderStyle HorizontalAlign="Center"></HeaderStyle>
<CellStyle HorizontalAlign="Center">
</CellStyle>
</dx:GridViewDataDateColumn>
<dx:GridViewDataTextColumn Caption="Interés Mora" FieldName="interes_mora" VisibleIndex="7"
Visible="true" EditCellStyle-HorizontalAlign="Right" CellStyle-HorizontalAlign="Right"
HeaderStyle-HorizontalAlign="Right" ReadOnly="false">
<EditCellStyle HorizontalAlign="Right">
</EditCellStyle>
<HeaderStyle HorizontalAlign="Right"></HeaderStyle>
<CellStyle HorizontalAlign="Right">
</CellStyle>
<DataItemTemplate>
<dx:ASPxLabel ID="txbInteresMora" ClientInstanceName="txbInteresMora" runat="server"
Text='<%# Bind("interes_mora")%>'>
</dx:ASPxLabel>
</DataItemTemplate>
<EditItemTemplate>
<dx:ASPxTextBox ID="txtInteresMora" Text='<%# Bind("interes_mora")%>' runat="server"
MaxLength="12" DisplayFormatInEditMode="True" DisplayFormatString="N0" HorizontalAlign="Right">
<ClientSideEvents KeyDown="SoloNumeros2" GotFocus="NoCopyPaste" LostFocus="SiCopyPaste"
ValueChanged="function(s, e){ cbckPage.PerformCallback('IM,' + s.GetValue()) }" />
</dx:ASPxTextBox>
</EditItemTemplate>
<PropertiesTextEdit Style-HorizontalAlign="Right">
<Style HorizontalAlign="Right"></Style>
</PropertiesTextEdit>
</dx:GridViewDataTextColumn>
<dx:GridViewDataTextColumn Caption="Monto Cuota" VisibleIndex="8" FieldName="PagadoCuotaPeso"
EditCellStyle-HorizontalAlign="Left" Visible="true" CellStyle-HorizontalAlign="Right"
Width="120" HeaderStyle-HorizontalAlign="Center" ReadOnly="true" PropertiesTextEdit-DisplayFormatString="N0">
<PropertiesTextEdit DisplayFormatString="N2">
</PropertiesTextEdit>
<DataItemTemplate>
<dx:ASPxLabel ID="txbMontoCuota" ClientInstanceName="txbMontoCuota" runat="server"
Text='<%# Bind("PagadoCuotaPeso")%>'>
</dx:ASPxLabel>
</DataItemTemplate>
<EditItemTemplate>
<dx:ASPxTextBox ID="txtMontoCuota" Text='<%# Bind("PagadoCuotaPeso")%>' runat="server"
MaxLength="12" Width="150px" DisplayFormatInEditMode="True" DisplayFormatString="N0"
HorizontalAlign="Left" ClientEnabled="false">
</dx:ASPxTextBox>
</EditItemTemplate>
<HeaderStyle HorizontalAlign="Center"></HeaderStyle>
<CellStyle HorizontalAlign="Right">
</CellStyle>
</dx:GridViewDataTextColumn>
<dx:GridViewDataTextColumn Caption="Total Pagado" VisibleIndex="9" FieldName="total_pagado"
EditCellStyle-HorizontalAlign="Left" Visible="true" PropertiesTextEdit-DisplayFormatInEditMode="true"
PropertiesTextEdit-DisplayFormatString="N2" CellStyle-HorizontalAlign="Right"
Width="125" HeaderStyle-HorizontalAlign="Center" ReadOnly="false">
<DataItemTemplate>
<dx:ASPxLabel ID="txbTotalPagado" ClientInstanceName="txbTotalPagado" runat="server"
Text='<%# Bind("total_pagado")%>'>
</dx:ASPxLabel>
</DataItemTemplate>
<EditItemTemplate>
<dx:ASPxTextBox ID="txbTotalPag" Text='<%# Bind("total_pagado")%>' runat="server"
MaxLength="12" Width="150px" DisplayFormatInEditMode="True" DisplayFormatString="N0"
HorizontalAlign="Right">
<ClientSideEvents ValueChanged="function(s, e){ cbckPage.PerformCallback('TP,' + s.GetValue()); }" />
</dx:ASPxTextBox>
</EditItemTemplate>
<PropertiesTextEdit DisplayFormatInEditMode="True" DisplayFormatString="N0">
</PropertiesTextEdit>
<HeaderStyle HorizontalAlign="Center"></HeaderStyle>
<CellStyle HorizontalAlign="Left">
</CellStyle>
</dx:GridViewDataTextColumn>
<dx:GridViewDataDateColumn Caption="Fecha Pago" FieldName="fecha_pago" VisibleIndex="10"
CellStyle-HorizontalAlign="Center" HeaderStyle-HorizontalAlign="Center" Visible="true"
Width="140px">
<PropertiesDateEdit DisplayFormatString="{0:dd/MM/yyyy}">
</PropertiesDateEdit>
<EditItemTemplate>
<%-- <dx:ASPxDateEdit ID="dFecha" runat="server" ClientEnabled="True" Width="150px" Text='<%# DateTime.Now.ToShortDateString() %>'>--%>
<dx:ASPxDateEdit ID="dFecha" runat="server" ClientEnabled="True" Width="150px" Date='<%# Convert.ToDateTime(Eval("fecha_pago"))%>'>
<ClientSideEvents ValueChanged="function(s, e){ cbckPage.PerformCallback('FP,' + s.GetText()); }" />
</dx:ASPxDateEdit>
</EditItemTemplate>
<HeaderStyle HorizontalAlign="Center"></HeaderStyle>
<CellStyle HorizontalAlign="Center">
</CellStyle>
</dx:GridViewDataDateColumn>
<dx:GridViewDataComboBoxColumn Caption="Moneda" FieldName="Moneda" EditCellStyle-HorizontalAlign="Left"
CellStyle-HorizontalAlign="Left" HeaderStyle-HorizontalAlign="Left" VisibleIndex="11"
ReadOnly="false" Width="100">
<EditItemTemplate>
<dx:ASPxComboBox ID="cbxMonedas" runat="server" TextField="sigla" Width="100" ValueField="cod_moneda"
Value='<%# Bind("Moneda") %>' ClientEnabled="false" DataSourceID="objMonedas" SelectedIndex="0">
</dx:ASPxComboBox>
</EditItemTemplate>
<PropertiesComboBox ValueType="System.String" TextField="sigla" ValueField="cod_moneda"
DataSourceID="objMonedas">
</PropertiesComboBox>
<EditCellStyle HorizontalAlign="Left">
</EditCellStyle>
<HeaderStyle HorizontalAlign="Left"></HeaderStyle>
<CellStyle HorizontalAlign="Left">
</CellStyle>
</dx:GridViewDataComboBoxColumn>
<dx:GridViewDataTextColumn Caption="Paridad" VisibleIndex="12" FieldName="ParidadPago"
Width="95" Visible="true" CellStyle-HorizontalAlign="Center" HeaderStyle-HorizontalAlign="Center"
EditCellStyle-HorizontalAlign="Left" ReadOnly="false">
<EditItemTemplate>
<dx:ASPxTextBox ID="txbParidad" runat="server" ClientEnabled="false" Width="150px"
HorizontalAlign="Right" Text='<%# Bind("ParidadPago") %>'>
</dx:ASPxTextBox>
</EditItemTemplate>
<DataItemTemplate>
<dx:ASPxLabel ID="txbParidadPago" ClientInstanceName="tbxParidadPago" runat="server"
Text='<%# Eval("ParidadPago")%>'>
</dx:ASPxLabel>
</DataItemTemplate>
<PropertiesTextEdit DisplayFormatString="N2" DisplayFormatInEditMode="true">
</PropertiesTextEdit>
<HeaderStyle HorizontalAlign="Center"></HeaderStyle>
<CellStyle HorizontalAlign="Center">
</CellStyle>
</dx:GridViewDataTextColumn>
<dx:GridViewDataTextColumn FieldName="fecha_ingreso" ShowInCustomizationForm="True"
Visible="False" VisibleIndex="14">
</dx:GridViewDataTextColumn>
<dx:GridViewDataTextColumn FieldName="cod_tipo_moneda" ShowInCustomizationForm="True"
Visible="False" VisibleIndex="15">
</dx:GridViewDataTextColumn>
<dx:GridViewDataTextColumn FieldName="interes_mora_mc" ShowInCustomizationForm="True"
Visible="False" VisibleIndex="16">
</dx:GridViewDataTextColumn>
<dx:GridViewDataTextColumn FieldName="total_pagado_mc" ShowInCustomizationForm="True"
Visible="False" VisibleIndex="17">
</dx:GridViewDataTextColumn>
<dx:GridViewDataTextColumn FieldName="indice_recibo_impreso" ShowInCustomizationForm="True"
Visible="False" VisibleIndex="18">
</dx:GridViewDataTextColumn>
<dx:GridViewDataTextColumn FieldName="num_recibo_cobranza" ShowInCustomizationForm="True"
Visible="False" VisibleIndex="19">
</dx:GridViewDataTextColumn>
<dx:GridViewDataTextColumn FieldName="corre_pago" ShowInCustomizationForm="True"
Visible="False" VisibleIndex="20">
</dx:GridViewDataTextColumn>
<dx:GridViewDataTextColumn FieldName="cod_error" ShowInCustomizationForm="True" Visible="False"
VisibleIndex="21">
</dx:GridViewDataTextColumn>
<dx:GridViewDataTextColumn FieldName="cod_error_facturacion" ShowInCustomizationForm="True"
Visible="False" VisibleIndex="22">
</dx:GridViewDataTextColumn>
<dx:GridViewDataTextColumn FieldName="origen_pago" ShowInCustomizationForm="True"
Visible="False" VisibleIndex="23">
</dx:GridViewDataTextColumn>
<dx:GridViewDataTextColumn FieldName="emisor" ShowInCustomizationForm="True" Visible="False"
VisibleIndex="24">
</dx:GridViewDataTextColumn>
<dx:GridViewDataTextColumn FieldName="num_factura" ShowInCustomizationForm="True"
Visible="False" VisibleIndex="25">
</dx:GridViewDataTextColumn>
<dx:GridViewDataTextColumn FieldName="correlativo_deuda" ShowInCustomizationForm="True"
Visible="False" VisibleIndex="26">
</dx:GridViewDataTextColumn>
<dx:GridViewDataTextColumn FieldName="correlativo" ShowInCustomizationForm="True"
Visible="False" VisibleIndex="27">
</dx:GridViewDataTextColumn>
<dx:GridViewDataTextColumn FieldName="fecha_modificacion" ShowInCustomizationForm="True"
Visible="False" VisibleIndex="28">
</dx:GridViewDataTextColumn>
<dx:GridViewDataTextColumn FieldName="modificacion" ShowInCustomizationForm="True"
Visible="False" VisibleIndex="29">
</dx:GridViewDataTextColumn>
<dx:GridViewDataTextColumn FieldName="num_docum" ShowInCustomizationForm="True" Visible="False"
VisibleIndex="30">
</dx:GridViewDataTextColumn>
<dx:GridViewDataTextColumn FieldName="envio_contab" ShowInCustomizationForm="True"
Visible="False" VisibleIndex="31">
</dx:GridViewDataTextColumn>
<dx:GridViewDataTextColumn FieldName="estado_cierre" ShowInCustomizationForm="True"
Visible="False" VisibleIndex="32">
</dx:GridViewDataTextColumn>
<dx:GridViewDataTextColumn FieldName="estado" ShowInCustomizationForm="True" Visible="False"
VisibleIndex="33">
</dx:GridViewDataTextColumn>
<dx:GridViewDataTextColumn FieldName="estado_facturacion" ShowInCustomizationForm="True"
Visible="False" VisibleIndex="34">
</dx:GridViewDataTextColumn>
<dx:GridViewDataTextColumn FieldName="rut" ShowInCustomizationForm="True" Visible="False"
VisibleIndex="35">
</dx:GridViewDataTextColumn>
<dx:GridViewDataTextColumn FieldName="ValorCuotaMo" ShowInCustomizationForm="True"
Visible="False" VisibleIndex="36">
</dx:GridViewDataTextColumn>
<dx:GridViewDataTextColumn FieldName="IntMoraPe" ShowInCustomizationForm="True" Visible="False"
VisibleIndex="37">
</dx:GridViewDataTextColumn>
<dx:GridViewDataTextColumn FieldName="TipoPagoIni" ShowInCustomizationForm="True"
Visible="False" VisibleIndex="38">
</dx:GridViewDataTextColumn>
<dx:GridViewDataTextColumn FieldName="tasa_pago" ShowInCustomizationForm="True" Visible="False"
VisibleIndex="39">
</dx:GridViewDataTextColumn>
<dx:GridViewDataTextColumn FieldName="monto_deuda_pe" ShowInCustomizationForm="True"
Visible="False" VisibleIndex="40">
</dx:GridViewDataTextColumn>
<dx:GridViewDataTextColumn FieldName="monto_mo_deuda" ShowInCustomizationForm="True"
Visible="False" VisibleIndex="41">
</dx:GridViewDataTextColumn>
<dx:GridViewDataTextColumn FieldName="cod_tipo_pago" ShowInCustomizationForm="True"
Visible="False" VisibleIndex="42">
</dx:GridViewDataTextColumn>
</Columns>
<SettingsBehavior AllowDragDrop="False" AllowFocusedRow="True" ConfirmDelete="True">
</SettingsBehavior>
<Settings ShowVerticalScrollBar="True" VerticalScrollableHeight="150"></Settings>
<Templates>
<StatusBar>
<div align="right">
<table width="260" border="0" cellpadding="0" cellspacing="0">
<tr align="right">
<td>
<dx:ASPxButton ID="btnEvaluar" runat="server" AutoPostBack="false" ToolTip="Evaluar"
CssClass="boton-full" Text="Evaluar" Image-Url="~/img/icon/report_edit.png" Image-UrlHottracked="~/img/icon/report_edit.png"
Image-UrlPressed="~/img/icon/report_edit.png" EnableTheming="false" EnableDefaultAppearance="false"
Cursor="pointer" Visible="True">
<ClientSideEvents Click="function(s, e){ gvDetPago.PerformCallback('Evaluar'); }" />
</dx:ASPxButton>
</td>
<td>
<dx:ASPxButton ID="btnAgregar" VerticalAlign="Middle" AutoPostBack="false" runat="server"
Visible="true" Cursor="pointer" EnableDefaultAppearance="False" Text="Nuevo"
CssClass="boton-full" EnableTheming="False" ToolTip="Añadir una nueva fila" Image-Url="~/img/icon/application_add.png">
<%--<ClientSideEvents Click="function(s, e){ if(1==2){alert('Acción no implementada')}else{if(confirm('¿Desea ingresar un nuevo registro?')){gvDetPago.AddNewRow();}} }" />--%>
<ClientSideEvents Click="function(s, e){ if(1==2){alert('Acción no implementada')}else{if(confirm('¿Desea ingresar un nuevo registro?')){gvDetPago.PerformCallback('ADD');;}} }" />
</dx:ASPxButton>
</td>
<td>
<dx:ASPxButton ID="btnGrabar" runat="server" AutoPostBack="false" ToolTip="Grabar"
CssClass="boton-full" Text="Grabar" Image-Url="~/img/icon/disk.png" Image-UrlHottracked="~/img/icon/disk.png"
Image-UrlPressed="~/img/icon/disk.png" EnableTheming="false" EnableDefaultAppearance="false"
Cursor="pointer">
<ClientSideEvents Click="function(s, e){ Save(s, e); }" />
</dx:ASPxButton>
</td>
</tr>
</table>
</div>
</StatusBar>
</Templates>
<TotalSummary>
</TotalSummary>
</dx:ASPxGridView>

________________________________________________
.ASPX.CS
________________________________________________

protected void Page_Init(object sender, EventArgs e)
{
odsdet.Selecting += odsdet_Selecting;

cbckPage.Callback += cbckPage_Callback;
objDetallePagos.Selecting += objDetallePagos_Selecting;
cbk.Callback += cbk_Callback;
gvDetPago.CustomCallback += gvDetPago_CustomCallback;
gvDetPago.DataBound += gvDetPago_DataBound;
gvDetPago.CustomSummaryCalculate += gvDetPago_CustomSummaryCalculate;
gvDetPago.RowDeleting += gvDetPago_RowDeleting;
gvDetPago.CellEditorInitialize += gvDetPago_CellEditorInitialize;
gvDetPago.ParseValue += gvDetPago_ParseValue;
gvDetPago.CustomErrorText += gvDetPago_CustomErrorText;
gvDetPago.AfterPerformCallback += gvDetPago_AfterPerformCallback;
gvDetPago.InitNewRow += gvDetPago_InitNewRow;
gvDetPago.RowInserting += gvDetPago_RowInserting;
gvDetPago.RowUpdating += gvDetPago_RowUpdating;
gvDetPago.PageIndexChanged += gvDetPago_PageIndexChanged;

}

void gvDetPago_AfterPerformCallback(object sender, ASPxGridViewAfterPerformCallbackEventArgs e)
{
SetValuesFormat();
SetValuesEditPopUpEditForm();
}

private void SetValuesEditPopUpEditForm()
{
#region TipoCuota
var valueTipoCuota = gvDetPago.GetRowValues(gvDetPago.FocusedRowIndex,
"cod_tipo_cuota");
var ctrlTipoCuota = (ASPxComboBox)
gvDetPago.FindEditRowCellTemplateControl(((GridViewDataColumn)gvDetPago.Columns["cod_tipo_cuota"]),
"cbxTipoCuota");

if (valueTipoCuota != null && ctrlTipoCuota != null)
ctrlTipoCuota.SelectedItem = ctrlTipoCuota.Items.FindByValue(valueTipoCuota.ToString());

#endregion

#region CodConcepto
var valueCodConcepto = gvDetPago.GetRowValues(gvDetPago.FocusedRowIndex,
"cod_concepto");
var ctrlCodconcepto = (ASPxComboBox)
gvDetPago.FindEditRowCellTemplateControl(((GridViewDataColumn)gvDetPago.Columns["cod_concepto"]),
"cbxConcepto");

if (valueCodConcepto != null && ctrlCodconcepto != null)
ctrlCodconcepto.SelectedItem = ctrlCodconcepto.Items.FindByValue(valueCodConcepto);
#endregion

#region Moneda
var valueMoneda = gvDetPago.GetRowValues(gvDetPago.FocusedRowIndex,
"Moneda");
var ctrlMoneda = (ASPxComboBox)
gvDetPago.FindEditRowCellTemplateControl(((GridViewDataColumn)gvDetPago.Columns["Moneda"]),
"cbxMonedas");

if (valueMoneda != null && ctrlMoneda != null)
ctrlMoneda.SelectedItem = ctrlMoneda.Items.FindByValue(valueMoneda);
#endregion

}