protected void IdiomaControles() { Idioma.Columns.Add("Objeto", typeof(string)); Idioma.Columns.Add("Texto", typeof(string)); using (SqlConnection sqlCon = new SqlConnection(Cnx.BaseDatosPrmtr())) { string LtxtSql = "EXEC Idioma @I,@F1,@F2,@F3,@F4"; SqlCommand SC = new SqlCommand(LtxtSql, sqlCon); SC.Parameters.AddWithValue("@I", Session["77IDM"].ToString().Trim()); SC.Parameters.AddWithValue("@F1", ViewState["PFileName"]); SC.Parameters.AddWithValue("@F2", ""); SC.Parameters.AddWithValue("@F3", ""); SC.Parameters.AddWithValue("@F4", ""); sqlCon.Open(); SqlDataReader tbl = SC.ExecuteReader(); while (tbl.Read()) //Todos los objetos { string bO = tbl["Objeto"].ToString().Trim(); string bT = tbl["Texto"].ToString().Trim(); Idioma.Rows.Add(bO, bT); if (bO.Equals("Caption")) { Page.Title = bT; ViewState["PageTit"] = bT; } TitForm.Text = bO.Equals("Titulo") ? bT : TitForm.Text; LblTitAlrt.Text = bO.Equals("Titulo") ? bT : LblTitAlrt.Text; LblTitAlertaSPRp.Text = bO.Equals("LblTitAlertaSPRp") ? bT : LblTitAlertaSPRp.Text; GrdAlrta.EmptyDataText = bO.Equals("SinRegistros") ? bT : GrdAlrta.EmptyDataText; GrdAlrta.Columns[0].HeaderText = bO.Equals("PedidoMstr") ? bT : GrdAlrta.Columns[0].HeaderText; GrdAlrta.Columns[1].HeaderText = bO.Equals("ReferenciaMst") ? bT : GrdAlrta.Columns[1].HeaderText; GrdAlrta.Columns[4].HeaderText = bO.Equals("Descripcion") ? bT : GrdAlrta.Columns[4].HeaderText; GrdAlrta.Columns[5].HeaderText = bO.Equals("CantMst") ? bT : GrdAlrta.Columns[5].HeaderText; GrdAlrta.Columns[6].HeaderText = bO.Equals("FechaMstr") ? bT : GrdAlrta.Columns[6].HeaderText; GrdAlrta.Columns[7].HeaderText = bO.Equals("GrdFechaAprob") ? bT : GrdAlrta.Columns[7].HeaderText; GrdAlrta.Columns[8].HeaderText = bO.Equals("LblUsrMstr") ? bT : GrdAlrta.Columns[8].HeaderText; GrdAlrta.Columns[9].HeaderText = bO.Equals("GrdPPt") ? bT : GrdAlrta.Columns[9].HeaderText; BtnExportarModl.Text = bO.Equals("BtnExportMstr") ? bT : BtnExportarModl.Text; BtnCerrarAlerta.Text = bO.Equals("BtnCerrarMst") ? bT : BtnCerrarAlerta.Text; } sqlCon.Close(); ViewState["TablaIdioma"] = Idioma; } }
protected void IdiomaControles() { Idioma.Columns.Add("Objeto", typeof(string)); Idioma.Columns.Add("Texto", typeof(string)); using (SqlConnection sqlCon = new SqlConnection(Cnx.BaseDatosPrmtr())) { string LtxtSql = "EXEC Idioma @I,@F1,@F2,@F3,@F4"; SqlCommand SC = new SqlCommand(LtxtSql, sqlCon); SC.Parameters.AddWithValue("@I", Session["77IDM"].ToString().Trim()); SC.Parameters.AddWithValue("@F1", ViewState["PFileName"]); SC.Parameters.AddWithValue("@F2", ""); SC.Parameters.AddWithValue("@F3", ""); SC.Parameters.AddWithValue("@F4", ""); sqlCon.Open(); SqlDataReader tbl = SC.ExecuteReader(); while (tbl.Read()) //Todos los objetos { string bO = tbl["Objeto"].ToString().Trim(); string bT = tbl["Texto"].ToString().Trim(); Idioma.Rows.Add(bO, bT); if (bO.Equals("Caption")) { Page.Title = bT; ViewState["PageTit"] = bT; } TitForm.Text = bO.Equals("Titulo") ? bT : TitForm.Text; LblMes.Text = bO.Equals("LblMes") ? bT : LblMes.Text; LblAno.Text = bO.Equals("LblAno") ? bT : LblAno.Text; BtnCierreM.Text = bO.Equals("BtnCierreM") ? bT : BtnCierreM.Text; LblTitActPer.Text = bO.Equals("LblTitActPer") ? bT : LblTitActPer.Text; GrdDatos.Columns[0].HeaderText = bO.Equals("CkbActivo") ? bT : GrdDatos.Columns[0].HeaderText; GrdDatos.Columns[1].HeaderText = bO.Equals("GrdM") ? bT : GrdDatos.Columns[1].HeaderText; GrdDatos.Columns[2].HeaderText = bO.Equals("GrdA") ? bT : GrdDatos.Columns[2].HeaderText; } DataRow[] Result = Idioma.Select("Objeto= 'Mens01CCConf'"); foreach (DataRow row in Result) { BtnCierreM.OnClientClick = string.Format("return confirm('" + row["Texto"].ToString().Trim() + "');"); } //Desea realizar el cierre contable? sqlCon.Close(); ViewState["TablaIdioma"] = Idioma; } }
protected void IdiomaControles() { Idioma.Columns.Add("Objeto", typeof(string)); Idioma.Columns.Add("Texto", typeof(string)); using (SqlConnection sqlCon = new SqlConnection(Cnx.BaseDatosPrmtr())) { string LtxtSql = "EXEC Idioma @I,@F1,@F2,@F3,@F4"; SqlCommand SC = new SqlCommand(LtxtSql, sqlCon); SC.Parameters.AddWithValue("@I", Session["77IDM"].ToString().Trim()); SC.Parameters.AddWithValue("@F1", ViewState["PFileName"]); SC.Parameters.AddWithValue("@F2", ""); SC.Parameters.AddWithValue("@F3", ""); SC.Parameters.AddWithValue("@F4", ""); sqlCon.Open(); SqlDataReader tbl = SC.ExecuteReader(); while (tbl.Read()) //Todos los objetos { string bO = tbl["Objeto"].ToString().Trim(); string bT = tbl["Texto"].ToString().Trim(); Idioma.Rows.Add(bO, bT); if (bO.Equals("Caption")) { Page.Title = bT; ViewState["PageTit"] = bT; } TitForm.Text = bO.Equals("Titulo") ? bT : TitForm.Text; LblBusqueda.Text = bO.Equals("MstrLblBusq") ? bT + ":" : LblBusqueda.Text; if (bO.Equals("placeholder")) { TxtBusqueda.Attributes.Add("placeholder", bT); } IbtConsultar.ToolTip = bO.Equals("IbtConsultarTTMst") ? bT : IbtConsultar.ToolTip; LblTitDatos.Text = bO.Equals("Titulo") ? bT : LblTitDatos.Text; GrdDatos.Columns[0].HeaderText = bO.Equals("GrdCod") ? bT : GrdDatos.Columns[0].HeaderText; GrdDatos.Columns[1].HeaderText = bO.Equals("GrdDesc") ? bT : GrdDatos.Columns[1].HeaderText; LblTitContAsig.Text = bO.Equals("LblTitContAsig") ? bT : LblTitContAsig.Text; GrdContdr.Columns[0].HeaderText = bO.Equals("GrdCntd") ? bT : GrdContdr.Columns[0].HeaderText; } sqlCon.Close(); ViewState["TablaIdioma"] = Idioma; } }
protected void IdiomaControles() { Idioma.Columns.Add("Objeto", typeof(string)); Idioma.Columns.Add("Texto", typeof(string)); using (SqlConnection sqlCon = new SqlConnection(Cnx.BaseDatosPrmtr())) { string LtxtSql = "EXEC Idioma @I,@F1,@F2,@F3,@F4"; SqlCommand SC = new SqlCommand(LtxtSql, sqlCon); SC.Parameters.AddWithValue("@I", Session["77IDM"].ToString().Trim()); SC.Parameters.AddWithValue("@F1", ViewState["PFileName"]); SC.Parameters.AddWithValue("@F2", ""); SC.Parameters.AddWithValue("@F3", ""); SC.Parameters.AddWithValue("@F4", ""); sqlCon.Open(); SqlDataReader tbl = SC.ExecuteReader(); while (tbl.Read()) //Todos los objetos { string bO = tbl["Objeto"].ToString().Trim(); string bT = tbl["Texto"].ToString().Trim(); Idioma.Rows.Add(bO, bT); if (bO.Equals("Caption")) { Page.Title = bT; ViewState["PageTit"] = bT; } TitForm.Text = bO.Equals("Titulo") ? bT : TitForm.Text; BtnReparaciones.Text = bO.Equals("BtnReparaciones") ? bT : BtnReparaciones.Text; LblTitReparaciones.Text = bO.Equals("BtnReparaciones") ? bT : LblTitReparaciones.Text; BtnReparaciones.ToolTip = bO.Equals("BtnReparacionesTT") ? bT : BtnReparaciones.ToolTip; IbtCerrarImpr.ToolTip = bO.Equals("CerrarVentana") ? bT : IbtCerrarImpr.ToolTip; LblTitReparaciones.Text = bO.Equals("BtnReparaciones") ? bT : LblTitReparaciones.Text; LblFechI.Text = bO.Equals("LblFechI") ? bT : LblFechI.Text; LblFechF.Text = bO.Equals("LblFechF") ? bT : LblFechF.Text; IbtExcelRepa.ToolTip = bO.Equals("BtnExportMstr") ? bT : IbtExcelRepa.ToolTip; } sqlCon.Close(); ViewState["TablaIdioma"] = Idioma; } }
protected void IdiomaControles() { Idioma.Columns.Add("Objeto", typeof(string)); Idioma.Columns.Add("Texto", typeof(string)); using (SqlConnection sqlCon = new SqlConnection(Cnx.BaseDatosPrmtr())) { string LtxtSql = "EXEC Idioma @I,@F1,@F2,@F3,@F4"; SqlCommand SC = new SqlCommand(LtxtSql, sqlCon); SC.Parameters.AddWithValue("@I", Session["77IDM"].ToString().Trim()); SC.Parameters.AddWithValue("@F1", "FRMCICLOSESPECIALMOTOR"); SC.Parameters.AddWithValue("@F2", ""); SC.Parameters.AddWithValue("@F3", ""); SC.Parameters.AddWithValue("@F4", ""); sqlCon.Open(); SqlDataReader tbl = SC.ExecuteReader(); while (tbl.Read()) //Todos los objetos { string bO = tbl["Objeto"].ToString().Trim(); string bT = tbl["Texto"].ToString().Trim(); Idioma.Rows.Add(bO, bT); if (bO.Equals("Caption")) { Page.Title = bT; ViewState["PageTit"] = bT; } TitForm.Text = bO.Equals("LblTituloCiDis") ? bT : TitForm.Text; BtnAlaF.Text = bO.Equals("BtnAlaF") ? bT : BtnAlaF.Text; BtnAlaR.Text = bO.Equals("BtnAlaR") ? bT : BtnAlaR.Text; GrdDatos.Columns[0].HeaderText = bO.Equals("GrdMtr") ? bT : GrdDatos.Columns[0].HeaderText; GrdDatos.Columns[1].HeaderText = bO.Equals("GrdSubCmpn") ? bT : GrdDatos.Columns[1].HeaderText; GrdDatos.Columns[2].HeaderText = bO.Equals("GrdClEquiv") ? bT : GrdDatos.Columns[2].HeaderText; GrdAR.Columns[0].HeaderText = bO.Equals("GrdMtr") ? bT : GrdAR.Columns[0].HeaderText; GrdAR.Columns[1].HeaderText = bO.Equals("GrdSubCmpn") ? bT : GrdAR.Columns[1].HeaderText; GrdAR.Columns[2].HeaderText = bO.Equals("GrdDesc") ? bT : GrdAR.Columns[2].HeaderText; } sqlCon.Close(); ViewState["TablaIdioma"] = Idioma; } }
protected void IdiomaControles() { Idioma.Columns.Add("Objeto", typeof(string)); Idioma.Columns.Add("Texto", typeof(string)); using (SqlConnection sqlCon = new SqlConnection(Cnx.BaseDatosPrmtr())) { string LtxtSql = "EXEC Idioma @I,@F1,@F2,@F3,@F4"; SqlCommand SC = new SqlCommand(LtxtSql, sqlCon); SC.Parameters.AddWithValue("@I", Session["77IDM"].ToString().Trim()); SC.Parameters.AddWithValue("@F1", "0"); SC.Parameters.AddWithValue("@F2", ""); SC.Parameters.AddWithValue("@F3", ""); SC.Parameters.AddWithValue("@F4", ""); sqlCon.Open(); SqlDataReader tbl = SC.ExecuteReader(); while (tbl.Read()) //Todos los objetos { string b1 = tbl["Objeto"].ToString(); string b2 = tbl["Texto"].ToString(); Idioma.Rows.Add(tbl["Objeto"].ToString(), tbl["Texto"].ToString()); IbnSalir.ToolTip = b1.Trim().Equals("IbnSalir") ? b2.Trim() : IbnSalir.ToolTip; LkbCambPass.Text = b1.Trim().Equals("LkbCambPass") ? b2.Trim() : LkbCambPass.Text; LkbMenu.Text = b1.Trim().Equals("LkbMenu") ? b2.Trim() : LkbMenu.Text; } DataRow[] Result = Idioma.Select("Objeto= 'IbnSalirOnClick'"); foreach (DataRow row in Result) { IbnSalir.OnClientClick = string.Format("return confirm('" + row["Texto"].ToString().Trim() + "');"); } DataRow[] Result1 = Idioma.Select("Objeto= 'LkbCambPassOnClick'"); foreach (DataRow row in Result1) { LkbCambPass.OnClientClick = string.Format("return confirm('" + row["Texto"].ToString().Trim() + "');"); } /**/ ViewState["TablaIdioma"] = Idioma; } }
protected void IdiomaControles() { Idioma.Columns.Add("Objeto", typeof(string)); Idioma.Columns.Add("Texto", typeof(string)); using (SqlConnection sqlCon = new SqlConnection(Cnx.BaseDatosPrmtr())) { string LtxtSql = "EXEC Idioma @I,@F1,@F2,@F3,@F4"; SqlCommand SC = new SqlCommand(LtxtSql, sqlCon); SC.Parameters.AddWithValue("@I", Session["77IDM"].ToString().Trim()); SC.Parameters.AddWithValue("@F1", "FrmAcceso"); SC.Parameters.AddWithValue("@F2", ""); SC.Parameters.AddWithValue("@F3", ""); SC.Parameters.AddWithValue("@F4", ""); sqlCon.Open(); SqlDataReader tbl = SC.ExecuteReader(); while (tbl.Read()) //Todos los objetos { string b1 = tbl["Objeto"].ToString(); string b2 = tbl["Texto"].ToString(); Idioma.Rows.Add(tbl["Objeto"].ToString(), tbl["Texto"].ToString()); TbnIngresar.Text = b1.Trim().Equals("BtnAcceder") ? b2.Trim() : TbnIngresar.Text; TitConfirmarC.Text = b1.Trim().Equals("TitConfirmarC") ? b2.Trim() : TitConfirmarC.Text; if (b1.Trim().Equals("placeholderNew")) { TxtNuevoPass.Attributes.Add("placeholder", b2.Trim()); } if (b1.Trim().Equals("placeholderConf")) { TxtConfirmarPass.Attributes.Add("placeholder", b2.Trim()); } BtnCambioPass.Text = b1.Trim().Equals("BtnCambioPass") ? b2.Trim() : BtnCambioPass.Text; TitForm.Text = b1.Trim().Equals("CaptionCambioPas") ? b2.Trim() : TitForm.Text; } ViewState["TablaIdioma"] = Idioma; } }
protected void IdiomaControles() { Idioma.Columns.Add("Objeto", typeof(string)); Idioma.Columns.Add("Texto", typeof(string)); using (SqlConnection sqlCon = new SqlConnection(Cnx.BaseDatosPrmtr())) { string LtxtSql = "EXEC Idioma @I,@F1,@F2,@F3,@F4"; SqlCommand SC = new SqlCommand(LtxtSql, sqlCon); SC.Parameters.AddWithValue("@I", Session["77IDM"].ToString().Trim()); SC.Parameters.AddWithValue("@F1", ViewState["PFileName"]); SC.Parameters.AddWithValue("@F2", ""); SC.Parameters.AddWithValue("@F3", ""); SC.Parameters.AddWithValue("@F4", ""); sqlCon.Open(); SqlDataReader tbl = SC.ExecuteReader(); while (tbl.Read()) //Todos los objetos { string bO = tbl["Objeto"].ToString().Trim(); string bT = tbl["Texto"].ToString().Trim(); Idioma.Rows.Add(bO, bT); if (bO.Equals("Caption")) { Page.Title = bT; ViewState["PageTit"] = bT; } TitForm.Text = bO.Equals("Caption") ? bT : TitForm.Text; LblAk.Text = bO.Equals("LblAk") ? bT + ":" : LblAk.Text; BtnConsultar.Text = bO.Equals("BtnConsultar") ? bT : BtnConsultar.Text; LblFechI.Text = bO.Equals("LblFechI") ? bT + ":" : LblFechI.Text; LblFechF.Text = bO.Equals("LblFechF") ? bT + ":" : LblFechF.Text; GrdHistor.Columns[0].HeaderText = bO.Equals("GrdPrcs") ? bT : GrdHistor.Columns[0].HeaderText; GrdHistor.Columns[1].HeaderText = bO.Equals("LblAk") ? bT : GrdHistor.Columns[1].HeaderText; GrdHistor.Columns[4].HeaderText = bO.Equals("GrdMyr") ? bT : GrdHistor.Columns[4].HeaderText; GrdHistor.Columns[5].HeaderText = bO.Equals("GrdSbC") ? bT : GrdHistor.Columns[5].HeaderText; GrdHistor.Columns[6].HeaderText = bO.Equals("GrdDesc") ? bT : GrdHistor.Columns[6].HeaderText; GrdHistor.Columns[7].HeaderText = bO.Equals("GrdFecEv") ? bT : GrdHistor.Columns[7].HeaderText; GrdHistor.Columns[8].HeaderText = bO.Equals("GrdPosc") ? bT : GrdHistor.Columns[8].HeaderText; GrdHistor.Columns[9].HeaderText = bO.Equals("GrdUbTec") ? bT : GrdHistor.Columns[9].HeaderText; GrdHistor.Columns[10].HeaderText = bO.Equals("GrdEve") ? bT : GrdHistor.Columns[10].HeaderText; GrdHistor.Columns[11].HeaderText = bO.Equals("GrdMtvo") ? bT : GrdHistor.Columns[11].HeaderText; GrdHistor.Columns[12].HeaderText = bO.Equals("GrdFecMvt") ? bT : GrdHistor.Columns[12].HeaderText; GrdHistor.EmptyDataText = bO.Equals("SinRegistros") ? bT : GrdHistor.EmptyDataText; //**************** Procesar un elemento **************************** IbtCerrarProces.ToolTip = bO.Equals("CerrarVentana") ? bT : IbtCerrarProces.ToolTip; LblTitHisC1Aplicab.Text = bO.Equals("LblTitHisC1Aplicab") ? bT : LblTitHisC1Aplicab.Text; LblHkProcs.Text = bO.Equals("LblAk") ? bT : LblHkProcs.Text; LblFechMyr.Text = bO.Equals("LblFechMyr") ? bT : LblFechMyr.Text; LblFechHast.Text = bO.Equals("LblFechHast") ? bT : LblFechHast.Text; LblContador.Text = bO.Equals("LblContador") ? bT : LblContador.Text; BtnPrcsCont.Text = bO.Equals("GrdPrcs") ? bT : BtnPrcsCont.Text; GrdProcesar.Columns[0].HeaderText = bO.Equals("GrdPrFech") ? bT : GrdProcesar.Columns[0].HeaderText; GrdProcesar.Columns[1].HeaderText = bO.Equals("GrdPrcsIndiv") ? bT : GrdProcesar.Columns[1].HeaderText; GrdProcesar.Columns[2].HeaderText = bO.Equals("GrPrcsAcum") ? bT : GrdProcesar.Columns[2].HeaderText; GrdProcesar.Columns[3].HeaderText = bO.Equals("GrdPrcsLv") ? bT : GrdProcesar.Columns[3].HeaderText; GrdProcesar.EmptyDataText = bO.Equals("SinRegistros") ? bT : GrdProcesar.EmptyDataText; } DataRow[] Result1 = Idioma.Select("Objeto= 'BtnPrcsContOnC'"); foreach (DataRow row in Result1) { BtnPrcsCont.OnClientClick = string.Format("return confirm('" + row["Texto"].ToString().Trim() + "');"); } sqlCon.Close(); ViewState["TablaIdioma"] = Idioma; } }
protected void IdiomaControles() { Idioma.Columns.Add("Objeto", typeof(string)); Idioma.Columns.Add("Texto", typeof(string)); using (SqlConnection sqlCon = new SqlConnection(Cnx.BaseDatosPrmtr())) { string LtxtSql = "EXEC Idioma @I,@F1,@F2,@F3,@F4"; SqlCommand SC = new SqlCommand(LtxtSql, sqlCon); SC.Parameters.AddWithValue("@I", Session["77IDM"].ToString().Trim()); SC.Parameters.AddWithValue("@F1", ViewState["PFileName"]); SC.Parameters.AddWithValue("@F2", ""); SC.Parameters.AddWithValue("@F3", ""); SC.Parameters.AddWithValue("@F4", ""); sqlCon.Open(); SqlDataReader tbl = SC.ExecuteReader(); while (tbl.Read()) //Todos los objetos { string bO = tbl["Objeto"].ToString().Trim(); string bT = tbl["Texto"].ToString().Trim(); Idioma.Rows.Add(bO, bT); if (bO.Equals("Caption")) { Page.Title = bT; ViewState["PageTit"] = bT; } TitForm.Text = bO.Equals("Caption") ? bT : TitForm.Text; BtnConsultar.Text = bO.Equals("BtnConsultar") ? bT : BtnConsultar.Text; if (bO.Equals("TxtDescPlHl")) { TxtDesc.Attributes.Add("placeholder", bT); } BtnSubComp.Text = bO.Equals("BtnSubComp") ? bT : BtnSubComp.Text; BtnMayor.Text = bO.Equals("BtnMayor") ? bT : BtnMayor.Text; GrdHistor.Columns[0].HeaderText = bO.Equals("GrdPrcs") ? bT : GrdHistor.Columns[0].HeaderText; GrdHistor.Columns[3].HeaderText = bO.Equals("GrdAcc") ? bT : GrdHistor.Columns[3].HeaderText; GrdHistor.Columns[4].HeaderText = bO.Equals("GrdFec") ? bT : GrdHistor.Columns[4].HeaderText; GrdHistor.Columns[5].HeaderText = bO.Equals("GrdPosc") ? bT : GrdHistor.Columns[5].HeaderText; GrdHistor.Columns[6].HeaderText = bO.Equals("GrdUbTec") ? bT : GrdHistor.Columns[6].HeaderText; GrdHistor.Columns[7].HeaderText = bO.Equals("GrdPnMy") ? bT : GrdHistor.Columns[7].HeaderText; GrdHistor.Columns[8].HeaderText = bO.Equals("GrdSnMy") ? bT : GrdHistor.Columns[8].HeaderText; GrdHistor.Columns[9].HeaderText = bO.Equals("GrdMtvo") ? bT : GrdHistor.Columns[9].HeaderText; GrdHistor.Columns[10].HeaderText = bO.Equals("GrdFecMvt") ? bT : GrdHistor.Columns[10].HeaderText; GrdHistor.EmptyDataText = bO.Equals("SinRegistros") ? bT : GrdHistor.EmptyDataText; //**************** Procesar un elemento **************************** IbtCerrarProces.ToolTip = bO.Equals("CerrarVentana") ? bT : IbtCerrarProces.ToolTip; LblTitProcsCont.Text = bO.Equals("LblTitProcsCont") ? bT : LblTitProcsCont.Text; LblPrcsSnMy.Text = bO.Equals("LblPrcsSnMy") ? bT : LblPrcsSnMy.Text; LblPrcsFecMyr.Text = bO.Equals("LblPrcsFecMyr") ? bT : LblPrcsFecMyr.Text; LblPrcsFecHast.Text = bO.Equals("LblPrcsFecHast") ? bT : LblPrcsFecHast.Text; LblPrcsCont.Text = bO.Equals("LblPrcsCont") ? bT : LblPrcsCont.Text; BtnPrcsConsult.Text = bO.Equals("BtnPrcsConsult") ? bT : BtnPrcsConsult.Text; BtnPrcsCont.Text = bO.Equals("GrdPrcs") ? bT : BtnPrcsCont.Text; GrdProcesar.Columns[0].HeaderText = bO.Equals("GrdFecPrc") ? bT : GrdProcesar.Columns[0].HeaderText; GrdProcesar.Columns[1].HeaderText = bO.Equals("GrdIndvPrc") ? bT : GrdProcesar.Columns[1].HeaderText; GrdProcesar.Columns[2].HeaderText = bO.Equals("GrdAcumPrc") ? bT : GrdProcesar.Columns[2].HeaderText; GrdProcesar.Columns[3].HeaderText = bO.Equals("GrdLVPrc") ? bT : GrdProcesar.Columns[3].HeaderText; GrdProcesar.EmptyDataText = bO.Equals("SinRegistros") ? bT : GrdProcesar.EmptyDataText; } sqlCon.Close(); ViewState["TablaIdioma"] = Idioma; } }
protected void IdiomaControles() { Idioma.Columns.Add("Objeto", typeof(string)); Idioma.Columns.Add("Texto", typeof(string)); using (SqlConnection sqlCon = new SqlConnection(Cnx.BaseDatosPrmtr())) { string LtxtSql = "EXEC Idioma @I,@F1,@F2,@F3,@F4"; SqlCommand SC = new SqlCommand(LtxtSql, sqlCon); SC.Parameters.AddWithValue("@I", Session["77IDM"].ToString().Trim()); SC.Parameters.AddWithValue("@F1", ViewState["PFileName"]); SC.Parameters.AddWithValue("@F2", ""); SC.Parameters.AddWithValue("@F3", ""); SC.Parameters.AddWithValue("@F4", ""); sqlCon.Open(); SqlDataReader tbl = SC.ExecuteReader(); while (tbl.Read()) //Todos los objetos { string bO = tbl["Objeto"].ToString().Trim(); string bT = tbl["Texto"].ToString().Trim(); Idioma.Rows.Add(bO, bT); if (bO.Equals("Caption")) { Page.Title = bT; ViewState["PageTit"] = bT; } TitForm.Text = bO.Equals("Titulo") ? bT : TitForm.Text; LblLote.Text = bO.Equals("LoteMst") ? bT : LblLote.Text; LblTipo.Text = bO.Equals("TipoMstr") ? bT : LblTipo.Text; LblDescrPn.Text = bO.Equals("Descripcion") ? bT : LblDescrPn.Text; BtnConsultar.Text = bO.Equals("BtnConsultar") ? bT : BtnConsultar.Text; BtnEjecutar.Text = bO.Equals("BtnEjecutar") ? bT : BtnEjecutar.Text; CkbAlterno.Text = bO.Equals("CkbAlterno") ? " " + bT : CkbAlterno.Text; LblStockActual.Text = bO.Equals("GrdCantStockMstr") ? bT : LblStockActual.Text; BtnExport.Text = bO.Equals("BtnExportMstr") ? bT : BtnExport.Text; BtnExport.ToolTip = bO.Equals("BtnExportTT") ? bT : BtnExport.ToolTip; ViewState["IdimaPnALter"] = bO.Equals("LblTitAlterno") ? bT : ViewState["IdimaPnALter"]; ViewState["TitExprtMvts"] = bO.Equals("TitExprtMvts") ? bT : ViewState["TitExprtMvts"]; LblTitAlterno.Text = bO.Equals("LblTitAlterno") ? bT : LblTitAlterno.Text; GrdAlterno.EmptyDataText = bO.Equals("SinRegistros") ? bT : GrdAlterno.EmptyDataText; GrdAlterno.Columns[1].HeaderText = bO.Equals("LblEstadoMst") ? bT : GrdAlterno.Columns[1].HeaderText; GrdAlterno.Columns[2].HeaderText = bO.Equals("GrdBloq") ? bT : GrdAlterno.Columns[2].HeaderText; LblTitStock.Text = bO.Equals("LblTitStock") ? bT : LblTitStock.Text; GrdStokAlma.EmptyDataText = bO.Equals("SinRegistros") ? bT : GrdStokAlma.EmptyDataText; GrdStokAlma.Columns[0].HeaderText = bO.Equals("AlmacenMstr") ? bT : GrdStokAlma.Columns[0].HeaderText; GrdStokAlma.Columns[1].HeaderText = bO.Equals("CantMst") ? bT : GrdStokAlma.Columns[1].HeaderText; GrdStokAlma.Columns[2].HeaderText = bO.Equals("GrdUndMstr") ? bT : GrdStokAlma.Columns[2].HeaderText; GrdStokAlma.Columns[3].HeaderText = bO.Equals("LblEstadoMst") ? bT : GrdStokAlma.Columns[3].HeaderText; GrdStokAlma.Columns[6].HeaderText = bO.Equals("LoteMst") ? bT : GrdStokAlma.Columns[6].HeaderText; GrdStokAlma.Columns[7].HeaderText = bO.Equals("BodegaMstr") ? bT : GrdStokAlma.Columns[7].HeaderText; GrdStokAlma.Columns[8].HeaderText = bO.Equals("GrdFila") ? bT : GrdStokAlma.Columns[8].HeaderText; GrdStokAlma.Columns[9].HeaderText = bO.Equals("GrdColumn") ? bT : GrdStokAlma.Columns[9].HeaderText; LblTitMovimientos.Text = bO.Equals("LblTitMovimientos") ? bT : LblTitMovimientos.Text; // *********************************************** Modal *********************************************** LblTitModalBusqPN.Text = bO.Equals("LblTitOTOpcBusqueda") ? bT : LblTitModalBusqPN.Text; RdbMdlBusqLote.Text = bO.Equals("LoteMst") ? " " + bT : RdbMdlBusqLote.Text; RdbMdlBusqDesc.Text = bO.Equals("Descripcion") ? " " + bT : RdbMdlBusqDesc.Text; if (bO.Equals("placeholder")) { TxtModalBusq.Attributes.Add("placeholder", bT); } IbtModalBusq.ToolTip = bO.Equals("BtnConsultar") ? bT : IbtModalBusq.ToolTip; LblModalBusq.Text = bO.Equals("MstrLblBusq") ? bT + ":" : LblModalBusq.Text; BtnCloseModalBusqPN.Text = bO.Equals("BtnCerrarMst") ? bT : BtnCloseModalBusqPN.Text; GrdMdlBusq.EmptyDataText = bO.Equals("SinRegistros") ? bT : GrdMdlBusq.EmptyDataText; GrdMdlBusq.Columns[3].HeaderText = bO.Equals("LoteMst") ? bT : GrdMdlBusq.Columns[3].HeaderText; GrdMdlBusq.Columns[4].HeaderText = bO.Equals("Descripcion") ? bT : GrdMdlBusq.Columns[4].HeaderText; GrdMdlBusq.Columns[5].HeaderText = bO.Equals("TipoMstr") ? bT : GrdMdlBusq.Columns[5].HeaderText; // *********************************************** Movimientos *********************************************** GrdMvtos.EmptyDataText = bO.Equals("SinRegistros") ? bT : GrdMvtos.EmptyDataText; GrdMvtos.Columns[0].HeaderText = bO.Equals("GrdDoc") ? bT : GrdMvtos.Columns[0].HeaderText; GrdMvtos.Columns[1].HeaderText = bO.Equals("GrdMvto") ? bT : GrdMvtos.Columns[1].HeaderText; GrdMvtos.Columns[2].HeaderText = bO.Equals("FechaMstr") ? bT : GrdMvtos.Columns[2].HeaderText; GrdMvtos.Columns[4].HeaderText = bO.Equals("GrdSnLot") ? bT : GrdMvtos.Columns[4].HeaderText; GrdMvtos.Columns[5].HeaderText = bO.Equals("GrdEntr") ? bT : GrdMvtos.Columns[5].HeaderText; GrdMvtos.Columns[6].HeaderText = bO.Equals("GrdSali") ? bT : GrdMvtos.Columns[6].HeaderText; GrdMvtos.Columns[7].HeaderText = bO.Equals("GrdUndMstr") ? bT : GrdMvtos.Columns[7].HeaderText; GrdMvtos.Columns[8].HeaderText = bO.Equals("GrdOtrD") ? bT : GrdMvtos.Columns[8].HeaderText; GrdMvtos.Columns[9].HeaderText = bO.Equals("GrdOT") ? bT : GrdMvtos.Columns[9].HeaderText; GrdMvtos.Columns[10].HeaderText = bO.Equals("PosMstr") ? bT : GrdMvtos.Columns[10].HeaderText; GrdMvtos.Columns[11].HeaderText = bO.Equals("GrdMtvo") ? bT : GrdMvtos.Columns[11].HeaderText; } sqlCon.Close(); ViewState["TablaIdioma"] = Idioma; } }
protected void IdiomaControles() { Idioma.Columns.Add("Objeto", typeof(string)); Idioma.Columns.Add("Texto", typeof(string)); using (SqlConnection sqlCon = new SqlConnection(Cnx.BaseDatosPrmtr())) { string LtxtSql = "EXEC Idioma @I,@F1,@F2,@F3,@F4"; SqlCommand SC = new SqlCommand(LtxtSql, sqlCon); SC.Parameters.AddWithValue("@I", Session["77IDM"].ToString().Trim()); SC.Parameters.AddWithValue("@F1", ViewState["PFileName"]); SC.Parameters.AddWithValue("@F2", ""); SC.Parameters.AddWithValue("@F3", ""); SC.Parameters.AddWithValue("@F4", ""); sqlCon.Open(); SqlDataReader tbl = SC.ExecuteReader(); while (tbl.Read()) //Todos los objetos { string bO = tbl["Objeto"].ToString().Trim(); string bT = tbl["Texto"].ToString().Trim(); Idioma.Rows.Add(bO, bT); if (bO.Equals("Caption")) { Page.Title = bT; ViewState["PageTit"] = bT; } TitForm.Text = bO.Equals("Titulo") ? bT : TitForm.Text; RdbSolPed.Text = bO.Equals("RdbSolPed") ? " " + bT : RdbSolPed.Text; RdbPpt.Text = bO.Equals("RdbPpt") ? " " + bT : RdbPpt.Text; LblBusqueda.Text = bO.Equals("MstrLblBusq") ? bT + ":" : LblBusqueda.Text; if (bO.Equals("placeholder")) { TxtBusqueda.Attributes.Add("placeholder", bT); } IbtBusqueda.ToolTip = bO.Equals("BtnConsultar") ? bT : IbtBusqueda.ToolTip; LblBusqueda.Text = bO.Equals("MstrLblBusq") ? bT + ":" : LblBusqueda.Text; BtnAprobar.Text = bO.Equals("BtnAprobar") ? bT : BtnAprobar.Text; IbtAprDetAll.ToolTip = bO.Equals("IbtAprDetAll") ? bT : IbtAprDetAll.ToolTip; GrdBusq.EmptyDataText = bO.Equals("SinRegistros") ? bT : GrdBusq.EmptyDataText; GrdBusq.Columns[1].HeaderText = bO.Equals("RdbSolPed") ? bT : GrdBusq.Columns[1].HeaderText; GrdBusq.Columns[2].HeaderText = bO.Equals("PosMstr") ? bT : GrdBusq.Columns[2].HeaderText; GrdBusq.Columns[3].HeaderText = bO.Equals("FechaMstr") ? bT : GrdBusq.Columns[3].HeaderText; GrdBusq.Columns[4].HeaderText = bO.Equals("PrioridadMstr") ? bT : GrdBusq.Columns[4].HeaderText; GrdBusq.Columns[5].HeaderText = bO.Equals("LblEstadoMst") ? bT : GrdBusq.Columns[5].HeaderText; GrdBusq.Columns[6].HeaderText = bO.Equals("GrdPetic") ? bT : GrdBusq.Columns[6].HeaderText; GrdBusq.Columns[7].HeaderText = bO.Equals("CantMst") ? bT : GrdBusq.Columns[7].HeaderText; GrdBusq.Columns[9].HeaderText = bO.Equals("ReferenciaMst") ? bT : GrdBusq.Columns[9].HeaderText; GrdBusq.Columns[10].HeaderText = bO.Equals("GrdEstadoRef") ? bT : GrdBusq.Columns[10].HeaderText; GrdBusq.Columns[11].HeaderText = bO.Equals("Descripcion") ? bT : GrdBusq.Columns[11].HeaderText; /**/ GrdBusq.Columns[12].HeaderText = bO.Equals("TipoMstr") ? bT : GrdBusq.Columns[12].HeaderText; /**/ GrdBusq.Columns[13].HeaderText = bO.Equals("GrdPpt") ? bT : GrdBusq.Columns[13].HeaderText; /**/ } DataRow[] Result = Idioma.Select("Objeto= 'BtnAprobarOnCl'"); foreach (DataRow row in Result) { BtnAprobar.OnClientClick = "return confirm('" + row["Texto"].ToString().Trim() + "');"; } sqlCon.Close(); ViewState["TablaIdioma"] = Idioma; } }
protected void IdiomaControles() { Idioma.Columns.Add("Objeto", typeof(string)); Idioma.Columns.Add("Texto", typeof(string)); using (SqlConnection sqlCon = new SqlConnection(Cnx.BaseDatosPrmtr())) { string LtxtSql = "EXEC Idioma @I,@F1,@F2,@F3,@F4"; SqlCommand SC = new SqlCommand(LtxtSql, sqlCon); SC.Parameters.AddWithValue("@I", Session["77IDM"].ToString().Trim()); SC.Parameters.AddWithValue("@F1", ViewState["PFileName"]); SC.Parameters.AddWithValue("@F2", ""); SC.Parameters.AddWithValue("@F3", ""); SC.Parameters.AddWithValue("@F4", ""); sqlCon.Open(); SqlDataReader tbl = SC.ExecuteReader(); while (tbl.Read()) //Todos los objetos { string bO = tbl["Objeto"].ToString().Trim(); string bT = tbl["Texto"].ToString().Trim(); Idioma.Rows.Add(bO, bT); if (bO.Equals("Caption")) { Page.Title = bT; ViewState["PageTit"] = bT; } TitForm.Text = bO.Equals("LblTituloElem") ? bT : TitForm.Text; LblCodigo.Text = bO.Equals("LblCodigo") ? bT + ":" : LblCodigo.Text; LblReferenc.Text = bO.Equals("LblReferenc") ? bT + ":" : LblReferenc.Text; LblReferenc.Text = bO.Equals("LblReferenc") ? bT + ":" : LblReferenc.Text; LblDescr.Text = bO.Equals("LblDescr") ? bT + ":" : LblDescr.Text; LblLote.Text = bO.Equals("LblLote") ? bT + ":" : LblLote.Text; LblFechRec.Text = bO.Equals("LblFechRec") ? bT + ":" : LblFechRec.Text; LblUndMed.Text = bO.Equals("LblUndMed") ? bT + ":" : LblUndMed.Text; LblGrupo.Text = bO.Equals("LblGrupo") ? bT + ":" : LblGrupo.Text; LblAta.Text = bO.Equals("LblAta") ? bT + ":" : LblAta.Text; LblPosic.Text = bO.Equals("LblPosic") ? bT + ":" : LblPosic.Text; LblAerona.Text = bO.Equals("LblAerona") ? bT + ":" : LblAerona.Text; LblMayor.Text = bO.Equals("LblMayor") ? bT + ":" : LblMayor.Text; LblUbicTec.Text = bO.Equals("LblUbicTec") ? bT + ":" : LblUbicTec.Text; LblSheLif.Text = bO.Equals("LblSheLif") ? bT + ":" : LblSheLif.Text; LblEstad.Text = bO.Equals("LblEstad") ? bT + ":" : LblEstad.Text; CkbApu.Text = bO.Equals("CkbApu") ? " " + bT : CkbApu.Text; CkbMot.Text = bO.Equals("CkbMot") ? " " + bT : CkbMot.Text; CkbConsig.Text = bO.Equals("CkbConsig") ? " " + bT : CkbConsig.Text; RdbActivo.Text = bO.Equals("RdbActivo") ? " " + bT + " " : RdbActivo.Text; RdbInactivo.Text = bO.Equals("RdbInactivo") ? " " + bT : RdbInactivo.Text; BtnModificar.Text = bO.Equals("BtnModificar") ? bT : BtnModificar.Text; BtnConsultar.Text = bO.Equals("BtnConsultar") ? bT : BtnConsultar.Text; LblTitContAsig.Text = bO.Equals("LblTitContAsig") ? bT : LblTitContAsig.Text; GrdCont.Columns[0].HeaderText = bO.Equals("GrdNom") ? bT : GrdCont.Columns[0].HeaderText; GrdCont.Columns[1].HeaderText = bO.Equals("GrdContad") ? bT : GrdCont.Columns[1].HeaderText; GrdCont.Columns[2].HeaderText = bO.Equals("GrdValor") ? bT : GrdCont.Columns[2].HeaderText; GrdCont.EmptyDataText = bO.Equals("GtdTextSin") ? bT : GrdCont.EmptyDataText; //**************************************Busq ***************************************************** LblTitOpcBusq.Text = bO.Equals("LblTitOpcBusq") ? bT : LblTitOpcBusq.Text; RdbBusqDesc.Text = bO.Equals("LblDescr") ? " " + bT : RdbBusqDesc.Text; RdbBusqRef.Text = bO.Equals("LblReferenc") ? " " + bT : RdbBusqRef.Text; LblBusqueda.Text = bO.Equals("Busqueda") ? bT : LblBusqueda.Text; if (bO.Equals("placeholderDC")) { TxtBusqueda.Attributes.Add("placeholder", bT); } IbtConsultar.ToolTip = bO.Equals("BtnConsultar") ? bT : IbtConsultar.ToolTip; IbtCerrar.ToolTip = bO.Equals("CerrarVentana") ? bT : IbtCerrar.ToolTip; GrdBusq.Columns[1].HeaderText = bO.Equals("LblReferenc") ? bT : GrdBusq.Columns[1].HeaderText; GrdBusq.Columns[4].HeaderText = bO.Equals("LblLote") ? bT : GrdBusq.Columns[4].HeaderText; GrdBusq.Columns[5].HeaderText = bO.Equals("LblDescr") ? bT : GrdBusq.Columns[5].HeaderText; GrdBusq.Columns[6].HeaderText = bO.Equals("LblFechRec") ? bT : GrdBusq.Columns[6].HeaderText; GrdBusq.Columns[7].HeaderText = bO.Equals("LblUndMed") ? bT : GrdBusq.Columns[7].HeaderText; GrdBusq.Columns[8].HeaderText = bO.Equals("GrdCodGrup") ? bT : GrdBusq.Columns[8].HeaderText; GrdBusq.Columns[9].HeaderText = bO.Equals("LblGrupo") ? bT : GrdBusq.Columns[9].HeaderText; GrdBusq.Columns[11].HeaderText = bO.Equals("LblPosic") ? bT : GrdBusq.Columns[11].HeaderText; GrdBusq.Columns[12].HeaderText = bO.Equals("LblAerona") ? bT : GrdBusq.Columns[12].HeaderText; GrdBusq.Columns[13].HeaderText = bO.Equals("LblMayor") ? bT : GrdBusq.Columns[13].HeaderText; GrdBusq.Columns[14].HeaderText = bO.Equals("LblUbicTec") ? bT : GrdBusq.Columns[14].HeaderText; GrdBusq.Columns[15].HeaderText = bO.Equals("LblSheLif") ? bT : GrdBusq.Columns[15].HeaderText; GrdBusq.Columns[16].HeaderText = bO.Equals("LblEstad") ? bT : GrdBusq.Columns[16].HeaderText; GrdBusq.Columns[17].HeaderText = bO.Equals("GrdFecVen") ? bT : GrdBusq.Columns[17].HeaderText; GrdBusq.Columns[19].HeaderText = bO.Equals("CkbMot") ? bT : GrdBusq.Columns[19].HeaderText; GrdBusq.Columns[20].HeaderText = bO.Equals("CkbConsig") ? bT : GrdBusq.Columns[20].HeaderText; GrdBusq.Columns[21].HeaderText = bO.Equals("RdbActivo") ? bT : GrdBusq.Columns[21].HeaderText; GrdBusq.Columns[22].HeaderText = bO.Equals("LblCodigo") ? bT : GrdBusq.Columns[22].HeaderText; GrdBusq.Columns[23].HeaderText = bO.Equals("GrdIdent") ? bT : GrdBusq.Columns[23].HeaderText; GrdBusq.EmptyDataText = bO.Equals("SinRegistros") ? bT : GrdBusq.EmptyDataText; } sqlCon.Close(); ViewState["TablaIdioma"] = Idioma; } }
protected void IdiomaControles() { Idioma.Columns.Add("Objeto", typeof(string)); Idioma.Columns.Add("Texto", typeof(string)); using (SqlConnection sqlCon = new SqlConnection(Cnx.BaseDatosPrmtr())) { string LtxtSql = "EXEC Idioma @I,@F1,@F2,@F3,@F4"; SqlCommand SC = new SqlCommand(LtxtSql, sqlCon); SC.Parameters.AddWithValue("@I", Session["77IDM"].ToString().Trim()); SC.Parameters.AddWithValue("@F1", ViewState["PFileName"]); SC.Parameters.AddWithValue("@F2", ""); SC.Parameters.AddWithValue("@F3", ""); SC.Parameters.AddWithValue("@F4", ""); sqlCon.Open(); SqlDataReader tbl = SC.ExecuteReader(); while (tbl.Read()) //Todos los objetos { string bO = tbl["Objeto"].ToString().Trim(); string bT = tbl["Texto"].ToString().Trim(); Idioma.Rows.Add(bO, bT); if (bO.Equals("Caption")) { Page.Title = bT; ViewState["PageTit"] = bT; } TitForm.Text = bO.Equals("TituloMod") ? bT : TitForm.Text; LblBusq.Text = bO.Equals("LblBusq") ? bT + ":" : LblBusq.Text; if (bO.Equals("placeholder")) { TxtBusqueda.Attributes.Add("placeholder", bT); } if (bO.Equals("placeholderSinFrm")) { TxtFormL.Attributes.Add("placeholder", bT); } BtIConsultar.ToolTip = bO.Equals("BtIConsultar") ? bT : BtIConsultar.ToolTip; LblCodigo.Text = bO.Equals("LblCodigo") ? bT + ":" : LblCodigo.Text; LblMod.Text = bO.Equals("LblMod") ? bT + ":" : LblMod.Text; LblDesc.Text = bO.Equals("LblDesc") ? bT + ":" : LblDesc.Text; LblNumMot.Text = bO.Equals("LblNumMot") ? bT + ":" : LblNumMot.Text; LblNumTr.Text = bO.Equals("LblNumTr") ? bT + ":" : LblNumTr.Text; LblPasj.Text = bO.Equals("LblPasj") ? bT + ":" : LblPasj.Text; LblFormL.Text = bO.Equals("LblFormL") ? bT + ":" : LblFormL.Text; BtIFormL.ToolTip = bO.Equals("BtIFormL") ? bT : BtIFormL.ToolTip; LblAlaF.Text = bO.Equals("LblAlaF") ? bT : LblAlaF.Text; LblAlaR.Text = bO.Equals("LblAlaR") ? bT : LblAlaR.Text; BtnIngresar.Text = bO.Equals("BotonIng") ? bT : BtnIngresar.Text; BtnModificar.Text = bO.Equals("BotonMod") ? bT : BtnModificar.Text; BtnEliminar.Text = bO.Equals("BtnEliminar") ? bT : BtnEliminar.Text; LblFormula.Text = bO.Equals("LblFormula") ? bT : LblFormula.Text; BtnLimp.Text = bO.Equals("BtnLimp") ? bT : BtnLimp.Text; BtnCiclo.ToolTip = bO.Equals("BtnCiclo") ? bT : BtnCiclo.ToolTip; BtnLevant.ToolTip = bO.Equals("BtnLevant") ? bT : BtnLevant.ToolTip; BtiAceptar.ToolTip = bO.Equals("BtiAceptar") ? bT : BtiAceptar.ToolTip; BtiCancelar.ToolTip = bO.Equals("BtiCancelar") ? bT : BtiCancelar.ToolTip; GrdDatos.Columns[1].HeaderText = bO.Equals("GrdCodMod") ? bT : GrdDatos.Columns[1].HeaderText; GrdDatos.Columns[2].HeaderText = bO.Equals("LblMod") ? bT : GrdDatos.Columns[2].HeaderText; GrdDatos.Columns[3].HeaderText = bO.Equals("LblDesc") ? bT : GrdDatos.Columns[3].HeaderText; GrdDatos.Columns[4].HeaderText = bO.Equals("LblNumMot") ? bT : GrdDatos.Columns[4].HeaderText; GrdDatos.Columns[5].HeaderText = bO.Equals("LblNumTr") ? bT : GrdDatos.Columns[5].HeaderText; GrdDatos.Columns[6].HeaderText = bO.Equals("LblPasj") ? bT : GrdDatos.Columns[6].HeaderText; GrdDatos.Columns[7].HeaderText = bO.Equals("LblFormL") ? bT : GrdDatos.Columns[7].HeaderText; GrdDatos.Columns[8].HeaderText = bO.Equals("LblAlaF") ? bT : GrdDatos.Columns[8].HeaderText; GrdDatos.Columns[9].HeaderText = bO.Equals("LblAlaR") ? bT : GrdDatos.Columns[9].HeaderText; GrdDatos.EmptyDataText = bO.Equals("SinRegistros") ? bT : GrdDatos.EmptyDataText; } DataRow[] Result = Idioma.Select("Objeto= 'MensConfEli'"); foreach (DataRow row in Result) { BtnEliminar.OnClientClick = string.Format("return confirm('" + row["Texto"].ToString().Trim() + "');"); } //¿Desea eliminar el registro? sqlCon.Close(); ViewState["TablaIdioma"] = Idioma; } }
public void Alimentar(string Vista, string Idioma)// { Tb77lIdioma.Columns.Add("NomCursor", typeof(string)); Tb77lIdioma.Columns.Add("C01", typeof(string)); Tb77lIdioma.Columns.Add("C02", typeof(string)); Tb77lIdioma.Columns.Add("C03", typeof(string)); Tb77lIdioma.Columns.Add("C04", typeof(string)); Tb77lIdioma.Columns.Add("C05", typeof(string)); Tb77lIdioma.Columns.Add("C06", typeof(string)); Tb77lIdioma.Columns.Add("C07", typeof(string)); Tb77lIdioma.Columns.Add("C08", typeof(string)); Tb77lIdioma.Columns.Add("C09", typeof(string)); Tb77lIdioma.Columns.Add("C10", typeof(string)); Tb77lIdioma.Columns.Add("C11", typeof(string)); Tb77lIdioma.Columns.Add("C12", typeof(string)); Tb77lIdioma.Columns.Add("C13", typeof(string)); Tb77lIdioma.Columns.Add("C14", typeof(string)); Tb77lIdioma.Columns.Add("C15", typeof(string)); Tb77lIdioma.Columns.Add("C16", typeof(string)); Tb77lIdioma.Columns.Add("C17", typeof(string)); Tb77lIdioma.Columns.Add("C18", typeof(string)); Tb77lIdioma.Columns.Add("C19", typeof(string)); Tb77lIdioma.Columns.Add("C20", typeof(string)); Tb77lIdioma.Columns.Add("C21", typeof(string)); Tb77lIdioma.Columns.Add("C22", typeof(string)); Tb77lIdioma.Columns.Add("C23", typeof(string)); Tb77lIdioma.Columns.Add("C24", typeof(string)); Tb77lIdioma.Columns.Add("C25", typeof(string)); Tb77lIdioma.Columns.Add("C26", typeof(string)); Tb77lIdioma.Columns.Add("C27", typeof(string)); Tb77lIdioma.Columns.Add("C28", typeof(string)); Tb77lIdioma.Columns.Add("C29", typeof(string)); Tb77lIdioma.Columns.Add("C30", typeof(string)); Tb77lIdioma.Columns.Add("C31", typeof(string)); Tb77lIdioma.Columns.Add("C32", typeof(string)); Tb77lIdioma.Columns.Add("C33", typeof(string)); Tb77lIdioma.Columns.Add("C34", typeof(string)); Tb77lIdioma.Columns.Add("C35", typeof(string)); Tb77lIdioma.Columns.Add("C36", typeof(string)); Tb77lIdioma.Columns.Add("C37", typeof(string)); Tb77lIdioma.Columns.Add("C38", typeof(string)); Tb77lIdioma.Columns.Add("C39", typeof(string)); Tb77lIdioma.Columns.Add("C40", typeof(string)); Tb77lIdioma.Columns.Add("C41", typeof(string)); Tb77lIdioma.Columns.Add("C42", typeof(string)); Tb77lIdioma.Columns.Add("C43", typeof(string)); Tb77lIdioma.Columns.Add("C44", typeof(string)); Tb77lIdioma.Columns.Add("C45", typeof(string)); using (SqlConnection sqlCon = new SqlConnection(Cnx.BaseDatosPrmtr())) { string C01 = "", C02 = "", C03 = "", C04 = "", C05 = "", C06 = "", C07 = "", C08 = "", C09 = "", C10 = "", C11 = "", C12 = "", C13 = "", C14 = "", C15 = "", C16 = ""; string C17 = "", C18 = "", C19 = "", C20 = "", C21 = "", C22 = "", C23 = "", C24 = "", C25 = "", C26 = "", C27 = "", C28 = "", C29 = "", C30 = "", C31 = "", C32 = "", C33 = "", C34 = "", C35 = "", C36 = "", C37 = "", C38 = "", C39 = ""; string LtxtSql = "EXEC Idioma @I,@F,'','',''"; SqlCommand SC = new SqlCommand(LtxtSql, sqlCon); SC.Parameters.AddWithValue("@I", Idioma); SC.Parameters.AddWithValue("@F", Vista); sqlCon.Open(); SqlDataReader tbl = SC.ExecuteReader(); while (tbl.Read()) { string borr = tbl["Objeto"].ToString().Trim(); string borr1 = tbl["Texto"].ToString().Trim(); C01 = tbl["Objeto"].ToString().Trim() == "C01" ? tbl["Texto"].ToString().Trim() : C01; C02 = tbl["Objeto"].ToString().Trim() == "C02" ? tbl["Texto"].ToString().Trim() : C02; C03 = tbl["Objeto"].ToString().Trim() == "C03" ? tbl["Texto"].ToString().Trim() : C03; C04 = tbl["Objeto"].ToString().Trim() == "C04" ? tbl["Texto"].ToString().Trim() : C04; C05 = tbl["Objeto"].ToString().Trim() == "C05" ? tbl["Texto"].ToString().Trim() : C05; C06 = tbl["Objeto"].ToString().Trim() == "C06" ? tbl["Texto"].ToString().Trim() : C06; C07 = tbl["Objeto"].ToString().Trim() == "C07" ? tbl["Texto"].ToString().Trim() : C07; C08 = tbl["Objeto"].ToString().Trim() == "C08" ? tbl["Texto"].ToString().Trim() : C08; C09 = tbl["Objeto"].ToString().Trim() == "C09" ? tbl["Texto"].ToString().Trim() : C09; C10 = tbl["Objeto"].ToString().Trim() == "C10" ? tbl["Texto"].ToString().Trim() : C10; C11 = tbl["Objeto"].ToString().Trim() == "C11" ? tbl["Texto"].ToString().Trim() : C11; C12 = tbl["Objeto"].ToString().Trim() == "C12" ? tbl["Texto"].ToString().Trim() : C12; C13 = tbl["Objeto"].ToString().Trim() == "C13" ? tbl["Texto"].ToString().Trim() : C13; C14 = tbl["Objeto"].ToString().Trim() == "C14" ? tbl["Texto"].ToString().Trim() : C14; C15 = tbl["Objeto"].ToString().Trim() == "C15" ? tbl["Texto"].ToString().Trim() : C15; C16 = tbl["Objeto"].ToString().Trim() == "C16" ? tbl["Texto"].ToString().Trim() : C16; C17 = tbl["Objeto"].ToString().Trim() == "C17" ? tbl["Texto"].ToString().Trim() : C17; C18 = tbl["Objeto"].ToString().Trim() == "C18" ? tbl["Texto"].ToString().Trim() : C18; C19 = tbl["Objeto"].ToString().Trim() == "C19" ? tbl["Texto"].ToString().Trim() : C19; C20 = tbl["Objeto"].ToString().Trim() == "C20" ? tbl["Texto"].ToString().Trim() : C20; C21 = tbl["Objeto"].ToString().Trim() == "C21" ? tbl["Texto"].ToString().Trim() : C21; C22 = tbl["Objeto"].ToString().Trim() == "C22" ? tbl["Texto"].ToString().Trim() : C22; C23 = tbl["Objeto"].ToString().Trim() == "C23" ? tbl["Texto"].ToString().Trim() : C23; C24 = tbl["Objeto"].ToString().Trim() == "C24" ? tbl["Texto"].ToString().Trim() : C24; C25 = tbl["Objeto"].ToString().Trim() == "C25" ? tbl["Texto"].ToString().Trim() : C25; C26 = tbl["Objeto"].ToString().Trim() == "C26" ? tbl["Texto"].ToString().Trim() : C26; C27 = tbl["Objeto"].ToString().Trim() == "C27" ? tbl["Texto"].ToString().Trim() : C27; C28 = tbl["Objeto"].ToString().Trim() == "C28" ? tbl["Texto"].ToString().Trim() : C28; C29 = tbl["Objeto"].ToString().Trim() == "C29" ? tbl["Texto"].ToString().Trim() : C29; C30 = tbl["Objeto"].ToString().Trim() == "C30" ? tbl["Texto"].ToString().Trim() : C30; C31 = tbl["Objeto"].ToString().Trim() == "C31" ? tbl["Texto"].ToString().Trim() : C31; C32 = tbl["Objeto"].ToString().Trim() == "C32" ? tbl["Texto"].ToString().Trim() : C32; C33 = tbl["Objeto"].ToString().Trim() == "C33" ? tbl["Texto"].ToString().Trim() : C33; C34 = tbl["Objeto"].ToString().Trim() == "C34" ? tbl["Texto"].ToString().Trim() : C34; C35 = tbl["Objeto"].ToString().Trim() == "C35" ? tbl["Texto"].ToString().Trim() : C35; C36 = tbl["Objeto"].ToString().Trim() == "C36" ? tbl["Texto"].ToString().Trim() : C36; C37 = tbl["Objeto"].ToString().Trim() == "C37" ? tbl["Texto"].ToString().Trim() : C37; C38 = tbl["Objeto"].ToString().Trim() == "C38" ? tbl["Texto"].ToString().Trim() : C38; C39 = tbl["Objeto"].ToString().Trim() == "C39" ? tbl["Texto"].ToString().Trim() : C39; } Tb77lIdioma.Rows.Add(Vista.Trim(), C01, C02, C03, C04, C05, C06, C07, C08, C09, C10, C11, C12, C13, C14, C15, C16, C17, C18, C19, C20, C21, C22, C23, C24, C25, C26, C27, C28, C29, C30, C31, C32, C33, C34, C35, C36, C37, C38, C39, "40", "41", "42", "43", "44", "45"); Cnx.SelecBD(); using (SqlConnection sqlCon2 = new SqlConnection(Cnx.GetConex())) { sqlCon2.Open(); using (SqlTransaction transaction = sqlCon2.BeginTransaction()) { string VBQuery = "ExportIdioma"; using (SqlCommand sqlCmd = new SqlCommand(VBQuery, sqlCon2, transaction)) { try { sqlCmd.CommandType = CommandType.StoredProcedure; SqlParameter Prmtrs = sqlCmd.Parameters.AddWithValue("@Curidioma", Tb77lIdioma); Prmtrs.SqlDbType = SqlDbType.Structured; SqlDataReader SDR = sqlCmd.ExecuteReader(); if (SDR.Read()) { string PMensj = HttpUtility.HtmlDecode(SDR["Mensj"].ToString().Trim()); } SDR.Close(); transaction.Commit(); sqlCon.Close(); } catch (Exception Ex) { string VbUsu, VbPantalla, VbcatVer, VbcatAct; VbUsu = System.Web.HttpContext.Current.Session["C77U"].ToString(); VbPantalla = "FrmAeronave"; VbcatVer = System.Web.HttpContext.Current.Session["77Version"].ToString(); VbcatAct = System.Web.HttpContext.Current.Session["77Act"].ToString(); Cnx.UpdateErrorV2(VbUsu, VbPantalla, "CsTypExportarIdioma", Ex.StackTrace.Substring(Ex.StackTrace.Length - 300, 300), Ex.Message, VbcatVer, VbcatAct); transaction.Rollback(); } } } } } }
protected void IdiomaControles() { Idioma.Columns.Add("Objeto", typeof(string)); Idioma.Columns.Add("Texto", typeof(string)); using (SqlConnection sqlCon = new SqlConnection(Cnx.BaseDatosPrmtr())) { string LtxtSql = "EXEC Idioma @I,@F1,@F2,@F3,@F4"; SqlCommand SC = new SqlCommand(LtxtSql, sqlCon); SC.Parameters.AddWithValue("@I", Session["77IDM"].ToString().Trim()); SC.Parameters.AddWithValue("@F1", ViewState["PFileName"]); SC.Parameters.AddWithValue("@F2", ""); SC.Parameters.AddWithValue("@F3", ""); SC.Parameters.AddWithValue("@F4", ""); sqlCon.Open(); SqlDataReader tbl = SC.ExecuteReader(); while (tbl.Read()) //Todos los objetos { string bO = tbl["Objeto"].ToString().Trim(); string bT = tbl["Texto"].ToString().Trim(); Idioma.Rows.Add(bO, bT); if (bO.Equals("Caption")) { Page.Title = bT; ViewState["PageTit"] = bT; } TitForm.Text = bO.Equals("Titulo") ? bT : TitForm.Text; RdbBusqSP.Text = bO.Equals("RdbBusqSP") ? " " + bT : RdbBusqSP.Text; RdbBusqCot.Text = bO.Equals("RdbBusqCot") ? " " + bT : RdbBusqCot.Text; RdbBusqPet.Text = bO.Equals("RdbBusqPet") ? " " + bT : RdbBusqPet.Text; RdbBusqPPT.Text = bO.Equals("RdbBusqPPT") ? " " + bT : RdbBusqPPT.Text; if (bO.Equals("placeholder")) { TxtBusqueda.Attributes.Add("placeholder", bT); } IbtBusqueda.ToolTip = bO.Equals("BtnConsultar") ? bT : IbtBusqueda.ToolTip; BtnOpenCompra.Text = bO.Equals("BtnOpenCompra") ? bT : BtnOpenCompra.Text; BtnOpenCompra.ToolTip = bO.Equals("BtnOpenCompraTT") ? bT : BtnOpenCompra.ToolTip; BtnOpenRepa.Text = bO.Equals("BtnOpenRepa") ? bT : BtnOpenRepa.Text; BtnOpenRepa.ToolTip = bO.Equals("BtnOpenRepaTT") ? bT : BtnOpenRepa.ToolTip; IbtAprPNAll.ToolTip = bO.Equals("IbtAprPNAll") ? bT : IbtAprPNAll.ToolTip; IbtDesAprAll.ToolTip = bO.Equals("IbtDesAprAll") ? bT : IbtDesAprAll.ToolTip; BtnAprob.Text = bO.Equals("IbtUpdate") ? bT : BtnAprob.Text; BtnExport.Text = bO.Equals("BtnExportMstr") ? bT : BtnExport.Text; // *************************************************Grid detalle ************************************************* GrdDet.Columns[0].HeaderText = bO.Equals("GrdApr") ? bT : GrdDet.Columns[0].HeaderText; GrdDet.Columns[1].HeaderText = bO.Equals("GrdAprPPT") ? bT : GrdDet.Columns[1].HeaderText; GrdDet.Columns[3].HeaderText = bO.Equals("FechaMstr") ? bT : GrdDet.Columns[3].HeaderText; GrdDet.Columns[4].HeaderText = bO.Equals("RdbBusqCot") ? bT : GrdDet.Columns[4].HeaderText; GrdDet.Columns[5].HeaderText = bO.Equals("GrdProv") ? bT : GrdDet.Columns[5].HeaderText; GrdDet.Columns[7].HeaderText = bO.Equals("Descripcion") ? bT : GrdDet.Columns[7].HeaderText; GrdDet.Columns[8].HeaderText = bO.Equals("GrdPnAlt") ? bT : GrdDet.Columns[8].HeaderText; GrdDet.Columns[9].HeaderText = bO.Equals("GrdUndMstr") ? bT : GrdDet.Columns[9].HeaderText; GrdDet.Columns[10].HeaderText = bO.Equals("CantMst") ? bT : GrdDet.Columns[10].HeaderText; GrdDet.Columns[11].HeaderText = bO.Equals("GrdCMC") ? bT : GrdDet.Columns[11].HeaderText; GrdDet.Columns[12].HeaderText = bO.Equals("ValorMstr") ? bT : GrdDet.Columns[12].HeaderText; GrdDet.Columns[13].HeaderText = bO.Equals("GrdMond") ? bT : GrdDet.Columns[13].HeaderText; GrdDet.Columns[14].HeaderText = bO.Equals("GrdDescto") ? bT : GrdDet.Columns[14].HeaderText; GrdDet.Columns[15].HeaderText = bO.Equals("GrdStts") ? bT : GrdDet.Columns[15].HeaderText; GrdDet.Columns[16].HeaderText = bO.Equals("GrdTimEnt") ? bT : GrdDet.Columns[16].HeaderText; GrdDet.Columns[17].HeaderText = bO.Equals("GrdTipPag") ? bT : GrdDet.Columns[17].HeaderText; GrdDet.Columns[18].HeaderText = bO.Equals("GrdLugEntr") ? bT : GrdDet.Columns[18].HeaderText; GrdDet.Columns[19].HeaderText = bO.Equals("LblObsMst") ? bT : GrdDet.Columns[19].HeaderText; GrdDet.Columns[20].HeaderText = bO.Equals("GrdTimEntPPT") ? bT : GrdDet.Columns[20].HeaderText; GrdDet.Columns[21].HeaderText = bO.Equals("GrdTipCOt") ? bT : GrdDet.Columns[21].HeaderText; GrdDet.Columns[22].HeaderText = bO.Equals("GrdPPT") ? bT : GrdDet.Columns[22].HeaderText; GrdDet.Columns[23].HeaderText = bO.Equals("GrdGaranti") ? bT : GrdDet.Columns[23].HeaderText; } DataRow[] Result = Idioma.Select("Objeto= 'IbtUpdateOnC'"); foreach (DataRow row in Result) { BtnAprob.OnClientClick = "return confirm('" + row["Texto"].ToString().Trim() + "');"; } sqlCon.Close(); ViewState["TablaIdioma"] = Idioma; } }
protected void IdiomaControles() { Idioma.Columns.Add("Objeto", typeof(string)); Idioma.Columns.Add("Texto", typeof(string)); using (SqlConnection sqlCon = new SqlConnection(Cnx.BaseDatosPrmtr())) { string LtxtSql = "EXEC Idioma @I,@F1,@F2,@F3,@F4"; SqlCommand SC = new SqlCommand(LtxtSql, sqlCon); SC.Parameters.AddWithValue("@I", Session["77IDM"].ToString().Trim()); SC.Parameters.AddWithValue("@F1", ViewState["PFileName"]); SC.Parameters.AddWithValue("@F2", ""); SC.Parameters.AddWithValue("@F3", ""); SC.Parameters.AddWithValue("@F4", ""); sqlCon.Open(); SqlDataReader tbl = SC.ExecuteReader(); while (tbl.Read()) //Todos los objetos { string bO = tbl["Objeto"].ToString().Trim(); string bT = tbl["Texto"].ToString().Trim(); Idioma.Rows.Add(bO, bT); if (bO.Equals("Caption")) { Page.Title = bT; ViewState["PageTit"] = bT; } TitForm.Text = bO.Equals("Titulo") ? bT : TitForm.Text; LblAeronave.Text = bO.Equals("LblAeronave") ? bT : LblAeronave.Text; BtnConsult.Text = bO.Equals("BtnConsultarGral") ? bT : BtnConsult.Text; LblStatus.Text = bO.Equals("LblStatus") ? bT : LblStatus.Text; LblOTPpl.Text = bO.Equals("LblOTPpl") ? bT : LblOTPpl.Text; LblRpteNro.Text = bO.Equals("LblRpteNro") ? bT : LblRpteNro.Text; LblFechI.Text = bO.Equals("LblFechI") ? bT : LblFechI.Text; LblFechF.Text = bO.Equals("LblFechF") ? bT : LblFechF.Text; BtnImprimir.Text = bO.Equals("BtnImprimir") ? bT : BtnImprimir.Text; BtnExportar.Text = bO.Equals("BtnExportar") ? bT : BtnExportar.Text; BtnAlertaCO.Text = bO.Equals("BtnAlertaCO") ? bT : BtnAlertaCO.Text; LblTitReportes.Text = bO.Equals("LblTitReportes") ? bT : LblTitReportes.Text; GrdDatos.Columns[0].HeaderText = bO.Equals("LblStatus") ? bT : GrdDatos.Columns[0].HeaderText; GrdDatos.Columns[1].HeaderText = bO.Equals("LblAeronave") ? bT : GrdDatos.Columns[1].HeaderText; GrdDatos.Columns[2].HeaderText = bO.Equals("LblRpteNro") ? bT : GrdDatos.Columns[2].HeaderText; GrdDatos.Columns[3].HeaderText = bO.Equals("GrdPrg") ? bT : GrdDatos.Columns[3].HeaderText; GrdDatos.Columns[4].HeaderText = bO.Equals("GrRdoPor") ? bT : GrdDatos.Columns[4].HeaderText; GrdDatos.Columns[5].HeaderText = bO.Equals("GrdFGene") ? bT : GrdDatos.Columns[5].HeaderText; GrdDatos.Columns[6].HeaderText = bO.Equals("GrdDescRte") ? bT : GrdDatos.Columns[6].HeaderText; GrdDatos.Columns[7].HeaderText = bO.Equals("GrdFCump") ? bT : GrdDatos.Columns[7].HeaderText; GrdDatos.Columns[8].HeaderText = bO.Equals("GrdAccC") ? bT : GrdDatos.Columns[8].HeaderText; GrdDatos.Columns[10].HeaderText = bO.Equals("GrdLic") ? bT : GrdDatos.Columns[10].HeaderText; GrdDatos.Columns[11].HeaderText = bO.Equals("LblOTPpl") ? bT : GrdDatos.Columns[11].HeaderText; GrdDatos.Columns[12].HeaderText = bO.Equals("GrdLV") ? bT : GrdDatos.Columns[12].HeaderText; GrdDatos.Columns[13].HeaderText = bO.Equals("GrdUbTec") ? bT : GrdDatos.Columns[13].HeaderText; //********************************** Impresion ****************************************** IbtCerrarImpr.ToolTip = bO.Equals("CerrarVentana") ? bT : IbtCerrarImpr.ToolTip; LblTitImpresion.Text = bO.Equals("LblTitImpresion") ? bT : LblTitImpresion.Text; ViewState["PTitulo"] = bO.Equals("PTitulo") ? bT : ViewState["PTitulo"]; ViewState["PHK"] = bO.Equals("LblAeronave") ? bT : ViewState["PHK"]; ViewState["PCteLbl"] = bO.Equals("PCteLbl") ? bT : ViewState["PCteLbl"]; } sqlCon.Close(); ViewState["TablaIdioma"] = Idioma; } }
protected void IdiomaControles() { Idioma.Columns.Add("Objeto", typeof(string)); Idioma.Columns.Add("Texto", typeof(string)); using (SqlConnection sqlCon = new SqlConnection(Cnx.BaseDatosPrmtr())) { string LtxtSql = "EXEC Idioma @I,@F1,@F2,@F3,@F4"; SqlCommand SC = new SqlCommand(LtxtSql, sqlCon); SC.Parameters.AddWithValue("@I", Session["77IDM"].ToString().Trim()); SC.Parameters.AddWithValue("@F1", ViewState["PFileName"]); SC.Parameters.AddWithValue("@F2", ""); SC.Parameters.AddWithValue("@F3", ""); SC.Parameters.AddWithValue("@F4", ""); sqlCon.Open(); SqlDataReader tbl = SC.ExecuteReader(); while (tbl.Read()) //Todos los objetos { string bO = tbl["Objeto"].ToString().Trim(); string bT = tbl["Texto"].ToString().Trim(); Idioma.Rows.Add(bO, bT); if (bO.Equals("Caption")) { Page.Title = bT; ViewState["PageTit"] = bT; } TitForm.Text = bO.Equals("Titulo") ? bT : TitForm.Text; LblBusqueda.Text = bO.Equals("MstrLblBusq") ? bT + ":" : LblBusqueda.Text; LblBusquedaH.Text = bO.Equals("MstrLblBusq") ? bT + ":" : LblBusquedaH.Text; if (bO.Equals("placeholder")) { TxtBusqueda.Attributes.Add("placeholder", bT); } IbtConsultar.ToolTip = bO.Equals("IbtConsultarTTMst") ? bT : IbtConsultar.ToolTip; IbtConsultarH.ToolTip = bO.Equals("IbtConsultarTTMst") ? bT : IbtConsultarH.ToolTip; BtnEditarHistrc.Text = bO.Equals("BtnEditarHistrc") ? bT : BtnEditarHistrc.Text; BtnEditarHistrc.ToolTip = bO.Equals("BtnEditarHistrcTT") ? bT : BtnEditarHistrc.ToolTip; GrdDatos.Columns[0].HeaderText = bO.Equals("Caption") ? bT : GrdDatos.Columns[0].HeaderText; GrdDatos.Columns[1].HeaderText = bO.Equals("Descripcion") ? bT : GrdDatos.Columns[1].HeaderText; GrdDatos.Columns[2].HeaderText = bO.Equals("GrdSmbl") ? bT : GrdDatos.Columns[2].HeaderText; GrdDatos.Columns[3].HeaderText = bO.Equals("GrdTRMAct") ? bT : GrdDatos.Columns[3].HeaderText; GrdDatos.Columns[4].HeaderText = bO.Equals("GrdUltFecR") ? bT : GrdDatos.Columns[4].HeaderText; GrdDatos.Columns[5].HeaderText = bO.Equals("GrdTrmNw") ? bT : GrdDatos.Columns[5].HeaderText; GrdDatos.Columns[5].HeaderText = bO.Equals("FechaMstr") ? bT : GrdDatos.Columns[5].HeaderText; LblTitHisto.Text = bO.Equals("LblTitHisto") ? bT : LblTitHisto.Text; IbtCloseHist.ToolTip = bO.Equals("CerrarVentana") ? bT : IbtCloseHist.ToolTip; if (bO.Equals("Titulo")) { TxtBusqMon.Attributes.Add("placeholder", bT); } if (bO.Equals("TxtBAno")) { TxtBusqAno.Attributes.Add("placeholder", bT); } if (bO.Equals("TxtBMes")) { TxtBusqMes.Attributes.Add("placeholder", bT); } GrdDatosH.Columns[0].HeaderText = bO.Equals("GrdTRMAct") ? bT : GrdDatosH.Columns[0].HeaderText; GrdDatosH.Columns[1].HeaderText = bO.Equals("FechaMstr") ? bT : GrdDatosH.Columns[1].HeaderText; } sqlCon.Close(); ViewState["TablaIdioma"] = Idioma; } }
protected void IdiomaControles() { Idioma.Columns.Add("Objeto", typeof(string)); Idioma.Columns.Add("Texto", typeof(string)); using (SqlConnection sqlCon = new SqlConnection(Cnx.BaseDatosPrmtr())) { string LtxtSql = "EXEC Idioma @I,@F1,@F2,@F3,@F4"; SqlCommand SC = new SqlCommand(LtxtSql, sqlCon); SC.Parameters.AddWithValue("@I", Session["77IDM"].ToString().Trim()); SC.Parameters.AddWithValue("@F1", ViewState["PFileName"]); SC.Parameters.AddWithValue("@F2", ""); SC.Parameters.AddWithValue("@F3", ""); SC.Parameters.AddWithValue("@F4", ""); sqlCon.Open(); SqlDataReader tbl = SC.ExecuteReader(); while (tbl.Read()) //Todos los objetos { string bO = tbl["Objeto"].ToString().Trim(); string bT = tbl["Texto"].ToString().Trim(); Idioma.Rows.Add(bO, bT); if (bO.Equals("Caption")) { Page.Title = bT; ViewState["PageTit"] = bT; } TitForm.Text = bO.Equals("Caption") ? bT : TitForm.Text; LblTipo.Text = bO.Equals("LblTipo") ? bT : LblTipo.Text; BtnSinConfigurar.Text = bO.Equals("BtnSinConfigurar") ? bT : BtnSinConfigurar.Text; BtnSinConfigurar.ToolTip = bO.Equals("BtnSinConfigurarTT") ? bT : BtnSinConfigurar.ToolTip; BtnAbrirElem.Text = bO.Equals("BtnAbrirElem") ? bT : BtnAbrirElem.Text; BtnAbrirElem.ToolTip = bO.Equals("BtnAbrirElemTT") ? bT : BtnAbrirElem.ToolTip; LblTitProxVenc.Text = bO.Equals("LblTitProxVenc") ? bT : LblTitProxVenc.Text; LblTitSinConf.Text = bO.Equals("LblTitSinConf") ? bT : LblTitSinConf.Text; GrdProxVenc.EmptyDataText = bO.Equals("SinRegistros") ? bT : GrdProxVenc.EmptyDataText; GrdSinConfg.EmptyDataText = bO.Equals("SinRegistros") ? bT : GrdSinConfg.EmptyDataText; GrdProxVenc.Columns[0].HeaderText = bO.Equals("TipoMstr") ? bT : GrdProxVenc.Columns[0].HeaderText; GrdSinConfg.Columns[0].HeaderText = bO.Equals("TipoMstr") ? bT : GrdSinConfg.Columns[0].HeaderText; GrdProxVenc.Columns[2].HeaderText = bO.Equals("GrdSnLote") ? bT : GrdProxVenc.Columns[2].HeaderText; GrdSinConfg.Columns[2].HeaderText = bO.Equals("GrdSnLote") ? bT : GrdSinConfg.Columns[2].HeaderText; GrdSinConfg.Columns[3].HeaderText = bO.Equals("ReferenciaMst") ? bT : GrdSinConfg.Columns[3].HeaderText; GrdProxVenc.Columns[3].HeaderText = bO.Equals("ReferenciaMst") ? bT : GrdProxVenc.Columns[3].HeaderText; GrdProxVenc.Columns[4].HeaderText = bO.Equals("Descripcion") ? bT : GrdProxVenc.Columns[4].HeaderText; GrdSinConfg.Columns[4].HeaderText = bO.Equals("Descripcion") ? bT : GrdSinConfg.Columns[4].HeaderText; GrdSinConfg.Columns[5].HeaderText = bO.Equals("GrdFecVen") ? bT : GrdSinConfg.Columns[5].HeaderText; GrdProxVenc.Columns[5].HeaderText = bO.Equals("GrdFecVen") ? bT : GrdProxVenc.Columns[5].HeaderText; GrdProxVenc.Columns[6].HeaderText = bO.Equals("AlmacenMstr") ? bT : GrdProxVenc.Columns[6].HeaderText; GrdSinConfg.Columns[6].HeaderText = bO.Equals("AlmacenMstr") ? bT : GrdSinConfg.Columns[6].HeaderText; GrdSinConfg.Columns[7].HeaderText = bO.Equals("BodegaMstr") ? bT : GrdSinConfg.Columns[7].HeaderText; GrdProxVenc.Columns[7].HeaderText = bO.Equals("BodegaMstr") ? bT : GrdProxVenc.Columns[7].HeaderText; GrdProxVenc.Columns[8].HeaderText = bO.Equals("CantMst") ? bT : GrdProxVenc.Columns[8].HeaderText; GrdSinConfg.Columns[8].HeaderText = bO.Equals("CantMst") ? bT : GrdSinConfg.Columns[8].HeaderText; GrdProxVenc.Columns[9].HeaderText = bO.Equals("GrdRemnt") ? bT : GrdProxVenc.Columns[9].HeaderText; IbtCloseSinConfg.ToolTip = bO.Equals("BtnCerrarMst") ? bT : IbtCloseSinConfg.ToolTip; } sqlCon.Close(); ViewState["TablaIdioma"] = Idioma; } }
protected void IdiomaControles() { Idioma.Columns.Add("Objeto", typeof(string)); Idioma.Columns.Add("Texto", typeof(string)); using (SqlConnection sqlCon = new SqlConnection(Cnx.BaseDatosPrmtr())) { string LtxtSql = "EXEC Idioma @I,@F1,@F2,@F3,@F4"; SqlCommand SC = new SqlCommand(LtxtSql, sqlCon); SC.Parameters.AddWithValue("@I", Session["77IDM"].ToString().Trim()); SC.Parameters.AddWithValue("@F1", ViewState["PFileName"]); SC.Parameters.AddWithValue("@F2", ""); SC.Parameters.AddWithValue("@F3", ""); SC.Parameters.AddWithValue("@F4", ""); sqlCon.Open(); SqlDataReader tbl = SC.ExecuteReader(); while (tbl.Read()) //Todos los objetos { string bO = tbl["Objeto"].ToString().Trim(); string bT = tbl["Texto"].ToString().Trim(); Idioma.Rows.Add(bO, bT); if (bO.Equals("Caption")) { Page.Title = bT; ViewState["PageTit"] = bT; } TitForm.Text = bO.Equals("Titulo") ? bT : TitForm.Text; BtnConsultar.Text = bO.Equals("IbtConsultar") ? bT : BtnConsultar.Text; LblNumRva.Text = bO.Equals("LblNumRv") ? bT : LblNumRva.Text; LblEstado.Text = bO.Equals("LblEstadoMst") ? bT : LblEstado.Text; LblFechaRv.Text = bO.Equals("GrdFecRva") ? bT : LblFechaRv.Text; LblMatr.Text = bO.Equals("LblAeronaveMstr") ? bT : LblMatr.Text; BtnConsultar.Text = bO.Equals("BtnConsultar") ? bT : BtnConsultar.Text; BtnExprt.Text = bO.Equals("BtnExportMstr") ? bT : BtnExprt.Text; BtnAlerta.Text = bO.Equals("BtnAlerta") ? bT : BtnAlerta.Text; BtnAlerta.ToolTip = bO.Equals("BtnAlertaTT") ? bT : BtnAlerta.ToolTip; IbtConsltPn.ToolTip = bO.Equals("BtnConsultar") ? bT : IbtConsltPn.ToolTip; // *************************************************Detalle Reserva ************************************************* LblTitDetRv.Text = bO.Equals("LblTitDetRv") ? bT : LblTitDetRv.Text; GrdReserva.EmptyDataText = bO.Equals("SinRegistros") ? bT : GrdReserva.EmptyDataText; GrdReserva.Columns[0].HeaderText = bO.Equals("GrdPos") ? bT : GrdReserva.Columns[0].HeaderText; GrdReserva.Columns[1].HeaderText = bO.Equals("ReferenciaMst") ? bT : GrdReserva.Columns[1].HeaderText; GrdReserva.Columns[3].HeaderText = bO.Equals("Descripcion") ? bT : GrdReserva.Columns[3].HeaderText; GrdReserva.Columns[4].HeaderText = bO.Equals("GrdCantSol") ? bT : GrdReserva.Columns[4].HeaderText; GrdReserva.Columns[5].HeaderText = bO.Equals("GrdUndMstr") ? bT : GrdReserva.Columns[5].HeaderText; GrdReserva.Columns[6].HeaderText = bO.Equals("GrdCantEntr") ? bT : GrdReserva.Columns[6].HeaderText; // *************************************************Recibo usuario la reserva ************************************************* LblTitUsuario.Text = bO.Equals("TitRecibRv") ? bT : LblTitUsuario.Text; GrdUsuario.EmptyDataText = bO.Equals("SinRegistros") ? bT : GrdUsuario.EmptyDataText; GrdUsuario.Columns[0].HeaderText = bO.Equals("GrdRecibe") ? bT : GrdUsuario.Columns[0].HeaderText; GrdUsuario.Columns[1].HeaderText = bO.Equals("GrdFecDsp") ? bT : GrdUsuario.Columns[1].HeaderText; GrdUsuario.Columns[2].HeaderText = bO.Equals("GrdFecRcb") ? bT : GrdUsuario.Columns[2].HeaderText; // *************************************************Stock ************************************************* LblTitStock.Text = bO.Equals("LblTitStock") ? bT : LblTitStock.Text; GrdStok.EmptyDataText = bO.Equals("SinRegistros") ? bT : GrdStok.EmptyDataText; GrdStok.Columns[0].HeaderText = bO.Equals("AlmacenMstr") ? bT : GrdStok.Columns[0].HeaderText; GrdStok.Columns[3].HeaderText = bO.Equals("LoteMst") ? bT : GrdStok.Columns[3].HeaderText; GrdStok.Columns[4].HeaderText = bO.Equals("CantMst") ? bT : GrdStok.Columns[4].HeaderText; GrdStok.Columns[5].HeaderText = bO.Equals("BodegaMstr") ? bT : GrdStok.Columns[5].HeaderText; // *************************************************opcion de busqueda ************************************************* if (bO.Equals("placeholder")) { TxtBusqueda.Attributes.Add("placeholder", bT); TxtConsltPN.Attributes.Add("placeholder", bT); } IbtBusqueda.ToolTip = bO.Equals("BtnConsultar") ? bT : IbtBusqueda.ToolTip; IbtCerrarBusq.ToolTip = bO.Equals("CerrarVentana") ? bT : IbtCerrarBusq.ToolTip; LblBusqueda.Text = bO.Equals("MstrLblBusq") ? bT + ":" : LblBusqueda.Text; LblTitOpcBusq.Text = bO.Equals("LblTitOTOpcBusqueda") ? bT : LblTitOpcBusq.Text; RdbBusqNumOT.Text = bO.Equals("LblOTMstr") ? bT + ":" : RdbBusqNumOT.Text; RdbBusqHK.Text = bO.Equals("LblAeronaveMstr") ? bT + ":" : RdbBusqHK.Text; GrdBusq.EmptyDataText = bO.Equals("SinRegistros") ? bT : GrdBusq.EmptyDataText; GrdBusq.Columns[1].HeaderText = bO.Equals("LblOTMstr") ? bT : GrdBusq.Columns[1].HeaderText; GrdBusq.Columns[2].HeaderText = bO.Equals("GrdAplicab") ? bT : GrdBusq.Columns[2].HeaderText; GrdBusq.Columns[5].HeaderText = bO.Equals("GrdCodHk") ? bT : GrdBusq.Columns[5].HeaderText; GrdBusq.Columns[6].HeaderText = bO.Equals("LblAeronaveMstr") ? bT : GrdBusq.Columns[6].HeaderText; GrdBusq.Columns[7].HeaderText = bO.Equals("GrdFecRv") ? bT : GrdBusq.Columns[7].HeaderText; GrdBusq.Columns[8].HeaderText = bO.Equals("LblEstadoMst") ? bT : GrdBusq.Columns[8].HeaderText; } sqlCon.Close(); ViewState["TablaIdioma"] = Idioma; } }
protected void IdiomaControles() { Idioma.Columns.Add("Objeto", typeof(string)); Idioma.Columns.Add("Texto", typeof(string)); using (SqlConnection sqlCon = new SqlConnection(Cnx.BaseDatosPrmtr())) { string LtxtSql = "EXEC Idioma @I,@F1,@F2,@F3,@F4"; SqlCommand SC = new SqlCommand(LtxtSql, sqlCon); SC.Parameters.AddWithValue("@I", Session["77IDM"].ToString().Trim()); SC.Parameters.AddWithValue("@F1", ViewState["PFileName"]); SC.Parameters.AddWithValue("@F2", ""); SC.Parameters.AddWithValue("@F3", ""); SC.Parameters.AddWithValue("@F4", ""); sqlCon.Open(); SqlDataReader tbl = SC.ExecuteReader(); while (tbl.Read()) //Todos los objetos { string bO = tbl["Objeto"].ToString().Trim(); string bT = tbl["Texto"].ToString().Trim(); Idioma.Rows.Add(bO, bT); if (bO.Equals("Caption")) { Page.Title = bT; ViewState["PageTit"] = bT; } TitForm.Text = bO.Equals("Caption") ? bT : TitForm.Text; LblAlmacen.Text = bO.Equals("LblAlmacen") ? bT : LblAlmacen.Text; LblTipo.Text = bO.Equals("LblTipo") ? bT : LblTipo.Text; BtnConsult.Text = bO.Equals("BtnConsultarGral") ? bT : BtnConsult.Text; IbnExcel.ToolTip = bO.Equals("IbnExcel") ? bT : IbnExcel.ToolTip; if (bO.Equals("placeholder")) { TxtBusqueda.Attributes.Add("placeholder", bT); } LblTitUbicaFis.Text = bO.Equals("LblTitUbicaFis") ? bT : LblTitUbicaFis.Text; GrdDatos.EmptyDataText = bO.Equals("SinRegistros") ? bT : GrdDatos.EmptyDataText; GrdDatos.Columns[0].HeaderText = bO.Equals("GrdAsig") ? bT : GrdDatos.Columns[0].HeaderText; GrdDatos.Columns[3].HeaderText = bO.Equals("GrdLot") ? bT : GrdDatos.Columns[3].HeaderText; GrdDatos.Columns[4].HeaderText = bO.Equals("GrdRef") ? bT : GrdDatos.Columns[4].HeaderText; GrdDatos.Columns[5].HeaderText = bO.Equals("GrdCant") ? bT : GrdDatos.Columns[5].HeaderText; GrdDatos.Columns[6].HeaderText = bO.Equals("GrdUM") ? bT : GrdDatos.Columns[6].HeaderText; GrdDatos.Columns[7].HeaderText = bO.Equals("GrdBod") ? bT : GrdDatos.Columns[7].HeaderText; GrdDatos.Columns[8].HeaderText = bO.Equals("GrdF") ? bT : GrdDatos.Columns[8].HeaderText; GrdDatos.Columns[9].HeaderText = bO.Equals("GrdC") ? bT : GrdDatos.Columns[9].HeaderText; //*******************Asignar*************************** IbtCerrarCambioBod.ToolTip = bO.Equals("CerrarVentana") ? bT : IbtCerrarCambioBod.ToolTip; LblTitCambioBod.Text = bO.Equals("LblTitCambioBod") ? bT : LblTitCambioBod.Text; LblLote.Text = bO.Equals("GrdLot") ? bT : LblLote.Text; LblBodOrig.Text = bO.Equals("LblBodOrig") ? bT : LblBodOrig.Text; LblBodDest.Text = bO.Equals("LblBodDest") ? bT : LblBodDest.Text; LblCantAct.Text = bO.Equals("LblCantAct") ? bT : LblCantAct.Text; LblCantNew.Text = bO.Equals("LblCantNew") ? bT : LblCantNew.Text; LblTitBodDes.Text = bO.Equals("LblBodDest") ? bT : LblTitBodDes.Text; GrdUbicaDes.EmptyDataText = bO.Equals("SinRegistros") ? bT : GrdUbicaDes.EmptyDataText; GrdUbicaDes.Columns[0].HeaderText = bO.Equals("GrdTrasf") ? bT : GrdUbicaDes.Columns[0].HeaderText; GrdUbicaDes.Columns[1].HeaderText = bO.Equals("GrdF") ? bT : GrdUbicaDes.Columns[1].HeaderText; GrdUbicaDes.Columns[2].HeaderText = bO.Equals("GrdC") ? bT : GrdUbicaDes.Columns[2].HeaderText; } sqlCon.Close(); ViewState["TablaIdioma"] = Idioma; } }
protected void IdiomaControles() { Idioma.Columns.Add("Objeto", typeof(string)); Idioma.Columns.Add("Texto", typeof(string)); using (SqlConnection sqlCon = new SqlConnection(Cnx.BaseDatosPrmtr())) { string LtxtSql = "EXEC Idioma @I,@F1,@F2,@F3,@F4"; SqlCommand SC = new SqlCommand(LtxtSql, sqlCon); SC.Parameters.AddWithValue("@I", Session["77IDM"].ToString().Trim()); SC.Parameters.AddWithValue("@F1", ViewState["PFileName"]); SC.Parameters.AddWithValue("@F2", ""); SC.Parameters.AddWithValue("@F3", ""); SC.Parameters.AddWithValue("@F4", ""); sqlCon.Open(); SqlDataReader tbl = SC.ExecuteReader(); while (tbl.Read()) //Todos los objetos { string bO = tbl["Objeto"].ToString().Trim(); string bT = tbl["Texto"].ToString().Trim(); Idioma.Rows.Add(bO, bT); if (bO.Equals("Caption")) { Page.Title = bT; ViewState["PageTit"] = bT; } TitForm.Text = bO.Equals("Caption") ? bT : TitForm.Text; LblAeronave.Text = bO.Equals("LblAeronave") ? bT : LblAeronave.Text; LblDiaVisual.Text = bO.Equals("LblDiaVisual") ? bT : LblDiaVisual.Text; LblEtiqDia.Text = bO.Equals("LblEtiqDia") ? bT : LblEtiqDia.Text; CkbVisualTodo.Text = bO.Equals("CkbVisualTodo") ? " " + bT : CkbVisualTodo.Text; BtnConsultar.Text = bO.Equals("BtnConsultarGral") ? bT : BtnConsultar.Text; IbnExcel.ToolTip = bO.Equals("IbnExcelTT") ? bT : IbnExcel.ToolTip; BtnSvcRestCero.Text = bO.Equals("BtnSvcRestCero") ? bT : BtnSvcRestCero.Text; BtnSvcRestCero.ToolTip = bO.Equals("BtnSvcRestCeroTT") ? bT : BtnSvcRestCero.ToolTip; BtnUbicaTec.Text = bO.Equals("BtnUbicaTec") ? bT : BtnUbicaTec.Text; BtnUbicaTec.ToolTip = bO.Equals("BtnUbicaTecTT") ? bT : BtnUbicaTec.ToolTip; LblTitServicios.Text = bO.Equals("LblTitServicios") ? bT : LblTitServicios.Text; GrdDatos.Columns[0].HeaderText = bO.Equals("LblAeronave") ? bT : GrdDatos.Columns[0].HeaderText; GrdDatos.Columns[1].HeaderText = bO.Equals("GrdDesc") ? bT : GrdDatos.Columns[1].HeaderText; GrdDatos.Columns[2].HeaderText = bO.Equals("GrdDoc") ? bT : GrdDatos.Columns[2].HeaderText; GrdDatos.Columns[5].HeaderText = bO.Equals("GrdFecUC") ? bT : GrdDatos.Columns[5].HeaderText; GrdDatos.Columns[6].HeaderText = bO.Equals("GrdOT") ? bT : GrdDatos.Columns[6].HeaderText; GrdDatos.Columns[8].HeaderText = bO.Equals("GrdProy") ? bT : GrdDatos.Columns[8].HeaderText; GrdDatos.Columns[9].HeaderText = bO.Equals("GrdFrec") ? bT : GrdDatos.Columns[9].HeaderText; GrdDatos.Columns[10].HeaderText = bO.Equals("GrdUnMed") ? bT : GrdDatos.Columns[10].HeaderText; GrdDatos.Columns[11].HeaderText = bO.Equals("GrdExt") ? bT : GrdDatos.Columns[11].HeaderText; GrdDatos.Columns[12].HeaderText = bO.Equals("GrdRemn") ? bT : GrdDatos.Columns[12].HeaderText; GrdDatos.Columns[13].HeaderText = bO.Equals("GrdFrecD") ? bT : GrdDatos.Columns[13].HeaderText; GrdDatos.Columns[14].HeaderText = bO.Equals("GrdExtD") ? bT : GrdDatos.Columns[14].HeaderText; GrdDatos.Columns[15].HeaderText = bO.Equals("GrdRmnD") ? bT : GrdDatos.Columns[15].HeaderText; GrdDatos.Columns[16].HeaderText = bO.Equals("GrdUltDP") ? bT : GrdDatos.Columns[16].HeaderText; //**********************************Servicios Reseteable ****************************************** IbtCerrarSvcReset.ToolTip = bO.Equals("CerrarVentana") ? bT : IbtCerrarSvcReset.ToolTip; LblTitSvcReset.Text = bO.Equals("LblTitServicios") ? bT : LblTitSvcReset.Text; GrdSvcReset.Columns[0].HeaderText = bO.Equals("GrdSvc") ? bT : GrdSvcReset.Columns[0].HeaderText; GrdSvcReset.Columns[1].HeaderText = bO.Equals("GrdFrec") ? bT : GrdSvcReset.Columns[1].HeaderText; GrdSvcReset.Columns[2].HeaderText = bO.Equals("GrdContdr") ? bT : GrdSvcReset.Columns[2].HeaderText; GrdSvcReset.Columns[3].HeaderText = bO.Equals("GrdFecUC") ? bT : GrdSvcReset.Columns[3].HeaderText; GrdSvcReset.Columns[6].HeaderText = bO.Equals("GrdDesElem") ? bT : GrdSvcReset.Columns[6].HeaderText; GrdSvcReset.Columns[7].HeaderText = bO.Equals("LblAeronave") ? bT : GrdSvcReset.Columns[7].HeaderText; //**********************************Ubicación Técnica ****************************************** IbtCerrarUbicTec.ToolTip = bO.Equals("CerrarVentana") ? bT : IbtCerrarUbicTec.ToolTip; LblTitUbicTec.Text = bO.Equals("LblTitUbicTec") ? bT : LblTitUbicTec.Text; GrdUbicTec.Columns[0].HeaderText = bO.Equals("LblAeronave") ? bT : GrdUbicTec.Columns[0].HeaderText; GrdUbicTec.Columns[1].HeaderText = bO.Equals("GrdUltNvl") ? bT : GrdUbicTec.Columns[1].HeaderText; GrdUbicTec.Columns[2].HeaderText = bO.Equals("GrdDesc") ? bT : GrdUbicTec.Columns[2].HeaderText; } sqlCon.Close(); ViewState["TablaIdioma"] = Idioma; } }