示例#1
0
        public List <gstClsConcepto> mtdListarConcepto()
        {
            string LstrComando = "select * from gstCONpConcepto";
            List <gstClsConcepto> LobjListaConcepto = new List <gstClsConcepto>();
            gstClsConcepto        LobjConcepto;
            SqlDataAdapter        LobjAdaptador = new SqlDataAdapter(LstrComando, LobjConexion.Conectar());
            DataTable             LobjDataTable = new DataTable();

            LobjAdaptador.Fill(LobjDataTable);
            LobjConexion.Conectar().Close();
            if (LobjDataTable.Rows.Count > 0)
            {
                foreach (DataRow LobjRegistro in LobjDataTable.Rows)
                {
                    LobjConcepto                = new gstClsConcepto();
                    LobjConcepto.CONcodigo      = Convert.ToInt32(LobjRegistro[0]);
                    LobjConcepto.CONdescripcion = LobjRegistro[1].ToString();
                    LobjConcepto.CONmonto       = LobjRegistro[2].ToString();
                    LobjConcepto.CONtipo        = LobjRegistro[3].ToString();


                    LobjListaConcepto.Add(LobjConcepto);
                }
            }

            return(LobjListaConcepto);
        }
示例#2
0
        public int mtdModificar(gstClsConcepto LobjConcepto)
        {
            int LintRespuesta = 0;

            string LstrComando = "update gstCONpConcepto set CONdescripcion = '" + LobjConcepto.CONdescripcion + "', CONmonto = " + LobjConcepto.CONmonto + ", CONtipo = '" + LobjConcepto.CONtipo + "' where CONcodigo = " + LobjConcepto.CONcodigo;

            LobjComando = new SqlCommand(LstrComando, LobjConexion.Conectar());

            LintRespuesta = LobjComando.ExecuteNonQuery();

            LobjConexion.Conectar().Close();
            return(LintRespuesta);
        }
示例#3
0
        public int mtdGuardar(gstClsConcepto LobjConcepto)
        {
            int LintRespuesta = 0;

            string LstrComando = "insert into gstCONpConcepto values('" + LobjConcepto.CONdescripcion + "', " + LobjConcepto.CONmonto + ", '" + LobjConcepto.CONtipo + "')";

            LobjComando = new SqlCommand(LstrComando, LobjConexion.Conectar());

            LintRespuesta = LobjComando.ExecuteNonQuery();

            LobjConexion.Conectar().Close();
            return(LintRespuesta);
        }
示例#4
0
        public gstClsConcepto mtdObtenerConcepto(int LintCodigo)
        {
            gstClsConcepto LobjConcepto = new gstClsConcepto();

            string LstrComando = "select CONcodigo as CÓDIGO, CONdescripcion as DESCRIPCIÓN, CONmonto as MONTO, CONtipo as TIPO from gstCONpConcepto where CONcodigo = " + LintCodigo;

            SqlDataAdapter LobjAdaptador = new SqlDataAdapter(LstrComando, LobjConexion.Conectar());
            DataTable      LobjDataTable = new DataTable();

            LobjAdaptador.Fill(LobjDataTable);

            foreach (DataRow LobjRegistro in LobjDataTable.Rows)
            {
                LobjConcepto.CONcodigo      = Convert.ToInt32(LobjRegistro[0]);
                LobjConcepto.CONdescripcion = LobjRegistro[1].ToString();
                LobjConcepto.CONmonto       = LobjRegistro[2].ToString();
                LobjConcepto.CONtipo        = LobjRegistro[3].ToString();
            }

            LobjConexion.Conectar().Close();
            return(LobjConcepto);
        }