public bool Copiar(string empresaid, tb_plla_rubrospermanente BE)
 {
     //return tablaDA.Update(empresaid, BE);
     bool zreturn = tablaDA.Copiar(empresaid, BE);
     Sql_Error = tablaDA.Sql_Error;
     return zreturn;
 }
 public bool Delete(string empresaid, tb_plla_rubrospermanente BE)
 {
     //return tablaDA.Delete(empresaid, BE);
     bool zreturn = tablaDA.Delete(empresaid, BE);
     Sql_Error = tablaDA.Sql_Error;
     return zreturn;
 }
 public bool Delete(string empresaid, tb_plla_rubrospermanente BE)
 {
     using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid)))
     {
         using (SqlCommand cmd = new SqlCommand("gspTbPllaRubrospermanentes_DELETE", cnx))
         {
             {
                 cmd.CommandType = CommandType.StoredProcedure;
                 cmd.Parameters.Add("@tipoplla", SqlDbType.Char, 1).Value = BE.tipoplla;
                 cmd.Parameters.Add("@tiporubro", SqlDbType.Char, 1).Value = BE.tiporubro;
                 cmd.Parameters.Add("@rubro", SqlDbType.Char, 2).Value = BE.rubro;
             }
             try
             {
                 cnx.Open();
                 if (cmd.ExecuteNonQuery() > 0)
                 {
                     return true;
                 }
                 else
                 {
                     return false;
                 }
             }
             catch (Exception ex)
             {
                 Sql_Error = ex.Message;
                 throw new Exception(ex.Message);
             }
         }
     }
 }
 public DataSet GetMAX_CODIGORUBROPLANILLA(string empresaid, tb_plla_rubrospermanente BE)
 {
     //return tablaDA.GetAll_CONSULTA(empresaid, BE);
     DataSet xreturn = null;
     xreturn = tablaDA.GetMAX_CODIGORUBROPLANILLA(empresaid, BE);
     Sql_Error = tablaDA.Sql_Error;
     return xreturn;
 }
 public DataSet GetAll_IR(string empresaid, tb_plla_rubrospermanente BE)
 {
     //return tablaDA.GetAll_IR(empresaid, BE);
     DataSet xreturn = null;
     xreturn = tablaDA.GetAll_IR(empresaid, BE);
     Sql_Error = tablaDA.Sql_Error;
     return xreturn;
 }
        private void CargaDatos()
        {
            var xtipoplanilla = string.Empty;
            var nestado = 1;
            if (rbestado2.Checked)
            {
                nestado = 2;
            }
            if (rbestado3.Checked)
            {
                nestado = 3;
            }

            if (cmbfiltrotipoplanilla.Enabled)
            {
                if (cmbfiltrotipoplanilla.SelectedValue != null)
                {
                    xtipoplanilla = cmbfiltrotipoplanilla.SelectedValue.ToString();
                }
            }
            var nposcolumnasortear = 0;
            var PrvSotOrder = default(SortOrder);
            var zordenado = false;
            var xcodcliente = "..";
            var xpalabra1 = string.Empty;
            var xpalabra2 = string.Empty;
            var xpalabra3 = string.Empty;
            if (txtfiltronombre.Text.Trim().Length > 0)
            {
                xpalabra1 = VariablesPublicas.Palabras(txtfiltronombre.Text, 1);
                xpalabra2 = VariablesPublicas.Palabras(txtfiltronombre.Text, 2);
                xpalabra3 = VariablesPublicas.Palabras(txtfiltronombre.Text, 3);
            }
            if (Examinar.CurrentRow != null)
            {
                xcodcliente = Examinar.Rows[Examinar.CurrentRow.Index].Cells["rubro"].Value.ToString();
            }
            if (Examinar.SortedColumn != null)
            {
                nposcolumnasortear = Examinar.SortedColumn.Index;
                PrvSotOrder = Examinar.SortOrder;
                zordenado = true;
            }
            var BL = new tb_plla_rubrospermanenteBL();
            var BE = new tb_plla_rubrospermanente();

            BE.tipoplla = xtipoplanilla;
            BE.descriplike1 = xpalabra1;
            BE.descriplike2 = xpalabra2;
            BE.descriplike3 = xpalabra3;
            BE.norden = 0;
            BE.incluir_blanco = 0;
            BE.nestado = nestado;
            tablaclientes = BL.GetAll_CONSULTA(VariablesPublicas.EmpresaID, BE).Tables[0];
            Examinar.AutoGenerateColumns = false;
            Examinar.DataSource = tablaclientes;

            VariablesPublicas.PintaEncabezados(Examinar);

            if (zordenado)
            {
                if (PrvSotOrder == SortOrder.Ascending)
                {
                    Examinar.Sort(Examinar.Columns[nposcolumnasortear], System.ComponentModel.ListSortDirection.Ascending);
                }
                else
                {
                    Examinar.Sort(Examinar.Columns[nposcolumnasortear], System.ComponentModel.ListSortDirection.Descending);
                }
            }
            else
            {
                Examinar.Sort(Examinar.Columns["rubro"], System.ComponentModel.ListSortDirection.Ascending);
            }
            if (Examinar.CurrentRow == null)
            {
                if (Examinar.RowCount > 0)
                {
                    Examinar.CurrentCell = Examinar.Rows[0].Cells["rubro"];
                }
            }
            for (lc_cont = 0; lc_cont <= Examinar.Rows.Count - 1; lc_cont++)
            {
                if (Examinar.Rows[lc_cont].Cells["rubro"].Value.ToString() == xcodcliente)
                {
                    Examinar.CurrentCell = Examinar.Rows[lc_cont].Cells["rubro"];
                    break;
                }
            }
            if (Examinar.RowCount > 0)
            {
                lbltotalregistros.Text = Examinar.RowCount.ToString() + " Registro(s)";
            }
            else
            {
                lbltotalregistros.Text = " NINGUN REGISTRO";
            }
            U_RefrescaControles();
        }
        private void btngrabar_Click(object sender, EventArgs e)
        {
            if (U_Validacion())
            {
                var tmpcursor = new DataTable();
                var BL = new tb_plla_rubrospermanenteBL();
                var BE = new tb_plla_rubrospermanente();

                BE.rubro = txtcodigo.Text.ToString().Trim();
                BE.tipoplla = cmbtipoplanilla.SelectedValue.ToString();
                BE.norden = 1;
                BE.incluir_blanco = 0;
                BE.nestado = 1;
                tmpcursor = BL.GetAll_CONSULTA1(VariablesPublicas.EmpresaID, BE).Tables[0];

                if (u_n_opsel == 1)
                {
                    tmpcursor = BL.GetAll_CONSULTA1(VariablesPublicas.EmpresaID, BE).Tables[0];
                    if (tmpcursor.Rows.Count > 0)
                    {
                        var BLm = new tb_plla_rubrospermanenteBL();
                        var BEm = new tb_plla_rubrospermanente();
                        BEm.tipo = GlobalVars.GetInstance().TipoRubroPlanillaPermanente;
                        BEm.tipoplla = cmbtipoplanilla.SelectedValue.ToString();
                        txtcodigo.Text = BLm.GetMAX_CODIGORUBROPLANILLA(VariablesPublicas.EmpresaID.ToString(), BEm).Tables[0].Rows[0]["maximo_codigo"].ToString();
                    }
                    tmpcursor.Rows.Add(VariablesPublicas.InsertIntoTable(tmpcursor));
                    tmpcursor.Rows[0]["rubro"] = txtcodigo.Text;
                    tmpcursor.Rows[0]["status"] = '0';
                }
                tmpcursor.Rows[0]["tipoplla"] = cmbtipoplanilla.SelectedValue;
                tmpcursor.Rows[0]["tiporubro"] = cmbtipo.SelectedValue;
                tmpcursor.Rows[0]["rubroname"] = txtdescripcion.Text;
                tmpcursor.Rows[0]["modalidad"] = cmbmodalidad.SelectedValue;
                tmpcursor.Rows[0]["visible"] = (chkvisible.Checked ? 1 : 0);
                tmpcursor.Rows[0]["edita"] = (chkeditable.Checked ? 1 : 0);
                tmpcursor.Rows[0]["statusrubro"] = (chkrubro.Checked ? 1 : 0);
                tmpcursor.Rows[0]["status"] = (chkactivo.Checked ? '0' : '9');
                if (cmbrubroingreso.SelectedValue != null)
                {
                    tmpcursor.Rows[0]["codrubro"] = cmbrubroingreso.SelectedValue;
                }
                tmpcursor.AcceptChanges();

                var BLIU = new tb_plla_rubrospermanenteBL();

                if (BLIU.Insert_Update(VariablesPublicas.EmpresaID, tmpcursor))
                {
                    seguridadlog();
                    U_CancelarEdicion(0);
                }
                else
                {
                    Frm_Class.ShowError(BLIU.Sql_Error, this);
                }
            }
        }
        private void btneliminar_Click(object sender, EventArgs e)
        {
            if (Examinar.CurrentRow != null)
            {
                var xnomcampo = string.Empty;
                var BL = new tb_plla_rubrospermanenteBL();
                var BE = new tb_plla_rubrospermanente();

                BE.rubro = Examinar.Rows[Examinar.CurrentRow.Index].Cells["tipoplla"].Value.ToString() + Examinar.Rows[Examinar.CurrentRow.Index].Cells["rubro"].Value.ToString();
                tmpcursor = BL.GetAll_IR(VariablesPublicas.EmpresaID, BE).Tables[0];
                if (BL.Sql_Error.Length > 0)
                {
                    xnomcampo = BL.Sql_Error;
                    Frm_Class.ShowError(BL.Sql_Error, this);
                }
                else
                {
                    if (tmpcursor.Rows.Count == 0)
                    {
                    }
                    else
                    {
                        for (lc_cont = 0; lc_cont <= tmpcursor.Rows.Count - 1; lc_cont++)
                        {
                            xnomcampo = xnomcampo + tmpcursor.Rows[lc_cont]["relacion"] + "\r";
                            if (lc_cont + 1 == 10)
                            {
                                break;
                            }
                        }
                    }
                }
                if (xnomcampo.Length == 0)
                {
                    var BL1 = new tb_plla_rubrospermanenteBL();
                    var BE1 = new tb_plla_rubrospermanente();

                    BE1.rubro = Examinar.Rows[Examinar.CurrentRow.Index].Cells["rubro"].Value.ToString();
                    BE1.tipoplla = Examinar.Rows[Examinar.CurrentRow.Index].Cells["tipoplla"].Value.ToString();
                    BE1.norden = 1;
                    BE1.incluir_blanco = 0;
                    BE1.nestado = 1;
                    tmptabla = BL1.GetAll_CONSULTA(VariablesPublicas.EmpresaID, BE1).Tables[0];
                    if (BL1.Sql_Error.Length == 0)
                    {
                        var message = "Desea eliminar datos del rubro  " + tmptabla.Rows[0]["rubro"].ToString().Trim() + "-" + tmptabla.Rows[0]["rubroname"].ToString().Trim() + " ...?";
                        var caption = "Mensaje del Sistema";
                        var buttons = MessageBoxButtons.YesNo;
                        DialogResult result;
                        result = MessageBox.Show(this, message, caption, buttons, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2);
                        if (result == DialogResult.Yes)
                        {
                            var BLE = new tb_plla_rubrospermanenteBL();

                            BLE.Eliminar(VariablesPublicas.EmpresaID, tmptabla);
                            if (BLE.Sql_Error.Length == 0)
                            {
                                var BLL = new tb_co_seguridadlogBL();
                                var BEL = new tb_co_seguridadlog();

                                BEL.moduloid = Name;
                                BEL.clave = VariablesPublicas.EmpresaID + Examinar.Rows[Examinar.CurrentRow.Index].Cells["tipoplla"].Value.ToString() + Examinar.Rows[Examinar.CurrentRow.Index].Cells["rubro"].Value.ToString();
                                BEL.cuser = VariablesPublicas.Usuar;
                                BEL.fecha = DateTime.Now;
                                BEL.pc = VariablesPublicas.userip;
                                BEL.accion = "B";
                                BEL.detalle = "Rubro: " + txtdescripcion.Text;
                                BLL.Insert(VariablesPublicas.EmpresaID.ToString(), BEL);
                                Examinar.Rows.Remove(Examinar.CurrentRow);
                                Examinar.Refresh();
                                u_PintaDatos();
                            }
                            else
                            {
                                Frm_Class.ShowError(BLE.Sql_Error, this);
                            }
                        }
                    }
                    else
                    {
                        Frm_Class.ShowError(BL1.Sql_Error, this);
                    }
                }
                else
                {
                    MessageBox.Show(xnomcampo, "IMPOSIBLE ELIMINAR REGISTRO");
                }
            }
            U_RefrescaControles();
        }
 public bool Update(string empresaid, tb_plla_rubrospermanente BE)
 {
     using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid)))
     {
         using (SqlCommand cmd = new SqlCommand("gspTbPllaRubrospermanentes_UPDATE", cnx))
         {
             {
                 //cmd.Connection.ConnectionTimeout = 0;
                 cmd.CommandType = CommandType.StoredProcedure;
                 cmd.Parameters.Add("@tipoplla", SqlDbType.Char, 1).Value = BE.tipoplla;
                 cmd.Parameters.Add("@tiporubro", SqlDbType.Char, 1).Value = BE.tiporubro;
                 cmd.Parameters.Add("@rubro", SqlDbType.Char, 2).Value = BE.rubro;
                 cmd.Parameters.Add("@rubroname", SqlDbType.VarChar, 60).Value = BE.rubroname;
                 cmd.Parameters.Add("@modalidad", SqlDbType.Char, 1).Value = BE.modalidad;
                 cmd.Parameters.Add("@visible", SqlDbType.Bit).Value = BE.visible;
                 cmd.Parameters.Add("@edita", SqlDbType.Bit).Value = BE.edita;
                 cmd.Parameters.Add("@codrubro", SqlDbType.Char, 3).Value = BE.codrubro;
                 cmd.Parameters.Add("@statusrubro", SqlDbType.Bit).Value = BE.statusrubro;
                 cmd.Parameters.Add("@status", SqlDbType.Char, 1).Value = BE.status;
             }
             try
             {
                 cnx.Open();
                 if (cmd.ExecuteNonQuery() > 0)
                 {
                     return true;
                 }
                 else
                 {
                     return false;
                 }
             }
             catch (Exception ex)
             {
                 Sql_Error = ex.Message;
                 throw new Exception(ex.Message);
             }
         }
     }
 }
 public bool Insert(string empresaid, tb_plla_rubrospermanente BE)
 {
     using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid)))
     {
         using (SqlCommand cmd = new SqlCommand("gspTbPllaRubrospermanentes_INSERT", cnx))
         {
             cmd.CommandType = CommandType.StoredProcedure;
             cmd.Parameters.Add("@tipoplla", SqlDbType.Char, 1).Value = BE.tipoplla;
             cmd.Parameters.Add("@tiporubro", SqlDbType.Char, 1).Value = BE.tiporubro;
             cmd.Parameters.Add("@rubro", SqlDbType.Char, 2).Value = BE.rubro;
             cmd.Parameters.Add("@rubroname", SqlDbType.VarChar, 60).Value = BE.rubroname;
             cmd.Parameters.Add("@modalidad", SqlDbType.Char, 1).Value = BE.modalidad;
             cmd.Parameters.Add("@visible", SqlDbType.Bit).Value = BE.visible;
             cmd.Parameters.Add("@edita", SqlDbType.Bit).Value = BE.edita;
             cmd.Parameters.Add("@codrubro", SqlDbType.Char, 3).Value = BE.codrubro;
             cmd.Parameters.Add("@statusrubro", SqlDbType.Bit).Value = BE.statusrubro;
             cmd.Parameters.Add("@status", SqlDbType.Char, 1).Value = BE.status;
             //tipoplla [char](1) NOT NULL,
             //tiporubro [char](1) NOT NULL,
             //rubro [char](2) NOT NULL,
             //rubroname [varchar](60) NOT NULL,
             //modalidad [char](1) NOT NULL,
             //visible [bit] NOT NULL,
             //edita [bit] NOT NULL,
             //codrubro [char](3) NOT NULL,
             //statusrubro [bit] NOT NULL,
             //status [char](1) NOT NULL,
             try
             {
                 cnx.Open();
                 if (cmd.ExecuteNonQuery() > 0)
                 {
                     return true;
                 }
                 else
                 {
                     return false;
                 }
             }
             catch (Exception ex)
             {
                 Sql_Error = ex.Message;
                 throw new Exception(ex.Message);
             }
         }
     }
 }
        public DataSet GetOne(string empresaid, tb_plla_rubrospermanente BE)
        {
            using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid)))
            {
                using (SqlCommand cmd = new SqlCommand("gspTbPllaRubrospermanentes_SELECT", cnx))
                {
                    DataSet ds = new DataSet();
                    {
                        cmd.CommandType = CommandType.StoredProcedure;
                        cmd.Parameters.Add("@tipoplla", SqlDbType.Char, 1).Value = BE.tipoplla;
                        cmd.Parameters.Add("@tiporubro", SqlDbType.Char, 3).Value = BE.tiporubro;
                        cmd.Parameters.Add("@rubro", SqlDbType.Char, 3).Value = BE.rubro;
                    }

                    try
                    {
                        cnx.Open();
                        using (SqlDataAdapter da = new SqlDataAdapter(cmd))
                        {
                            da.Fill(ds);
                        }
                        return ds;
                    }
                    catch (Exception ex)
                    {
                        Sql_Error = ex.Message;
                        throw new Exception(ex.Message);
                    }
                }
            }
        }
 public DataSet GetAll_CONSULTA1(string empresaid, tb_plla_rubrospermanente BE)
 {
     using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid)))
     {
         using (SqlCommand cmd = new SqlCommand("gspTbPllaRubrospermanentes_CONSULTA1", cnx))
         {
             DataSet ds = new DataSet();
             {
                 cmd.CommandType = CommandType.StoredProcedure;
                 cmd.Parameters.Add("@rubro", SqlDbType.Char, 2).Value = BE.rubro;
                 cmd.Parameters.Add("@tipoplla", SqlDbType.Char, 1).Value = BE.tipoplla;
                 cmd.Parameters.Add("@descriplike1", SqlDbType.VarChar, 60).Value = BE.descriplike1;
                 cmd.Parameters.Add("@descriplike2", SqlDbType.VarChar, 60).Value = BE.descriplike2;
                 cmd.Parameters.Add("@descriplike3", SqlDbType.VarChar, 60).Value = BE.descriplike3;
                 cmd.Parameters.Add("@norden", SqlDbType.Int).Value = BE.norden;
                 cmd.Parameters.Add("@incluir_blanco", SqlDbType.Int).Value = BE.incluir_blanco;
                 cmd.Parameters.Add("@nestado", SqlDbType.Int).Value = BE.nestado;
             }
             try
             {
                 cnx.Open();
                 using (SqlDataAdapter da = new SqlDataAdapter(cmd))
                 {
                     da.Fill(ds);
                 }
                 return ds;
             }
             catch (Exception ex)
             {
                 Sql_Error = ex.Message;
                 throw new Exception(ex.Message);
             }
         }
     }
 }
 public DataSet GetAll(string empresaid, tb_plla_rubrospermanente BE)
 {
     using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid)))
     {
         using (SqlCommand cmd = new SqlCommand("gspTbPllaRubrospermanentes_SEARCH", cnx))
         {
             DataSet ds = new DataSet();
             {
                 cmd.CommandType = CommandType.StoredProcedure;
                 cmd.Parameters.Add("@tipoplla", SqlDbType.Char, 1).Value = BE.tipoplla;
                 cmd.Parameters.Add("@tiporubro", SqlDbType.Char, 1).Value = BE.tiporubro;
                 cmd.Parameters.Add("@rubro", SqlDbType.Char, 2).Value = BE.rubro;
                 cmd.Parameters.Add("@rubroname", SqlDbType.VarChar, 60).Value = BE.rubroname;
                 cmd.Parameters.Add("@modalidad", SqlDbType.Char, 1).Value = BE.modalidad;
                 //cmd.Parameters.Add("@visible", SqlDbType.Bit).Value = BE.visible;
                 //cmd.Parameters.Add("@edita", SqlDbType.Bit).Value = BE.edita;
                 cmd.Parameters.Add("@codrubro", SqlDbType.Char, 3).Value = BE.codrubro;
                 //cmd.Parameters.Add("@statusrubro", SqlDbType.Bit).Value = BE.statusrubro;
                 cmd.Parameters.Add("@status", SqlDbType.Char, 1).Value = BE.status;
             }
             try
             {
                 cnx.Open();
                 using (SqlDataAdapter da = new SqlDataAdapter(cmd))
                 {
                     da.Fill(ds);
                 }
                 return ds;
             }
             catch (Exception ex)
             {
                 Sql_Error = ex.Message;
                 throw new Exception(ex.Message);
             }
         }
     }
 }