示例#1
0
        protected void GrdDatos_RowCommand(object sender, GridViewCommandEventArgs e)
        {
            if (e.CommandName.Equals("AddNew"))
            {
                if (DdlForm.Text.Equals("-1"))
                {
                    ScriptManager.RegisterClientScriptBlock(this.Page, this.Page.GetType(), "alert", "alert('Debe seleccionar un formulario');", true);
                    DdlForm.Focus();
                    return;
                }

                TextBox TxtObjPP  = (GrdDatos.FooterRow.FindControl("TxtObjPP") as TextBox);
                TextBox TxtDescPP = (GrdDatos.FooterRow.FindControl("TxtDescPP") as TextBox);
                TextBox TxtEspaPP = (GrdDatos.FooterRow.FindControl("TxtEspaPP") as TextBox);
                TextBox TxtInglPP = (GrdDatos.FooterRow.FindControl("TxtInglPP") as TextBox);
                if (TxtObjPP.Text.Equals(""))
                {
                    TxtObjPP.Focus(); return;
                }
                if (TxtDescPP.Text.Equals(""))
                {
                    TxtDescPP.Focus(); return;
                }
                if (TxtEspaPP.Text.Equals(""))
                {
                    TxtEspaPP.Focus(); return;
                }
                if (TxtInglPP.Text.Equals(""))
                {
                    TxtInglPP.Focus(); return;
                }
                using (SqlConnection sqlCon = new SqlConnection(Cnx.BaseDatosPrmtr()))
                {
                    sqlCon.Open();
                    string VBQuery = "EXEC SP_Configuracion 4, @Es,@En, @Obj,@Desc, @Usu, @Id,0,0,0,'01-01-1','02-01-1','03-01-1'";
                    using (SqlCommand SC = new SqlCommand(VBQuery, sqlCon))
                    {
                        SC.Parameters.AddWithValue("@Es", TxtEspaPP.Text.Trim());
                        SC.Parameters.AddWithValue("@En", TxtInglPP.Text.Trim());
                        SC.Parameters.AddWithValue("@Obj", TxtObjPP.Text.Trim());
                        SC.Parameters.AddWithValue("@Desc", TxtDescPP.Text.Trim());
                        SC.Parameters.AddWithValue("@Usu", Session["C77U"].ToString().Trim());
                        SC.Parameters.AddWithValue("@Id", DdlForm.Text.Trim());
                        try
                        {
                            var Mensj = SC.ExecuteScalar();
                            if (!Mensj.ToString().Trim().Equals(""))
                            {
                                ScriptManager.RegisterClientScriptBlock(this.Page, this.Page.GetType(), "alert", "alert('" + Mensj + "');", true);
                                return;
                            }
                            SC.ExecuteNonQuery();
                            BindData("UPD");
                        }
                        catch (Exception)
                        { ScriptManager.RegisterClientScriptBlock(this.Page, this.Page.GetType(), "alert", "alert('Incovenientes con la creación');", true); }
                    }
                }
            }
        }
示例#2
0
        protected void Page_Load(object sender, EventArgs e)
        {
            if (Session["Login77"] == null)
            {
                if (Cnx.GetProduccion().Trim().Equals("Y"))
                {
                    Response.Redirect("~/FrmAcceso.aspx");
                }
            }
            ViewState["PFileName"] = System.IO.Path.GetFileNameWithoutExtension(Request.PhysicalPath); // Nombre del archivo
            Page.Title             = string.Format("Idioma");
            if (Session["C77U"] == null)
            {
                Session["C77U"] = "";
                if (Cnx.GetProduccion().Trim().Equals("N"))
                {
                    Session["C77U"]     = Cnx.GetUsr(); //00000082|00000133
                    Session["D[BX"]     = Cnx.GetBD();  //|DbNeoDempV2  |DbNeoAda | DbNeoHCT
                    Session["$VR"]      = Cnx.GetSvr();
                    Session["V$U@"]     = Cnx.GetUsSvr();
                    Session["P@$"]      = Cnx.GetPas();
                    Session["N77U"]     = Session["D[BX"];
                    Session["Nit77Cia"] = Cnx.GetNit(); // 811035879-1 TwoGoWo |800019344-4  DbNeoAda | 860064038-4 DbNeoHCT
                    Session["!dC!@"]    = Cnx.GetIdCia();
                    Session["77IDM"]    = Cnx.GetIdm();
                }
            }
            if (!IsPostBack)
            {
                ViewState["PageTit"] = "";
                TitForm.Text         = "Idioma";

                using (SqlConnection sqlCon = new SqlConnection(Cnx.BaseDatosPrmtr()))
                {
                    DataTable DT       = new DataTable();
                    string    VbTxtSql = " EXEC SP_Configuracion 2,'','','','','DDL',0,0,0,0,'01-01-1','02-01-1','03-01-1'";
                    sqlCon.Open();
                    using (SqlCommand SC = new SqlCommand(VbTxtSql, sqlCon))
                    {
                        SqlDataAdapter SDA = new SqlDataAdapter();
                        SDA.SelectCommand = SC;
                        SDA.Fill(DT);
                        DdlForm.DataSource     = DT;
                        DdlForm.DataTextField  = "Nombre";
                        DdlForm.DataValueField = "IdFormulario";
                        DdlForm.DataBind();
                        DdlForm.Text = "0";
                    }
                }
                BindData("UPD");

                if (Session["C77U"].ToString().Trim().Equals("00000082"))
                {
                    TxtIdCia.Visible = true; TxtPassCia.Visible = true; IbtCambioPassCia.Visible = true;
                }
            }
            ScriptManager.RegisterClientScriptBlock(this, GetType(), "none", "<script>myFuncionddl();</script>", false);
        }