예제 #1
0
        public SqlDataAdapter ListarAlmacenes()
        {
            CargaParametroMat();
            RegCatAlmacen OpLst = new RegCatAlmacen(db);

            return(OpLst.ListAlmacenes());
        }
예제 #2
0
        public int ActualizaAlmacen()
        {
            CargaParametroMat();
            RegCatAlmacen OpUp = new RegCatAlmacen(MatParam, db);

            return(OpUp.UpdateAlmacen());
        }
예제 #3
0
        public DataTable CboCatAlmacenes(int OcultaInt)
        {
            RegCatAlmacen OpLst = new RegCatAlmacen(db);
            DataSet       Cbo   = new DataSet();

            OpLst.CboCatAlmacenes(OcultaInt).Fill(Cbo);
            return(Cbo.Tables[0]);
        }
예제 #4
0
        public int EliminaAlmacen()
        {
            //CargaParametroMat();
            MatParam       = new object[1, 2];
            MatParam[0, 0] = "ClaveAlmacen"; MatParam[0, 1] = ClaveAlmacen;
            RegCatAlmacen OpDel = new RegCatAlmacen(MatParam, db);

            return(OpDel.DeleteAlmacen());
        }
예제 #5
0
        public SqlDataAdapter BuscaAlmacen(string buscar)
        {
            /* MatParam = new object[4, 2];
             * MatParam[0, 0] = "CodAlmacen"; MatParam[0, 1] = buscar;
             * MatParam[1, 0] = "Descripcion"; MatParam[1, 1] = buscar;
             * MatParam[2, 0] = "Ubicacion"; MatParam[2, 1] = buscar;
             * MatParam[3, 0] = "Encargado"; MatParam[3, 1] = buscar;
             * RegCatAlmacen OpBsq = new RegCatAlmacen(MatParam);/
             */
            RegCatAlmacen OpBsq = new RegCatAlmacen(db);

            return(OpBsq.BuscaAlmacen(buscar));
        }
예제 #6
0
        public void GetAlmaPorSuc()
        {
            MatParam       = new object[1, 2];
            MatParam[0, 0] = "CveSucursal"; MatParam[0, 1] = ClaveAlmacen;
            RegCatAlmacen OpEdit = new RegCatAlmacen(MatParam, db);

            Datos = OpEdit.RegistroActivoPorSucursal();
            DataSet Ds = new DataSet();

            Datos.Fill(Ds);
            object[] ObjA = Ds.Tables[0].Rows[0].ItemArray;

            ClaveAlmacen = ObjA[0].ToString();
        }
예제 #7
0
        public int AgregarAlmacen()
        {
            int resp = 0;

            CargaParametroMat();
            RegCatAlmacen OpRadd = new RegCatAlmacen(MatParam, db);

            resp = OpRadd.AddRegAlmacen();

            MatParam       = new object[1, 2];
            MatParam[0, 0] = "ClaveAlmacen"; MatParam[0, 1] = ClaveAlmacen;
            RegCatAlmacen OpRaddExis = new RegCatAlmacen(MatParam, db);

            resp = OpRaddExis.AddRegExistencias();

            return(resp);
        }
예제 #8
0
        public void EditarAlmacen()
        {
            MatParam       = new object[1, 2];
            MatParam[0, 0] = "ClaveAlmacen"; MatParam[0, 1] = ClaveAlmacen;
            RegCatAlmacen OpEdit = new RegCatAlmacen(MatParam, db);

            Datos = OpEdit.RegistroActivo();
            DataSet Ds = new DataSet();

            Datos.Fill(Ds);
            object[] ObjA = Ds.Tables[0].Rows[0].ItemArray;

            ClaveAlmacen = ObjA[0].ToString();
            Descripcion  = ObjA[1].ToString();
            Estatus      = ObjA[2].ToString();
            EsDeCompra   = Convert.ToInt32(ObjA[3]);
            EsDeVenta    = Convert.ToInt32(ObjA[4]);
            EsDeConsigna = Convert.ToInt32(ObjA[5]);
            NumRojo      = Convert.ToInt32(ObjA[6]);
            CveLstPrecio = ObjA[7].ToString();
            CveSucursal  = ObjA[8].ToString();
        }