protected void BtnExport_Click(object sender, EventArgs e) { try { Page.Title = ViewState["PageTit"].ToString(); if (DdlPN.Text.Trim().Equals("")) { GrdStokAlma.DataSource = null; GrdStokAlma.DataBind(); return; } DSSM = (DataSet)ViewState["DSSM"]; using (XLWorkbook wb = new XLWorkbook()) { wb.Worksheets.Add(DSSM.Tables[3]); Response.Clear(); Response.Buffer = true; Response.ContentType = "application/ms-excel"; Response.AddHeader("content-disposition", string.Format("attachment;filename={0}.xlsx", ViewState["TitExprtMvts"])); Response.Charset = ""; using (MemoryStream MyMemoryStream = new MemoryStream()) { wb.SaveAs(MyMemoryStream); MyMemoryStream.WriteTo(Response.OutputStream); Response.Flush(); Response.End(); } } } catch (Exception Ex) { string VbcatUs = Session["C77U"].ToString(), VbcatNArc = ViewState["PFileName"].ToString(), VbcatVer = Session["77Version"].ToString(), VbcatAct = Session["77Act"].ToString(); Cnx.UpdateErrorV2(VbcatUs, VbcatNArc, "Exportar Excel Aeronaves", Ex.StackTrace.Substring(Ex.StackTrace.Length > 300 ? Ex.StackTrace.Length - 300 : 0, 300), Ex.Message, VbcatVer, VbcatAct); } }
//**************** Ejecutar *********************************** protected void BindEjecutar() { Idioma = (DataTable)ViewState["TablaIdioma"]; try { if (DdlPN.Text.Trim().Equals("")) { GrdStokAlma.DataSource = null; GrdStokAlma.DataBind(); return; } Cnx.SelecBD(); using (SqlConnection sqlConB = new SqlConnection(Cnx.GetConex())) { string VbPn = DdlPN.Text.Trim(); string VbSn = DdlSN.Text.Trim(); string VbLot = DdlLote.Text.Trim(); if (CkbAlterno.Checked == true) { VbPn = ""; VbSn = ""; VbLot = ""; } CsTypExportarIdioma CursorIdioma = new CsTypExportarIdioma(); CursorIdioma.Alimentar("CURDATOSCONSULTA1", Session["77IDM"].ToString().Trim()); string VbTxtSql = "EXEC SP_TablasLogistica 5, @Rf,@Pn,@Sn,@Lt,'','','','','CURDATOSCONSULTA1',0,0,@ExpVlr,1,@Idm,@ICC,'01-01-1','02-01-1','03-01-1'"; sqlConB.Open(); using (SqlCommand SC = new SqlCommand(VbTxtSql, sqlConB)) { SC.Parameters.AddWithValue("@Rf", ViewState["CodReferencia"]); SC.Parameters.AddWithValue("@Pn", VbPn); SC.Parameters.AddWithValue("@Sn", VbSn); SC.Parameters.AddWithValue("@Lt", VbLot); SC.Parameters.AddWithValue("@ExpVlr", ViewState["VblCE4"]); SC.Parameters.AddWithValue("@Idm", Session["77IDM"]); SC.Parameters.AddWithValue("@ICC", Session["!dC!@"]); using (SqlDataAdapter SDA = new SqlDataAdapter()) { using (DataSet DSSM = new DataSet()) { SDA.SelectCommand = SC; SDA.Fill(DSSM); DSSM.Tables[0].TableName = "Stock"; DSSM.Tables[1].TableName = "StockActual"; DSSM.Tables[2].TableName = "Mvtos"; DSSM.Tables[3].TableName = "Exprtr"; ViewState["DSSM"] = DSSM; GrdStokAlma.DataSource = DSSM.Tables[0]; GrdStokAlma.DataBind(); TxtStockActual.Text = DSSM.Tables[1].Rows[0]["CantTtl"].ToString().Trim(); GrdMvtos.DataSource = DSSM.Tables[2]; GrdMvtos.DataBind(); } } } } } catch (Exception Ex) { DataRow[] Result = Idioma.Select("Objeto= 'MensIncovCons'"); foreach (DataRow row in Result) { ScriptManager.RegisterClientScriptBlock(this.Page, this.Page.GetType(), "alert", "alert('" + row["Texto"].ToString() + "');", true); } // Cnx.UpdateErrorV2(Session["C77U"].ToString(), ViewState["PFileName"].ToString().Trim(), "UPDATE Detalle PPT", Ex.StackTrace.Substring(Ex.StackTrace.Length > 300 ? Ex.StackTrace.Length - 300 : 0, 300), Ex.Message, Session["77Version"].ToString(), Session["77Act"].ToString()); } }
protected void BindBusPn(string PN) { DSTPSL = (DataSet)ViewState["DSTPSL"]; DataRow[] DR; DataTable DT = new DataTable(); GrdAlterno.DataSource = null; GrdAlterno.DataBind(); GrdStokAlma.DataSource = null; GrdStokAlma.DataBind(); GrdMvtos.DataSource = null; GrdMvtos.DataBind(); DR = DSTPSL.Tables[0].Select("Codigo ='" + PN + "'"); if (Cnx.ValidaDataRowVacio(DR)) { DT = DR.CopyToDataTable(); TxtTipo.Text = DT.Rows[0]["DescTipo"].ToString().Trim(); TxtDescrPn.Text = DT.Rows[0]["Descripcion"].ToString().Trim(); ViewState["CodReferencia"] = DT.Rows[0]["CodReferencia"].ToString().Trim(); LblTitAlterno.Text = ViewState["IdimaPnALter"].ToString().Trim() + " [" + ViewState["CodReferencia"] + "]"; switch (DT.Rows[0]["Identf"].ToString().Trim()) { case "SN": DR = DSTPSL.Tables[1].Select("PN ='" + PN + "' OR Codigo = ''"); if (Cnx.ValidaDataRowVacio(DR)) { DT = DR.CopyToDataTable(); DdlSN.DataSource = DT; DdlSN.DataTextField = "SN"; DdlSN.DataValueField = "Codigo"; } else { DdlSN.DataSource = null; } DdlSN.DataBind(); DR = DSTPSL.Tables[2].Select("Codigo = ''"); if (Cnx.ValidaDataRowVacio(DR)) { DT = DR.CopyToDataTable(); DdlLote.DataSource = DT; DdlLote.DataTextField = "LOTE"; DdlLote.DataValueField = "Codigo"; DdlLote.DataBind(); } break; case "LOTE": DR = DSTPSL.Tables[2].Select("PN ='" + PN + "' OR Codigo = ''"); if (Cnx.ValidaDataRowVacio(DR)) { DT = DR.CopyToDataTable(); DdlLote.DataSource = DT; DdlLote.DataTextField = "LOTE"; DdlLote.DataValueField = "Codigo"; } else { DdlLote.DataSource = null; } DdlLote.DataBind(); DR = DSTPSL.Tables[1].Select("Codigo = ''"); if (Cnx.ValidaDataRowVacio(DR)) { DT = DR.CopyToDataTable(); DdlSN.DataSource = DT; DdlSN.DataTextField = "SN"; DdlSN.DataValueField = "Codigo"; DdlSN.DataBind(); } break; default: DR = DSTPSL.Tables[2].Select("Codigo = ''"); if (Cnx.ValidaDataRowVacio(DR)) { DT = DR.CopyToDataTable(); DdlLote.DataSource = DT; DdlLote.DataTextField = "LOTE"; DdlLote.DataValueField = "Codigo"; DdlLote.DataBind(); } DR = DSTPSL.Tables[1].Select("Codigo = ''"); if (Cnx.ValidaDataRowVacio(DR)) { DT = DR.CopyToDataTable(); DdlSN.DataSource = DT; DdlSN.DataTextField = "SN"; DdlSN.DataValueField = "Codigo"; DdlSN.DataBind(); } break; } Cnx.SelecBD(); using (SqlConnection sqlConB = new SqlConnection(Cnx.GetConex())) { string VbTxtSql = "EXEC SP_PANTALLA_ConsultaMovimiento 14,@CRf,'','','',0,0,@Idm,@ICC,'01-1-2009','01-01-1900','01-01-1900'"; sqlConB.Open(); using (SqlCommand SC = new SqlCommand(VbTxtSql, sqlConB)) { SC.Parameters.AddWithValue("@CRf", ViewState["CodReferencia"]); SC.Parameters.AddWithValue("@Idm", Session["77IDM"]); SC.Parameters.AddWithValue("@ICC", Session["!dC!@"]); using (SqlDataAdapter SDA = new SqlDataAdapter()) { using (DataTable DTA = new DataTable()) { SDA.SelectCommand = SC; SDA.Fill(DTA); GrdAlterno.DataSource = DTA; GrdAlterno.DataBind(); } } } } } }