Esempio n. 1
0
        private void buscar_db()
        {
            sqlCommands     sql  = new sqlCommands();
            helperFunctions help = new helperFunctions();

            //Orden de las operaciones al momento de buscar la base de datos. El orden es el siguiente: ID, codSap, catalogo, descripcion
            if (!(string.IsNullOrWhiteSpace(this.txt_ID.Text)))
            {
                this.dg_Buscado.DataSource = null;
                this.dg_Buscado.Rows.Clear();
                clsMaterial material = new clsMaterial();
                if (!help.mensajeAdvInt(this.txt_ID.Text, "el ID del material. Solo se aceptan numeros enteros.").boolean)
                {
                    return;
                }
                ;
                long id = Int64.Parse(this.txt_ID.Text);
                material = sql.buscarID(id);
                this.dg_Buscado.Rows.Add("1", id, material.catalogo, material.codsap, material.descripcion, material.marca, material.familia);
                this.resizeGrid();
                dg_Buscado.Focus();
            }
            else if (!(string.IsNullOrWhiteSpace(this.txt_SAP.Text)))
            {
                this.dg_Buscado.DataSource = null;
                this.dg_Buscado.Rows.Clear();
                clsMaterial material = new clsMaterial();
                if (!help.mensajeAdvInt(this.txt_SAP.Text, "el codigo SAP del material. Solo se aceptan numeros enteros.").boolean)
                {
                    return;
                }
                ;
                long codsap = Int64.Parse(this.txt_SAP.Text);
                material = sql.buscarPorCodigoSAP(codsap);
                this.dg_Buscado.Rows.Add("1", material.id, material.catalogo, material.codsap, material.descripcion, material.marca, material.familia);
                this.resizeGrid();
                dg_Buscado.Focus();
            }
            else if (!(string.IsNullOrWhiteSpace(this.txt_Catalogo.Text)))
            {
                this.dg_Buscado.DataSource = null;
                this.dg_Buscado.Rows.Clear();
                string catalogo = this.txt_Catalogo.Text;
                sql.buscarDB(this.txt_Catalogo.Text, this.dg_Buscado);
                this.resizeGrid();
                dg_Buscado.Focus();
            }
            else
            {
                List <long> marcas   = this.listSelectedMarcas();
                List <long> familias = this.listSelectedFamilias();
                sql.buscarDBFiltrado(this.txt_Descripcion.Text, familias, marcas, this.dg_Buscado);
                this.resizeGrid();
                dg_Buscado.Focus();
            }
        }
Esempio n. 2
0
        private void Dg_Buscado_MouseDoubleClick(object sender, MouseEventArgs e)
        {
            helperFunctions help = new helperFunctions();

            if (!help.isDataGridEmpty(this.dg_Buscado))
            {
                clsMaterial material = new clsMaterial();
                material.id = int.Parse(dg_Buscado.SelectedCells[1].Value.ToString());
                frmVerMaterial frmVer = new frmVerMaterial(material);
                frmVer.ShowDialog();
            }
        }
Esempio n. 3
0
        private void Dg_Resumen_MouseDoubleClick(object sender, MouseEventArgs e)
        {
            //Determina si el DataGridView esta vacio. Si esta vacio no corre las funciones.
            helperFunctions help = new helperFunctions();

            if (!help.isDataGridEmpty(this.dg_Resumen))
            {
                clsMaterial material = new clsMaterial();
                material.id = int.Parse(this.dg_Resumen.SelectedCells[0].Value.ToString());
                frmVerMaterial frmVer = new frmVerMaterial(material);
                frmVer.ShowDialog();
            }
        }
Esempio n. 4
0
        private void FrmVerMaterial_Load(object sender, EventArgs e)
        {
            sqlCommands sql = new sqlCommands();

            clsMaterial                = sql.buscarID(clsMaterial.id);
            this.txt_Id.Text           = clsMaterial.id.ToString();
            this.txt_Familia.Text      = clsMaterial.familia;
            this.txt_Marca.Text        = clsMaterial.marca;
            this.txt_Catalogo.Text     = clsMaterial.catalogo;
            this.txt_Comentarios.Text  = clsMaterial.comentario;
            this.txt_Descripcion.Text  = clsMaterial.descripcion;
            this.txt_SAP.Text          = clsMaterial.codsap.ToString();
            this.txt_specCatalogo.Text = clsMaterial.speccatalogo;
            this.txt_specEnercom.Text  = clsMaterial.specenercom;
            this.txt_specTexto.Text    = clsMaterial.spectexto;
            this.txt_specUl.Text       = clsMaterial.specul;
            this.txt_specVarias.Text   = clsMaterial.specvarias;
        }
Esempio n. 5
0
        /// <summary>
        /// Busca la base de datos por codigo SAP y guarda los datos en una clase que contiene todos los datos
        /// </summary>
        /// <param name="codsap">El codigo sap que esta siendo buscado</param>
        /// <returns></returns>
        public clsMaterial buscarPorCodigoSAP(long codsap)
        {
            clsMaterial material = new clsMaterial();

            material.codsap = codsap;
            using (SqlConnection conn = new SqlConnection())
            {
                conn.ConnectionString = globalVars.connectionString;
                SqlCommand cmd = new SqlCommand("stp_getBySAP", conn);
                cmd.CommandType = System.Data.CommandType.StoredProcedure;
                SqlParameter paramIn = new SqlParameter("@sap", codsap);
                cmd.Parameters.Add(paramIn);
                conn.Open();
                using (SqlDataReader reader = cmd.ExecuteReader())
                {
                    if (reader.HasRows)
                    {
                        while (reader.Read())
                        {
                            material.id           = safeBigInt(reader, "IDmaterial");
                            material.catalogo     = safeString(reader, "catalogo");
                            material.familia      = safeString(reader, "nombreFamilia");
                            material.descripcion  = safeString(reader, "descripcion");
                            material.marca        = safeString(reader, "nombreMarca");
                            material.comentario   = safeString(reader, "comentarios");
                            material.specenercom  = safeString(reader, "specenercom");
                            material.speccatalogo = safeString(reader, "speccatalogo");
                            material.specul       = safeString(reader, "specul");
                            material.spectexto    = safeString(reader, "spectexto");
                            material.specvarias   = safeString(reader, "specvarias");
                        }
                    }
                    return(material);
                }
            }
        }
Esempio n. 6
0
 public frmVerMaterial(clsMaterial _clsMaterial)
 {
     InitializeComponent();
     clsMaterial = _clsMaterial;
 }