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 }