protected void btnExportExcel_Click(object sender, System.EventArgs e)
{
//Dim cadenaHtml1 As String = ""
//Dim tw As New System.IO.StringWriter
//Dim hw As New System.Web.UI.HtmlTextWriter(tw)
//Dim cadena As String
//cadena = txtDate1.Text & "a" & txtDate2.Text
//'FILTRO_EXCEL()
//Response.Clear()
//Response.Charset = ""
//Response.Buffer = True
//Response.ContentType = "application/vnd.ms-excel"
//cadena = ""
//Response.AddHeader("content-disposition", "attachment;filename=INF_RESUMEN_DEVOLUCION_" & cadena & ".xls")
//Response.ContentEncoding = System.Text.Encoding.Default
//'Grilla_Excel_Factura.RenderControl(hw)
//'GrillaBoleta.RenderControl(hw)
//cadenaHtml1 = HTML_Excel()
//'Response.Write(tw.ToString())
//Response.Write(cadenaHtml1)
//Response.End()
string cadenaHtml = "";
cadenaHtml = cadenaHtml + "<table border='1'><tr>";
cadenaHtml = cadenaHtml + "<td colspan='8' align='center'>";
cadenaHtml = cadenaHtml + "<h3>MANTENEDOR OPERADORES</h3>";
cadenaHtml = cadenaHtml + "</td>";
cadenaHtml = cadenaHtml + "</tr></table>";
cadenaHtml = cadenaHtml + "</table>";
cadenaHtml = cadenaHtml + "<br></br>";
cadenaHtml = cadenaHtml + "<br></br>";
//Call componeHTMLFrac(cadenaHtml)
Response.Clear();
Response.Charset = "";
Response.Buffer = true;
Response.ContentType = "application/vnd.ms-excel";
Response.AddHeader("content-disposition", "attachment;filename=AsignacionOT.xls");
Response.ContentEncoding = System.Text.Encoding.Default;
//If comboExcel.SelectedIndex = 0 Then 'Excel 97-2000
// 'Response.ContentEncoding = System.Text.Encoding.UTF7
//ElseIf comboExcel.SelectedIndex = 1 Then ' Excel 2003 - 2007
// Response.ContentEncoding = System.Text.Encoding.UTF8
//Else
// Response.ContentEncoding = System.Text.Encoding.UTF7
//End If
//Response.ContentEncoding = System.Text.Encoding.UTF7
Response.Write(cadenaHtml);
System.IO.StringWriter tw = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(tw);
GrillaCortadores_temp.Visible = true;
GrillaCortadores_temp.RenderControl(hw);
Response.Write(tw.ToString());
Response.End();
// GrillaAnalisisLect_TEMP.Visible = False
GrillaCortadores_temp.Visible = false;
}
public void carga_lectores(String RutDeEmpresa)
{
OracleConnection CnOra = new OracleConnection(conexion_cliente_oracle);
OracleCommand cmdAcceso = new OracleCommand("PK_INSTALADOR.CARGA_INSTALADOR_X_EMPRESA", CnOra);
OracleDataAdapter da = new OracleDataAdapter(cmdAcceso);
PRO.agrega_parametro_sp(da, "o_cursor", OracleType.Cursor, ParameterDirection.Output, "");
PRO.agrega_parametro_sp(da, "i_rut_empresa", OracleType.Number, ParameterDirection.Input, RutDeEmpresa);
da.SelectCommand.CommandType = CommandType.StoredProcedure;
CnOra.Open();
DataTable dtLectores = new DataTable();
da.Fill(dtLectores);
CnOra.Close();
CnOra.Dispose();
dt = new DataTable();
dt.Columns.Add(new DataColumn("id_instalador", typeof(string)));
dt.Columns.Add(new DataColumn("id_region", typeof(string)));
dt.Columns.Add(new DataColumn("id_zona", typeof(string)));
dt.Columns.Add(new DataColumn("rut_empresa", typeof(string)));
dt.Columns.Add(new DataColumn("cod_instalador", typeof(string)));
dt.Columns.Add(new DataColumn("apellido", typeof(string)));
dt.Columns.Add(new DataColumn("nombre", typeof(string)));
dt.Columns.Add(new DataColumn("nom_empresa", typeof(string)));
dt.Columns.Add(new DataColumn("clave_admin", typeof(string)));
dt.Columns.Add(new DataColumn("clave_instalador", typeof(string)));
dt.Columns.Add(new DataColumn("estado", typeof(string)));
dt.Columns.Add(new DataColumn("version", typeof(string)));
dt.Columns.Add(new DataColumn("cantidad", typeof(string)));
dt.Columns.Add(new DataColumn("fotografia", typeof(string)));
dt.Columns.Add(new DataColumn("numero_telefono", typeof(string)));
dt.Columns.Add(new DataColumn("serie_maquina", typeof(string)));
dt.Columns.Add(new DataColumn("id_modelo", typeof(string)));
dt.Columns.Add(new DataColumn("id_contratista", typeof(string)));
dt.Columns.Add(new DataColumn("descripcion", typeof(string)));
DataRow dr = null;
int cont_registros = 0;
cont_registros = 0;
foreach (System.Data.DataRow drLectorItem in dtLectores.Rows)
{
dr = dt.NewRow();
dr["id_instalador"] = drLectorItem["id_instalador"].ToString();
dr["id_region"] = drLectorItem["id_region"].ToString();
dr["id_zona"] = drLectorItem["id_zona"].ToString();
dr["rut_empresa"] = drLectorItem["rut_empresa"].ToString();
dr["cod_instalador"] = drLectorItem["cod_instalador"].ToString();
dr["apellido"] = drLectorItem["apellido"].ToString().ToUpper();
dr["nombre"] = drLectorItem["nombre"].ToString().ToUpper();
dr["nom_empresa"] = Convert.ToString(OBTIENE_NOMBRE_EMPRESA(drLectorItem["rut_empresa"].ToString())).ToUpper(); //"Empresa" 'Funcion que entrege Empresa 'drUsuarioItem("nom_empresa").ToString
dr["clave_admin"] = drLectorItem["clave_admin"].ToString();
dr["clave_instalador"] = drLectorItem["clave_instalador"].ToString();
//dr("estado") = drLectorItem("estado").ToString
if (drLectorItem["estado"].ToString() == "0")
{
dr["estado"] = "ACTIVO";
}
else
{
dr["estado"] = "INACTIVO";
}
dr["version"] = drLectorItem["version"].ToString().ToUpper();
dr["cantidad"] = drLectorItem["cantidad"].ToString();
if (drLectorItem["fotografia"].ToString() == 0.ToString())
{
dr["fotografia"] = "SIN FOTOGRAFIA";
}
else
{
dr["fotografia"] = "CON FOTOGRAFIA";
}
if (string.IsNullOrEmpty(drLectorItem["numero_telefono"].ToString()))
{
dr["numero_telefono"] = "Sin Datos";
}
else
{
dr["numero_telefono"] = drLectorItem["numero_telefono"].ToString();
}
if (string.IsNullOrEmpty(drLectorItem["serie_maquina"].ToString()))
{
dr["serie_maquina"] = "Sin Datos";
}
else
{
dr["serie_maquina"] = drLectorItem["serie_maquina"].ToString();
}
//dr("id_modelo") = drLectorItem("id_modelo").ToString
object VARIABLE_TEMPORAL_MODELO = null;
VARIABLE_TEMPORAL_MODELO = obtener_nombre_modelo(drLectorItem["id_modelo"].ToString());
if (VARIABLE_TEMPORAL_MODELO.ToString() == "ERROR")
{
dr["id_modelo"] = "Sin Datos";
}
else
{
dr["id_modelo"] = VARIABLE_TEMPORAL_MODELO;
}
dr["id_contratista"] = drLectorItem["id_contratista"].ToString();
dr["descripcion"] = drLectorItem["descripcion"].ToString();
dt.Rows.Add(dr);
cont_registros = cont_registros + 1;
}
lb_cantidad_registros.Text = cont_registros.ToString() + " coincidencia(s) encontrada(s)";
DataView MydataView = null;
MydataView = new DataView(dt);
GrillaCortadores.DataSource = MydataView;
GrillaCortadores.DataBind();
GrillaCortadores_temp.DataSource = MydataView;
GrillaCortadores_temp.DataBind();
//INICIO: Control de Estado de Cortadores
DataGridItem GridItem = null;
int c = 0;
for (c = 0; c < GrillaCortadores.Items.Count; c++)
{
GridItem = GrillaCortadores.Items[c];
if (GridItem.Cells[10].Text == "ACTIVO")
{
GridItem.Cells[10].ForeColor = System.Drawing.Color.DarkGreen;
GridItem.Cells[10].BorderColor = System.Drawing.Color.Black;
}
if (GridItem.Cells[10].Text == "INACTIVO")
{
GridItem.Cells[20].Text = "";
GridItem.Cells[10].ForeColor = System.Drawing.Color.Red;
GridItem.Cells[10].BorderColor = System.Drawing.Color.Black;
}
}
//FIN: Control de Estado de Cortadores
}
