Beispiel #1
0
 private void filtrarGrillaCombos()
 {
     CCInventario oCCInventario = new CCInventario();
     CEInventario oCEInventario = new CEInventario();
     oCEInventario.tipo_Inventario = dpdl_inv.SelectedItem.Text.Trim();
     oCEInventario.almacen = dpdl_alm.SelectedItem.Text.Trim();
     DataTable oDT= oCCInventario.getinventarioGriewList(oCEInventario);
     Gdv_inv.DataSource = oDT;
     Gdv_inv.DataBind();
 }
Beispiel #2
0
        public DataTable getGriewList(CEInventario oEntidad)
        {
            String procedure_alm = "sp_inv";
            try
            {
                SqlConnection oSqlConnection = new SqlConnection();
                CDConnection oCDConnection = new CDConnection();
                oSqlConnection = oCDConnection.openDB();
                SqlCommand oSqlCommand = new SqlCommand(procedure_alm, oSqlConnection);
                oSqlCommand.CommandType=CommandType.StoredProcedure;
                oSqlCommand.Parameters.Add("@nom_alm", SqlDbType.Char, 15).Value = oEntidad.almacen;
                oSqlCommand.Parameters.Add("@nom_est", SqlDbType.VarChar, 20).Value = oEntidad.tipo_Inventario;
                SqlDataAdapter oSqlDataAdapter = new SqlDataAdapter(oSqlCommand);
                DataTable oDataTable = new DataTable();
                oSqlDataAdapter.Fill(oDataTable);
                return oDataTable;

            }
            catch (Exception e)
            {
                e.ToString();
                return null;
            }
        }
Beispiel #3
0
 public DataTable getinventarioGriewList(CEInventario oEntidad)
 {
     CDinventario oCDinventario = new CDinventario();
     return oCDinventario.getGriewList(oEntidad);
 }