Example #1
0
 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;
            }
        }
Example #5
0
        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;
            }
        }
Example #6
0
        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;
            }
        }
Example #7
0
 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;
     }
 }
Example #8
0
 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;
     }
 }
Example #9
0
 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") ? "&nbsp" + 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") ? "&nbsp" + bT : RdbMdlBusqLote.Text;
             RdbMdlBusqDesc.Text    = bO.Equals("Descripcion") ? "&nbsp" + 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;
     }
 }
Example #11
0
        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") ? "&nbsp" + bT : RdbSolPed.Text;
                    RdbPpt.Text      = bO.Equals("RdbPpt") ? "&nbsp" + 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;
            }
        }
Example #12
0
        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") ? "&nbsp" + bT : CkbApu.Text;
                    CkbMot.Text                   = bO.Equals("CkbMot") ? "&nbsp" + bT : CkbMot.Text;
                    CkbConsig.Text                = bO.Equals("CkbConsig") ? " " + bT : CkbConsig.Text;
                    RdbActivo.Text                = bO.Equals("RdbActivo") ? "&nbsp" + bT + "&nbsp" : RdbActivo.Text;
                    RdbInactivo.Text              = bO.Equals("RdbInactivo") ? "&nbsp" + 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") ? "&nbsp" + bT : RdbBusqDesc.Text;
                    RdbBusqRef.Text    = bO.Equals("LblReferenc") ? "&nbsp" + 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;
            }
        }
Example #13
0
        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") ? "&nbsp" + bT : RdbBusqSP.Text;
             RdbBusqCot.Text = bO.Equals("RdbBusqCot") ? "&nbsp" + bT : RdbBusqCot.Text;
             RdbBusqPet.Text = bO.Equals("RdbBusqPet") ? "&nbsp" + bT : RdbBusqPet.Text;
             RdbBusqPPT.Text = bO.Equals("RdbBusqPPT") ? "&nbsp" + 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;
     }
 }
Example #16
0
        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;
            }
        }
Example #17
0
        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;
            }
        }
Example #18
0
        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;
            }
        }
Example #19
0
 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;
     }
 }
Example #20
0
 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;
     }
 }
Example #21
0
 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") ? "&nbsp" + 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;
     }
 }